Question: Problem Description A small firm makes three products, which all follow the same three-step process, which consists of milling, inspection, and drilling. Product A requires

Problem Description A small firm makes three products, which all follow the same three-step process, which consists of milling, inspection, and drilling. Product A requires 6 minutes of milling, 5 minutes of inspection, and 4 minutes of drilling; product B requires 2.5 minutes of milling, 2 minutes of inspection, and 2 minutes of drilling; and product C requires 5 minutes of milling, 4 minutes of inspection, and 8 minutes of drilling. The department has 20 hours available during the next period for milling, 15 hours for inspection, and 24 hours for drilling. Product A contributes $6.00 per unit to profit, product B contributes $4.00 per unit, and product C contributes $10.00 per unit. Build an LP model that helps you determine the optimal product mix that would maximize the firms profit. After formulating the LP model, build the model in Excel and use Solver to find the optimal solution. You will answer online questions about the model and the solution.

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!