can someone assist me with this question please
Activity 1: Chase Production Strategy X Video Exos Online structured Activity: Chase Production Strategy The ATV Corporation makes the models of altera vehicles. Model A Model B and Model Modd A ses a 0.4 er engine, Model Boes answer crane and Mode uses a 0.6- engine. The aggregate production plan is the twelve-month plan that combines all three modes together in total ironny piction. The planning hotel telve me The Apoceries the site of the workforce, which is the constrained resource. Assume that the beginning inventory for Bory and that the desired money ending inventory 120 units (3 units each of Modiet and Model Band 60 units of Modetc), and the firm desires to have an ending inventory at 160 unts at the end of the war. On average ont un ATV requires echt labor hours to product, and worker contributes 160 hours (8 hoursdays x 4 week) per month. The data has been collected in the Microsoft Excel on below. Use the Microsoft Excel Online bow to develop the chase production strategy and answer the following questions Questions 1. What are the totals of the forecast demand (ancluding inventory adjustment for December), production, hours and workers acted with great production plan? Clint find the number of workers as the sum of workers required during each month.) Round your answers to the nearest whole number Forecast Demand Production Capacity Needed (Units) (Units) Hours Workers Excel gate Scan Horne Draw Page Layout Form Data Review View Help Editing A B SA General $ D Aggregate Production Plan for the ATV Corporation Desmod Monthly Ending ventory Desured End of Year inventory Worker hours needed per unit Work hours per month his X5 days x 4 weeks) Decanter irrory Austment 120 100 6 100 Fomulas WNA Capacity Needed (Labor) Hours Workers 10 Forecast Demand Total Forecast Production Ending Inventory 11 Period Demand (Units (Units) (Unit 13. Jy 140 13 February 120 14 March 200 15 Apr 400 16 000 11 June 740 10 July 000 19 Aug 620 > Senter 0 Od 930 November 300 Dober 120 TOTAS 5160 can Driventory Adunt ding December inoy Aquinont Total Forecast Production Demand (Units)" (Unit) MA UN NA NA INA F WNA WA NIR NA NA ONA INA UNA NA WNA F. ONA ONA F NA MNA NA MA NA WNA ANA MNA F ANA Ending Inventory (unit) WNA NA NA NA PINIA WA NA NA F MA WNIA WA WA Capacity Needed Labor Hours Workers GA NA UNA F WA MUA NA INA WA ANA NA ANA NA ANA NA MA NA MNA NA NA UNI MUA . Usaties below to drawshe chart for the eventory and production under the chase productions Activity 1: Chase Production Strategy X Video Exos Online structured Activity: Chase Production Strategy The ATV Corporation makes the models of altera vehicles. Model A Model B and Model Modd A ses a 0.4 er engine, Model Boes answer crane and Mode uses a 0.6- engine. The aggregate production plan is the twelve-month plan that combines all three modes together in total ironny piction. The planning hotel telve me The Apoceries the site of the workforce, which is the constrained resource. Assume that the beginning inventory for Bory and that the desired money ending inventory 120 units (3 units each of Modiet and Model Band 60 units of Modetc), and the firm desires to have an ending inventory at 160 unts at the end of the war. On average ont un ATV requires echt labor hours to product, and worker contributes 160 hours (8 hoursdays x 4 week) per month. The data has been collected in the Microsoft Excel on below. Use the Microsoft Excel Online bow to develop the chase production strategy and answer the following questions Questions 1. What are the totals of the forecast demand (ancluding inventory adjustment for December), production, hours and workers acted with great production plan? Clint find the number of workers as the sum of workers required during each month.) Round your answers to the nearest whole number Forecast Demand Production Capacity Needed (Units) (Units) Hours Workers Excel gate Scan Horne Draw Page Layout Form Data Review View Help Editing A B SA General $ D Aggregate Production Plan for the ATV Corporation Desmod Monthly Ending ventory Desured End of Year inventory Worker hours needed per unit Work hours per month his X5 days x 4 weeks) Decanter irrory Austment 120 100 6 100 Fomulas WNA Capacity Needed (Labor) Hours Workers 10 Forecast Demand Total Forecast Production Ending Inventory 11 Period Demand (Units (Units) (Unit 13. Jy 140 13 February 120 14 March 200 15 Apr 400 16 000 11 June 740 10 July 000 19 Aug 620 > Senter 0 Od 930 November 300 Dober 120 TOTAS 5160 can Driventory Adunt ding December inoy Aquinont Total Forecast Production Demand (Units)" (Unit) MA UN NA NA INA F WNA WA NIR NA NA ONA INA UNA NA WNA F. ONA ONA F NA MNA NA MA NA WNA ANA MNA F ANA Ending Inventory (unit) WNA NA NA NA PINIA WA NA NA F MA WNIA WA WA Capacity Needed Labor Hours Workers GA NA UNA F WA MUA NA INA WA ANA NA ANA NA ANA NA MA NA MNA NA NA UNI MUA . Usaties below to drawshe chart for the eventory and production under the chase productions
