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

Click here for the Excel Data File

Activity $1$ Activity $2$

Unit Profit $$2$ $$5$

Resource Usage Available

Resource $11210$

Resource $21312$

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.

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.

Determine the total profit.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.

b$.$ Determine the total profit.