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

A manufacturer buys cardboard boxes from a supplier. The annual demand is 40,000 boxes and is uniformly distributed. The boxes cost $5 each. The estimated order cost is $10, and the carrying cost rate is 20% per year. What is the EOQ and what is the annual order and carrying cost? How many times a year are orders placed, and what is the average time, in weeks, between orders? Using the answer from (b), if you round the average time between orders to the nearest week, what should the order quantity be? Would you recommend using this order quantity and time interval? Suppose that the actual demand turns out to be 80,000 boxes instead of 40,000 boxes.If you had used the EOQ from the (a), what would be the annual order and carrying cost be?
Suppose that the R&B Beverage Company has a soft drink product that shows a constant annual demand rate of 3,600 cases. A case of the soft drink costs R&B $4. Ordering costs are $22 per order and holding costs are 23% of the value of the inventory. R&B has 250 working days per year, and the lead time is 5 days. Identify the following aspects of the inventory policy: a. Economic order quantity. If required, round your answer to two decimal places.Q = b. Reorder point. If required, round your answer to the nearest whole number.r =c. Cycle time. If required, round your answer to two decimal places.T = daysd. Total annual cost. If required, round your answer to two decimal places.TC = $
A company has a demand for 25,750 units annually. The holding cost is 33% of the item cost which is $10.00. The ordering or set-up cost is $250.00 per order and the lead time is 5 days. Assume that there are 350 days per year Suppose a price break of $50 per order is offered for purchase quantities of 2,000 or greater. Question: What is the reorder point for this inventory strategy? What is the inventory position immediately after an order is placed for the inventory strategy that you have selected?
You are in the process of deciding the optimal order quantity of shampoo packs for a hotel. The supplier charges you $47 per order and your stockroom costs approximately $0.69 per shampoo pack per year to store the product. Based on prior research, you were able to determine that the hotel goes through approximately 94 shampoo packs per day. They hold 0 safety stock. The supplier is willing to give the following quantity discounts for the product. Using the order quantity that will minimize total cost, what is the total annual cost? Quantity 1 - 1499 $2.25 $2.10 $2.05 $2.03 Note: Round your answer to 2 decimal places. Do NOT include $ sign or a comma. For example, answer like 50246 and NOT $50,246 Answer: 1500 - 3999 4000 - 7999 8000+ Price Check
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
During the last 5 weeks, demands for a certain SKU at a retailer were 7 units (5 weeks ago), 4 units, 4 units, 4 units, and 5 units (last week). The retailer uses a period review model with order-up-to level 71 units, a review period of 2 weeks, and the lead time is 11 weeks. It is time to order. How much should the retailer order?
Bart’s Barometer Business (BBB) is a retail outlet that deals exclusively with weather equipment. Currently BBB is trying to decide on an inventory and reorder policy for home barometers. These cost BBB $60 each and demand is about 1200 per year distributed fairly evenly throughout the year. Reordering costs are $50 per order and holding costs are figured at 20% of the cost of the item. BBB is open 300 days a year (6 days a week and closed two weeks in August). Lead time is 60 working days. a.Develop a total cost model for this system. b. What is the optimal reorder quantity? c. What is the cycle time?
Polymorph Promotions finds that demand for an item is Normally distributed with a mean of 2,000 units a year and a standard deviation of 400 units. Unit cost is $100, reorder cost is $200, holding cost is 20% of value a year and lead time is fixed at 3 weeks. Compute the (s,Q) ordering policy that gives a 95% service level and the annual cost of the safety stock.
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…
An engineer has decided to pursue ordering option for a particular item on an as needed basis as oppose to stocking it. To stock the item, inventory inspection costs $500 annually. The cost to place an order is estimated at $125. For the ordering option, there is an additional $85 special delivery charge per order. Demand for the $20 item is 2,300 units per year. The annual holding cost rate is 40% of the item price. Calculate range of the order quantity that will make it economical to order this item every time. If the engineer decides to stock the item what is the order quantity that is economical.
Suppose that the retailer SnowInc buys ski jackets from the Chinese manufacturerJacketCo. Due to the short selling season and long delivery lead time for this fashiongood, this is a one-time purchase decision. SnowInc estimates the season’s demand forone type of jacket to be normally distributed with mean 500 and standard deviation 100.Retail price for the jacket is $100. If not sold at the end of the season they unload themfor $10 per jacket. The wholesale price JacketCo charges is $30 per jacket and JacketCo’sper unit manufacturing cost is $12. How many jackets should SnowInc order and what arethe two firms’ profits? If both firms were owned by the same company, how would theseanswers change?
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?

SEE MORE QUESTIONS

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