Preview

Case Study: Safeway And Pepsico

Good Essays
Open Document
Open Document
457 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Case Study: Safeway And Pepsico
1. What is a potential benefit of supply chain visibility? The benefit of a supply chain visibility is that the organization can view a product’s lifecycle from its beginning conception, through the manufacturing process ending with the customer’s product experience (Musa & Gunasekaran & Yusuf, 2014). In regards to Safeway and PepsiCo, they implemented programs along with other vendors that allowed them to save money. Safeway’s Data Visibility program, which is very forward thinking, along with PepsiCo’s 360 Retail execution program was taken to the next level by Deloitte Consulting. Partnering with the two this created an effective way to resolve massive amounts of data (Turban & Volonino & Wood, 2015, pg 370).

2. What was the limitation of Excel-based data analytics at Safeway? The limitation of the Excel based data analytics is a spreadsheet, with rows and columns. This spread sheet limited the amount of information that was represented in the company’s report. The
…show more content…
What steps did Safeway and PepsiCo undertake to arrive at their data visualization solution? Safeway and PepsiCo collaborated to figure out how to limit the “number of days of supply”. The steps that were undertake included, how to feed the huge datasets into the visualization software, the best way to display the data visually and how to gather feedback (Turban & Volonino & Wood, 2015, pg 370).
5. What did Safeway learn from its data visualization dashboards? Safeway learned that several stores were experiencing an unequal number of stockouts and they were able to regulate their supply chain strategy in an attempt to even the demand. They also learned that they were sending contradictory prediction to their vendors (Turban & Volonino & Wood, 2015, pg 371).
6. What were the two operational improvements at Safeway? The two operational improvements at Safeway were the improved forecast accuracy by 35 percent, and the reduced on-hand warehouse inventory (Turban & Volonino & Wood, 2015, pg

You May Also Find These Documents Helpful

  • Good Essays

    When working with reports and company information, data tables are great visual aids and very helpful. Data tables presents information in an organized format. A more detailed data table is more commonly used in order to be able to make a report effective. Kudler Fine Foods uses a basic data table to represent their Inventory Report. The design element is very basic with improvement being needed.…

    • 547 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    This document is a proposal for building a data warehouse architecture that will consolidate and transform data into useful information for the purpose of decision-making and for establishing a new function that offers a broad array of decision support services to all units at ABC Retail Chain Corporation. Executives and decision-makers often need information to analyze the past, describe current circumstances, and anticipate the future. Presently, decision-makers across the Institute rely on hard copy reports or Excel Sheets to provide information. Typically, any request for information is forwarded to the operational areas of the Organization, which provide hard copy reports reflecting the data gathered in their functional area. To analyze and transform data into useful information, decision-makers and their staff have to manually re-enter the non-integrated data into their own mini-systems. This type of operation hinders the ability of decision making and the executives are either drowning in too much data with no option to analyze it or too little data, which means they are back to square one and must request additional information. Often executives receive multiple, conflicting information or information that is based on incomplete assumptions about the types of analysis required.…

    • 641 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    The approach employed on behalf of SmartMart embraced a two-pronged strategy that entailed both a strategic growth initiative that allows SmartMart to explore additional potential revenue channels and opportunities, and the use of data and industry statistics to drive decision-making. It is incredibly easy to believe that a firm knows what their target demographic desires, but in the end figures are the most proven way to drive company policy.…

    • 1598 Words
    • 7 Pages
    Powerful Essays
  • Good Essays

    For companies has been using the analytics of data to reduce cost and drive innovation. Data has now become more available and with the help of technology better to understand though a computer. Stores such as Home Depot, Lowe’s, and Walmart analyze data to tailor products and price markdowns for customers located in curtain demographic areas. Fed-Ex use data on their delivery truck and planes, to help manage delivery times and traffic for better delivery schedules.…

    • 321 Words
    • 2 Pages
    Good Essays
  • Good Essays

    There is a long ongoing battle that is being waged between unions and business since the rise of large corporations. Unions were created to fight higher official corruption and to protect workers from unfavorable conditions and unfair treatment by top-level officials, companies take extreme measures to prevent the creation of unions within their organizations. There are positive and negative effects for both nonunion and unionized companies. Preventing workers from unionizing is a difficult task for organizations especially as they expand into the global arena. More is demanded from employees usually with little added benefits (thus the reason for unionization). A notable successful company is Trader Joe’s, who’s business strategy and cultural…

    • 860 Words
    • 4 Pages
    Good Essays
  • Better Essays

    Trader Joe's Case Study

    • 3477 Words
    • 14 Pages

    Many Trader Joe’s stores can be found in old strip malls in suburban locations. The typical Trader Joe’s store has less than 15,000 square feet of selling space. The store works with a much lower square footage than larger supermarket chains that range from about 40,000-50,000 square feet. Experts estimate that Trader Joe’s generate approximately $10 billion in annual revenue. The store carries about 4,000 SKU’s per location compared to about 50,000 SKU’s for most other grocery stores. 80% or more of their products consist of private label items and you can’t find any major brands at the store. They do not offer a wide range of meat but instead they offer a wide range of frozen goods such as fruit. Trader Joe’s do not offer all of the necessities that you may need while shopping therefore a typical family wouldn’t be able to do all of their shopping there. The company scoured high for interesting and dynamic products. They introduce 10-15 products per week and eliminate 10-15. Trader Joe’s is not a technology savvy store and they do not have things such as self-checkouts. Instead Trader Joe’s believes on being able to converse with their customers. Trader Joe’s employees are paid more than if they worked at another grocery store. New part-time hires typically earn $12 per hour. Full time employees earned approximately $50,000 per year. Store…

    • 3477 Words
    • 14 Pages
    Better Essays
  • Satisfactory Essays

    Case Study Kroger

    • 144 Words
    • 1 Page

    Ultimately, variations in fixed and variable costs and their impact on profits made me think. At Kroger, I reviewed the operating statement each month and focused on items I could control, such as: salaries and inventory.…

    • 144 Words
    • 1 Page
    Satisfactory Essays
  • Satisfactory Essays

    Trader Joes Case Study

    • 313 Words
    • 2 Pages

    Trader Joes demonstrates the responsibility in each management process in several ways. The first step in the process is planning. They go about this by offering and selling high quality products for low prices. They deliberately carry a lot less inventory than most comparable stores in order to maintain the quality goods people want for the prices they want them at. Trader Joes has a set plan, that the employees wear Hawaiian shirts, hand out stickers and keep a casual environment. This is key to the planning process because no matter if you are in a Trader Joes twenty miles from your hometown, it will feel the same. This is crucial to making customers feel relaxed and at ease while shopping; no store feels foreign. They demonstrate the…

    • 313 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Macy's

    • 528 Words
    • 2 Pages

    Macy's is using the Differentiation Strategy according to the Porter’s 3 strategies model. The market is very competitive and already saturated. It is hard to differentiate themselves with the products itself; consequently, it is the quality of service that Macy's is targeting. Macy's main target is to offer more localized, personalized and smarter retail customer experience across all channels. In order to achieve this, they use Big Data among others to create a personalized customer experience including customized incentives at checkouts. Macy's increased its analytical capabilities with implementing the SAS® Enterprise Miner™ resulting in providing valuable customers with the right promotions in order to serve them the best way possible. Even more, they are now capable of sending hyper-targeted direct mailings to their customers, including 500.000 unique versions of a single mailing! Successful differentiation is displayed when a company accomplishes either a premium price for the product or service, increased revenue, or the consumers' loyalty to purchase the company's product or service (brand loyalty). In Macy's case, they could brilliantly achieve the later two of those KPI's. The new centralized online fulfillment centre came at a cost of $ 170 million. However, thanks to Big Data, they increased store sales with 10 percent over the past years. In 2012 alone, Macy's reported sales of $ 27.7 billion. Taking into account that merely three years ago they were still relying on Excel for insights, this is a noteworthy…

    • 528 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Trader Joe's Case Study

    • 745 Words
    • 3 Pages

    While driving down Manchester Boulevard, you are enticed by Mcdonald's, Taco Bell, and Randy’s Donuts. You are swamped with fast food options but healthy alternatives are scarce. You don’t see signs of fresh vegetables or advertisements for home-cooked foods. The grocery store chain, Trader Joe’s, is a solution to this. The Trader Joe’s corporation should expand their stores into Inglewood, Calif bringing healthier, fresh, organic and cheap produce to a community that needs it.…

    • 745 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    23). Target Corporation prides itself on the research and marketing front as one of the most diligent companies to know how to reach the customers and get the necessary information to ensure the goals of the company are met. For instance, Target has long used customer analytics to make marketing decisions and assess how successful the company is at reaching the prime Target consumer. “Target starts by analyzing its collection data to understand the needs of each customer,” while simultaneously studying marital status, age, gender, household income, occupation, and many other specific details about the consumers who frequent their locations (Corrigan, Craciun, & Powell, 2014). This form of data mining, while extremely controversial is also extremely beneficial to evaluating how well the company is reaching certain consumers and how well the company is performing.…

    • 1688 Words
    • 7 Pages
    Powerful Essays
  • Good Essays

    Rock in a Hard Place

    • 710 Words
    • 3 Pages

    First, the infrastructure and existing systems had to be fixed. One million dollars was spent on installing a data warehouse system that captured and analyzed data corporate wide. Point of sales data was now available regarding all purchases as well as demographic info on customers.…

    • 710 Words
    • 3 Pages
    Good Essays
  • Good Essays

    A great way for Nordstrom to collect and analyze definitive information is called Big Data. Underneath all of the comments on the internet is a huge amount of data about what customers actually do. This information can supply companies with important information about what customers click, what they purchase, and what there habits are. Although this method is great for gather information on core customers it also is not an easy task. It involves collecting data that is so large and complex that it is very difficult to process using typical on-hand database management tools. Some of the challenges using big data are having to capture information, the curation of the information, and also storage of the information. Not to mention also having to search for the information, transfer it so it can be collected, and analyzing it so it can be transformed into a visualization. It's better to use larger data sets because companies can aqcuire additional information from analysis of larger sets of related data, rather than smaller sets with the same overall amount of data. The amount of data that is collected is usually around a few dozen terabytes (one terabyte is 1000 gigabytes) up to many petabytes (1000 terabytes) of data in a single data set. I feel the use of big data will open of doors to more productivity growth and consumer surplus. Other companies that have used big data have…

    • 766 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Closing Case Study One

    • 1065 Words
    • 5 Pages

    To redesign Ben & Jerry’s data warehouse the dimensions of information include frozen yogurt, ice cream, merchandise, locations, sales and shipping. This company should track all the different types of ice cream and yogurt flavors. They should also monitor these areas with the highest and lowest sales to make adjustments to save money. There should be information gathered on the merchandise being sold by Ben & Jerry. Ben & Jerry will monitor sales from stores in other locations ensuring the right merchandise is being shipped to the right location. The different dimensions are merchandise and locations.…

    • 1065 Words
    • 5 Pages
    Good Essays
  • Satisfactory Essays

    Coca-Cola Case Study

    • 303 Words
    • 1 Page

    Coca-Cola uses various segmentation strategies to include and categorize all of its consumers into their beverage market. Coca-Cola has virtually a selecting for everyone on the planet, other than those who naturally prefer Pepsi over Coke. Their “Dieters Segment” appeals to those who are concerned about their weight. Which started with the original Coke and spread to the various versions they offered in late years. Then they created Diet Coke Plus which had added vitamins, which was a customer valued decision. Next there is the “”Real Men” Segment” Which includes Coke Zero, this drink allowed men to purchase low calorie drinks without relating the idea it was very similar to a Diet Coke; “because Diet Coke is for women”. The “Diy Segment” is another segment Coca-Cola has created to divide a extensive target market into subcategories of customers. In this segment otherwise called “Do It Yourself” allowed, consumers to create and mix any possible drink. The new machines are becoming more frequently seen and easily accessible.…

    • 303 Words
    • 1 Page
    Satisfactory Essays