Alden Enterprises produces two products. Each product can be produced on either of two machines. The time

Question:

Alden Enterprises produces two products. Each product can be produced on either of two machines. The time (in hours) required to produce each product on each machine is listed in the file P03_32.xlsx. Each month, 500 hours of time are available on each machine. Each month, customers are willing to buy up to the quantities of each product at the prices also given in the file P03_32.xlsx. The company’s goal is to maximize the revenue obtained from selling units during the next 2 months.

a. Determine how it can meet this goal. Assume that Alden will not produce any units in either month that it cannot sell in that month.

b. Suppose Alden 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 SolverTable 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?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Practical Management Science, Revised

ISBN: 9781118373439

3rd Edition

Authors: Wayne L Winston, S. Christian Albright

Question Posted: