Ford has three assembly plants located in various parts of the country. The first plant (built...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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.5 hours of labor and 1 hour of machine time to assemble one automobile. The second plant (built in 1958 and located in Bakersfield, California) requires 1.5 hours of labor and 1.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 2.5 hours of machine time to assemble one automobile. The firm pays $35 per hour of labor and $11 per hour of machine time at each of its plants. The first plant has a capacity of 400 hours of machine time per day; the second, 1500 hours; and the third, 2,000 hours. The manufacturer's production target is 1,800 automobiles per day. The production department sets each plant's schedule by solving a linear programming problem designed to identify the cost-minimizing pattern of assembly across the three plants. Tasks: 1. Model the decision problem as a linear program. 2. Use EXCEL Solver to determine the cost-minimizing method of meeting Ford's daily production target. Discuss the solution. 3. Obtain the sensitivity report of EXCEL Solver and discuss the report. ONLY use the Sensitivity Report to answer tasks (4 to 8) 4. The UWA local in Bakersfield, California, has proposed wage concessions at that plant to raise employment. What is the smallest decrease in the wage rate at that plant that would increase employment there? (%10) 5. (A) What is the cost of assembling extra 10 automobiles given the current output level of 1,800 automobiles? (B) Is it possible to produce 3,500 automobiles with given solution? If possible provide the new total cost, if not possible explain why not? (C) Is it possible to 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.5 hours of labor and 1 hour of machine time to assemble one automobile. The second plant (built in 1958 and located in Bakersfield, California) requires 1.5 hours of labor and 1.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 2.5 hours of machine time to assemble one automobile. The firm pays $35 per hour of labor and $11 per hour of machine time at each of its plants. The first plant has a capacity of 400 hours of machine time per day; the second, 1500 hours; and the third, 2,000 hours. The manufacturer's production target is 1,800 automobiles per day. The production department sets each plant's schedule by solving a linear programming problem designed to identify the cost-minimizing pattern of assembly across the three plants. Tasks: 1. Model the decision problem as a linear program. 2. Use EXCEL Solver to determine the cost-minimizing method of meeting Ford's daily production target. Discuss the solution. 3. Obtain the sensitivity report of EXCEL Solver and discuss the report. ONLY use the Sensitivity Report to answer tasks (4 to 8) 4. The UWA local in Bakersfield, California, has proposed wage concessions at that plant to raise employment. What is the smallest decrease in the wage rate at that plant that would increase employment there? (%10) 5. (A) What is the cost of assembling extra 10 automobiles given the current output level of 1,800 automobiles? (B) Is it possible to produce 3,500 automobiles with given solution? If possible provide the new total cost, if not possible explain why not? (C) Is it possible to
Expert Answer:
Related Book For
Microeconomics Theory and Applications with Calculus
ISBN: 978-0133019933
3rd edition
Authors: Jeffrey M. Perloff
Posted Date:
Students also viewed these mechanical engineering questions
-
The Sky Hospital Consortium consists of 40 hospitals in various parts of the US. After being discharged, patients are given a survey to determine if they are satisfied with the overall service. In...
-
Educational vouchers are increasingly used in various parts of the United States. Suppose that the government offers poor people $5,000 education vouchers that can be used only to pay for education....
-
Governments increasingly use educational vouchers in various parts of the United States. Suppose that the government offers poor people $5,000 education vouchers that they may use only to pay for...
-
The following two-dimensional problems all have mixed boundary conditions involving both traction and displacement specifications. Using various field equations, formulate all boundary conditions for...
-
What is the heat when 245 g of H2O cool from 355 K to 298 K? The heat capacity of H2O is in Table 7.1.
-
Calculate the change in structural efficiency for both bending stiffness and strength when a solid flat panel of unit area and thickness \(t\) is foamed to give a foam panel of unit area and...
-
Briefly explain: (a) the advantage to external auditors and companies of external auditors relying (in part) on the work of internal auditors; (b) why internal auditors do not perform all of the...
-
(Term Modification with GainCreditors Entries) Using the same information as in E14-21 and E14-23 above, answer the following questions related to American Bank (creditor). (a) Compute the loss...
-
To improve the short-range acceleration of an electric car, a capacitor may be used. Charge is stored on the capacitor's surface between a porous composite electrode and electrolytic fluid. Such a...
-
The plots below show sampling distributions of p-values for different values of power. Match the distribution to the power. Please note that for this problem, you must pick values of power for all...
-
What specific attitudes towards homelessness would a Symbolic Interactionist seek to discourage?
-
False spoken statements or actions that damage a persons reputation or good name. a. conversion b. contributory ne gligence c. defamation d. liability e. libel f. negligence g. nuisance h. slander i....
-
Indicate whether each of the following statements is true or false by writing T or F in t he a nswer c olumn. The tort of nuisance does not entail taking anothers property, only detracting from his...
-
Indicate whether each of the following statements is true or false by writing T or F in the answer c olumn. Upon reaching legal age, a minor must ratify earlier completed contracts in writing.
-
Organizations established contractually by several countries that agree to be legally bound by the rules of the organization. a. comity b. transnational ins titutions c. General Agreement on Tariffs...
-
Indicate whether each of the following statements is true or false by writing T or F in t he a nswer c olumn. Two defenses to charges of defamation are truth and privilege.
-
Demonstrate the utility of database automation. Describe commonly used database automation tools. Describe SQL server integration services (SSIS) data migration software, SQL server analysis services...
-
Tell whether the angles or sides are corresponding angles, corresponding sides, or neither. AC and JK
-
The 2002 production run of 25,000 new Thunderbirds included only 2,000 cars for Canada. Yet potential buyers besieged Canadian Ford dealers. Many hoped to make a quick profit by reselling the cars in...
-
The two people in a pure exchange economy have identical utility functions. Will they ever want to trade? Why or why not?
-
A monopoly chocolate manufacturer faces two types of consumers. The larger group, the hoi polloi, loves desserts and has a relatively flat, linear demand curve for chocolate. The smaller group, the...
-
T/F: BOs are internally stable and externally adaptable.
-
T/F: BOs is the middle layer of stability model.
-
T/F: BOs are semi-tangible and mostly conceptual.
Study smarter with the SolutionInn App