5-13
Develop a four-month moving average forecast for Wallace Garden Supply and compute the MAD. 185186A three-month moving average forecast was developed in the section on moving averages in Table 5.3.
Question 1 of 11 10.0 Points
 
The four-month moving average forecast for Wallace Garden Supply is _13__________. (Please round it to an integer and include no units.)

 A.17

 B.18

 C.19

 D.20

Question 2 of 11 

The Mean Absolute Deviation (MAD) for the above forecast is  . (Please round it to two decimal points.)  9.03
 5-15
Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. 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. Which method do you thins best?
 
Question 3 of 11 10.0 Points

The three-year moving average forecast for Wallace Garden Supply is  . (Please round it to two decimal points and include no units.)
Question 4 of 11 10.0 Points

The Mean Absolute Deviation (MAD) for the above moving average forecast is  . (Please round it to two decimal points.)
 Mark for Review What's This?

Question 5 of 11 10.0 Points

The three-year weighted moving average forecast for Wallace Garden Supply is  . (Please round it to an integer and include no units.)
 Mark for Review What's This?

Question 6 of 11 10.0 Points

The Mean Absolute Deviation (MAD) for the above weighted moving average forecast is  . (Please round it to two decimal points.)

Question 7 of 11 5.0 Points
Based on your previous calculation, which method do you think is the best?

 A.3-year moving average.

 B.3-year weighted moving average.

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.
 
Question 8 of 11 10.0 Points
The starting /initial forecast for the sales of Cool-Man air conditioners is _________. (Please round it to an integer and include no units.)

 A.400

 B.410

 C.430

 D.450
Reset Selection

 Mark for Review What's This?

Question 9 of 11 5.0 Points

The Year 2 forecast for the sales of Cool-Man air conditioners is   (Please round it to an integer and include no units.)
Question 10 of 11 10.0 Points

The Year 6 forecast for the sales of Cool-Man air conditioners is  . (Please round it to two decimal points and include no units.)
 Mark for Review What's This?

Question 11 of 11 10.0 Points

The Mean Absolute Deviation (MAD) for the above exponential smoothing forecast is  . (Please round it to two decimal points.)

 

 

    • 12 years ago
    PROBLEM SET 4 TEST QUESTIONS SOLUTION
    NOT RATED

    Purchase the answer to view it

    • problem_set_4_test_questions_solution_worksheet.xlsx
    • problem_set_4_test_questions_solution.docx