80.2K

Verified Solution

Link Copied!

urgent

Randy Smith was very proud of his new position as inventory control manager for the Johnson Trinket Company. His primary responsibility had been fairly clearly defined: Maintain an inventory level in the warehouse that ensures that production will not run out of stock, yet also maintain an inventory level that will minimize inventory holding and control costs. Since Randy had recently had a course in materials management, he knew an approach that should help him. He decided to make a list of inventory items in one small section of the warehouse to see if he could develop a good plan for inventory control. If it worked in the one small section, he could expand it to the rest of the more than 30,000-part numbers in the warehouse. The following is the data Randy compiled Part Part Unit Value In Quantity Currently in Average Annual Annual Number s Inventory Usage s Usage 1234 2.5 300 3000 7500 1235 0.2 550 900 180 1236 15 400 1000 15000 1237 0.75 SO 7900 5925 1238 7.6 180 2800 21280 1239 4.4 20 5000 22000 1240 1.8 200 1800 3240 1241 0.05 10 1200 1242 17.2 950 2000 34400 1243 160 2500 22500 1244 3.2 430 7000 22400 1245 0.3 500 10000 3000 1246 1.1 25 7500 8250 1247 8.1 60 2100 17010 1248 5 390 4000 20000 1249 0.9 830 6500 5850 1250 700 3100 18600 1251 2.2 80 6000 13200 1252 1.2 480 4500 5400 1253 5.9 230 900 5310 60 9 6 ICCIO When Randy scanned the list, he noticed several things that disturbed him, and he asked one of the experienced inventory clerks. The following list summarizes the part number issues that concerned Randy, and the explanation from the clerk: Part number 1236, a very expensive part with almost half-a-years' worth of inventory. This part is used for a product that has very cyclical demand, and the busy time of the year is about to start. Part number 1241 is very inexpensive, yet the inventory is very small. This part has a supplier with an erratic delivery history, and the part also has a very long lead time. A lot of 150 has been on order for some time and is now several days past duc. Part number 1242, like 1236, is expensive with almost half a year worth of inventory--this part is shipped to a location on the other side of the country and is being accumulated into a large lot to save shipping costs. Part number 1246 is not too expensive, with a low inventory. This part is produced in-house, and has a quality tolerance that the older equipment, which was used to produce it, had a difficult time meeting. The last batch was rejected by the quality department Part number 1253 is moderately expensive with a large inventory compared to usage. This part was subject to a recent quality audit, and almost 150 of the items were rejected as a result of that audit

Answer & Explanation Solved by verified expert

See Answer