The first completed picture is the first part that has already been completed. It's just there if you need help with the second part. Could you please post the formulas from excel as well? Thank you

7 8 ShopCo makes shopping carts. Below is their forecast for the first 6 months next year. They want to cost out a level production plan of 700 units per month. Beginning Inventory is 100 units. Inventory holding costs are $15 per unit per month. Backorder costs are $35 per unit per month. Regular labour is $80 per unit. 9 10 11 12 1 2 3 4 5 6 Total 600 700 725 750 850 750 4375 700 700 700 700 700 700 4200 13 Month 14 Forecast 15 Output 16 Regular 17 Part Time 18 Overtime 19 Subcontract 20 Output - Forecast 21 Inventory 22 Beginning 23 Ending 24 Average 25 Backorder 100 200 200 175 125 0 800 200 175 125 0 0 200 150 700 750 200 187.5 150 0 62.5 25 0 0 0 0 50 75 26 Costs: 27 $56,000 $56,000 $56,000 $56,000 $56,000 $56,000 $336,000 28 29 30 Regular Part Time Overtime Subcontract Hire/Layoff Inventory Back orders 31 32 33 34 Total 35 $ 2,250.00 $3,000.00 $ 2,812.50 $2,250.00 $ 937.50 $ 750.00 $ 12,000.00 0 0 0 0 875 1750 $2,625 $58,250 $59,000 $58,812.5 $58,250 $57,812.5 $58,500 $350,625 35 36 37 38 As an alternative, Shopco would like to try using a Chase Method. Their current staffing levels have them able to produce 600 units per month using regular labour. They can work overtime one Saturday per month to produce an extra 100 units per day. Overtime units are $125 each and Subcontracted units are $150 each. *Beginning inventory is 100 units. 39 40 1 2 3 41 5 6 Total 600 700 725 750 850 750 41 42 Month 43 Forecast 44 Output 45 Regular 46 Part Time 47 Overtime 48 Subcontract 49 Output - Forecast 50 Inventory 51 Beginning 52 Ending 53 Average 54 Backorder 55 Costs: 56 Regular 57 Part Time 58 Overtime 59 Subcontract 60 Hire/Layoff 61 Inventory 62 Back orders 63 Total 64 65