# Question: A pharmaceutical company manufactures two drugs at Los Angeles and

A pharmaceutical company manufactures two drugs at Los Angeles and Indianapolis. The cost of manufacturing a pound of each drug depends on the location, as indicated in the file S13_42.xlsx. The machine time (in hours) required to produce a pound of each drug at each city is also shown in this table. The company must produce at least 1000 pounds per week of drug 1 and at least 2000 pounds per week of drug 2. It has 500 hours per week of machine time at Indianapolis and 400 hours per week at Los Angeles.

a. Determine how the company can minimize the cost of producing the required drugs.

b. Use SolverTable to determine how much the company would be willing to pay to purchase a combination of A extra hours of machine time at Indianapolis and B extra hours of machine time at Los Angeles, where A and B can be any positive multiples of 10 up to 50.

a. Determine how the company can minimize the cost of producing the required drugs.

b. Use SolverTable to determine how much the company would be willing to pay to purchase a combination of A extra hours of machine time at Indianapolis and B extra hours of machine time at Los Angeles, where A and B can be any positive multiples of 10 up to 50.

## Answer to relevant Questions

A company manufactures two products on two machines. The number of hours of machine time and labor depends on the machine and product as shown in the file S13_43.xlsx. The cost of producing a unit of each product depends on ...In the original Red Brand problem, the costs for shipping from plants or warehouses to customer 2 were purposely made high so that it would be optimal to ship to customer 1 and then let customer 1 ship to customer 2. Use ...Modify the original Grand Prix example by increasing the demand at each regions by 200, so that total demand is well above total plant capacity. However, now interpret these “demands” as “maximum sales,” the most ...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 ...In the pension fund problem, suppose there is a fourth bond, bond 4. Its unit cost in 2010 is $1020; it returns coupons of $70 in years 2011 through 2016 and a payment of $1070 in 2017. Modify the model to incorporate this ...Post your question