Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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. blank

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Definitive Guide To Blockchain For Accounting And Business

Authors: Saurav K. Dutta

1st Edition

1789738687, 9781789738681

More Books

Students also viewed these Accounting questions