DEMANDS (Excel)

Document Sample
DEMANDS (Excel) Powered By Docstoc
					                                  a26e1de0-9795-4e9b-b680-6b6544854649.XLS


                            Forecasting and Batch sizing of orders
Product number A101

Smoothing constant (a) =            0.1                        Strategy A:
                                                               cost=



Week:   Demand: Forecast:   Abs. Dev.:    Forecast             Order:      Stock
                                          (as integer)
    1       120
    2       109
    3       124                                                200
    4       119
                                                               150
                                                     Demands
    5       161
    6       138                                                100
    7       131
                                                                50
    8       102
    9       109                                                  0
   10       114                                                      1
   11       145
   12       163
   13       133
   14       170
   15       143
   16       124
   17       113
   18       143
   19       115
   20       158
   21       121
   22       107
   23        70
   24        74
   25       154
   26       111
   27        82
   28        86
   29        93
   30        98
   31        97
   32       129
   33       117
   34       149
   35       154
   36       133
   37       164
   38       156
   39       127
   40        97
   41       123
   42       147


                                                                  Page 1
           a26e1de0-9795-4e9b-b680-6b6544854649.XLS


43   165
44   109
45    91
46    75
47    97
48   124
49    92
50    81
51    47
52    53
53    25
54    90
55    83
56    54
57    57
58    78
59   108
60   100
61    76
62   111
63   106
64   103
65   130
66   120
67    87
68   139
69   113
70    89
71   157
72   135
73    85
74   143
75    95
76   128
77    95
78   134
79   117
80   119
81   130
82   103
83   119
84   149
85   175
86   153
87   132
88   188
89   184
90   106
91   146
92   122
93    86
94   125


                            Page 2
            a26e1de0-9795-4e9b-b680-6b6544854649.XLS


 95   114
 96   148
 97   106
 98   118
 99   136
100   187
101   153
102   172
103   147
104   144




                             Page 3
a26e1de0-9795-4e9b-b680-6b6544854649.XLS




                 Page 4

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:3
posted:12/2/2011
language:English
pages:4