A company that builds sailboats wants to determine how many sailboats to build during each of the next four quarters. The demand during each of the next four quarters is as follows: first quarter, 160 sailboats; sec-ond quarter, 240 sailboats; third quarter, 300sailboats; fourth quarter, 100 sailboats. The company must meet demands on time. At the beginning of the first quarter, the company has an inventory of 40sailboats. At the beginning of each quarter, the company must decide how many sailboats to build during that quarter. For simplicity, assume that sailboats built during a quarter can be used to meet demand for that quarter. During each quarter, the company can build up to 160sailboats with regular-time labor at a total cost of $1600 per sailboat. By having employees work overtime during a quarter, the company can build additional sailboats with overtime labor at a total cost of $1800 per sailboat. At the end of each quarter (after production has occurred and the current quarter's demand has been satisfied), a holding cost of $80 per sailboat is incurred.

a.Determine a production schedule to minimize the sum of production and inventory holding costs during the next four quarters.

The template screenshot is included below. Please provide step by step guidance.

AutoSave OFF A FC ... Linear Optimization Part 1 - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments TH La. Connections KEY Clear Flash Fill Group v Data Validation v HO Analysis Tools Properties Reapply Ungroup v Get Data from Refresh Stocks Currencies Geography Sort Filter Text to Remove Duplicates - Consolidate What-If ? Solver Data Picture All Edit Links Advanced Columns Analysis Subtotal 117 X V fx B C D E F G H K M N P Q R S U V W Building sailboats Quarter 1 2 3 Regular time unit cost Overtime unit cost Unit holding cost Initial inventory 10 Production schedule 11 Quarter Regular time production Upper bound Overtime production 18 Onhand after production 19 20 Demand Ending inventory 24 Regular time cost 25 Overtime cost Holding cost 28 Total cost 29 43 Sensitivity Report 1 Model 25a Sensitivity Report 2 Model 28a Model 31a Model 32a Model 37a + Ready 100%