2. a. The following table contains figures on the monthly volume and unit costs for a randomsample of 16 items from a list of 2,000 inventory items at a health care facility. Develop anA-B-C classification for these items.ItemUnit CostUsageItemUnit CostUsageК34$10200F992060К3525600D4510550K3636150D481290M101625D5215110M202080D5740120Z4580200N083040F1420300P0516500F9530800P091030b. Given the monthly usages in the following table, classify the items in A, B, and C categoriesaccording to dollar usage.ItemUsageUnit Cost402190$1,4009402300124066307006500150209280101,02040508014068502,0001030104002044005,000c. Determine the percentage of items in each category and the annual dollar value for each cat-egory for part b.

2. a. 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. Develop an A-B-C classification for these items. 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 PO5 16 500 F95 30 800 P09 30 b. Given the monthly usages in the following table, classify the items in A, B, and C categories according to dollar usage. Item Usage Unit Cost 4021 90 $1,400 9402 300 12 4066 30 700 6500 150 20 9280 10 1,020 4050 80 140 6850 2,000 10 3010 400 20 4400 5,000 c. Determine the percentage of items in each category and the annual dollar value for each cat- egory for part b.

2. a. 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. Develop an A-B-C classification for these items. 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 PO5 16 500 F95 30 800 P09 30 b. Given the monthly usages in the following table, classify the items in A, B, and C categories according to dollar usage. Item Usage Unit Cost 4021 90 $1,400 9402 300 12 4066 30 700 6500 150 20 9280 10 1,020 4050 80 140 6850 2,000 10 3010 400 20 4400 5,000 c. Determine the percentage of items in each category and the annual dollar value for each cat- egory for part b.

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

Given the following list of items,a. Classify the items as A, B, or C.b. Determine the economic order quantity for each item (round to the nearest whole unit).ItemEstimatedAnnualDemandOrderingCostHoldingCost(%)UnitPriceH4-010 20,000 50 20 2.50H5-201 60,200 60 20 4.00P6-400 9,800 80 30 28.50P6-401 14,500 50 30 12.00P7-100 6,250 50 30 9.00P9-103 7,500 50 40 22.00TS-300 21,000 40 25 45.00TS-400 45,000 40 25 40.00TS-041 800 40 25 20.00V1-001 33,100 25 35 4.00
. 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
M&L Manufacturing makes various components for printers andcopiers. In addition to supplying these items to a major manufacturer,the company distributes these and similar items to officesupply stores and computer stores as replacement parts forprinters and desktop copiers. In all, the company makes about20 different items. The two markets (the major manufacturerand the replacement market) require somewhat different handling.For example, replacement products must be packagedindividually whereas products are shipped in bulk to the majormanufacturer.The company does not use forecasts for production planning.Instead, the operations manager decides which items to produceand the batch size, based on orders and the amounts in inventory.The products that have the fewest amounts in inventory get thehighest priority. Demand is uneven, and the company has experiencedbeing overstocked on some items and out of others. Beingunderstocked has occasionally created tensions with the managersof…
M&L Manufacturing makes various components for printers andcopiers. In addition to supplying these items to a major manufacturer,the company distributes these and similar items to officesupply stores and computer stores as replacement parts forprinters and desktop copiers. In all, the company makes about20 different items. The two markets (the major manufacturerand the replacement market) require somewhat different handling.For example, replacement products must be packagedindividually whereas products are shipped in bulk to the majormanufacturer.The company does not use forecasts for production planning.Instead, the operations manager decides which items to produceand the batch size, based on orders and the amounts in inventory.The products that have the fewest amounts in inventory get thehighest priority. Demand is uneven, and the company has experiencedbeing overstocked on some items and out of others. Beingunderstocked has occasionally created tensions with the managersof…
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?
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.
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) Method Using this table format: Week 1 2 3 4 5 6 7 8 Gross requirements Schedule receipts Projected on hand Net requirements Planned order receipts Planned order releases
Emery Pharmaceutical uses an unstable chemicalcompound that must be kept in an environment where both temperatureand humidity can be controlled. Emery uses 800 poundsper month of the chemical, estimates the holding cost to be 50%of the purchase price (because of spoilage), and estimates ordercosts to be $50 per order. The cost schedules of two suppliers areas follows: a) What is the economic order quantity for each supplier?b) What quantity should be ordered, and which supplier should be used?c) What is the total cost for the most economic order size?d) What factor(s) should be considered besides total cost?
Part 1 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,8210 from the above table for relative classification (these are some of the items for which you computed the metrics) A) Based on the percentages of follar colume, item number 1289 should be classified as _ (A,B,C) B) Item number 2349 should be classified as _ (A,B,C) c) Item number 8210 should be classified as _ (A.B, C)
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.
QUESITON 26 Calculate the percentage of assets committed to inventory, where Panda lnc has $44,000,000 in total assets and 11,400,000 of inventory. QUESITON 27 Supply chain management is ... A.a set of procedures connecting suppliers to customers B.Design, operation and improvement of productive systems C.A sequence of activities across organizations that are involved in producing and delivering a product or service D.a series of activities from suppliers to customers that add value to a product or service QUESITON 28 SCOR stands for A.Supply Chain Operations Reference model B.Supply Chain Operations Resilience C.Supply Chain Organsational Resources D.