New Exercise Bank Content Qu$.08-02$

Consider a resource$-$allocation problem having the following data:

Click here for the Excel Data File

$\backslash$table$[[,$Activity $1,,$Activity $2],[$Unit Profit,$$2,,$$$5],[$Resource$,$Usage,Available$],[$Resource $1,-1,2,10],[$Resource $2,1,3,12]]$

Formulate and solve a spreadsheet model for this problem. Then use Solver's sensitivity report to find the allowable range for the unit profit of each activity.

a$.$ Determine the number of units of each activity to undertake.

Note: If an allowable increase$/$decrease is $10,000$ or larger, simply enter $10,000.$ Round "Allowable Increase $-$ Solution Activity $1"$ answer to $1$ decimal place. Round "Allowable Decrease $-$ Solution Activity $1"$ answer to $2$ decimal places.

$\backslash$table$[[$Name$,$Final Value,Reduced Cost,$\backslash$table$[[$Objective$],[$Coefficient$]],$Allowable Increase,Allowable Decrease$],[$Solution activity $1,,0,2,,],[$Solution activity $2,,0,5,,],[$Name$,$Final Value,Shadow Price,Constraint RightHand Side,Allowable Increase,$\backslash$table$[[$Allowable$],[$Decrease$]]],[$Resource $1$ used,,$1,10,,],[$Resource $2$ used,,$1,12,,]]$

b$.$ Determine the total profit.

Total profit