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. Develop a total cost model for this system. What is the economic order quantity? What is the cycle time? What is the reorder policy for BBB? What total annual cost does the model give?

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. Develop a total cost model for this system. What is the economic order quantity? What is the cycle time? What is the reorder policy for BBB? What total annual cost does the model give?

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

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

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

Chapter16: Lean Supply Chain Management

Section: Chapter Questions

Problem 10DQ: The chapter presented various approaches for the control of inventory investment. Discuss three...

See similar textbooks

Similar questions

Surge Electric uses 4,000 toggle switches a year. Switches are priced as follows: 1 to 499, 90cents each; 500 to 999, 85 cents each; and 1,000 or more, 80 cents each. It costs approximately$30 to prepare an order and receive it, and carrying costs are 40 percent of purchase price perunit on an annual basis. Determine the optimal order quantity and the total annual cost.
A pharmacist wants to establish an optimal inventory policy for a new antibiotic that requires refrigeration in storage. The pharmacist expects to sell 6000 packages of this antibiotic at a steady rate during the next year. She plans to place several orders of the same size spaced equally throughout the year. The ordering cost for each delivery is $15, and carrying costs, based on the average number of packages in inventory, amount to $8 per year for one package. Use this information to answer the following questions. a) Let x be the order quantity and r the number of orders placed during the year. Find the inventory cost (ordering cost plus carrying cost) in terms of x and r. b) Find the constraint function. c) Determine the economic order quantity that minimizes the inventory cost and then find the minimum inventory cost. X=__________ C=$___________
Jim recently acquired a designer shoe store in downtown silver spring. The former owner always ordered 100 pairs of shoes. Jim wants to reevaluate this policy. Based on his analysis, the cost to place each order is $40 and the holding cost is $12 per shampoo bottle per year. The annual demand for this product is 2500 pairs. Should Jim change the current order policy and, if so, how much can she save? Answer in two decimal places. (Hint: Calculate annual total cost using the old and the new policy and compare)
JAL Trading is a Hong Kong manufacturer of electroniccomponents. During the course of a year it requires container cargo space on ships leaving Hong Kong bound forthe United States, Mexico, South America, and Canada.The company needs 280,000 cubic feet of cargo space annually. The cost of reserving cargo space is $7000 and thecost of holding cargo space is $0.80/ft3. Determine howmuch storage space the company should optimally order,the total cost, and how many times per year it should placean order to reserve space
In the past, Taylor Industries has used a fixed−time period inventory system that involved taking a complete inventory count of all items each month. However, increasing labor costs are forcing Taylor Industries to examine alternative ways to reduce the amount of labor involved in inventory stockrooms, yet without increasing other costs, such as shortage costs. Here is a random sample of 20 of Taylor's items. ITEMNUMBER ANNUALUSAGE ITEMNUMBER ANNUALUSAGE 1 $ 1,500 11 $ 13,000 2 12,000 12 600 3 2,200 13 42,000 4 50,000 14 9,900 5 9,600 15 1,200 6 750 16 10,200 7 2,000 17 4,000 8 11,000 18 61,000 9 800 19 3,500 10 15,000 20 2,900 a. Classify each item in inventory using an ABC plan
Hayes Electronics assumed with certainty that the ordering cost is $450 per order and the inventory carrying cost is $170 per unit per year. However, the inventory model parameters are frequently only estimates that are subject to some degree of uncertainty. Consider four cases of variation in the model parameters: (a) Both ordering cost and carrying cost are 10% less than originally estimated, (b) both ordering cost and carrying cost are 10% higher than originally estimated, (c) ordering cost is 10% higher and carrying cost is 10% lower than originally estimated, and (d) ordering cost is 10% lower and carrying cost is 10% higher than originally estimated. Determine the optimal order quantity and total inventory cost for each of the four cases. Prepare a table with values from all four cases and compare the sensitivity of the model solution to changes in parameter values.
The Interstate Carpet Discount Store has annual demand of10,000 yards of Super Shag carpet. The annual carrying costfor a yard of this carpet is $1.25, and the ordering cost is$300. The carpet manufacturer normally charges the store $8per yard for the carpet. However, the manufacturer has offered a discount price of $6.50 per yard if the store will order5000 yards. How much should the store order, and what willbe the total annual inventory cost for that order quantity?
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?
In the past, Taylor Industries has used a fixed−time period inventory system that involved taking a complete inventory count of all items each month. However, increasing labor costs are forcing Taylor Industries to examine alternative ways to reduce the amount of labor involved in inventory stockrooms, yet without increasing other costs, such as shortage costs. Here is a random sample of 20 of Taylor's items. ITEMNUMBER ANNUALUSAGE ITEMNUMBER ANNUALUSAGE 1 $1,900 11 $13,800 2 12,700 12 1,000 3 2,700 13 43,600 4 51,800 14 10,600 5 10,300 15 1,600 6 1,200 16 10,900 7 2,500 17 4,500 8 11,700 18 63,200 9 5,600 19 4,000 10 15,800 20 3,400 a. Classify each item in inventory using an ABC plan. item # Class (A, B, or C) 1 2 3 4 5 6 7 8 9 10
Rafiki Bar uses 10,000 cases of millet beer monthly. One case costs Shs.5,000. Holding cost is 30% of the cost of a case p.a while ordering cost is Shs.100,000 per order. The firm works 360 days in a year while lead time is 6 days. Required: ii. Determine the days between orders and the reorder point iii. Determine the total cost of the inventory policy iv. Suppose actual holding cost turns out to be 15% instead of 30% and the inventory policy above is implemented for a year, determine the cost of prediction error if every other parameter estimate turns out as predicted.
Petromax Enterprises uses a continuous review policy to manage the inventory for one of its SKUs. The following information is available on the item. The firm operates 50 weeks in a year. Demand = 90,000 units/year Ordering Cost = $60/Order Holding Cost = $3/Unit/Order Lead Time = 10 weeks Standard Deviation of Weekly Demand = 200 units Suppose due to some recent changes to the target service level, they have determined the reorder point to be 20,000. If the inventory position of this SKU is currently 19,600, how many units should they order? (Round your answer to the nearest whole number, if it has decimals. Input 0 if they should not order now.)
Custom Computers, Inc. assembles custom home computer systems. The heat sinks needed are bought for $12 each and are ordered in quantities of 1300 units. Annual demand is 5200 heat sinks, the annual inventory holding cost rate is $3 per unit, and the cost to place an order is estimated to be $50. Calculate the following: (a) Average inventory level (b) The number of orders placed per year (c) The total annual inventory holding cost (d) The total annual ordering cost (e) The total annual cost