A manufacturing company wants to maximize profits on products A, B, and C. The profit margin is $3 for A, $6 for B, and $15 for C. The production requirements and departmental capacities are as follows: Department | Production requirement | Departmental capacity by product (hours) A B C 2 3 2 Total hours) Assembling Painting Finishing 30,000 38,000 28,000 Formulate the LP Problem and solve using Excel Solver. 7) What is the maximum profit in this model?
8) What is the maximum profit if the profit margin on A changes to $7.00
9) What is the maximum profit if the profit margin on C changes to $10.00
10) What is the maximum profit if the capacity of the finishing department changes to 33,000 hours
11) What is the maximum profit if the capacity of the painting department changes to 40,000 hours
7)
8)
9)
10)
11)