Question: Please show the calculations. (in Excel file format using Excel formulas) Weekly demand for avocados at the Guac Shop is normally distributed with a mean

Please show the calculations. (in Excel file format using Excel formulas)

Weekly demand for avocados at the Guac Shop is normally distributed with a mean of 2500 and a standard deviation of 650. The store manager has decided to follow a periodic review policy to manage inventory of avocados. They plan to order every two weeks. The farmers currently take two weeks to fill an order. a) Given a desired Cycle Service Level (CSL) of 97.5 percent, how much safety inventory should the Guac Shop carry? b) What should their Order-up-to Level (OUL) be

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!

Please show the calculations. (in Excel file format using Excel formulas) Weekly demand for corn tortillas at Big Truck Tacos is normally distributed with a mean of 1500 and a standard deviation of...

Please show the calculations. (in Excel file format using Excel formulas) In a class example, we determined safety inventory given a desired fill rate. The example included: ROP = 6000 units, D =...

Please show the calculations. (in Excel file format using Excel formulas) Marlo Stanfield's operation also uses large quantities of prepaid cell phones, on average 1500 per week with a standard...

Please show the calculations. (in Excel file format using Excel formulas) - Avon Barksdale's operation uses large quantities of prepaid cell phones, on average 500 per week with a standard deviation...

A company sells the soft drink AlFa. The weekly demand from the company is normally distributed with an average of 2,500 and a standard deviation of 500 . See the inventory level over time and the...

ABC Fashion has 100 retail shops in London and each retail shop carries every product. ABC Fashion is thinking of centralizing the products in 1 location. While because of centralization, extra cost...

Please do not use excel and show all work. Thank you! Question 6 (16 points) Lead time demand for a product is normally distributed with mean equal to 42 and standard deviation equal to 12. The...

AutoSave . OFF 1 STA 3215 Deliverable 2 - Tutoring on the Normal Distribution Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) * 11 AA" ab Wrap Text v...

MATH 221 Statistics for Decision Making Week 6 iLab Name: Melissa Frawley Statistical Concepts: Data Simulation Confidence Intervals Normal Probabilities Short Answer Writing Assignment All answers...

A sample of 32 breastfed infants found that 2 of them developed iron deficiency by age 5.5 months.39 (a) Use these data to construct an appropriate 90% confidence interval. (b) What conditions are...

The income statement account balances on December 31, 20xx, for Jaymax Company appear below. In addition, ending merchandise inventory was $2,000. Sales $80,000 Cost of Merchandise Sold 35,000...

34. The travel brochure states that walking up OConnell Street, the statue of Parnell comes into view. Apparently that statue has no trouble getting around. Identify the fallacies of relevance, weak...

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...