NowJuice, Inc. produces bottled pickle juice. A planner has developed an aggregate forecast for demand (in cases) for the next four months. Use the following information to develop an aggregate plan using the LEVEL strategy. Inventory holding cost is $1 per month per case and backlog cost is $5 per month per case. Beginning inventory is zero. Month May June July August Forecast 452 520 600 719   Cost Per Unit Monthly Capacity Regular Production 19.40 400 Overtime Production 1.5 x Regular Prod Cost 400 What is the TOTAL cost of the LEVEL plan over the planning horizon

Given an actual demand this period of 100, a forecast value for this period of 130, and an alpha of 0.6, what is the exponential smoothing forecast for next period? (Round answer to the nearest whole number.) O A. 100 OB. 130 C. 82 O D. O E. 112 118

Wal Mart, although they are not a manufacturing company, uses sophisticated computer software to forecast sales and order products to be stocked in their stores so that they do not run out of the things shoppers are looking for. What kind of software system does Wal Mart likely use? Group of answer choices a) Inventory control b) Just-in-time ordering c) E-procurement d) Materials Requirement Planning (MRP)

12

Exercise Torecast CIT ▷ Complete the table Month 1 2 3 4 5 6 Forecast demand 700 760 780 790 850 950 Actual demand 660 840 750 835 910 890 ▷ What is MAD? MAPE? TS? Deviation RSFE (Cumulative sum of forecast errors) MAD (Mean absolute deviation) APE (absolute % error) +

CASE EIGHT GLASSES A DAY (EGAD) The EGAD Bottling Company has decided to introduce a new line of premium bottled water that will include several "designer" flavors. Marketing manager Georgianna Mercer is predicting an upturn in demand based on the new offerings and the increased public awareness of the health benefits of drinking more water. She has prepared aggregate forecasts for the next six months, as shown in the following table (quantities are in tankloads). Month May Jun Jul Aug Sep Oct Total Forecast 50 60 70 90 80 70 420 Production manager Mark Mercer (no relation to Georgianna) has developed the following information. (Costs are in thousands of dollars.) Regular production cost $1 per tankload 60 tankloads Regular production capacity Overtime production cost Subcontracting cost Holding cost Backordering cost Beginning inventory Question $1.6 per tankload $1.8 per tankload $2 per tankload per month Backlogs are not allowed 0 tankloads Among the strategies being considered are…

Southeast Soda Pop, Inc., has a new fruit drink for which it has high hopes. John Mittenthal, the production planner, has assembled the following cost data and demand forecast: Click the icon to view the demand forecast. E Click the icon to view the cost data. John's job is to develop an aggregate plan. The three initial options he wants to evaluate are: • Plan A: a strategy that hires and fires personnel as necessary to meet the forecast. • Plan B: a level strategy. • Plan C: a level strategy that produces 1,000 cases per quarter and meets the forecast demand with inventory and subcontracting. a) Which strategy is the lowest-cost plan? Try hiring and layoffs (to meet the forecast) as necessary (enter your responses as whole numbers). Hiring and Layoff Plan Layoff (Units) Hire Quarter Forecast Production Inits) 1,300 1 1,700 Costs/Other Data Previous quarter's output = 1,300 cases Beginning inventory = 0 cases Stockout cost of backorders = $140 per case Inventory holding cost = $45 per…

The table above provides the aggregate plan of production by a firm. It is known that the firm uses a level plan with backorders. Given this information, what is the number in the cell with the question mark?

2) A manager has prepared a forecast of expected aggregate demand. Develop an aggregate plan that assumes: A level production rate, back orders are allowed and are charged at the rate of $15 per unit per month, inventory holding costs are $2 per unit per month in average inventory, regular time cost is $7 per unit and beginning inventory is zero. Show the aggregate plan and determine the cost of this plan. (use excel to show formulas for your calculations) Month Forecast 270 2 310 280 4 350 310 280

State which forecast is best on the result for a., b., and c. forecasts. Explain your answer.