Adam Enterprises manufactures two products. Each product can be produced on either of two machines. The time (in hours) required to make each product on each machine is shown below: Each month, 500 hours of time are available on each machine, and also customers are willing to buy up to the quantities of each product at the prices shown below: The company's goal is to maximize the revenue obtained from selling units during the next two months.
-(A) Determine how the company can meet its goal. Assume that Adam will not produce any units in either month that it cannot sell in that month.
(B) Referring to (A), suppose Adam wants to see what will happen if customer demands for each product in each month simultaneously change by a factor 1 + k. Revise the model so that you can use the SolverTable add-in to investigate the effect of this change on total revenue as k varies from -0.3 to 0.3 in increments of 0.1. Does revenue change in a linear manner over this range? Can you explain intuitively why it changes in the way it does?

Question

Adam Enterprises manufactures two products. Each product can be produced on either of two machines. The time (in hours) required to make each product on each machine is shown below:  Each month, 500 hours of time are available on each machine, and also customers are willing to buy up to the quantities of each product at the prices shown below:  The company's goal is to maximize the revenue obtained from selling units during the next two months.
-(A) Determine how the company can meet its goal. Assume that Adam will not produce any units in either month that it cannot sell in that month.
(B) Referring to (A), suppose Adam wants to see what will happen if customer demands for each product in each month simultaneously change by a factor 1 + k. Revise the model so that you can use the SolverTable add-in to investigate the effect of this change on total revenue as k varies from -0.3 to 0.3 in increments of 0.1. Does revenue change in a linear manner over this range? Can you explain intuitively why it changes in the way it does?

Quizplus · Accepted Answer

The Answer of Adam Enterprises manufactures two products. Each product can be produced on either of two machines. The time (in hours) required to make each product on each machine is shown below:  Each month, 500 hours of time are available on each machine, and also customers are willing to buy up to the quantities of each product at the prices shown below:  The company's goal is to maximize the revenue obtained from selling units during the next two months.
-(A) Determine how the company can meet its goal. Assume that Adam will not produce any units in either month that it cannot sell in that month.
(B) Referring to (A), suppose Adam wants to see what will happen if customer demands for each product in each month simultaneously change by a factor 1 + k. Revise the model so that you can use the SolverTable add-in to investigate the effect of this change on total revenue as k varies from -0.3 to 0.3 in increments of 0.1. Does revenue change in a linear manner over this range? Can you explain intuitively why it changes in the way it does?

Adam Enterprises Manufactures Two Products