Brushing up on inventory control

Assignment Help Basic Statistics
Reference no: EM131105269

BRUSHING UP ON INVENTORY CONTROL

Robert Gates rounds the corner of the street and smiles when he sees his wife pruning rose bushes in their front yard. He slowly pulls his car into the driveway, turns off the engine, and falls into his wife's open arms. "How was your day?" she asks. "Great! The drugstore business could not be better!" Robert replies, "Except for the traffic coming home from work! That traffic can drive a sane man crazy! I am so tense right now. I think I will go inside and make myself a relaxing martini." Robert enters the house and walks directly into the kitchen. He sees the mail on the kitchen counter and begins flipping through the various bills and advertisements until he comes across the new issue of OR/MS Today. He prepares his drink, grabs the magazine, treads into the living room, and settles comfortably into his recliner. He has all that he wants-except for one thing. He sees the remote control lying on the top of the television. He sets his drink and magazine on the coffee table and reaches for the remote control. Now, with the remote control in one hand, the magazine in the other, and the drink on the table near him, Robert is finally the master of his domain. Robert turns on the television and flips the channels until he finds the local news. He then opens the magazine and begins reading an article about scientific inventory management.

Occasionally he glances at the television to learn the latest in business, weather, and sports. As Robert delves deeper into the article, he becomes distracted by a commercial on television about toothbrushes. His pulse quickens slightly in fear because the commercial for Totalee toothbrushes reminds him of the dentist. The commerical concludes that the customer should buy a Totalee toothbrush because the toothbrush is Totalee revolutionary and Totalee effective. It certainly is effective; it is the most popular toothbrush on the market! At that moment, with the inventory article and the toothbrush commercial fresh in his mind, Robert experiences a flash of brilliance. He knows how to control the inventory of Totalee toothbrushes at Nightingale Drugstore!

As the inventory control manager at Nightingale Drugstore, Robert has been experiencing problems keeping Totalee toothbrushes in stock. He has discovered that customers are very loyal to the Totalee brand name since Totalee holds a patent on the toothbrush endorsed by 9 out of 10 dentists. Customers are willing to wait for the toothbrushes to arrive at Nightingale Drugstore since the drugstore sells the toothbrushes for 20 percent less than other local stores. This demand for the toothbrushes at Nightingale means that the drugstore is often out of Totalee toothbrushes. The store is able to receive a shipment of toothbrushes several hours after an order is placed to the Totalee regional warehouse because the warehouse is only 20 miles away from the store. Nevertheless, the current inventory situation causes problems because numerous emergency orders cost the store unnecessary time and paperwork and because customers become disgruntled when they must return to the store later in the day. Robert now knows a way to prevent the inventory problems through scientific inventory management! He grabs his coat and car keys and rushes out of the house. As he runs to the car, his wife yells, "Honey, where are you going?"

"I'm sorry, darling," Robert yells back. "I have just discovered a way to control the inventory of a critical item at the drugstore. I am really excited because I am able to apply my industrial engineering degree to my job! I need to get the data from the store and work out the new inventory policy! I will be back before dinner!" Because rush hour traffic has dissipated, the drive to the drugstore takes Robert no time at all. He unlocks the darkened store and heads directly to his office where he rummages through file cabinets to find demand and cost data for Totalee toothbrushes over the past year. Aha! Just as he suspected! The demand data for the toothbrushes is almost constant across the months. Whether in winter or summer, customers have teeth to brush, and they need toothbrushes. Since a toothbrush will wear out after a few months of use, customers will always return to buy another toothbrush. The demand data shows that Nightingale Drugstore customers purchase an average of 250 Totalee toothbrushes per month (30 days). After examining the demand data, Robert investigates the cost data. Because Nightingale Drugstore is such a good customer, Totalee charges its lowest wholesale price of only $1.25 per toothbrush. Robert spends about 20 minutes to place each order with Totalee. His salary and benefits add up to $18.75 per hour. The annual holding cost for the inventory is 12 percent of the capital tied up in the inventory of Totalee toothbrushes.

(a) Robert decides to create an inventory policy that normally fulfills all demand since he believes that stock-outs are just not worth the hassle of calming customers or the risk of losing future business. He therefore does not allow any planned shortages. Since Nightingale Drugstore receives an order several hours after it is placed, Robert makes the simplifying assumption that delivery is instantaneous. What is the optimal inventory policy under these conditions? How many Totalee toothbrushes should Robert order each time and how frequently? What is the total variable inventory cost per year with this policy?

(b) Totalee has been experiencing financial problems because the company has lost money trying to branch into producing other personal hygiene products, such as hairbrushes and dental floss. The company has therefore decided to close the warehouse located 20 miles from Nightingale Drugstore. The drugstore must now place orders with a warehouse located 350 miles away and must wait 6 days after it places an order to receive the shipment. Given this new lead time, how many Totalee toothbrushes should Robert order each time, and when should he order?

