Betty Products Inc. manufactures three products on two machines. In a typical week 40 hours are available on each machine. The profit contribution and production time in hours per unit follows:
Category Product 1 Product 2 Product 3
Profit/unit $30 $50 $20
Machine 1 time/unit 0.5 2.0 0.75
Machine 2 time/unit 1.0 1.0 0.5
Two operators are required for machine 1; thus, 2 hours of labor must be scheduled for each hours of machine 1 time. Only one operator is required for machine 2. a maximum of 100 labors is available for assignment to the machines during the coming week. Other production requirement are that product 1 cannot account for more than 50% of the units produced and that product 3 must account for at least 20% of the units produced
a. How many units of each product be produced to maximize the total profit contribution? What is the projected weekly profit associated with the solution?
b. How many hours of production time will be scheduled on each machine?
c. What is the value of an additional hour of labor?
d. Assume that labor capacity can be increased to 120 hours. Would you be interested in using the additional 20 hours available for the resource? Develop the optimal product mix assuming the extra hours are made available.© BrainMass Inc. brainmass.com June 3, 2020, 8:23 pm ad1c9bdddf
I'll attach the excel spreadsheet I used to calculate some of these problems.
For part (a) the greatest amount of profit can be made by maximizing product 1 on machine 1 and eliminating product 1 on machine 2, while keeping product 3 above %20.
Total Units ...
A management problem is solved. The solution is detailed and well presented. The response received a rating of "5/5" from the student who originally posted the question.