The company L. Houts Plastics is alarge manufacturer of injection-molded plastics in North Carolina.An investigation of the company'smanufacturing facility in Charlotteyields the information presented inthe table below.How would the plant classify theseitems to an ABC classification system?L. Houts Plastics Charlotte Inventory LevelsItem Code # Average Inventory (units) Value ($/unit)3.754.002.501.501.752.001289234740030012023492363239423956782756030201.152.05127844821083101.802.003.0091116.

Answered: The company L. Houts Plastics is a…

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

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.
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…
Lindsay Electronics, a small ma nufacturer of electronicresearch equipment, has approximately 7,000 items in itsinventory and has hired Joan Blasco-Paul to manage its inventory. Joan has determined that 10% of the items in inven toryare A items, 35% are B items, and 55% are C items. She wouldlike to set up a system in which all A items are counted monthly(every 20 working days), all B items are counted quarterly (every60 working days), and all C items are counted semiannually (every120 working days). How many items need to be counted each day?
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)
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.
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)
Answer bold italicized questions Using excel. The Metropolitan Bus Company (MBC) purchases diesel fuel from AmericanPetroleum Supply. In addition to the fuel cost, American PetroleumSupply charges MBC $250 per order to cover the expenses of deliveringand transferring the fuel to MBC’s storage tanks. The lead time for anew shipment from American Petroleum is 10 days; the cost of holding agallon of fuel in the storage tanks is $0.04 per month, or $0.48 peryear; and annual fuel usage is 150,000 gallons. MBC buses operate 300days a year.a.What is the optimal order quantity for MBC?b.Howfrequently should MBC order to replenish the gasoline supply?c.TheMBC storage tanks have a capacity of 15,000 gallons. ShouldMBC consider expanding the capacity of its storage tanks?d.What isthe reorder point?
Tasty Treats is a distributor of candy and snack products serving customers in a six-state region of the midwestern United States. Bill Jones, chief operations officer, has been concerned about inventory levels and inventory performance at Tasty Treats for quite some time. In speaking with Jim Busfield, chief executive officer of Tasty Treats, Bill voiced some of his concerns: “Jim, we carry over 5,000 different items in inventory. I have a feeling that we just don’t have a good handle on the proper approach to managing this part of our operations. We don’t have any real analysis that tells us how much we should carry of each item. We just use simple rules of thumb to determine how much we should order from our suppliers. For example, we sell an average of 100 cases of Chocolate Chewies every day. When we order Chocolate Chewies from our supplier, it usually takes about 10 days for us to get the order. So, we order 1,000 cases of Chocolate Chewies every 10 days. I also try to keep an…
Which of the following is ‘data’? i. Number of items in inventory in the store were 3,000 ii. Value of items in the store was OMR 5,000 iii. Total items with value OMR 1,500 to OMR 3,000 were 500
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…
Average daily demand (d) 130 cases Demand Standard deviation (σd) 20 cases Service level 94.0% Service level alternative 86.0% Lead tme, LT 6 days 1. What is the standard deviation of demand during lead time? Round your answer to one decimal place. _______ cases 2. What is the required safety stock at a 94 percent service level? Round your answer to the nearest whole number. _______ cases 3. What is the reorder point? Round your answer to the nearest whole number. _______ cases 4.What is the required safety stock at a 86 percent service level? Round your answer to the nearest whole number. _______ cases 5. What is the safety stock reduction? Round your answer to the nearest whole number. _______ cases
Jim'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. What is the inventory control system for Tegdiws? Reorder quantity = 1,225 Reorder point = 824.24 b. Find the total inventory costs if using inventory policy. This is a case considering safety stock (Do not use Excel, show your work) Holding cost per unit per year is given as a percentage of item cost ITEM TEGDIW WIDGET Annual Demand 10,000 5,000 Holding cost (% of item cost) 20% 20% Set up or order cost $150.00 $25.00 Lead Time 4 weeks 1 week Safety stock 55 units 5 units Item cost $10.00 $2.00

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