Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Daily Sales Template with autoforecast

VIEWS: 47 PAGES: 3

Template for entering daily sales with volumes and amount for two product groups. Simply enter the data every day and the sheet will recalculate the forecast. There is place for entering the invoicing days as well.

More Info
									      Total
      Date                Pieces Turnover    Date                Pieces          Turnover
              10/1/2010        250      3375         10/1/2009             316           3634
              10/4/2010        640      8640         10/2/2009             740           8510
              10/5/2010        465      4680         10/3/2009             534           6141
                                                     10/5/2009             689         7923.5
                                                     10/6/2009             363         4174.5
                                                     10/8/2009             259         2978.5
                                                     10/9/2009             448           5152
                                                    10/10/2009             890         10235
                                                    10/11/2009             489         5623.5
                                                    10/12/2009            1801        20711.5
                                                    10/13/2009             473         5439.5
                                                    10/14/2009             935        10752.5
                                                    10/16/2009             802           9223
                                                    10/17/2009             433         4979.5
                                                    10/18/2009             471         5416.5
                                                    10/19/2009             288           3312
                                                    10/20/2009             375         4312.5
                                                    10/24/2009             669         7693.5
                                                    10/25/2009             346           3979
                                                    10/28/2009             492           5658
                                                    10/29/2009             355         4082.5
                                                    10/30/2009             556           6394



      Total               1355 16695 Total                          12724          146326
      Forecast            9485 116865 Difference                    -3239          -29461


Number of working days:                   21
http://hirudov.com
Special products
Date             Pieces Turnover     Date                Pieces    Turnover
20101001               35    4644.62         10/1/2009         5              75
20101004               68    5015.67         10/2/2009         8              75
20101005               59    6059.88         10/3/2009         2              75
                                             10/5/2009         6              75
                                             10/6/2009         4              75
                                             10/8/2009         9              75
                                             10/9/2009        11              75
                                            10/10/2009         5              75
                                            10/11/2009         4              75
                                            10/12/2009         3              75
                                            10/13/2009         5              75
                                            10/14/2009         6              75
                                            10/16/2009         8              75
                                            10/17/2009         4              75
                                            10/18/2009         5              75
                                            10/19/2009         6              75
                                            10/20/2009         2              75
                                            10/24/2009         5              75
                                            10/25/2009         2              75
                                            10/28/2009         3              75
                                            10/29/2009         4              75
                                            10/30/2009         5              75



Total            162 15720 Total        112   1650
Forecast        1134 110041 Difference 1022 108391
Comment   Note

								
To top