The city council of Fayetteville is in the process of approving the construction of a new 200,000-ft convention center. Two sites have been proposed, and both require exercising the "eminent domain" law to acquire the property. The following about proposed (contiguous) properties in both sites together with the acquisition cost. table provides data

The city council of Fayetteville is in the process of approving the construction of a new 200,000-ft convention center. Two sites have been proposed, and both require exercising the "eminent domain" law to acquire the property. The following about proposed (contiguous) properties in both sites together with the acquisition cost. table provides data

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Metro has initiated discussions on attracting rail service. A depot would need to be constructed, which would require $2.5million in land and $7.5 million in construction costs. Annual operating and maintenance costs (O&M) for the facility would be $150,000, and personnel costs would be an additional $110,000. Other assorted costs would be born by the railroad and federal authorities. Annual benefits (B) of the rail service are estimated as listed: $120,000 for Railroad annual payments, $25,000 for Rail tax charged to passengers, $20,000 for Convenience benefits to local residents, and $12,000 for Additional tourism dollars for Metro. Apply the B-C ratio method, with a MARR of 8% per year and 20 year study period, to determine if the rail service should be established. a. BC ratio=2.12, good project b. BC ratio=-1.76, good project c. BC ratio=1.69, good project d. BC ratio=0.14, not good project
A battery manufacturing plant has been ordered to cease discharging acidic waste liquids containing mercury into the city sewer system. As a result, the firm must now adjust the pH and remove the mercury from its waste liquids. Quotations from three firms are included in the following table of costs. Bidder Installed Cost Annual Operating Cost Annual Income from Mercury Recovery Salvage Value Foxhill $ 70,000 $5000 $6500 $10,000 Instrument Quicksilver 50,000 5000 2500 0 Almaden 90,000 5000 7800 10,000 If the installation will last 15 years and money is worth 12%, which equipment should be purchased?
Carlisle Tire and Rubber, Inc., is considering expanding production to meet potential increases in the demand for one of its tire products. Carlisle’s alternatives are to construct a new plant, expand the existing plant, or do nothing in the short run. The market for this particular tire product may expand, remain stable, or contract. Carlisle’s marketing department estimates the probabilities of these market outcomes to be 0.25, 0.35, and 0.40, respectively. The file P09_31.xlsx contains Carlisle’s payoffs and costs for the various combinations of decisions and outcomes. a. Use PrecisionTree to identify the strategy that maximizes this tire manufacturer’s expected profit. b. Perform a sensitivity analysis on the optimal decision, letting each of the monetary inputs vary one at a time plus or minus 10% from its base value, and summarize your findings. Which of the inputs appears to have the largest effect on the best solution? Tire plant decisions Decision\outcome…
Carlisle Tire and Rubber, Inc., is considering expanding production to meet potential increases in the demand for one of its tire products. Carlisle’s alternatives are to construct a new plant, expand the existing plant, or do nothing in the short run. The market for this particular tire product may expand, remain stable, or contract. Carlisle’s marketing department estimates the probabilities of these market outcomes to be 0.25, 0.35, and 0.40, respectively. The file P06_31.xlsx (picture of given excel file is attached) contains Carlisle’s payoffs and costs for the various combinations of decisions and outcomes. Identify the strategy that maximizes this tire manufacturer’s expected profit. Perform a sensitivity analysis on the optimal decision, letting each of the monetary inputs vary one at a time plus or minus 10% from its base value, and summarize your findings. Which of the inputs appears to have the largest effect on the best solution?
(Provide complete decision table solution) which decision alternative has a minimum payoff value from the maximum regrets? a. construct a facility in talisay b. both construct a facility in talisay and subcontracting ohlala move c. hire additional drivers in mandaue d. sobcontracting ohlala move what realism approach decision alternative has maximum payoff? a. construct a facility in talisay b. both hire additional drivers in mandaue and construct a facility in talisay c. hire additional drivers in mandaue d. sobcontracting ohlala move which equally likely decision alternative has the best payoff value? a. construct a facility in talisay b. hire additional drivvers in mandaue c. either subcontracting ohlala move or construct a facility in talisay d. subcontracting ohlala move.
A company that produces pleasure boats has decided to expand one of its lines. Current facilities are insufficient to handle the increased workload, so the company is considering three alternatives. A (new location), B (subcontract), and C (expand existing facilities). Alternative A would involve substantial fixed costs but relatively low variable costs: fixed costs would be $315,000 per year, and variable costs would be $600 per boat. Subcontracting would involve a cost per boat of $2,580, and expansion would require an annual fixed cost of $58,000 and a variable cost of $1,040 per boat. a. Find the range of output for each alternative that would yield the lowest total cost. (Leave no cells blank be certain to enter "0" wherever required. Round your answers to the nearest whole number.) A B C or to OA OB OC to more b. Which alternative would yield the lowest total cost for an expected annual volume of 90 boats? c. What other factors might be considered in choosing between expansion…
A company that produces pleasure boats has decided to expand one of its lines. Current facilities are insufficient to handle the increased workload, so the company is considering three alternatives, A (new location), B (subcontract), and C (expand existing facilities). Alternative A would involve substantial fixed costs but relatively low variable costs: fixed costs would be $250,000 per year, and variable costs would be $500 per boat. Subcontracting would involve a cost per boat of $2,500, and expansion would require an annual fixed cost of $50,000 and a variable cost of $1,000 per boat. a. Find the range of output for each alternative that would yield the lowest total cost. (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to the nearest whole number. Do not include the indifference point in your answer.) A B C → OA OB OC or to to more b. Which alternative would yield the lowest total cost for an expected annual volume of 150 boats? C. What other…
Carlisle Tire and Rubber, Inc., is considering expanding production to meet potential increases in the demand for one of its tire products. Carlisle's alternatives are to construct a new plant, expand the existing plant, or do nothing in the short run. The market for this particular tire product may improve, remain stable, or contract. The table below presents the payoff matrix. Improve Remain stable Contract Construct a new plant $400,000 -$100,000 -$200,000 Expand existing plant $250,000 -$50,000 -$75,000 Do nothing $50,000 $0 -$30,000 Considered the problem statement and data table above. Under the Minimax Regret decision rule, the optimal decision is [Select] Y.The corresponding value for the optimal decision is [Select]
7. Suisan Fish Company must decide whether to build a small or a large warehouse at a new location, Kona. Demand at Kona can be either low or high, with probabilities estimated to be 0.4 and 0.6, respectively. If a small warehouse is built, and demand is high, the fish manager may choose to maintain the current size or to expand. The net present value of profits is $220,000 if the company chooses not to expand. However, if the firm chooses to expand, there is a 50% chance that the net present value of the returns will be $330,000 and a 50% chance the estimated net present value of profits will be $220,000. If a small warehouse is built and demand is low, there is no reason to expand and the net present value of the profits is $210,000. However, if a large warehouse is built and the demand turns out to be low, the choice is to do nothing with a net present value of $25,000 or to stimulate demand through local advertising. The response to advertising can be either modest with a…
A company that produces pleasure boats has decided to expand one of its lines. Current facilities are insufficient to handle the increased workload, so the company is considering three alternatives, A (new location), B (subcontract), and C (expand existing facilities).Alternative A would involve substantial fixed costs but relatively low variable costs: fixed costs would be $260,000 per year, and variable costs would be $610 per boat. Subcontracting would involve a cost per boat of $2,570, and expansion would require an annual fixed cost of $61,000 and a variable cost of $1,090 per boat.
Scenario: The Greater Toronto Airports Authority is expanding again to accommodate the increasing number of flights being routed through Toronto. Plans are currently being developed to build another airport outside the city limits. Two possible locations have been identified, but a final decision on the new location is not expected to be made for another year. The WelcomeStay chain of hotels intends to build a new facility near the new airport once its site is determined. Kirsten Brown is responsible for real estate acquisitions for the company, and she faces a difficult decision about where to buy land. Currently, land values around the two possible sites for the new airport are increasing as investors speculate that property values will increase greatly in the vicinity of the new airport. The Cashflows-and-Payoff worksheet summarizes (1) the current price of each parcel of land, (2) the estimated present value of future cash flows that a hotel would generate at each site if the…
Harden College is contemplating opening a Europeancampus where students from the main campus could go to take courses for 1 of the 4 college years. At the moment, it is con-sidering five countries: The Netherlands, Great Britain, Italy, Belgium, and Greece. The college wishes to consider eight factorsin its decision. The first two factors are given weights of 0.2, whilethe rest are assigned weights of 0.1. The following table illustratesits assessment of each factor for each country (5 is best). issue