Xemex has collected the following inventory data for the six items that it stocks: ITEM CODE UNIT COST ($) ANNUAL DEMAND (UNITS) ORDERING COST ($) CARRYING COST AS A PERCENTAGE OF UNIT COST 1 10.60 600 40 20 2 11.00 450 30 25 3 2.25 500 50 15 4 150.00 560 40 15 5 4.00 540 35 16 6 4.10 490 40 17 Lynn Robinson, Xemex’s inventory manager, does not feel that all of the items can be controlled. What ordered quantities do you recommend for which inventory product(s)?

Xemex has collected the following inventory data for the six items that it stocks: ITEM CODE UNIT COST ($) ANNUAL DEMAND (UNITS) ORDERING COST ($) CARRYING COST AS A PERCENTAGE OF UNIT COST 1 10.60 600 40 20 2 11.00 450 30 25 3 2.25 500 50 15 4 150.00 560 40 15 5 4.00 540 35 16 6 4.10 490 40 17 Lynn Robinson, Xemex’s inventory manager, does not feel that all of the items can be controlled. What ordered quantities do you recommend for which inventory product(s)?

Name: Xemex has collected the following inventory data for the six items tha
Uploaded: 2024-03-20T06:57:05.000Z
Channel: Bartleby
Description: Xemex has collected the following inventory data for the six items that it stocks:ITEM CODEUNIT COST ($)ANNUAL DEMAND (UNITS)ORDERING COST ($)CARRYING COST AS A PERCENTAGE OF UNIT COST110.606004020211.00450302532.2550050154150.00560401554.00540351664

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

ITEM CODE	UNIT COST ($)	ANNUAL DEMAND (UNITS)	ORDERING COST ($)	CARRYING COST AS A PERCENTAGE OF UNIT COST
1	10.60	600	40	20
2	11.00	450	30	25
3	2.25	500	50	15
4	150.00	560	40	15
5	4.00	540	35	16
6	4.10	490	40	17

Similar questions

The chapter presented various approaches for the control of inventory investment. Discuss three additional approaches not included that might involve supply chain managers.
Barbara Flynn's company has compiled the following 12.5 ata on a small set of products: ITEM A B C D E ANNUAL DEMAND ITEM NUMBER E102 D23 D27 R02 R19 $107 $123 U11 U23 V75 100 75 50 200 150 Perform an ABC analysis on her data. PX 12.6 Lynn Fish opened a new beauty-products retail store. There are numerous items in inventory, and Lynn knows that there are costs associated with inventory. However, because her time is limited, she cannot carefully evaluate the inventory policy for all products. Lynn wants to classify the items according to dol- lars invested in them. The following table provides information about the 10 items that she carries: UNIT COST $300 100 50 100 65 UNIT COST $4 $16 $8 $2 $8 $12 $1 $7 $1 $14 DEMAND (UNITS) 800 2,400 700 1,000 200 500 1,200 800 Use ABC analysis to classify these items into categories A, B, and C. PX 1,500 2,500 Problems 12.7-12.40 relate to Inventory Models for Independent Demand • 12.7 William Beville's computer training school, in Richmond, stocks…
“The ABC Supply company is currently experiencing with an inventory rotation problem. This difficulty stems from the fact that some supplies must be used prior to a stated expiration date. Upon receipt, a new shipment of these perishable items must be stacked beneath the boxes that are currently in inventory. A substantial amount of time is consumed in restacking the items according to their expiration dates.” Required: Explain the DMAIC methodology that can be used by the “ABC” company to implement Six Sigma Process for the above scenario. 800 words
“The ABC Supply company is currently experiencing with an inventory rotation problem. This difficulty stems from the fact that some supplies must be used prior to a stated expiration date. Upon receipt, a new shipment of these perishable items must be stacked beneath the boxes that are currently in inventory. A substantial amount of time is consumed in restacking the items according to their expiration dates.” Required: Explain the DMAIC methodology that can be used by the “ABC” company to implement Six Sigma Process for the above scenario.
Fisk Corporation is trying to improve its inventory control system and has installed an online system at its retail stores. Fisk anticipates sales of 58,800 units per year, an ordering cost of $4 per order, and carrying costs of $1.50 per unit. In the second year, Fisk Corporation finds that it can reduce ordering costs to $1 per order, but carrying costs will stay the same at $1.50 per unit. a-1. What is the economic ordering quantity for the second year? Economic ordering quantity (EOQ) a-2. How many orders will be placed during the second year? Number of orders a-3. What will the average inventory be for the second year? Average inventory Total costs units units a-4. What is the total cost of ordering and carrying inventory for second year? LA
The materials manager for a billiard ball maker must periodically place orders for resin, one of the raw materials used in producing billiard balls. She knows that manufacturing uses resin at a rate of 50 kilograms each day, and that it costs $.04 per day to carry a kilogram of resin in inventory. She also knows that the order costs for resin are $100 per order, and that the lead time for delivery is four days. If the order size was 1,000 kilograms of resin, what would be the average inventory level?
Black Instrument Company replenishes highly specialized replacement (service) parts based on statistical reorder point. One part is a 40-mm thumbscrew. Relevant data for the thumbscrew are: Planned stock out frequency= Six per year. Planned lead time = 2 weeks Forecast for next week= 300 Batch size = 400 Standard deviation of demand = 20 (per week) What is the reorder point? What would be the effect on the ROP if lead time were five weeks instead of two? What other factors might impact your decision on when to reorder parts?
Catlea Merchandising is engaged in selling school shoesfor both boys and girls in their teenage years. Catlea needs 32,000 pairs of shoes in a year in order to satisfy the market demand. It costs ₱ 48 to place an order while ₱ 8 is needed to hold each quantity of shoe in Catlea's inventory. Upon checking on Catlea's supplier, it takes 8 days in between placing an order and eventually receiving it. a. Determine the Economic Order Quantityb. Determine the number of order per monthc. Determine the reorder point
Alina Limited is a manufacturer of widgets orders components for use in manufacturing. The estimated demand for the components during the coming year is 15,000. Order costs are $100 per order; carrying costs are $12 per component. Using the economic order quantity model What is Alina Ltd’s optimum order quantity? If the supplier guarantees a three (3) day delivery on any order that is placed, What is the re-order point?
Fisk Corporation is trying to improve its inventory control system and has installed an online computer at its retail stores. Fisk anticipates sales of 112, 500 units per year, an ordering cost of $3 per order, and carrying costs of $1.20 per unit. a. What is the economic ordering quantity? b. How many orders will be placed during the year? c. What will the average inventory be? d. What is the total cost of ordering and carrying inventory?
Why do we use "Specifications or bill of material" in the dependent inventory model?
Southern Markets, Inc. is considering the use of ABCanalysis to focus on the most critical SKUs in its inventory.Currently, there are approximately 20,000 different SKUswith a total dollar usage of $10,000,000 per year.a. What would you expect to be the number of SKUs and thetotal annual dollar usage for A items, B items, and C itemsat Southern Markets, Inc.? b. The following table provides a random sample of the unitvalues and annual demands of eight SKUs. Categorizethese SKUs as A, B, and C items.