A firm orders on average 400 wheels each month. Demand is normally distributed with standard deviation of the monthly demand being 20 wheels. The ordering cost is $8 per order. The cost to buy one wheel is $4 per wheel. Annual carrying costs are 50% of unit cost. The supplier lead time is 2 operating days. The firm operates 240 days per year, in other word, the firm operates 20 days each month. Each order is received from the supplier in a single delivery. There are no quantity discounts. 1h. What is the standard deviation of demand during lead time period?

A firm orders on average 400 wheels each month. Demand is normally distributed with standard deviation of the monthly demand being 20 wheels. The ordering cost is $8 per order. The cost to buy one wheel is $4 per wheel. Annual carrying costs are 50% of unit cost. The supplier lead time is 2 operating days. The firm operates 240 days per year, in other word, the firm operates 20 days each month. Each order is received from the supplier in a single delivery. There are no quantity discounts. 1h. What is the standard deviation of demand during lead time period?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter10: Introduction To Simulation Modeling

Section10.4: Simulation With Built-in Excel Tools

Problem 14P

See similar textbooks

Similar questions

A retailer uses a periodic review order-up-to model to control the inventory of one of its high volume products. Average demand is 2580 units per week with a standard deviation of 1270. The review period is 5 weeks, the lead time is 11 weeks, and the safety factor used is 0.61. How many stockouts should the retailer expect for this product next year?
The demand faced by CBA company each week is estimated to be normally distributed with a mean of 1000 units and a standard deviation of 250. Lead time of delivery is fixed at 2 weeks. Ordering cost is $800 per order, variable cost per unit ordered is $4, the inventory carrying charge is 20% per year. Assume 50 weeks per year. CBA would like the probability to satisfy customer demand be 95%. Find the (Q,R) policy. If the leadtime is 2 weeks and a standard deviation of 1 week. Find the (Q,R) policy. What is the impact of the weekly demand’s standard deviation on the (Q,R) policy?
An automotive warehouse stocks a variety of parts that are sold at neighborhood stores. One particular part, a popular brand of oil filter, is purchased by the warehouse for $1.50 each. It is estimated that the cost of order processing and reciept is a $100 per order. The company uses an inventory carrying charge based on 28 percent annual interest rate. The monthly demand for the filters follows a normal distribution with mean 280 and a standard deviation 77. Order lead time is assumed to be 5 months. Assume that if a filter is demanded when the warehouse is out of stock, then the demand is back-ordered and the cost assessed for each back-ordered demand is $12.80. Determine the following quantities: a. The optimal values of the order quantity and the reorder level. b. The average annual cost of holding, setup, and stock-out associated with this item assuming that an optimal policy is used. c. Evaluate the cost of uncertanity for this process. That is, compare the average annual cost…
Vallie Enterprise sells a product that cost $200 per unit and has a monthly demand of 500 units. The annual holding cost per unit is calculated as 2% of the unit purchase price. It costs the business $30 to place a single order. The maximum number of units sold for any one week is 150 and minimum sales 80 units. The vendor takes anywhere from 2 to 4 weeks to deliver the merchandise after the order is placed. The EOQ model is appropriate. i) What is the cost minimizing solution for this product each year? ii) Determine the re-order level, minimum inventory level and maximum inventory level for the product.
A company manufacturers 5,000 units of a product per month. The average weekly demand is 275kg. The cost of placing an order is `K100. The purchase price of the raw material is ` K10 per kg. The re-order period is 4 to 8 weeks. The consumption of raw materials varies from 100 kg. to 450 kg. per week. The carrying cost of inventory is 20% of the purchase price. Assuming 52 weeks in a year, you are required to calculate (i) Re-order level (ii) Optimum order quantity and total inventory costs (iii) Maximum stock level (iv) Minimum stock level
Nationwide Auto Parts uses a periodic review inventory control system for one of its stock items. The review interval is 6 weeks, and the lead time for receiving the materials ordered from its wholesaler is 3 weeks. Weekly demand is normally distributed, with a mean of 100 units and a standard deviation of 20 units.a. What is the average and the standard deviation of demand during the protection interval?b. What should be the target inventory level if the firm desires 97.5 percent stockout protection?c. If 350 units were in stock at the time of a periodic review, how many units should be ordered?
Rocky Mountain Tire Centre sells 20,000 tires of a particular type per year. The ordering cost for each order is $40, and the holding cost is 20% of the purchase price of the tires per year. The purchase price is $20. per tire if fewer than 500 tires are ordered, $18. Per tire if more than 500 but fewer than 1,000 tires are ordered and $17. per tire if 1,000 or more tires are ordered. How many tires should Rocky Mountain order each time it places an order? Quantity Unit Price 1-499 $20. 500-999 $18. 1000 & over $17 Based on available information, lead time demand for CD-ROM drives averages 50 units (normally distributed), with a standard deviation of 5 drives. Management wants a 97% service level. What value of Z should be applied? How many drives should be carried as safety stock?
Geox Ltd buys shoes from a supplier in Italy and sells them on to retailers in Australia. Geox Ltd currently uses an EOQ model to determine the number of shoes to send to order. The annual demand for shoes is approximately 45,600. The ordering cost is $55 per order. The annual cost of physically storing shoes is $8.75 per unit. The insurance on the inventory (shoes) cost is $4.25 per unit. The opportunity cost (annual ROI 25% x $30) is $7.50 per unit. The accountant of Geox Ltd, Richard Branson, recently attended a seminar on Just-in-Time (JIT) and is considering how the ideas of JIT differ from traditional techniques like EOQ and how they may help to manage inventory more efficiently. REQUIRED: A) Use the EOQ model to determine the optimal number of shoes per order. (show calculations) B) If it takes two weeks to receive an order, at what point should Geox Ltd reorder shoes? (show calculations) C) Geox Ltd has determined that demand may vary from the average by up to 25%. To handle…
A small coffee shop consumes on average 5000 bags of their most popular coffee beans each month. Demand is normally distributed with standard deviation of the monthly demand being 200 bags. The shop pays $12 for each bag to the supplier. The cost of ordering and receiving shipments is $12 per order. Accounting estimates annual inventory carrying cost is 30% of its value. The supplier lead time is a constant of 2 operating days. The shop operates 240 days per year, i.e., the shop operates 20 days each month. Each order is received from the supplier in a single delivery. The coffee shop uses continuous review (i.e., fixed-order quantity) inventory system and pays the supplier when the order is delivered (i.e., cash on delivery). There are no quantity discounts. Please keep two decimal places in all your calculations. How many times per year will the shop order on average?
A small coffee shop consumes on average 5000 bags of their most popular coffee beans each month. Demand is normally distributed with standard deviation of the monthly demand being 200 bags. The shop pays $12 for each bag to the supplier. The cost of ordering and receiving shipments is $12 per order. Accounting estimates annual inventory carrying cost is 30% of its value. The supplier lead time is a constant of 2 operating days. The shop operates 240 days per year, i.e., the shop operates 20 days each month. Each order is received from the supplier in a single delivery. The coffee shop uses continuous review (i.e., fixed-order quantity) inventory system and pays the supplier when the order is delivered (i.e., cash on delivery). There are no quantity discounts. Please keep two decimal places in all your calculations. What is the store’s minimum total annual cost of placing orders & carrying inventory (cycle stock)?
A small coffee shop consumes on average 5000 bags of their most popular coffee beans each month. Demand is normally distributed with standard deviation of the monthly demand being 200 bags. The shop pays $12 for each bag to the supplier. The cost of ordering and receiving shipments is $12 per order. Accounting estimates annual inventory carrying cost is 30% of its value. The supplier lead time is a constant of 2 operating days. The shop operates 240 days per year, i.e., the shop operates 20 days each month. Each order is received from the supplier in a single delivery. The coffee shop uses continuous review (i.e., fixed-order quantity) inventory system and pays the supplier when the order is delivered (i.e., cash on delivery). There are no quantity discounts. Please keep two decimal places in all your calculations. What quantity should the shop order with each order? How many times per year will the shop order on average? How many operating days will elapse on average between two…
A small coffee shop consumes on average 5000 bags of their most popular coffee beans each month. Demand is normally distributed with standard deviation of the monthly demand being 200 bags. The shop pays $12 for each bag to the supplier. The cost of ordering and receiving shipments is $12 per order. Accounting estimates annual inventory carrying cost is 30% of its value. The supplier lead time is a constant of 2 operating days. The shop operates 240 days per year, i.e., the shop operates 20 days each month. Each order is received from the supplier in a single delivery. The coffee shop uses continuous review (i.e., fixed-order quantity) inventory system and pays the supplier when the order is delivered (i.e., cash on delivery). There are no quantity discounts. Please keep two decimal places in all your calculations. The company currently carries a safety stock of 50 bags. What is the annual cost to carry the safety stock of 50 bags?