all required data is in the two sheets.

Sales Forecast (Standard Boats each quarter) D Quarter 0 Quarter 1 Quarter 2 Quarter 3 Quarter 4 qtr 5 Product Lines Fun Ray Demand Production Inventory 5000 3000 Sun Ray Demand Production Inventory 3000 1000 Sting Ray Demand Production Inventory 4000 3000 2 3 4 5 6 Lot Size 7 Target inventory 8 9 10 11 Lot Size 12 Target Inventory 13 14 15 16 Lot Size 17 Target Inventory 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Capacity Capacity Used Capacity Available Production (Standard Boats each quarter) Lot Size Quarter 0 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Product Lines Overall Demand Production Capacity Used Inventory 15000 Inventory Funray Sun Ray Sting Ray 15000 3000 5000 23000 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 Sales Forecast (Standard Boats each quarter) D Quarter 0 Quarter 1 Quarter 2 Quarter 3 Quarter 4 qtr 5 Product Lines Fun Ray Demand Production Inventory 5000 3000 Sun Ray Demand Production Inventory 3000 1000 Sting Ray Demand Production Inventory 4000 3000 2 3 4 5 6 Lot Size 7 Target inventory 8 9 10 11 Lot Size 12 Target Inventory 13 14 15 16 Lot Size 17 Target Inventory 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Capacity Capacity Used Capacity Available Production (Standard Boats each quarter) Lot Size Quarter 0 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Product Lines Overall Demand Production Capacity Used Inventory 15000 Inventory Funray Sun Ray Sting Ray 15000 3000 5000 23000 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