The unit price is 50$. The company produces 50000 units per month. The unit cost follows a continuous Uniform Distribution between $25 and $30. The fixed cost is a Normal Distribution with the mean=500000 and Standard Deviation=60000. Run the simulation 100 times and compute the statistics for the expected profit
Q: Given the data here, a. Compute the average return for each of the assets from 1929 to 1940 (the…
A: Use excel as follows to calculate average return , variance and standard deviation
Q: What does the worst-case scenario simulation model tell you that Monte Carlo simulation does not?…
A: Worst case scenario – It deals with the worst-case scenario. When making a net present value…
Q: The weather evolves in a probabilistic manner based on many factors from one day to the next.…
A:
Q: Assume that prices for a non-dividend-paying stock follow the lognormal model. The current price of…
A: Introduction: The term Business refers to an exchange of goods and services between the buyer and…
Q: W. L. Brown, a direct marketer of women’s clothing,must determine how many telephone operators…
A: The aforementioned question is answered as below:
Q: A specialized machine essential for a company's operations costs $5,000 and has operating costs of…
A: Calculations:
Q: Suppose you are an HR (human resources) manager at a big university, and you sense that the…
A: As an HR manager at a big university, it will create a great responsibility to cope up with the…
Q: Management of the Toys R4U Company needs to decide whether to introduce a certain new novelty toy…
A: Let the decision variable, X=Number of the toys to produce. Fixed cost, F= $500000 Variable cost, V…
Q: I need a detailed explanation on how to solve this problem: A bagel shop buys each bagel for $0.08…
A: Given Information:Each bagel buys at the rate of $0.08And each bagel sells at the rate of…
Q: The methods used to capture the effect of several sources of uncertainty will in practice often…
A: We will evaluate the statement and options The statement is that "the methods to capture the effect…
Q: A hardware company sells a lot of low-cost, highvolumeproducts. For one such product, it is…
A: given, low sales = 60,000 high sales = 100,000 variable cost per unit 25% chance of = $6…
Q: A publisher prints copies of a popular weekly tabloid for distribution and sale. The fixed costs are…
A: Cost function indicating the sum value of the cost. Here, we develop the cost function by…
Q: Suppose savers either buy bonds or make deposits in savings accounts at banks. Initially, the…
A: A budget deficit is a situation when the country’s expenditure increased from its revenue.
Q: A television network earns an average of $25 million each season from a hit program and loses an…
A: For a value of C = $160,000, build a precision tree by the procedure given below, 1. Precision tree…
Q: Suppose you are a financial analyst and your company runs many simulation models to estimate the…
A: Simulation modeling: A simulation model is a computerized model that would depict or imitate a…
Q: The management of Brinkley Corporation is interested in using simulation to estimate the profit per…
A: Given data: Procurement Cost ($) Probability Labor cost Probability Transportation Cost…
Q: A milk man buys milk at K10 per litre and sells it at K12 if sold on the same day. If not, it can be…
A: Here, this question is related to the Topic - Inventory Management and this topic falls under…
Q: A building contains 1000 lightbulbs. Each bulb lastsat most five months. The company maintaining…
A: In the above question, the company wants to decide whether the group replacement policy is…
Q: Home price y is estimated as a function of the square footage of a house x and a dummy variable d…
A: Given: y = 118.90 +0.12x + 52.60d i.) For a house with mountain views, d = 1 For a house with…
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 particular automobile costs an average of $21,755 in the Pacific Northwest. The standard deviation…
A: A random sample is a sample of the population where the variables in the samples are taken randomly.…
Q: Compcomm, Inc., is an international communications andinformation technology company that has seen…
A: The simulation model is following
Q: A new edition of a very popular textbook will be published a year from now. The publisher currently…
A: Given data, Copies in Hand = 1000 Fixed Cost = $15000 Variable Cost = $20 per book Seeling Price =…
Q: According to the CAPM, what is the expected risk premium of a stock with a beta of 0.8 if the market…
A: The Capital Asset Pricing Model is used to determine the expected return of security with the help…
Q: I own a single share of Wivco stock. I must sell myshare at the beginning of one of the next 30…
A:
Q: A person wants to invest in one of three alternative investment plans: stocks, bonds or a savings…
A: Following is the given information:
Q: 2. A daily demand for loaves of bread at a grocery store is given by the fllowing probability…
A: Given data is
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 restaurant borrows $15,200 from a local bank for 10 months. The local bank charges simple…
A: Given that: Principal(P) = $15200 For months (t) = 10 Interest rate annually = 4.55%
Q: If the farmer uses pesticides he expects a crop of 60,000 bushels; if he does not use pesticides he…
A: Cost of Pesticides = $20,000 Other Costs = $450,000 Price of corn: P1 = $10 (probability = 0.50) P2…
Q: We are thinking of filming the Don Harnett story. Weknow that if the film is a flop, we will lose $4…
A:
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: What family of functions do f(x) and g(x) belong to? How do you know?
A: Hello thank you for the question. As per guidelines, we would provide only one answer at a time.…
Q: Gap analysis predicts that a decrease in interest rates will result in a rise in bank profits when…
A: the quantity of rate sensitive assets is greater than the quantity of rate sensitive liabilities.
Q: See how sensitive the results in Example 11.2 are to the following changes. For each part, make the…
A: The Yakkon Company sells a popular camera for $500 with a warranty of 1.5 years and cost for…
Q: A company needs to order raw material and demand is forecast to be normally distributed with a mean…
A: An inventory system containing uncertainty, e.g., in demand, in costs, in lead time, or in supplied…
Q: You are thinking of starting Peaco, which will produce Peakbabies, a product that competes with Ty’s…
A:
Q: The management of the Keribels Company wishes to apply the Miller-Orr model to manage its cash…
A: Given data, Transaction cost =$100 Cash flow variance=75000 I =0.05%
Q: 1. Give 2 examples of over processing (waste)? 2 examples of over processing (waste) as follows: 2.…
A: Note: “Since you have asked multiple questions, we will solve the first question for you. If you…
Q: A valid reason for using simulation model is: a. analyze relationship between the variables which…
A: Simulation modeling is nothing but the technique of developing and examining automated or digital…
Q: A salesperson for Fuller Brush has three options: quit,put forth a low-effort level, or put forth a…
A:
Q: 46. You are making several runs of a simulation model,each with a different value of some decision…
A: The decision problem might have more than one dependent variable. On the basis of profit, the…
Q: Nippon Steel's expenses for heating and cooling a large manufacturing facility are expected to…
A: Computation of Present Worth Year Cash Flow ($) PV Factor @11% Discounted Cash Flows ($) (A)…
Q: The daily demand for a product in a shop can assume one of the following values: 100, 120, or 130…
A: The optimal stock assigns the specific measure of stock a business needs to satisfy routine interest…
Q: Hashing and Load balancing are two related applications that govern the work of distributed load…
A: Probability theory is a part of science worried about the investigation of irregular phenomena.…
Q: You own Amazon stock. Suppose that Amazon has an expected return of 52% and a volatility of 19%. The…
A: SD(RxCML) = xSD(RMkt).23 = x(.16) → x = .23/.16 = 1.4375, so long 144% market and short 44%…
- The demand distribution for a company follows the below Table.
Demand |
Probability |
40,000 |
0.1 |
45,000 |
0.3 |
50,000 |
0.4 |
55,000 |
0.15 |
60,000 |
0.05 |
The unit price is 50$. The company produces 50000 units per month. The unit cost follows a continuous Uniform Distribution between $25 and $30. The fixed cost is a
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 6 images
- 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.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.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?
- Assume that all of a companys job applicants must take a test, and that the scores on this test are normally distributed. The selection ratio is the cutoff point used by the company in its hiring process. For example, a selection ratio of 25% means that the company will accept applicants for jobs who rank in the top 25% of all applicants. If the company chooses a selection ratio of 25%, the average test score of those selected will be 1.27 standard deviations above average. Use simulation to verify this fact, proceeding as follows. a. Show that if the company wants to accept only the top 25% of all applicants, it should accept applicants whose test scores are at least 0.674 standard deviation above average. (No simulation is required here. Just use the appropriate Excel normal function.) b. Now generate 1000 test scores from a normal distribution with mean 0 and standard deviation 1. The average test score of those selected is the average of the scores that are at least 0.674. To determine this, use Excels DAVERAGE function. To do so, put the heading Score in cell A3, generate the 1000 test scores in the range A4:A1003, and name the range A3:A1003 Data. In cells C3 and C4, enter the labels Score and 0.674. (The range C3:C4 is called the criterion range.) Then calculate the average of all applicants who will be hired by entering the formula =DAVERAGE(Data, "Score", C3:C4) in any cell. This average should be close to the theoretical average, 1.27. This formula works as follows. Excel finds all observations in the Data range that satisfy the criterion described in the range C3:C4 (Score0.674). Then it averages the values in the Score column (the second argument of DAVERAGE) corresponding to these entries. See online help for more about Excels database D functions. c. What information would the company need to determine an optimal selection ratio? How could it determine the optimal selection ratio?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.Big Hit Video must determine how many copies of a new video to purchase. Assume that the companys goal is to purchase a number of copies that maximizes its expected profit from the video during the next year. Describe how you would use simulation to shed light on this problem. Assume that each time a video is rented, it is rented for one day.
- 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.)Suppose you simulate a gambling situation where you place many bets. On each bet, the distribution of your net winnings (loss if negative) is highly skewed to the left because there are some possibilities of really large losses but not much upside potential. Your only simulation output is the average of the results of all the bets. If you run @RISK with many iterations and look at the resulting histogram of this output, what will it look like? Why?Simulation can be used to illustrate a number of results from statistics that are difficult to understand with nonsimulation arguments. One is the famous central limit theorem, which says that if you sample enough values from any population distribution and then average these values, the resulting average will be approximately normally distributed. Confirm this by using @ RISK with the following population distributions (run a separate simulation for each): (a) discrete with possible values 1 and 2 and probabilities 0.2 and 0.8; (b) exponential with mean 1 (use the RISKEXPON function with the single argument 1); (c) triangular with minimum, most likely, and maximum values equal to 1,9, and 10. (Note that each of these distributions is very skewed.) Run each simulation with 10 values in each average, and run 1000 iterations to simulate 1000 averages. Create a histogram of the averages to see whether it is indeed bell-shaped. Then repeat, using 30 values in each average. Are the histograms based on 10 values qualitatively different from those, based on 30?
- If you own a stock, buying a put option on the stock will greatly reduce your risk. This is the idea behind portfolio insurance. To illustrate, consider a stock that currently sells for 56 and has an annual volatility of 30%. Assume the risk-free rate is 8%, and you estimate that the stocks annual growth rate is 12%. a. Suppose you own 100 shares of this stock. Use simulation to estimate the probability distribution of the percentage return earned on this stock during a one-year period. b. Now suppose you also buy a put option (for 238) on the stock. The option has an exercise price of 50 and an exercise date one year from now. Use simulation to estimate the probability distribution of the percentage return on your portfolio over a one-year period. Can you see why this strategy is called a portfolio insurance strategy? c. Use simulation to show that the put option should, indeed, sell for about 238.The customer loyalty model in Example 11.9 assumes that once a customer leaves (becomes disloyal), that customer never becomes loyal again. Assume instead that there are two probabilities that drive the model, the retention rate and the rejoin rate, with values 0.75 and 0.15, respectively. The simulation should follow a customer who starts as a loyal customer in year 1. From then on, at the end of any year when the customer was loyal, this customer remains loyal for the next year with probability equal to the retention rate. But at the end of any year the customer is disloyal, this customer becomes loyal the next year with probability equal to the rejoin rate. During the customers nth loyal year with the company, the companys mean profit from this customer is the nth value in the mean profit list in column B. Keep track of the same two outputs as in the example, and also keep track of the number of times the customer rejoins.Amanda has 30 years to save for her retirement. At the beginning of each year, she puts 5000 into her retirement account. At any point in time, all of Amandas retirement funds are tied up in the stock market. Suppose the annual return on stocks follows a normal distribution with mean 12% and standard deviation 25%. What is the probability that at the end of 30 years, Amanda will have reached her goal of having 1,000,000 for retirement? Assume that if Amanda reaches her goal before 30 years, she will stop investing. (Hint: Each year you should keep track of Amandas beginning cash positionfor year 1, this is 5000and Amandas ending cash position. Of course, Amandas ending cash position for a given year is a function of her beginning cash position and the return on stocks for that year. To estimate the probability that Amanda meets her goal, use an IF statement that returns 1 if she meets her goal and 0 otherwise.)