Required: Prepare an aggregate production plan for the company that will minimize monthly ending inventory as well as the overtime hours. Continue working on the spreadsheet attached and include the additional columns for the following: a) Monthly hours required to produce the forecasted demand, including the additional inventory in December. b) Monthly overtime (in hours) and the total overtime hours that company need to incur to meet the demand. Please indicate in the table how many workers will render overtime for the month and how many hours each. c) Monthly production schedule (regular time + overtime) d) Monthly ending inventory (taking into consideration the overtime hours rendered), with EI for December = 140 units. Note: You can use excel to work on the problem, but manual computation will also do. In both cases, indicate the formula that you will have used.

INSTRUCTIONS: PREPARE AN AGGREGATE PRODUCTION PLAN FOR ATV CORPORATION USING MIXED PRODUCTION STRATEGY. 1 Given: ATV Corporation's Aggregate Production Plan Forecast No. of Period Demand Workers January 120 February 100 March 300 April 460 May 600 June 700 July 760 August 640 September October 400 November 200 December 140 140 10 580 10 Additional Given/Limitations: a) Number of workers indicated above is what the company planned to maintain for every month of the year. b) Process time for1 ATV = 8 hours c) Available hours per worker per month = 8 hrs/day X 5 days/wk X 4 weeks/month = 160 hours per worker per month d) Beginning inventory (January) = 100 units e) Desired ending inventory (December) = 140 units (this is not yet included on the forecast demand above) f) Additional labor hours can only be through overtime, during the month when there is a shortage in capacity ONLY. Weekdays = 2 hrs per worker per day (maximum) Weekends = 10 hrs per worker during Saturdays only g) Stockouts not allowed, which means, there should be no negative inventory, with the assumption that customers will cancel orders once not delivered on the month committed