Greaves Brewery Case Analysis - 1441 Words

Greaves Brewery Case Analysis Greaves Brewery: Bottle Replenishment Case Analysis Case Synopsis The following is an analysis of the case, Greaves Brewery: Bottle Replenishment. It details the growing beer operation of Greaves Brewery located in the Caribbean island of Trinidad. The purchasing manager for the company, Alex Benson, is uncertain about how many bottles to order from the company’s German glass supplier. His decision is complicated by the possibility of a new bottle design being introduced that would compromise his existing inventory of bottles. Additionally, he is faced with storage limitations and erratic sales, all of which are impacting his decision. He is also concerned about over ordering to avoid issues from an†¦show more content†¦Data Analysis to Support Decision According to the case, prior to the implementation of the Trinidadian’s government excise taxes, Greaves Brewery was showing signs of growth (Erskine, Leenders amp; Piper, 2004). To show growth trends, a Time Series graph was run from 1999 to 2004. However, the purpose of the case is to determine the quantity of bottles that Greaves needs to purchase based on a sales forecast for 2004. Greaves provided five years and two months of annual sales data. Using Stat Tools, the following analysis were run: Moving Average, Exponential Smoothing Simple, Exponential Smoothing Holt’s, and Exponential Smoothing Winter’s. Following a comparison on the average on all models, the Exponential Smoothing Winter’s was found to be the most suitable model for the case. A graph analysis is captured below. StatTools Report | | | | | Analysis: | Forecast | | | | | Performed By: | shart | | | | | Date: | Friday, November 18, 2011 | | | | Updating: | Live/Unlinked | | | | | Forecasting Constant | | | | | | Span | 3 | | | | | Moving Averages | | | | | | Mean Abs Err | 62.10 | | | | | Root Mean Sq Err | 83.52 | | | | | Mean Abs Per% Err | 22.27% | | | | | Forecasting Data | Sales | Forecast |Show MoreRelatedGreaves Brewery Case Analysis1462 Words   |  6 PagesGreaves Brewery: Bottle Replenishment Case Analysis Case Synopsis The following is an analysis of the case, Greaves Brewery: Bottle Replenishment. It details the growing beer operation of Greaves Brewery located in the Caribbean island of Trinidad. The purchasing manager for the company, Alex Benson, is uncertain about how many bottles to order from the company’s German glass supplier. His decision is complicated by the possibility of a new bottle design being introduced that would compromiseRead MoreGreaves Brewery1117 Words   |  5 PagesExecutive Summary Greaves Brewery is a growing beer operation based out of Trinidad. The purchasing manager for the brewery finds himself struggling in finding a balance between ordering enough bottles to support sales; yet minimizing over ordering to avoid issues associated with growth decelerating trend from an off year, continued impact from government excise tax, tourism, and growth of exports particularly the USA. In addition to previously mentioned concerns ordering the right number