Please do not give solution in image format thankuthe drop down options are B-A-C For all 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 thetable 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 twodecimal places)ItemCode12892347234923632394239567827844821083109111L. Houts Plastics Charlotte Inventory LevelsAvg.ValueInventory (units) ($/unit)4.254.002.5036030012070602520128761.801.751.751.152.051.602.003.00DollarVolume1,200300105232514183,397% of DollarVolume35.328.833.090.680.720.410.53For 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 astem number 8210 should be classified as

Here, for each item code, I have been given the Average inventory units and value per unit, so, I…

For the following three questions, consider only tems 1289, 2349, and 8210 from the above table for relative classification (these are some of the items for which you computed the metrics) should be classified as Based on the percentages of dollar volume, item number 1289 should Item number 2349 should be classified as em number 8210 should be classified as

For the following three questions, consider only tems 1289, 2349, and 8210 from the above table for relative classification (these are some of the items for which you computed the metrics) should be classified as Based on the percentages of dollar volume, item number 1289 should Item number 2349 should be classified as em number 8210 should be classified as

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. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
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.
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 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…
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
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
Specialty Toys, Inc., sells a variety of new and innovative children's toys. As with other products, Specialty faces the decision of how may Weather Teddy units to order for coming holiday season. Members of the management team suggested order quantities of 15,000, 18,000, 24,000, 28,000 units. The wide range of order quantities suggested indicates considerable disagreement concerning the market potential. The product management team ask you for analysis of the stock-out probabilities for various order quantities, an estimate of the product potential, and to help make an order quantity recommendation. Specialty expects to sell Weather Teddy for $24 based on cost of $16 per unit. If inventory remains after the holiday season, Specialty will sell all surplus inventory for $5 per unit. After reviewing the sales history of similar products, Specialty%u2019s sales forecaster predicted and expected demand of 20,000 units with a .95 probability that demand would be between 10,000 units and…
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.
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.
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 individual dollar volumes to two decimal places. Also round percentage of dollar volume to two decimal places.) L. Houts Plastics Charlotte Inventory Levels Item Code Avg. Inventory (units) Value ($/unit) Dollar % of Dollar Volume Volume 1289 360 4.00 2347 300 4.00 1,200 36.20 2349 120 2.50 300 9.05 2363 75 1,50 2394 60 1.75 105 3.17 2395 35 2.00 6782 20 1.15 23 0.69 7844 12 2.05 24.6 0.74 8210 5 1.60 8310 7 2.00 14 0.42 9111 3.00 18 0.54 3,315.1 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 computed the metrics). Based on the percentages of dollar volume, item number…
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 information presented 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 of dollar volume to two decimal places) L. Houts Plastics Charlotte Inventory Levels Item Code Avg. Inventory (units) Value Dollar % of Dollar Volume (Slunit) 3 25 Volume 1289 420 2347 300 4.00 1.200 37.31 2349 120 2.50 300 9.33 2363 70 1.30 2394 60 1.75 105 3.26 2396 30 2.25 6782 7844 20 12 1.15 2.05 23 25 0.72 0.76 8210 1.60 8310 7. 2.00 3.00 0.44 9111 18 0 56 3.216 For 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…
If the company in #8 uses exponential smoothing (smoothing factor = .6) and the forecast for the year is the figure they use for EOQ calculations, calculate the EOQ using the following information: The cost of ordering and carrying cost % are the same as #7 Cost of ordering: $25 Carrying costs: 45% Starting with 2018, Forecast the 2020 demand using exponential smoothing and then use that forecast as the annual demand. year sales 2017 1,000,000 2018 1,200,000 2019 2,000,000 2020