The management of Brinkley Corporation is interested in using simulation to estimate the profit per unit for a new product. The selling price for the product will be $45 per unit. Probability distributions for the purchase cost, the labor cost, and the transportation cost are estimated as follows. Procurement Labor Cost ($) Probability Transportation Cost ($) Probability Probability Cost ($) 10 0.25 20 0.15 0.75 11 0.40 22 0.20 0.25 12 0.35 24 0.35 25 0.30 (a) Construct a simulation model to estimate the average profit (in $) per unit and the variance of the profit per unit. (Use at least 1,000 trials. Round your answer to two decimal places.) average variance What is a 95% confidence interval (in $) around this average? (Round your answers to two decimal places.) to $ (b) Management believes that the project may not be sustainable if the profit per unit is less than $5. Use simulation to estimate the probability that the profit per unit will be less than $5. (Use at least 1,000 trials. Round your answer to three decimal places.) What is a 95% confidence interval around this proportion? (Round your answers to three decimal places.) to
Q: Downtown Health Clinic needs to order influenza vaccines for the next flu season. The Clinic charges…
A: a) The expected number of vaccines can be calculated as follows: Thus, the clinic should order 4300…
Q: For the Orlando real estate investment problem, assume the probabilities for the gasoline shortage,…
A: Given data is
Q: a) Express this problem as a linear programming model with two decision variables. (b) Solve the…
A: Answer a) Let the decision variables be represented by x and y. Where the amount invested in the…
Q: Donald Harris received a windfall and needs to invest it for tax reasons. He went to his…
A: Given data, Future Air Traffic Strategies Major Downturn Downturn Upturn Major Upturn…
Q: The Megabus operates between New York City and Philadelphia and is a popular mode of transportation…
A: # of Passengers Who Show Up Probability 28 0.05 29 0.25 30 0.5 31 0.15 32 0.05
Q: of hybrid cars that have be requested for rental from a car rental office during a 50 day sample…
A: Demand for Cars Number of Days Probability 3 3…
Q: A NY Times best-selling author wants to write a new book as either volume II of her earlier…
A: Note: - As we can answer only up to three subparts we will answer the first three subparts here.…
Q: A business owner is planning to strategize his company's growth. He can either buy, rent, or lease a…
A: Here the option 2 is correct. Using the Laplace's method the company go for buy decision.
Q: From past experience, Anna knows that the probability that her friend will take her to dinner in…
A: the probability that her friend will take her to dinner in Orro Resto = 0.7 the probability that…
Q: CanaSystems is considering a project to build upscale condominiums. They are considering plans on a…
A: Opportunity loss is characterized as the contrast between the real result and the result that would…
Q: What is the mean arrival rate in jobs per hour? If required, round your answer to two decimal…
A: Since you have posted a question with multiple sub-parts, we will solve the first three subparts for…
Q: Hemmingway, Inc., is considering a $5 million research and development (R&D) project. Profit…
A: At Node 4, for building facility, the profit at high demand is 34 million with 0.5 probability, at…
Q: Your answer is partially correct. An independent contractor for a transportation company needs to…
A: The detailed solution is given in Step 2.
Q: A bakery must decide how many pies to prepare for the upcoming weekend. The bakery has the option to…
A: Given Information; Cost Price of a pie = $ 5 Selling Price of a pie = $ 7 Demand Probability…
Q: Your firm is considering purchasing an old office building with an estimated remaining service life…
A:
Q: A manager is trying to decide whether to build a small, medium, or large facility. Demand can be…
A: The maximin practice implicates choosing the option that maximizes all the minimum pay-off possible.…
Q: The time between arrivals of cars at the Petroco Service Station is defined by the following…
A:
Q: ACME, Inc. firm was trying to decide which of the four projects it should submit a bid for, There…
A: The decision tree is shown below.
Q: The management of a company is interested in using simulation to estimate the profit per unit for a…
A: From the given data we found that Selling price = $45/unit Purchase cost ($) Labour cost…
Q: A farmer must decide whether to take protective action to limit damage to his grapefruit crop in the…
A: The farmer decided to take a protective action to limit damage of his grapefruit crop . There are…
Q: Compute the EVPI 2- Determine the range over which each alternative would be best in terms of the…
A: Expected value of perfect information (EVPI) is the difference between the expected value with…
Q: PT. Corona is currently trying to determine the size of the computer system which will provide…
A: Given data is
Q: A large steel manufacturing company has three options with regard to production: Produce…
A: A Small Introduction about manufacturing company Manufacturing is the large-scale manufacturing of…
Q: The CEO of Lucky Petroleum Co. has been considering to open a new gasoline statioin. He must decide…
A: Find the Given details below: Given details: Size of Station Good Market Fair Market Poor…
Q: a.) Draw a decision tree. b.) Determine the expected payoff for each decision and event node. c.)…
A: A Small Introduction about Demand Market interest structure the most essential ideas of financial…
Q: Williams Auto has a machine that installs tires. The machine is now in need of repair. The…
A: Decision to either repair or replace the machine can be effectively taken by making a comparison…
Q: The management of Brinkley Corporation is interested in using simulation to estimate the profit per…
A: Hello thank you for the question. As per guidelines, we would provide only one answer at a time.…
Q: A farmer is trying to decide if continuing to farm is the correct thing to do. Yields on his fields…
A: A decision tree is the decision assistance tool that practices a tree-like pattern of decisions…
Q: A farmer must decide whether to take protective action to limit damage to his grapefruit crop in the…
A: The farmer must decide whether to take protective action to limit damage to his grapefruit crop…
Q: A manager is trying to decide whether to build a small, medium, or large facility. Demand can be…
A: Given data, Probabilities = 0.25, 0.40, 0.35 Demand is average expected to earn = $75000 Net…
Q: Jeffrey Mogul is a Hollywood film producer, and he is currently evaluating a script by a new…
A:
Q: A local real estate investor in Kingston is considering three alternative investments: a motel, a…
A: Decision making is a process which helps to identifying the best suitable decision from all…
Q: A new electric power generation plant is expected to cost $42,000,000 to complete. The revenues…
A: The question is related to the Capital Budgeting. IRR is the internal rate of return is the rate…
Q: A manager is trying to decide whether to build a small, medium, or large facility. Demand can be…
A: Option (A): It contains all the nodes with decision nodes. Hence, option (A) is incorrect. Option…
Q: Hemmingway, Inc., is considering a $5 million research and development (R&D) project. Profit…
A: Determine the expected value of the strategy as shown below: Calculate the expected value for node…
Q: A battery manufacturing plant has been ordered to cease discharging acidic waste liquids containing…
A: Bidder Installed Cost Annual Operating Cost Annual Income from Mercury Recovery…
Q: Suppose we are considering the question of how much capacity to build in the face of uncertain…
A: The probability of various demand levels is as follows: Demand – x units Probability of x 1 0…
Q: Construct a decision tree to help the farmer make his decision. What should he do? Explain your…
A: A decision tree is the analysis of the options that are to be considered or chosen among to take the…
Q: Downtown Health Clinic needs to order influenza vaccines for the next flu season. The Clinic charges…
A: Expected profit means the future value the company wants to earn by selling X units of products and…
Q: Hyewon Kim owns her own catering business. She continually monitors her other expense costs,…
A: Here we will talk about the instance of Hyewon Kim, who owns a catering business, Hyewon was advised…
Q: 10. An investor must decide between two alternative investments-stocks and bonds. The return for…
A: A payoff table refers to a table that can be used to represent and analyze a scenario that has a…
Q: Kualoa Corporation is trying to assess the risk of two possible capital budgeting proposals. The…
A: Range of annual cash inflows = optimistic cash inflow - pessimistic cash inflow ( highest value -…
Q: Palmer Jam Company is a small manufacturer of several different jam products. One product is an…
A: Expected monetary value (EMV) is a risk management technique that may be used to measure and analyze…
Q: A business owner is planning to strategize his company's growth. He can either buy, rent, or lease a…
A: Given information- The probability of business doing good = 0.7 The probability of a slow business…
Q: A company sells its products to wholesalers in batches of 1,000 units only. The daily demand for its…
A: Given data is
Q: perfect information on all cars
A: EVPI (expected value of perfect information) indicating the loss of unknow market state…
Q: The Dallas Mavericks trail by two points and have theball with 10 seconds remaining. They must…
A:
Q: 3-26 Megley Cheese Company is a small manufacturer of several different cheese products. One of the…
A: Given data is
6
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 4 images
- A common decision is whether a company should buy equipment and produce a product in house or outsource production to another company. If sales volume is high enough, then by producing in house, the savings on unit costs will cover the fixed cost of the equipment. Suppose a company must make such a decision for a four-year time horizon, given the following data. Use simulation to estimate the probability that producing in house is better than outsourcing. If the company outsources production, it will have to purchase the product from the manufacturer for 25 per unit. This unit cost will remain constant for the next four years. The company will sell the product for 42 per unit. This price will remain constant for the next four years. If the company produces the product in house, it must buy a 500,000 machine that is depreciated on a straight-line basis over four years, and its cost of production will be 9 per unit. This unit cost will remain constant for the next four years. The demand in year 1 has a worst case of 10,000 units, a most likely case of 14,000 units, and a best case of 16,000 units. The average annual growth in demand for years 2-4 has a worst case of 7%, a most likely case of 15%, and a best case of 20%. Whatever this annual growth is, it will be the same in each of the years. The tax rate is 35%. Cash flows are discounted at 8% per year.The DC Cisco office is trying to predict the revenue it will generate next week. Ten deals may close next week. The probability of each deal closing and data on the possible size of each deal (in millions of dollars) are listed in the file P11_55.xlsx. Use simulation to estimate total revenue. Based on the simulation, the company can be 95% certain that its total revenue will be between what two numbers?Based on Grossman and Hart (1983). A salesperson for Fuller Brush has three options: (1) quit, (2) put forth a low level of effort, or (3) put forth a high level of effort. Suppose for simplicity that each salesperson will sell 0, 5000, or 50,000 worth of brushes. The probability of each sales amount depends on the effort level as described in the file P07_71.xlsx. If a salesperson is paid w dollars, he or she regards this as a benefit of w1/2 units. In addition, low effort costs the salesperson 0 benefit units, whereas high effort costs 50 benefit units. If a salesperson were to quit Fuller and work elsewhere, he or she could earn a benefit of 20 units. Fuller wants all salespeople to put forth a high level of effort. The question is how to minimize the cost of encouraging them to do so. The company cannot observe the level of effort put forth by a salesperson, but it can observe the size of his or her sales. Thus, the wage paid to the salesperson is completely determined by the size of the sale. This means that Fuller must determine w0, the wage paid for sales of 0; w5000, the wage paid for sales of 5000; and w50,000, the wage paid for sales of 50,000. These wages must be set so that the salespeople value the expected benefit from high effort more than quitting and more than low effort. Determine how to minimize the expected cost of ensuring that all salespeople put forth high effort. (This problem is an example of agency theory.)
- In August of the current year, a car dealer is trying to determine how many cars of the next model year to order. Each car ordered in August costs 20,000. The demand for the dealers next year models has the probability distribution shown in the file P10_12.xlsx. Each car sells for 25,000. If demand for next years cars exceeds the number of cars ordered in August, the dealer must reorder at a cost of 22,000 per car. Excess cars can be disposed of at 17,000 per car. Use simulation to determine how many cars to order in August. For your optimal order quantity, find a 95% confidence interval for the expected profit.An automobile manufacturer is considering whether to introduce a new model called the Racer. The profitability of the Racer depends on the following factors: The fixed cost of developing the Racer is triangularly distributed with parameters 3, 4, and 5, all in billions. Year 1 sales are normally distributed with mean 200,000 and standard deviation 50,000. Year 2 sales are normally distributed with mean equal to actual year 1 sales and standard deviation 50,000. Year 3 sales are normally distributed with mean equal to actual year 2 sales and standard deviation 50,000. The selling price in year 1 is 25,000. The year 2 selling price will be 1.05[year 1 price + 50 (% diff1)] where % diff1 is the number of percentage points by which actual year 1 sales differ from expected year 1 sales. The 1.05 factor accounts for inflation. For example, if the year 1 sales figure is 180,000, which is 10 percentage points below the expected year 1 sales, then the year 2 price will be 1.05[25,000 + 50( 10)] = 25,725. Similarly, the year 3 price will be 1.05[year 2 price + 50(% diff2)] where % diff2 is the percentage by which actual year 2 sales differ from expected year 2 sales. The variable cost in year 1 is triangularly distributed with parameters 10,000, 12,000, and 15,000, and it is assumed to increase by 5% each year. Your goal is to estimate the NPV of the new car during its first three years. Assume that the company is able to produce exactly as many cars as it can sell. Also, assume that cash flows are discounted at 10%. Simulate 1000 trials to estimate the mean and standard deviation of the NPV for the first three years of sales. Also, determine an interval such that you are 95% certain that the NPV of the Racer during its first three years of operation will be within this interval.W. L. Brown, a direct marketer of womens clothing, must determine how many telephone operators to schedule during each part of the day. W. L. Brown estimates that the number of phone calls received each hour of a typical eight-hour shift can be described by the probability distribution in the file P10_33.xlsx. Each operator can handle 15 calls per hour and costs the company 20 per hour. Each phone call that is not handled is assumed to cost the company 6 in lost profit. Considering the options of employing 6, 8, 10, 12, 14, or 16 operators, use simulation to determine the number of operators that minimizes the expected hourly cost (labor costs plus lost profits).
- A European put option allows an investor to sell a share of stock at the exercise price on the exercise data. For example, if the exercise price is 48, and the stock price is 45 on the exercise date, the investor can sell the stock for 48 and then immediately buy it back (that is, cover his position) for 45, making 3 profit. But if the stock price on the exercise date is greater than the exercise price, the option is worthless at that date. So for a put, the investor is hoping that the price of the stock decreases. Using the same parameters as in Example 11.7, find a fair price for a European put option. (Note: As discussed in the text, an actual put option is usually for 100 shares.)If you want to replicate the results of a simulation model with Excel functions only, not @RISK, you can build a data table and let the column input cell be any blank cell. Explain why this works.Based on Babich (1992). Suppose that each week each of 300 families buys a gallon of orange juice from company A, B, or C. Let pA denote the probability that a gallon produced by company A is of unsatisfactory quality, and define pB and pC similarly for companies B and C. If the last gallon of juice purchased by a family is satisfactory, the next week they will purchase a gallon of juice from the same company. If the last gallon of juice purchased by a family is not satisfactory, the family will purchase a gallon from a competitor. Consider a week in which A families have purchased juice A, B families have purchased juice B, and C families have purchased juice C. Assume that families that switch brands during a period are allocated to the remaining brands in a manner that is proportional to the current market shares of the other brands. For example, if a customer switches from brand A, there is probability B/(B + C) that he will switch to brand B and probability C/(B + C) that he will switch to brand C. Suppose that the market is currently divided equally: 10,000 families for each of the three brands. a. After a year, what will the market share for each firm be? Assume pA = 0.10, pB = 0.15, and pC = 0.20. (Hint: You will need to use the RISKBINOMLAL function to see how many people switch from A and then use the RISKBENOMIAL function again to see how many switch from A to B and from A to C. However, if your model requires more RISKBINOMIAL functions than the number allowed in the academic version of @RISK, remember that you can instead use the BENOM.INV (or the old CRITBENOM) function to generate binomially distributed random numbers. This takes the form =BINOM.INV (ntrials, psuccess, RAND()).) b. Suppose a 1% increase in market share is worth 10,000 per week to company A. Company A believes that for a cost of 1 million per year it can cut the percentage of unsatisfactory juice cartons in half. Is this worthwhile? (Use the same values of pA, pB, and pC as in part a.)
- Suppose you currently have a portfolio of three stocks, A, B, and C. You own 500 shares of A, 300 of B, and 1000 of C. The current share prices are 42.76, 81.33, and, 58.22, respectively. You plan to hold this portfolio for at least a year. During the coming year, economists have predicted that the national economy will be awful, stable, or great with probabilities 0.2, 0.5, and 0.3. Given the state of the economy, the returns (one-year percentage changes) of the three stocks are independent and normally distributed. However, the means and standard deviations of these returns depend on the state of the economy, as indicated in the file P11_23.xlsx. a. Use @RISK to simulate the value of the portfolio and the portfolio return in the next year. How likely is it that you will have a negative return? How likely is it that you will have a return of at least 25%? b. Suppose you had a crystal ball where you could predict the state of the economy with certainty. The stock returns would still be uncertain, but you would know whether your means and standard deviations come from row 6, 7, or 8 of the P11_23.xlsx file. If you learn, with certainty, that the economy is going to be great in the next year, run the appropriate simulation to answer the same questions as in part a. Repeat this if you learn that the economy is going to be awful. How do these results compare with those in part a?Software development is an inherently risky and uncertain process. For example, there are many examples of software that couldnt be finished by the scheduled release datebugs still remained and features werent ready. (Many people believe this was the case with Office 2007.) How might you simulate the development of a software product? What random inputs would be required? Which outputs would be of interest? Which measures of the probability distributions of these outputs would be most important?Rerun the new car simulation from Example 11.4, but now use the RISKSIMTABLE function appropriately to simulate discount rates of 5%, 7.5%, 10%, 12.5%, and 15%. Comment on how the outputs change as the discount rate decreases from the value used in the example, 10%.