=E*3.7. Consider the following algebraic formulation of a resource-allocation problem with three resources, where the decisions to be made are the levels of three activities (A1, A2, and A3).

subject to and Formulate and solve the spreadsheet model for this problem.

A1 0 A2 0 A3 0 Resource 3: A1 3A2 2A3 200 1amount available2 Resource 2: A1 A2 A3 100 1amount available2 Resource 1: 3A1 5A2 4A3 400 1amount available2 Maximize Profit 20A1 40A2 30A3