Formulate the LP Model, A car manufacturer has three

Formulate the LP Model

Assignment Help Operation Management

Reference no: EM131843712

Question: A car manufacturer has three assembly lines, Plant A, B, and C and three distribution centers: Center I, II, and III. Every day, Plant A can assemble at most 200 cars, Plant B can assemble 150 cars, and Plant C can assemble 250 Cars. Distributor I requires at least 120 cars/day. Distribution II requires at least 270 cars a day and Distribution III requires at least 200 cars a day. The cost for transpiration one car is given as

	Plant A	Plant B	Plant C
Distributor 1	$230	$150	$190
Distributor 2	$410	$320	$130
Distributor 3	$210	$230	$200

Please answer the following questions:

(1) Formulate the LP Model;

(2) Solve this problem using optimization tools such as Excel solver. Please make sure to attach the excel table as part of the solution.

Reference no: EM131843712

Questions Cloud

Why td updates are likely to be much better : Can you see why TD updates are likely to be much better, at least initially, in this case? Might the same sort of thing happen in the original task?

What will be the practical and ethical issues : A car company discovered that there a gas feed problem and possible an overheated vehicle. The CEO and chief designer did not want to tell public (hiding).

Identify the aqueous species that have the highest : Identify the aqueous species that have the highest concentrations at equilibrium. Justify your answer.

What can he do to make sure that the number of cords : What can he do to make sure that the number of cords with defect to go down?

Formulate the LP Model : A car manufacturer has three assembly lines, Plant A, B, and C and three distribution centers: Center I, II, and III. Every day, Plant A can assemble.

Implement value iteration for the gamblers problem : Implement value iteration for the gambler's problem and solve it for p = .25 and p = .55. Are your results stable as ? ? 0.

How you would use the team factors to reduce the likelihood : How you would use the team factors to reduce the likelihood of friction due to the personalities and dynamics.

How do quinalones antibiotics harm bacterial : Question: How do Quinalones antibiotics harm bacterial cells but not human cells?

Cause an action potential of the axon : Would iy take more impulses to cause an action potential of the axon is far ways the from the postsynaptic cell body or on the cell body? Why?

User Account

All Pages