# Question: A pharmaceutical company produces the drug NasaMist from four chemicals

A pharmaceutical company produces the drug NasaMist from four chemicals. Today, the company must produce 1000 pounds of the drug. The three active ingredients in NasaMist are A, B, and C. By weight, at least 8% of NasaMist must consist of A, at least 4% of B, and at least 2% of C. The cost per pound of each chemical and the amount of each active ingredient in one pound of each chemical are given in the file S14_80.xlsx. It is necessary that at least 100 pounds of chemical 2 be used.

a. Determine the cheapest way of producing today’s batch of NasaMist.

b. Use SolverTable to see how much the percentage of requirements of A is really costing the company. Let the percentage required vary from 6% to 12%.

a. Determine the cheapest way of producing today’s batch of NasaMist.

b. Use SolverTable to see how much the percentage of requirements of A is really costing the company. Let the percentage required vary from 6% to 12%.

## Answer to relevant Questions

A bank is attempting to determine where to invest its assets during the current year. At present, $500,000 is available for investment in bonds, home loans, auto loans, and personal loans. The annual rates of return on each ...The government is auctioning off oil leases at two sites: 1 and 2. At each site 10,000 acres of land are to be auctioned. Cliff Ewing, Blake Barnes, and Alexis Pickens are bidding for the oil. Government rules state that no ...You are given the following means, standard deviations, and correlations for the annual return on three potential investments. The means are 0.12, 0.15, and 0.20. The standard deviations are 0.20, 0.30, and 0.40. The ...An oil company has oil fields in San Diego and Los Angeles. The San Diego field can produce up to 500,000 barrels per day, and the Los Angeles field can produce up to 400,000 barrels per day. Oil is sent from the fields to a ...Use @RISK to draw a normal distribution with mean 500 and standard deviation 100. Then answer the following questions.a. What is the probability that a random number from this distribution is less than 450?b. What is the ...Post your question