A company manufactures mechanical heart valves from the heart valves of pigs. Different heart operations require valves of different sizes. The company purchases pig valves from three different suppliers. The cost and size mix of the valves purchased from each supplier are given in the file P03_36.xlsx. This file also contains the maximum number of valves available from each supplier per month. Each month, the company places an order with each supplier. At least 1300 large, 900 medium, and 400 small valves must be purchased each month.
1. Use Solver to determine how the company can minimize the cost of acquiring the needed valves.
2. Use SolverTable to investigate the effect on total cost of increasing its minimal purchase requirements each month. Specifically, see how the total cost changes as the minimal purchase requirements of large, medium, and small valves all increase from their original values by the same percentage. Revise your model so that SolverTable can be used to investigate these changes when the percentage increase varies from 2% to 40% in increments of 2%.
Answers: 3
Another question on Business
Business, 21.06.2019 20:20
If the demand for a pair of shoes is given by 2p + 5q = 200 and the supply function for it is p â 2q = 10, compare the quantity demanded and the quantity supplied when the price is $90. quantity demanded pairs of shoes quantity supplied pairs of shoes will there be a surplus or shortfall at this price? there will be a surplus. there will be a shortfall.
Answers: 3
Business, 21.06.2019 21:00
Suppose an economist believes that the price level in the economy is directly related to the money supply, or the amount of money circulating in the economy. the economist proposes the following relationship: p=a x m - p=price level - m=money supply - a=a composite of other factors, including real gdp, that change very slowly over time. how might an economist gather empirical data to test the proposed relationship between money and the price level? an economist would persuade the federal reserve to change the money supply to various levels, and observe the resulting changes in the price level. unlike researchers in the hard sciences, economists cannot study complex relationships using data. economists do not usually develop theoretical models of the economy but only analyze summary statistics about the current state of the economy. an economist would look for data on past changes in the money supply, and note the resulting changes in the price level
Answers: 1
Business, 22.06.2019 07:10
mark, a civil engineer, entered into a contract with david. as per the contract, mark agreed to design and build a house for david for a specified fee. mark provided david with an estimation of the total cost and the contract was mutually agreed upon. however, during construction, when mark increased the price due to a miscalculation on his part, david refused to pay the amount. this scenario is an example of a mistake.
Answers: 1
Business, 22.06.2019 20:20
John has served as the chief operating officer (coo) for business graphics, inc., a publicly owned firm, the past 5 years. which of the following statements about john is correct? both john and the ceo of business graphics must certify to the sec that the firm's financial statements are accurate. as the coo, john will be ranked higher than the ceo but still below the cfo. in john's postition as the coo, it is highly unlikely that he would also be the chairperson of the board of directors. as the coo, john would typically be involved with accounting, finance, and asset purchase decisions.
Answers: 2
You know the right answer?
A company manufactures mechanical heart valves from the heart valves of pigs. Different heart operat...
Questions
Computers and Technology, 21.12.2019 02:31
