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!"

