L. Houts Plastics is a large manufacturer of injection-molded plastics in North Carolina. An investigation of the company's manufacturing facity in Charlotte ylelds the informationpresented in the table below. How would the plant classity these items according to an ABC classification system? (Round dollar volume to the nearest whole number and percentage ofdollar volume to two decimal places)L. Houts Plastics Charlotte Inventory LevelsItem Code Avg. Inventory(units)ValueDollar% of Dollar Volume(Slunit)3 25Volume128942023473004.001.20037.3123491202.503009.332363701.302394601.751053.262396302.256782784420121.152.0523250.720.7682101.6083107.2.003.000.449111180 563.216For the following three questions, consider only tems 1289, 2349, and 8210 from the above table for etive cassification (these are some of the items for which you computed the metrics)Based on the percentages of dollar volume, tem number 1209 should be classified as (1)bem number 2349 should be classified as (2)thm number 8210 shouid be classified as (3).(2) O AO B(1) O A(3) O BO B

Inventory management is the management in which stock is sourced, stored, and sold in the market as…

Answered: L. Houts Plastics is a large…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

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.
ABC analysis on the following set of products Item Annual Demand Unit CostA 211 800 R9B 390 100 R90C 003 450 R6D 100 400 R100E 707 85 R2,000F 660 250 R320G 473 500 R75H 921 100 R75 Soft goods department sells 175 units per month of a certain large bath towel. The unit cost of a towel to the manufacturer is R2.50 and the cost of placing an order has been estimated to be R12.00. There is an inventory carrying charge of 27% of the unit cost per year. What is the optimal order quantity, the order frequency, and the annual holding and setup cost. If the ordering cost can be cut to R4.00, what will be the new economicorder quantity, the order frequency, and annual holding and setup costs.
The company 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 to an ABC classification system? L. Houts Plastics Charlotte Inventory Levels Item Code # Average Inventory (units) Value ($/unit) 3.75 4.00 2.50 1.50 1.75 2.00 1289 2347 400 300 120 2349 2363 2394 2395 6782 75 60 30 20 1.15 2.05 12 7844 8210 8310 1.80 2.00 3.00 9111 6.
Michael’s Offi ce Supply (MOS) sells offi ce furniture,equipment, and supplies. Th is week the company has received 50customer orders. Each order has an average of fi ve line items. Th eaverage dollar amount of each order is $1200. MOS was able toship 47 of the 50 orders on schedule.(a) Using the percentage of orders shipped on time, calculatethe customer service level.(b) If Michael’s calculates customer service level by using thepercentage of line items shipped on schedule, how manyline items must be shipped to achieve the same customerservice level calculated in part (a)?(c) If Michael’s calculates customer service level by thepercentage of dollar volume shipped, how many dollarsof product must be shipped to achieve the same customerservice level calculated in part (a)?(d) What factors determine the customer service levelmeasure that MOS should use?
[8] United States. Your harvest has just come in and you picked 795,000 pounds of apples. You need to distribute the harvest to the appropriate warchouse locations. You manage an apple orchard that distributes fruit throughout the southeast part of the [A] Using the following warchouse information, allocate the apples to their appropriate locations. DEMAND STANDARD DESIRED WARE CURRENT STOCK DEVIATION OF DEMAND HOUSE INVENTORY FORECAST AVAIL- ABILITY Atlanta 35,000 lbs 190,000 lbs 20,000 lbs 95% Miami 10,000 Ibs 170,000 lbs 18,000 lbs 95% Columbia 45,000 lbs 155,000 Ibs 10,000 lbs 85% Memphis 5,000 lbs 145,000 Ibs 25,000 lbs 80% [B] Discuss two additional methods to push inventory into a network.
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.) Item Code Avg. Inventory (units) Value ($/unit)1289 380 3.252347 300 4.002349 120 2.502363 70 1.302394 60 1.752395 25 1.756782 20 1.157844 12 2.058210 10…
Gringer’s Plastics provides plastic parts to the shipbuilding industry. They gathered the following information on their inventory. Based on this data, what products would be considered A class inventory? Product Unit Cost Volume 1 $ 12.50 11,200 2 $ 325.00 160 3 $ 9.75 23,786 4 $ 8.50 29,590 5 $ 175.60 80 6 $ 1,125.99 26 7 $ 756.25 41 8 $ 24.99 5,230 9 $ 109.25 98 10 $ 33.00 7,865 11 $ 6.75 3,489 12 $ 550.80 26 Group of answer choices A. 1, 3, 4, 10 B. 2, 3, 4, 8 C. 1, 2, 4, 7 D. 2, 4, 7
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: 12 units at $47 Jan. 11 Aug. 13 20 units at $48 Nov. 30 $564 960 735 Avaliable for sale $2,259 There are 20 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using the (a) first-in, first-out (FIFO) method; (b) last-sout (LIFO) method; and (c) weighted average cost method (round per-unit cost to two decimal places and your final answer to the nearest whole dollar). a First-in, first-out (FIFO) b. Last-in, first-out (LIFO) c. Weighted average cost Inventory Purchase Purchase 15 units at $49 47 units 1,284 X
1CASE STUDY - The UK’s National Blood ServiceNo inventory manager likes to run out of stock. But for blood services, such as the UK’s National Blood Service (NBS) the consequences of running out of stock can be particularly serious. Many people owe their lives to transfusions that were made possible by the efficientmanagement of blood, stocked in a supply network that stretches from donation centres through to hospital blood banks. The NBS supply chain has three main stages:1. Collection, which involves recruiting and retaining blood donors, encouraging them to attend donor sessions (at mobile or fixed locations) and transporting the donated blood to their local blood centre.2. Processing, which breaks blood down into its constituent parts (red cells, platelets and plasma) as well over twenty other blood-based ‘products’.3. Distribution, which transports blood from blood centres to hospitals in response to both routine and emergency requests. Of the Service’s 200,000 deliveries a year,…
Explain what is meant by pipeline inventory and execess inventory ?
Southern Markets, Inc., is considering the use of ABC analysis to focus on the most critical SKUs in its inventory. Currently, there are approximately 20,000 different SKUs with a total dollar usage of $10,000,000 per year.a. What would you expect to be the number of SKUs and the total annual dollar usage for A items, B items, and C items at Southern Markets, Inc.?350 PART 2 Managing Customer Demandb. The following table provides a random sample of the unit values and annual demands of eight SKUs. Categorize these SKUs as A, B, and C items.SKU Code Unit Value Demand (Units)A104 $2.10 2,500D205 $2.50 30X104 $0.85 350U404 $0.25 250L205 $4.75 20S104…
Cost tradeoff exists between transportation and inventory Select one: a. True b. False

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS