A manufacturing firm produces four types of automobile parts. Each is first fabricated and then finished. The required worker hours and profit for each part are:
|
Part A
|
Part B
|
Part C
|
Part D
|
|
Fabrication Time (hr/100 units)
|
2.5
|
1.5
|
2.75
|
2
|
|
Finishing Time (hr/100 units)
|
3.5
|
3
|
3
|
2
|
|
Profit ($ / 100 units)
|
375
|
275
|
475
|
325
|
Your (per month) total fabrication time available is 640 hours and the total finishing time is 960 hours.
a) Set up the problem in standard form and write the initial tableau.
b) Use Excel to solve for the amount of each part that maximizes profit.
c) Which would further maximize profit, hiring an extra 40 hours of fabrication time or finishing time?