[Steps Shown] (a) (Submit your work in Excel and use the solver to solve.) The following table summarizes the key facts but products, A and B, and the resources
Question: (a) (Submit your work in Excel and use the solver to solve.)
The following table summarizes the key facts but products, A and B, and the resources Q, R, and S, required to produce them.
Resource Usage Per Unit Produced
| Resource | Product A | Product B | Amount of Resource Available |
| Q | 2 | 1 | 2 |
| R | 1 | 2 | 2 |
| S | 3 | 3 | 4 |
Profit/Unit $3000 $2000
All the assumptions of linear programming hold.
E* a. Formulate and solve a linear programming model for this problem on a spreadsheet.
b. Formulate this same model algebraically.
Deliverable: Word Document 