Weekly Sales Stock Inventory
Week Month
2010
2011
%Inc/Dec Plan on year stock PO= 100.000
Week cover
Dels
1 2 3 4
P1 P2
$15.000 $23.000 $21.000 $29.000 $88.000 $22.000 $17.000 $14.000 $12.000 $65.000 $153.000
$5.000 $10.000 $8.000 $7.000 $30.000 $12.000 $18.000 $17.000 $23.000 $70.000 $100.000
33,3% 43,4% 38% 24,1% 34% 54,5 105,8% 121,4% 191,6% 107,6% 65%
180.000 240.000
7 6 6
O.T.B OTB PO =100.000 110.000 130.000
$26.000 $18.000 $13.000 $16.000 $73.000 $138.000
$35.000 $23.000 $31.000 $21.000 $110.000 $210.000
134,6% 127,7% 238,4% 131,2% 150,6% 152,2%
340.000
7
210.000
$15.000 $19.000 $27.000 $20.000 P4 $81.000 Cum P3-‐ $154.000 4 $45.000 $39.000 $53.000 $21.000 P5 $158.000 Cum $239.000 P4-‐5 $12.000
$40.000 $27.000 $33.000 $30.000 $130.000 $340.000
266,6% 142,1% 122,2% 150% 160,4% 220,7%
120.000
7
40.000
$19.000 $12.000 $26.000 $23.000 $80.000 $420.000
42,2% 30,7% 49% 109,5% 50,6% 175,7%
130.000
6
140.000
$17.000 $8.000 $3.000 $2.000
141,6% 88,8% 37,5% 33,33%
$30.000
85,7%
7
Cum P1-‐2
P3 Cum P2-‐3
$9.000
$8.000 $6.000
P6
$35.000 Cum P1-‐ $500.000 6
$450.000 90%
The weekly stock intake is a report is a way to analyse how often a company changes its stock in a year. Thus, helps to anticipate the stock level at peak periods such as Christmas or the summer season. Jackson (2001). Moreover, it also enables have a better awareness of the inventory.
List of formulas used: Plan Stock : Plan Stock P0 = Sales 2011 P1 + Sales 2011 P2 Plan Stock P1 = Sales 2011 P2 + Sales 2011 P3 Plan Stock P2 = Sales 2011 P3 + Sales 2011 P4 Plan Stock P3 = Sales 2011 P4 + Sales 2011 P5 OTB : OTB P0 = Plan Stock P0 OTB P1 = Plan Stock P1 – Sales 2011 P2 OTB P2 = Plan Stock P2 – Sales 2011 P3 OTB P3 = Plan Stock P3 – Sales 2011 P4 OTB P4 = Plan Stock P4 – Sales 2011 P5 OTB P5 = Plan Stock P5 – Sales 2011 P6 + OTB P4