Include excel formulas and solution

1. The Seymore Bicycle Manufacturing Company of Boise, Idaho, has developed the following demand forecast for next year's bicycle. Quarter Forecast AWN- 5,000 10,000 8,000 2,000 On January 1, there are 1,000 units in inventory. The firm has prepared the following data: Hiring cost per employee = $200. Layoff cost per employee = $400. Beginning workforce = 60 employees. Inventory carrying cost = $2 per unit per quarter of ending inventory. Stockout cost = $50 per unit. Regular payroll = $1,200 per employee per quarter. Overtime cost = $2 per unit, limited to = 40 units per employee per quarter. Each employee can produce = 100 units per quarter on regular time. Demand not satisfied in any quarter is lost. Using linear programming: a. How much should Seymore produce during each quarter? b. What is the total budget Seymore's plan will require for the next year? 1. The Seymore Bicycle Manufacturing Company of Boise, Idaho, has developed the following demand forecast for next year's bicycle. Quarter Forecast AWN- 5,000 10,000 8,000 2,000 On January 1, there are 1,000 units in inventory. The firm has prepared the following data: Hiring cost per employee = $200. Layoff cost per employee = $400. Beginning workforce = 60 employees. Inventory carrying cost = $2 per unit per quarter of ending inventory. Stockout cost = $50 per unit. Regular payroll = $1,200 per employee per quarter. Overtime cost = $2 per unit, limited to = 40 units per employee per quarter. Each employee can produce = 100 units per quarter on regular time. Demand not satisfied in any quarter is lost. Using linear programming: a. How much should Seymore produce during each quarter? b. What is the total budget Seymore's plan will require for the next year