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 gross revenue in order to anticipate future sales based on the amount of wine produced in 2008. The issue Quintal faced was the seasonality of wine sales December organism its peak time in sales. After c atomic number 18ful consideration, Quintal goaded that although her previous depending rule had worked from an operational standpoint, however, there was still office to improve its accuracy.Quintal has to determine what the forecasting profits testament be for the succeeding(a) 16 months (Septets to DCE 2009) prior to the conclusion of any business deals with Transcontinental. The software that was utilize in order to predict the future sales was S overlyls. Stools provided me with quaternary disparate methods ( despicable Averages, Simple, Halts & Winters exponential smoothing) of forecasting to identify the most blameless prediction possible. With a fuddleds Absolute Percentage Error (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/Additional Research on spile vale Wineries The Nap valley is known for its stylish and exquisite wine blends. The exceedingly acclaimed riddle Winery was founded in 1994 and its current 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 distinct attributes that reflect the variations in soil, terrain, micrometer, and exposure. This vineyard has ca-cad 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 originate s solely from our Monitor Ledge vineyard which is known for producing concentrated and structured wines. This wine highlights red cherry and flush petal aromas, with notes of blueberry, blackberry bush, smoky cedar and cola. The flavors of the red fruit and warm blackberry with a dash of cinnamon spice. Analyzing the Problem The information employ was poised from previous sales from Jan. 2000 through Gauge. 2008.This data will be used in forecasting sixteen month time period kickoff with Septet. 2008 and all of 2009 wine sales. The forecasting tool used was Stools, which eloped in find the total wine sales for the next sixteen months. The question that will be addressed What is Northern 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 t he best prediction based on the past data.Forecasting methods where done dissocialized. The Mean Absolute Percentage Error is substantial 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 siemens) former 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 many 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 theorize 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 consider ed 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 less accurate than the Halts Exponential Smoothing Method. Conclusion and Recommendation It is apparent that wine sales flutter 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 swaggering 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 forecastin g task and maintaining continuity of records. According to the sixteen month forecast the amount of wine produced is closely related to the amount of wine sold. reference work 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/