(c) Robert begins to wonder whether he would save money if he allows planned shortages to occur. Customers would wait to buy the toothbrushes from Nightingale since they have high brand loyalty and since Nightingale sells the toothbrushes for less. Even though customers would wait to purchase the Totalee toothbrush from Nightingale, they would become unhappy with the prospect of having to return to the store again for the product. Robert decides that he needs to place a dollar value on the negative ramifications from shortages. He knows that an employee would have to calm each disgruntled customer and track down the delivery date for a new shipment of Totalee toothbrushes. Robert also believes that customers would become upset with the inconvenience of shopping at Nightingale and would perhaps begin looking for another store providing better service. He estimates the costs of dealing with disgruntled customers and losing customer goodwill and future sales as $1.50 per unit short per year. Given the 6-day lead time and the shortage allowance, how many Totalee toothbrushes should Robert order each time, and when should he order? What is the maximum shortage under this optimal inventory policy? What is the total variable inventory cost per year?

(d) Robert realizes that his estimate for the shortage cost is simply that-an estimate. He realizes that employees sometimes must spend several minutes with each customer who wishes to purchase a toothbrush when none is currently available. In addition, he realizes that the cost of losing customer goodwill and future sales could vary within a wide range. He estimates that the cost of dealing with disgruntled customers and losing customer goodwill and future sales could range from 85 cents to $25 per unit short per year. What effect would changing the estimate of the unit shortage cost have on the inventory policy and total variable inventory cost per year found in part (c)?

(e) Closing warehouses has not improved Totalee's bottom line significantly, so the company has decided to institute a discount policy to encourage more sales. Totalee will charge $1.25 per toothbrush for any order of up to 500 toothbrushes, $1.15 per toothbrush for orders of more than 500 but less than 1000 toothbrushes, and $1 per toothbrush for orders of 1000 toothbrushes or more. Robert still assumes a 6-day lead time, but he does not want planned shortages to occur. Under the new discount policy, how many Totalee toothbrushes should Robert order each time, and when should he order? What is the total inventory cost (including purchase costs) per year?

Reference no: EM131105269

Questions Cloud

Tnt tackling newsboy teachings : Howie Rogers sits in an isolated booth at his favorite coffee shop completely immersed in the classified ads of the local newspaper. He is searching for his next get-rich-quick venture.
Assignment on you are an investment analyst : As the CFO of your corporation, you are in charge of preparing and analyzing financial statements that will be presented to potential investors and creditors. However, before you can present the financial statements to investors and creditors, you..
Demonstrate that it is impossible for all three lines : Demonstrate that it is impossible for all three lines to be matched when looking toward the junction.
Develop a new order­processing system : Customer has engaged your software development company to develop a new order­processing system. However, the time frames are very tight and inflexible for delivery of at least the basic part of the new system. Further, user requirements are sketchy ..
Brushing up on inventory control : Robert Gates rounds the corner of the street and smiles when he sees his wife pruning rose bushes in their front yard. He slowly pulls his car into the driveway, turns off the engine, and falls into his wife's open arms. "How was your day?" she a..
What amount of the note payable should largo : What amount of the note payable should Largo include in the current liabilities section of its December 31, year 2 balance sheet?
What is meant by financial flexibility : A recent financial magazine indicated that the airline industry has poor financial flexibility. What is meant by financial flexibility, and why is it important?
Design a three-port resistive divider for an equal power : Design a three-port resistive divider for an equal power split and a 100 Ω system impedance. If port 3 is matched, calculate the change in output power at port 3 (in dB) when port 2 is connected first to a matched load, and then to a load having a..
How should cali classify the note : Proceeds from the bonds were used to repay the note when it came due. How should Cali classify the note in its December 31, year 2 financial statements?

Reviews

Write a Review

Basic Statistics Questions & Answers

  Developing confidence intervals

A car rental office checks out an average of 30 cars per day with a standard deviation of 8 cars. If a sample of 25 days of operation is selected and the sample mean is computed.

  Positive sales means positive net earnings

Positive sales means positive net earnings for any business, sales have no effect on net revenues and insufficient sales can lead to net losses for some businesses.

  What proportion of students drink decaffeinated coffee only

a national survey of graduate students is conducted to assess thier consumption of coffee. the table below summarizes

  State the information given in the question in probability

in a remote tropical region there is a direct road from a to b but it is impassable about 50 of the time due to rain.

  Statistics to complete a one-hour times exam

The times for 300 college students of introductory statistics to complete a one-hour times exam.

  In fact it is positively skewed what is the probability of

the rent for a one-bedroom apartment in southern california follows the normal distribution with a mean of 2475 per

  What is probability at least one of the stocks appreciates

What is the probability both stocks appreciate during the period? What is the probability the bank stock appreciates but the utility does not? What is the probability at least one of the stocks appreciates?

  Paris arlines wants to estimate the average number of

paris arlines wants to estimate the average number of flights pet year for its crews. a quick pilot study found the

  A medical test for malaria is subject to some error given a

a medical test for malaria is subject to some error. given a person who has malaria the probability that the test will

  Calculate the mean x, variance s2, and standard deviation s

The ages (in days) at time of death for samples of 11 girls and 16 boys who died of sudden infant death syndrome are shown in Table E2.17. Calculate the mean x, variance s2, and standard deviation s for each group.

  Show statistical data using graphic and tabular techniques

Calculate the measures of central tendency, dispersion, and skew for your data. Display your descriptive statistical data using graphic and tabular techniques.

  A life insurance company wants to estimate their annual

question 1 a loaf of bread is normally distributed with a mean of 22 oz and a standard deviation of 0.5 oz. what is the

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd