ft Excel Activity #2: Aggregate Planning - Chase Production Open spreadsheet Questions 1. What is the average monthly demand? Round your answer to two decimal places barrels 2. What is the maximum monthly ending inventory? Round your answer to the nearest whole number 0 barrets 3. What are the costs associated with chose demand production plan? Round your answers to the nearest cent. Production Cost Inventory Cost 0 Month Totals 5 Lost Sales Cost ogs Overtime Cost Undertime Cost Rate Change Cost $ $ 4. What is the total cost? Round your answer to the nearest cent. Check My Work Reset Problem shouthione template We D Qij D Agewing Cha Demand Pool 371.00 yang $130 LOGO to 00 Owen VM change Home) 500 2.100 1 NAD Cumuwe Cumulative Product Ending Derrand Production Avfyrventory LO c Month Derrand Demand 1400 1000 100 19 15 10 17 VINE 1000 RY March Apr My Month wy F M Apr May June wit 2500 PUA 2.000 ANA 12 3.000 2500 2600 2.000 2100 2.500 July August 2100 2.800 ker TE NA NA Vih NA INA Sheet CM Not GELDAB template Saved Formulas Data insert Review View Help Tell me what you want to do 10 10 Arial Number 25 X LA B I U ab Insert Delete Format MTU $ -% 928 Condibunal Format Formatting Styles AA A board font Alignment Number Table 11 D E B G F H WOW Month January February March April May June July August September October November December Average Cumulative Cumulative Product Ending Lost Demand Demand Production Availability Inventory Sales 1,400 1.000 1,800 2,500 2,600 3,000 3,100 2,800 1.500 400 1,300 1500 Maximum Production Inventory Lost Sales Overtime Undertime Rate Change Cont Cost Cost Cost Cost Cost Month January February March April May June July August September October November December Average Demand 1,400 1,000 1,800 2,500 2,600 3,000 3,100 2,800 1,600 400 1,300 1.600 AN/A Month January Month January Production Cost #N/A AN Sheet - C about blank Excel template Saved Home Insert Formulas Data Review View Help Tell me what you want to do X Arial 10 Number B 1 U Paste Insert Delete Conditional Format Formatia Table Styles -A A $ - % 848 42 Cud Alignment Number Tables Curtis D E F G H Production Cost Inventory Lost Sales Cost Cost Overtime Undertime Rate Change Cost Cost Cost Produc 3 3 6 17 Month January February March April May June July August September October November December Totals Month January February March April May June July August September October November December Totals ANJA #NIA #N/A #N/A #N/A #N/A #N/A #N/A N/A #N/A WNIA WNIA 39 40 41 42 40 45 Total cost Total cost #N/A B Sheet + Con de toute Workbook ft Excel Activity #2: Aggregate Planning - Chase Production Open spreadsheet Questions 1. What is the average monthly demand? Round your answer to two decimal places barrels 2. What is the maximum monthly ending inventory? Round your answer to the nearest whole number 0 barrets 3. What are the costs associated with chose demand production plan? Round your answers to the nearest cent. Production Cost Inventory Cost 0 Month Totals 5 Lost Sales Cost ogs Overtime Cost Undertime Cost Rate Change Cost $ $ 4. What is the total cost? Round your answer to the nearest cent. Check My Work Reset Problem shouthione template We D Qij D Agewing Cha Demand Pool 371.00 yang $130 LOGO to 00 Owen VM change Home) 500 2.100 1 NAD Cumuwe Cumulative Product Ending Derrand Production Avfyrventory LO c Month Derrand Demand 1400 1000 100 19 15 10 17 VINE 1000 RY March Apr My Month wy F M Apr May June wit 2500 PUA 2.000 ANA 12 3.000 2500 2600 2.000 2100 2.500 July August 2100 2.800 ker TE NA NA Vih NA INA Sheet CM Not GELDAB template Saved Formulas Data insert Review View Help Tell me what you want to do 10 10 Arial Number 25 X LA B I U ab Insert Delete Format MTU $ -% 928 Condibunal Format Formatting Styles AA A board font Alignment Number Table 11 D E B G F H WOW Month January February March April May June July August September October November December Average Cumulative Cumulative Product Ending Lost Demand Demand Production Availability Inventory Sales 1,400 1.000 1,800 2,500 2,600 3,000 3,100 2,800 1.500 400 1,300 1500 Maximum Production Inventory Lost Sales Overtime Undertime Rate Change Cont Cost Cost Cost Cost Cost Month January February March April May June July August September October November December Average Demand 1,400 1,000 1,800 2,500 2,600 3,000 3,100 2,800 1,600 400 1,300 1.600 AN/A Month January Month January Production Cost #N/A AN Sheet - C about blank Excel template Saved Home Insert Formulas Data Review View Help Tell me what you want to do X Arial 10 Number B 1 U Paste Insert Delete Conditional Format Formatia Table Styles -A A $ - % 848 42 Cud Alignment Number Tables Curtis D E F G H Production Cost Inventory Lost Sales Cost Cost Overtime Undertime Rate Change Cost Cost Cost Produc 3 3 6 17 Month January February March April May June July August September October November December Totals Month January February March April May June July August September October November December Totals ANJA #NIA #N/A #N/A #N/A #N/A #N/A #N/A N/A #N/A WNIA WNIA 39 40 41 42 40 45 Total cost Total cost #N/A B Sheet + Con de toute Workbook