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 receipt is $100 per order. The company uses an inventory carrying charge based on a 25 percent annual interest rate. The monthly demand for the filter follows a normal distribution with mean 300 and standard deviation 80. Order lead time is assumed to be five 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. With Type 2 Service objective of 95 percent. Find the optimal values of (Q, R). Q= R=

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 receipt is $100 per order. The company uses an inventory carrying charge based on a 25 percent annual interest rate. The monthly demand for the filter follows a normal distribution with mean 300 and standard deviation 80. Order lead time is assumed to be five 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. With Type 2 Service objective of 95 percent. Find the optimal values of (Q, R). Q= R=

Name: An automotive warehouse stocks a variety of parts that are sold at ne
Uploaded: 2024-03-20T06:57:05.000Z
Channel: Bartleby
Description: An automotive warehouse stocks a variety of parts that are sold at neighborhood stores. One particular part, a popular brand of oil filter, ispurchased by the warehouse for $1.50 each. It is estimated that the cost of order processing and receipt is

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

The home appliance department in a large department store is using a (Q, R) system to control the replenishment of a model of FM radio. The store sells an average of 12 radios each week. Weekly demand follows a normal distribution with variance 30. (Assume that there are 52 weeks in a year.) The store pays $20 for each radio, which it sells for $85. Fixed order cost is $30 per order. The accounting department recommends a 20% interest rate for the cost of capital. Storage costs are 3% and breakage 2% of the purchasing cost of each item. If a customer demands the radio when it is out of stock, the customer will generally go elsewhere. Loss-of-goodwill costs are estimated to be about $25 per radio. Order lead time is 13 weeks. (The penalty cost includes loss of profit and loss of goodwill.) Find the optimal values of (Q, R) based on the penalty cost. What are the values for Q and R if the stock-out cost is replaced with a 95% Type 1 service level?
Annual demand for number 2 pencils at the campus store is normallydistributed with mean 1,000 and standard deviation 250. The store purchases the pencils for 6 cents each and sells them for 20 cents each. There is a two-month lead time from the initiation to the receipt of an order. The store accountant estimates that the cost in employee time for performing the necessary paperwork to initiate and receive an order is $20, and recommends a 22 percent annual interest rate for determining holding cost. The cost of a stock-out is the cost of lost profit plus an additional 20 cents per pencil, which represents the cost of loss of goodwill.a. Find the optimal value of the reorder point R assuming that the lot size used is the EOQ.b. Find the simultaneous optimal values of Q and R.c. Compare the average annual holding, setup, and stock-out costs of the policies determined in parts (a) and (b).d. What is the safety stock for this item at the optimal solution?
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 receipt is $100 per order. The company uses an inventory carrying charge based on a 25 percent annual interest rate. The monthly demand for the filter follows a normal distribution with mean 290 and standard deviation 75. Order lead time is assumed to be five 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. With Type 2 Service objective of 95 percent. Find the optimal values of (Q, R). Q= R=
Good Shoes Company manufactures ski boots for children each pair of which costs $40 to manufacture. Good Shoes sells the boots to a well-known sports goods retailer and the retailer sells each pair for $100. Any boots not sold (by the retailer) during the season are sold to a discount retailer for $20 a pair. Demand during the season is assumed to have a Normal distribution with a mean of 850 and a standard deviation of 350. What should the manufacturer charge the retailer per pair to maximize its expected profits? Assume that Good Shoes will consider a price from the following set: (60,65,70,75,80,85 90,95), i.e., The manufacturer's price will be either $60, or $65 or $70, or ......,,$95).
Annual demand for number 2 pencils at the campus store is normally distributed with mean 1,000 and standard deviation 250. The store purchases the pencils for 6 cents each and sells them for 20 cents each. There is a two-month lead time from the initiation to the receipt of an order. The store accountant estimates that the cost in employee time for performing the necessary paperwork to initiate and receive an order is $20, and recommends a 22 percent annual interest rate for determining holding cost. The cost of a stock-out is the cost of lost profit plus an additional 20 cents per pencil, which represents the cost of loss of goodwill. Consider the problem of satisfying the demand for number 2 pencils faced by the campus store mentioned above.a. Re-solve the problem, substituting a Type 1 service level criterion of 95 percent for the stock-out cost.b. Re-solve the problem, substituting a Type 2 service level criterion of 95 percent for the stock-out cost. Assume that Q is given by the…
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…
The home appliance department of a large department store is using a lot size–reorder point system to control the replenishment of a particular model of FM table radio. The store sells an average of 10 radios each week. Weekly demand follows a normal distribution with variance 26.The store pays $20 for each radio, which it sells for $75. Fixed costs of replenishment amount to $28.The accounting department recommends a 20 percent interest rate for the cost of capital. Storage costs amount to 3 percent and breakage to 2 percent of the value of each item.If a customer demands the radio when it is out of stock, the customer will generally go elsewhere. Loss-of-goodwill costs are estimated to be about $25 per radio. Replenishment lead time is three months.a. If lot sizes are based on the EOQ formula, what reorder level should be used for the radios?b. Find the optimal values of (Q, R).c. Compare the average annual costs of holding, ordering, and stock-out for the policies that you found in…
A grocer purchases plums for $2.95 per pound and sells them for $4.62 per pound. At the end of the sales cycle, leftover plums are sold for a closeout price of $1.76 per pound. The grocer purchases 10,380 pounds of plums. Expected demand is normally distributed with a mean of 8,304 pounds and a standard deviation of 1,038. What is the grocer's expected profit?
Suppose that the manager of a construction supply house determined from historical recordsthat demand for sand during lead time averages 50 tons. In addition, suppose the managerdetermined that demand during lead time could be described by a normal distribution thathas a mean of 50 tons and a standard deviation of 5 tons. Answer these questions, assumingthat the manager is willing to accept a stockout risk of no more than 3 percent:a. What value of z is appropriate?
A golf specialty wholesaler operates 50 weeks per year. Management is trying to determine an inventory policy for its 1-irons, which have the following characteristics:Demand 1D2 = 2,000 units/yearDemand is normally distributedStandard deviation of weekly demand = 3 unitsOrdering cost = $40/orderAnnual holding cost 1H2 = $5/unitsDesired cycle@service level = 90 percentLead time 1L2 = 4 weeksa. If the company uses a periodic review system, what should P and T be? Round P to the nearest week.b. If the company uses a continuous review system, what should R be?
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?
Every four years, Blockbuster Publishers revises its textbooks. It has been three years since the best-selling book, The Joy of OR, has been revised. At present, 2,000 copies of the book are in stock, and Blockbuster must determine how many copies of the book should be printed for the next year. The sales department believes that sales during the next year are governed by the distribution in Table 8. Each copy of Joy sold during the next year brings the publisher $35 in revenues. Any copies left at the end of the next year cannot be sold at full price but can be sold for $5 to Bonds Ennoble and Gitano’s bookstores. The cost of a printing of the book is $50,000 plus $15 per book printed. How many copies of Joy should be printed? Would the answer change if 4,000 copies were currently in stock? Table 8: Copies Demanded Probability 5,000 .30 6,000 .20 7,000 .40 8,000 .10