A and B 12.1-3. A real estate development firm, Peterson and Johnson, isconsidering five possible development projects. The following tableshows the estimated long-run profit (net present value) that eachproject would generate, as well as the amount of investment re-quired to undertake the project, in units of millions of dollars.Development Project1234511.81.60.81.4Estimated profitCapital required6121048The owners of the firm, Dave Peterson and Ron Johnson, haveraised $20 million of investment capital for these projects. Daveand Ron now want to select the combination of projects that willmaximize their total estimated long-run profit (net present value)without investing more that $20 million.(a) Formulate a BIP model for this problem.(b) Display this model on an Excel spreadsheet.c (c) Use the computer to solve this model.

Answered: (a) Formulate a BIP model for this…

Business

Operations Management

(a) Formulate a BIP model for this problem. (b) Display this model on an Excel spreadsheet.

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

33. In the early stages of a Risk Assessment, one must consider what when picking a subject of study: a Scope of the problem/issue b The extent of the risk to humans c The probability of exposure d Funding opportunities
Corporate triple-A bond interest rates for 12 consecutive months follow. (a) Construct a time series plot. 11.01 10.5 10.0 9.5- FEFE 9.0- 8.5 8.0 7.5- 2 1 4 11.01 5 10.5 3 6 10.0 7 9.6 9.3 9.4 9.6 9.9 9.8 9.8 10.6 10.0 9.7 9.7 9.6 What type of pattern exists in the data? O The data appear to follow a seasonal pattern. O The data appear to follow a cyclical pattern. O The data appear to follow a horizontal pattern. O The data appear to follow a trend pattern. 8 Month 9 10 9.5 11 9.0 12 8.5 8.0 7.5 7.0 0 1 2 3 4 5 6 7 8 9 10 11 12 13 Month (b) Develop three-month and four-month moving averages for this time series. (Round your answers to two decimal places.) Time Series Value 3-Month Moving Average Forecast 4-Month Moving Average Forecast 9.6 9.3 9.4 9.6 9.9 9.8 9.8 10.6 10.0 9.7 9.7 9.6 | | [ | Ⓒ L 11.0 T T 들 10.5 10.0- 9.5 9.0 8.5 8.0 7.5 7.0 0 1 2 3 4 5 6 7 8 9 10 11 12 13 Month 0° 7.0 0 1 2 3 4 5 6 7 8 9 10 11 12 13 Month Does the three-month or four-month moving average provide more…
4. Transrail is bidding on a project that it figures will cost $400,000 to perform. Using a 25% markup, it will charge $500,000, netting a profit of $100,000. However, it has been learned that another company, Rail Freight, is also considering bidding on the project. If Rail Freight does submit a bid, it figures to be a bid about $470,000. Transrail really wants this project and is considering a bid with only a 15% markup to $460,000 to ensure winning regardless of whether or not Rail Freight submits a bid. a. Prepare a profit payoff table from Transrail’s point of view. (6 points) b. For this payoff table find Transrail’s optimal decision using (1) the pessimistic approach, (2) the optimistic approach, and (3) minimax regret approach. (10 points) c. If Rail Freight is known to submit bids on only 25% of the projects it considers, what decision should Transrail make? (5 points) d. Given the information in (c), what is EVPI? (5 points)
The following data were taken from the financial statements of Loveseth Inc. for the current fiscal year. Property, plant, and equipment (net) $1,826,200 Liabilities: Current liabilities $160,000 Note payable, 6%, due in 15 years 794,000 Total liabilities $954,000 Stockholders' equity: Preferred $2 stock, $100 par (no change during year) $715,500 Common stock, $10 par (no change during year) 715,500 Retained earnings: Balance, beginning of year $764,000 Net income 359,000 $1,123,000 Preferred dividends $14,310 Common dividends 154,690 169,000 Balance, end of year 954,000 Total stockholders' equity $2,385,000 Sales $16,603,050 Interest expense $47,640 Assuming that total assets were $3,172,000 at the beginning of the current fiscal year, determine the following: When required, round to one decimal place. a. Ratio of fixed assets to long-term liabilities b. Ratio of liabilities to stockholders' equity c. Asset turnover d. Return on total assets e. Return on stockholders' equity % f.…
Maximax, Maximin, Minimax RegretLearning material: Watch this videoLab Scenario:Imagine a local entrepreneur is considering starting a business and has three options: open a coffeeshop, a bookshop, or a fusion coffee-bookshop. The entrepreneur is uncertain about the market'sreaction to these businesses. The possible market conditions are: favorable, neutral, and unfavorable.Data (Payoff Table in USD):Business Option Favorable Market Neutral Market Unfavorable MarketCoffee Shop 150,000 70,000 -30,000Bookshop 100,000 60,000 -20,000Fusion Shop 130,000 80,000 -10,000Positive values represent profits, and negative values represent losses.Assignment Steps:1. Maximax (Optimist's Criterion) Approach:For each business option, identify the maximum possible payoff.First Question What is the business option with the highest of these maximum payoffs? (5points)2. Maximin (Pessimist's Criterion) Approach:For each business option, identify the minimum possible payoff.Second Question What is the…
31. among the following variances. which of them does not need a corrective action? a. 200,000 b. 50,000 c. -750,000 d. 0
In Benefit/cost ratio analysis, if the salvage value is used to recover the first cost, it is being considered as: Select one: a. negative cost b. cost c. benefit d. disbenefit =================== Ali takes out a loan at 10 percent compounded annually for 7 years. At the end of this period, he pays off the loan at a value of $23,384.61. What amount did he borrow? Select one: a. $12,000.00 b. $15,000.00 c. $14,000.00 d. $13,000.00 ============= While considering the engineering economy concepts, the most important tense almost all exercises deal with is the annual worth. Select one: True False Ans all
Seneca Hill Winery recently purchased land for the purpose of establishing a new vineyard. Management is considering two varieties of white grapes for the new vineyard: Chardonnay and Riesling. The Chardonnay grapes would be used to produce a dry Chardonnay wine, and the Riesling grapes would be used to produce a semidry Riesling wine. It takes approximately four years from the time of planting before new grapes can be harvested. This length of time creates a great deal of uncertainty concerning future demand and makes the decision concerning the type of grapes to plant difficult. Three possibilities are being considered: Chardonnay grapes only; Riesling grapes only; and both Chardonnay and Riesling grapes. Seneca management decided that for planning purposes it would be adequate to consider only two demand possibilities for each type of wine: strong or weak. With two possibilities for each type of wine it was necessary to assess four probabilities. With the help of some forecasts in…
Seneca Hill Winery recently purchased land for the purpose of establishing a new vineyard. Management is considering two varieties of white grapes for the new vineyard: Chardonnay and Riesling. The Chardonnay grapes would be used to produce a dry Chardonnay wine, and the Riesling grapes would be used to produce a semidry Riesling wine. It takes approximately four years from the time of planting before new grapes can be harvested. This length of time creates a great deal of uncertainty concerning future demand and makes the decision concerning the type of grapes to plant difficult. Three possibilities are being considered: Chardonnay grapes only; Riesling grapes only; and both Chardonnay and Riesling grapes. Seneca management decided that for planning purposes it would be adequate to consider only two demand possibilities for each type of wine: strong or weak. With two possibilities for each type of wine it was necessary to assess four probabilities. With the help of some forecasts in…
Identify the Information System that would generate the type of report shown below. DOEJOE INC. STATEMENT OF OWNER'S EQUITY FOR MONTH OF AUGUST 21, 2022 JOHN DOE, CAPITAL, AUGUST 31, 2022 INVESTMENT DURING THE PERIOD NET INCOME FOR PERIOD SUBTOTAL WITHDRAWLS DURING THE PERIOD NET LOSSES FOR PERIOD JOHN DOE, CAPITAL, AUGUST 31, 2022 O a. Management Information System O b. Decision support system O c. Business Intelligence Dashboard Od. Transaction processing system 4,000.00 1,000.00 2,000.00 $ 7,000.00 2,000.00 $5,000.00
Given the following payoff table with the profits ($m), a firm might expect alternative investments (A, B, C) under different levels of interest rate. payoffs as profits states of nature 1(5%) decision 2(7%) 3(9%) alternatives A 14 22 6. B 19 18 11 12 17 15 (a) Which alternative should the firm choose under the maximax criterion? (b) Which option should the firm choose under the maximin criterion? (c) Which option should the firm choose under the LaPlace criterion? (d) Which option should the firm choose with the Hurwicz criterion with a = 0.2? (e) Using a minimax regret approach, what alternative should the firm choose? (f) Economists have assigned probabilities of 0.35, 0.3, and 0.35 to the possible interest levels 1, 2, and 3 respectively. Using expected monetary values, what option should be chosen and what is that optimal expected value? (g) What is the most that the firm should be willing to pay for additional information? Use Expected Regre (h) Use the alternative method to…
8. List three issues that must be dealt with in an effective strategy for dealing with risk.