Question: need help show work in excel please A drugstore uses fixed-order cycles for many of the Items it stocks. The manager wants a service level

need help show work in excel please

A drugstore uses fixed-order cycles for many of the Items it stocks. The manager wants a service level of .95. The order Interval is 10 days, and lead time is 2 days. Average demand for one item is 61 units per day, and the standard devlation of demand is 4 units per day. Given the on-hand inventory at the reorder time for each order cycle shown in the following table. Use Table. Click here for the Excel Data File Determine the order quantitles for cycles 1,2 , and 3 : (Round your answers to the nearest whole number.)

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!

QUESTION 1 A drugstore uses fixed-order cycles for many of the items it stocks. The manager wants a service level of 0.98 or 98%. The order interval is 14 days, and lead time is 2 days. Average...

please answer the following A produce distributor uses 770 packing crates a month, which it purchases at a cost of $8 each. The manager has assigned an annual carrying cost of 30 percent of the...

help Problem 12-31 (Algo) A drugstore uses fixed-order cycles for many of the items it stocks. The manager wants a service level of 95. The order interval is 14 days, and lead time is 2 days. Average...

please show work! A drugstore uses fixed-order cycles for many of the items it stocks. The manager wants a service level of .98. The order interval is 13 days, and lead time is 3 days. Average demand...

eBookHintAskReferencesCheck my workCheck My Work button is now enabledItem 5 A drugstore uses fixed - order cycles for many of the items it stocks. The manager wants a service level of . 9 5 . The...

Problem 12-19 (Algo) Given this information: Expected demand during lead time = 275 units Standard deviation of lead time demand = 14 units Use Table. Determine each of the following, assuming that...

Problem 12-31 (Algo) A drugstore uses fixed-order cycles for many of the items it stocks. The manager wants a service level of 95. The order interval is 14 days, and lead time is 2 days. Average...

please answer the following A drugstore uses fixed-order cycles for many of the items it stocks. The manager wants a service level of.98. The order interval is 12 days, and lead time is 2 days....

can someone help me understand this please? thank you and i will like your answer! Problem 12-31 (Algo) A drugstore uses fixed-order cycles for many of the items it stocks. The manager wants a...

A drugstore uses fixed-order cycles for many of the items it stocks. The manager wants a service level of 90. The order Interval is 11 days, and lead time is 1 days. Average demand for one item is 76...

Suppose all possible investment opportunities in the world are limited to the five stocks listed in the following table. What are the market portfolio weights? Stock Price/Share Number of Shares...

A two-year bond provides a coupon of 6% paid semiannually and has a cash price of 102. What is the bond's yield? (Hint: Goal Seek) Report your answer in decimal format rounded to four decimal places....

Which of the following would a lessee not record in connection with a lease? Multiple Choice Right - of - use asset Amortization expense Lease revenue. Interest expense Prev 2 4 of 3 8 Ngm Search

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...