I know we need to use solver to find the minimum total cost
Question 2: General Avionics has developed the following sales plan for one line in its factory: Quarter Sales Plan 5,000 10,000 8,000 2,000 2 3 1 4 At the beginning of Quarter 1, there are 1,000 units in inventory. The firm has prepared the following production data: Hiring cost per employee: $600 Layoff cost per employee: $800 Beginning workforce: 60 employees Inventory carrying cost: $4 per unit per quarter of ending inventory S&OP& MPS Assignment SCMG 480 Fall 2019 2 Regular payroll cost: $6,200 per employee per quarter Overtime cost: $7 per unit Each employee can produce 100 units per quarter during regular time and no more than 30 units per quarter in overtime. General Avionics would like to ensure that the ending inventory in Quarter 4 is no less than 500 units. Develop and solve a linear program to determine the optimal production plan that minimizes the total cost over the next year. [50 points Question 2: General Avionics has developed the following sales plan for one line in its factory: Quarter Sales Plan 5,000 10,000 8,000 2,000 2 3 1 4 At the beginning of Quarter 1, there are 1,000 units in inventory. The firm has prepared the following production data: Hiring cost per employee: $600 Layoff cost per employee: $800 Beginning workforce: 60 employees Inventory carrying cost: $4 per unit per quarter of ending inventory S&OP& MPS Assignment SCMG 480 Fall 2019 2 Regular payroll cost: $6,200 per employee per quarter Overtime cost: $7 per unit Each employee can produce 100 units per quarter during regular time and no more than 30 units per quarter in overtime. General Avionics would like to ensure that the ending inventory in Quarter 4 is no less than 500 units. Develop and solve a linear program to determine the optimal production plan that minimizes the total cost over the next year. [50 points