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-28