Question: Recall the RMC problem with three products studied in class. The solution to this problem obtained with EXCEL follows. In this case, I added a



Recall the RMC problem with three products studied in class. The solution to this problem obtained with EXCEL follows. In this case, I added a constraint that says that RMC has an order far 10n tane of Colvant Raca that hac ta ha filfilled Answer the following questions as accurately as possible, explaining all your answers. (a) Write the units of the following figures in the sensitivity report (for example: \$, tons, \$/ton, ...): (b) The market value of Material 1 is $85 per ton, how can RMC take advantage of this? Explain in detail how they can increase their profit - if they can - and by how much. (c) RMC has been offered 50 additional tons of Material 3 for $500. Should they accept the offer? What would happen to the overall profit if they did? Explain. (d) If the profit per ton of the Carpet Cleaning Fluid increases to $55 per ton. How will this affect the optimal solution? And the total profit? (e) If the profit per ton of the Fuel Additive decreases to $30 per ton. How will this affect the optimal solution? And the total profit? (f) What is the meaning of the 12.5 in $B$23 ? Explain. Recall the RMC problem with three products studied in class. The solution to this problem obtained with EXCEL follows. In this case, I added a constraint that says that RMC has an order far 10n tane of Colvant Raca that hac ta ha filfilled Answer the following questions as accurately as possible, explaining all your answers. (a) Write the units of the following figures in the sensitivity report (for example: \$, tons, \$/ton, ...): (b) The market value of Material 1 is $85 per ton, how can RMC take advantage of this? Explain in detail how they can increase their profit - if they can - and by how much. (c) RMC has been offered 50 additional tons of Material 3 for $500. Should they accept the offer? What would happen to the overall profit if they did? Explain. (d) If the profit per ton of the Carpet Cleaning Fluid increases to $55 per ton. How will this affect the optimal solution? And the total profit? (e) If the profit per ton of the Fuel Additive decreases to $30 per ton. How will this affect the optimal solution? And the total profit? (f) What is the meaning of the 12.5 in $B$23 ? Explain
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
