Scribd
Upload
85 views20 pages

F4 Hotel Room and Guest Schedule

The document summarizes guest information and food orders for an hotel and restaurant. It includes a list of room types and rates, guest details like names and addresses, check in and check out information for 5 guests, and food orders for breakfast, lunch and dinner. The food order section lists the menu items, prices and quantities ordered by 3 guests on a given date.

Uploaded by

Meiss Ly
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as ODS, PDF, TXT or read online on Scribd
85 views20 pages

F4 Hotel Room and Guest Schedule

The document summarizes guest information and food orders for an hotel and restaurant. It includes a list of room types and rates, guest details like names and addresses, check in and check out information for 5 guests, and food orders for breakfast, lunch and dinner. The food order section lists the menu items, prices and quantities ordered by 3 guests on a given date.

Uploaded by

Meiss Ly
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as ODS, PDF, TXT or read online on Scribd

Sheet1

“F4 HOTEL AND RESTAURANT”


LEGEND:
Type of Room Amount Code
Standard Php1,500.00 STD
Deluxe Php5,000.00 DL
Executive Php7,500.00 EX
Pent House Php12,000.00 PH

GUEST ID FNAME LNAME PHONE ADDRESS


002345B Jane Medusa 9495857690 San Francisco

001425K Lyka Gairanod 9493242572 Manila

001324H Vicente Luna 9124536785 QC

00675D Fred Mallapre 9123436476 Singapore

004523Z Zian Chua 9103425257 Texas

Page 1
Sheet1

“F4 HOTE
Registration
COUNTRY PASTPORT NUMBER JOB TYPE OF PAYMENT
CANADA Ave987 ENGINEER Credit Card

PHILIPPINES Zbe078 OFW Credit Card

PHILIPPINES CONGRESSMAN Credit Card

SINGAPORE Ave987 DOCTOR Credit Card

MEXICO Def578 PAINTER Cash

Page 2
Sheet1

“F4 HOTEL AND RESTAURANT”


Registration Form Guest Data( Check In)
GUEST/S RESERVED FOR DATE OF CHECK IN TIME OF ARRIVAL
1 08/09/14 07:45:00 AM

1 08/09/14 08:00:00 AM

1 08/09/14 08:15:00 AM

1 08/09/14 08:30:00 AM

1 08/09/14 09:00:00 AM

Page 3
Sheet1

ROOM NUMBER ROOM TYPE DATE OF DEPARTURE


Rm.0034G STD 08/10/14

Rm.0053F2 STD 08/10/14

Rm.0021G DL 08/10/14

Rm.0002G EX 08/10/14

Rm.0025G PH 08/10/14

Page 4
Sheet1

TIME OF DEPARTURE DAY/S OCCUPPIED COST


06:00:00 AM 1 Php1,500.00

06:30:00 AM 1 Php1,500.00

07:00:00 AM 1 Php5,000.00

07:10:00 AM 1 Php7,500.00

07:45:00 AM 1 Php12,000.00

Page 5
Sheet2

Guest ID
Room No.
F4 HOTEL & RESTAURANT Server of the Day:
Date Order
Time Serve:
Breakfast
Lunch
F & B DEPARTMENT Dinner
MENU (BREAKFAST) CODE PRICE Quantity/ Order
Caramel coffee C1 Php50.00 0
Choco C2 Php50.00 0
Hot coffee C3 Php95.00 0
Hot tea C4 Php95.00 0
Special lomi C5 Php67.00 0
Fried rice C6 Php38.00 0
Hotdog C7 Php27.00 0
Footlong C8 Php34.00 0
Longanisa C9 Php45.00 0
SUBTOTAL
MENU'S FOR LUNCH
Pork steak w/ rice F1 Php150.00 1
Shirmp tempura w/ rice F2 Php140.00 0
Roasted chicken w/ rice F3 Php150.00 0
Chicken curry w/ rice F4 Php155.00 1
Salmon steak w/ rice F5 Php180.00 0
Beef tederlion w/ rice F6 Php200.00 0
Boiled Cabbage F7 Php120.00 0
Chopsuey F8 Php120.00 0
Add. Rice A1 Php25.00 2
SUBTOTAL
DESSERT
Chocolate mousse D1 Php175.00 1
Frozen yogurt D2 Php150.00 0
Black forest cake D3 Php130.00 0
Brownies D4 Php125.00 0
Pandan Cake D5 Php125.00 0
Chocolate cake D6 Php120.00 1
SUBTOTAL
MENU'S FOR DINNER
Pork steak w/ rice F1 Php150.00 1
Shirmp tempura w/ rice F2 Php140.00 0
Roasted chicken w/ rice F3 Php150.00 0
Chicken curry w/ rice F4 Php155.00 1
Salmon steak w/ rice F5 Php180.00 0
Beef tederlion w/ rice F6 Php200.00 0
Boiled Cabbage F7 Php120.00 0
Chopsuey F8 Php120.00 0

Page 6
Sheet2

Add. Rice A1 Php25.00 2


