PLEASE SHOW ME WHAT FORMULAS TO USE IN EACH CELL ON EXCEL! ALSO PLEASE SHOW ME HOW TO ENTER IT INTO SOLVER BECAUSE I AM DOING IT INCORRECTLY.

3.3A SPREADSHEET:

3.3.* Consider a resource-allocation problem having the following data. Contribution per unit = profit per unit of the activity. a. Formulate a linear programming model for this problem on a spreadsheet. \begin{tabular}{|r|r|r|} \hline & Activity 1 & Activity 2 \\ \hline Contribution per unit & \\ \hline & Resource Usage \\ \hline Resource 1 & \\ \hline Resource 2 & \\ \hline Resource 3 & \\ \hline & \\ \hline & Activity 1 & Activity 2 \\ \hline & \\ \hline Level of Activity \\ \cline { 1 - 2 } & \\ \hline \end{tabular}