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. 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 0 4 140 Resource Y 4 8 296 Resource Z 6 0 186
A. What is the total profit? ____________________
B. Product A number of units? ____________________
C. Product B number of units? ____________________
D. Resource X total? ____________________