SUBTOTAL
DESSERT
Chocolate mousse D1 Php175.00 1
Frozen yogurt D2 Php150.00 0
Black forest cake D3 Php130.00 0
Brownies D4 Php125.00 0
Pandan Cake D5 Php125.00 0
Chocolate cake D6 Php120.00 1
SUBTOTAL
TOTALCOST

Page 7
Sheet2

002345B Guest ID 001425K Guest ID 001324H


Rm.0034G Room No. Rm.0053F2 Room No. Rm.0021G
Lito Tan Server of the Day: Alex Adra Server of the Day: Luo Tsu
08/09/14 Date Order 08/09/14 Date Order 08/09/14
Time Serve: Time Serve:
Breakfast 08:00:00 AM Breakfast
11:30:00 AM Lunch Lunch
07:30:00 PM Dinner 07:30:00 PM Dinner 07:30:00 PM
Cost Quantity/ Order Cost Quantity/ Order Cost
Php0.00 1 Php50.00 0 Php0.00
Php0.00 1 Php50.00 0 Php0.00
Php0.00 0 Php0.00 0 Php0.00
Php0.00 0 Php0.00 0 Php0.00
Php0.00 0 Php0.00 0 Php0.00
Php0.00 0 Php0.00 0 Php0.00
Php0.00 1 Php27.00 0 Php0.00
Php0.00 2 Php68.00 0 Php0.00
Php0.00 0 Php0.00 0 Php0.00
Php0.00 195 0

Php150.00 0 Php0.00 0 Php0.00


Php0.00 0 Php0.00 0 Php0.00
Php0.00 0 Php0.00 0 Php0.00
Php155.00 0 Php0.00 0 Php0.00
Php0.00 0 Php0.00 0 Php0.00
Php0.00 0 Php0.00 0 Php0.00
Php0.00 0 Php0.00 0 Php0.00
Php0.00 0 Php0.00 0 Php0.00
Php50.00 0 Php0.00 0 Php0.00
355 0 0

Php175.00 0 Php0.00 0 Php0.00


Php0.00 0 Php0.00 0 Php0.00
Php0.00 0 Php0.00 0 Php0.00
Php0.00 0 Php0.00 0 Php0.00
Php0.00 0 Php0.00 0 Php0.00
Php120.00 0 Php0.00 0 Php0.00
295 0 0

Php150.00 1 Php150.00 0 Php0.00


Php0.00 0 Php0.00 1 Php140.00
Php0.00 0 Php0.00 1 Php150.00
Php155.00 1 Php155.00 0 Php0.00
Php0.00 0 Php0.00 1 Php180.00
Php0.00 0 Php0.00 0 Php0.00
Php0.00 0 Php0.00 0 Php0.00
Php0.00 0 Php0.00 0 Php0.00

Page 8
Sheet2

Php50.00 2 Php50.00 3 Php75.00


355 355 545

Php175.00 1 Php175.00 0 Php0.00


Php0.00 0 Php0.00 0 Php0.00
Php0.00 0 Php0.00 1 Php130.00
Php0.00 0 Php0.00 1 Php125.00
Php0.00 0 Php0.00 0 Php0.00
Php120.00 1 Php120.00 0 Php0.00
295 295 255
1300 845 800

Page 9
Sheet2

Guest ID 00675D Guest ID 004523Z


Room No. Rm.0002G Room No. Rm.0025G
Server of the Day: Drew Kula Server of the Day: Lito Tan
Date Order 08/09/14 Date Order 08/09/14
Time Serve: Time Serve:
Breakfast 07:30:00 AM Breakfast 07:30:00 AM
Lunch 11:30:00 AM Lunch 11:30:00 AM
Dinner 07:30:00 PM Dinner 07:30:00 PM
Quantity/ Order Cost Quantity/ Order Cost
1 Php50.00 0 Php0.00
1 Php50.00 1 Php50.00
0 Php0.00 0 Php0.00
0 Php0.00 1 Php95.00
2 Php134.00 2 Php134.00
0 Php0.00 0 Php0.00
2 Php54.00 3 Php81.00
0 Php0.00 1 Php34.00
0 Php0.00 0 Php0.00
288 394

1 Php150.00 0 Php0.00
0 Php0.00 1 Php140.00
0 Php0.00 0 Php0.00
1 Php155.00 0 Php0.00
0 Php0.00 0 Php0.00
0 Php0.00 2 Php400.00
0 Php0.00 1 Php120.00
0 Php0.00 1 Php120.00
2 Php50.00 0 Php0.00
355 780

1 Php175.00 0 Php0.00
0 Php0.00 0 Php0.00
0 Php0.00 1 Php130.00
0 Php0.00 0 Php0.00
0 Php0.00 1 Php125.00
1 Php120.00 0 Php0.00
295 255

1 Php150.00 0 Php0.00
0 Php0.00 0 Php0.00
0 Php0.00 1 Php150.00
1 Php155.00 0 Php0.00
0 Php0.00 2 Php360.00
0 Php0.00 1 Php200.00
0 Php0.00 0 Php0.00
0 Php0.00 0 Php0.00

