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.