provide excel formulas too. calculate mps, changeover costs and inventory holding cost quarterly

1 Neptune Manufacturing Sales Forecast (Standard Boats each quarter) Product Lines Quarter 0 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Co YOU AWN- 5 Fun Ray Sun Ray Sting Ray 8000 4000 9000 21000 9000 5000 10000 24000 6000 2000 6000 14000 6000 2000 7000 15000 15000 15000 0 0 15000 15000 Production (Standard Boats each quarter) 15000 0 15000 15000 0 15000 Quarter 0 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Qtr 5 $ $ $ 100.00 150.00 200.00 9 10 11 Capacity 12 Capacity Used 13 Capacity Available 14 15 Lot Size Product Lines 16 17 5000 Fun Ray 18 3000 Sun Ray 19 4000 Sting Ray 20 Target Inventory 21 22 Inventory Min Inventory 23 3000 Funray 3000 24 1000 Sun Ray 1000 25 3000 Sting Ray 3000 26 27 Inventory Costs Holding costs 28 Funray $ 10.00 29 Sun Ray $ 15.00 30 Sting Ray $ 20.00 31 32 Changeover Costs $ 5,000.00 33 34 changeovers Funray 35 Sunray 36 Sting ray 37 38 Inventory 15000 3000 5000 Inventory Total Cost 30 1 Neptune Manufacturing Sales Forecast (Standard Boats each quarter) Product Lines Quarter 0 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Co YOU AWN- 5 Fun Ray Sun Ray Sting Ray 8000 4000 9000 21000 9000 5000 10000 24000 6000 2000 6000 14000 6000 2000 7000 15000 15000 15000 0 0 15000 15000 Production (Standard Boats each quarter) 15000 0 15000 15000 0 15000 Quarter 0 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Qtr 5 $ $ $ 100.00 150.00 200.00 9 10 11 Capacity 12 Capacity Used 13 Capacity Available 14 15 Lot Size Product Lines 16 17 5000 Fun Ray 18 3000 Sun Ray 19 4000 Sting Ray 20 Target Inventory 21 22 Inventory Min Inventory 23 3000 Funray 3000 24 1000 Sun Ray 1000 25 3000 Sting Ray 3000 26 27 Inventory Costs Holding costs 28 Funray $ 10.00 29 Sun Ray $ 15.00 30 Sting Ray $ 20.00 31 32 Changeover Costs $ 5,000.00 33 34 changeovers Funray 35 Sunray 36 Sting ray 37 38 Inventory 15000 3000 5000 Inventory Total Cost 30