SOLVE USING SOLVER IN EXCEL AND MAKE THE ANSWER EASY TO SEE FOR EACH PART. 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

$164$

$245$

$342$The shaper is available for $120$ hours, and the grinder for $110$ hours. No more than $150$ units of component $3$ can be sold, but up to $1,000$ units of component $1$ and up to $1,000$ units of component $2$

can be sold. In fact, the company already has orders for $650$ units of component $1$ that must be satisfied. The per unit selling price and per unit variable costs for each of the three components are as

follows:

$($a$)$ For each component, calculate the profit margin $($profit margin $=$ selling price $-$ material cost $-$ labor cost$).$

Component $1$: $

Component $2$: $

Component $3$: $

Formulate and solve the model to determine the maximum profit. If the constant is $"1",$ it must be entered in the box. If an amount is zero, enter $"0".$

Let $C_1=$ units of component $1$ manufactured

$C_2=$ units of component $2$ manufactured

$C_3=$ units of component $3$ manufactured

Maximum profit: $!$

$($b$)$ What are the objective coefficients ranges for the three components? If required, round your answers to two decimal places.

Interpret these ranges for company management.

Individual changes in the profit coefficients $-$ Select your answer $-$ these ranges will not cause a change in the optimal number of components to produce.

$($c$)$ What are the right$-$hand$-$side ranges?

Interpret these ranges for company management.

These are the ranges over which the shadow prices for the associated constraints $-$ Select your answer $-$ applicable.

$($d$)$ If more time could be made available on the grinder, how much would it be worth? Explain.

$],$ because the constraint related to the time available on the grinder binding.

$($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 $-,$ because the production of component $3$ would be

price $-$ Select your answer $-$ of component $3$ would be produced.