f2Same problem statement:Weekly demand for DVD-Rs at a retailer is normally distributed with a mean of 1,000 boxes and a standard deviation of 150. Currently, the store places orders to the supplier,with a reorder point of 4,200 boxes. The order quantity to the supplier is fixed at 5,000 boxes. Replenishment lead time is 4 weeks, fixed order cost per order is $100, each boxcosts the retailer $10, and the inventory holding cost is 25% per year. Assume 50 weeks in a year.Given the problem parameters, what is the optimal order quantity the retailer should order?Numeric Responsef32040f4f540f604-f7♫+< Prev.fgIAA***4 of 5hp▷IIf10DDINext >f11Wf12.Xinsertprt sc+=Odelete← backspacehomenumlock f2estion #5Same problem statement:Weekly demand for DVD-Rs at a retailer is normally distributed with a mean of 1,000 boxes and a standard deviation of 150. Currently, the store places orders to the supplier,with a reorder point of 4,200 boxes. The order quantity to the supplier is fixed at 5,000 boxes. Replenishment lead time is 4 weeks, fixed order cost per order is $100, each boxcosts the retailer $10, and the inventory holding cost is 25% per year.Under the current order quantity of 5,000 boxes and current reorder point of 4,200 boxes, what would be the order-up-to level S that the retailer should use as a baseline tocalculate how much inventory to order when conducting a periodic review?Numeric Response1500f3f4f57040f604-f7s+< Prev.fgIAA5 of 5fghp▷IIf10□DDINextf11Wf12.insertprt sc+delete← backspacehomenumlock

Answered: Image /qna-images/answer/e2fbf9df-5d2e-4840-ae01-3ded4642a9ed.jpg

Answered: Same problem statement: Weekly demand…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

ABC Corporation resells one type of candle. It has 250 working days. Each day, it sells an average of 500 boxes but maysometimes sell a maximum of 600 boxes. The supplier takes an average of 5 days to deliver the order. During busier times, thesupplier may take 7 days.Based on ABC’s records, ordering cost average P400 per order. Storage cost per box average P5 per year. There is also anopportunity cost of 1% per year for every peso invested in inventories. Each box of candles costs P450. If ABC would continue its current inventory management policy, it would keep 10,000 boxes as safety stock and order ten-days-worth of inventory. (B) Economic Order Quantity 1. How much would the total inventory related (ordering plus carrying) costs be if the economic order quantity wasfollowed (excluding safety stock)? (D) Cost-Benefit Analysis: If ABC maintains its current inventory policy for the year,1. How much would the entity save it followed the reorder point and economic order quantity models?…
A company targets a 97% service level for a product with independent weekly demand that is normally distributed with a mean of 50 and a standard deviation of 10. They use a continuous review policy and order from a supplier with a lead time of 3 weeks. What should their reorder point be? PLEASE SHOW CALCULATIONS/EXCEL WITH FORMULAS
You are in charge of inventory control of a highly successful product retailed by your firm. Weekly demand for this item varies, with an average of 350 units and a standard deviation of 15 units. It is purchased from a wholesaler at a cost of $25.00 per unit. The supply lead time is 7 weeks. Placing an order costs $55.00, and the inventory carrying rate per year is 15 percent of the item's cost. Your firm operates 6 days per week, 50 weeks per year. Refer to the standard normal table The table below shows the total area under the normal curve for a point that is Z standard deviations to the right of the mean. Z 0.00 0.01 0.02 0.03 0.04 0.05 0.06 0.07 0.08 0.09 0.0 0.5000 0.5040 0.5080 0.5120 0.5160 0.5199 0.5239 0.5279 0.5319 0.5359 0.1 0.5398 0.5438 0.5478 0.5517 0.5557 0.5596 0.5636 0.5675 0.5714 0.5754 0.2 0.5793 0.5832 0.5871 0.5910 0.5948 0.5987 0.6026 0.6064 0.6103 0.6141…
Your objective is to help company by determining EOQ* (Economic Order Quantity) that minimizes the totalinventory cost for a company that sells ceiling fans. Your worksheet provides information about the currentorder quantity, demand quantity and other costs.Questions: Answer A and Ba. With the current order quantity, what is the total cost of inventory?b. Implement the problem in Excel and find the order quantity (EOQ) (round to nearest integer) that givesminimum inventory cost. Note: this is a Non-linear programming, hence select “GRG Nonlinear” method inSolver- How much money would company save by switching to optimum quantity from current orderquantity?
Suppose that we would like to determine Reorder Point for the product. From the historical data the manager determined demand during lead-time for that product fits Normal distribution with a mean of 200 and standard deviation of 10 products. The maximum stock out risk is 10%. Answer the following questions according to the (Q, R) system. a) Find the safety stock if the lead time is 2 weeks. b) Find the reorder point. c) Find the reorder point if the stock out risk decreases to 1%. Comment on the result.
Annual demand for a product is 11,960 units; weekly demand is 230 units with a standard deviation of 50 units. The cost of placing an order is $125, and the time from ordering to receipt is four weeks. The annual inventory carrying cost is $0.80 per unit. To provide a 98 percent service probability, what must the reorder point be? Suppose the production manager is told to reduce the safety stock of this item by 125 units. If this is done, what will the new service probability be?
A health and nutrition store stocks a multivitamin with an annual demand of 1,000 bottles has Co = $26.50 and Ch = $7. The demand exhibits some variability such that the lead-time demand follows a normal probability distribution with ? = 25 and ? = 5. (a) What is the recommended order quantity? (Round your answer to the nearest integer.):________ (b) What are the reorder point and safety stock if the store desires at most a 6% probability of stock-out on any given order cycle? (Round your answers to the nearest integer.) reorder point:________ safety stock:________ (c) If a manager sets the reorder point at 30, what is the probability of a stock-out on any given order cycle? (Round your answer to four decimal places.):________ How many times would you expect a stock-out during the year if this reorder point were used? (Round your answer to the nearest integer.):________
your company is facing the situation in which the demand is stochastic but the lead time is known with certainty. Your company has recently implemented a periodic review policy in which your inventory is reviewed every 30 days. The demand is normally distributed with a mean of 600 items annually. The lead time is 25 days, and the annual standard deviation is 100 units. Inventory shows 20 parts in stock. Your company has a policy of 90% service level type I. Also, ordering cost in $20 and holding cost is also $20 per item per year. a) find the order quantity for the next period b) how would your answer change if service level is defined as the expected number of parts available from stock.
Suppose the weekly demand at each regional distribution center (RDC) is normally distributed with a mean =117 and standard deviation =23. The company is considering to replace the RDCs with one central distribution center (CDC). The CDC would continue to have a continuous review policy, and the delivery lead time from Asia will remain 8 weeks. What is the average weekly demand at CDC?

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS