Question: Show work by Excel, that would be nice thanks The Golden Hawk Manufacturing Company wants to maximize the profits on products A, B, and C.
The Golden Hawk Manufacturing Company wants to maximize the profits on products A, B, and C. The contribution margin for each product is as follows: Profit A B Contribution Margin in $ 1 5 -10 The production requirements and the departmental capacities are as follows: Production Requirements by Product (Hours) Department B Departmental Capacity (Total Hours) 18 45 60 Assembling Painting Finishing 8 1 5 4 6 7 12 2 3 (a) Write the objective function representing the profit-maximization formula for the Golden Hawk Company? (b) Write the constraints inequalities (there should be three)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
