# Question: A manufacturing company makes two products Each product can be

A manufacturing company makes two products. Each product can be made on either of two machines. The time (in hours) required to make each product on each machine is listed in the file S13_33.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 same file. 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 this goal. Assume that it will not produce any units in a month that it cannot sell in that month.

b. Use SolverTable to see what happens 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?

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

b. Use SolverTable to see what happens 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?

**View Solution:**## Answer to relevant Questions

There are three factories on the Momiss River. Each emits two types of pollutants, labeled P1 and P2, into the river. If the waste from each factory is processed, the pollution in the river can be reduced. It costs $1500 to ...A textile company produces shirts and pants. Each shirt requires two square yards of cloth, and each pair of pants requires three square yards of cloth. During the next two months the following demands for shirts and pants ...In the original Red Brand problem, suppose the plants cannot ship to each other and the customers cannot ship to each other. Modify the model appropriately, and rerun Solver. How much does the total cost increase because of ...Continuing the previous problem (with capacity 300 at plant 2), suppose you want to see how much extra capacity and extra demand you can add to plant 1 and region 2 (the same amount to each) before the total shipping cost ...SureStep is currently getting 160 regular-time hours from each worker per month. This is actually calculated from 8 hours per day times 20 days per month. For this, they are paid $9.375 per hour (=1500/160). Suppose workers ...Post your question