Question: please show work in excel. Problem 1 A souvenir shop in downtown San Francisco is open 300 days a year and sells an average of

please show work in excel. please show work in excel. Problem 1 A souvenir

Problem 1 A souvenir shop in downtown San Francisco is open 300 days a year and sells an average of 37 Golden Gate Bridge T-shirts a day. The ordering costs are $15 per order. The annual holding cost per shirt is $0.65. After careful review, it was determined that the Lead Time Demand (LTD) was normally distributed at 370 T-shirts with a std. deviation of 23 shirts. a) Assume that management has specified that no more than 1% risk of a stock out is acceptable. What should the safety stock be? b) What should the reorder point (ROP) be? c) What is the annual additional holding cost of maintaining the level of safety stock needed to support the 1% stock out risk? d) If management specified that a 2% risk of stock out during lead time would be acceptable, would the safety stock holding costs decrease or increase

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

A gourmet coffee shop in downtown San Francisco is open 2 0 0 days a year and sells an average of 7 6 pounds of Kona coffee beans a day. ( Demand can be assumed to be distributed normally with a...

The Excel sheet is part of the solution for question a) which starts with; " Ashley decided to allocate..... This problem has already been solved by your Expert. However, There seems to be some error...

can you please answer these questions so that I can check my answers against others so I can try to correct any of my mistakes thank you All of the 1.020 students at a local high school must enroll...

Neiman Marcus filed for bankruptcy on May 7, 2020. The case study provides invaluable background information about Neiman Marcus from its opening in 1907 to 2006 when the case was written. Use the...

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

CASE 25 Southwest Airlines in 2014: Culture, Values, and Operating Practices Arthur A. Thompson John E. Gamble The University of Alabama Texas A&M University-Corpus Christi n 2014, Southwest Airlines...

HI GOOD AFTERNOON, IS IT POSSIBLE THAT I MAY GET SOME ASSISTANCE WITH THIS ASSIGNMENT. SEE ATTACHMENT INSTRUCTIONS ARE AS FOLLOWS: ONLY THE RELEVANT HISTORY IS IMPORTANT, IN TERMS OF A PROBLEM...

Please help, also could you show the formulas as well. Please help. Does it look better now, the first excel sheet goes all the up to 12 & then the total. please Sprinkles Ice Cream Shoppe Please...

Bloomberg CASEO Businessweek STUDIES 4 Weighted Average Cost of Capital Analyze how the theoretical concepts This lesson explores how several companies and industries are of weighted average cost of...

Assume that A is row equivalent to B. Find bases for Nul A and Col A. A= - 2 4-2-4 26-3 2 B= - 3 8 2-4 1064 0252 0000 A basis for Col A is. (Use a comma to separate vectors as needed.) A basis for...

An athletic league does drug testing of its athletes, 10 percent of whom use drugs. This test, however, is only 95 percent reliable. That is, a drug user will test positive with probability 0.95 and...

13. Just before Ward Laboratories opened for business, Pamela Ward, the owner, had the following assets and liabilities. Determine the totals that would appear in the firms fundamental accounting...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...