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
- 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.A martingale betting strategy works as follows. You begin with a certain amount of money and repeatedly play a game in which you have a 40% chance of winning any bet. In the first game, you bet 1. From then on, every time you win a bet, you bet 1 the next time. Each time you lose, you double your previous bet. Currently you have 63. Assuming you have unlimited credit, so that you can bet more money than you have, use simulation to estimate the profit or loss you will have after playing the game 50 times.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?
- Assume a very good NBA team has a 70% chance of winning in each game it plays. During an 82-game season what is the average length of the teams longest winning streak? What is the probability that the team has a winning streak of at least 16 games? Use simulation to answer these questions, where each iteration of the simulation generates the outcomes of all 82 games.The game of Chuck-a-Luck is played as follows: You pick a number between 1 and 6 and toss three dice. If your number does not appear, you lose 1. If your number appears x times, you win x. On the average, use simulation to find the average amount of money you will win or lose on each play of the game.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?
- Play Things is developing a new Lady Gaga doll. The company has made the following assumptions: The doll will sell for a random number of years from 1 to 10. Each of these 10 possibilities is equally likely. At the beginning of year 1, the potential market for the doll is two million. The potential market grows by an average of 4% per year. The company is 95% sure that the growth in the potential market during any year will be between 2.5% and 5.5%. It uses a normal distribution to model this. The company believes its share of the potential market during year 1 will be at worst 30%, most likely 50%, and at best 60%. It uses a triangular distribution to model this. The variable cost of producing a doll during year 1 has a triangular distribution with parameters 15, 17, and 20. The current selling price is 45. Each year, the variable cost of producing the doll will increase by an amount that is triangularly distributed with parameters 2.5%, 3%, and 3.5%. You can assume that once this change is generated, it will be the same for each year. You can also assume that the company will change its selling price by the same percentage each year. The fixed cost of developing the doll (which is incurred right away, at time 0) has a triangular distribution with parameters 5 million, 7.5 million, and 12 million. Right now there is one competitor in the market. During each year that begins with four or fewer competitors, there is a 25% chance that a new competitor will enter the market. Year t sales (for t 1) are determined as follows. Suppose that at the end of year t 1, n competitors are present (including Play Things). Then during year t, a fraction 0.9 0.1n of the company's loyal customers (last year's purchasers) will buy a doll from Play Things this year, and a fraction 0.2 0.04n of customers currently in the market ho did not purchase a doll last year will purchase a doll from Play Things this year. Adding these two provides the mean sales for this year. Then the actual sales this year is normally distributed with this mean and standard deviation equal to 7.5% of the mean. a. Use @RISK to estimate the expected NPV of this project. b. Use the percentiles in @ RISKs output to find an interval such that you are 95% certain that the companys actual NPV will be within this interval.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?You have 5 and your opponent has 10. You flip a fair coin and if heads comes up, your opponent pays you 1. If tails comes up, you pay your opponent 1. The game is finished when one player has all the money or after 100 tosses, whichever comes first. Use simulation to estimate the probability that you end up with all the money and the probability that neither of you goes broke in 100 tosses.
- New York City is the most expensive city in the United States for lodging. The mean hotel room rate is $204 per night (USA Today, April 30, 2012). Assume that room rates are normally distributed with a standard deviation of $55. Use Table 1 in Appendix B. a. What is the probability that a hotel room costs $225 or more per night (to 4 decimals)? b. What is the probability that a hotel room costs less than $140 per night (to 4 decimals)? c. What is the probability that a hotel room costs between $200 and $300 per night (to 4 decimals)? d. What is the cost of the 20% most expensive hotel rooms in New York City? Round up to the next dollar. or - Select your answer - ♥Implement a financial simulation model for a new product proposal and determine a distribution of profits using the provided discrete distributions for the unit cost, demand, and fixed costs. Price is fixed at $1,000. Simulate this model for 50 trials and a production quantity of 140. What is the average profit? Click here to view the discrete distributions. Click here to view a sample of 50 simulation trial results. Set up a lookup table for the unit cost. (Type integers or decimals. Do not round. Use ascending order.) Unit Cost Probability Lower Limit Upper Limit $400 0.25 $600 0.40 $700 0.15 $800 0.20 0.25 0.25 0.65 $400 $600 $700 $800Yearly Sales data for a product is given in Table SS Table SS (Yearly Sales) Sales (S) P(S) 120 0.12 140 0.25 160 0.17 180 0.25 200 0.09 220 0.12 Using the data in Table SS and the random numbers, 0.06, 0.10, 0.87, 0.14, 0.86, 0.32 the correct simulation of sales for 6 years is given by which of the following: IV 120 140 200 II II 120 120 120 200 120 120 120 200 200 140 180 180 140 200 140 140 180 180 140 140 140 Select one: O a. l O b. II Oc. II O d. IV 10:47 AM Ca D) ENG 12/16/2021 29°C