Question: Solve all please will upvote Excei Onilie Structured Activily: Levei Production Strategy The ATV Corporation makes three models of all-terrain vehideit Model A, Model B,

Excei Onilie Structured Activily: Levei Production Strategy The ATV Corporation makes three models of all-terrain vehideit Model A, Model B, and Model C. Modet A uses a 0.4 iter enginh, Model B uset a o.s-liter engine, and Modet C uses a 0.6- liter engine. The aggregate procuction plan is the twelve.month plan that combines all three models together in tatal meothly production. The planning borixin is tweive monts. The APP determines the size of the wekferce, which is the constraned retource. Astume that the bepinning inventery far janiaary is 160 unis (30 unita each of Mode: A and Midel B, and 100 units of Model c). The firm desines to have an ending inventery of 200 units at the end of the year On average, coe unit of ArV requires eight labor heurs to produce, and a worker contributes 160 hours (s heurs 5 days 4 weeks) per momeh. The data has been collected in the Mierosof Excel Online file below. Use the Microsan Excel Onine file belaw to develop the ievel prodoction strategy and answer the foliowing questions. Dpen spreadsheet Questions 1. What are the totals of the forecost demsnd (induding inventory adjustment for December). production, hours and woekers associted with aggregate production plan? (itint: fad the total mumber of wotkers as the sum of workers teguired during each month.) Round your anwwers to the nearest whole numbet. 1 Level Production Strategy Aggregate Production Plan for the ATV Corporation
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
