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.