Question: 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

FC.62 Mitchell's Mills is a startup looking toFC.62 Mitchell's Mills is a startup looking 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 482 in the month of April. The table below contains actual sales data for April and each of the succeeding five months (through September): Month WG1s Sold Forecast 453 482 Apr May 462 Jun 431 Jul 416 Aug 441 Sep 446 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.) 471.85 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.) 441.36 What is the MAD for this forecast (based on six months of forecastsApril through September)? (Display your answer to two decimal places.) Number 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.) 1 % FC.72 Enrollment numbers at BYU-Idaho over the last four years are as follows: 2017 2018 2019 15,968 Semester Winter Spring Fall 15,364 14,077 17,157 14,432 14,193 2020 14,245 13,961 13,166 17,408 15,520 16,643 What is the seasonal index for the winter semester? (Display your answer to two decimal places.) .99 What is the seasonal index for the spring semester? (Display your answer to two decimal places.) .91 What is the seasonal index for the fall semester? (Display your answer to two decimal places.) 1.1 Suppose for the 2021 school year BYU-Idaho is expecting a total of 53,000 students. Based on this projection, how many students should they expect to enroll in the fall semester? (Display your answer to the nearest whole number.) 19500

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!