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 theExam 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	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? ____________________