Mail - Ashu Monga - Outlook - Google Chrome 0 X about:blank Excel Activity Day 3 Part A -Ag Planning.xIsx Open in Excel Desktop app v Download Save to OneDrive Show email File Home Insert Draw Page Layout Formulas Data Review View Automate Help Tell me what you want to do Comments Viewing V 12 B Ev ab Merge General v . . . R3 V X V f A B D E G H K L M N O P Q R S T U Aggregate Planning Exercise - Day 3 A manufacturer of boat engines forecasted their requirements for a family of engines for the coming year and included some of the information in the charts below 4 5 1. Using a level strategy calculate the monthly inventory values in the chart below. They have 500 units to start and they want to end with about the same Starting Month values 2 3 4 5 6 8 9 10 11 12 Total Demand 1000 1100 1200 1300 1350 1350 1300 1200 1100 1100 1050 990 14040 Production 9 nventory 10 11 2. If inventory cost 2$/unit per month what would the total costs be with this level strategy 12 Starting 13 Month values 3 5 6 8 10 11 12 14 Demand 1000 1100 1200 1300 1350 1350 1300 1200 1100 110 1050 990 14040 15 Production 16 Inventory 17 nventory cos 18 19 20 3. They have 15 workers, each worker can produce 50 units. What are the total hiring costs if each worker costs $600 to hire using the same strategy Starting 21 Month values 2 3 5 6 8 9 10 11 12 22 Demand 1000 1100 1200 1300 1350 1350 1300 1200 1100 110 1050 990 14040 Sheet1 + Workbook Statistics Give Feedback to Microsoft - 100% + 11 C X A Co & ENG 8:04 PM Partly sunny US 2022-09-28Mail - Ashu Monga - Outlook - Google Chrome 0 X about:blank Excel Activity Day 3 Part A -Ag Planning.xIsx Open in Excel Desktop app Download Show email File Home Insert Draw Page Layout Formulas Data Review View Automate Help Tell me what you want to do Comments Viewing V 12 B Av ... E ab Merge General v . . . A2 v X v fx A manufacturer of boat engines forecasted their requirements for a family of engines for the coming year and included some of the information in the charts below A B D F H K M N O P Q R S T U 20 3. They have 15 workers, each worker can produce 50 units. What are the total hiring costs if each worker costs $600 to hire using the same strategy Starting 21 Month values 3 8 10 11 12 22 Demand 1000 1100 1200 1300 1350 1350 1300 1200 1100 1100 1050 990 14040 23 Production 24 Inventory 25 Inventory 26 Number of workers 27 New workers needed 28 Hiring costs 29 30 31 4. Use the chart below to illustrate a chase plan, They have 500 units to start and they want to end with about the same, Layoff costs are $600/worker Starting 32 Month values 2 3 5 6 8 10 11 12 33 Demand 1000 1100 1200 1300 1350 1350 1300 1200 1100 1100 1050 990 14040 34 Production 35 Inventory 36 Inventory cost 37 Number of workers New workers needed 38 or layed off 39 Hiring and layoff costs 40 41 5.Analyze the 2 plans. What plan is better and why? 42 E Sheet1 + Workbook Statistics Give Feedback to Microsoft - 100% + 11 C 8:11 PM Partly sunny A Co & ENG US 2022-09-28