TRISAKTI HOTEL & RESTAURANT JAKARTA
MONTHLY FOOD COST FOOD SALES A
Gross Food Sales
B
Adjustments and Discounts
C
Net Food Sales
A-B
COST OF FOOD SOLD Opening Inventories D
Store Room
E
Kitchen Total
F
G
Food Purchase
H
Total Food Available
D+E
F+G
CLOSING INVENTORY I
Store Room
J
Kitchen
K L
Total Closing COST OF FOOD CONSUMED
I+J H-K
COST OF ADJUSTMENT M
Food to Bar
N
Employees Meal
O
Other Credit
P
Total Food Credit
Q
Beverage to food
R
COST OF FOOD SOLD
M+N+O
L-P+Q
S
Food Cost %
R : C X 100
T
Food Cost % ( as per daily = 34 % )
MTD Daily FC
U
Difference
S-T
TRISAKTI HOTEL & RESTAURANT JAKARTA
DAILY FOOD COST A
B
Date Store Room Issue
C
D
Direct
Transfer
E
Purchase from Bar
F
Total Gross Employees Cost
Meal
G
H
Transfer
Total
fr Kitchen
Credit
Today
F+G
E+H
B+C+D 1
750,000
2
3,350,000
3
1,870,000
400,000
4
4,850,000
650,000
5
1,987,890
500,100
6
-
350,000 -
-
7
5,100,980
340,000
8
1,760,000
300,000
9
3,040,000
210,000
10
3,100,000
-
100,000
1,200,000
130,000
3,350,000
240,000
210,000
2,480,000
230,000
5,730,000
-
120,000 230,120 200,000 -
-
I NET COST To date
J REVENUE Today
To date
K COST % Today
Todate
130,000
1,330,000
1,330,000
6,900,000
6,900,000
19.28
19.28
300,000
540,000
3,890,000
5,220,000
12,250,000
19,150,000
31.76
27.26
150,000
150,000
300,000
2,780,000
8,000,000
6,000,000
25,150,000
46.33
31.81
190,000
230,000
420,000
6,150,000
14,150,000
13,250,000
38,400,000
46.42
36.85
2,487,990
210,000
200,000
410,000
2,897,990
17,047,990
7,980,320
46,380,320
36.31
36.76
120,000
140,000
140,000
260,000
17,307,990
3,450,000
49,830,320
7.54
34.73
-
5,671,100
160,000
160,000
5,831,100
23,139,090
12,210,000
62,040,320
47.76
37.30
2,060,000
350,000
400,000
750,000
2,810,000
25,949,090
4,000,000
66,040,320
70.25
39.29
3,450,000
240,000
480,000
720,000
4,170,000
30,119,090
7,230,000
73,270,320
57.68
41.11
3,100,000
240,000
705,000
945,000
4,045,000
34,164,090
8,500,000
81,770,320
47.59
41.78
4,515,000
34,164,090
29,649,090
81,770,320
# TANGGAL 01 MARET Ada catatan distore room requestition untuk kebutuhan food consumed sebesar
41.78
# TANGGAL 01 MARET Ada catatan distore room requestition untuk kebutuhan food consumed sebesar
