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. Value Dollar Inventory (units) ($/unit) Volume 4.00 360 300 120 65 60 35 20 12 10 7 6 4.00 2.50 1.30 1.75 1.75 1.15 2.05 1.60 2.00 3.00 1,200 300 105 23 25 14 18 3,286 % of Dollar Volume 36.51 9.13 3.20 0.70 0.75 0.43 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. Value Dollar Inventory (units) ($/unit) Volume 4.00 360 300 120 65 60 35 20 12 10 7 6 4.00 2.50 1.30 1.75 1.75 1.15 2.05 1.60 2.00 3.00 1,200 300 105 23 25 14 18 3,286 % of Dollar Volume 36.51 9.13 3.20 0.70 0.75 0.43 0.55

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter10: Introduction To Simulation Modeling

Section10.5: Introduction To @risk

Problem 19P: In Problem 12 of the previous section, suppose that the demand for cars is normally distributed with...

See similar textbooks

Similar questions

The following table contains figures on the monthly volume and unit costs for a random sample of 16 items from a list of 2,000 inventory items at a health care facility: Item Unit Cost Usage Item Unit Cost Usage K34 $10 200 F99 20 60 K35 25 600 D45 10 550 K36 36 150 D48 12 110 M10 16 25 D52 15 110 M20 20 80 D57 40 120 Z45 80 200 N08 30 40 F14 20 300 P05 16 500 F95 30 800 P09 10 30 Determine the percentage of items in each category and the annual dollar value for each category for part b
Your company makes hand sanitizer in two lines: Moisturizing+, and StandardSoap. On the market, Moisturizing+ retails for $175/L and StandardSoap retails for $95/L. You make the hand sanitizer by combining lotion, soap, and secret ingredient SpecialX. These ingredients are purchased from a mysterious supplier, and you can purchase at most 4000L of lotion, 5000L of soap, and 750L of SpecialX in a month. Lotion costs $25/L, soap costs $10/L, and SpecialX costs $35/L. To make 1L of Moisturizing+, you need to combine 0.5L of lotion, 0.3L of soap, and 0.2L of SpecialX. To make 1L of StandardSoap, you need to combine 0.4L of lotion, 0.55L of soap, and 0.05L of SpecialX. Your company has committed to donating 500L of StandardSoap to a local charity. Since this is a donation, you will not receive any revenue. However, the costs and purchasing limits apply to both the hand sanitizer that is sold on the market and donated to charity. You want to maximize your monthly profit. Assume that…
A distributor of large appliances needs to determine the order quantities and reorderpoints for the various products it carries. The following data refer to a specii c refrigeratorin its product line:Cost to place an orderHolding costCost of refrigeratorAnnual demandStandard deviation of demand during lead timeLead time$10020 percent of product cost per year$500 each500 refrigerators10 refrigerators7 daysConsider an even daily demand and a 365-day year.a. What is the economic order quantity?b. If the distributor wants a 97 percent service probability, what reorder point, R, shouldbe used?
A firm is faced with the attractive situation in which it can obtain immediate delivery of an itemit stocks for retail sale. The firm has therefore not bothered to order the item in any systematicway. Recently, however, profits have been squeezed due to increasing competitive pressures, andthe firm has retained a management consultant to study its inventory management. The consultanthas determined that the various costs associated with making an order for the item stockedare approximately $30 per order. She has also determined that the costs of carrying the item ininventory amount to approximately $20 per unit per year (primarily direct storage costs and foregoneprofit on investment in inventory). Demand for the item is reasonably constant over time and the forecast is for 19,200 units per year. When an order is placed for the item, the entire orderis immediately delivered to the firm by the supplier. The firm operates 6 days a week plus afew Sundays, or approximately 320 days per…
A firm is faced with the attractive situation in which it can obtain immediate delivery of an itemit stocks for retail sale. The firm has therefore not bothered to order the item in any systematicway. Recently, however, profits have been squeezed due to increasing competitive pressures, andthe firm has retained a management consultant to study its inventory management. The consultanthas determined that the various costs associated with making an order for the item stockedare approximately $30 per order. She has also determined that the costs of carrying the item ininventory amount to approximately $20 per unit per year (primarily direct storage costs and foregoneprofit on investment in inventory). Demand for the item is reasonably constant over time and the forecast is for 19,200 units per year. When an order is placed for the item, the entire orderis immediately delivered to the firm by the supplier. The firm operates 6 days a week plus afew Sundays, or approximately 320 days per…
A firm is faced with the attractive situation in which it can obtain immediate delivery of an itemit stocks for retail sale. The firm has therefore not bothered to order the item in any systematicway. Recently, however, profits have been squeezed due to increasing competitive pressures, andthe firm has retained a management consultant to study its inventory management. The consultanthas determined that the various costs associated with making an order for the item stockedare approximately $30 per order. She has also determined that the costs of carrying the item ininventory amount to approximately $20 per unit per year (primarily direct storage costs and foregoneprofit on investment in inventory). Demand for the item is reasonably constant over time and the forecast is for 19,200 units per year. When an order is placed for the item, the entire orderis immediately delivered to the firm by the supplier. The firm operates 6 days a week plus afew Sundays, or approximately 320 days per…
A firm is faced with the attractive situation in which it can obtain immediate delivery of an itemit stocks for retail sale. The firm has therefore not bothered to order the item in any systematicway. Recently, however, profits have been squeezed due to increasing competitive pressures, andthe firm has retained a management consultant to study its inventory management. The consultanthas determined that the various costs associated with making an order for the item stockedare approximately $30 per order. She has also determined that the costs of carrying the item ininventory amount to approximately $20 per unit per year (primarily direct storage costs and foregoneprofit on investment in inventory). Demand for the item is reasonably constant over time and the forecast is for 19,200 units per year. When an order is placed for the item, the entire orderis immediately delivered to the firm by the supplier. The firm operates 6 days a week plus afew Sundays, or approximately 320 days per…
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.) For the following three questions, consider only items 1289, 2349, and 8210from 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 as Item number 2349 should be classified as Item number 8210 should be classified as .
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…
3. Cynthia Knott’s oyster bar buys fresh Louisiana oysters for $5 per pound and sells them for $12 per pound. Any oysters not sold that day are sold to her cousin, who has a nearby grocery store, for $1 per pound. Cynthia believes that demand follows the normal distribution, with a mean of 100 pounds and a standard deviation of 15 pounds. a) What is the cost of underestimating demand for each pound? b) What is the overage cost per pound? c) How many pounds of oyster should she order each day? d) What is the stockout risk for this order size?
Hayes electronics assumed with certainty that the ordering cost is $450 per order and the inventory carrying cost is $170 per unit per year. However, the inventory model parameters are frequently only estimates that are subject to some degree of uncertainty. Consider four cases of variation in the model parameters as follows: (a) both ordering cost and carrying cost are 10% less that originally estimated, (b) both ordering cost and carrying cost are 10% higher than originally estimated, (c) ordering cost is 10% higher and carrying cost is 10% lower than originally estimated, and (d) ordering cost is 10% lower and carrying cost is 10% higher than originally estimated. Determine the optimal order quantity and total inventory cost for each of the four cases. Prepare a table with values from all four cases and compare the sensitivity of the model solution to changes in parameter values.
The following table contains figures on the monthly volume and unit costs for a random sample of 16 items from a list of 2,000 inventory items at a health care facility. Transcribed Image Text: Item Unit Cost Usage Item Unit Cost Usage K34 $10 200 F99 20 60 K35 25 600 D45 10 550 K36 36 150 D48 12 90 M10 16 25 D52 15 110 M20 20 40 08 200 D57 120 245 80 NO8 30 40 F14 20 300 PO5 16 500 F95 30 800 P09 10 30 a-Develop an A-B-C classification for these items. b-Given the monthly usages in the following table, classify the items in A, B, and C categories according to dollar usage. c- Determine the percentage of items in each category and the annual dollar value for each category for part b.