Consider the following algebraic formulation of a resource-allocation problem with three resources, where the decisions to be

Question:

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).
Maximize Profit = 20A1 + 40A2 + 30A3
Subject to
Resource 1: 3 A1 + 5 A2 + 4 A3 ( 400 (amount available)
Resource 2: A1 + A2 + A3 ( 100 (amount available)
Resource 3: A1 + 3A2 + 2A3 ( 200 (amount available)
And
A1 ( 0 A2 ( 0 A3 ( 0
Formulate and solve the spreadsheet model for this problem?