*******please don't post another solution to my question .this question is different and have different numbers .....**********

Ford has three assembly plants located in various parts of the country. The first plant (built in 1937 and located in Norwood, Ohio) requires 1 hours of labor and 2 hour of machine time to assemble one automobile. The second plant (built in 1958 and located in Bakersfield, California) requires 0.5 hours of labor and 2.5 hours of machine time to assemble one automobile. The third plant (built in 1981 and located in Kingsport, Tennessee) requires 1.1 hours of labor and 1.5 hours of machine time to assemble one automobile. The firm pays((( $32 )))per hour of labor and(((( $10 )))per hour of machine time at each of its plants. The first plant has a capacity of((((( 600 )))))hours of machine time per day; the second, ((((1100))) hours; and the third,(((( 1,000 ))))hours. The manufacturers production target is((((( 1400 ))))automobiles per day. The production department sets each plants schedule by solving a linear programming problem designed to identify the cost-minimizing pattern of assembly across the three plants.

1. (30 Points) Use EXCEL Solver to determine the cost-minimizing method of meeting Fords daily production target. Discuss the solution. 2. (15 Points) Based on the optimum solution of your LP model, which plant do you recommend having more orders in the future in case of over-loaded plants or the firm is having more orders than usual? 3. (15 Points) Obtain the sensitivity report of EXCEL Solver and discuss the report.