Napa Valley Winery Inc

Quintal realized that the quantity of red table vino produced is closely associated to the gross revenue. Ms. Quintal reviewed her past sales in order to predict future sales based on the amount of wine produced in 2008. The issue Quintal faced was the seasonality of wine sales declination being its peak time in sales. After careful consideration, Quintal determined that although her precedent soothsaying method acting had worked from an operational standpoint, however, there was still dwell to improve its accuracy.Quintal has to determine what the forecasting profits leave be for the next 16 months (Septets to DCE 2009) prior to the conclusion of any business deals with Transcontinental. The software that was used in order to predict the future sales was Stools. Stools provided me with four different methods (Moving Averages, Simple, Halts & Winters exponential smoothing) of forecasting to identify the most accurate foretelling possible. With a Means absolute Percentage Erro r (MAPS) of 3. 72% the Halts exponential smoothing method was determined to be the best method of predicting monthly wine sales for the next sixteen months (Figure 2).Background/ spare Research on Nap Valley Wineries The Nap valley is known for its stylish and exquisite wine blends. The highly acclaimed Paradox Winery was founded in 1994 and its flowing wine maker is David Marches. Paradox is the only winery that is truly devoted to wine blends in the Nap Valley. Paradox has four different estates that produce grapes with apparent attributes that reflect the variations in soil, terrain, micrometer, and exposure. This vineyard has created a blend of zinfandel, Cabernet Sauvignon, along with smaller amounts of Merlot and Petite Sarah to create the first Paradox vintage.One of Paradoxs quality wines is the 2006 Postmark Monitor ledge Vineyard Red Wine. This lend of Zinfandel paired with Cabernet Sauvignon and Merlot originates solely from our Monitor Ledge Vineyard which is known fo r producing concentrated and structured wines. This wine highlights red cherry and move up petal aromas, with notes of blueberry, blackberry, smoky cedar and cola. The flavors of the red fruit and warm blackberry with a dash of cinnamon spice. Analyzing the Problem The entropy used was gathered from previous sales from Jan. 2000 through Gauge. 2008.This data will be used in forecasting sixteen month time period starting with Septet. 2008 and all of 2009 wine sales. The forecasting tool used was Stools, which eloped in determining the total wine sales for the next sixteen months. The question that will be addressed What is Federal Nap Valley Winners projected sales for the upcoming sixteen months? To better answer this question there are four different methods of forecasting (Figure 5 Moving Averages, Figure 4 Simple, Figurer Halts & Figure 3 Winters Exponential Smoothing) that will be used, of those four one will give the best prediction based on the past data.Forecasting methods where done dissocialized. The Mean Absolute Percentage Error is important when forecasting data. The closer the MAPS is to zero the more accurate the forecast. This will be the catalyst in determining the accuracy of the forecasts. Runs test (Null Hypothesis of Randomness) Prior to doing any forecasting it is important to determine whether or not the data is random or nonrandom. The software used to conduct the Runs Test for Randomness was Stools. This test was used in order to determine if there were too some or too few runs in a series of data.Figure 5 Moving Averages I I Forecasting Constant I Forecast I Span 13 Mean Abs Err 1683. 03 631. 59 I I Moving Averages 1460. 00 1480. 16 I Root Mean Sq Err 14. 12% By using Stools a graph was formulated to show the fluctuation of sales from Jan 2000 through DCE. 2009. The moving average in this case for the next sixteen months produced a MAPS of 4. 12%. A MAPS of is considered to be very good so 4. 12% has limited forecasting errors and would be considered an excellent forecast. Although, the MAPS for the moving average was considerably accurate, the Halts method produced a MAPS of 3. 2% which indicative of a more accurate forecast. The difference between the Moving Averages method and the Halts method is the MAPS of . 4%, which makes the Moving Average little accurate than the Halts Exponential Smoothing Method. Conclusion and Recommendation It is apparent that wine sales fluctuate monthly which could be based upon changes in the economy, climate, or preference. Annual forecasting is not conducive to wine sales since wine fluctuates on a monthly basis. An example of wine lactating would be in August sales are low but, in sales are at its peak.Ms. Quintal should forecast future sales on a monthly basis in order to maintain a more accurate account sales activity. It is recommended that Ms. Quintal utilize Stools as a means of automating her forecasting task and maintaining tenacity of records. According to the six teen month forecast the amount of wine produced is closely related to the amount of wine sold. Reference Nap valley wineries. (2011, November 16). Retrieved from http// www. Banqueters. Com/nap_valley_wineries. HTML (2011, November 16). Retrieved from http//www. Wisped. Org/