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. Thesolution to this problem obtained with EXCEL follows. In this case, Iadded a constraint that says that RMC has an order far 10n

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!