A warehouse distributor of carpet keeps 6,000 yards of deluxe shag carpet in stock during a month. The average demand for carpet from the stores that purchase from the distributor is 4,500 yards per month, with a standard deviation of 900 yards. What is the probability that a customer’s order will not be met during a month? (This situation is referred to as a stockout.)
Q: The BeeGees' sells guitars for P6,999 each. The store consistently sells 450 guitars every year. The…
A:
Q: New York City is the most expensive city the United States for lodging. The mean hotel room rate is…
A:
Q: The mean annual earning for U.S. workers with advanced degrees is $80,977 with a standard deviation…
A: Note, Since you have posted multiple subparts in the same questions, we will be answering the first…
Q: Precision Parts is a job shop that specializes in producing electric motor shafts. The average shaft…
A: Formula:
Q: In a production phase, a corporation requires 85 circuit boards every day.This is the maxim that the…
A: Given that: Daily Demand (d)= 85 boards Reorder Point (R) = 625 orders Lead Time(L) = 6 days Average…
Q: Joe is selling Christmas trees to pay his college tuition.He purchases trees for $10 each and sells…
A: Since this question provides no limiting data to do the calculations. Lets assume that we will have…
Q: Use @RISK to draw a triangular distribution with parameters 300, 500, and 900. Then answer the…
A: Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: A company is trying to determine the proper capacity level for its new electric car. A unit of…
A: Above excel sheet will help in determining the cost of various level in production along with the…
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 company uses 85 circuit boards a day in a manufacturing process. The person who ordersthe boards…
A:
Q: An automobile manufacturer is concerned about a fault in the braking mechanism of a particular…
A: given, distribution number of cars per year =8 on average
Q: A retail outlet sells a seasonal product for $10 per unit. The cost of the product is $8 per unit.…
A: Given data: Selling price = $10 per unit Cost price = $8 per unit Salvage cost
Q: The average number of phone calls to a call center on Thursday nights from 10:00 PM to 11:00 PM is…
A: For this given question, we know about the average number of calls that is here, 6.3, here, I have…
Q: The methods used to capture the effect of several sources of uncertainty will in practice often…
A: Simulation helps in modelling random events that helps in evaluating the performance of various…
Q: Develop a decision tree. b) Which supplier should Kellogg use?
A:
Q: A manufacturer sells a product in two regions. Weekly demand in each region is Normally distributed…
A: given, standard deviation = 300 weekly demand = 1000 correlation coefficient = -.35
Q: Company XYZ produces and sells two types of calculators: Basic and Scientific. The Basic has a lower…
A: Contribution Margin: It is defined as the difference between revenues and variable costs.…
Q: Daniel Grady is the financial advisor for a number of professional athletes. An analysis of the…
A: The constrains are in Blue The decision variable, the share of investment is in green And the…
Q: Answer all questions
A:
Q: Consider the M/M/1 queueing system with arrival rate λ > 0 and service rate μ > 0. (a) Compute the…
A: This question must be solved using the superposition of two Poisson processes. As per superposition…
Q: andrew thomas , a sandwich vendor at hard rock cafe 's annual rockfest, created a table of…
A: given possibility of big demand =0.3 possibility of Average demand =0.5 possibility of small demand…
Q: Franz Beckmann is selling sausages at the local soccergames in Pullach. History has shown that in…
A: Given data Cost price = 0.25 Sales price = 2 Salvage value = 0 Now, calculating the cost of…
Q: optimal lot sizes and reorder points for this brand
A: The decision Variable Q is the number of units to be purchased at the beginning of the period. The…
Q: Automobile repair cost continue to rise with the average cost now at $367 per repair. Assume that…
A: Normal distribution with SD = $88 and mean = $367. The z-value at $480 = (480-367)/88 = 0.9004 (left…
Q: 2. Suppose a rancher must decide whether to take his cattle to market in the morning or afternoon.…
A:
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: Given this frequency distribution, what demand values would be associated with the following random…
A: Below is the solution:-
Q: A fish restaurant sells fish for 50$ per kg and buys it from the suppliers for 10$ per kg. Fish that…
A: A supervisor boosts profit when the worth of the last unit of the item (minimal income) approaches…
Q: The Polo Development Firm is building a shopping center. It has informed renters that their rental…
A: Probability is a statistical tool but in operations, the probability is used to check the favourable…
Q: Planetary Communications, Inc., intends to launch a satellite that will enhance reception of…
A:
Q: For a given perishable product, a retailer pays $5 for each unit, then sells them for $10 each. At…
A: Given that: Cost price for Retailer = $5 Selling price for retailer = $10 Salvage Value = $1 x…
Q: TP Inc. is a small company specializes in supplying toilet paper to small businesses, offices,…
A: Given data: Weekly demand d = 650 boxes Ordering cost = S = $150 per order Cost of each package -…
Q: Planetary Communications, Inc., intends to launch a satellite that will enhance reception of…
A:
Q: Discuss how likely it is that 70% of students will pass a college course with a B or an A. Then,…
A:
Q: Consider a service system in which each entering customer must be served first by server 1, then by…
A: (a) Let X1 , X2 and X3 be the measure of time taken by worker 1, 2 and 3 individually. Likelihood…
Q: A recent 10-year study conducted by a research team at the Great Falls Medical School was conducted…
A: Here, I have answered the first three sub-parts, There are four data column, Y data is risk of a…
Q: 5. A concessionaire for the local ballpark has developed a table of conditional values for the…
A: Find the Given details below: Given Details States of Nature (Size of Crowd) Alternatives…
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: The Ramshead Pub sells a large quantity of beer every Saturday. From past sales records, the pub has…
A: Expected number of barrels=60.10+70.20+80.40+90.25+100.05=0.6+1.4+3.2+2.25+0.5=7.95
Q: Deborah Hollwager, a concessionaire for the Amway Center in Orlando, has developed a table of…
A: Given-
Q: What is false about service level and stock out? Service level and stock out risk are probabilities…
A: It is true that the service level and stock out risk are probabilities of mutually exclusive events…
Q: The average number of operational losses in a year at a particular plant is 18, so the number of…
A:
Q: National Auto parts uses a 4-week periodic review system to reorder parts for its inventory stock. A…
A: 1. Existing stock = 8 units, On-order qty = 16 Prob{stockout happens before the next arrival} =…
Q: Lucresia the witch owns a magic basket and black eggs. It is observed that every minute the numbers…
A: In the above case it is mentioned that every minute the black eggs in the magic basket are doubling.…
Q: the probability distribution for their product
A: calculating the expected value of demand is following the sum values of probability multiplied by…
Q: Suppose that for years East Campus' short-run Phillips Curve was such that each 1 percentage point…
A: given, East Campus' short-run Phillips Curve was such that each I percentage point increase in its…
Q: The owner of Western Clothing Company has determined that the company must sell 670 pairs of denim…
A: Here, mean is 805 and standard deviation is 207 and more than 670 pairs of jeans need to be sold to…
A warehouse distributor of carpet keeps 6,000 yards of deluxe shag carpet in stock during a
month. The average demand for carpet from the stores that purchase from the distributor is 4,500
yards per month, with a standard deviation of 900 yards. What is the probability that a customer’s
order will not be met during a month? (This situation is referred to as a stockout.)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
- 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?Six months before its annual convention, the American Medical Association must determine how many rooms to reserve. At this time, the AMA can reserve rooms at a cost of 150 per room. The AMA believes the number of doctors attending the convention will be normally distributed with a mean of 5000 and a standard deviation of 1000. If the number of people attending the convention exceeds the number of rooms reserved, extra rooms must be reserved at a cost of 250 per room. a. Use simulation with @RISK to determine the number of rooms that should be reserved to minimize the expected cost to the AMA. Try possible values from 4100 to 4900 in increments of 100. b. Redo part a for the case where the number attending has a triangular distribution with minimum value 2000, maximum value 7000, and most likely value 5000. Does this change the substantive results from part a?Dilberts Department Store is trying to determine how many Hanson T-shirts to order. Currently the shirts are sold for 21, but at later dates the shirts will be offered at a 10% discount, then a 20% discount, then a 40% discount, then a 50% discount, and finally a 60% discount. Demand at the full price of 21 is believed to be normally distributed with mean 1800 and standard deviation 360. Demand at various discounts is assumed to be a multiple of full-price demand. These multiples, for discounts of 10%, 20%, 40%, 50%, and 60% are, respectively, 0.4, 0.7, 1.1, 2, and 50. For example, if full-price demand is 2500, then at a 10% discount customers would be willing to buy 1000 T-shirts. The unit cost of purchasing T-shirts depends on the number of T-shirts ordered, as shown in the file P10_36.xlsx. Use simulation to determine how many T-shirts the company should order. Model the problem so that the company first orders some quantity of T-shirts, then discounts deeper and deeper, as necessary, to sell all of the shirts.
- You now have 10,000, all of which is invested in a sports team. Each year there is a 60% chance that the value of the team will increase by 60% and a 40% chance that the value of the team will decrease by 60%. Estimate the mean and median value of your investment after 50 years. Explain the large difference between the estimated mean and median.Based on Marcus (1990). The Balboa mutual fund has beaten the Standard and Poors 500 during 11 of the last 13 years. People use this as an argument that you can beat the market. Here is another way to look at it that shows that Balboas beating the market 11 out of 13 times is not unusual. Consider 50 mutual funds, each of which has a 50% chance of beating the market during a given year. Use simulation to estimate the probability that over a 13-year period the best of the 50 mutual funds will beat the market for at least 11 out of 13 years. This probability turns out to exceed 40%, which means that the best mutual fund beating the market 11 out of 13 years is not an unusual occurrence after all.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.
- 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).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.)It costs a pharmaceutical company 75,000 to produce a 1000-pound batch of a drug. The average yield from a batch is unknown but the best case is 90% yield (that is, 900 pounds of good drug will be produced), the most likely case is 85% yield, and the worst case is 70% yield. The annual demand for the drug is unknown, with the best case being 20,000 pounds, the most likely case 17,500 pounds, and the worst case 10,000 pounds. The drug sells for 125 per pound and leftover amounts of the drug can be sold for 30 per pound. To maximize annual expected profit, how many batches of the drug should the company produce? You can assume that it will produce the batches only once, before demand for the drug is known.
- 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?Use @RISK to analyze the sweatshirt situation in Problem 14 of the previous section. Do this for the discrete distributions given in the problem. Then do it for normal distributions. For the normal case, assume that the regular demand is normally distributed with mean 9800 and standard deviation 1300 and that the demand at the reduced price is normally distributed with mean 3800 and standard deviation 1400.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.