preview

Greaves Brewery Case Analysis

Best Essays

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 & 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 |

Get Access