opontos B C D E F G H Demand for Quantum Corporation's action toy series follows a seasonal pattern-growing through the fall months and culminating in December rith smaller peaks in January (for after- season markdowns, exchanges, and accessory purchases) and July (for Christmas-in-July specials). Demand (cases) Month January February March April May June Demand (cases) 1000 400 400 400 400 400 Month July August September October November December 500 500 1000 1500 2500 3000 Each worker can produce on average 100 cases of action toys each month. Overtime is limited to 300 cases, and subcontracting is unlimited. No action toys are currently in inven- tory. The wage rate is $10 per case for regular production, $15 for overtime production, and $25 for subcontracting. No stockouts are allowed. Holding cost is $1 per case per month. In- creasing the workforce costs approximately $1000 per worker; decreasing the workforce costs $500 per worker. Management wishes to test the following scenarios for planning production: a. Level production over the 12 months. b. Produce to meet demand each month. c. Solve the problem with linear programming (LP) using Excel Solver. O opontos B C D E F G H Demand for Quantum Corporation's action toy series follows a seasonal pattern-growing through the fall months and culminating in December rith smaller peaks in January (for after- season markdowns, exchanges, and accessory purchases) and July (for Christmas-in-July specials). Demand (cases) Month January February March April May June Demand (cases) 1000 400 400 400 400 400 Month July August September October November December 500 500 1000 1500 2500 3000 Each worker can produce on average 100 cases of action toys each month. Overtime is limited to 300 cases, and subcontracting is unlimited. No action toys are currently in inven- tory. The wage rate is $10 per case for regular production, $15 for overtime production, and $25 for subcontracting. No stockouts are allowed. Holding cost is $1 per case per month. In- creasing the workforce costs approximately $1000 per worker; decreasing the workforce costs $500 per worker. Management wishes to test the following scenarios for planning production: a. Level production over the 12 months. b. Produce to meet demand each month. c. Solve the problem with linear programming (LP) using Excel Solver. O