Preview

Hfhgfghh

Better Essays
Open Document
Open Document
1096 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Hfhgfghh
Project Instructions:

Read and complete the following Application Case.

Spreadsheet Model-Based Decision Support for Inventory Target Setting at Procter & Gamble.

Procter & Gamble (P&G) is a large, diversified, multinational consumer products company. Its modeling and decision support group was asked to create global inventory models. P&G has needed “scientific” models to help it control its inventory since the mid-1980s when it implemented Distribution Requirements Planning (DRP). P&G needed an easy way to establish reliable safety stock levels at both the item and location levels. This safety stock is needed to allow for uncertainty in production during the time when replenishments would be delivered.

The original solution was created using Lotus 1-2-3, but over the years the company has developed a suite of global inventory models using Excel. When developing the spreadsheet models, the company kept two goals in mind: “educate supply chain planners on various types, roles and root causes of inventories in supply chains and provide a quick method for setting safety stock within a DRP framework.” The latest model, in addition to growing into a global inventory model, also provides a mechanism for the central support group to train users and assist those who have questions. The inventory components in the models include: cycle stocks, safety stocks, frozen stocks, and anticipation stocks.

Most of P&G’s models use a continuous review policy. Continuous review policy, as the name implies, means that inventory levels are monitored continually. When inventory goes below a set order point, the company reorders up to a set amount using and order quantity (number of items per unit) or a multiple of the order faces. Examples of these issues in the models include:

1. Modeling of normal and gamma distributions for demands or forecast errors.
2. Recognition of a two-tier distribution network: customers receive replenishments directly

