1.)

2.)

A manager is attempting to put together an aggregate plan for the coming nine months. She has obtained a forecast of expected demand for the planning horizon. The plan must deal with highly seasonal demand; demand is relatively high in periods 3 and 4, and again in period 8, as can be seen from the following forecasts. 4 Period Forecast 1 190 2 230 3 260 5 210 6 170 7 160 8 260 9 180 Total 1,940 280 The department now has 20 full-time employees, each of whom produces 10 units of output per period at a cost of $6 per unit. Beginning inventory for period 1 is zero. Inventory carrying cost is $5 per unit per period, and backlog cost is $10 per unit per period. The manager has decided to use part-time workers to assist during seasonal peaks. The cost per unit, including hiring and training, is $11. The output rate is 10 units per worker per period for all workers. A maximum of 10 part-time workers can be used, and the same number of part-time workers must be used in all periods that have part-time workers. The ending inventory in period 9 should be 10 units. The limit on backlogs is 20 units per period. Try to make up backlogs as soon as possible. Compute the total cost for this plan. Assume 20 full-time workers and regular monthly production = regular capacity. Total cost Prepare a schedule for the following situation: The forecast is 80 units for each of the first two periods and 60 units for each of the next three periods. The starting inventory is 20 units. The company uses a chase strategy for determining the production lot size, except there is an upper limit on the lot size of 70 units. Also, the desired safety stock is 10 units. Note: The ATP quantities are based on maximum allowable production and do not include safety stock. Committed orders are as follows: (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required.) Period 1 2 3 4 5 Customer Orders 82 80 60 40 20 min Click here for the Excel Data File 2 3 5 80 80 60 60 60 82 80 60 40 20 Period Forecast Customer Orders Projected On-Hand MPS ATP