A certain medical device will result in an estimated $15,000 reduction in hospital labor expenses during its first year of operation. Labor expenses (and thus savings) are projected to increase at a rate of 7% per year after the first year. Additional operating expenses for the device (maintenance, electric power, etc.) are $3,500 annually, and they increase by $250 per year there after (i.e., $3,750 in year two and so on). It is anticipated that the device will last for 10 years and will have no market value at that time. If theMARR is 10 % per year, how much can the hospital afford to pay for this device? Use an Excel spreadsheet in your solution.

A certain medical device will result in an estimated $15,000 reduction in hospital labor expenses during its first year of operation. Labor expenses (and thus savings) are projected to increase at a rate of 7% per year after the first year. Additional operating expenses for the device (maintenance, electric power, etc.) are $3,500 annually, and they increase by $250 per year there after (i.e., $3,750 in year two and so on). It is anticipated that the device will last for 10 years and will have no market value at that time. If theMARR is 10 % per year, how much can the hospital afford to pay for this device? Use an Excel spreadsheet in your solution.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

It costs a pharmaceutical company 75,000 to produce a 1000-pound batch of a drug. The average yield from a batch is unknown but the best case is 90% yield (that is, 900 pounds of good drug will be produced), the most likely case is 85% yield, and the worst case is 70% yield. The annual demand for the drug is unknown, with the best case being 20,000 pounds, the most likely case 17,500 pounds, and the worst case 10,000 pounds. The drug sells for 125 per pound and leftover amounts of the drug can be sold for 30 per pound. To maximize annual expected profit, how many batches of the drug should the company produce? You can assume that it will produce the batches only once, before demand for the drug is known.
Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the companys mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs 2 to send a catalog, and the average profit per order is 30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?
The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.
Lemingtons is trying to determine how many Jean Hudson dresses to order for the spring season. Demand for the dresses is assumed to follow a normal distribution with mean 400 and standard deviation 100. The contract between Jean Hudson and Lemingtons works as follows. At the beginning of the season, Lemingtons reserves x units of capacity. Lemingtons must take delivery for at least 0.8x dresses and can, if desired, take delivery on up to x dresses. Each dress sells for 160 and Hudson charges 50 per dress. If Lemingtons does not take delivery on all x dresses, it owes Hudson a 5 penalty for each unit of reserved capacity that is unused. For example, if Lemingtons orders 450 dresses and demand is for 400 dresses, Lemingtons will receive 400 dresses and owe Jean 400(50) + 50(5). How many units of capacity should Lemingtons reserve to maximize its expected profit?
A convenience store manager earns a base salary plus a small bonus of $190 for each of ten different possible monthly milestones he meets. If the manager meets a milestone, the full bonus is paid. However, if the manager falls even one penny short, none of that bonus is paid. Suppose each of the ten milestones requires 40 hours of effort to meet, and that the manager has 160 hours of effort to allocate to work each month. Question: In order to maximize the total monthly bonus, the manager should allocate___hours toward meeting each of ___ milestones and ___hours toward meeting each of the remaining___ sales milestones. There are 4 blanks to fill for this question
An electronics firm is currently manufacturing an item that has a variable cost of $0.50 per unit and a selling price of $1.10 per unit. Fixed costs are $15,000. Current volume is 30,000 units. The firm can substantially improve the product quality by adding a new piece of equipment at an additional fixed cost of $5,600. Variable cost would increase to $0.65 and the selling price would be revised to $1.30 with the expectation that the volume would be 50,000 units as a result of a higher-quality product. If the firm does not add new equipment, its profit will be =_____ dollars (round your response to the nearest whole number and include a minus sign if the profit is negative).
Lauren Moore has sold her business for $500,000 and wants to invest in condominium units (which she intends to rent) and land (which she will lease to a farmer). She estimates thatshe will receive an annual return of $8,000 for each condominium and $6,000 for each acre of land. A condominium unit costs $70,000, and land costs $30,000 per acre. A condominium will cost her $1,000 per unit. an acre of land will cost $2,000 for maintenance and upkeep, and $14,000 has been budgeted for these annual expenses. Lauren wants to know how much to invest in condominiums and land to maximize her annual return. a. Formulate a mixed integer programming model for this problem. b. Solve this model by using the computer.
A catering company must have the following number of clean napkins available at the beginning of each of the next four days: day 1: 15, day 2: 12, day 3: 18, and day 4: 6. After being used, a napkin can be cleaned by one of two methods: fast service or slow service. Fast service costs $0.10 per napkin, and a napkin cleaned via fast service is available for use the day after it is last used. Slow service costs $0.06 per napkin, and a napkin cleaned via slow service is available two days after they were last used. New napkins can be purchased for a cost of $0.20 per napkin. Part A: Formulate the problem as a minimum cost transportation problem.
A catering company must have the following number of clean napkins available at the beginning of each of the next four days: day 1: 15, day 2: 12, day 3: 18, and day 4: 6. After being used, a napkin can be cleaned by one of two methods: fast service or slow service. Fast service costs $0.10 per napkin, and a napkin cleaned via fast service is available for use the day after it is last used. Slow service costs $0.06 per napkin, and a napkin cleaned via slow service is available two days after they were last used. New napkins can be purchased for a cost of $0.20 per napkin. Part A: Formulate the problem as a minimum cost transportation problem. Part B: Solve the problem (provide exact values for all variables and the optimal objective function).
You are thinking of making your mansion more energy efficient by replacing some of the light bulbs with compact fluorescent bulbs, and insulating part or all of your exterior walls. Each compact fluorescent light bulb costs $4 and saves you an average of $2 per year in energy costs, and each square foot of wall insulation costs $1 and saves you an average of $0.20 per year in energy costs.† Your mansion has 150 light fittings and 2,900 square feet of uninsulated exterior wall. To impress your friends, you would like to spend as much as possible, but save no more than $900 per year in energy costs (you are proud of your large utility bills). How many compact fluorescent light bulbs and how many square feet of insulation should you purchase? How much will you save in energy costs (in dollars) per year? (If an answer does not exist, enter DNE.)
Lauren Moore has sold her business for $500,000 and wants to invest in condominium units (which she intends to rent) and land (which she will lease to a farmer). She estimates that she will receive an annual return of $8,000 for each condominium and $6,000 for each acre of land. A condominium unit costs $70,000, and land costs $30,000 per acre. A condominium will cost her $1,000 per unit, an acre of land will cost $2,000 for maintenance and upkeep, and $14,000 has been budgeted for these annual expenses. Lauren wants to know how much to invest in condominiums and land to maximize her annual return. Requirements:a) Define decision variables and tabulated datab) Formulate the Integer Linear Programming Model.