(d)	If more time could be made available on the grinder, how much would it be worth?
	- Select your answer -Profit of $1000Profit of $200NothingItem 43
	Explain.
	The input in the box below will not be graded, but may be reviewed and considered by your instructor.
(e)	If more units of component 3 can be sold by reducing the sales price by $4, should the company reduce the price?
	- Select your answer -YesNoItem 45
	Explain.
	The input in the box below will not be graded, but may be reviewed and considered by your instructor.

Please answer all questions and use 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 6 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 - V Shaper C + C2 + C3 - Select your answer - Grinder C3 V Select your answer Maximum units of component 3 C1 - Select your answer Maximum units of component 1 - 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 - C3 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 V to Select your answer - 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 6 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 - V Shaper C + C2 + C3 - Select your answer - Grinder C3 V Select your answer Maximum units of component 3 C1 - Select your answer Maximum units of component 1 - 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 - C3 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 V to Select your