Forecasting and Economic Order Quantity problems

Problem Set 4

Instructions
Solve problems 5-12, 5-14, and 5-18. Save your responses in a Word file.

5-12:
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 section on moving averages in Table 5.3.

see attached for data

5-14:
Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. Develop a three-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 two years are each given a weight of 1. Which method do you think is best?

Year Scale Fertilizer Demand
1 4
2 6
3 4
4 5
5 10
6 8
7 7
8 9
9 12
10 14
11 15

5-18:
Sales of Cool-Man air conditioners have grown steadily during the past five years:

Year Sales
1 450
2 495
3 518
4 563
5 584
6 ?

The sales manager had predicted, before the business started, that year 1's sales would be 410 air conditioners. Using exponential smoothing with a weight of 􏰅 = 0.30, develop forecasts for years 2 through 6

Problem Set 5

6-18:
Lila Battle has determined that the annual demand for number 6 screws is 100,000 screws. Lila, who works in her brother's hardware store, is in charge of purchasing. She estimates that it costs $10 every time an order is placed. This cost includes her wages, the cost of the forms used in placing the order, and so on. Furthermore, she estimates that the cost of carrying one screw in inventory for a year is one-half of 1 cent. Assume that the demand is constant throughout the year.
(a) How many number 6 screws should Lila order at a time if she wishes to minimize total inventory cost? (b) How many orders per year would be placed?
What would the annual ordering cost be? (c) What would the average inventory be? What
would the annual holding cost be?