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 inthe table below. How would the plant classify these items according to an ABC classification system? (Round individual dollar volumes to two decimal places. Also round percentage of dollarvolume to two decimal places.)L. Houts Plastics Charlotte Inventory LevelsItem Code Avg. Inventory(units)Value($/unit)Dollar% of Dollar VolumeVolume12893604.0023473004.001,20036.2023491202.503009.052363751,502394601.751053.172395352.006782201.15230.697844122.0524.60.74821051.60831072.00140.4291113.00180.543,315.1For the following three questions, consider only items 1289, 2349, and 8210 from 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 asItem number 2349 should be classified asItem number 8210 should be classified as

Inventory is a means to an end in any association occupied with the creation, deal, or exchanging of…

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

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…
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.) L. Houts Plastics Charlotte Inventory Levels Item Code Avg. Inventory (units) Value ($/unit) Dollar Volume % of Dollar Volume 1289 380 3.50 insert answer insert answer 2347 300 4.00 1,200 37.83 2349 120 2.50 300 9.46 2363 75 1.30 insert answer insert answer 2394 60 1.75 105 3.31 2395 25 2.00 insert…
Problem 12.1L. 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? (Rounddollar volume to the nearest whole number and percentage of dollar volume to two decimal places.)L. Houts Plastics Charlotte Inventory LevelsItem CodeAvg. Inventory (units)Value($/unit)DollarVolume% of Dollar Volume12893803.75nothingnothing23473004.001 comma 20036.3223491202.503009.082363751.80nothingnothing2394601.751053.182395251.75nothingnothing6782201.15230.707844122.05250.748210101.60nothingnothing831072.00140.42911163.00180.543 comma 304Enter your answer in the edit fields and then click Check Answer.
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.
Genesis Company is a wholesaler. It purchases 60,000 units of Product X per month for sale to retailers. The cost of placing an order is P100. The cost of holding one unit of inventory for one year is P4. Note: Kindly input your answer with comma.Example: 10,000 Required: a. Compute the economic order quantity. b. How many orders would be placed under the EOQ policy? c. Compute the annual ordering cost for the EOQ. d. Compute the annual carrying cost for the EOQ. e. Compute the total inventory-related cost at the EOQ.
Discount-Mart (see Problem 16.8), as part of its newLean program, has signed a long-term contract with SpecialtyLighting and will place orders electronically for its halogen lamps.Ordering costs will drop to $.50 per order, but Discount-Mart alsoreassessed its carrying costs and raised them to $20 per lamp.a) What is the new economic order quantity?b) How many orders will now be placed?c) What is the total annual cost of managing the inventory withthis policy?
Jill's Job Shop buys two parts (Tegdiws and Widgets) for use in its production system from two different suppliers. The parts are needed throughout the entire 52-week year. Tegdiws are used at a relatively constant rate and are ordered whenever the remaining quantity drops to the reorder level. Widgets are ordered from a supplier who stops by every three weeks. Data for both products are as follows: A. Find the total inventory costs if using inventory policy. This is a case considering safety stock (make sure to use the right formula)
Q2) Groundz Coffee Shop uses 4 kgs of a specialty tea weekly; each kg costs $16. Carrying costs are $1 per kg per week because space is very scarce. It costs the firm $8 to prepare an order. Assume 52 weeks per year. How many kgs of tea should Groundz order at a time? What is total annual cost. How many orders should Groundz place annually. Q2) Groundz Coffee Shop uses 4 kgs of a specialty tea weekly; each kg costs $16. Carrying costs are $1 per kg per week because space is very scarce. It costs the firm $8 to prepare an order. Assume 52 weeks per year. How many kgs of tea should Groundz order at a time? What is total annual cost. How many orders should Groundz place annually.
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?
Kendi Company uses 800 units of a product per year on a continuous basis. The product has a Fixed Cost of $50 per order, and its carrying cost is $2 per unit per year. It takes 5 days to receive a shipment after an order is placed, and the firm wishes to hold 10 days’ usage in inventory as a safety stock. Show Computations and Explanations. A. Calculate the EOQ. B. Determine the Average Level of Inventory. (Note: Use a 365-day year to calculate daily usage.) (Format: 111.11) C. Determine the Reorder Point. (Format: 11.11)
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)?
Howard BooksLynelle Howard owns a thriving independent bookstore in artsy New Hope,Pennsylvania. She must decide how many copies to order of a new book, Powerand Self-Destruction, an exposé on a famous politician’s lurid affairs. Interest inthe book will be intense at first and then fizzle quickly as attention turns to othercelebrities.The book’s retail price is $27 and the wholesale price is $19. The publisher willbuy back the retailer’s leftover copies at a full refund, but Howard Books incurs $5in shipping and handling costs for each book returned to the publisher.Lynelle believes her demand forecast can be represented by a normal distributionwith a mean of 310 and a standard deviation of 100.

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