Question

In: Finance

Demand for Coca Cola at a local restaurant is 60 bottles per day with a standard deviation of 15 bottles per day.

Demand for Coca Cola at a local restaurant is 60 bottles per day with a standard deviation of 15 bottles per day.

a. Compute the probability that demand will be at most 1700 bottles during the next 28 days.

b. Compute the number of bottles the restaurant should stock to have at most a 9% chance of running out over the next 28 days.

Solutions

Expert Solution

P( X <=1700) = P[ z <= (1700 - 60x28)/15*(28)^.5 = P[ Z <= 0.251976]

Now using function Norm.dist function with mean of 60x28 and SD = 79.39( 15*(28)^.5 ), we find the probability is 0.5997 or 59.97 %

b) We have mean of 1680, SD = 79.375

But we dont know what will be number of bottle for which P { x <= no of Bottle} = .09 = Norm.inv ( Probability, mean, SD) { Using x-cel function we got

X = 1573.5 9 Since, bottle can be in fraction number of bottle can be 1573 or 1574


Related Solutions

Coca-Cola 2.1. Coca-Cola’s profile Coca-Cola started its business in 1886 as a local soda producer in...
Coca-Cola 2.1. Coca-Cola’s profile Coca-Cola started its business in 1886 as a local soda producer in Atlanta, Georgia (US) selling about nine beverages per day. By the 1920s, the company had begun expanding internationally, selling its products first in the Caribbean and Canadian markets and then moving in consecutive decades to Asia, Europe, South America and the Soviet Union. By the end of the 20th century, the company was selling its products in almost every country in the world. In...
Average for a normally distributed demand of a product is 35 units per day. Standard deviation...
Average for a normally distributed demand of a product is 35 units per day. Standard deviation of lead time demand is 10. Lead time is 3 days. Service level is 95%. a) Calculate reorder point and safety stock. b) Reconsider 10 units as daily standard deviation of demand and re-calculate reorder point. c) Reconsider that demand is constant, but lead time varies with a standard deviation of 1 day. Recalculate reorder point. d) Assume both demand and lead time are...
5. The Coca-Cola World service process is demand- or capacity-constrained? 6. How could Coca-Cola World improve...
5. The Coca-Cola World service process is demand- or capacity-constrained? 6. How could Coca-Cola World improve its service process? 7. What is the main source of variation for Coca-Cola World and how could this variation be reduced?
A road averages 2,895 vehicles per day with a standard deviation of 615 vehicles per day....
A road averages 2,895 vehicles per day with a standard deviation of 615 vehicles per day. A traffic counter was used on this road on 34 days that were randomly selected. a. What is the probability that the sample mean is less than 2,700 vehicles per​ day? b. What is the probability that the sample mean is more than 2,900 vehicles per​ day? c. What is the probability that the sample mean is between 2,800 and 3,000 vehicles per​ day?...
Why is the price elasticity of demand for Coca-Cola greater than price elasticity of demand for...
Why is the price elasticity of demand for Coca-Cola greater than price elasticity of demand for soft drinks generally? Provide another example of good or service where you can see 'Coca-Cola & soft drinks in general' type of relationship in existence.
Why is the price of elasticity of demand for coca cola greater than the price of...
Why is the price of elasticity of demand for coca cola greater than the price of elasticity of demand for soft drinks generally?
The Standard Deviation of stock returns for Stock A is 60% and The standard Deviation of...
The Standard Deviation of stock returns for Stock A is 60% and The standard Deviation of market returns is 30% so If the statistical correlation between Stock A and the overall market is 0.6, then the beta for stock A is: 60%/30% x 0.6= 1.2 What is the expected risk premium for investors with this beta value compared to the market average for returns on investment?
Assume that the market for Coca-Cola in your area is perfectly competitive, with Demand P =...
Assume that the market for Coca-Cola in your area is perfectly competitive, with Demand P = 9 ? 0.3Q D and Supply P = 2 + 0.1Q S . Each firm that sells Coca-Cola is identical, with Total Cost T C = 3 + Q 2 , which gives Marginal Cost MC = 2Q. 1 Find the equilibrium price and quantity and graph the market. 2 Identify the consumer and producer surplus on the graph. 3 Graph the firm. Include...
The standard deviation of stock A is .60, while the standard deviation of stock B is...
The standard deviation of stock A is .60, while the standard deviation of stock B is .80. If the correlation coefficient for A and B is positive, then a portfolio that consists of 50% of stock A and 50% of stock B MUST have a standard deviation _________. Assume no short selling allowed. a) Less than 0.5 b) Greater than 0.7 c) Greater than 0.5 d) Less than 0.6 e) Not enough information
A product has a daily demand of 26 units per day. Ordering costs are $60 per...
A product has a daily demand of 26 units per day. Ordering costs are $60 per order. The annual carrying costs are measured at 20% of item value. Your supplier has offered you three item cost/price and quantity scenarios (1) you pay $150 per unit if your order quantity is 199 units or less, (2) you pay $121 per unit if your order quantity is between 200 and 4999 units, and (3) you pay $114 per unit if your order...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT