Case Study-Ben and Jerry's

Good Essays
1. If I were to design Ben & Jerry's data warehouse I would use several dimensions of information. The first dimension would consist of the company's products; ice cream, frozen yogurt or merchandise. The marketing department has to know which products are selling, if Ben & Jerry's didn't know that their T-shirts are selling out as soon as they hit the stores, then they wouldn't be able to take advantage of the opportunity to sell the shirts. The second dimension would consist of the different areas of sales; US, Canada, Mexico, or Europe. I am not sure if they sell their ice cream in Mexico, but with data collection they can find out if their ice cream would be a better seller in the hot climate, rather than pushing for greater distribution in Canada. The third dimension would consist of the "specifics"; where the sale was made, when the sale was made, and who purchased the product. This information can help in the design of the product to focus on the buyer; it can tailor flavors to seasons, and packaging to buyer who looks for the better-looking product. If Ben & Jerry's could know when a season was coming to an end in a specific area, then they could forecast the need or the decline in need and speed up, or slow down distribution to those areas. The focus of the information is that it needs to be useful, and almost any information is useful.
2. Ben & Jerry's would need a huge number of files. The files I would create would be Store, Product, and Employee files. The Store file would contain information about each store that sells Ben & Jerry's, it would tell me everything about every transaction with a Ben & Jerry's product. The primary key for the Store file would be the store number, or code. Some of the foreign keys would be; delivery dates, order dates, sales, and customer complaints. The Employee files primary key would be an employee number. The foreign keys for the Employee files would be; start date, wage, shift, employee address, paid time off, and

You May Also Find These Documents Helpful

  • Good Essays

    Ben and Jerry's Case Study

    • 1058 Words
    • 5 Pages

    Ben and Jerry’s Case Study What makes a company great? Is it constant financial growth year after year? Is it producing a product that is known and recognized in millions of households around the world? Or is it being socially conscience while still providing a cost effective product? With Ben and Jerry’s ice cream company, it’s not enough to just be financially successful; they also strive to be socially successful. Ben and Jerry’s want more from their alliances with wholesalers, franchisees…

    • 1058 Words
    • 5 Pages
    Good Essays
  • Powerful Essays

    Ben and Jerry's Case Study

    • 2393 Words
    • 10 Pages

    Ben & Jerry's Homemade ice cream Inc. Tutor’s Introduction This case study comes from the second edition of Business Strategy: an introduction published in 2001. It is very readable and interesting, providing students with insights into how two entrepreneurs who set up an ice cream shop in a renovated petrol station became the names behind one of the most well-known ice cream brands around the globe. Students will find out how Ben and Jerry tackled the almighty (at the time) Pillsbury and Häagen-Dazs…

    • 2393 Words
    • 10 Pages
    Powerful Essays
  • Good Essays

    Ben and Jerry's Case Study

    • 1054 Words
    • 5 Pages

    Mission in Ben and Jerry’s, and she had to face many issues concerning the mission statement of the company, such as political voice, employee morale and product development. It was hard for her to integrate the social beliefs of Ben and Jerry’s into the code of conduct of Unilever. • Employee Morale: Prior to the acquisition, employees of Ben and Jerry’s saw the company as a network of family and friends in which they were all fully involved and integrated. Ben and Jerry’s had a policy…

    • 1054 Words
    • 5 Pages
    Good Essays
  • Good Essays

    Ben and Jerry’s is an ice cream manufacturing company founded in 1978 in Burlington, Vermont, U.S.A. Right from the beginning the founders, Ben Cohen and Jerry Greenfield, have kept an equal focus on creating delicious ultra premium ice cream desserts and giving back to social and environmental issues. Their grassroots efforts to use local and sustainable ingredients superseded today’s farm to table craze by decades. Despite Ben and Jerry’s annual sales revenue of $132 million and incredible growth…

    • 797 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Ben & Jerry's Case Study

    • 1008 Words
    • 5 Pages

    BEN & JERRY’S HOMEMADE ~ Case Analysis ~ I. PROBLEM STATEMENT Ben and Jerry’s, founded in 1978, is a market leading distributor of super-premium ice creams, frozen yogurts, and sorbets, and has built a reputation on being a socially minded company. They were pioneers in the policy of “caring capitalism” and place heavy importance on the concept of social responsibility, a practice which many companies have since adopted. They have enjoyed long-term success as a result of their progressive…

    • 1008 Words
    • 5 Pages
    Good Essays
  • Good Essays

    Ben & Jerry's Case Study

    • 593 Words
    • 3 Pages

    Question One: Ben & Jerry’s is founded on and dedicated to the three main parts of their mission statement: social, product and economic. These missions were to be fulfilled in creative new ways. When the company first started, the strong commitment to the community was a unique idea but it is now an increasing popular concept. Over the past decades, Ben & Jerry’s has continuously donated 7.5% of its pretax earnings to various social foundations and community-action groups. Also, they express…

    • 593 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Ben and Jerry's Case

    • 3503 Words
    • 15 Pages

    edu Managing Social Responsibility and Growth at Ben & Jerry’s INTRODUCTION Ben Cohen and Jerry Greenfield opened their first ice cream shop on May 5, 1978, in a converted gas station in Burlington, Vermont, investing $12,000 in secondhand equipment. Their business credentials consisted of much enthusiasm and a $5 Pennsylvania State University correspondence course in ice cream making. Driven by Cohen and Greenfield’s 1960s ideals, Ben & Jerry’s Homemade, Inc., has grown to be a very successful…

    • 3503 Words
    • 15 Pages
    Powerful Essays
  • Good Essays

    Ben and Jerry's

    • 971 Words
    • 4 Pages

    “Ben & Jerry’s – Japan” Assignment 2 1. Which way would you recommend B&J enter Japan: with Mr. Yamada or with 7-11? Support your answer with rationale. Let’s see the advantages and disadvantages for Ben and Jerry’s to enter the Japanese market with Mr. Yamada or with 7-Eleven Japan; Entering Japanese market with Mr. Yamada: Advantages: * Ken Yamada was a third generation Japanese American from Hawaii, with his excellent marketing skills and knowledge of the Japanese market and…

    • 971 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Ben And Jerry's

    • 1007 Words
    • 5 Pages

    Ben and Jerry’s was founded in 1978 by childhood friends Ben Cohen and Jerry Greenfield. They had a dream of starting a company together but they didn’t have any experience in business. Due to their love for food, they came up with the idea of making bagels or ice cream, but the cost of the equipment for bagels was much higher so they chose to produce homemade ice cream (citation). They learned only from small business pamphlets and a correspondence course from Penn State University (citation).…

    • 1007 Words
    • 5 Pages
    Good Essays
  • Satisfactory Essays

    Ben and Jerry's

    • 382 Words
    • 2 Pages

    Ben & Jerry's omemade Inc.: Y'o! I'm Y'our CEO!" This case was prepared by Katherine A. Auer of (he lndlOno University and Alan N. Hoffman of Bentley College. Ben & Jerry's Grows Up -Boston Globe Ben, Jerry Losing Their Values ' -Washington TImes Ben & Jerry's Melting Social Charter -Washington Post The headlines said i( all. Ben & Jerry's, the company that had built its success as much on its down-home image and folksy idealism as on its superrich ice cream, was at a crossroads…

    • 382 Words
    • 2 Pages
    Satisfactory Essays