The production manager of 1ifideotechnics 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 600 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 1200 2 2100 3 2400 4 30-00 5 4000 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. 1} Formulate a linear programming model for this problem. 2] Solve the model by using Excel Solver