Question: Please answer all and show work on Excel to understang more easily. Thank you! Like this--> FC.62 Mitchell's Mills is a startup looking to break

Please answer all and show work on Excel to

Please answer all and show work on Excel to understang more easily. Thank you!

Like this-->

Please answer all and show work on Excel to

FC.62 Mitchell's Mills is a startup looking to break into the preparedness market with a revolutionary new wheat grinder called the WG1. Since Mitchell's is a new company they do not have any historical data for sales of its flagship product, but they estimate they will be able to sell 458 in the month of April. The table below contains actual sales data for April and each of the succeeding five months (through September): WG1s Sold 434 Forecast 458 Month Apr May Jun 383 375 Jul 446 387 Aug Sep 444 Suppose it was the beginning of May and you were asked to develop a forecast for the month of May. Your only actual sales data was for the month of April. Because of this paucity of data you decide to use the exponential smoothing method for the construction of your forecasting model. You determine that an alpha value of 0.35 would be appropriate. Based on the above information, what would have been your forecast for the month of May? (Display your answer to two decimal places.) 525.95 If you follow this same forecasting process through all the months, continuing with June and going through September, what would be the forecast in the month of September? (Display your answer to two decimal places.) 495 What is the MAD for this forecast (based on six months of forecasts-April through September)? (Display your answer to two decimal places.) Nmero What is the MAPE for this forecast (based on six months of forecastsApril through September)? (Write your answer as a percentage, and display your answer to two decimal places.) Normal Time Crashed T Normal Cost Crashed Cost Predecessors Max p. cash time Activity A 6 800 =C5-D5 Paths Duration =C6+C10 B =C6-06 B-F C 5 A-D in min M M N 300 500 950 1350 1000 400 625 1150 2250 925 Cost/day = (F5-E5)/H5 = (F6-E6)/H6 =(F7-E7)/H7 =(F8-E8)/H8 =(F9-E9)/H9 = (F10-E10)/H10 =C5+C8 =C7+C9 A C-E =C7-D7 =C8-D8 =C9-09 =C10-D10 D E 3 B F 2 2. 825

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!