Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please show work in excel Vollmer Manufacturing makes three components for sale to refrigeration companies. The components are processed on two machines: a shaper and
Please show work in excel
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: Machine Component Shaper Grinder 1 6 4 2 4 5 3 4 2 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 1,000 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. (a) Formulate and solve for the recommended production quantities. If the constant is "1" it must be entered in the box. If an amount is zero, enter "0". Let C1 = units of component 1 manufactured C2 = units of component 2 manufactured C3 = units of component 3 manufactured Max C1 + C2 + C3 s.t. C1 + C2 + C3 - Select your answer - Shaper C1 + C2 + C3 Select your answer - Grinder C3 Select your answer - Maximum units of component 3 C1 0 0 0 0 0 0 0 - Select your answer - 4 Maximum units of component 1 C2 Select your answer - Maximum units of component 2 C1 Select your answer - Minimum units of component 1 C1, C2, C3 Select your answer - Optimal solution: C1 = C2 C3= (b) What are the objective coefficients ranges for the three components? If required, round your answers to two decimal places. Variable Objective Coefficient Range C1 Select your answer - to Select your answer - C2 Select your answer - to Select your answer - Select your answer - to Select your answer - Interpret these ranges for company management. The input in the box below will not be graded, but may be reviewed and considered by your instructor. blank (c) What are the right-hand-side ranges? Constraint Right-Hand-Side Range 1 - Select your answer - to Select your answer - 2 Select your answer - to Select your answer - Interpret these ranges for company management. The input in the box below will not be graded, but may be reviewed and considered by your instructor. blankStep 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