Need help solving problem number 2

Cinnamon Buns Cupcakes Day Blueberry Muffins 31 37 34 27 24 a. Predict orders for the following day for each of the products using an appropriate naive method. Hint: Plot each data set. b. What should the use of sales data instead of demand imply? 2. National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales (000 units) Feb. Mar. Apr. May Jun. Jul. Aug. a. Plot the monthly data on a sheet of graph paper. b. Forecast September sales volume using each of the following: (1) The naive approach (2) A five month moving average (3) A weighted average using .60 for August, 30 for July, and. 10 for June (4) Exponential smoothing with a smoothing constant equal to.20, assuming a a March forecast of 19(000) (5) A lincar trend equation c. Which method seems least appropriate? Why? (Hint: Refer to your plot from part a.) d. What does use of the term sales rather than demand presume? 3. A dry cleaner uses exponential smoothing to forecast equipment usage at its main plant. August usage was forecasted to be 88 percent of capacity: actual usage was 89.6 percent of capacity. A smoothing constant of .1 is used. a. Prepare a forecast for September. b. Assuming actual September usage of 92 percent, prepare a forecast for October usage. 4. An electrical contractor's records during the last five weeks indicate the number of job requests: Week 1 2 3 4 5 Requests 20 Predict the number of requests for week 6 using each of these methods: a. Naive b. A four-period moving average c. Exponential smoothing with a = .30; use 20 for week 2 forecast 5. A cosmetics manufacturer's marketing department has developed a linear trend equation that can be used to predict annual sales of its popular Hand & Foot Cream. F, = 80 + 151 where Fl=Annual sales (000 bottles) 1 is in years a. Are annual sales increasing or decreasing? By how much? b. Predict annual sales for year 6 using the equation. 18