Question: Show excel steps and solve the problem: Supertronics, Inc., would like to know how the profitability is altered by product mix. Currently, the product mix

Show excel steps and solve the problem:
Supertronics, Inc., would like to know how the profitability is altered by product mix. Currently, the product mix is determined by giving priority to the product with the highest per-unit contribution margin(defined as the difference between price and material cost). Details on the Supertronics product line, including processing time at each workstation, follow: PRODUCT Alpha Beta Delta GammaPrice $350.00 $320.00 $400.00 $500.00Material Cost $50.00 $40.00 $125.00 $150.00Weekly Demand in Units 100605080Processing Time at Machine 1 in Minutes2004010Processing Time at Machine 2 in Minutes2520050Processing Time at Machine 3 in Minutes0206030a. Assume that Supertronics has 5,500 minutes of capacity available at each workstation each week. Develop a linear program to define the production mix that maximizes contribution margin. b. Solve your formulation using a computer package such as POM for Windows. c. Given your solution for part (b), which machine is the bottleneck?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!