Monthly End Inventory
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Monthly End Inventory as PDF for free.
More details
- Words: 4,580
- Pages: 12
MONTHLY END INVENTORY AQUARIUM HOTEL From The Month of November 2007
STOCKROOM UOM
Qty
F-420 DE LUXE COFFEE kilo kilo F-421 ALTO PRIMO COFFEE F-422 DECAFFEINATED COFFEE grms kilo F-423 TURKISH COFFEE
1 1 250 1
84 84 21
6 30 0 0
kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo
1.36 1.42 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1
59 71 91.25 91.25 100 100 91.25 100 92.5 92.5 87.5 87.5 74
pc pc pc pc pc pc pc pc
1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1
Code
ITEM
Unit Equal Plus Price Beg. Del. Bal. (+)
Equal (=) Bal.
Price Total Bal
Minus Equal Request Total (-) (=) Bal.
Total Overall Total Usage Balance Total Usage Cost outside Ending
0 0 0 0
6 30 0 0
504 2520 0 0
0 1 0 0
6 29 0 0
0 0.55 0 0
6 29.55 0 0
0 0.45 0 0
0 37.8 0 0
2 0 4 4 4 4 4 4 4 4 4 4 6
0 0 0 0 0 0 0 0 0 0 0 0 0
2 0 4 4 4 4 4 4 4 4 4 4 6
118 0 365 365 400 400 365 400 370 370 350 350 444
1 0 1 1 1 1 1 1 1 1 1 1 1
1 0 3 3 3 3 3 3 3 3 3 3 5
0.6 0 0.45 1 1 1 1 1 0.95 1 1 0.95 1
1.6 0 3.45 4 4 4 4 4 3.95 4 4 3.95 6
0.4 0 0.55 0 0 0 0 0 0.05 0 0 0.05 0
23.6 0 50.19 0 0 0 0 0 4.62 0 0 4.37 0
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
144 144 144 144 144 144 144 144
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
COFFEE
POWDER F-424 CHOCOLATE POWDER F-425 WHITE CHOCO POWDER F-426 MOCHA ORIGINAL F-427 MOCHA FRENCH VANILLA F-428 MOCHA ESPRESSIMO F-429 MOCHA TOFFEE COFFEE F-430 MOCH MEXICAN SPICE F-431 MOCHA COOKIE & CREAM F-432 DOUBLE FUDGE MOCHA F-433 LATTE FREEZE F-434 VANILLA NON DAIRY F-435 CHOCOLATE TRUFFLE F-436 NIRVANA POWDER
TEA F-437 F-438 F-439 F-440 F-441 F-442 F-443 F-444
TEMPLE OF HEAVEN MONKEY KING AGED EARL GRAY BUSHMEN'S BREW CHINESE BREAKFAST SWEET AFRICAN RED MORNING RISE SWEET MEADOWS
8473
120.59
MONTHLY END INVENTORY AQUARIUM HOTEL From The Month of November 2007
STOCKROOM Code
UOM
Qty
bag bag bag bag
1 1 1 1
249 249 249 249
0 1 1 1
1.89 1.89 1.89 2.64
70 70 70 85
ml ml ml ml ml ml ml ml ml ml
750 750 750 750 750 750 750 750 750 750
ml ml ml ml ml
750 750 750 750 750
ITEM
Unit Equal Plus Price Beg. Del. Bal. (+)
Equal (=) Bal.
Price Total Bal
Minus Equal Request Total (-) (=) Bal.
Total Overall Total Usage Balance Total Usage Cost outside Ending
0 0 0 0
0 1 1 1
0 249 249 249
0 0 0 0
0 1 1 1
0 0 0 0
0 1 1 1
0 0 0 0
0 0 0 0
0 6 6 12
0 0 0 0
0 6 6 12
0 420 420 1020
0 5 5 11
0 1 1 0.95
0 6 6 11.95
0 0 0 0.05
0 0 0 4.25
30 30 30 30 30 30 30 30 30 30
1 0 1 1 1 1 0 1 0 0
0 0 0 0 0 0 0 0 0 0
1 0 1 1 1 1 0 1 0 0
30 0 30 30 30 30 0 30 0 0
0 1 1 1 0 1 0 1 1 1 1 0 1 0 0
0 0 0 0 0 0 0 0 0 0
1 0 0.5 0.9 1 1 0 1 0 0
1 0 0.5 0.9 1 1 0 1 0 0
0 0 0.5 0.1 0 0 0 0 0 0
0 0 15 3 0 0 0 0 0 0
30 30 30 30 30
1 1 1 1 1
0 0 0 0 0
1 1 1 1 1
30 30 30 30 30
1 1 1 1 1
0 0 0 0 0
1 1 1 1 1
1 1 1 1 1
0 0 0 0 0
0 0 0 0 0
FLOWERING TEA F-445 F-446 F-447 F-448
MIDNIGHT PEONY EMERALD SUN FLOWER JEWEL STARLIGHT ROSE
SAUCES
liter liter liter F-452 Molinari Choco Sauce liter F-449 DARK CHOCOLATE SAUCE F-450 CARAMEL SAUCE F-451 W. CHOCO SAUCE
SYRUP F-452 Hazelnut Syrup F-453 French Vanilla Syrup F-454 Vanilla Syrup F-455 Caramel Syrup F-456 Irish Cream Syrup F-457 White Chocolate Syrup F-458 Cinnamon Syrup F-459 Crème de Cacao Syrup F-460 Coconut Syrup F-461 Ginger Syrup
ICE TEA SYRUP F-463 F-464 F-465 F-466 F-467
RASPBERRY ICE TEA BLACKBERRY ICE TEA STRAWBERRY ICE TEA MANGO ICE TEA PEACH ICE TEA
2937
22.25
MONTHLY END INVENTORY AQUARIUM HOTEL From The Month of November 2007
STOCKROOM Code
UOM
Qty
liter liter liter liter liter
1.89 1.89 1.89 1.89 1.89
150 150 150 150 150
1 1 1 1 1
gal liter pc
1 1 1
6 5 5
0 0 0
liter pack pack box box box
0 1 1 0 0 0
0 15 13 0
0 1 1 0
ITEM
Unit Equal Plus Price Beg. Del. Bal. (+)
Equal (=) Bal.
Price Total Bal
0 0 0 0 0
1 1 1 1 1
150 150 150 150 150
0 0
0 0 0 0 1 1 0
Minus Equal Request Total (-) (=) Bal.
Total Overall Total Usage Balance Total Usage Cost outside Ending
SMOOTIES F-468 F-469 F-470 F-471 F-472
RASPBERRY Smootie MIXEDBERRY Smootie PEACH Smootie MANGO Smootie STRAWBERRY Smootie
1 1 1 1 1
0 0 0 0 0
1 1 1 0.8 0.75
1 1 1 0.8 0.75
0 0 0 0.2 0.25
0 0 0 30 37.5
0 0 0
0 0
0 0 0
0 0
0 0 0
0 0 0
0 0 0
0 15 13 0
0 1 1 0
0 0 0 0
0 0 0 0
0 0 0 0
0 1 1 0
0 15 13 0
MILK F-491 F-492 F-493
FRESH MILK LONG LIFE CONDENSED MILK
OTHERS F-473 F-474 F-475 F-476 F-477 F-478
WHIP CREAM OREO Hershey's Mini Choco SOFTDRINKS IN CAN PERRIER SODA WATER
0 0
778
95.5
MONTHLY END INVENTORY AQUARIUM HOTEL From The Month of DECEMBER 2007
STOCKROOM UOM
Qty
F-420 DE LUXE COFFEE kilo kilo F-421 ALTO PRIMO COFFEE F-422 DECAFFEINATED COFFEE grms kilo F-423 TURKISH COFFEE
1 1 250 1
84 84 21
6 29.55 0 0
1.36 1.42 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1
59 71 91.25 91.25 100 100 91.25 100 92.5 92.5 87.5 87.5 74
1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1
Code
ITEM
Unit Equal Plus Price Beg. Del. Bal. (+)
Equal (=) Bal.
Price Total Bal
Minus Equal Request Total (-) (=) Bal.
Total Overall Total Usage Balance Total Usage Cost outside Ending
0 0 0 0
6 29.55 0 0
504 2482.2 0 0
0 1.55 0 0
6 28 0 0
0 0.8 0 0
6 28.8 0 0
0 0.75 0 0
0 63 0 0
1.6 0 3.45 4 4 4 4 4 3.95 4 4 3.95 6
0 0 0 0 0 0 0 0 0 0 0 0 0
1.6 0 3.45 4 4 4 4 4 3.95 4 4 3.95 6
94.4 0 314.81 365 400 400 365 400 365.38 370 350 345.63 444
1.6 0 0.45 1 1 1 1 1 0.95 1 1 0.95 1
0 0 3 3 3 3 3 3 3 3 3 3 5
0.7 0 0.05 0.9 1 0.25 0.95 0.95 0.25 0.2 1 0.85 1
0.7 0 3.05 3.9 4 3.25 3.95 3.95 3.25 3.2 4 3.85 6
0.9 0 0.4 0.1 0 0.75 0.05 0.05 0.7 0.8 0 0.1 0
53.1 0 36.5 9.13 0 75 4.56 5 64.75 74 0 8.75 0
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
144 144 144 144 144 144 144 144
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
COFFEE
POWDER F-424 CHOCOLATE POWDER F-425 WHITE CHOCO POWDER F-426 MOCHA ORIGINAL F-427 MOCHA FRENCH VANILLA F-428 MOCHA ESPRESSIMO F-429 MOCHA TOFFEE COFFEE F-430 MOCH MEXICAN SPICE F-431 MOCHA COOKIE & CREAM F-432 DOUBLE FUDGE MOCHA F-433 LATTE FREEZE F-434 VANILLA NON DAIRY F-435 CHOCOLATE TRUFFLE F-436 NIRVANA POWDER
TEA F-437 F-438 F-439 F-440 F-441 F-442 F-443 F-444
TEMPLE OF HEAVEN MONKEY KING AGED EARL GRAY BUSHMEN'S BREW CHINESE BREAKFAST SWEET AFRICAN RED MORNING RISE SWEET MEADOWS
kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo KILO pc pc pc pc pc pc pc pc
8352.41
393.79
MONTHLY END INVENTORY AQUARIUM HOTEL From The Month of DECEMBER 2007
STOCKROOM Code
UOM
Qty
bag bag bag bag
1 1 1 1
249 249 249 249
0 1 1 1
1.89 1.89 1.89 2.64
70 70 70 85
ml ml ml ml ml ml ml ml ml ml
750 750 750 750 750 750 750 750 750 750
ml ml ml ml ml
750 750 750 750 750
ITEM
Unit Equal Plus Price Beg. Del. Bal. (+)
Equal (=) Bal.
Price Total Bal
Minus Equal Request Total (-) (=) Bal.
Total Overall Total Usage Balance Total Usage Cost outside Ending
0 0 0 0
0 1 1 1
0 249 249 249
0 0 0 0
0 1 1 1
0 0 0 0
0 1 1 1
0 0 0 0
0 0 0 0
0 6 6 11.95
0 0 0 0
0 6 6 11.95
0 420 420 1015.75
0 1 1 1.95
0 5 5 10
0 1 1 0.95
0 6 6 10.95
0 0 0 1
0 0 0 85
30 30 30 30 30 30 30 30 30 30
1 0 0.5 0.9 1 1 0 1 0 0
0 0 0 0 0 0 0 0 0 0
1 0 0.5 0.9 1 1 0 1 0 0
30 0 15 27 30 30 0 30 0 0
1 0 0.5 0.9 1 1 0 1 0 0
0 0 0 0 0 0 0 0 0 0
0.8 0 0 0.8 1 1 0 0.95 0 0
0.8 0 0 0.8 1 1 0 0.95 0 0
0.2 0 0.5 0.1 0 0 0 0.05 0 0
6 0 15 3 0 0 0 1.5 0 0
30 30 30 30 30
1 1 1 1 1
0 0 0 0 0
1 1 1 1 1
30 30 30 30 30
1 1 1 1 1
0 0 0 0 0
0.95 0.95 0.95 0.95 0.95
0.95 0.95 0.95 0.95 0.95
0.05 0.05 0.05 0.05 0.05
1.5 1.5 1.5 1.5 1.5
FLOWERING TEA F-445 F-446 F-447 F-448
MIDNIGHT PEONY EMERALD SUN FLOWER JEWEL STARLIGHT ROSE
SAUCES
liter liter liter F-452 Molinari Choco Sauce liter F-449 DARK CHOCOLATE SAUCE F-450 CARAMEL SAUCE F-451 W. CHOCO SAUCE
SYRUP F-452 Hazelnut Syrup F-453 French Vanilla Syrup F-454 Vanilla Syrup F-455 Caramel Syrup F-456 Irish Cream Syrup F-457 White Chocolate Syrup F-458 Cinnamon Syrup F-459 Crème de Cacao Syrup F-460 Coconut Syrup F-461 Ginger Syrup
ICE TEA SYRUP F-463 F-464 F-465 F-466 F-467
RASPBERRY ICE TEA BLACKBERRY ICE TEA STRAWBERRY ICE TEA MANGO ICE TEA PEACH ICE TEA
2914.75
118
MONTHLY END INVENTORY AQUARIUM HOTEL From The Month of DECEMBER 2007
STOCKROOM Code
UOM
Qty
liter liter liter liter liter
1.89 1.89 1.89 1.89 1.89
150 150 150 150 150
1 1 1 0.8 0.75
gal liter pc
1 1 1
6 5 5
liter pack pack btl btl
0 1 1 0 0
0 15 13 13 16
ITEM
Unit Equal Plus Price Beg. Del. Bal. (+)
Equal (=) Bal.
Price Total Bal
Minus Equal Request Total (-) (=) Bal.
Total Overall Total Usage Balance Total Usage Cost outside Ending
0 0 0 0 0
1 1 1 0.8 0.75
150 150 150 120 112.5
1 1 1 0.8 0.75
0 0 0 0 0
1 1 1 0.7 0.45
1 1 1 0.7 0.45
0 0 0 0.1 0.3
0 0 0 15 45
30 12 0
0 0 0
30 12 0
180 60 0
30 6 0
0 0 0
2 0 0
2 0 0
28 12 0
168 60 0
0 1 1 11 15
0 0 0 0 0
0 1 1 11 15
0 15 13 143 240
0 1 1 11 15
0 0 0 0 0
0 0.8 1.5 1
0 0 0.8 1.5 1
0 1 0.2 9.5 14
0 15 2.6 123.5 224
SMOOTIES F-468 F-469 F-470 F-471 F-472
RASPBERRY Smootie MIXEDBERRY Smootie PEACH Smootie MANGO Smootie STRAWBERRY Smootie
MILK F-491 F-492 F-493
FRESH MILK LONG LIFE CONDENSED MILK
OTHERS F-473 F-474 F-475 F-476 F-477 F-478
WHIP CREAM OREO Hershey's Mini Choco NESCAFE COFFEE MATE
1333.5
653.1
MONTHLY END INVENTORY AQUARIUM HOTEL From The Month of JANUARY 2008
STOCKROOM UOM
Qty
F-420 DE LUXE COFFEE kilo kilo F-421 ALTO PRIMO COFFEE F-422 DECAFFEINATED COFFEE grms kilo F-423 TURKISH COFFEE
1 1 250 1
84 84 21
6 28.8 0 0
1.36 1.42 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1
59 71 91.25 91.25 100 100 91.25 100 92.5 92.5 87.5 87.5 74
1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1
Code
ITEM
Unit Equal Plus Price Beg. Del. Bal. (+)
Equal (=) Bal.
Price Total Bal
Minus Equal Total Overall Total Usage Request Total Balance Total Usage Cost (-) (=) Bal. outside Ending
0 0 0 0
6 28.8 0 0
504 2419.2 0 0
0 2.8 0 0
6 26 0 0
0 0.6 0 0
6 26.6 0 0
0 2.2 0 0
0 184.8 0 0
0.7 0 3.05 3.9 4 3.25 3.95 3.95 3.25 3.2 4 3.85 6
0 0 0 0 0 0 0 0 0 0 0 0 0
0.7 0 3.05 3.9 4 3.25 3.95 3.95 3.25 3.2 4 3.85 6
41.3 0 278.31 355.88 400 325 360.44 395 300.63 296 350 336.88 444
0.7 0 0.05 0.9 1 0.25 0.95 0.9 0.25 1 0.85 0.95
0 0 3 3 3 3 3 3.05 3 3.2 3 3 5.05
0.3 0 0 0.9 1 0.25 0.75 0.9 0.05 0.95 1 0.3 0.95
0.3 0 3 3.9 4 3.25 3.75 3.95 3.05 4.15 4 3.3 6
0.4 0 0.05 0 0 0 0.2 0 0.2 -0.95 0 0.55 0
23.6 0 4.56 0 0 0 18.25 0 18.5 -87.88 0 48.13 0
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
144 144 144 144 144 144 144 144
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
COFFEE
POWDER F-424 CHOCOLATE POWDER F-425 WHITE CHOCO POWDER F-426 MOCHA ORIGINAL F-427 MOCHA FRENCH VANILLA F-428 MOCHA ESPRESSIMO F-429 MOCHA TOFFEE COFFEE F-430 MOCH MEXICAN SPICE F-431 MOCHA COOKIE & CREAM F-432 DOUBLE FUDGE MOCHA F-433 LATTE FREEZE F-434 VANILLA NON DAIRY F-435 CHOCOLATE TRUFFLE F-436 NIRVANA POWDER
TEA F-437 F-438 F-439 F-440 F-441 F-442 F-443 F-444
TEMPLE OF HEAVEN MONKEY KING AGED EARL GRAY BUSHMEN'S BREW CHINESE BREAKFAST SWEET AFRICAN RED MORNING RISE SWEET MEADOWS
kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo KILO pc pc pc pc pc pc pc pc
7958.63
209.96
MONTHLY END INVENTORY AQUARIUM HOTEL From The Month of JANUARY 2008
STOCKROOM Code
UOM
Qty
bag bag bag bag
1 1 1 1
249 249 249 249
0 1 1 1
1.89 1.89 1.89 2.64
70 70 70 85
ml ml ml ml ml ml ml ml ml ml
750 750 750 750 750 750 750 750 750 750
ml ml ml ml ml
750 750 750 750 750
ITEM
Unit Equal Plus Price Beg. Del. Bal. (+)
Equal (=) Bal.
Price Total Bal
Minus Equal Total Overall Total Usage Request Total Balance Total Usage Cost (-) (=) Bal. outside Ending
0 0 0 0
0 1 1 1
0 249 249 249
0 0 0 0
0 1 1 1
0 0 0 0
0 1 1 1
0 0 0 0
0 0 0 0
0 6 6 10.95
0 0 0 0
0 420 420 930.75
0 1 1 1.95
0 5 5 9
0 1 0.75 1
0 6 5.75 10
0 0 0.25 0.95
0 0 17.5 80.75
30 30 30 30 30 30 30 30 30 30
0.8 0 0 0.8 1 1 0 0.95 0 0
0 0 0 0 0 0 0 0 0 0
0 6 6 10.95 0 0.8 0 0 0.8 1 1 0 0.95 0 0
24 0 0 24 30 30 0 28.5 0 0
0.8 0 0 0.8 1 1 0 0.95 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0.7 0.85 0.8 0 0.7 0 0
0.6 0 0 0.7 0.85 0.8 0 0.7 0 0
0.2 0 0 0.1 0.15 0.2 0 0.25 0 0
6 0 0 3 4.5 6 0 7.5 0 0
30 30 30 30 30
0.95 0.95 0.95 0.95 0.95
0 0 0 0 0
0.95 0.95 0.95 0.95 0.95
28.5 28.5 28.5 28.5 28.5
0.95 0.95 0.95 0.95 0.95
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0.95 0.95 0.95 0.95 0.95
28.5 28.5 28.5 28.5 28.5
FLOWERING TEA F-445 F-446 F-447 F-448
MIDNIGHT PEONY EMERALD SUN FLOWER JEWEL STARLIGHT ROSE
SAUCES
liter liter liter F-452 Molinari Choco Sauce liter F-449 DARK CHOCOLATE SAUCE F-450 CARAMEL SAUCE F-451 W. CHOCO SAUCE
SYRUP F-452 Hazelnut Syrup F-453 French Vanilla Syrup F-454 Vanilla Syrup F-455 Caramel Syrup F-456 Irish Cream Syrup F-457 White Chocolate Syrup F-458 Cinnamon Syrup F-459 Crème de Cacao Syrup F-460 Coconut Syrup F-461 Ginger Syrup
ICE TEA SYRUP F-463 F-464 F-465 F-466 F-467
RASPBERRY ICE TEA BLACKBERRY ICE TEA STRAWBERRY ICE TEA MANGO ICE TEA PEACH ICE TEA
2796.75
267.75
MONTHLY END INVENTORY AQUARIUM HOTEL From The Month of JANUARY 2008
STOCKROOM Code
UOM
Qty
liter liter liter liter liter
1.89 1.89 1.89 1.89 1.89
150 150 150 150 150
1 1 1 0.7 0.45
gal liter pc
1 1 1
7 5 5
liter pack pack btl btl
0 1 1 1 1
0 15 13 26 14
ITEM
Unit Equal Plus Price Beg. Del. Bal. (+)
Equal (=) Bal.
Price Total Bal
Minus Equal Total Overall Total Usage Request Total Balance Total Usage Cost (-) (=) Bal. outside Ending
0 0 0 0 0
1 1 1 0.7 0.45
150 150 150 105 67.5
1 1 1 0.7 0.45
0 0 0 0 0
1 1 0.9 0.6 0.4
1 1 0.9 0.6 0.4
0 0 0.1 0.1 0.05
0 0 15 15 7.5
16 4 0
0 0 0
16 4 0
112 20 0
16 4 0
0 0 0
0 0 0
0 0 0
16 4 0
112 20 0
0 0 0 12 22
0 0 0 0 0
0 0 0 12 22
0 0 0 312 308
0 0 0 12 22
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 12 22
0 0 0 312 308
SMOOTIES F-468 F-469 F-470 F-471 F-472
RASPBERRY Smootie MIXEDBERRY Smootie PEACH Smootie MANGO Smootie STRAWBERRY Smootie
MILK F-491 F-492 F-493
FRESH MILK LONG LIFE CONDENSED MILK
OTHERS F-473 F-474 F-475 F-476 F-477 F-478
WHIP CREAM OREO Hershey's Mini Choco NESCAFE COFFEE MATE
1374.5
789.5
MONTHLY END INVENTORY AQUARIUM HOTEL From The Month of Febuary 2008
STOCKROOM UOM
Qty
F-420 DE LUXE COFFEE kilo kilo F-421 ALTO PRIMO COFFEE F-422 DECAFFEINATED COFFEE grms kilo F-423 TURKISH COFFEE
1 1 250 1
84 84 21
6 26.6 0 0
1.36 1.42 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1
59 71 91.25 91.25 100 100 91.25 100 92.5 92.5 87.5 87.5 74
1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1
Code
ITEM
Unit Equal Plus Price Beg. Del. Bal. (+)
Equal (=) Bal.
Price Total Bal
Minus Equal Total Overall Total Usage Request Total Balance Total Usage Cost (-) (=) Bal. outside Ending
0 0 0 0
6 26.6 0 0
504 2234.4 0 0
0 2.6 0 0
6 24 0 0
0 1.3 0 0
6 25.3 0 0
0 1.3 0 0
0 109.2 0 0
0.03 0 3 3.9 4 3.25 3.75 3.95 3.05 4.15 4 3.3 6
0 0 0 0 0 0 0 0 0 0 0 0 0
0.03 0 3 3.9 4 3.25 3.75 3.95 3.05 4.15 4 3.3 6
1.77 0 273.75 355.88 400 325 342.19 395 282.13 383.88 350 288.75 444
0.03 0 1 0.9 1 0.25 0.75 0.95 0.05 0.15 1 0.3 1
0 0 2 3 3 3 3 3 3 4 3 3 5
0 0
0 0 2 3 3 3 3 3 3 4 3 3 5
0.03 0 1 0.9 1 0.25 0.75 0.95 0.05 0.15 1 0.3 1
1.77 0 91.25 82.13 100 25 68.44 95 4.62 13.88 87.5 26.25 74
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
144 144 144 144 144 144 144 144
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
144 144 144 144 144 144 144 144
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
COFFEE
POWDER F-424 CHOCOLATE POWDER F-425 WHITE CHOCO POWDER F-426 MOCHA ORIGINAL F-427 MOCHA FRENCH VANILLA F-428 MOCHA ESPRESSIMO F-429 MOCHA TOFFEE COFFEE F-430 MOCH MEXICAN SPICE F-431 MOCHA COOKIE & CREAM F-432 DOUBLE FUDGE MOCHA F-433 LATTE FREEZE F-434 VANILLA NON DAIRY F-435 CHOCOLATE TRUFFLE F-436 NIRVANA POWDER
TEA F-437 F-438 F-439 F-440 F-441 F-442 F-443 F-444
TEMPLE OF HEAVEN MONKEY KING AGED EARL GRAY BUSHMEN'S BREW CHINESE BREAKFAST SWEET AFRICAN RED MORNING RISE SWEET MEADOWS
kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo KILO pc pc pc pc pc pc pc pc
7732.73
0
779.03
MONTHLY END INVENTORY AQUARIUM HOTEL From The Month of Febuary 2008
STOCKROOM Code
UOM
Qty
bag bag bag bag
1 1 1 1
249 249 249 249
0 249 249 249
1.89 1.89 1.89 2.64
70 70 70 85
ml ml ml ml ml ml ml ml ml ml
750 750 750 750 750 750 750 750 750 750
ml ml ml ml ml
750 750 750 750 750
ITEM
Unit Equal Plus Price Beg. Del. Bal. (+)
Equal (=) Bal.
Price Total Bal
Minus Equal Total Overall Total Usage Request Total Balance Total Usage Cost (-) (=) Bal. outside Ending
0 0 0 0
0 249 249 249
0 62001 62001 62001
0 0 0 0
0 0 0 0
0 0 0 0
0 249 249 249
0 62001 62001 62001
0 6 5.75 10
0 0 0 0
0 420 402.5 850
0 1 0.75 1
0 5 5 9
0 5 5 9
0 1 0.75 1
0 70 52.5 85
30 30 30 30 30 30 30 30 30 30
0.6 0 0 0.2 0.85 0.8 0 0.7 0 0
0 0 0 0 0 0 0 0 0 0
0 6 5.75 10 0 0.6 0 0 0.2 0.85 0.8 0 0.7 0 0
18 0 0 6 25.5 24 0 21 0 0
0.6 0 0 0.2 0.85 0.8 0 0.7 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0.6 0 0 0.2 0.85 0.8 0 0.7 0 0
18 0 0 6 25.5 24 0 21 0 0
30 30 30 30 30
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
FLOWERING TEA F-445 F-446 F-447 F-448
MIDNIGHT PEONY EMERALD SUN FLOWER JEWEL STARLIGHT ROSE
SAUCES
liter liter liter F-452 Molinari Choco Sauce liter F-449 DARK CHOCOLATE SAUCE F-450 CARAMEL SAUCE F-451 W. CHOCO SAUCE
SYRUP F-452 Hazelnut Syrup F-453 French Vanilla Syrup F-454 Vanilla Syrup F-455 Caramel Syrup F-456 Irish Cream Syrup F-457 White Chocolate Syrup F-458 Cinnamon Syrup F-459 Crème de Cacao Syrup F-460 Coconut Syrup F-461 Ginger Syrup
ICE TEA SYRUP F-463 F-464 F-465 F-466 F-467
RASPBERRY ICE TEA BLACKBERRY ICE TEA STRAWBERRY ICE TEA MANGO ICE TEA PEACH ICE TEA
187770
186305
MONTHLY END INVENTORY AQUARIUM HOTEL From The Month of Febuary 2008
STOCKROOM Code
UOM
Qty
liter liter liter liter liter
1.89 1.89 1.89 1.89 1.89
150 150 150 150 150
1 1 0.9 0.6 0.4
gal liter pc
1 1 1
7 5 5
liter pack pack btl btl
0 1 1 1 1
0 15 13 26 14
ITEM
Unit Equal Plus Price Beg. Del. Bal. (+)
Equal (=) Bal.
Price Total Bal
0 0 0 0 0
1 1 0.9 0.6 0.4
150 150 135 90 60
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
Minus Equal Total Overall Total Usage Request Total Balance Total Usage Cost (-) (=) Bal. outside Ending
SMOOTIES F-468 F-469 F-470 F-471 F-472
RASPBERRY Smootie MIXEDBERRY Smootie PEACH Smootie MANGO Smootie STRAWBERRY Smootie
1 1 0.9 0.6 0.4
0 0 0 0 0
0.95 0.95 0.9 0.15 0.3
0.95 0.95 0.9 0.15 0.3
0.05 0.05 0 0.45 0.1
7.5 7.5 0 67.5 15
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
MILK F-491 F-492 F-493
FRESH MILK LONG LIFE CONDENSED MILK
OTHERS F-473 F-474 F-475 F-476 F-477 F-478
WHIP CREAM OREO Hershey's Mini Choco NESCAFE COFFEE MATE
585
97.5
STOCKROOM UOM
Qty
F-420 DE LUXE COFFEE kilo kilo F-421 ALTO PRIMO COFFEE F-422 DECAFFEINATED COFFEE grms kilo F-423 TURKISH COFFEE
1 1 250 1
84 84 21
6 30 0 0
kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo
1.36 1.42 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1
59 71 91.25 91.25 100 100 91.25 100 92.5 92.5 87.5 87.5 74
pc pc pc pc pc pc pc pc
1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1
Code
ITEM
Unit Equal Plus Price Beg. Del. Bal. (+)
Equal (=) Bal.
Price Total Bal
Minus Equal Request Total (-) (=) Bal.
Total Overall Total Usage Balance Total Usage Cost outside Ending
0 0 0 0
6 30 0 0
504 2520 0 0
0 1 0 0
6 29 0 0
0 0.55 0 0
6 29.55 0 0
0 0.45 0 0
0 37.8 0 0
2 0 4 4 4 4 4 4 4 4 4 4 6
0 0 0 0 0 0 0 0 0 0 0 0 0
2 0 4 4 4 4 4 4 4 4 4 4 6
118 0 365 365 400 400 365 400 370 370 350 350 444
1 0 1 1 1 1 1 1 1 1 1 1 1
1 0 3 3 3 3 3 3 3 3 3 3 5
0.6 0 0.45 1 1 1 1 1 0.95 1 1 0.95 1
1.6 0 3.45 4 4 4 4 4 3.95 4 4 3.95 6
0.4 0 0.55 0 0 0 0 0 0.05 0 0 0.05 0
23.6 0 50.19 0 0 0 0 0 4.62 0 0 4.37 0
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
144 144 144 144 144 144 144 144
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
COFFEE
POWDER F-424 CHOCOLATE POWDER F-425 WHITE CHOCO POWDER F-426 MOCHA ORIGINAL F-427 MOCHA FRENCH VANILLA F-428 MOCHA ESPRESSIMO F-429 MOCHA TOFFEE COFFEE F-430 MOCH MEXICAN SPICE F-431 MOCHA COOKIE & CREAM F-432 DOUBLE FUDGE MOCHA F-433 LATTE FREEZE F-434 VANILLA NON DAIRY F-435 CHOCOLATE TRUFFLE F-436 NIRVANA POWDER
TEA F-437 F-438 F-439 F-440 F-441 F-442 F-443 F-444
TEMPLE OF HEAVEN MONKEY KING AGED EARL GRAY BUSHMEN'S BREW CHINESE BREAKFAST SWEET AFRICAN RED MORNING RISE SWEET MEADOWS
8473
120.59
MONTHLY END INVENTORY AQUARIUM HOTEL From The Month of November 2007
STOCKROOM Code
UOM
Qty
bag bag bag bag
1 1 1 1
249 249 249 249
0 1 1 1
1.89 1.89 1.89 2.64
70 70 70 85
ml ml ml ml ml ml ml ml ml ml
750 750 750 750 750 750 750 750 750 750
ml ml ml ml ml
750 750 750 750 750
ITEM
Unit Equal Plus Price Beg. Del. Bal. (+)
Equal (=) Bal.
Price Total Bal
Minus Equal Request Total (-) (=) Bal.
Total Overall Total Usage Balance Total Usage Cost outside Ending
0 0 0 0
0 1 1 1
0 249 249 249
0 0 0 0
0 1 1 1
0 0 0 0
0 1 1 1
0 0 0 0
0 0 0 0
0 6 6 12
0 0 0 0
0 6 6 12
0 420 420 1020
0 5 5 11
0 1 1 0.95
0 6 6 11.95
0 0 0 0.05
0 0 0 4.25
30 30 30 30 30 30 30 30 30 30
1 0 1 1 1 1 0 1 0 0
0 0 0 0 0 0 0 0 0 0
1 0 1 1 1 1 0 1 0 0
30 0 30 30 30 30 0 30 0 0
0 1 1 1 0 1 0 1 1 1 1 0 1 0 0
0 0 0 0 0 0 0 0 0 0
1 0 0.5 0.9 1 1 0 1 0 0
1 0 0.5 0.9 1 1 0 1 0 0
0 0 0.5 0.1 0 0 0 0 0 0
0 0 15 3 0 0 0 0 0 0
30 30 30 30 30
1 1 1 1 1
0 0 0 0 0
1 1 1 1 1
30 30 30 30 30
1 1 1 1 1
0 0 0 0 0
1 1 1 1 1
1 1 1 1 1
0 0 0 0 0
0 0 0 0 0
FLOWERING TEA F-445 F-446 F-447 F-448
MIDNIGHT PEONY EMERALD SUN FLOWER JEWEL STARLIGHT ROSE
SAUCES
liter liter liter F-452 Molinari Choco Sauce liter F-449 DARK CHOCOLATE SAUCE F-450 CARAMEL SAUCE F-451 W. CHOCO SAUCE
SYRUP F-452 Hazelnut Syrup F-453 French Vanilla Syrup F-454 Vanilla Syrup F-455 Caramel Syrup F-456 Irish Cream Syrup F-457 White Chocolate Syrup F-458 Cinnamon Syrup F-459 Crème de Cacao Syrup F-460 Coconut Syrup F-461 Ginger Syrup
ICE TEA SYRUP F-463 F-464 F-465 F-466 F-467
RASPBERRY ICE TEA BLACKBERRY ICE TEA STRAWBERRY ICE TEA MANGO ICE TEA PEACH ICE TEA
2937
22.25
MONTHLY END INVENTORY AQUARIUM HOTEL From The Month of November 2007
STOCKROOM Code
UOM
Qty
liter liter liter liter liter
1.89 1.89 1.89 1.89 1.89
150 150 150 150 150
1 1 1 1 1
gal liter pc
1 1 1
6 5 5
0 0 0
liter pack pack box box box
0 1 1 0 0 0
0 15 13 0
0 1 1 0
ITEM
Unit Equal Plus Price Beg. Del. Bal. (+)
Equal (=) Bal.
Price Total Bal
0 0 0 0 0
1 1 1 1 1
150 150 150 150 150
0 0
0 0 0 0 1 1 0
Minus Equal Request Total (-) (=) Bal.
Total Overall Total Usage Balance Total Usage Cost outside Ending
SMOOTIES F-468 F-469 F-470 F-471 F-472
RASPBERRY Smootie MIXEDBERRY Smootie PEACH Smootie MANGO Smootie STRAWBERRY Smootie
1 1 1 1 1
0 0 0 0 0
1 1 1 0.8 0.75
1 1 1 0.8 0.75
0 0 0 0.2 0.25
0 0 0 30 37.5
0 0 0
0 0
0 0 0
0 0
0 0 0
0 0 0
0 0 0
0 15 13 0
0 1 1 0
0 0 0 0
0 0 0 0
0 0 0 0
0 1 1 0
0 15 13 0
MILK F-491 F-492 F-493
FRESH MILK LONG LIFE CONDENSED MILK
OTHERS F-473 F-474 F-475 F-476 F-477 F-478
WHIP CREAM OREO Hershey's Mini Choco SOFTDRINKS IN CAN PERRIER SODA WATER
0 0
778
95.5
MONTHLY END INVENTORY AQUARIUM HOTEL From The Month of DECEMBER 2007
STOCKROOM UOM
Qty
F-420 DE LUXE COFFEE kilo kilo F-421 ALTO PRIMO COFFEE F-422 DECAFFEINATED COFFEE grms kilo F-423 TURKISH COFFEE
1 1 250 1
84 84 21
6 29.55 0 0
1.36 1.42 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1
59 71 91.25 91.25 100 100 91.25 100 92.5 92.5 87.5 87.5 74
1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1
Code
ITEM
Unit Equal Plus Price Beg. Del. Bal. (+)
Equal (=) Bal.
Price Total Bal
Minus Equal Request Total (-) (=) Bal.
Total Overall Total Usage Balance Total Usage Cost outside Ending
0 0 0 0
6 29.55 0 0
504 2482.2 0 0
0 1.55 0 0
6 28 0 0
0 0.8 0 0
6 28.8 0 0
0 0.75 0 0
0 63 0 0
1.6 0 3.45 4 4 4 4 4 3.95 4 4 3.95 6
0 0 0 0 0 0 0 0 0 0 0 0 0
1.6 0 3.45 4 4 4 4 4 3.95 4 4 3.95 6
94.4 0 314.81 365 400 400 365 400 365.38 370 350 345.63 444
1.6 0 0.45 1 1 1 1 1 0.95 1 1 0.95 1
0 0 3 3 3 3 3 3 3 3 3 3 5
0.7 0 0.05 0.9 1 0.25 0.95 0.95 0.25 0.2 1 0.85 1
0.7 0 3.05 3.9 4 3.25 3.95 3.95 3.25 3.2 4 3.85 6
0.9 0 0.4 0.1 0 0.75 0.05 0.05 0.7 0.8 0 0.1 0
53.1 0 36.5 9.13 0 75 4.56 5 64.75 74 0 8.75 0
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
144 144 144 144 144 144 144 144
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
COFFEE
POWDER F-424 CHOCOLATE POWDER F-425 WHITE CHOCO POWDER F-426 MOCHA ORIGINAL F-427 MOCHA FRENCH VANILLA F-428 MOCHA ESPRESSIMO F-429 MOCHA TOFFEE COFFEE F-430 MOCH MEXICAN SPICE F-431 MOCHA COOKIE & CREAM F-432 DOUBLE FUDGE MOCHA F-433 LATTE FREEZE F-434 VANILLA NON DAIRY F-435 CHOCOLATE TRUFFLE F-436 NIRVANA POWDER
TEA F-437 F-438 F-439 F-440 F-441 F-442 F-443 F-444
TEMPLE OF HEAVEN MONKEY KING AGED EARL GRAY BUSHMEN'S BREW CHINESE BREAKFAST SWEET AFRICAN RED MORNING RISE SWEET MEADOWS
kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo KILO pc pc pc pc pc pc pc pc
8352.41
393.79
MONTHLY END INVENTORY AQUARIUM HOTEL From The Month of DECEMBER 2007
STOCKROOM Code
UOM
Qty
bag bag bag bag
1 1 1 1
249 249 249 249
0 1 1 1
1.89 1.89 1.89 2.64
70 70 70 85
ml ml ml ml ml ml ml ml ml ml
750 750 750 750 750 750 750 750 750 750
ml ml ml ml ml
750 750 750 750 750
ITEM
Unit Equal Plus Price Beg. Del. Bal. (+)
Equal (=) Bal.
Price Total Bal
Minus Equal Request Total (-) (=) Bal.
Total Overall Total Usage Balance Total Usage Cost outside Ending
0 0 0 0
0 1 1 1
0 249 249 249
0 0 0 0
0 1 1 1
0 0 0 0
0 1 1 1
0 0 0 0
0 0 0 0
0 6 6 11.95
0 0 0 0
0 6 6 11.95
0 420 420 1015.75
0 1 1 1.95
0 5 5 10
0 1 1 0.95
0 6 6 10.95
0 0 0 1
0 0 0 85
30 30 30 30 30 30 30 30 30 30
1 0 0.5 0.9 1 1 0 1 0 0
0 0 0 0 0 0 0 0 0 0
1 0 0.5 0.9 1 1 0 1 0 0
30 0 15 27 30 30 0 30 0 0
1 0 0.5 0.9 1 1 0 1 0 0
0 0 0 0 0 0 0 0 0 0
0.8 0 0 0.8 1 1 0 0.95 0 0
0.8 0 0 0.8 1 1 0 0.95 0 0
0.2 0 0.5 0.1 0 0 0 0.05 0 0
6 0 15 3 0 0 0 1.5 0 0
30 30 30 30 30
1 1 1 1 1
0 0 0 0 0
1 1 1 1 1
30 30 30 30 30
1 1 1 1 1
0 0 0 0 0
0.95 0.95 0.95 0.95 0.95
0.95 0.95 0.95 0.95 0.95
0.05 0.05 0.05 0.05 0.05
1.5 1.5 1.5 1.5 1.5
FLOWERING TEA F-445 F-446 F-447 F-448
MIDNIGHT PEONY EMERALD SUN FLOWER JEWEL STARLIGHT ROSE
SAUCES
liter liter liter F-452 Molinari Choco Sauce liter F-449 DARK CHOCOLATE SAUCE F-450 CARAMEL SAUCE F-451 W. CHOCO SAUCE
SYRUP F-452 Hazelnut Syrup F-453 French Vanilla Syrup F-454 Vanilla Syrup F-455 Caramel Syrup F-456 Irish Cream Syrup F-457 White Chocolate Syrup F-458 Cinnamon Syrup F-459 Crème de Cacao Syrup F-460 Coconut Syrup F-461 Ginger Syrup
ICE TEA SYRUP F-463 F-464 F-465 F-466 F-467
RASPBERRY ICE TEA BLACKBERRY ICE TEA STRAWBERRY ICE TEA MANGO ICE TEA PEACH ICE TEA
2914.75
118
MONTHLY END INVENTORY AQUARIUM HOTEL From The Month of DECEMBER 2007
STOCKROOM Code
UOM
Qty
liter liter liter liter liter
1.89 1.89 1.89 1.89 1.89
150 150 150 150 150
1 1 1 0.8 0.75
gal liter pc
1 1 1
6 5 5
liter pack pack btl btl
0 1 1 0 0
0 15 13 13 16
ITEM
Unit Equal Plus Price Beg. Del. Bal. (+)
Equal (=) Bal.
Price Total Bal
Minus Equal Request Total (-) (=) Bal.
Total Overall Total Usage Balance Total Usage Cost outside Ending
0 0 0 0 0
1 1 1 0.8 0.75
150 150 150 120 112.5
1 1 1 0.8 0.75
0 0 0 0 0
1 1 1 0.7 0.45
1 1 1 0.7 0.45
0 0 0 0.1 0.3
0 0 0 15 45
30 12 0
0 0 0
30 12 0
180 60 0
30 6 0
0 0 0
2 0 0
2 0 0
28 12 0
168 60 0
0 1 1 11 15
0 0 0 0 0
0 1 1 11 15
0 15 13 143 240
0 1 1 11 15
0 0 0 0 0
0 0.8 1.5 1
0 0 0.8 1.5 1
0 1 0.2 9.5 14
0 15 2.6 123.5 224
SMOOTIES F-468 F-469 F-470 F-471 F-472
RASPBERRY Smootie MIXEDBERRY Smootie PEACH Smootie MANGO Smootie STRAWBERRY Smootie
MILK F-491 F-492 F-493
FRESH MILK LONG LIFE CONDENSED MILK
OTHERS F-473 F-474 F-475 F-476 F-477 F-478
WHIP CREAM OREO Hershey's Mini Choco NESCAFE COFFEE MATE
1333.5
653.1
MONTHLY END INVENTORY AQUARIUM HOTEL From The Month of JANUARY 2008
STOCKROOM UOM
Qty
F-420 DE LUXE COFFEE kilo kilo F-421 ALTO PRIMO COFFEE F-422 DECAFFEINATED COFFEE grms kilo F-423 TURKISH COFFEE
1 1 250 1
84 84 21
6 28.8 0 0
1.36 1.42 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1
59 71 91.25 91.25 100 100 91.25 100 92.5 92.5 87.5 87.5 74
1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1
Code
ITEM
Unit Equal Plus Price Beg. Del. Bal. (+)
Equal (=) Bal.
Price Total Bal
Minus Equal Total Overall Total Usage Request Total Balance Total Usage Cost (-) (=) Bal. outside Ending
0 0 0 0
6 28.8 0 0
504 2419.2 0 0
0 2.8 0 0
6 26 0 0
0 0.6 0 0
6 26.6 0 0
0 2.2 0 0
0 184.8 0 0
0.7 0 3.05 3.9 4 3.25 3.95 3.95 3.25 3.2 4 3.85 6
0 0 0 0 0 0 0 0 0 0 0 0 0
0.7 0 3.05 3.9 4 3.25 3.95 3.95 3.25 3.2 4 3.85 6
41.3 0 278.31 355.88 400 325 360.44 395 300.63 296 350 336.88 444
0.7 0 0.05 0.9 1 0.25 0.95 0.9 0.25 1 0.85 0.95
0 0 3 3 3 3 3 3.05 3 3.2 3 3 5.05
0.3 0 0 0.9 1 0.25 0.75 0.9 0.05 0.95 1 0.3 0.95
0.3 0 3 3.9 4 3.25 3.75 3.95 3.05 4.15 4 3.3 6
0.4 0 0.05 0 0 0 0.2 0 0.2 -0.95 0 0.55 0
23.6 0 4.56 0 0 0 18.25 0 18.5 -87.88 0 48.13 0
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
144 144 144 144 144 144 144 144
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
COFFEE
POWDER F-424 CHOCOLATE POWDER F-425 WHITE CHOCO POWDER F-426 MOCHA ORIGINAL F-427 MOCHA FRENCH VANILLA F-428 MOCHA ESPRESSIMO F-429 MOCHA TOFFEE COFFEE F-430 MOCH MEXICAN SPICE F-431 MOCHA COOKIE & CREAM F-432 DOUBLE FUDGE MOCHA F-433 LATTE FREEZE F-434 VANILLA NON DAIRY F-435 CHOCOLATE TRUFFLE F-436 NIRVANA POWDER
TEA F-437 F-438 F-439 F-440 F-441 F-442 F-443 F-444
TEMPLE OF HEAVEN MONKEY KING AGED EARL GRAY BUSHMEN'S BREW CHINESE BREAKFAST SWEET AFRICAN RED MORNING RISE SWEET MEADOWS
kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo KILO pc pc pc pc pc pc pc pc
7958.63
209.96
MONTHLY END INVENTORY AQUARIUM HOTEL From The Month of JANUARY 2008
STOCKROOM Code
UOM
Qty
bag bag bag bag
1 1 1 1
249 249 249 249
0 1 1 1
1.89 1.89 1.89 2.64
70 70 70 85
ml ml ml ml ml ml ml ml ml ml
750 750 750 750 750 750 750 750 750 750
ml ml ml ml ml
750 750 750 750 750
ITEM
Unit Equal Plus Price Beg. Del. Bal. (+)
Equal (=) Bal.
Price Total Bal
Minus Equal Total Overall Total Usage Request Total Balance Total Usage Cost (-) (=) Bal. outside Ending
0 0 0 0
0 1 1 1
0 249 249 249
0 0 0 0
0 1 1 1
0 0 0 0
0 1 1 1
0 0 0 0
0 0 0 0
0 6 6 10.95
0 0 0 0
0 420 420 930.75
0 1 1 1.95
0 5 5 9
0 1 0.75 1
0 6 5.75 10
0 0 0.25 0.95
0 0 17.5 80.75
30 30 30 30 30 30 30 30 30 30
0.8 0 0 0.8 1 1 0 0.95 0 0
0 0 0 0 0 0 0 0 0 0
0 6 6 10.95 0 0.8 0 0 0.8 1 1 0 0.95 0 0
24 0 0 24 30 30 0 28.5 0 0
0.8 0 0 0.8 1 1 0 0.95 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0.7 0.85 0.8 0 0.7 0 0
0.6 0 0 0.7 0.85 0.8 0 0.7 0 0
0.2 0 0 0.1 0.15 0.2 0 0.25 0 0
6 0 0 3 4.5 6 0 7.5 0 0
30 30 30 30 30
0.95 0.95 0.95 0.95 0.95
0 0 0 0 0
0.95 0.95 0.95 0.95 0.95
28.5 28.5 28.5 28.5 28.5
0.95 0.95 0.95 0.95 0.95
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0.95 0.95 0.95 0.95 0.95
28.5 28.5 28.5 28.5 28.5
FLOWERING TEA F-445 F-446 F-447 F-448
MIDNIGHT PEONY EMERALD SUN FLOWER JEWEL STARLIGHT ROSE
SAUCES
liter liter liter F-452 Molinari Choco Sauce liter F-449 DARK CHOCOLATE SAUCE F-450 CARAMEL SAUCE F-451 W. CHOCO SAUCE
SYRUP F-452 Hazelnut Syrup F-453 French Vanilla Syrup F-454 Vanilla Syrup F-455 Caramel Syrup F-456 Irish Cream Syrup F-457 White Chocolate Syrup F-458 Cinnamon Syrup F-459 Crème de Cacao Syrup F-460 Coconut Syrup F-461 Ginger Syrup
ICE TEA SYRUP F-463 F-464 F-465 F-466 F-467
RASPBERRY ICE TEA BLACKBERRY ICE TEA STRAWBERRY ICE TEA MANGO ICE TEA PEACH ICE TEA
2796.75
267.75
MONTHLY END INVENTORY AQUARIUM HOTEL From The Month of JANUARY 2008
STOCKROOM Code
UOM
Qty
liter liter liter liter liter
1.89 1.89 1.89 1.89 1.89
150 150 150 150 150
1 1 1 0.7 0.45
gal liter pc
1 1 1
7 5 5
liter pack pack btl btl
0 1 1 1 1
0 15 13 26 14
ITEM
Unit Equal Plus Price Beg. Del. Bal. (+)
Equal (=) Bal.
Price Total Bal
Minus Equal Total Overall Total Usage Request Total Balance Total Usage Cost (-) (=) Bal. outside Ending
0 0 0 0 0
1 1 1 0.7 0.45
150 150 150 105 67.5
1 1 1 0.7 0.45
0 0 0 0 0
1 1 0.9 0.6 0.4
1 1 0.9 0.6 0.4
0 0 0.1 0.1 0.05
0 0 15 15 7.5
16 4 0
0 0 0
16 4 0
112 20 0
16 4 0
0 0 0
0 0 0
0 0 0
16 4 0
112 20 0
0 0 0 12 22
0 0 0 0 0
0 0 0 12 22
0 0 0 312 308
0 0 0 12 22
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 12 22
0 0 0 312 308
SMOOTIES F-468 F-469 F-470 F-471 F-472
RASPBERRY Smootie MIXEDBERRY Smootie PEACH Smootie MANGO Smootie STRAWBERRY Smootie
MILK F-491 F-492 F-493
FRESH MILK LONG LIFE CONDENSED MILK
OTHERS F-473 F-474 F-475 F-476 F-477 F-478
WHIP CREAM OREO Hershey's Mini Choco NESCAFE COFFEE MATE
1374.5
789.5
MONTHLY END INVENTORY AQUARIUM HOTEL From The Month of Febuary 2008
STOCKROOM UOM
Qty
F-420 DE LUXE COFFEE kilo kilo F-421 ALTO PRIMO COFFEE F-422 DECAFFEINATED COFFEE grms kilo F-423 TURKISH COFFEE
1 1 250 1
84 84 21
6 26.6 0 0
1.36 1.42 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1.36 1
59 71 91.25 91.25 100 100 91.25 100 92.5 92.5 87.5 87.5 74
1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1
Code
ITEM
Unit Equal Plus Price Beg. Del. Bal. (+)
Equal (=) Bal.
Price Total Bal
Minus Equal Total Overall Total Usage Request Total Balance Total Usage Cost (-) (=) Bal. outside Ending
0 0 0 0
6 26.6 0 0
504 2234.4 0 0
0 2.6 0 0
6 24 0 0
0 1.3 0 0
6 25.3 0 0
0 1.3 0 0
0 109.2 0 0
0.03 0 3 3.9 4 3.25 3.75 3.95 3.05 4.15 4 3.3 6
0 0 0 0 0 0 0 0 0 0 0 0 0
0.03 0 3 3.9 4 3.25 3.75 3.95 3.05 4.15 4 3.3 6
1.77 0 273.75 355.88 400 325 342.19 395 282.13 383.88 350 288.75 444
0.03 0 1 0.9 1 0.25 0.75 0.95 0.05 0.15 1 0.3 1
0 0 2 3 3 3 3 3 3 4 3 3 5
0 0
0 0 2 3 3 3 3 3 3 4 3 3 5
0.03 0 1 0.9 1 0.25 0.75 0.95 0.05 0.15 1 0.3 1
1.77 0 91.25 82.13 100 25 68.44 95 4.62 13.88 87.5 26.25 74
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
144 144 144 144 144 144 144 144
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
144 144 144 144 144 144 144 144
144 144 144 144 144 144 144 144
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
COFFEE
POWDER F-424 CHOCOLATE POWDER F-425 WHITE CHOCO POWDER F-426 MOCHA ORIGINAL F-427 MOCHA FRENCH VANILLA F-428 MOCHA ESPRESSIMO F-429 MOCHA TOFFEE COFFEE F-430 MOCH MEXICAN SPICE F-431 MOCHA COOKIE & CREAM F-432 DOUBLE FUDGE MOCHA F-433 LATTE FREEZE F-434 VANILLA NON DAIRY F-435 CHOCOLATE TRUFFLE F-436 NIRVANA POWDER
TEA F-437 F-438 F-439 F-440 F-441 F-442 F-443 F-444
TEMPLE OF HEAVEN MONKEY KING AGED EARL GRAY BUSHMEN'S BREW CHINESE BREAKFAST SWEET AFRICAN RED MORNING RISE SWEET MEADOWS
kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo kilo KILO pc pc pc pc pc pc pc pc
7732.73
0
779.03
MONTHLY END INVENTORY AQUARIUM HOTEL From The Month of Febuary 2008
STOCKROOM Code
UOM
Qty
bag bag bag bag
1 1 1 1
249 249 249 249
0 249 249 249
1.89 1.89 1.89 2.64
70 70 70 85
ml ml ml ml ml ml ml ml ml ml
750 750 750 750 750 750 750 750 750 750
ml ml ml ml ml
750 750 750 750 750
ITEM
Unit Equal Plus Price Beg. Del. Bal. (+)
Equal (=) Bal.
Price Total Bal
Minus Equal Total Overall Total Usage Request Total Balance Total Usage Cost (-) (=) Bal. outside Ending
0 0 0 0
0 249 249 249
0 62001 62001 62001
0 0 0 0
0 0 0 0
0 0 0 0
0 249 249 249
0 62001 62001 62001
0 6 5.75 10
0 0 0 0
0 420 402.5 850
0 1 0.75 1
0 5 5 9
0 5 5 9
0 1 0.75 1
0 70 52.5 85
30 30 30 30 30 30 30 30 30 30
0.6 0 0 0.2 0.85 0.8 0 0.7 0 0
0 0 0 0 0 0 0 0 0 0
0 6 5.75 10 0 0.6 0 0 0.2 0.85 0.8 0 0.7 0 0
18 0 0 6 25.5 24 0 21 0 0
0.6 0 0 0.2 0.85 0.8 0 0.7 0 0
0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0
0.6 0 0 0.2 0.85 0.8 0 0.7 0 0
18 0 0 6 25.5 24 0 21 0 0
30 30 30 30 30
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
FLOWERING TEA F-445 F-446 F-447 F-448
MIDNIGHT PEONY EMERALD SUN FLOWER JEWEL STARLIGHT ROSE
SAUCES
liter liter liter F-452 Molinari Choco Sauce liter F-449 DARK CHOCOLATE SAUCE F-450 CARAMEL SAUCE F-451 W. CHOCO SAUCE
SYRUP F-452 Hazelnut Syrup F-453 French Vanilla Syrup F-454 Vanilla Syrup F-455 Caramel Syrup F-456 Irish Cream Syrup F-457 White Chocolate Syrup F-458 Cinnamon Syrup F-459 Crème de Cacao Syrup F-460 Coconut Syrup F-461 Ginger Syrup
ICE TEA SYRUP F-463 F-464 F-465 F-466 F-467
RASPBERRY ICE TEA BLACKBERRY ICE TEA STRAWBERRY ICE TEA MANGO ICE TEA PEACH ICE TEA
187770
186305
MONTHLY END INVENTORY AQUARIUM HOTEL From The Month of Febuary 2008
STOCKROOM Code
UOM
Qty
liter liter liter liter liter
1.89 1.89 1.89 1.89 1.89
150 150 150 150 150
1 1 0.9 0.6 0.4
gal liter pc
1 1 1
7 5 5
liter pack pack btl btl
0 1 1 1 1
0 15 13 26 14
ITEM
Unit Equal Plus Price Beg. Del. Bal. (+)
Equal (=) Bal.
Price Total Bal
0 0 0 0 0
1 1 0.9 0.6 0.4
150 150 135 90 60
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
Minus Equal Total Overall Total Usage Request Total Balance Total Usage Cost (-) (=) Bal. outside Ending
SMOOTIES F-468 F-469 F-470 F-471 F-472
RASPBERRY Smootie MIXEDBERRY Smootie PEACH Smootie MANGO Smootie STRAWBERRY Smootie
1 1 0.9 0.6 0.4
0 0 0 0 0
0.95 0.95 0.9 0.15 0.3
0.95 0.95 0.9 0.15 0.3
0.05 0.05 0 0.45 0.1
7.5 7.5 0 67.5 15
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
MILK F-491 F-492 F-493
FRESH MILK LONG LIFE CONDENSED MILK
OTHERS F-473 F-474 F-475 F-476 F-477 F-478
WHIP CREAM OREO Hershey's Mini Choco NESCAFE COFFEE MATE
585
97.5
Related Documents
Monthly End Inventory
November 2019 10
Monthly Inventory Report
November 2019 22
Moth End Inventory March
October 2019 20
Inventory
November 2019 61
Inventory
November 2019 62