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

Resource Usage per Unit of Each Activity

Activity $1$ Activity $2$ Amount of Resource

Available

Resource $11210$

Resource $21312$

The unit profit for Activity $1$ is $$2,$ and the unit profit for Activity $2$ is $$5.$ The objective is to

determine the number of units of each activity to undertake so as to maximize the total profit.

Formulate a spreadsheet model for this problem, and use Solver to find an optimal solution.