Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please make sure the answer is correct 100% Question 1) Ford has three assembly plants located in various parts of the country. The first plant

Please make sure the answer is correct 100%

Question 1)

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. Use EXCEL Solver to determine the cost-minimizing method of meeting Fords daily production target. Discuss the solution.
  2. 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. Obtain the sensitivity report of EXCEL Solver and discuss the report.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Tools For Business Decision Making

Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso

3rd Edition

047169195X, 978-0471691952

More Books

Students also viewed these Accounting questions

Question

How did we obtain formulas for numeric differentiation?

Answered: 1 week ago

Question

What is the purpose of the staffing practice called Two-in-aBox?

Answered: 1 week ago

Question

What would you do?

Answered: 1 week ago