Randy Smith was very proud of his new position as inventory control manager for the Johnson...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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: Quantity currently in inventory Average annual Part number Part unit value in $ usage 1234 $2.50 300 3000 1235 $0.20 550 900 1236 S15.00 400 1000 1237 $0.75 50 7900 1238 $7.60 180 2800 1239 $440 20 5000 1240 $1.80 200 1800 1241 $0.05 10 1200 1242 $17.20 950 2000 1243 $9.00 160 2500 1244 $3.20 430 7000 1245 $0.30 500 10000 1246 $1.10 25 7500 1247 $8.10 60 2100 1248 $5.00 390 4000 1249 $0.90 830 6500 1250 $6.00 700 3100 1251 $2.20 80 6000 1252 $1.20 480 4500 1253 $5.90 230 900 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-year's 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 due. - 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. Once Randy understood some of the issues, suddenly he did not feel quite as confi- dent that he had the best approach in mind to control the inventory to meet the expecta- tions of his boss. Assignment Is there other information that you would like to see that might help you to make a more effective policy? If so, what would that information be and how would you use it to help you? 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: Quantity currently in inventory Average annual Part number Part unit value in $ usage 1234 $2.50 300 3000 1235 $0.20 550 900 1236 S15.00 400 1000 1237 $0.75 50 7900 1238 $7.60 180 2800 1239 $440 20 5000 1240 $1.80 200 1800 1241 $0.05 10 1200 1242 $17.20 950 2000 1243 $9.00 160 2500 1244 $3.20 430 7000 1245 $0.30 500 10000 1246 $1.10 25 7500 1247 $8.10 60 2100 1248 $5.00 390 4000 1249 $0.90 830 6500 1250 $6.00 700 3100 1251 $2.20 80 6000 1252 $1.20 480 4500 1253 $5.90 230 900 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-year's 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 due. - 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. Once Randy understood some of the issues, suddenly he did not feel quite as confi- dent that he had the best approach in mind to control the inventory to meet the expecta- tions of his boss. Assignment Is there other information that you would like to see that might help you to make a more effective policy? If so, what would that information be and how would you use it to help you?
Expert Answer:
Answer rating: 100% (QA)
It would be helpful to understand what other parts are made inhouse and if they need quality problems like PN 1246 Perhaps this part should be made on ... View the full answer
Related Book For
Quantitative Analysis for Management
ISBN: 978-0132149112
11th Edition
Authors: Barry render, Ralph m. stair, Michael e. Hanna
Posted Date:
Students also viewed these accounting questions
-
Jim Overstreet, inventory control manager for Itex, receives wheel bearings from Wheel-Rite, a small producer of metal parts. Unfortunately, Wheel-Rite can only produce 500 wheel bearings per day....
-
It is not possible to see very small objects, such as viruses, using an ordinary light microscope. An electron microscope can view such objects using an electron beam instead of a light beam....
-
Responsibility for materials usage variance Lehman Fruit Basket Company makes baskets of assorted fruit. The standard and actual costs of oranges used in each basket of fruit follow. Lehman actually...
-
Estimates have been presented to Holly Farms, which is considering two environmental chambers for a project that will detail laboratory confirmations of on-line bacteria tests in chicken meat for the...
-
An evaluation score X1 of a candidate using method 1 has a mean of 100 and a standard deviation of 12, while an evaluation score X2 of a candidate using method 2 has a mean of 100 and a standard...
-
What are the positive consequences associated with a high predictor cutoff score? What are the negative consequences?
-
Consider the following cash flow profile, and assume MARR is 10 percent/year. a. What does Descartes' rule of signs tell us about the IRR(s) of this project? b. What does Norstrom's criterion tell us...
-
Multiple-choice questions: a. Which of the following ratios can be used as a guide to a firms ability to carry debt from an income perspective? 1. Debt ratio 2. Debt to tangible net worth 3....
-
Tokens are generated at a Poisson rate of 5 per second. Data packets arrive at a network entry point at a Poisson rate of 2 per second. Each packet waits to obtain a token (permit) before entering...
-
Futoshiki is a Sudoku-like Japanese logic puzzle that is very simple, but can be quite challenging. You are given an n x n grid, and must place the numbers 1, . . . n in the grid such that every row...
-
Name the two main constituents of the Central Nervous System in human beings. (b) What is the need for a system of control and coordination in human beings?
-
Write a program that will create an invoice for a customer order based on their requests. Your program should prompt the user for their requested items based on a stock number then store the...
-
Compare our hospital's ratio numbers to the most recent Optum Median hospital numbers (provided). For each ratio, is our hospital better or worse than the median hospital? explain what purpose is...
-
Rewrite the minimum number of lines of VHDL code to properly model a register's asynchronous reset. In the table below, rewrite the minimum number of lines so that code correctly simulates. library...
-
Bob Hill's hourly rate is $25.00, and he worked 39 regular hours during the week. What is his income tax and gross pay for the month?
-
MCK Inc. purchased on January 1, 2021, $600.000. 6% bonds of Aguirre Co. for $536,621. The bonds were purchased to yield 8% interest. Interest is payable semiannually on June 30 and December 31. The...
-
Does systems thinking provide leaders with an advantage when considering how to make decisions ethically and anticipate the related consequences of those decisions? If so, how? If not, why not?
-
Explain the operation of the dividends received deduction.
-
For each of the following F values, determine whether the probability indicated is greater than or less than 5%: (a) P(F3,4 > 6.8) (b) P(F7,3 > 3.6) (c) P(F20,20 > 2.6) (d) P(F7,5 > 5.1) (e) P(F7,5 <...
-
Northern Distributors is a wholesale organization that supplies retail stores with lawn care and household products. One building is used to store Neverfail lawn mowers. The building is 25 feet wide...
-
What is a risk seeker? What is a risk avoider? How does the utility curve for these types of decision makers differ?
-
Postural hypotension is the occurrence of low (systolic) blood pressure when standing up too quickly from a reclined position, causing fainting or lightheadedness. For most people, a systolic...
-
We've seen that fish can control their buoyancy through the use of a swim bladder, a gas-filled organ inside the body. You can assume that the gas pressure inside the swim bladder is roughly equal to...
-
A person's percentage of body fat can be estimated by weighing the person both in air and underwater, from which the average density \(ho_{\text {avg }}\) can be calculated. A widely used equation...
Study smarter with the SolutionInn App