Preview

Inventory Management: Case Study: Hewlett-Packard

Good Essays
Open Document
Open Document
358 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Inventory Management: Case Study: Hewlett-Packard
CASE: Hewlett-Packard – Supplying the DeskJet Printer in Europe – Teaching
Note
First review the Reorder Point model and the Equal Order Period model (this could be done on the day prior to when the DeskJet case is being discussed. It’s important that the average inventory calculations are covered, since this is no covered in the book.)
Let’s use some different numbers, just for another problem example. d = 20 units/day, std. dev. = 4 unit/day
L = 10 days
96% confidence
Q = 600 units
ROP (min level) = D(lead time) + SS
D(lead time) = 10 * 20 = 200
SS = 1.75 * Std dev(lead time) ---- sqrt( 10*4^2) = 12.65
SS = 1.75 * 12.65 = 22.14
ROP = 222 unit
What is average inventory? Q/2 + SS = 600/2 + 22 = 322
Equal Order Period model
Max Level = D(lead time + review period) + SS
Review period is 30 days
D (T+L) = (30+10) * 20 = 800
SS = 1.75 * Std dev (lead time + review period) -- sqrt (40*4^2) = 25.3
SS = 1.75 * 25.3 = 44.271 –> 44
Max Level = 20 * (30+10) + 44 = 800 + 44 = 844 suggest the average inventory to be?
Let’s consider model AB
Monthly mean 15,830.1, Std Dev = 5,624.6
Review Cycle = 1 week
Lead Time = 6 weeks
Average Weekly Demand = 15,830.1/4 = 3,957.525
Std. Dev. = sqrt (5624.6^2/4) = 2,812.3
Average inventory = 3957.525/2 + 2.1 * sqrt(7 * 2,812.6^2)
= 17,260 units
These are worth $250 each = 4,315,000 total value of inventory
Inventory carrying cost = 4,315,000 * .25 = $1, 078,950
This is compared to HP’s current policy of carrying 1 month’s worth of inventory for the model AB. This cost is (15,830.1 * 250 * .25) = $989,381.25. In this case the model would suggest that additional inventory be kept.
Next bring up the spreadsheet (from the Student CD, Website-ROM) and do the calculations for the rest of the items. The calculations are then done for the pooled demand. The savings are pretty dramatic as can be seen from the following
completed

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Acc/531 Week 4

    • 623 Words
    • 3 Pages

    Cost of goods manufactured ($12,200) is then used in combination with beginning and ending WIP inventories of $0 to derive total costs incurred ($12,200) and then, in combination with materials ($5,700) the conversion costs of $6,500…

    • 623 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    JCT2 Task 1

    • 1659 Words
    • 8 Pages

    15,000 15,000 15,000 + Shipping 0 27,665 46,811 52,995 + Inventory Holding Costs 0 4,544 20,489 0 + Excess Capacity Cost 0 0 0 0 + Depreciation 0 45,833 91,667 137,500 =…

    • 1659 Words
    • 8 Pages
    Powerful Essays
  • Satisfactory Essays

    The case is about Control versus Cost versus Service versus Liability. What if the hospital stock out of a SKU and hurts a patient or if the patient dies due to lack of inventory? The EOQ is a marginal cost model. – Models are only as good as their parameter estimates –Answer the four case questions with special emphasis on getting good estimates of order and inventory holding costs…

    • 379 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Cost Of Goods WEEK 7

    • 275 Words
    • 1 Page

    in June 300,000 - ending inventory in June 50,000 = 350,000 (cost of inventory). Here are some examples…

    • 275 Words
    • 1 Page
    Satisfactory Essays
  • Good Essays

    Inventory Management

    • 333 Words
    • 2 Pages

    1. Locate a firm that incorporates inventory management. Identify the type of inventory system (fixed order quantity system, fixed order period system, or a hybrid system) it uses.…

    • 333 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Management: Problem Sets

    • 405 Words
    • 2 Pages

    9.14) If the annual cost of goods sold is $12,000,000 and the average inventory is $2,250,000:…

    • 405 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Ferguson Car Rental Essay

    • 942 Words
    • 4 Pages

    There are several ways worth considering improving the current situation, such as by using a collocation of adopting different rental terms of 4 weeks, 8 weeks, and 12 weeks. However, the proportions of the rental terms need to be chosen carefully. Below are three options for consideration:…

    • 942 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Market Analysis of Big Bazar

    • 1702 Words
    • 28 Pages

    Under the FIFO cost flow assumption during a period of inflation, which of the following is false? WHICH OF THE FOLLOWING IS NOT TRUE. (Hint: One way to answer this is to look at examples of lifo and fifo).…

    • 1702 Words
    • 28 Pages
    Satisfactory Essays
  • Good Essays

    Regarding the liquidity ratios, East Coast Yachts current ratio is below the median industry ratio. This implies the company has less liquidity than the industry in general. However, the current ratio is above the lower quartile, so there are companies in the industry with lower liquidity than East Coast Yachts. The company may have more predictable cash flows, or more access to short-term borrowing.…

    • 706 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    During a conversion at my family dinner my sister mentioned her small clothing store and she also discussed how frustrating it is to manually track and record all of the high demanding items in her store. My sister would like an easier solution for her problem. She decided she wanted an automated system, but she told us that she has a very small budget. So she asked my mother and I for any advice we can give for her store.…

    • 605 Words
    • 3 Pages
    Satisfactory Essays
  • Best Essays

    In a world of constant change being able to adapt can sometimes be a struggle, especially when dealing with the largest tool of progression…technology. Hewlett Packard is the world’s largest Internet Technology Company with a portfolio that covers anything from printing and personal computers to software and services. There infrastructure is so vast and expansive that constant revision and attention is necessary to keep this companies supply chain successful and dominant in the field of technology. Hewlett Packard has been one of the largest and most powerful companies in the interests of technology; with new endeavors being explored this company has gained modern perspectives on progressive concepts and designs within their strategies towards supply chain innovations. HP began in a garage by two men by the names of Bill Hewlett and Dave Packard…

    • 2177 Words
    • 9 Pages
    Best Essays
  • Powerful Essays

    ' 'The logistics of distribution are the iceberg below the waterline of online bookselling, ' ' Jeff Bezos, founder and chief executive of Amazon.com…

    • 5542 Words
    • 23 Pages
    Powerful Essays
  • Powerful Essays

    A specialty chemical company with worldwide operations serving the electronics, surface finishing, and decorative industries engaged Daniel Penn Associates to improve its supply chain logistics and inventory control systems. At the time, the company had 14 manufacturing site, six R&D facilities, sales, and distribution centers worldwide and employs 1,300 people.…

    • 2114 Words
    • 9 Pages
    Powerful Essays
  • Better Essays

    Inventory ties up the largest amount of cash in companies, and inventory management decisions directly influence the purchasing function. As these activities fall under the supply chain management umbrella, managers cannot act independently pursuing an objective that is going to satisfy one department. Instead, managers foster teamwork and cooperation not only within their own company, but also between their company and the company’s suppliers of goods and services. Purchasing for the sake of taking advantage of a good price is no longer a priority in a company, many companies rather purchase products at a higher price in order to sustain and foster a relationship with their suppliers. As pricing directly affects purchasing, also Purchasing directly affects Inventory Management. Good managers are those who are able to find the delicate balance between when and how much to buy.…

    • 1721 Words
    • 5 Pages
    Better Essays
  • Satisfactory Essays

    Inventory Management

    • 410 Words
    • 2 Pages

    A global manufacturing company was experiencing inefficiencies in in its inventory management processes. With suppliers across the world delivering parts for the company's products, multiple buyers within the company are responsible for tracking the parts required for each product from the manufacturing phase through delivery. The company needed a way to keep a master list of all inventory with easy access to parts' delivery statuses and other pertinent information relevant to the company. The firm engaged Aciron to develop a custom inventory management system focused on enhancing inventory management through powerful parts tracking, management, and reporting features.…

    • 410 Words
    • 2 Pages
    Satisfactory Essays