A museum of natural history is having problems managing their inventories. Low inventory turnover is squeezing profit margins and causing cash-flow problems. A Class A item, a birdfeeder is also a top-selling item. See information for this item in the table below. Management has been ordering in lots of 390 units. 1) What is the annual cost of the current policy (hint: find the current total cost with the current order size, Q)? 2) What is the Economic Order Quantity or the optimum order quantity (EOQ) for the birdfeeders? 3) What is the total annual cost of ordering at the EOQ? How much could be saved if the museum ordered at the EOQ opposed to their current order size of 390 units?

A museum of natural history is having problems managing their inventories. Low inventory turnover is squeezing profit margins and causing cash-flow problems. A Class A item, a birdfeeder is also a top-selling item. See information for this item in the table below. Management has been ordering in lots of 390 units. 1) What is the annual cost of the current policy (hint: find the current total cost with the current order size, Q)? 2) What is the Economic Order Quantity or the optimum order quantity (EOQ) for the birdfeeders? 3) What is the total annual cost of ordering at the EOQ? How much could be saved if the museum ordered at the EOQ opposed to their current order size of 390 units?

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

Saga ltd. produces electronic toys for children between the ages of 7-10 years old. The toys use a processor that is imported from Japan. Annual demand for the processor is 12,500. The holding cost per processor per year is $2. Ordering cost per order is $400. Lead time is 7 days and the number of working days in the year is 250. d. What is the optimal number of days between any two orders? e. What is the reorder point? f. Given the EOQ, what is the total annual inventory cost?
Suppose that the R&B Beverage Company has a soft drink product that shows a constant annual demand rate of 3,800 cases. A case of the soft drink costs R&B $3. Ordering costs are $20 per order and holding costs are 25% 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 (round your answer to the nearest integer.) _____450_______ b. reorder point ______76______ c. cycle time (in days) (round your answer to two decimal places.) ______29.61______ d. total annual cost (in $) (round your answer to two decimal places.) _____?_______ ***I am asking the question with the ? symbol. I have been able to locate the numbers for the first three but I am having issues computing my answers for the last one.
William Beville's computer training school, in Richmond, stocks workbooks with the following characteristics: Demand D 20,000 units/year Ordering cost S $23/order Holding cost H $3/unit/year Part 2 a) The EOQ for the workbooks is ________ (round your response to the nearest whole number). Part 3 b) What are the annual holding costs for the workbooks? $________ (round your response to the nearest whole number). Part 4 c) What are the annual ordering costs? $_________ (round your response to the nearest whole number).
Q 1 Super K Beverage Company distributes a soft drink that has a constant annual demand rate of 4,600 cases. A 12-pack case of the soft drink costs Super K $2.25. Ordering costs are $20 per order, and inventory-holding costs are charged at 25 percent of the cost per unit. There are 250 working days per year, and the lead time is four days. Find the economic order quantity and total annual cost, and compute the reorder point. Q 2 Environmental considerations, material losses, and waste disposal can be included in the EOQ model to improve inventory management decisions. Assume that the annual demand for an industrial chemical is 1,200 lb, item cost is $5/lb, order cost is $40, inventory-holding cost rate (percent of item cost) is 18 percent. Q3 An insurance claims work area has five claims waiting for processing as follows. Job Processing Time Due Date (Di) 1 22 35 2…
Ross White’s machine shop uses 2500 brackets during the course of a year, and this usage is relatively constant throughout the year. These brackets are purchased from a supplier 100 miles away for $15 each, and the lead time is 2 days. The holding cost per bracket per year is $1.50 (or 10% of the unit cost) and the ordering cost per order is $18.75. There are 300 working days per year. A. What is the reorder policy? B. What are the total annual holding and ordering costs associated with your recommended EOQ? C. What is the total annual cost associated with your recommended EOQ?
The Star Equipment Company purchases 54,000 bearing assemblies each year at a unit cost of $40.00. The holding cost is $9.00 per unit per year, and the ordering cost is $20.00. What is the economic order quantity? How many orders should be placed per year? If the lead time is one (01) month, what is the re-order point for the assemblies?
It’s your responsibility, as the new head of the automotive section of Nichols Department Store, to ensure that reorder quantities for the various items have been correctly established. You decide to test one item and choose Michelin tires, XW size 185 x 14 BSW. A perpetual inventory system has been used, so you examine this, as well as other records, and come up with the following data. Cost per tire $55 each Holding cost 15 percent of tire cost per year Demand 1,180 per year Ordering cost $ 36 per order Standard deviation of daily demand 7 tires Delivery lead time 8 days Because customers generally do not wait for tires but go elsewhere, you decide on a service probability of 95 percent. Assume the…
A company purchases special metal parts to make office furniture in lots of 100 units to satisfy an annual demand of 1600 parts. Holding cost for the parts is 0.3 dollars per unit per month and ordering cost is 40 dollars per order. Answer the following questions: Formulas: a) What is the EOQ? b) What are the costs previously (with 100 units per order) and now with EOQ. Hint: Calculate total holding cost and ordering cost for 100 units, and then same costs with EOQ. Which one (100 units or EOQ) is better in terms of costs? EOQ = SQRT(2Ds/h) THC=h*(Q/2) TOC=s*(D/Q) TC=THC+TOC please answer in excel
Abey Kuruvilla, of Parkside Plumbing, uses 1,250 of a certain spare part that costs $26 for each order, with an annual holding cost of $27. a) Calculate the total cost for order sizes of 25, 40, 50, 60, and 100 (round your responses to two decimal places). b) What is the economic order quantity? units (round your response to two decimal places).
Saga ltd. produces electronic toys for children between the ages of 7-10 years old. The toys use a processor that is imported from Japan. Annual demand for the processor is 12,500. The holding cost per processor per year is $2. Ordering cost per order is $400. Lead time is 7 days and the number of working days in the year is 250. a. What is the economic order quantity? b. What is the optimal number of orders per year? c. Calculate the annual holding cost if the economic order quantity is used. d. What is the optimal number of days between any two orders? e. What is the reorder point? f. Given the EOQ, what is the total annual inventory cost?
Bat 'Em Up Inc., is a company that markets baseball bats to universities. Mr. Homerun, it's CEO, will reduce its inventory cost by determining the optimal number of baseball bats to obtain per order. The annual demand is 100,000 units and the ordering cost is $10 per order. The carrying cost per unit is $2.00. What is their expected annual ordering cost (not including the costs of the goods) if they will use the Economic Order Quantity to place orders?
G-Tech’s monthly demand is 1000 units. You are in charge of the inventory department. You know that the holding cost is $100 per unit and ordering cost is $4,000 per order. What is the EOQ? 2. What is the number of orders per year? 3. What is the annual holding cost? (not Total cost, just the holding cost portion! 4. If we decide to order a quantity of 1000 units instead of the EOQ, what happens to the annual holding cost? (Just tell me in words – could be 3 short words!)