Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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 494 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
Apr 460 494
May 387
Jun 470
Jul 405
Aug 425
Sep 422

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.)

482.10 (Correct answer) 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.)

What is the MAD for this forecast (based on six months of forecastsApril through September)? (Display your answer to two decimal places.)

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.) %

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 494 in the month of April. The table below contains actual sales data for April and each of the succeeding five months (through September): 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.) 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.) What is the MAD for this forecast (based on six months of forecasts-April through September)? (Display your answer to two decimal places.) What is the MAPE for this forecast (based on six months of forecasts-April through September)? (Write your answer as a percentage, and display your answer to two decimal places.) 95

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Management

Authors: Richard L Daft, Dorothy Marcic

6th Edition

9780324581782, 324581785, 978-0324568387

More Books

Students also viewed these General Management questions

Question

Describe the economic activity of production.

Answered: 1 week ago