Page 10
Sheet2

2 Php50.00 1 Php25.00
355 735

1 Php175.00 0 Php0.00
0 Php0.00 1 Php150.00
0 Php0.00 1 Php130.00
0 Php0.00 0 Php0.00
0 Php0.00 0 Php0.00
1 Php120.00 0 Php0.00
295 280
1588 2444

Page 11
Sheet3

HOUSEKEEPING DEPARTMENT DATA:


Type of Room Code
Standard STD
Deluxe DL
Executive EX
Pent House PH

SERVICES & EXTRA CHARGES:


LEGEND: AMOUNT
Extra Person per Head Php700.00
Extra Shoe Shine Php50.00
Lost of Key/ Vincard Php700.00
Extra Bed Php100.00
Extra Loundry Service per Piece Php50.00
Lost of Valuable Amenities per Item Php100.00

F4 HOTEL & RESTAURANT


HOUSEKEEPING DEPARTMENT
Name of Guest: Jane Medusa
RA: Luke Tan
Date: 08/10/14
Guest ID: 002345B
Room Number: Rm.0034G
Room Type: STD

SERVICES & EXTRA/s (Code) Charges


EPH 2
ESS 0
LKV 0
EB 2
ELSP 3
LVAI 1
TOTAL
Name of Guest: Lyka Gairanod
RA: Luke Tan
Date: 08/10/14
Guest ID: 001425K
Room Number: Rm.0053F2
Room Type: STD

Page 12
Sheet3

SERVICES & EXTRA/s Code Charges


EPH 2
ESS 0
LKV 0
EB 2
ELSP 3
LVAI 4
TOTAL
Name of Guest: Vicente Luna
RA: Luke Tan
Date: 08/10/14
Guest ID: 001324H
Room Number: Rm. 00021G
Room Type: EX

SERVICES & EXTRA/s Code Charges


EPH 2
ESS 0
LKV 0
EB 2
ELSP 5
LVAI 2
TOTAL
Name of Guest: Fred Mallapre
RA: Luke Tan
Date: 08/10/14
Guest ID: 00675D
Room Number: Rm.0002G
Room Type: DL

SERVICES & EXTRA/s Code Charges


EPH 2
ESS 0
LKV 0
EB 2
ELSP 5
LVAI 2
TOTAL
Name of Guest: Zian Chua
RA: Luke Tan
Date: 08/10/14
Guest ID: 00453Z
Room Number: Rm.0025G
Room Type: PH

SERVICES & EXTRA/s Code Charges

Page 13
Sheet3

EPH 2
ESS 0
LKV 0
EB 2
ELSP 4
LVAI 2
TOTAL

Page 14
Sheet3

F4 HOTEL & RESTAURANT

Furniture & Fixture


TV,Electric Fan, DVD, Telephone,6 pcs. Hanger
TV, Air-conditioned, Telephone,6 pcs. Hanger
Flat screen TV, mini-refrigerator,air conditioned, Telephone, 6 pcs. Hanger
Mini-bar, Flat screen TV, Refrigerator, Air conditioned,sofa set, wi-fi,jacuzzi, Telephone,6 pcs. Hanger

CODE
EPH
ESS
LKV
EB
ELSP
LVAI

F4 HOTEL & RESTAURANT


HOUSEKEEPING DEPARTMENT
sa

Amount
Php1,400.00
Php0.00
Php0.00
Php200.00
Php150.00
Php100.00
1850

nod

Page 15
Sheet3

Amount
Php1,400.00
Php0.00
Php0.00
Php200.00
Php150.00
Php400.00
2150

na

Amount
Php1,400.00
Php0.00
Php0.00
Php200.00
Php250.00
Php200.00
2050

pre

Amount
Php1,400.00
Php0.00
Php0.00
Php200.00
Php250.00
Php200.00
2050

Amount

Page 16
Sheet3

Php1,400.00
Php0.00
Php0.00
Php200.00
Php200.00
Php200.00
2000

Page 17
Sheet3

& RESTAURANT

Amenities
shampoo, conditioner, soap, hand towel, foot towel, bath towel, lotion
shampoo, conditioner, soap, hand towel, foot towel, bath towel, lotion
shampoo, conditioner, soap, hand towel, foot towel, bath towel, lotion
slipper, shampoo, conditioner, soap, hand towel, foot towel, bath towel, lotion,toohbrush, toothpaste

Page 18
Sheet3

Type of Bed Total Amount Per Room


Single Php1,500.00
Single Php5,000.00
king size Php7,500.00
queen size Php12,000.00

Page 19
Sheet4

F4 HOTEL & RESTAURANT


NAME OF GUEST
Number of Guest
Type of Room
Number of Day/s Occupied
Transactions
Cost of Room 1500
Charges(F&B Dep't) 1300
Charges(Housekeeping Dep't) 1850
TOTAL PAYMENT 4650

Page 20

You might also like