15. The ABC Consumer Electronics Company has a hard time exactly meeting the sales plan with its new mix of products. In order to be sure to not run out during periods of extra high demand, the management team has decided to raise the inventory target from 5 to 10 days of supply. They currently use a chase production strategy. Their five-day target plan follows. Propose a level build plan that gradually brings the days of supply to the 10-day level over the next three months. Use 30 days per month for all days of supply calculations. Employees can build an average of 1,000 units per workday. Note that July is a short work month due to a two-week vacation shutdown.

Transcribed Image Text:

ABC Sales and Operations Planning Spreadsheet History Plan Future Apr May Jun Jul Aug Sep Oct Sales Plan (in millions $) $22.50 $25.50 $28.50 $31.50 (in million units) 1.50 1.70 1.90 $34.50 $37.50 $37.50 2.10 2.30 2.50 2.5 Actual (in million units) 0.78 1.95 1.63 Diff. month -0.72 0.25 -0.27 Diff. cumulative -0.47 -0.74 Operations Plan (in million units) 1.50 1.70 1.90 2.10 2.31 2.51 (in employees) 75 77 86 210 110 109 Number working days/mo. 20 22 22 10 21 23 223 Actual (in million units) 1.51 1.70 1.88 Diff. month 0.01 0.00 -0.02 Diff. cumulative 0.01 -0.01 Inventory Plan (in units) Actual (in units) 250,000 250,000 250,000 250,001 260,001 267,001 250,001 250,000 250,001 Days of supply 3.81 4.6 3.6 3.3 3.1 3.2