A company makes two products – product A and product

A company makes two products – product A and product B which are sold at a profit per unit of $60 and $100, respectively. The three resources used to make these products are summarized in the table below. The excel model setup is provided in the Exam 1 Excel Template. Complete the excel model spreadsheet by entering the required totals calculations and use Solver to maximize the total profit. Use the results to answer the following questions. Product A Product B Total Resources Available Resource X 12 0 372 Resource Y 8 16 592 Resource Z 8 8 280

A. What is the total profit? ____________________

B. Product A number of units? ____________________

C. Product B number of units? ____________________

D. Resource X total? ____________________