2. The following table contains figures on the monthly volume and unit costs for a random sampla et16 items from a list of 2,000 inventory items at a health care facility:Unit CostUsageItemUnit CostUsageItemK34$10200F992060К3525600D4510550K3636150D4812M101625D5215110M202080D5740120Z4580200N083040F1420300P0516500F9530800P091030a. Develop an A-B-C classification for these items.

Name: 2. The following table contains figures on the monthly volume and uni
Uploaded: 2024-03-20T06:57:05.000Z
Channel: Bartleby
Description: 2. The following table contains figures on the monthly volume and unit costs for a random sampla et16 items from a list of 2,000 inventory items at a health care facility:Unit CostUsageItemUnit CostUsageItemK34$10200F992060К3525600D4510550K3636150D4

Answered: Image /qna-images/answer/56ee7bca-0124-4c4b-b765-c29f36464ec4.jpg

Business

Operations Management

2. The following table contains figures on the monthly volume and unit cósts for a random samala 16 items from a list of 2,000 inventory items at a health care facility: Item Unit Cost Usage Item Unit Cost Usage К34 $10 200 F99 20 60 К35 25 600 D45 10 550 К36 36 150 D48 12 90 M10 16 25 D52 15 110 M20 20 80 D57 40 120 Z45 80 200 N08 30 40 F14 20 300 P05 16 500 F95 30 800 P09 10 30

2. The following table contains figures on the monthly volume and unit cósts for a random samala 16 items from a list of 2,000 inventory items at a health care facility: Item Unit Cost Usage Item Unit Cost Usage К34 $10 200 F99 20 60 К35 25 600 D45 10 550 К36 36 150 D48 12 90 M10 16 25 D52 15 110 M20 20 80 D57 40 120 Z45 80 200 N08 30 40 F14 20 300 P05 16 500 F95 30 800 P09 10 30

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

L. Houts Plastics is a large manufacturer of injection-molded plastics in North Carolina. An investigation of the company's manufacturing facility in Charlotte yields the information presented in the table below. How would the plant classify these items according to an ABC classification system? (Round dollar volume to the nearest whole number and percentage of dollar volume to two decimal places.) For the following three questions, consider only items 1289, 2349, and 8210from the above table for relative classification (these are some of the items for which you computed the metrics). Based on the percentages of dollar volume, item number 1289 should be classified as Item number 2349 should be classified as Item number 8210 should be classified as .
. The following table contains figures on the monthly volume and unit costs for a random sample of 16 items from a list of 2,000 inventory items at a health care facility. a-Develop an A-B-C classification for these items. b-Given the monthly usages in the following table, classify the items in A, B, and C categories according to dollar usage. c- Determine the percentage of items in each category and the annual dollar value for each category for part b. The principal table are in the picture below
The following table contains figures on the monthly volume and unit costs for a random sample of 16 items from a list of 2,000 inventory items as a health care facility. Develop an A-B-C classification of these items. Step 1: find annual dollar value, Step 2: arrange in importance (A,B,C), find percent of items and percent of dollar value Item Unit Cost Usage K34 $10 200 K35 25 600 K36 36 150 M10 16 25 M20 20 80 Z45 80 200 F14 20 300 F95 30 800 F99 20 60 D45 10 550 D48 12 90 D52 15 110 D57 40 120 N08 30 40 P05 16 500 P09 10 30
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.
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…
Boreki Enterprises has the following 10 items ininventory. Theodore Boreki asks you, a recent OM graduate, todivide these items into ABC classifications.ITEM ANNUAL DEMAND COST/UNITA2 3,000 $ 50B8 4,000 12C7 1,500 45D1 6,000 10E9 1,000 20F3 500 500G2 300 1,500H2 600 20I5 1,750 10J8 2,500 5a) Develop an ABC classification system for the 10 items.b) How can Boreki use this information?c) Boreki reviews the classification and then places item A2 intothe A category. Why might he do so?
1) Grand Styles Furniture Store is overstocked in (has excess inventory of) one type of chair. Based on the Price-Demand Relationship, what advice would you provide to the store manager to deal with this problem? Please use no more than 2 bullet points for your answer. 2) Fancy Fashions sells jeans for $59 and sweaters for $39, To increase sales of jeans and sweaters, Fancy Fashions promotes this Product Price Bundle: "Buy a pair of jeans and a sweater for $98'. Will this Product Price Bundle will work well to increase the sales of jeans and sweaters? Explain your answer In no more than 2 bullet points. 3) What Is the man (most Important) way that Cost-Based Pricing is different from Customer Value-Based Pricing? Please use no more than 2 bullet points for your answer. 4) Would the cost of coffee beans purchased by McDonald's be a Fixed Cost or a Variable Cost? Please use no more than 2 bullet points for your answer.
2.)Birka Styles & Co is introducing a new line of beachwear for their retail stores. The manager needs to decide how many lots of the new beachwear to order for their stores. The marketing came up with a payoff table (see below) considering information about the price, projected sales level, and cost of inventory and ordering. DEMAND Order size Low Medium High 1 lot 12,000 15,000 15,000 2 lots 9,000 25,000 35,000 3 lots 6,000 35,000 60,000 If the owner of Birka Styles & Co is an optimist, how many lots should the manager order?
2.)Birka Styles & Co is introducing a new line of beachwear for their retail stores. The manager needs to decide how many lots of the new beachwear to order for their stores. The marketing came up with a payoff table (see below) considering information about the price, projected sales level, and cost of inventory and ordering. DEMAND Order size Low Medium High 1 lot 12,000 15,000 15,000 2 lots 9,000 25,000 35,000 3 lots 6,000 35,000 60,000 A)If the owner of Birka Styles & Co is an optimist, how many lots should the manager order? B)If the owner of Birka Styles & Co is a pessimist, how many lots should the manager order? C)The owner wants to use minimax regret. How many lots should the manager order?
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.
Birka Styles & Co is introducing a new line of beachwear for their retail stores. The manager needs to decide how many lots of the new beachwear to order for their stores. The marketing came up with a payoff table (see below) considering information about the price, projected sales level, and cost of inventory and ordering. DEMAND Order size Low Medium High 1 lot 12,000 15,000 15,000 2 lots 9,000 25,000 35,000 3 lots 6,000 35,000 60,000 The owner wants to use the Hurwicz method and gave the manager a Hurwica alpha (α) of 0.6. How many lots should the manager order?
Birka Styles & Co is introducing a new line of beachwear for their retail stores. The manager needs to decide how many lots of the new beachwear to order for their stores. The marketing came up with a payoff table (see below) considering information about the price, projected sales level, and cost of inventory and ordering. DEMAND Order size Low Medium High 1 lot 12,000 15,000 15,000 2 lots 9,000 25,000 35,000 3 lots 6,000 35,000 60,000 The owner found out that: P(Low demand) = 1/3; P(Med demand) = 1/2; P(High demand) = 1/6. Which of the following decision is NOT true? A)The best decision is to order 3 lots for a payoff of $29,500. The probabilities gave me enough information to perform a Laplace approach. B)The best decision is to order 3 lots for a payoff of $29,500. The probabilities gave me enough information to perform the EMV approach. C)The EVPI is $2,000. D)The EVwPI is $31,500.