Vollmer Manufacturing makes 3 components for industrial uses. The components are processed on two machines, a shaper and a grinder. Component 1 requires 6 minutes on the shaper and 4 minutes on the grinder. Component 2 requires 4 minutes on the shaper and 5 minutes on the grinder. Component 3 requires 4 minutes on the shaper and 2 minutes on the grinder. The shaper is available for 120 hours and the grinder for 110 hours. No more than 200 units of component 3 can be sold, but up to 1000 units of each of the other components can be sold. The company has orders for 600 units of component 1 that must be satisfied. Profit contributions for components 1, 2, and 3 are $6, $8, and $9 respectively.
Construct a linear optimization model for this situation on a spreadsheet and solve using Solver. Copy the Solver model from the dialog and paste it into your spreadsheet next to the model.
The Solver model and the solution is:
Get Answers For Free
Most questions answered within 1 hours.