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