Estee de Pob Inventory Date: Sept 9 - Sept 14: Dairy Coffee Beans Syrups and Sauces

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 20

ESTEE DE POB

INVENTORY
Date: Sept 9 - Sept 14
DAY 1 SEPT 9
Orde
Beg Del End
r
Dairy
1 Fresh Milk (12L/case) 0 0 0 0
Coffee Beans
2 Allegro Beans (1kg/pack) 0 300 0 300
Syrups and Sauces
3 Biadgi Dark Chocolate Sauce (1.89 L/jug) GRAM 0 0 0 0
4 Biadgi White Chocolate Sauce (1.89 L/jug) GRAM 500 0 0 500
5 Chai Tea (700ml/btl)(15shot 0.3 0 0 0.3
6 Matcha Powder (1kg/pack) 800 0 0 800
Softfdrinks and Water
7 Coke Regular (24 pcs/case) 12 0 1 11
8 Coke Zero (24 pcs/case) 26 0 0 26
9 Sprite (24 pcs/case) 46 0 0 46
10 Bottled Water (24 pcs/case) 8 0 0 8
11 Soda Water (24 pcs/case) 32 0 0 32
12 Tonic Water (24 pcs/case) 11 0 0 11
13 Red bull (24 pcs/case) 6 0 0 6
14 Sprite l(1.5 liter) (24 pcs/case) 0 0 0 0
16 Ginger ale (24 pcs/case) 22 0 1 21
17 Coke Regular (1.5L) (24 pcs/case) 0 0 0 0
18 Lick Ice tea (24 pcs/case) 1 0 0 1
19 Mango shake (24 pcs/case) 0 0 0 0
20 Watermelon shake (24 pcs/case) 0 0 0 0
21 AllmighTEA Iced Tea (6 pcs/box) 0 0 0 0
22 Banana shake (24 pcs/case) 0 0 0 0
Beers
23 San Miguel Light (24 pcs/case) 21 0 0 21
24 San Miguel Super Dry (24 pcs/case) 0 0 0 0
25 Red Horse (24 pcs/case) 45 0 7 38
26 Heineken (24 pcs/case) 10 0 0 10
27 Pale Pilsen (24 pcs/case) 9 0 1 8
28 San Miguel Premium (24 pcs/case) 20 0 0 20
30 Smirnoff Mule (24 pcs/case) 39 72 0 111
31 Heineken Keg 32 glasses per keg 0 0 0 0
32 Tiger light (24 pcs/case) 112 0 0 112
33 Tiger Black (24 pcs/case) 9 0 0 9
34 San mig apple (24 pcs/case) 18 0 0 18
Liquors
VODKA
35 Absolut Vodka (700ml/btl)(15shot 1.8 0 0 1.8
37 Greygoose (750ml/btl)(16shot 0.7 0 0 0.7
38 Ketel One (750ml/btl)(16shot 0.7 0 0 0.7
39 Zubrowka (700ml/btl)(15shot 1.6 0 0 1.6
40 Smirnoff (700ml/btl)(15shot 3.8 0 0 3.8
RHUM
41 Don Papa (700ml/btl)(15shot 2.1 0 0 2.1
42 Sailor Jerry (700ml/btl)(15shot 1.4 0 0 1.4
43 Bacardi Gold (750ml/btl)(16shot 3.2 0 0 3.2
44 Bacardi Superior (750ml/btl)(16shot 2.9 0 0 2.9
45 Bacardi Black (750ml/btl)(16shot 1.7 0 0 1.7
46 Tanduay Asian Gold (750ml/btl)(16shot 0.3 0 0 0.3
47 Tanduay Asian Silver (750ml/btl)(16shot 0.9 0 0 0.9
AMERICAN RYE
48 Wild Turkey (700ml/btl)(15shot 1.5 0 0 1.5
BOURBON
49 Jimbeam White (750ml/btl)(16shot 1.8 1 0 2.8
50 Makers Mark (750ml/btl)(16shot 0.4 0 0 0.4
51 Bulleit Bourbon (1L/btl)(22shot) 1.4 0 0 1.4
52 Jack Daniels (700ml/btl)(15shot 0.7 6 0 6.7
53 Jack Daniels Honey (700ml/btl)(15shot 5.9 0 0 5.9
BRANDY
54 Hennessy (700ml/btl)(15shot 0.7 0 0 0.7
Irish
55 Jameson (700ml/btl)(15shot 1.9 0 0 1.9
56 Teeling (750ml/btl)(16shot 1.7 0 0 1.7
GIN
57 Bombay Sapphire (750ml/btl)(16shot 2.7 2 0 4.7
58 Crows (750ml/btl)(16shot 1 0 0 1
59 Hendricks (700ml/btl)(15shot 0.9 0 0 0.9
60 Tanqueray (750ml/btl)(16shot 1.6 0 0 1.6
61 Belgravia Londo dry (700ml/btl)(15shot 5.3 0 0 5.3
TEQUILLA
62 Cazadorez Reposado (750ml/btl)(16shot 7.4 0 0 7.4
63 Jose Cuervo Silver Tradicional (700ml/btl)(15shot 1.5 0 0 1.5
64 Jose Cuervo Gold Tadicional (700ml/btl)(15shot 2.3 0 0 2.3
65 Jose Cuervo Reposado Gold (700ml/btl)(15shot 1.5 4 0 5.5
66 Muestrano Ocho (500ml/btl)(11shot 0.7 0 0 0.7
67 Patron Silver (750ml/btl)(16shot 1.7 0 0 1.7
68 Patron XO (750ml/btl)(16shot 1.5 0 0 1.5
69 Siete Misterios (700ml/btl)(15shot 1 0 0 1
70 Jaegermeister (700ml/btl)(15shot 1 3 0 4
SINGLE MALT
74 Glenlivet 12 years (700ml/btl)(15shot 1.2 0 0 1.2
75 Glenfiddich 12 years (700ml/btl)(15shot 1.8 0 0 1.8
BLENDED SCOTCH
76 Dewars white label (750ml/btl)(16shot 1.8 0 0 1.8
77 Chivas Regal 12 years (750ml/btl)(16shot 0.9 0 0 0.9
78 Johnie Walker Black Label (700ml/btl)(15shot 2.8 0 0.1 2.7
80 Johnie Walker WHITE Label (700ml/btl)(15shot 0.4 0 0 0.4
81 Embassy (750ml/btl)(16shot 1.9 0 0 1.9
82 Captain Morgan (750ml/btl)(16shot 2 0 0 2
SYRUPS
83 1883 Raspberry Syrup (Depuis) (1 L/bottle) GRAMS 0.6 0 0 0.6
84 Giffard Granade (1L/btl)(22shot) 0.4 0 0 0.4
85 Giffard Orgeat (1L/btl)(22shot) 1 0 0 1
86 Giffard Mirabelle (1L/btl)(22shot) 0.8 0 0 0.8
87 Giffard Fleur de Sureu (1L/btl)(22shot) 0.8 0 0 0.8
88 Giffard Poire (1L/btl)(22shot) 1.3 0 0 1.3
89 Giffard Lichi (1L/btl)(22shot) 0.7 0 0 0.7
MIXING LIQUORS
91 Cointreu (700ml/btl)(15shot 0.9 0 0 0.9
92 Dissarono Amarreto (700ml/btl)(15shot 0.8 0 0 0.8
93 Campari (750ml/btl)(16shot 0.7 0 0 0.7
94 Mamille Calamansi (750ml/btl)(16shot 0.4 0 0 0.4
95 Mamille Dalandan (750ml/btl)(16shot 1 0 0 1
96 Absinth (1L/btl)(22shot) 0.9 0 0 0.9
97 Amadeo Coffee (750ml/btl)(16shot 0.5 0 0 0.5
98 Intramuros De Cacho (750ml/btl)(16shot 1 0 0 1
99 BLUE CURACAO (750ml/btl)(16shot 1.4 0 0 1.4
100 Baileys (700ml/btl)(15shot 0.9 0 0 0.9
101 Kahlua (700ml/btl)(15shot 0.9 0 0 0.9
VERMOUTH
102 Dolin Blanc (700ml/btl)(15shot 0 0 0 0
103 Dolin Dry (700ml/btl)(15shot 2.2 0 0 2.2
104 Dolin Rogue (700ml/btl)(15shot 0.9 0 0 0.9
Wines
109 Premio (Red wine) (750ml/btl)(4shot) 0 0 0 0
110 Premio (White wine) (750ml/btl)(4shot) 8.2 0 0 8.2
114 Doques (Sparkling wine) (750ml/btl)(4shot) 1.5 0 0 1.5
Herbs and Fruits
115 Orange (pieces) 0 0 0 0
116 Lemon (pieces) 0 0 0 0
117 Lime kilo 0 0 0 0
118 Cherries (60g/pck) 0 0 0 0
119 Mint Leaves (60g/pck) 0 0 0 0
120 Cucumber pieces 0 0 0 0
121 SW Dark Cherry 200g/can 0 0 0 0
123 Angostura bottle 0 0 0 0
Cups & Lids and Take out
124 12 oz Hot Cup (50 pcs/pack) 0 0 0 0
125 12 oz Hot Lid (100 pcs/pack) 0 0 0 0
126 12 oz Cold Cup (50 pcs/pack) 0 0 0 0
127 12 oz Cold lids (50 pcs/pack) 0 0 0 0
128 Micro. Rect. 750 ml Container 10pcs/pack 0 0 0 0
129 Brown Bag Large 100pcs/pack 0 0 0 0
130 Disposable Forks 50pcs/pck 0 0 0 0
131 Disposable Spoons 50pcs/pck 0 0 0 0
Dining Items and Sundries
132 Interfolded White Tissue pieces 0 0 0 0
133 Coffee Stirrer box 0 0 0 0
134 Jumbo Roll Tissue pieces 0 0 0 0
135 Brown Table Napkin packs 0 0 0 0
136 Minted Toothpick box 0 0 0 0
137 Foam Sponge per piece 0 0 0 0
138 Tea Light Candle box 0 0 0 0
139 Trashbag Roll - Large packs 0 0 0 0
140 Dishwashing Liquid 1 gal 0 0 0 0
141 Zonrox Original 1 gal 0 0 0 0
142 Liquid handsoap 1 gal 0 0 0 0
143 Air freshener (Lemon Glade) per bottle 0 0 0 0
144 Powder Detergrent 1kg/pack 0 0 0 0
145 Fabric Softener 1kg/pack 0 0 0 0
146 Gloves pieces 0 0 0 0
Cakes and Cookis
147 Red Velvet Cupcakes with Cream Cheese Frpieces 0 0 0 0
148 Oreo cheesecake Cookies pieces 0 0 0 0
149 Chocolate Cupcakes with Salted Caramel-Cpieces 0 0 0 0
150 Cheesecake Brownies pieces 0 0 0 0
151 Basque Cheesecake pieces 0 0 0 0
152 Banana Muffin pieces 0 0 0 0
153 Exotic Cake pieces 0 0 0 0
154 Brownies pieces 0 0 0 0
154 Macaroons pieces 10 0 0 10
154 Raspberry Cookies pieces 12 0 0 12
154 Cake Pops pieces 14 0 0 14
DAY 1 SEPT 9 DAY 2 SEPT 10 DAY 3 SEPT 11
Actual Orde Actual Orde
Variance Beg Del End Variance Beg Del End
Count r Count r

0 0 0 2 0 2 2 0 2 0 0 2

300 0 300 0 0 300 300 0 300 0 0 300

0 0 0 0 0 0 0 0 0 0 0 0
500 0 500 0 0 500 500 0 500 0 0 500
0.3 0 0.3 0 0 0.3 0.3 0 0.3 0 0 0.3
800 0 800 0 0 800 800 0 800 0 0 800

11 0 11 0 0 11 11 0 11 0 0 11
26 0 26 0 0 26 26 0 26 0 0 26
46 0 46 0 0 46 46 0 46 0 0 46
8 0 8 0 0 8 8 0 8 0 0 8
32 0 32 0 0 32 32 0 32 0 1 31
11 0 11 0 0 11 11 0 11 0 0 11
6 0 6 0 0 6 6 0 6 0 0 6
0 0 0 0 0 0 0 0 0 0 0 0
21 0 21 0 0 21 21 0 21 0 0 21
0 0 0 0 0 0 0 0 0 0 0 0
1 0 1 0 0 1 1 0 1 0 0 1
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0

21 0 21 0 0 21 21 0 21 0 0 21
0 0 0 0 0 0 0 0 0 0 0 0
38 0 38 0 0 38 38 0 38 0 0 38
10 0 10 0 4 6 6 0 6 0 0 6
8 0 8 0 0 8 8 0 8 0 3 5
20 0 20 0 0 20 20 0 20 0 0 20
111 0 111 0 4 107 107 0 107 0 0 107
0 0 0 0 0 0 0 0 0 0 0 0
112 0 112 0 0 112 112 0 112 0 0 112
9 0 9 0 0 9 9 0 9 0 0 9
18 0 18 0 0 18 18 0 18 0 0 18

1.8 0 1.8 0 0 1.8 1.8 0 1.8 0 0 1.8


0.7 0 0.7 0 0 0.7 0.7 0 0.7 0 0 0.7
0.7 0 0.7 0 0 0.7 0.7 0 0.7 0 0 0.7
1.6 0 1.6 0 0 1.6 1.6 0 1.6 0 0 1.6
3.8 0 3.8 0 0 3.8 3.8 0 3.8 0 0 3.8

2.1 0 2.1 0 0 2.1 2.1 0 2.1 0 0 2.1


1.4 0 1.4 0 0 1.4 1.4 0 1.4 0 0 1.4
3.2 0 3.2 0 0 3.2 3.2 0 3.2 0 0 3.2
2.9 0 2.9 0 0 2.9 2.9 0 2.9 0 0 2.9
1.7 0 1.7 0 0 1.7 1.7 0 1.7 0 0 1.7
0.3 0 0.3 0 0 0.3 0.3 0 0.3 0 0 0.3
0.9 0 0.9 0 0 0.9 0.9 0 0.9 0 0 0.9

1.5 0 1.5 0 0 1.5 1.5 0 1.5 0 0 1.5

2.8 0 2.8 0 0 2.8 2.8 0 2.8 0 0 2.8


0.4 0 0.4 0 0 0.4 0.4 0 0.4 0 0 0.4
1.4 0 1.4 0 0 1.4 1.4 0 1.4 0 0 1.4
6.7 0 6.7 0 0 6.7 6.7 0 6.7 0 0 6.7
5.9 0 5.9 0 0 5.9 5.9 0 5.9 0 0 5.9

0.7 0 0.7 0 0 0.7 0.7 0 0.7 0 0 0.7

1.9 0 1.9 0 0 1.9 1.9 0 1.9 0 0 1.9


1.7 0 1.7 0 0 1.7 1.7 0 1.7 0 0 1.7

4.7 0 4.7 0 0 4.7 4.7 0 4.7 0 0 4.7


1 0 1 0 0 1 1 0 1 0 0 1
0.9 0 0.9 0 0 0.9 0.9 0 0.9 0 0 0.9
1.6 0 1.6 0 0 1.6 1.6 0 1.6 0 0 1.6
5.3 0 5.3 0 0 5.3 5.3 0 5.3 0 0 5.3

7.4 0 7.4 0 0 7.4 7.4 0 7.4 0 0 7.4


1.5 0 1.5 0 0 1.5 1.5 0 1.5 0 0 1.5
2.3 0 2.3 0 0 2.3 2.3 0 2.3 0 0 2.3
5.5 0 5.5 0 0 5.5 5.5 0 5.5 0 0 5.5
0.7 0 0.7 0 0 0.7 0.7 0 0.7 0 0 0.7
1.7 0 1.7 0 0 1.7 1.7 0 1.7 0 0 1.7
1.5 0 1.5 0 0 1.5 1.5 0 1.5 0 0 1.5
1 0 1 0 0 1 1 0 1 0 0 1
4 0 4 0 0 4 4 0 4 0 0 4

1.2 0 1.2 0 0 1.2 1.2 0 1.2 0 0 1.2


1.8 0 1.8 0 0 1.8 1.8 0 1.8 0 0 1.8

1.8 0 1.8 0 0 1.8 1.8 0 1.8 0 0 1.8


0.9 0 0.9 0 0 0.9 0.9 0 0.9 0 0 0.9
2.7 0 2.7 0 0 2.7 2.7 0 2.7 0 0 2.7
0.4 0 0.4 0 0 0.4 0.4 0 0.4 0 0 0.4
1.9 0 1.9 0 0 1.9 1.9 0 1.9 0 0 1.9
2 0 2 0 0 2 2 0 2 0 0 2

0.6 0 0.6 0 0 0.6 0.6 0 0.6 0 0 0.6


0.4 0 0.4 0 0 0.4 0.4 0 0.4 0 0 0.4
1 0 1 0 0 1 1 0 1 0 0 1
0.8 0 0.8 0 0 0.8 0.8 0 0.8 0 0 0.8
0.8 0 0.8 0 0 0.8 0.8 0 0.8 0 0 0.8
1.3 0 1.3 0 0 1.3 1.3 0 1.3 0 0 1.3
0.7 0 0.7 0 0 0.7 0.7 0 0.7 0 0 0.7

0.9 0 0.9 0 0 0.9 0.9 0 0.9 0 0 0.9


0.8 0 0.8 0 0 0.8 0.8 0 0.8 0 0 0.8
0.7 0 0.7 0 0 0.7 0.7 0 0.7 0 0 0.7
0.4 0 0.4 0 0 0.4 0.4 0 0.4 0 0 0.4
1 0 1 0 0 1 1 0 1 0 0 1
0.9 0 0.9 0 0 0.9 0.9 0 0.9 0 0 0.9
0.5 0 0.5 0 0 0.5 0.5 0 0.5 0 0 0.5
1 0 1 0 0 1 1 0 1 0 0 1
1.4 0 1.4 0 0 1.4 1.4 0 1.4 0 0 1.4
0.9 0 0.9 0 0 0.9 0.9 0 0.9 0 0 0.9
0.9 0 0.9 0 0 0.9 0.9 0 0.9 0 0 0.9

0 0 0 0 0 0 0 0 0 0 0 0
2.2 0 2.2 0 0 2.2 2.2 0 2.2 0 0 2.2
0.9 0 0.9 0 0 0.9 0.9 0 0.9 0 0 0.9

0 0 0 0 0 0 0 0 0 0 0 0
8.2 0 8.2 0 0 8.2 8.2 0 8.2 0 0 8.2
1.5 0 1.5 0 0 1.5 1.5 0 1.5 0 0 1.5

0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
10 0 10 0 0 10 10 0 10 0 0 10
12 0 12 0 0 12 12 0 12 0 0 12
14 0 14 0 0 14 14 0 14 0 0 14
DAY 3 SEPT 11 DAY 4 SEPT 12 DAY 5 SEPT 13
Actual Orde Actual Orde
Variance Beg Del End Variance Beg Del End
Count r Count r

2 0 2 0 0 2 2 0 2 0 0.25 1.75

300 0 300 0 0 300 300 0 300 0 75 225

0 0 0 0 0 0 0 0 0 0 0 0
500 0 500 0 0 500 500 0 500 0 25 475
0.3 0 0.3 0 0 0.3 0.3 0 0.3 0 0 0.3
800 0 800 0 0 800 800 0 800 0 0 800

11 0 11 0 0 11 11 0 11 0 6 5
26 0 26 0 0 26 26 0 26 0 2 24
46 0 46 0 0 46 46 0 46 0 0 46
8 0 8 0 0 8 8 0 8 0 2 6
31 0 31 0 0 31 31 0 31 0 1 30
11 0 11 0 0 11 11 0 11 0 3 8
6 0 6 0 0 6 6 0 6 0 0 6
0 0 0 0 0 0 0 0 0 0 0 0
21 0 21 0 0 21 21 0 21 0 5 16
0 0 0 0 0 0 0 0 0 0 0 0
1 0 1 0 0 1 1 0 1 0 1 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0

21 0 21 0 0 21 21 0 21 72 41 52
0 0 0 0 0 0 0 0 0 72 68 4
38 0 38 0 0 38 38 0 38 72 74 36
6 0 6 0 0 6 6 0 6 0 6 0
5 0 5 0 0 5 5 0 5 96 14 87
20 0 20 0 0 20 20 0 20 0 0 20
107 0 107 0 0 107 107 0 107 0 10 97
0 0 0 0 0 0 0 0 0 0 0 0
112 0 112 0 0 112 112 0 112 0 0 112
9 0 9 0 0 9 9 0 9 0 1 8
18 0 18 0 1 17 17 0 17 24 8 33

1.8 0 1.8 0 0 1.8 1.8 0 1.8 0 0 1.8


0.7 0 0.7 0 0 0.7 0.7 0 0.7 0 0 0.7
0.7 0 0.7 0 0 0.7 0.7 0 0.7 0 0 0.7
1.6 0 1.6 0 0 1.6 1.6 0 1.6 0 0 1.6
3.8 0 3.8 0 0 3.8 3.8 0 3.8 0 0 3.8

2.1 0 2.1 0 0 2.1 2.1 0 2.1 0 0 2.1


1.4 0 1.4 0 0 1.4 1.4 0 1.4 0 0 1.4
3.2 0 3.2 0 0 3.2 3.2 0 3.2 0 0 3.2
2.9 0 2.9 0 0 2.9 2.9 0 2.9 0 0 2.9
1.7 0 1.7 0 0 1.7 1.7 0 1.7 0 0 1.7
0.3 0 0.3 0 0 0.3 0.3 0 0.3 0 0 0.3
0.9 0 0.9 0 0 0.9 0.9 0 0.9 0 0 0.9

1.5 0 1.5 0 0 1.5 1.5 0 1.5 0 0 1.5

2.8 0 2.8 0 0 2.8 2.8 0 2.8 0 0 2.8


0.4 0 0.4 0 0 0.4 0.4 0 0.4 0 0 0.4
1.4 0 1.4 0 0 1.4 1.4 0 1.4 0 0 1.4
6.7 0 6.7 0 0.2 6.5 6.5 0 6.5 0 0 6.5
5.9 0 5.9 0 0 5.9 5.9 0 5.9 0 0 5.9

0.7 0 0.7 0 0 0.7 0.7 0 0.7 0 0 0.7

1.9 0 1.9 0 0 1.9 1.9 0 1.9 0 0.1 1.8


1.7 0 1.7 0 0 1.7 1.7 0 1.7 0 0 1.7

4.7 0 4.7 0 0 4.7 4.7 0 4.7 0 2 2.7


1 0 1 0 0 1 1 0 1 0 0 1
0.9 0 0.9 0 0 0.9 0.9 0 0.9 0 0 0.9
1.6 0 1.6 0 0 1.6 1.6 0 1.6 0 0.1 1.5
5.3 0 5.3 0 0 5.3 5.3 0 5.3 0 0 5.3

7.4 0 7.4 0 0 7.4 7.4 0 7.4 0 0 7.4


1.5 0 1.5 0 0 1.5 1.5 0 1.5 0 0 1.5
2.3 0 2.3 0 0 2.3 2.3 0 2.3 0 0 2.3
5.5 0 5.5 0 0 5.5 5.5 0 5.5 0 2 3.5
0.7 0 0.7 0 0 0.7 0.7 0 0.7 0 0 0.7
1.7 0 1.7 0 0 1.7 1.7 0 1.7 0 0 1.7
1.5 0 1.5 0 0 1.5 1.5 0 1.5 0 0 1.5
1 0 1 0 0 1 1 0 1 0 0 1
4 0 4 0 0 4 4 0 4 0 0 4

1.2 0 1.2 0 0 1.2 1.2 0 1.2 0 0 1.2


1.8 0 1.8 0 0 1.8 1.8 0 1.8 0 0 1.8

1.8 0 1.8 0 0 1.8 1.8 0 1.8 0 0 1.8


0.9 0 0.9 0 0 0.9 0.9 0 0.9 0 0 0.9
2.7 0 2.7 0 0 2.7 2.7 0 2.7 0 1.7 1
0.4 0 0.4 0 0 0.4 0.4 0 0.4 0 0 0.4
1.9 0 1.9 0 0 1.9 1.9 0 1.9 0 0 1.9
2 0 2 0 0 2 2 0 2 0 1 1

0.6 0 0.6 0 0 0.6 0.6 0 0.6 0 0 0.6


0.4 0 0.4 0 0 0.4 0.4 0 0.4 0 0 0.4
1 0 1 0 0 1 1 0 1 0 0 1
0.8 0 0.8 0 0 0.8 0.8 0 0.8 0 0 0.8
0.8 0 0.8 0 0 0.8 0.8 0 0.8 0 0 0.8
1.3 0 1.3 0 0 1.3 1.3 0 1.3 0 0 1.3
0.7 0 0.7 0 0 0.7 0.7 0 0.7 0 0 0.7

0.9 0 0.9 0 0 0.9 0.9 0 0.9 0 0 0.9


0.8 0 0.8 0 0 0.8 0.8 0 0.8 0 0.2 0.6
0.7 0 0.7 0 0 0.7 0.7 0 0.7 0 0 0.7
0.4 0 0.4 0 0 0.4 0.4 0 0.4 0 0 0.4
1 0 1 0 0 1 1 0 1 0 0 1
0.9 0 0.9 0 0 0.9 0.9 0 0.9 0 0 0.9
0.5 0 0.5 0 0 0.5 0.5 0 0.5 0 0 0.5
1 0 1 0 0 1 1 0 1 0 0 1
1.4 0 1.4 0 0 1.4 1.4 0 1.4 0 0 1.4
0.9 0 0.9 0 0 0.9 0.9 0 0.9 0 0 0.9
0.9 0 0.9 0 0 0.9 0.9 0 0.9 0 0 0.9

0 0 0 0 0 0 0 0 0 0 0 0
2.2 0 2.2 0 0 2.2 2.2 0 2.2 0 0 2.2
0.9 0 0.9 0 0 0.9 0.9 0 0.9 0 0 0.9

0 0 0 0 0 0 0 0 0 0 0 0
8.2 0 8.2 0 0 8.2 8.2 0 8.2 0 0 8.2
1.5 0 1.5 0 0 1.5 1.5 0 1.5 0 0 1.5

0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 2 -2 0 2 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
10 0 10 0 0 10 10 0 10 0 0 10
12 0 12 0 0 12 12 0 12 0 0 12
14 0 14 0 5 9 9 0 5 0 0 5
5 SEPT 13 DAY 6 SEPT 14 Gr
Actual Orde Actual
Variance Beg Del End Variance Beg Del
Count r Count

1.75 0 1.75 12 0 13.8 9 -4.75 0 14

225 0 225 0 0 225 225 0 0 300

0 0 0 0 0 0 0 0 0 0
475 0 475 0 0 475 475 0 500 0
0.3 0 0.3 0 0 0.3 0.3 0 0.3 0
800 0 800 0 0 800 800 0 800 0

5 0 5 24 0 29 29 0 12 24
24 0 24 0 0 24 24 0 26 0
46 0 46 0 0 46 46 0 46 0
6 0 6 24 0 30 30 0 8 24
30 0 30 0 0 30 30 0 32 0
8 0 8 24 0 32 32 0 11 24
6 0 6 16 0 22 22 0 6 16
0 0 0 0 0 0 0 0 0 0
16 0 16 12 0 28 28 0 22 12
0 0 0 4 3 1 1 0 0 4
0 0 0 0 0 0 0 0 1 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0

52 0 52 0 0 52 52 0 21 72
4 0 4 0 0 4 4 0 0 72
36 0 36 0 5 31 31 0 45 72
0 0 0 0 0 0 0 0 10 0
87 0 87 0 7 80 80 0 9 96
20 0 20 0 0 20 20 0 20 0
97 0 97 0 0 97 97 0 39 72
0 0 0 0 0 0 0 0 0 0
112 0 112 0 0 112 112 0 112 0
8 0 8 0 0 8 8 0 9 0
33 0 33 0 0 33 33 0 18 24

1.8 0 1.8 0 0 1.8 1.8 0 1.8 0


0.7 0 0.7 0 0 0.7 0.7 0 0.7 0
0.7 0 0.7 0 0 0.7 0.7 0 0.7 0
1.6 0 1.6 0 0 1.6 1.6 0 1.6 0
3.8 0 3.8 0 0 3.8 3.8 0 3.8 0

2.1 0 2.1 0 0 2.1 2.1 0 2.1 0


1.4 0 1.4 0 0 1.4 1.4 0 1.4 0
3.2 0 3.2 0 0 3.2 3.2 0 3.2 0
2.9 0 2.9 0 0 2.9 2.9 0 2.9 0
1.7 0 1.7 0 0 1.7 1.7 0 1.7 0
0.3 0 0.3 0 0 0.3 0.3 0 0.3 0
0.9 0 0.9 0 0 0.9 0.9 0 0.9 0

1.5 0 1.5 0 0 1.5 1.5 0 1.5 0

2.8 0 2.8 0 0 2.8 2.8 0 1.8 1


0.4 0 0.4 0 0 0.4 0.4 0 0.4 0
1.4 0 1.4 0 0 1.4 1.4 0 1.4 0
6.5 0 6.5 0 3.5 3 3 0 0.7 6
5.9 0 5.9 0 0 5.9 5.9 0 5.9 0

0.7 0 0.7 0 0 0.7 0.7 0 0.7 0

1.8 0 1.8 0 0 1.8 1.8 0 1.9 0


1.7 0 1.7 0 0 1.7 1.7 0 1.7 0

2.7 0 2.7 0 0 2.7 2.7 0 2.7 2


1 0 1 0 0 1 1 0 1 0
0.9 0 0.9 0 0 0.9 0.9 0 0.9 0
1.5 0 1.5 0 0 1.5 1.5 0 1.6 0
5.3 0 5.3 0 0 5.3 5.3 0 5.3 0

7.4 0 7.4 0 0 7.4 7.4 0 7.4 0


1.5 0 1.5 0 0 1.5 1.5 0 1.5 0
2.3 0 2.3 0 0 2.3 2.3 0 2.3 0
3.5 0 3.5 0 0 3.5 3.5 0 1.5 4
0.7 0 0.7 0 0 0.7 0.7 0 0.7 0
1.7 0 1.7 0 0 1.7 1.7 0 1.7 0
1.5 0 1.5 0 0 1.5 1.5 0 1.5 0
1 0 1 0 0 1 1 0 1 0
4 0 4 0 0 4 4 0 1 3

1.2 0 1.2 0 0 1.2 1.2 0 1.2 0


1.8 0 1.8 0 0 1.8 1.8 0 1.8 0

1.8 0 1.8 0 0 1.8 1.8 0 1.8 0


0.9 0 0.9 0 0 0.9 0.9 0 0.9 0
1 0 1 5 0 6 6 0 2.8 5
0.4 0 0.4 0 0 0.4 0.4 0 0.4 0
1.9 0 1.9 0 0 1.9 1.9 0 1.9 0
1 0 1 0 0 1 1 0 2 0

0.6 0 0.6 0 0 0.6 0.6 0 0.6 0


0.4 0 0.4 0 0 0.4 0.4 0 0.4 0
1 0 1 0 0 1 1 0 1 0
0.8 0 0.8 0 0 0.8 0.8 0 0.8 0
0.8 0 0.8 0 0 0.8 0.8 0 0.8 0
1.3 0 1.3 0 0 1.3 1.3 0 1.3 0
0.7 0 0.7 0 0 0.7 0.7 0 0.7 0

0.9 0 0.9 0 0 0.9 0.9 0 0.9 0


0.6 0 0.6 0 0 0.6 0.6 0 0.8 0
0.7 0 0.7 0 0 0.7 0.7 0 0.7 0
0.4 0 0.4 0 0 0.4 0.4 0 0.4 0
1 0 1 0 0 1 1 0 1 0
0.9 0 0.9 0 0 0.9 0.9 0 0.9 0
0.5 0 0.5 0 0 0.5 0.5 0 0.5 0
1 0 1 0 0 1 1 0 1 0
1.4 0 1.4 0 0 1.4 1.4 0 1.4 0
0.9 0 0.9 0 0 0.9 0.9 0 0.9 0
0.9 0 0.9 0 0 0.9 0.9 0 0.9 0

0 0 0 0 0 0 0 0 0 0
2.2 0 2.2 0 0 2.2 2.2 0 2.2 0
0.9 0 0.9 0 0 0.9 0.9 0 0.9 0

0 0 0 5 0 5 5 0 0 5
8.2 0 8.2 0 0 8.2 8.2 0 8.2 0
1.5 0 1.5 0 0 1.5 1.5 0 1.5 0

0 0 0 0 0 0 7 7 0 0
0 0 0 0 0 0 5 5 0 0
0 0 0 0 0 0 10 10 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 1 1 0 0
0 0 0 0 0 0 1 1 0 0
0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
10 0 10 0 0 10 10 0 10 0
12 0 10 0 0 10 10 0 12 0
5 0 5 0 0 5 5 0 14 0
Grand Total per week
Actual
Order End Variance
Count

0.25 13.75 9 -4.75

75 225 225 0

0 0 0 0
25 475 475 0
0 0.3 0.3 0
0 800 800 0

7 29 29 0
2 24 24 0
0 46 46 0
2 30 30 0
2 30 30 0
3 32 32 0
0 22 22 0
0 0 0 0
6 28 28 0
3 1 1 0
1 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0

41 52 52 0
68 4 4 0
86 31 31 0
10 0 0 0
25 80 80 0
0 20 20 0
14 97 97 0
0 0 0 0
0 112 112 0
1 8 8 0
9 33 33 0

0 1.8 1.8 0
0 0.7 0.7 0
0 0.7 0.7 0
0 1.6 1.6 0
0 3.8 3.8 0

0 2.1 2.1 0
0 1.4 1.4 0
0 3.2 3.2 0
0 2.9 2.9 0
0 1.7 1.7 0
0 0.3 0.3 0
0 0.9 0.9 0

0 1.5 1.5 0

0 2.8 2.8 0
0 0.4 0.4 0
0 1.4 1.4 0
3.7 3 3 0
0 5.9 5.9 0

0 0.7 0.7 0

0.1 1.8 1.8 0


0 1.7 1.7 0

2 2.7 2.7 0
0 1 1 0
0 0.9 0.9 0
0.1 1.5 1.5 0
0 5.3 5.3 0

0 7.4 7.4 0
0 1.5 1.5 0
0 2.3 2.3 0
2 3.5 3.5 0
0 0.7 0.7 0
0 1.7 1.7 0
0 1.5 1.5 0
0 1 1 0
0 4 4 0

0 1.2 1.2 0
0 1.8 1.8 0

0 1.8 1.8 0
0 0.9 0.9 0
1.8 6 6 0
0 0.4 0.4 0
0 1.9 1.9 0
1 1 1 0

0 0.6 0.6 0
0 0.4 0.4 0
0 1 1 0
0 0.8 0.8 0
0 0.8 0.8 0
0 1.3 1.3 0
0 0.7 0.7 0

0 0.9 0.9 0
0.2 0.6 0.6 0
0 0.7 0.7 0
0 0.4 0.4 0
0 1 1 0
0 0.9 0.9 0
0 0.5 0.5 0
0 1 1 0
0 1.4 1.4 0
0 0.9 0.9 0
0 0.9 0.9 0

0 0 0 0
0 2.2 2.2 0
0 0.9 0.9 0

0 5 5 0
0 8.2 8.2 0
0 1.5 1.5 0

0 0 7 7
0 0 5 5
0 0 10 10
0 0 0 0
0 0 0 0
0 0 1 1
0 0 1 1
0 0 0 0

0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0

0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0

0 0 0 0
0 0 0 0
2 -2 0 2
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 10 10 0
0 12 10 -2
5 9 5 -4

You might also like