Your company has the following items in inventory: Annual Demand 1200 100 4500 400 35 250 1000 100 Item A B с D E F G H Unit Cost $9 $90 $6 $150 $2000 $120 $90 $75 a) What is the annual dollar volume for all items b) Perform an ABC analysis on the data. Which are the A items, the B items and the C item: c) Why is it desirable to classify items into groups, as the ABC classification scheme does?

Your company has the following items in inventory: Annual Demand 1200 100 4500 400 35 250 1000 100 Item A B с D E F G H Unit Cost $9 $90 $6 $150 $2000 $120 $90 $75 a) What is the annual dollar volume for all items b) Perform an ABC analysis on the data. Which are the A items, the B items and the C item: c) Why is it desirable to classify items into groups, as the ABC classification scheme does?

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

David Alexander has compiled the following table of six itemsin inventory at Angelo Products, along with the unit cost andthe annual demand in units:IDENTIFICATION CODE UNIT COST ($) ANNUAL DEMAND(UNITS)XX1 5.84 1,200B66 5.40 1,1103CPO 1.12 89633CP 74.54 1,104R2D2 2.00 1,110RMS 2.08 961 Use ABC analysis to determine which item(s) should be care-fully controlled using a quantitative inventory technique and which item(s) should not be closely controlled.
The two most important inventory-based questionsanswered by the typical inventory model are:a) when to place an order and the cost of the order.b) when to place an order and how much of an itemto order.c) how much of an item to order and the cost of the order.d) how much of an item to order and with whom theorder should be placed.
A clothing manufacturing company requires raw materials for 8 consecutive weeks as follows: 30, 40, 50, 35, 60, 30, 40, and 30 units with a one-time order cost of $50,000 and a storage fee of $500 per unit/week. From these data calculate the total cost of procurement using:a. Lot For Lot (LFL) Methodb. Economic Order Quantity (EOQ) Methodc. Period Order Quantity (POQ) Methodd. In your opinion as an operations manager at the company which method would you choose? Explain, why?
Use the ABC method of classifying inventory control over the itemsin the following inventory list. Use the total cost per item column to create thelisting. In Excel with formulas Item Annual Usage (in Units) Unit cost ($) Total Cost per Item1 6,000 1.4 8,4002 1,500 10 15,0003 11,000 9.5 104,5004 6,500 2.5 16,2505 8,500 0.6 5,1006 7,000 14.5 101,5007 6,000 0.8…
A company manufactures two products A and B. Each A requires two C’s and one D. Each D requires two F’s and one E, while each E requires one F. Each product B requires one D and two E’s. The table below shows data from the inventory records. ITEM ITEM ITEM ITEM DATA CATEGORY C D E F Lot - sizing rule Fixed Order Quantity = 220 Lot for Lot Fixed Order Quantity = 300 Period Order Quantity P = 2 Lead time 3 weeks 2 weeks 3 weeks 2 weeks Scheduled receipts 280 (week 1) None 300 (week 3) None Beginning inventory 25 0 150 600 The MPS for product A calls for 85 units to be started in week 3 and 100 units to be started in week 6. The MPS for product B calls for 180 units to be started in week 5.Develop the material requirements plan (showing Gross requirements, Scheduled receipts, On hand inventory, Net requirements, and Planned-order release) for the next six weeks for items C, D, E and F.
Anglo American Platinum uses ABC analysis as an inventory categorisation method. The current inventory ordering policy is to order 10 000 units of an ‘A’-item inventory when the level falls to 4 500 units. Forecast demand to meet production requirements during the next year is 62 500 units. The cost of placing and processing an order relating to this inventory item is R250, while the cost of holding a unit in store is R50 per unit per year. You anticipate that both costs will be constant during the next year. Orders are received two weeks after being placed with the supplier. Assume a 50-week year and that demand is constant throughout the year. Using a quantitative analysis, appraise the optimality of the current ordering policy of the ‘A’-item inventory (Show all calculations).
Given this information:Lead-time demand = 615 poundsStandard deviation of lead time demand = 48 pounds (Assume normality.)Acceptable stockout risk during lead time = 4 percentUse Table. a. What amount of safety stock is appropriate? (Round your answer to the nearest whole number.) Safety stock units b. How much of this item should be reordered? (Round your answer to the nearest whole number.) ROP units c. What risk of stockout would result from a decision not to have any safety stock? (Omit the "%" sign in your response.) Stockout risk %
Penalty costs can be assessed only against the number of units of demand that cannot be satisfied, or against the number of units weighted by the amount of time thatan order stays on the books. Consider the following history of supply and demandtransactions for a particular part:Number of Items Demand duringMonth Received MonthJanuary 200 520February 175 1,640March 750 670April 950 425May 500 280June 2,050 550Assume that starting inventory at the beginning of January is 480 units.a. Determine the ending inventory each month. Assume that excess demands areback-ordered.b. Assume that each time a unit is demanded that cannot be supplied immediately,a one-time charge of $10 is made. Determine the stock-out cost incurred duringthe six months (1) if excess demand at the end of each month is lost, and (2) ifexcess demand at the end of each month is back-ordered.c. Suppose that each stock-out costs $10 per unit per month that the demandremains unfilled. If demands are filled on a first-come,…
asap!! A manager of an inventory system believes that inventory models are important decision making aids. Even though often using an EOQ policy, the manager never considered a backorder model because of the assumption that backorders were “bad” and should be avoided. However, with upper management’s continued pressure for cost reduction, you have been asked to analyze the economics of a backorder policy for some products that can possibly be backordered. For a specific product with D = 1200 units per year, Co = 160, = 4, and = 25, what is the difference in total annual cost between the EOQ model and the planned shortage or backorder model? If the manager adds constraints that no more than 25% of the units can be backordered and that no customer will have to wait more than 18 days for an order, should the backorder inventory policy be adopted? Assume 300 working days per year.
Brock Co. adopted the dollar-value LIFO inventory method as of January 1, year 1. A single inventory pool and an internally computed price index are used to compute Brock’s LIFO inventory layers. Information about Brock’s dollar-value inventory follows: What was Brock’s dollar-value LIFO inventory at December 31, year 2? a. $80,000 b. $74,000 c. $66,000 d. $60,000
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?
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…