Question: 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

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 of 45. The lead time for their own brand of prepaid cell phones is two weeks and they have a lot size of 125 phones. a) What is the standard deviation of demand during their lead time? b) Suppose Mr. Barksdale sets his reorder point at 1100 phones. What is his average cell phone inventory? c) What is the average flow time of a phone if the reorder point used by Mr. Barksdale is 2000 phones

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) 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) In a class example, we determined safety inventory given a desired fill rate. The example included: ROP = 6000 units, D =...

Hertz's operation uses large quantities of prepaid cell phones, on average 500 per week with a standard deviation of 45. The lead time for their own brand of prepaid cell phones is two weeks. What is...

1. Multiple Choice Questions 1) The trade-off that a supply chain manager must consider when planning safety inventory is A) increasing product availability versus decreasing inventory holding costs....

Avon Barksdale's operation uses large quantities of prepaid cell phones, on average 500 per week with a standard deviation of 45. The lead time for their own brand of prepaid cell phones is two weeks...

1. Multiple Choice Questions 1) The trade-off that a supply chain manager must consider when planning safety inventory is A) increasing product availability versus increasing inventory holding costs....

Please provide the calculations on excel or word file along with the solution Research paper on Apple INC. The paper should be approximately 7 - 10 pages (12 - font, double-spaced) in length. Proper...

Custom Fabric Ventures is a small company that produces fabric-based wardrobe accessories (such as, handbags, scarves, and headbands) and home accessories (such as placemats, pillows, and window...

RO Finding Position of Most Significant Bit The positions of bits in a 32-bit register are counted from the least significant (rightmost) bit. Thus the first bit is 0, the next is 1, and the last is...

Happy Tots Learning Center has assembled the following data for the year ended June 30, 2012: Payments to suppliers . . . . . . . . . . . . . . . . . . . . $ 117,000 Purchase of equipment . . . . . ....

Question 2 4 All employees hired prior to 2 0 2 0 are required to complete a 2 0 2 0 Form W - 4 from 2 0 2 0 or Later. True False

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