0% found this document useful (0 votes)
216 views20 pages

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

1. This document shows the inventory of various food and beverage items for a cafe over a period from September 9-14. 2. It tracks the beginning quantity, items delivered, items used/sold, and ending quantity each day for over 130 separate items including coffee, syrups, sodas, beers, liquors, wines, herbs, cups/lids, and other supplies. 3. Many items showed no change in inventory levels during this period, while a few like Smirnoff Mule saw an increase from deliveries and no items used/sold.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
216 views20 pages

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

1. This document shows the inventory of various food and beverage items for a cafe over a period from September 9-14. 2. It tracks the beginning quantity, items delivered, items used/sold, and ending quantity each day for over 130 separate items including coffee, syrups, sodas, beers, liquors, wines, herbs, cups/lids, and other supplies. 3. Many items showed no change in inventory levels during this period, while a few like Smirnoff Mule saw an increase from deliveries and no items used/sold.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 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