You are managing a business that design products for specific medical purposes. Your potential demand is very short lived and uncertain. Your production cycle is very long which means you need to have the products ready in advance. If the demand for your product arises (only 30% chance), they will be sold well; if not, the products will remain unsold, and you will need to liquidate them for 500 each. You predict that the demand will be normally distributed with mean= 15000 and standard deviation= 7000. The production cost of your product is, on average, $5500. You will sell your product for $12500. Suppose you make 18000 products, and you get lucky and demand will occur this year. What is your expected profit?

You are managing a business that design products for specific medical purposes. Your potential demand is very short lived and uncertain. Your production cycle is very long which means you need to have the products ready in advance. If the demand for your product arises (only 30% chance), they will be sold well; if not, the products will remain unsold, and you will need to liquidate them for 500 each. You predict that the demand will be normally distributed with mean= 15000 and standard deviation= 7000. The production cost of your product is, on average, $5500. You will sell your product for $12500. Suppose you make 18000 products, and you get lucky and demand will occur this year. What is your expected profit?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 37P

See similar textbooks

Similar questions

The IRR is the discount rate r that makes a project have an NPV of 0. You can find IRR in Excel with the built-in IRR function, using the syntax =IRR(range of cash flows). However, it can be tricky. In fact, if the IRR is not near 10%, this function might not find an answer, and you would get an error message. Then you must try the syntax =IRR(range of cash flows, guess), where guess" is your best guess for the IRR. It is best to try a range of guesses (say, 90% to 100%). Find the IRR of the project described in Problem 34. 34. Consider a project with the following cash flows: year 1, 400; year 2, 200; year 3, 600; year 4, 900; year 5, 1000; year 6, 250; year 7, 230. Assume a discount rate of 15% per year. a. Find the projects NPV if cash flows occur at the ends of the respective years. b. Find the projects NPV if cash flows occur at the beginnings of the respective years. c. Find the projects NPV if cash flows occur at the middles of the respective years.
A new edition of a very popular textbook will be published a year from now. The publisher currently has 1000 copies on hand and is deciding whether to do another printing before the new edition comes out. The publisher estimates that demand for the book during the next year is governed by the probability distribution in the file P10_31.xlsx. A production run incurs a fixed cost of 15,000 plus a variable cost of 20 per book printed. Books are sold for 190 per book. Any demand that cannot be met incurs a penalty cost of 30 per book, due to loss of goodwill. Up to 1000 of any leftover books can be sold to Barnes and Noble for 45 per book. The publisher is interested in maximizing expected profit. The following print-run sizes are under consideration: 0 (no production run) to 16,000 in increments of 2000. What decision would you recommend? Use simulation with 1000 replications. For your optimal decision, the publisher can be 90% certain that the actual profit associated with remaining sales of the current edition will be between what two values?
You are considering a 10-year investment project. At present, the expected cash flow each year is 10,000. Suppose, however, that each years cash flow is normally distributed with mean equal to last years actual cash flow and standard deviation 1000. For example, suppose that the actual cash flow in year 1 is 12,000. Then year 2 cash flow is normal with mean 12,000 and standard deviation 1000. Also, at the end of year 1, your best guess is that each later years expected cash flow will be 12,000. a. Estimate the mean and standard deviation of the NPV of this project. Assume that cash flows are discounted at a rate of 10% per year. b. Now assume that the project has an abandonment option. At the end of each year you can abandon the project for the value given in the file P11_60.xlsx. For example, suppose that year 1 cash flow is 4000. Then at the end of year 1, you expect cash flow for each remaining year to be 4000. This has an NPV of less than 62,000, so you should abandon the project and collect 62,000 at the end of year 1. Estimate the mean and standard deviation of the project with the abandonment option. How much would you pay for the abandonment option? (Hint: You can abandon a project at most once. So in year 5, for example, you abandon only if the sum of future expected NPVs is less than the year 5 abandonment value and the project has not yet been abandoned. Also, once you abandon the project, the actual cash flows for future years are zero. So in this case the future cash flows after abandonment should be zero in your model.)
A borrower takes out a 30-year adjustable rate mortgage loan for $200,000 with monthly payments. The first two years of the loan have a "teaser" rate of 4 percent, after that the rate can reset with a 5 percent annual payment cap. On the reset date, the composite rate is 6 percent. Assume that the loan allows for negative amortization. What would be the outstanding balance on the loan at the end of Year 3? Multiple Choice $192,926 $190,074 $192,812 $192,337
Oxicon Inc. manufactures several different types of candy for various retail stores. The accountingmanager has requested that you determine the sales dollars required to break even for next quarter based on past financial data. Your research tells you that the total variable costs will be $500,000,total sales will be $750,000, and fixed costs will be $75,000. What is the breakeven point in salesdollars?
I need a detailed explanation on how to solve this problem: A bagel shop buys each bagel for $0.08 and sells each bagel for $0.35. Leftover bagels at the end of the day are purchased by a local soup kitchen for $0.03 per bagel. The shop’s owner has observed for the daily demand, Q, the following probabilities, f(Q): Q 0 5 10 15 20 25 30 35 f(Q) 0.05 0.10 0.10 0.20 0.25 0.15 0.10 0.05 - What is the optimal daily order in multiples of 5 (include the model name and formula)? - If the daily demand is normally distributed (the mean and variance can be obtained from the table above), then what is the optimal daily order?
A product with an annual demand of 800 units has Co = $20.00 and Ch = $6. The demand exhibits some variability such that the lead-time demand follows a normal probability distribution with µ = 26 and σ = 6.
Good Shoes Company manufactures ski boots for children each pair of which costs $40 to manufacture. Good Shoes sells the boots to a well-known sports goods retailer and the retailer sells each pair for $100. Any boots not sold (by the retailer) during the season are sold to a discount retailer for $20 a pair. Demand during the season is assumed to have a Normal distribution with a mean of 850 and a standard deviation of 350. What should the manufacturer charge the retailer per pair to maximize its expected profits? Assume that Good Shoes will consider a price from the following set: (60,65,70,75,80,85 90,95), i.e., The manufacturer's price will be either $60, or $65 or $70, or ......,,$95).
Suppose that you want to invest $10,000 in the stock market by buying shares in one of two companies: A and B. Shares in company A though risky, could yield a 50% return on investment during the next year. If the stock market if conditions are not favorable (bear market) the stock may lose 20% of it value. Company B provides safe investments with 15% return in a bull market and only 5% in a bear market Ali the applications you have consulted are predicting a 60% chance for a bull market and 40% for a bear market. Where you invest your money? Construct a decision tree.
The Standard Bank Risk Executive Maharsh Boaz is discussing a case with you in which he outlines that the institution hasa portfolio that consists of a single asset in the Middle East Stock Exchange. The return of the asset is normally distributedwith mean return 20% and standard deviation 30%. The value of the portfolio today is US$100 million. He needs to quantifythe risk of a potential loss for this portfolio by year end at a 95% confidence level. Critically discuss the method that you willrecommend to him and how it should be administered. Your response should make use of relevant example.
A building contains 1000 lightbulbs. Each bulb lastsat most five months. The company maintaining thebuilding is trying to decide whether it is worthwhileto practice a “group replacement” policy. Under agroup replacement policy, all bulbs are replaced everyT months (where T is to be determined). Also, bulbsare replaced when they burn out. Assume that it costs$0.05 to replace each bulb during a group replacementand $0.20 to replace each burned-out bulb if it isreplaced individually. How would you use simulationto determine whether a group replacement policy isworthwhile?
A retail outlet sells a seasonal product for $10 per unit. The cost of the product is $8 per unit. All units not sold during the regular season are sold for half the retail price in an end-of-season clearance sale. Assume that demand for the product is uniformly distributed between 200 and 800. What is the recommended order quantity? What is the probability that at least some customers will ask to purchase the product after the outlet is sold out? That is, what is the probability of a stock-out using your order quantity in part (a)? To keep customers happy and returning to the store later, the owner feels that stock-outs should be avoided if at all possible. What is your recommended order quantity if the owner is willing to tolerate a 0.15 probability of a stock-out?