“Problem Set 4” for BUSN603 D003 Win 15
Please review the Moving Averages and the Exponential Smoothing forecasting methods introduced in Section 5.5 in the textbook before taking this quiz. You may find it very helpful to go through the examples presented in Program 5.1A to 5.1C and Program 5.2 in the textbook as well as in the Week 4 PowerPoint Slides (5-26 to 5-40).
You may take this quiz as many times as you wish and only your highest score will be recorded for grading. These problem sets are designed for you to grasp the course material and achieve the course objective. Hence, as long as you work diligently, you may expect to receive 100% on this problem set.
However, your resubmission has to be made before the due date. After the due date, you will NOT be able to resubmit and for those who have not submitted by the due date, you will be given only one chance to submit and your submission will be tagged as late.
| This assessment is due Sunday, 2015-Mar-29 11:55 PM. |
Develop a four-month moving average forecast for Wallace Garden Supply and compute the MAD. A three-month moving average forecast was developed in the table attached.
|
| Part 2 of 3 – Part 2 |
Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the table attached. Develop a 3-year moving average to forecast sales. Then estimate demand again with a weighted moving average in which sales in the most recent year are given a weight of 2 and sales in the other 2 years are each given a weight of 1.
The three-year moving average forecast for Wallace Garden Supply is What’s This?
|
||
The Mean Absolute Deviation (MAD) for the above moving average forecast is What’s This?
|
||
The three-year weighted moving average forecast for Wallace Garden Supply is What’s This?
|
||
The Mean Absolute Deviation (MAD) for the above weighted moving average forecast is What’s This?
|
||
|
| Part 3 of 3 – Part 3 |
Sales of Cool-Man air conditioners have grown steadily during the past 5 years as shown in the attached table. The sales manager had predicted, before the business started, that year 1’s sales would be 410 air conditioners. Please use exponential smoothing with a weight of to answer the following questions.
The starting /initial forecast for the sales of Cool-Man air conditioners is _________. (Please round it to an integer and include no units.)
|
||||||||||
The Year 2 forecast for the sales of Cool-Man air conditioners is What’s This?
|
||||||||||
The Year 6 forecast for the sales of Cool-Man air conditioners is What’s This?
|
||||||||||
The Mean Absolute Deviation (MAD) for the above exponential smoothing forecast is [removed] . (Please round it to two decimal points.)
|
"96% of our customers have reported a 90% and above score. You might want to place an order with us."