You May Also Find These Documents Helpful

  • Powerful Essays

    The purpose of this group assignment is to collaborate as a team to compare different inventory systems and describe the advantage and disadvantages of each system in comparison to the others. Management of inventory is important to any business that wants to succeed. Companies purchase inventory systems to help manage the inventory of an organization. Team A reviewed the following companies and their inventory management programs: Best Buy, , and . This Inventory System Summary includes a description of the chosen companies and their inventory systems, and a comparison describing the advantages and disadvantages of each system. Best Buy…

    • 2054 Words
    • 59 Pages
    Powerful Essays
  • Satisfactory Essays

    The objectives of this report are to diagnose their current inventory control strategy on DC, facility and site, analyze their improved new policy and propose a better strategy to inventory management and allocation. Poisson distribution is implemented to describe the demand assumption. The three main indexes we use to evaluate a strategy are fill rate, total inventory cost and expected downtime.…

    • 295 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    There are several strategies that a company can use to maintain optimal inventory levels while ensuring that customer’s needs are met. There are many strategies like determining inventory levels, just-in-time inventory processes, improve data collection strategies, reduce lead times, increase production…

    • 839 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    The University of Phoenix Summer Historical Inventory Data is the source for developing Team B’s inventory management proposal. Annual trend lines were plotted in Microsoft Excel © to display the inventory amounts for each year. The trend line in this case is positive, which indicates that the likelihood of inventory levels in the subsequent years will continue to rise without considering any additional factors that may influence the business. Factors to support the observation include economic instability from stock market volatility, a decline in consumer confidence, severe weather, and acts of terrorism. Table 1 shows the existing data and includes the fifth year projections. Figure 1 displays the trend…

    • 285 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    short term cheat sheet

    • 636 Words
    • 2 Pages

    A simple way of altering an EOQ based inventory system to account for uncertainty is a safety stock…

    • 636 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Fredrick, J. (2002, 21 October 2002). AIMing to match supply and demand - Distribution - CVS is using a new data-driven inventory management system. Retrieved 8 October 2005, http://www.findarticles.com/p/articles/mi_m3374/is_14_24/ai_93371107…

    • 2171 Words
    • 9 Pages
    Powerful Essays
  • Better Essays

    Hhhh

    • 1424 Words
    • 6 Pages

    Using synthetic foam type materials to mimic the natural process - known as the extracellular matrix or ECM - scientists, from the University of Sheffield and University of California San Diego, created the random stickiness required for stem cells to properly adhere.…

    • 1424 Words
    • 6 Pages
    Better Essays
  • Best Essays

    Qrb 501 Week 2

    • 1899 Words
    • 8 Pages

    References: Atkinson, C. (2005, May 9). Today’s Inventory Management. Retrieved September 19, 2010, from http://www.inventorymanagementreview.org/strategy/…

    • 1899 Words
    • 8 Pages
    Best Essays
  • Better Essays

    Realco Breadmaster Company

    • 1027 Words
    • 5 Pages

    Inventory is the stock of items used to support production, supporting activities and customer service. It is the “bread and butter” that keeps manufacturing firms in business, and is a critical resource in the supply chain. Inventory can be manually managed so that different business conditions can have less of a negative impact on the operations, and give support to the efficient running of supply chains. There are also many tools that companies use to manage production, such as the master scheduling, the material requirements planning (MRP), job sequencing, and distribution requirements planning (DRP). Now with all that said, let us now begin the review and analyze the first case study about the Realco Breadmaster Company.…

    • 1027 Words
    • 5 Pages
    Better Essays
  • Good Essays

    Deere Company

    • 942 Words
    • 3 Pages

    Optimizing inventory in complex supply chain is challenging. Due to this increase in competition the profit margin of the companies are goes on decreasing as a result of which every company now a days focusing on reducing inventory by investing in enterprise planning and execution system but continue to face inventory problems. Establishing a sustainable inventory optimization system is not simple. In addition to that, time-varying demands caused by seasonality, product life cycles and time-varying capacities caused by expanding plants, introducing new processes and technologies, holidays and schedule shutdowns make setting the reliable inventory targets difficult.…

    • 942 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Hhhh

    • 6142 Words
    • 25 Pages

    A General Electric company or GE is an American multinational conglomerate corporation incorporated in Schenectady, New York and headquartered in Fairfield, Connecticut, United States. The company operates through four segments:…

    • 6142 Words
    • 25 Pages
    Powerful Essays
  • Good Essays

    Ethno-Cultural Identity Essay & Discussion They always say that the first step to overcoming your problem is being able to recognize and admit that you have a problem. Although this is a little bit of an extreme and someone cliche saying, it definitely has some truth to it, especially when it comes to self awareness with bias, stereotypes and prejudices. For the most part, people aren’t even aware that they have these, and that debilitates them from being able to overcome them in the first place. One group of people who must be particularly aware are those who are preparing for a career in the health field or as a healthcare provider.…

    • 593 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Fhgjh

    • 484 Words
    • 2 Pages

    Digestion is the mechanical and chemical breakdown of food into smaller components that are more easily absorbed into a blood stream, for instance. Digestion is a form of catabolism: a breakdown of large food molecules to smaller ones.…

    • 484 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Procter & gamble has leveraged its cross-functional organizational structure with operations research to reduce its inventory investment. Savings were achieved in a two-step process, spreadsheet-based inventory models and implementation of the multi-echelon inventory optimization software. Spreadsheet-based inventory model were the first inventory tool installed which locally optimizes each stage in the supply chain. As a result of which they achieved significant savings and established P&G’s scientific inventory practices. Secondly, P&G’s more complex supply chains implemented multi-echelon inventory optimization software to minimize inventory costs across the end-to-end supply chain. They achieved a $1.5 billion in cash savings with these supported tools by implementing it in a tightly coordinated manner. Today, more than 90 percent of P&G’s business units near about $70 billion in revenues use either single stage (70 percent) or multi-echelon (30 percent) inventory management tools. They are planning to increase the use of multi-echelon tools in the nearby future to manage 65 percent of P&G’s supply chains.…

    • 796 Words
    • 3 Pages
    Good Essays
  • Good Essays

    hghh

    • 1451 Words
    • 5 Pages

    In defining an index number, always start with a ratio of sums. Each component of each sum is a price times a quantity. The number of such price/quantity products is equal to the number of goods or services included in the index.…

    • 1451 Words
    • 5 Pages
    Good Essays