BUS446 week 1 assignment

Get Your Custom Essay Written From Scratch
We have worked on a similar problem. If you need help click order now button and submit your assignment instructions.
Just from $9/Page
Order Now

Using the appropriate tools (e.g., formulas, Excel, etc.), answer the three questions below. Show all work. Calculations and answers to questions can be on the same document. APA formatting is not required.

A pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales during the last 15 days were:

Day

Number Sold

1

36

2

38

3

42

4

44

5

48

6

49

7

50

8

49

9

52

10

48

11

52

12

55

13

54

14

56

15

57

  • Justify your selection of either a linear trend equation or trend-adjusted exponential smoothing to predict future sales.
  • If you learn that on some days the store ran out of the specific pain reliever, would that knowledge cause you any concern? Explain.
  • Assume that the data refer to demand rather than sales. Using trend-adjusted smoothing with an initial forecast of 50 for day 8, an initial trend estimate of 2, and α = β = .3, develop forecasts for days 9 through 16. What is the Mean Squared Error (MSE) for the eight forecasts for which there are actual data?
Do you need a similar assignment done for you from scratch? We have qualified writers to help you
Use our paper writing service to score better and meet your deadlines.
Order Now