30 DAYS TO 30-4-2008
APRIL MONTH END
P U R C H A S E S
DIRECT
STORE
MEAT
01-Apr-08
0.00
0.00
0.00
02-Apr-08
285,232.00
75,503.00
1,197,356.00
03-Apr-08
164,241.00
89,972.48
55,220.00
04-Apr-08
332,082.76
145,442.00
100,781.00
07-Apr-08
169,290.00
263,360.88
194,250.00
08-Apr-08
153,491.00
354,199.00
196,950.00
09-Apr-08
142,389.00
438,735.00
1,081,187.50
10-Apr-08
101,152.00
2,455.00
56,050.00
05-Apr-08
06-Apr-08
289,201.00
595,078.00
176,450.00
14-Apr-08
162,880.25
30,800.00
85,120.00
15-Apr-08
137,109.00
101,000.00
505,010.00
16-Apr-08
0.00
0.00
0.00
17-Apr-08
303,140.30
439,812.00
879,846.50
11-Apr-08
12-Apr-08
13-Apr-08
18-Apr-08
19-Apr-08
20-Apr-08
21-Apr-08
22-Apr-08
23-Apr-08
24-Apr-08
25-Apr-08
26-Apr-08
27-Apr-08
28-Apr-08
29-Apr-08
30-Apr-08
2,240,208.31
2,536,357.36
4,528,221.00
7,064,578.36 STORES PURCHASES
TOTAL
TOTAL
TODAY
TODATE
TOTAL I S S U E S
JUICE TO BAR
25,102.08
STORE
0.00
0.00
111,984.74
1,558,091.00
1,558,091.00
43,928.64
148,136.26
309,433.48
1,867,524.48
18,826.56
163,392.21
578,305.76
2,445,830.24
16,734.72
213,389.00
0.00
2,445,830.24
0.00
2,445,830.24
626,900.88
3,072,731.12
25,102.08
145,820.97
704,640.00
3,777,371.12
10,459.20
113,957.48
1,662,311.50
5,439,682.62
10,459.20
101,412.10
159,657.00
5,599,339.62
25,102.08
128,377.84
1,060,729.00
6,660,068.62
33,469.44
248,749.00
0.00
6,660,068.62
0.00
6,660,068.62
278,800.25
6,938,868.87
37,692.00
223,713.78
743,119.00
7,681,987.87
19,684.80
209,842.88
0.00
7,681,987.87
8,376.00
125,180.86
1,622,798.80
9,304,786.67
27,222.00
149,367.01
0.00
9,304,786.67
0.00
9,304,786.67
0.00
9,304,786.67
0.00
9,304,786.67
0.00
9,304,786.67
0.00
9,304,786.67
0.00
9,304,786.67
0.00
9,304,786.67
0.00
9,304,786.67
0.00
9,304,786.67
0.00
9,304,786.67
0.00
9,304,786.67
0.00
9,304,786.67
0.00
9,304,786.67
0.00
9,304,786.67
0.00
9,304,786.67
0.00
9,304,786.67
0.00
9,304,786.67
0.00
9,304,786.67
0.00
9,304,786.67
0.00
9,304,786.67
0.00
9,304,786.67
9,304,786.67
TORES PURCHASES
302,158.80
2,083,324.13
KIT. REQ.
3,825,261.94
STAFF REQ.
2,126,258.94
6,012,150.52
R A N S F E R
TRANSFER
TOTAL I S S U E S
BEV.TO
MEAT
DIRECT
0.00
0.00
420,846.71
285,232.00
294,574.96
164,241.00
649,444.92
332,082.76
IHPLC
STEWARD
FOOD
SALES
12,395.35
1,623.19
0.00
0.00
9,687.32
239,515.94
169,290.00
4,203.0
225,961.22
153,491.00
5,059.00
220,170.00
142,389.00
4,880.90
296,330.00
101,152.00
7,813.60
629,755.00
289,201.00
10,517.2
0.00
0.00
198,186.00
162,880.25
6,596.30
170,320.00
137,109.00
523.0
271,960.00
0.00
9,732.70
251,132.00
303,140.30
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
3,868,196.75
2,240,208.31
71,408.41
5,951,520.88
TODATE
71,408.4
1,623.19
0.00
0.0 TODAY
#NAME?
3,825,261.94
IHPLC
='C:\[clientel.12M]A'!R[74]C[43]
F&A
='C:\[clientel.12M]A'!R[74]C[43]
PLANET
='C:\[clientel.12M]A'!R[75]C[43]
THT
='C:\[clientel.12M]A'!R[75]C[43]
CANTEEN CREDIT
='C:\[clientel.12M]A'!R[10]C[-8]
FOOD TO BAR
SHERATON
JUICE TO BAR
TRANSFER
TRANSFER
TO EMPLOYEE
ADMIN &
BENEFIT
GENERAL
25,102.08
17,259.69
43,928.64
14,298.48
18,826.56
16,734.72
0.00
0.00
25,102.08
10,459.20
10,459.20
25,102.08
65,753.46
33,469.44
46,119.63
0.00
0.00
37,692.00
19,684.80
8,376.00
27,222.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
32,433.40
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
302,158.80
0.00
175,864.66
M]A'!R[74]C[43]
M]A'!R[74]C[43]
M]A'!R[75]C[43]
M]A'!R[75]C[43]
M]A'!R[10]C[-8]
OTHER STOREROOM CREDITS
OTHER KITCHEN KITCHEN CHARGE
FRUIT
TRANSFERS
BASKET
S&P; GRATIS
(TRANSFER)
SALES
72,535.05
4,365.00
26,275.00
66,140.00
STEWARD
TOTAL
OTHERS
22,190.00
18,915.00
SUB
5,026.50
816,636.49
608,328.52
650.00
1,122,126.99
20,226.62
0.00
9,687.32
20,915.00
4,000.00
468,161.49
29,115.00
469,353.70
21,565.00
26,160.00
2,500.00
447,287.00
330.00
505,013.44
330.00
LIVE-IN
BENEFITS
24,670.00
1,796.00
1,105,636.57
20,780.00
-20,780.00
20,780.00
-20,780.00
25,165.00
6,365.00
559,846.33
19,525.00
4,355.51
493,914.37
20,520.00
1,940.00
351,980.16
20,120.00
683,519.31
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
1,940.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
353,720.00
59,463.01
7,672,466.74
23,476.62
0.00
23,476.62 TOTAL STEWARD SALES
TODATE
TODAY
OTHER STOREROOM CREDITS
IKEJA
IKEJA
HOTELS
EMPLOYEE
ELIMINATION S & P
A & G
BENEFIT
1,412.25
939.84
3,125.67
1,409.76
1,726.90
2,326.02
4,416.00
6,275.52
1,121.45
0.00
TOTAL STEWARD SALES
0.00
7,687.77 10,649.64
4,416.00
COST
GRATIS
TOTAL
TO BARS
CHARGE
OF SALES
GROSS
GROSS
ADJUSTMENT
TODAY
TODATE
1,620.00
75,567.30
2,516.22
70,018.83
#NAME?
15,810.00
833,386.33
3,859.96
812,776.53
#NAME?
2,430.00
618,950.19
6,626.48
601,702.04
#NAME?
2,700.00
1,145,053.61
6,152.22
1,115,974.77
#NAME?
0.00
1,594.04
-1,594.04
#NAME?
9,687.32
4,110.26
5,577.06
#NAME?
1,620.00
471,191.25
922.17
467,239.32
#NAME?
1,080.00
472,160.60
922.17
468,431.53
#NAME?
1,350.00
448,967.00
0.00
447,287.00
#NAME?
1,350.00
509,019.46
0.00
505,013.44
#NAME?
2,700.00
16,620.00
2,700.00
1,116,552.09
671.87
1,104,964.70
#NAME?
-20,780.00
0.00
-20,780.00
#NAME?
-20,780.00
0.00
-20,780.00
#NAME?
576,466.33
0.00
559,846.33
#NAME?
493,914.37
3,688.70
490,225.67
#NAME?
354,680.16
4,430.70
347,549.46
#NAME?
684,640.76
0.00
683,519.31
#NAME?
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00
#NAME?
49,980.00
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00
#NAME?
0.00
0.00
0.00
#NAME?
7,768,676.77
35,494.78
7,636,971.96
DRY+COLD STORE
OPENING
INVENTORY
3,871,194.93
BOOK
CANTEEN
CANTEEN
INVENTORY
REQUIS
TRANSFER
#NAME?
21,559.88
31,294.80
#NAME?
140,400.02
32,356.00
#NAME?
163,456.66
30,741.00
#NAME?
352,480.30
92,135.00
#NAME?
121,139.52
30,445.00
#NAME?
115,779.79
6,059.00
#NAME?
124,445.18
33,911.00
#NAME?
161,617.59
31,491.00
#NAME?
#NAME?
#NAME?
341,408.37
31,051.00
#NAME?
31,931.00
#NAME?
29,456.00
#NAME?
143,572.25
36,813.40
#NAME?
167,116.99
34,327.75
#NAME?
129,222.21
33,046.28
#NAME?
144,060.18
38,796.00
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
0.00
2,126,258.94
523,854.23
TOTAL LIVE-IN
2,650,113.17 NET TRANSFERS
L/HSE. OFFICERS(OTHERS)
MUSIC
STOREROOM ANALYSIS
ADJ.OPENING INV.
OPENING
PURCHASES
TOTAL STOCK
STORE ISSUES
#NAME?
7,064,578.36
#NAME?
6,349,889.71
BOOK INVENTORY
#NAME?
CLOSING
#VALUE!
DIFFERENCE
#VALUE!
DRY
MEAT
='C:\[dry0408mid.12M]A'!R[118]C[-31]
='C:\[cold0408mid.12M]A'!R[3]C[-33]
TRANSFER TO
LIVE-IN
OFFICERS
OFFICERS
STAFFMEAL
STAFFMEAL
CHECKS
TODAY
TODATE
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
52,854.68
52,854.68
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
172,756.02
225,610.70
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
194,197.66
419,808.36
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
444,615.30
864,423.66
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
0.00
864,423.66
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
0.00
864,423.66
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
151,584.52
1,016,008.18
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
121,838.79
1,137,846.97
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
158,356.18
1,296,203.15
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
193,108.59
1,489,311.74
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
372,459.37
1,861,771.11
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
31,931.00
1,893,702.11
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
29,456.00
1,923,158.11
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
180,385.65
2,103,543.76
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
201,444.74
2,304,988.50
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
162,268.49
2,467,256.99
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
182,856.18
2,650,113.17
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
0.00
2,650,113.17
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
0.00
2,650,113.17
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
0.00
2,650,113.17
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
0.00
2,650,113.17
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
0.00
2,650,113.17
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
0.00
2,650,113.17
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
0.00
2,650,113.17
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
0.00
2,650,113.17
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
0.00
2,650,113.17
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
0.00
#NAME?
0.00
0.00
523,854.23
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
0.00
#NAME?
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
0.00
#NAME?
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
0.00
#NAME?
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
0.00
#NAME?
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
0.00
#NAME?
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
0.00
#NAME?
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
0.00
#NAME?
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
0.00
#NAME?
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
0.00
#NAME?
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
0.00
#NAME?
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
0.00
#NAME?
='C:\[Lhrofchk.12M]A'!R[-5]C[-36]
0.00
#NAME?
0.00
2,650,113.17
='C:\[staff-bu0408MId.12M]A'!R[191]C[82]
='C:\[staff-bu0408MId.12M]A'!R[214]C[82]
TO BE UPDATED PER MONTH END DATES
NET COST
NET COST
SALES
SALES
TODAY
TODATE
TODAY
TODATE
#NAME?
#NAME?
1,540,435.00
1,540,435.00
640,020.51
#NAME?
1,703,195.00
3,243,630.00
407,504.38
#NAME?
1,453,335.00
4,696,965.00
671,359.47
#NAME?
805,609.00
5,502,574.00
-1,594.04
#NAME?
979,444.00
6,482,018.00
5,577.06
#NAME?
560,952.00
7,042,970.00
315,654.80
#NAME?
651,074.00
7,694,044.00
346,592.74
#NAME?
785,301.00
8,479,345.00
288,930.82
#NAME?
1,084,096.00
9,563,441.00
311,904.85
#NAME?
1,126,297.00
10,689,738.00
732,505.33
#NAME?
1,076,682.00
11,766,420.00
-52,711.00
#NAME?
1,006,339.00
12,772,759.00
-50,236.00
#NAME?
424,887.00
13,197,646.00
379,460.68
#NAME?
640,464.00
13,838,110.00
288,780.93
#NAME?
846,357.00
14,684,467.00
185,280.97
#NAME?
1,257,482.00
15,941,949.00
500,663.13
#NAME?
691,925.00
16,633,874.00
0.00
#NAME?
0.00
16,633,874.00
0.00
#NAME?
0.00
16,633,874.00
0.00
#NAME?
0.00
16,633,874.00
0.00
#NAME?
0.00
16,633,874.00
0.00
#NAME?
0.00
16,633,874.00
0.00
#NAME?
0.00
16,633,874.00
0.00
#NAME?
0.00
16,633,874.00
0.00
#NAME?
0.00
16,633,874.00
0.00
#NAME?
0.00
16,633,874.00
#NAME?
0.00
16,633,874.00
#NAME?
0.00
#NAME?
0.00
16,633,874.00
0.00
#NAME?
0.00
16,633,874.00
0.00
#NAME?
0.00
16,633,874.00
0.00
#NAME?
0.00
16,633,874.00
0.00
#NAME?
0.00
16,633,874.00
0.00
#NAME?
0.00
16,633,874.00
0.00
#NAME?
0.00
16,633,874.00
0.00
#NAME?
0.00
16,633,874.00
0.00
#NAME?
0.00
16,633,874.00
0.00
#NAME?
0.00
16,633,874.00
0.00
#NAME?
0.00
16,633,874.00
0.00
#NAME?
0.00
16,633,874.00
#NAME?
16,633,874.00
DATE
01-Apr-08
02-Apr-08
03-Apr-08
04-Apr-08
05-Apr-08
#NAME?
06-Apr-08
07-Apr-08
08-Apr-08
09-Apr-08
10-Apr-08
11-Apr-08
12-Apr-08
13-Apr-08
14-Apr-08
15-Apr-08
16-Apr-08
17-Apr-08
18-Apr-08
19-Apr-08
20-Apr-08
21-Apr-08
22-Apr-08
0.00
23-Apr-08
24-Apr-08
25-Apr-08
26-Apr-08
27-Apr-08
0.0
0.0
28-Apr-08
29-Apr-08
30-Apr-08
00-Jan-00
00-Jan-00
#REF!
00-Jan-00
#REF!
00-Jan-00
#REF!
00-Jan-00
#REF!
00-Jan-00
#REF!
00-Jan-00
#REF!
00-Jan-00
TOTAL
TOTAL
%FOODCOST
%FOODCOST
TODAY
TODATE
#NAME?
#NAME?
37.6%
#NAME?
28.0%
#NAME?
83.3%
#NAME?
-0.2%
#NAME?
1.0%
#NAME?
48.5%
#NAME?
44.1%
#NAME?
26.7%
#NAME?
27.7%
#NAME?
68.0%
#NAME?
-5.2%
#NAME?
-11.8%
#NAME?
59.2%
#NAME?
34.1%
#NAME?
14.7%
#NAME?
72.4%
#NAME?
#DIV/0!
#NAME?
#DIV/0!
#NAME?
#DIV/0!
#NAME?
#DIV/0!
#NAME?
#DIV/0!
#NAME?
#DIV/0!
#NAME?
#DIV/0!
#NAME?
#DIV/0!
#NAME?
#DIV/0!
#NAME?
#NAME?
#NAME?
#DIV/0!
#NAME?
#DIV/0!
#NAME?
#DIV/0!
#NAME?
#DIV/0!
#NAME?
#DIV/0!
#NAME?
#DIV/0!
#NAME?
#DIV/0!
#NAME?
#DIV/0!
#NAME?
#DIV/0!
#NAME?
#DIV/0!
#NAME?
#DIV/0!
#NAME?
#DIV/0!
#NAME?
#NAME?
#NAME?
TODAY
GROSS COST
#NAME?
STAFFMEAL
52,854.68
812,776.53
172,756.02 TO: FINANCIAL MANAGER
601,702.04
194,197.66
1,115,974.77
444,615.30 16th-17th April 2008
-1,594.04
0.00
5,577.06
0.00
467,239.32
151,584.52 TOTAL SALES
468,431.53
121,838.79 RESTAURANT
447,287.00
158,356.18 BANQUET
505,013.44
193,108.59 GROSS COST
1,104,964.70
372,459.37 LESS: EMPLOYEE MEALS
-20,780.00
31,931.00 NET COST OF FOOD SOLD
-20,780.00
29,456.00
559,846.33
180,385.65 BEVERAGE TO FOOD
490,225.67
201,444.74 DIRECT PURCHASES
347,549.46
162,268.49 TOTAL STORE ISSUES
683,519.31
182,856.18 TOTAL MEAT ISSUES
0.00
0.00
0.00
0.00 TOTAL COVER
0.00
0.00 AVERAGE CHECK
0.00
0.00 AVERAGE COST/COVER
0.00
0.00
0.00
0.00
0.00
0.00 CC.
0.00
0.00 GENERAL MANAGER
0.00
0.00 OPERATIONS MANAGER
0.00
#NAME?
0.00
0.00 DEPUTY F&B MANAGER
0.00
0.00 EXECUTIVE CHEF
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
#NAME?
CHIEF ACCOUNTANT
0.00
#NAME?
CHECK
REMARK:Food cost today was high due to low sales.I
SALES
GROSS COST
-
LESS: EMPLOYEES MEALS
FEDERAL PALACE HOTELS
DAILY FLASH FOOD COST REPORT
17 of 30 days
TODAY
ACTUAL
1,949,407.00
MONTH TODATE
%
ACTUAL(2008)
100.00
16,633,874.00
100.00
1,661,060.00
#NAME?
288,347.00
2,854,173.00
1,031,068.77
52.9%
7,636,971.96
45.9%
425,029.98
21.8%
2,650,113.17
15.9%
606,038.79
31.1%
#NAME?
9,732.70
0.5%
71,408.41
0.4%
303,140.30
15.6%
2,240,208.31
13.5%
274,547.87
14.1%
2,083,324.13
12.5%
523,092.00
26.8%
3,868,196.75
23.3%
772
#NAME?
#NAME?
6863
2,423.70
#NAME?
#NAME?
79,444.10 ANY DIFFERENCE IS EITHER S & P TRANSFER OR COST OF SALES ADJ.
d cost today was high due to low sales.It is recommended that requisitions should be justified to occu
TODAY
-
ACTUAL
208,795.0
100.0
-
198,472.9
-
95.1%
-
TODATE
ACTUAL
100.0
0.0
0.0
#DIV/0!
-
L......
ELS
ORT
LAST YEAR (MTD)
YEAR TODATE
ACTUAL(2007)
ACTUAL(2008)
11,960,034.81
100.00
#NAME?
100.00
11,160,904.37
#NAME?
799,130.44
19,308,736.00
7,111,071.30
59.5%
46,552,415.37 #NAME?
2,783,366.75
23.3%
18,377,197.00 #NAME?
4,327,704.55
36.2%
28,175,218.37 #NAME?
16,089.82
0.1%
423,108.69 #NAME?
1,278,709.29
10.7%
13,372,137.95 #NAME?
1,887,450.41
15.8%
12,562,751.84 #NAME?
4,007,567.49
33.5%
23,741,053.59 #NAME?
5722
2,090.18
756.33
40333
#NAME?
698.56
HER S & P TRANSFER OR COST OF SALES ADJ.
ROTIMI ABAWONSE
Food & Beverages Controller
ded that requisitions should be justified to occupancy.
L......
LAST YEAR (YTD)
ACTUAL(2007)
90,237,726.11
%
100.00
JAN 1 TO MAR 31
JAN 1 TO MAR 31
2008 TO DATE
2007 TO DATE
MONTHLY
MONTHLY
73,970,580.00
78,277,691.30
73,986,265.24
57,516,017.00
62,825,360.87
16,251,460.87
16,454,563.00
15,452,330.43
51,909,323.50
57.5%
38,915,443.41
44,798,252.20
17,876,643.44
19.8%
15,727,083.83
15,093,276.69
34,032,680.06
37.7%
23,188,359.58
29,704,975.51
47,969.00
0.1%
351,700.28
31,879.18
11,884,028.85
13.2%
11,131,929.64
10,605,319.56
13,179,178.78
14.6%
10,479,427.71
11,291,728.37
27,772,308.28
30.8%
19,872,856.84
23,764,740.79
42941
33470
37219
2,101.44
2,210.06
2,103.16
792.55
692.81
798.11
ages Controller
C O S T O F S A L E S A D J U S T M E N T (FOOD)
#NAME?
COMPLIMENTARY
MUSIC
A&G
01-Apr-08
0.00
0.00
2,516.22
02-Apr-08
0.00
0.00
3,859.96
03-Apr-08
0.00
0.00
6,626.48
04-Apr-08
0.00
0.00
6,152.22
05-Apr-08
0.00
0.00
1,594.04
06-Apr-08
0.00
0.00
4,110.26
07-Apr-08
0.00
0.00
0.00
08-Apr-08
0.00
0.00
922.17
09-Apr-08
0.00
0.00
0.00
10-Apr-08
0.00
0.00
0.00
11-Apr-08
0.00
0.00
671.87
12-Apr-08
0.00
0.00
0.00
13-Apr-08
0.00
0.00
0.00
14-Apr-08
0.00
0.00
0.00
15-Apr-08
0.00
0.00
0.00
16-Apr-08
0.00
0.00
0.00
17-Apr-08
0.00
0.00
0.00
18-Apr-08
0.00
0.00
0.00
19-Apr-08
0.00
0.00
0.00
20-Apr-08
0.00
0.00
0.00
21-Apr-08
0.00
0.00
0.00
22-Apr-08
0.00
0.00
0.00
23-Apr-08
0.00
0.00
0.00
24-Apr-08
0.00
0.00
0.00
25-Apr-08
0.00
0.00
0.00
26-Apr-08
0.00
0.00
0.00
27-Apr-08
0.00
0.00
0.00
28-Apr-08
0.00
0.00
0.00
29-Apr-08
0.00
0.00
0.00
30-Apr-08
0.00
0.00
0.00
00-Jan-00
0.00
0.00
0.00
0.00
0.00
26,453.22
00-Jan-00
00-Jan-00
00-Jan-00
00-Jan-00
00-Jan-00
00-Jan-00
00-Jan-00
00-Jan-00
A D J U S T M E N T (FOOD)
COST OF SALES ADJUSTMENT
S&P1
S&P2
S&P3
S&P2
PR
SECURITY
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
922.17
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
1,375.04
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
922.17
0.00
0.00
0.00
0.00
1,375.04
ROOM
ENGINEERING PURCHASINGH/KEEPING
ADMIN
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
COSA
TRAINING
TOTAL REBATE
DATE
0.00
2,516.22
01-Apr-08
0.00
3,859.96
02-Apr-08
0.00
6,626.48
03-Apr-08
0.00
6,152.22
04-Apr-08
0.00
1,594.04
05-Apr-08
0.00
4,110.26
06-Apr-08
0.00
922.17
07-Apr-08
0.00
922.17
08-Apr-08
0.00
0.00
09-Apr-08
0.00
0.00
10-Apr-08
0.00
671.87
11-Apr-08
0.00
0.00
12-Apr-08
0.00
0.00
13-Apr-08
0.00
0.00
14-Apr-08
3,688.70
3,688.70
15-Apr-08
3,055.65
4,430.70
16-Apr-08
0.00
0.00
17-Apr-08
0.00
0.00
18-Apr-08
0.00
0.00
19-Apr-08
0.00
0.00
20-Apr-08
0.00
0.00
21-Apr-08
0.00
0.00
22-Apr-08
0.00
0.00
23-Apr-08
0.00
0.00
24-Apr-08
0.00
0.00
25-Apr-08
0.00
0.00
26-Apr-08
0.00
0.00
27-Apr-08
0.00
0.00
28-Apr-08
0.00
0.00
29-Apr-08
0.00
0.00
30-Apr-08
0.00
0.00
00-Jan-00
0.00
00-Jan-00
0.00
00-Jan-00
0.00
00-Jan-00
0.00
00-Jan-00
0.00
00-Jan-00
0.00
00-Jan-00
0.00
00-Jan-00
0.00
6,744.35
35,494.78
BEV TO FOOD BEV TO FOOD DIRECT
DIRECT
STORES
TODAY
TODATE
TODAY
TODATE
TODAY
0.00
0.00
0.00
0.00
111,984.74
0.00
0.00
285,232.00
285,232.00
148,136.26
12,395.35
12,395.35
164,241.00
449,473.00
163,392.21
0.00
12,395.35
332,082.76
781,555.76
213,389.00
0.00
12,395.35
0.00
781,555.76
0.00
9,687.32
22,082.67
0.00
781,555.76
0.00
4,203.04
26,285.71
169,290.00
950,845.76
145,820.97
5,059.00
31,344.71
153,491.00
1,104,336.76
113,957.48
4,880.90
36,225.61
142,389.00
1,246,725.76
101,412.10
7,813.60
44,039.21
101,152.00
1,347,877.76
128,377.84
10,517.20
54,556.41
289,201.00
1,637,078.76
248,749.00
0.00
54,556.41
0.00
1,637,078.76
0.00
0.00
54,556.41
0.00
1,637,078.76
0.00
6,596.30
61,152.71
162,880.25
1,799,959.01
223,713.78
523.00
61,675.71
137,109.00
1,937,068.01
209,842.88
9,732.70
71,408.41
0.00
1,937,068.01
125,180.86
0.00
71,408.41
303,140.30
2,240,208.31
149,367.01
0.00
71,408.41
0.00
2,240,208.31
0.00
0.00
71,408.41
0.00
2,240,208.31
0.00
0.00
71,408.41
0.00
2,240,208.31
0.00
0.00
71,408.41
0.00
2,240,208.31
0.00
0.00
71,408.41
0.00
2,240,208.31
0.00
0.00
71,408.41
0.00
2,240,208.31
0.00
0.00
71,408.41
0.00
2,240,208.31
0.00
0.00
71,408.41
0.00
2,240,208.31
0.00
0.00
71,408.41
0.00
2,240,208.31
0.00
0.00
71,408.41
0.00
2,240,208.31
0.00
0.00
71,408.41
0.00
2,240,208.31
0.00
0.00
71,408.41
0.00
2,240,208.31
0.00
0.00
71,408.41
0.00
2,240,208.31
0.00
0.00
71,408.41
0.00
2,240,208.31
0.00
0.00
71,408.41
0.00
2,240,208.31
0.00
0.00
71,408.41
0.00
2,240,208.31
0.00
0.00
71,408.41
0.00
2,240,208.31
0.00
0.00
71,408.41
0.00
2,240,208.31
0.00
0.00
71,408.41
0.00
2,240,208.31
0.00
0.00
71,408.41
0.00
2,240,208.31
0.00
0.00
71,408.41
0.00
2,240,208.31
0.00
0.00
71,408.41
0.00
2,240,208.31
0.00
71,408.41
2,240,208.31
2,083,324.13
STORES
MEAT ISSUE
MEAT ISSUE
TODATE
TODAY
TODATE
SALES STATISTICS
REST. TODAY
REST TODATE
111,984.74
0.00
0.00
968,261.00
968,261.00
260,121.00
420,846.71
420,846.71
981,456.00
1,949,717.00
423,513.21
294,574.96
715,421.67
967,248.00
2,916,965.00
636,902.21
649,444.92
1,364,866.59
762,566.00
3,679,531.00
636,902.21
0.00
1,364,866.59
918,574.00
4,598,105.00
636,902.21
0.00
1,364,866.59
560,952.00
5,159,057.00
782,723.18
239,515.94
1,604,382.53
638,031.00
5,797,088.00
896,680.66
225,961.22
1,830,343.75
720,953.00
6,518,041.00
998,092.76
220,170.00
2,050,513.75
1,013,661.00
7,531,702.00
1,126,470.60
296,330.00
2,346,843.75
863,514.00
8,395,216.00
1,375,219.60
629,755.00
2,976,598.75
1,076,682.00
9,471,898.00
1,375,219.60
0.00
2,976,598.75
735,035.00
10,206,933.00
1,375,219.60
0.00
2,976,598.75
424,887.00
10,631,820.00
1,598,933.38
198,186.00
3,174,784.75
640,464.00
11,272,284.00
1,808,776.26
170,320.00
3,345,104.75
846,357.00
12,118,641.00
1,933,957.12
271,960.00
3,617,064.75
986,352.00
13,104,993.00
2,083,324.13
251,132.00
3,868,196.75
674,708.00
13,779,701.00
2,083,324.13
0.00
3,868,196.75
0.00
13,779,701.00
2,083,324.13
0.00
3,868,196.75
0.00
13,779,701.00
2,083,324.13
0.00
3,868,196.75
0.00
13,779,701.00
2,083,324.13
0.00
3,868,196.75
0.00
13,779,701.00
2,083,324.13
0.00
3,868,196.75
0.00
13,779,701.00
2,083,324.13
0.00
3,868,196.75
0.00
13,779,701.00
2,083,324.13
0.00
3,868,196.75
0.00
13,779,701.00
2,083,324.13
0.00
3,868,196.75
0.00
13,779,701.00
2,083,324.13
0.00
3,868,196.75
0.00
13,779,701.00
2,083,324.13
0.00
3,868,196.75
0.00
13,779,701.00
2,083,324.13
0.00
3,868,196.75
0.00
13,779,701.00
2,083,324.13
0.00
3,868,196.75
0.00
13,779,701.00
2,083,324.13
0.00
3,868,196.75
0.00
13,779,701.00
2,083,324.13
0.00
3,868,196.75
0.00
13,779,701.00
2,083,324.13
0.00
3,868,196.75
0.00
13,779,701.00
2,083,324.13
0.00
3,868,196.75
0.00
13,779,701.00
2,083,324.13
0.00
3,868,196.75
0.00
13,779,701.00
2,083,324.13
0.00
3,868,196.75
0.00
13,779,701.00
2,083,324.13
0.00
3,868,196.75
0.00
13,779,701.00
2,083,324.13
0.00
3,868,196.75
0.00
13,779,701.00
2,083,324.13
0.00
3,868,196.75
0.00
13,779,701.00
2,083,324.13
0.00
3,868,196.75
0.00
13,779,701.00
3,868,196.75
13,779,701.00
SALES STATISTICS
BQT. TODAY
BQT. TODATE
TODAY
TODATE
COVER
COVER
0.00
0.00
685
685
0.00
0.00
754
1439
0.00
0.00
640
2079
0.00
0.00
307
2386
0.00
0.00
390
2776
0.00
0.00
245
3021
0.00
0.00
263
3284
0.00
0.00
356
3640
0.00
0.00
426
4066
0.00
0.00
497
4563
0.00
0.00
356
4919
0.00
0.00
468
5387
0.00
0.00
177
5564
0.00
0.00
243
5807
0.00
0.00
284
6091
0.00
0.00
506
6597
0.00
0.00
266
6863
0.00
0.00
6863
0.00
0.00
6863
0.00
0.00
6863
0.00
0.00
6863
0.00
0.00
6863
0.00
0.00
6863
0.00
0.00
6863
0.00
0.00
6863
0.00
0.00
6863
0.00
0.00
6863
0.00
0.00
6863
0.00
0.00
6863
0.00
0.00
6863
0.00
0.00
6863
0.00
0.00
6863
0.00
0.00
6863
0.00
0.00
6863
0.00
0.00
6863
0.00
0.00
6863
0.00
0.00
6863
0.00
0.00
6863
0.00
0.00
6863
0.00
6863
LIGHT HOUSE
L O U N G E
01-Apr-08
691,957.00
7,043.00
02-Apr-08
641,565.00
3,261.00
03-Apr-08
675,913.00
5,391.00
04-Apr-08
456,000.00
6,348.00
05-Apr-08
664,235.00
3,522.00
06-Apr-08
300,652.00
2,826.00
07-Apr-08
436,870.00
4,522.00
08-Apr-08
470,609.00
2,696.00
09-Apr-08
662,739.00
9,096.00
10-Apr-08
589,283.00
3,565.00
11-Apr-08
816,565.00
1,565.00
12-Apr-08
548,804.00
1,174.00
13-Apr-08
270,870.00
391.00
14-Apr-08
400,304.00
5,217.00
15-Apr-08
596,957.00
27,409.00
16-Apr-08
674,696.00
13,217.00
17-Apr-08
450,826.00
6,174.00
18-Apr-08
19-Apr-08
20-Apr-08
21-Apr-08
22-Apr-08
23-Apr-08
24-Apr-08
25-Apr-08
26-Apr-08
27-Apr-08
28-Apr-08
29-Apr-08
30-Apr-08
00-Jan-00
00-Jan-00
00-Jan-00
00-Jan-00
00-Jan-00
00-Jan-00
00-Jan-00
00-Jan-00
9,348,845.00
103,417.00
EXE. FLOOR
ROOM SERVICE
B A N Q U E T MINIBAR
15,957.00
253,304.00
572,174.00
17,087.00
319,543.00
721,739.00
13,783.00
272,161.00
486,087.00
19,957.00
280,261.00
43,043.00
8,217.00
242,600.00
60,870.00
12,870.00
244,604.00
0.00
13,304.00
183,335.00
13,043.00
14,870.00
232,778.00
64,348.00
19,304.00
322,522.00
70,435.00
19,109.00
251,557.00
262,783.00
14,413.00
244,139.00
0.00
21,457.00
163,600.00
271,304.00
12,196.00
141,430.00
0.00
34,565.00
200,378.00
0.00
36,391.00
185,600.00
0.00
37,304.00
261,135.00
271,130.00
7,565.00
210,143.00
17,217.00
318,349.00
4,009,090.00
2,854,173.00
0.00
POOL
ALG
DAILY TOTAL
COVERS TODAY
1,540,435.00
685
1,703,195.00
754
1,453,335.00
640
805,609.00
307
979,444.00
390
560,952.00
245
651,074.00
263
785,301.00
356
1,084,096.00
426
1,126,297.00
497
1,076,682.00
356
1,006,339.00
468
424,887.00
177
640,464.00
243
846,357.00
284
1,257,482.00
506
691,925.00
266
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
16,633,874.00
6863
EMPLOYEE MEALS
#VALUE!
DAILY SALES
(RESTAURANT)
968,261.00
685
981,456.00
1439
967,248.00
2079
762,566.00
2386
918,574.00
2776
560,952.00
3021
638,031.00
3284
720,953.00
3640
1,013,661.00
4066
863,514.00
4563
1,076,682.00
4919
735,035.00
5387
424,887.00
5564
640,464.00
5807
846,357.00
6091
986,352.00
6597
674,708.00
6863
0.00
6863
0.00
6863
0.00
6863
0.00
6863
0.00
6863
0.00
6863
0.00
6863
0.00
6863
0.00
6863
0.00
6863
#NAME?
0.00
6863
0.00
6863
0.00
6863
0.00
6863
0.00
6863
0.00
6863
0.00
6863
0.00
6863
0.00
6863
0.00
6863
0.00
6863
0.00
6863
SALES
TOTAL FOOD SALES(Net of rebates)
LIGHT HOUSE
LOUNGE
EXECUTIVE FLOOR
IN ROOM DINING
BANQUET
MINI BAR
POOL
ALG
COSTS
OPENING STOREROOM INVENTORY
OPENING PRODUCTION INVENTORY
TOTAL OPENING INVENTORY
STOREROOM PURCHASES
DIRECT PURCHASES
TOTAL
BEVERAGE TO FOOD
TOTAL CHARGES
LESS:
CLOSING STOREROOM INVENTORY
CLOSING PRODUCTION INVENTORY
TOTAL CLOSING INVENTORY
CREDITS (REQ. + TRANSFERS)
IKEJA HOTELS PLC
F & A SERVICES/ DESACOM
STEWARD SALES
PLANET/A.V.I SERVICES
TOTAL HEALTH TRUST
SHERATON LAGOS HOTELS & TOWERS
MANAGERS' A&G OFFICES
MUSICIANS
COST OF SALES ADJUSTMENTS
GRATIS TO BARS & OTHERS
FRUIT BASKET
EMPLOYEE BENEFIT
ELIMINATION
S&P
FOOD TO BARS / & JUICE
TOTAL CREDITS
TOTAL ALL CREDITS
GROSS COST OF FOOD SOLD
LESS: COST OF CANTEEN MEALS
LESS: OFFICERS CHECKS
LESS:LIVE-IN FOOD BENEFITS
NET COST OF FOOD SOLD
SUMMARY OF STOREROOM ISSUES
MAIN KITCHEN
STAFF KITCHEN
A&G
FOOD / JUICE TO BAR
GRATIS TO BARS
IKEJA HOTELS
LIVE-IN BENEFIT
STEWARD SALES
EMPLOYEE BENEFIT
S&P
ELIMINATION
TOTAL BOOK ISSUES
TOTAL ACTUAL ISSUES
STOREROOM OVER/(LOWER)
ACTUAL AVERAGE INVENTORY
TOTAL COST OF FOOD CONSUMED
INVENTORY AT PAR
ACTUAL INVENTORY TURNOVER RATE
INVENTORY OVER
ACTUAL INVENTORY TURNOVER
PAR INVENTORY TURNOVER
TURNOVER LOWER THAN PAR BY
PREPARED BY:
ROTIMI ABAWONSE
FOOD & BEVERAGE CONTROLLER
30 DAYS TO 30-4-2008
FEDERAL PALACE HOTELS
RECONCILIATION OF FOOD COSTS
SALES(Net of rebates) 16,633,874.00
9,348,845.00
103,417.00
318,349.00
4,009,090.00
2,854,173.00
0.00
0.00
0.00
#NAME?
850,583.31
#NAME?
7,064,578.36
2,240,208.31
9,304,786.67
71,408.41
#VALUE!
='C:\[prod0408MID.12M]A'!R[180]C[-113]
#VALUE!
='C:\[clientel.12M]A'!R[74]C[43]
='C:\[clientel.12M]A'!R[74]C[43]
23,476.62
='C:\[clientel.12M]A'!R[75]C[43]
='C:\[clientel.12M]A'!R[75]C[43]
0.00
186,514.30
='C:\[staff-bu0408MId.12M]A'!R[214]C[82]
35,494.78
109,443.01
353,720.00
4,416.00
0.00
7,687.77
305,866.07
1,026,618.55
FOOD SOLD
3,825,261.94
2,126,258.94
10,649.64
302,158.80
49,980.00
0.00
0.00
23,476.62
4,416.00
7,687.77
0.00
6,349,889.71
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
4.00
#NAME?
APPROVED BY:
MARK COURTNEY
FINANCIAL MANAGER
#NAME?
D COSTS
100.0%
56.2%
0.6%
1.9%
24.1%
17.2%
0.0%
0.0%
0.0%
9,376,195.08
R[180]C[-113]
A'!R[214]C[82]
#VALUE!
#NAME?
#VALUE!
='C:\[staff-bu0408MId.12M]A'!R[79]C[3]
0.00
#NAME?
L MANAGER
#NAME?
#NAME?
#VALUE!
#VALUE!
0.0%
#NAME?
30 DAYS TO 30-4-2008
RECONCILIATION OF FOOD COSTS
OPENING STOCK
ADD: PURCHASES
AVAILABLE
LESS CLOSING
TOTAL CONSUMPTION
CANTEEN MEALS/COOKS DRINKS
OFFICERS CHECKS
LIVE IN BENEFIT
TOTAL CAFETARIA COST
OTHER CREDITS:
A/R LAGOS SHERATON
FOOD TO BARS
GRATIS TO BARS & OTHERS
MANAGERS A & G OFFICES
IKEJA HOTEL PLC
MUSICIANS
DESACOM (F & A SERVICES)
GUEST AMENITIES
ELIMINATIONS
STEWARD SALES
TOTAL HEALTH TRUST
EMPLOYEE BENEFITS
TOTAL OTHER CREDITS
COST OF SALES ADJUSTMENTS:
A & G CONTROL
S&P1
S&P2
S&P3
PUBLIC RELATION
F&B
HUMAN RESOURCES
SECURITY
PURCHASING
ROOMS DEPT.
ENGINEERING DEPT.
TRAINING DEPT.
TOTAL COST ADJUSTMENT
CHECK (TOTAL ALL CREDIT)
1st to 15th
16th to 30th
30.3%
25.1% SALES VALUE OF REBATE
COMPL
MUSIC
01-Apr-08
02-Apr-08
03-Apr-08
04-Apr-08
05-Apr-08
06-Apr-08
07-Apr-08
08-Apr-08
09-Apr-08
0.00
0.00
10-Apr-08
0.00
0.00
11-Apr-08
12-Apr-08
0.00
0.00
13-Apr-08
0.00
0.00
14-Apr-08
0.00
0.00
0.00
0.00
15-Apr-08
16-Apr-08
17-Apr-08
18-Apr-08
19-Apr-08
20-Apr-08
21-Apr-08
22-Apr-08
23-Apr-08
24-Apr-08
25-Apr-08
26-Apr-08
27-Apr-08
28-Apr-08
29-Apr-08
30-Apr-08
00-Jan-00
00-Jan-00
00-Jan-00
00-Jan-00
00-Jan-00
00-Jan-00
00-Jan-00
00-Jan-00
00-Jan-00
00-Jan-00
00-Jan-00
00-Jan-00
00-Jan-00
0.00
0.00
TO 30-4-2008
IATION OF FOOD COSTS
#NAME?
9,304,786.67
#NAME?
#VALUE!
#NAME?
#VALUE!
='C:\[staff-bu0408MId.12M]A'!R[79]C[3]
0.00
#VALUE!
0.00
305,866.07
117,130.78
186,514.30
='C:\[clientel.12M]A'!R[74]C[43]
='C:\[staff-bu0408MId.12M]A'!R[214]C[82]
='C:\[clientel.12M]A'!R[74]C[43]
353,720.00
0.00
23,476.62
='C:\[clientel.12M]A'!R[75]C[43]
4,416.00
991,123.77
ES ADJUSTMENTS:
26,453.22
922.17
0.00
0.00
0.00
0.00
0.00
1,375.04
0.00
0.00
0.00
6,744.35
35,494.78
#VALUE!
SALES VALUE OF REBATE
A&G
S&P1
S&P2
S&P3
S&P2
9,550.00
14,650.00
25,150.00
23,350.00
6,050.00
15,600.00
3,500.00
3,500.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
2,550.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
100,400.00
3,500.00
0.00
0.00
0.00
214]C[82]
PR
SECURITY
ENGINEERING
PURCHASING
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
6,300.00
0.00
0.00
0.00
6,300.00
0.00
0.00
0.00
H/KEEPINGADMIN
TRAINING
TOTAL REBATE REBATE TODATE
9,550.00
9,550.00
8,304.3
14,650.00
24,200.00
12,739.1
25,150.00
49,350.00
21,869.6
23,350.00
72,700.00
20,304.3
6,050.00
78,750.00
5,260.9
15,600.00
94,350.00
13,565.2
3,500.00
97,850.00
3,043.5
3,500.00
101,350.00
3,043.5
0.00
0.00
0.00
0.00
101,350.00
0.0
0.00
0.00
0.00
0.00
101,350.00
0.0
2,550.00
103,900.00
2,217.4
0.00
0.00
0.00
0.00
103,900.00
0.0
0.00
0.00
0.00
0.00
103,900.00
0.0
0.00
0.00
0.00
0.00
103,900.00
0.0
14,000.00
14,000.00
117,900.00
12,173.9
14,000.00
20,300.00
138,200.00
17,652.2
0.00
0.00
138,200.00
0.0
0.00
138,200.00
0.0
0.00
138,200.00
0.0
0.00
138,200.00
0.0
0.00
138,200.00
0.0
0.00
138,200.00
0.0
0.00
138,200.00
0.0
0.00
138,200.00
0.0
0.00
138,200.00
0.0
0.00
138,200.00
0.0
0.00
138,200.00
0.0
0.00
0.00
0.00
0.00
28,000.00
0.00
138,200.00
0.0
0.00
138,200.00
0.0
0.00
138,200.00
0.0
0.00
138,200.00
0.0
0.00
138,200.00
0.0
0.00
138,200.00
0.0
0.00
138,200.00
0.0
0.00
138,200.00
0.0
0.00
138,200.00
0.0
0.00
138,200.00
0.0
0.00
138,200.00
0.0
0.00
138,200.00
0.0
138,200.00
120,173.9
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
