• Three and Five Point Moving Averages for ABC Floral Shop

    Pages: 4

    This 4 page paper uses data supplied by the student to answer three questions. The first demonstrates the way in which three point averages and five point averages may be calculated, uses the case study provided. The second question presents the results of the data and the moving average results in graphic format along with the inclusion of a trend line. The last question considers which of the two moving averages is best. The bibliography cites 1 source.

    File: TS14_TE35point.doc

    Send Me This Paper »

     

    Sample Text:
    Three and Five Point Moving Averages for ABC Floral Shop November 2011 To Use This Report Correctly, Please Visit  /aftersale.html Question 1 Data has been supplied regarding the sales for ABC Floral Shop. The data is given on a daily basis, showing the demand for the number of  geraniums. When looking at forecasting it is useful to be able to identify trends and then use trends in order to project the potential future demand. The benefit of using  a point moving average is seen in the way that the data is smoothed which allows a graph to be drawn with a line that has the best fit to  the data. The line may then be used to forecast future demand. Using the data we can calculate the three point moving  averages and use this to make a forecast. To calculate a three point average there will be the use of three data points for each day, the data is taken  from the day before, the day being calculated and the next day and averaged; the day for which the average being calculated in usually the middle data point. So we  cannot calculate this for day one, as there is no data for the day before. To calculate the moving average for day two we take the data from days 1,  2 and 3 and then divide it by 3. This is then repeated, so the three point average for day three takes the demand data from days 2, 3 and  4 and divides by 3. This is repeated for all the days (except the last day as there are not three data point which can be used. The results for 

    Back to Results