Question
how to solve this question in EXCEL using SLOVER : Vollmer Manufacturing Case Vollmer Manufacturing makes three components for sale to refrigeration companies. The components
how to solve this question in EXCEL using SLOVER :
Vollmer Manufacturing Case
Vollmer Manufacturing makes three components for sale to refrigeration companies. The components are processed on two machines: a shaper and a grinder.
The times (in minutes) required on each machine are as follows:
Component | Shaper | Grinder |
1 | 6 | 4 |
2 | 4 | 5 |
3 | 4 | 2 |
The shaper is available for 120 hours, and the grinder is available 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. In fact, the company already has orders for 600 units of component 1 that must be satisfied. The profit contributions for components 1, 2, and 3 are $8, $6, and $9, respectively.
- Formulate and solve for the recommended production quantities to maximize profit.
- What are the optimal production quantities and the optimal profit?
- If more time could be made available on the grinder, how much would it be worth?
SUBMIT : Excel file with answers to the above questions.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started