can you do all the 3 stratrageis level,chase, subcontract

need to find all 3 stratragies step by step explanation please

2 Opening Stock 120 units Closing Stock 30 2. Hori Costs 2505 per worker Costs per worker 9 Production costs 10 Subcontract Production costs St Month 13 Forecast Demand 1 Open to oduction 15 in house 16 broduct 17 Contoh 1350 LO 3400 1550 1800 1500 10 Home costs tooth Product Mother 30 costs Cho 2 in case the data in the picture is not clear. Opening Stock: 120 units Desired Closing Stock : 240 units Back order Costs : $ 50/ unit In-house production costs : $ 35 per unit Subcontract Production costs : $ 55 per unit Inventory Holding costs : $ 10 / unit/month Production Capacity: 40 units per month per worker Hiring Costs :250$ per worker Firing Costs 600porworktor 1. Using the data, develop a level production plan. How much extra cost (inventory and HR costs) are involved in this plan? What additional costs (both financial and nonfi- nancial) might be involved with such a plant 2. Using the data, develop a chase production plan. How much extra cost (inventory and HR costs) are involved in this plan? What additional costs (both financial and non- nancial) might be involved with such a plan? 3. Try to develop a possible hybrid plan that would accomplish the task with smaller total costs than either level or chase. 4. Based on your work, what would you recommend and why? What are some of the pros and cons of the solution you recommend? Meridian Pumps Worksheet Winter 2021 - Excel Search File Home Neve Tab New Tab Insert Page Layout Formulas Data Review View Help Power Pivot DAS 4 Opening Stock o closing Stock 7 Hiring costs Fin Costs . Regular Production costs 10 Subcontract Production Costs 11 Month 12 Forecast Demand 13 Openine Stock 14 Production 15 hue 16 Subcontract Production 17 Closine Stock 18 19. Production Change costs 20 Hiring 1350 1800 FE 200 1950 TO 1500 22 23 Inventory Sos 24 Baccorder costs 25 Droduction Conte 25 in house Production cons 27 Sub-contract Production is 2 Total Costs Marian Level LE O Type here to search worker produces an average of 25 pumps in any given month. There are currently 20 workers in the medium-size pump area. 1. Using the data, develop a level production plan. How much extra cost (inventory and HR costs) are involved in this plan? What additional costs (both financial and nonfi- nancial) might be involved with such a plan? 2. Using the data, develop a chase production plan. How much extra cost inventory and HR costs) are involved in this plan? What additional costs (both financial and nonfi- nancial) might be involved with such a plan? 3. Try to develop a possible hybrid plan that would accomplish the task with smaller total costs than either level or chase. 4. Based on your work, what would you recommend and why? What are some of the pros and cons of the solution you recommend? 2 Opening Stock 120 units Closing Stock 30 2. Hori Costs 2505 per worker Costs per worker 9 Production costs 10 Subcontract Production costs St Month 13 Forecast Demand 1 Open to oduction 15 in house 16 broduct 17 Contoh 1350 LO 3400 1550 1800 1500 10 Home costs tooth Product Mother 30 costs Cho 2 in case the data in the picture is not clear. Opening Stock: 120 units Desired Closing Stock : 240 units Back order Costs : $ 50/ unit In-house production costs : $ 35 per unit Subcontract Production costs : $ 55 per unit Inventory Holding costs : $ 10 / unit/month Production Capacity: 40 units per month per worker Hiring Costs :250$ per worker Firing Costs 600porworktor 1. Using the data, develop a level production plan. How much extra cost (inventory and HR costs) are involved in this plan? What additional costs (both financial and nonfi- nancial) might be involved with such a plant 2. Using the data, develop a chase production plan. How much extra cost (inventory and HR costs) are involved in this plan? What additional costs (both financial and non- nancial) might be involved with such a plan? 3. Try to develop a possible hybrid plan that would accomplish the task with smaller total costs than either level or chase. 4. Based on your work, what would you recommend and why? What are some of the pros and cons of the solution you recommend? Meridian Pumps Worksheet Winter 2021 - Excel Search File Home Neve Tab New Tab Insert Page Layout Formulas Data Review View Help Power Pivot DAS 4 Opening Stock o closing Stock 7 Hiring costs Fin Costs . Regular Production costs 10 Subcontract Production Costs 11 Month 12 Forecast Demand 13 Openine Stock 14 Production 15 hue 16 Subcontract Production 17 Closine Stock 18 19. Production Change costs 20 Hiring 1350 1800 FE 200 1950 TO 1500 22 23 Inventory Sos 24 Baccorder costs 25 Droduction Conte 25 in house Production cons 27 Sub-contract Production is 2 Total Costs Marian Level LE O Type here to search worker produces an average of 25 pumps in any given month. There are currently 20 workers in the medium-size pump area. 1. Using the data, develop a level production plan. How much extra cost (inventory and HR costs) are involved in this plan? What additional costs (both financial and nonfi- nancial) might be involved with such a plan? 2. Using the data, develop a chase production plan. How much extra cost inventory and HR costs) are involved in this plan? What additional costs (both financial and nonfi- nancial) might be involved with such a plan? 3. Try to develop a possible hybrid plan that would accomplish the task with smaller total costs than either level or chase. 4. Based on your work, what would you recommend and why? What are some of the pros and cons of the solution you recommend