A company makes two products - product A and product B which are sold at a profit
Question:
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? ____________________
Managing Business Process Flows Principles of Operations Management
ISBN: 978-0136036371
3rd edition
Authors: Ravi Anupindi, Sunil Chopra, Sudhakar Deshmukh, Jan Van Mieg