excel

3. Video-techtronics The production manager of Video-techtronics Company is attempting to determine the upcoming 5-month production schedule for video recorders. Past production records indicate that 2,000 recorders can be produced per month. An additional 700 recorders can be produced monthly on an overtime basis. Unit cost is $10 for recorders produced during regular working hours and $15 for those produced on an overtime basis. Contracted sales per month are as follows: Month Contracted Sales (units) 1 1,250 2 2,100 3 2,510 4 2960 5 4,000 Inventory carrying costs are $2 per recorder per month. The manager does not want any inventory carried over past the fifth month. The manager wants to know the monthly production that will minimize total production and inventory costs. a. Formulate a linear programming model for this problem. b. Solve the model by using the computer. c. If the contracted sales for month 1 were increased by 10, how much extra cost would there be? d. If the contracted sales for month 5 were increased by 10, how much extra cost would there be? e. How much would costs go down, if regular production per month capability inreased by 10 units