Question: please solve answer in handwritten method.not in excell form. Q3. Sunrise Baking Company markets doughnuts through a chain of food stores. It has been experiencing

please solve answer in handwritten method.not in

please solve answer in handwritten method.not in excell form.

Q3. Sunrise Baking Company markets doughnuts through a chain of food stores. It has been experiencing overproduction and underproduction because of forecasting errors. The following data are its demand in dozens of doughnuts for the past four weeks. Doughnuts are made for the following day, for example, Sunday's doughnut production is for Monday's sales, Monday's production is for Tuesday's sales, and so forth. The bakery is closed Saturday, so Friday's production must satisfy demand for both Saturday and Sunday. 4 WEEKS AGO 3 WEEKS AGO 2 WEEKS AGO LAST WEEK Monday 2.200 2,400 2,300 2.400 Tuesday 2.000 2.100 2.200 2.200 Wednesday 2.300 2,400 2.300 2.500 Thursday 1,800 1,900 1.800 2.000 Friday 1,900 1,800 2.100 2,000 Saturday (closed on Saturday) Sunday 2,800 2,700 3,000 2.900 Page 76 Make a forecast for this week on the following basis: a. Daily, using a simple four-week moving average. b. Daily, using a weighted moving average with weights of 0.40, 0.30, 0.20, and 0.10 (most recent to oldest week)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!