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?

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?

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 warehouse checks inventory and places an order from a supplier for a particular product once a month. The monthly demand for the product is independent and normally distributed with a mean of 500 and a standard deviation of 100. If the warehouse targets a 90% service level for this product, and the supplier’s lead time is one month, how much safety stock should be held? PLEASE SHOW CALCULATIONS/EXCEL WITH FORMULAS
A health and nutrition store stocks a multivitamin with an annual demand of 1,000 bottles has Co = $24.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 4% probability of stock-out on any given order cycle? (Round your answers to the nearest integer.) reorder pointsafety 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.)
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.):________
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?
A Mercedes dealer purchases vehicles for $20,000. The annual holding cost is estimated to be 25% of the dollar value of inventory. The dealer sells an average of 500 cars per year. He believes that demand is backlogged, but estimates that if he is short one car for one year, he will lose $20,000 in future profits. Each time the dealer places an order for cars, the ordering cost amounts to $10,000. What is the (s, Q) ordering policy that results in a 90% CSL?
A department store uses a (Q, R) policy to control its inventories. Sales of a pocket FM radioaverage 1.4 radios per week. The radio costs the store $50.00, and fixed costs of replenishmentamount to $20.00. Holding costs are based on a 20 percent annual interest charge, and thestore manager estimates a $12.50 cost of lost profit and loss of goodwill if the radio is demanded when out of stock. Reorder lead time is 2 weeks, and statistical studies have shownthat demand over the lead time is accurately described by a Poisson distribution. Find the optimallot sizes and reorder points for this item.
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…
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 distributor of large appliances needs to determine the order quantities and reorderpoints for the various products it carries. The following data refer to a specii c refrigeratorin its product line:Cost to place an orderHolding costCost of refrigeratorAnnual demandStandard deviation of demand during lead timeLead time$10020 percent of product cost per year$500 each500 refrigerators10 refrigerators7 daysConsider an even daily demand and a 365-day year.a. What is the economic order quantity?b. If the distributor wants a 97 percent service probability, what reorder point, R, shouldbe used?
Please do not give solution in image formate thanku. A product’s demand over (l + 1) periods is normally distributed with a mean of 100 and standard deviation of 10. Lead time is 2 periods. The order-up-to model is used to manage inventory. If in-stock probability stays at 99%, what will happen to expected on-hand inventory when expected demand increases to 200?             A) It will increase.                  B) It will stay the same.             C) It will decrease.             D) It may either increase or decrease.
A company stocks an item that is consumed at the rate of 30 units each day. Every time an order is placed for new supply, $ 120 must be paid. A unit inventory held in stock for one week will cost $ 0.14. What is the total annual cost if the order quantity is 200 more than EOQ? What is the optimum number of orders (rounded to the closest integer) that the company has to place each year?   Assume that the company has a standing policy of not allowing shortages in demand.
I need a detailed explanation on how to solve this problem: A paint shop implements an inventory policy on its stock of white paint, which costs the store $6 per can. Monthly demand for cans of white paint is normal with mean 28 and standard deviation 8. The replenishment lead time is 14 weeks. Excess demand is backordered, but costs $10 per back ordered can in labor and loss of goodwill. There is a fixed cost of $15 per order, and the holding cost is based on 30% interest rate per annum. In your computations, assume 4 weeks per month. - Write down the model name and parameters. - What are the optimal lot size and reorder points for white paint (include the formulas)? - What is the optimal safety stock (include the formula)?   *** Suppose the paint shop from the above problem adopts a service level policy. - What are the optimal lot size and reorder points for white paint, such that 90% of the cycles are filled without backordering (include all formulas)? - What is the fill rate…