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 1289 2347 2349 2363 2394 2395 6782 7844 8210 8310 9111 L. Houts Plastics Charlotte Inventory Levels Avg. Inventory Dollar (units) Volume 380 300 120 75 60 30 20 12 5 7 6 Value ($/unit) 3.75 4.00 2.50 1.50 1.75 2.25 1.15 2.05 1.60 2.00 3.00 1,200 300 105 23 25 14 18 3,298 % of Dollar Volume 36.39 9.10 3.18 0.70 0.75 0 0.42 0.55

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 1289 2347 2349 2363 2394 2395 6782 7844 8210 8310 9111 L. Houts Plastics Charlotte Inventory Levels Avg. Inventory Dollar (units) Volume 380 300 120 75 60 30 20 12 5 7 6 Value ($/unit) 3.75 4.00 2.50 1.50 1.75 2.25 1.15 2.05 1.60 2.00 3.00 1,200 300 105 23 25 14 18 3,298 % of Dollar Volume 36.39 9.10 3.18 0.70 0.75 0 0.42 0.55

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

ChapterC: Cases

Section: Chapter Questions

Problem 5.1SC: Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing...

See similar textbooks

Similar questions

Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
19. SPRAY-PAINT INVENTORY The Graphic Hobby House made purchases of assorted colors of spray paint during the year as follows. Beginning inventory 200 cans at $2.20 March 400 cans at $2.40 May 700 cans at $2.00 August 500 cans at $2.30 November 300 cans at S2.60 At the end of the year, they had 450 cans of spray paint in stock. (a) Find the inventory value using the weighted-average method. (b) Find the inventory value using the FIFO method. (c) Find the inventory value using the LIFO method.
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
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 15 units at $40 $600 Aug. 13 Purchase 5 units at $41 205 Nov. 30 Purchase 11 units at $42 462 Available for sale 31 units $1,267 There are 9 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-in, first-out (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) $fill in the blank 1 b. Last-in, first-out (LIFO) $fill in the blank 2 c. Weighted average cost $fill in the blank 3
b) Describe briefly about; i. Inventory, and Inventory cost ii. The purpose to have sales and operations planning c) Give at least ONE (1) example of; i. Product categorized as dependant demand ii. Product categorized as independent demand d) World Cycle is a centre for a new Malaysian made bicycle. It cost the company RM 1200 to order each bicycle from the manufacturer with handling cost of RM 100 for each unit. The company estimates the total annual demand will be 3000 units with a constant demand rate through-out the year. The store policy is never to have stock of the bicycle since it takes within minutes to receive it after placement order from a local warehouse. The company is open for business every day except public holidays. Malaysian public holidays, including Saturday and Sunday are 120 days a year. Determine; i. Optimal order quantity per order ii. Minimum total annual inventory costs iii. The number of orders per year iv. The working days between orders
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 classification system? (Round dollar volume to the nearest whole number and percentage of dollar volume to two decimal places.) Item number 2349 should be classified as Item Code Item number 8210 should be classified as 1289 2347 2349 2363 2394 2395 6782 7844 8210 8310 9111 L. Houts Plastics Charlotte Inventory Levels Value Dollar ($/unit) Volume Avg. Inventory (units) 400 300 120 75 89223 co 60 30 20 12 7 6 3.75 4.00 2.50 1.50 1.75 2.00 1.15 2.05 1.80 2.00 3.00 1,200 300 105 23 25 14 18 3,372 % of Dollar Volume 35.59 8.90 3.11 0.68 0.73 0 0.42 0.53 For 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…
After applying the NWC Rule for the initial tableau of the given transportation model, evaluate the vacant cells. What is the cell which has the most negative evaluation value and what is the cell evaluation value? DESTINATION SOURCE DEMAND X Y N OX-R; 1 OY-S; -1 OX-S; -1 OY-S; -2 P 75 8 12 EI 11 Q 80 5 8 11 R 120 7 10 10 S 50 11 13 14 SUPPLY 100 125 100 325
4. In the past, Peter Kelle's tire dealership in Baton Rouge sold an average of 1,100 radials each year. In the past 2 years, 220 and 250, respectively were sold in fall, 360 and 300 in winter, 150 and 160 in spring, and 320 and 440 in summer. With a major expansion planned, Kelle projects sales next year to increase to 1,300 radials. Part 2 Based on next year's projected sales, the demand for each season is going to be (enter your responses as whole numbers): Season Demand Fall __________
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
Identify the causes of the seasonal demand pattern for Diamonds.Determine the inventory order quantity for each of the three (3) primary ingredients thatDiamant Foods orders from its suppliers.
Cost tradeoff exists between transportation and inventory Select one: a. True b. False