The ATV Corporation makes three models of all-terrain vehicles: Model A, Model B, and Model C. Model A uses a 0.4-liter engine, Model B uses a 0.5-liter engine, and Model C uses a 0.6- liter engine. The aggregate production plan is the twelve-month plan that combines all three models together in total monthly production. The planning horizon is twelve months. The APP determines the size of the workforce, which is the constrained resource. Assume that the beginning inventory for January and that the desired monthly ending inventory is 100 units (30 units each of Model A and Model B, and 40 units of Model C), and the firm desires to have an ending inventory of 160 units at the end of the year. On average, one unit of ATV requires eight labor hours to produce, and a worker contributes 160 hours (8 hours x 5 days x 4 weeks) per month. The data has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develop the chase production strategy and answer the following questions. 1 Chase Production Strategy 2 3 4 Aggregate Production Plan for the ATV Corporation Desired Monthly Ending Inventory 5 6 7 8 Desired End of Year Inventory 100 160 Worker hours needed per unit 8 160 Worker hours per month (8 hrs x 5 days x 4 weeks) December Inventory Adjustment 9 10 Capacity Needed (Labor) Forecast Demand Total Forecast 11 Period (Units)* Demand (Units) Production (Units) Ending Inventory (Units) Hours Workers 12 January 13 February 14 March 15 April 16 May 17 June 100 80 340 480 620 720 18 July 780 19 August 660 20 September 520 21 October 440 22 November 220 23 December 100 24 TOTALS 5,060 25 excluding December Inventory Adjustment 26 including December Inventory Adjustment 27 28 Use the area below to draw a line chart for the inventory and production under the chase production strateg