solution

A companymakestwo 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 useSolver tomaximize the total profit. Use the results to answer the following questions.

(ps I need it in formula view) thank you

A. What is the total profit? ____________________

B. Product A number of units? ____________________

C. Product B number of units? ____________________

D. Resource X total? ____________________

Product A

Product B

Total Resources Available

Resource X

0

4

140

Resource Y

4

8

296

Resource Z

6

0

186

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"