TCSOpStmt
Acme Motels
Detailed Statement of Operations from 01 Mar 2008 to 31 Mar 2008
Actual
Last Year Actual
Actual
Variance
Budget
Variance
Budget
Actual
This Period
Last Year
This Year
This Year
This Year
This Period
This Period
This Period
OPERATING REVENUE
84,704
112,006
(27,302)
Accommodation Sales
922,900
(124,934)
797,966
(93,953)
(774,155)
2,276
3,132
(856)
Beverage Sales
23,384
(144)
23,240
(2,998)
(22,388)
146
555
(409)
Communication Sales
2,765
(1,144)
1,621
(428)
(1,964)
1,618
2,911
(1,293)
Conference Sales
18,186
(2,357)
15,829
(2,782)
(17,383)
468
564
(96)
Miscellaneous Income
3,943
2,393
6,336
(978)
(4,800)
14,136
24,081
(9,945)
Restaurant Sales
157,131
(22,271)
134,860
(19,748)
(128,857)
103,348
143,249
(39,901)
Gross Sales
1,128,309
(148,457)
979,852
(120,888)
(949,547)
OPERATING COSTS
Accommodation Costs
(1,328)
1,328
0
0
531
1,442
911
Beverage Costs
10,934
1,596
9,338
1,288
9,769
1,189
1,903
714
Communication Costs
9,383
916
8,467
1,827
9,077
6
1,193
1,187
Conference Costs
1,951
1,534
417
1,133
1,854
161
623
462
Miscellaneous Cost of Sales
3,939
1,450
2,489
869
3,924
4,084
10,122
6,038
Restaurant Costs
56,218
8,378
47,840
8,083
45,370
5,972
15,283
9,311
Gross Cost of Sales
82,425
12,545
69,880
13,199
69,995
GROSS MARGIN
84,704
112,006
(27,302)
Accommodation Gross Margin
922,900
(126,262)
796,638
(93,953)
(774,155)
1,745
1,690
55
Beverage Gross Margin
12,450
1,452
13,902
(1,711)
(12,619)
(1,044)
(1,348)
304
Communication Gross Margin
(6,618)
(227)
(6,845)
1,399
7,114
1,612
1,718
(106)
Conference Gross Margin
16,235
(823)
15,412
(1,650)
(15,529)
307
(59)
366
Miscellaneous Gross Margin
4
3,843
3,847
(109)
(875)
10,052
13,959
(3,907)
Restaurant Gross Margin
100,913
(13,893)
87,020
(11,665)
(83,487)
97,376
127,966
(30,590)
Gross Margin
1,045,884
(135,911)
909,973
(107,689)
(879,552)
DIRECT COSTS
9,487
5,833
(3,654)
Other Personnel Expenses
52,497
(12,854)
65,351
12,766
18,072
500
500
Employee Training
500
118
382
562
901
Recruitment
(105)
105
0
0
Uniforms
500
(135)
635
52
346
29,005
27,376
(1,629)
Wages & Salaries
236,061
(11,839)
247,900
29,652
267,046
38,492
33,709
(4,783)
Personnel Expenses
289,558
(24,815)
314,373
43,031
286,365
518
(518)
Insurance
(2,467)
2,467
0
0
8,987
7,189
(1,798)
Rates - General
70,095
(1,805)
71,900
7,190
69,441
696
556
(140)
Rates - Water
5,421
(143)
5,564
556
5,425
38,462
30,769
(7,693)
Rental/Lease
299,997
(7,695)
307,692
30,769
300,000
Page 1 of 3
Printed on 11 Jun 2009 at 10:26 AM
TCSOpStmt
Acme Motels
Detailed Statement of Operations from 01 Mar 2008 to 31 Mar 2008
Actual
Last Year Actual
Actual
Variance
Budget
Variance
Budget
Actual
This Period
Last Year
This Year
This Year
This Year
This Period
This Period
This Period
48,663
38,514
(10,149)
Property Lease Expenses
375,513
(12,111)
387,624
38,516
374,867
2,496
3,030
534
Electricity
26,940
3,299
23,641
3,015
26,884
Fuel
0
86
287
304
17
Gas
3,014
300
2,714
543
3,086
349
500
151
Waste Removal
3,420
24
3,396
495
3,389
3,132
3,834
702
Utilities Expenses
33,374
3,623
29,751
4,052
33,445
2
(2)
Cashiers Discrepancies
(39)
39
1
(54)
1,881
1,236
(645)
Cleaning Supplies
18,385
942
17,443
1,065
16,846
757
1,600
843
Commission Charge Card
13,625
5,702
7,923
1,099
9,374
250
250
Commission Other
1,375
1,142
233
174
855
529
400
(129)
Commission Travel Agent
4,490
400
4,090
179
2,129
367
1,054
687
Equip Rental - Other
9,486
1,025
8,461
1,054
9,482
1,231
1,203
(28)
Equip Rental - TV & Sky
10,827
(53)
10,880
1,203
10,823
75
75
Guest Checkin Beverage
385
376
9
24
347
100
100
Laundry
900
900
0
611
Low Value Assets
(260)
260
0
1,536
138
300
162
Newspapers for Guests
2,500
1,149
1,351
54
2,230
70
400
330
Printing & Stationery
4,100
474
3,626
899
3,829
100
100
Repl - China Glass Silverware
700
118
582
35
208
9
100
91
Repl - Kitchen Utensils
700
411
289
0
297
100
100
Repl - Linen (Restaurant)
700
(335)
1,035
0
0
185
250
65
Repl - Sheets/Slips
2,250
841
1,409
0
2,551
250
250
Repl - Towels
2,250
2,202
48
0
342
153
1,000
847
Repl - Unit Contents
7,000
4,121
2,879
272
13,715
4,293
3,345
(948)
Repairs & Maintenance
29,485
12,017
17,468
3,879
37,293
9,616
11,763
2,147
Other Costs
109,158
31,130
78,028
9,937
112,411
99,904
87,820
(12,084)
Direct Costs
807,603
(2,173)
809,776
95,536
807,088
(2,528)
40,146
(42,674)
Net Income
238,281
(138,084)
100,197
(12,153)
(72,464)
56
(56)
Internet Ads
(1,818)
1,818
(171)
8
56
(56)
Sales & Mkting - Internet
(1,818)
1,818
(171)
8
300
750
450
Other Marketing
6,750
3,070
3,680
0
8,154
Promotions
(200)
200
0
0
300
750
450
Sales & Mkting - Other
6,750
2,870
3,880
0
8,154
81
(81)
Telephone Book Ads
(499)
499
138
445
Page 2 of 3
Printed on 11 Jun 2009 at 10:26 AM
TCSOpStmt
Acme Motels
Detailed Statement of Operations from 01 Mar 2008 to 31 Mar 2008
Actual
Last Year Actual
Actual
Variance
Budget
Variance
Budget
Actual
This Period
Last Year
This Year
This Year
This Year
This Period
This Period
This Period
81
(81)
Sales & Mkting - Phonebook
(499)
499
138
445
Brochures
1,500
1,200
300
0
1,551
Magazine Ads
(1,197)
1,197
0
0
550
3,200
2,650
Magazine Ads
3,200
1,550
1,650
3,317
3,317
50
50
Newspaper Ads
350
67
283
0
0
550
3,250
2,700
Sales & Mkting - Print Media
5,050
1,620
3,430
3,317
4,868
1,590
700
(890)
Radio Ads
5,900
4,310
1,590
0
4,500
1,590
700
(890)
Sales & Mkting - TV/Radio
5,900
4,310
1,590
0
4,500
377
(377)
ACC Levy
(2,640)
2,640
0
0
1,000
275
(725)
Accounting Fees
4,675
1,719
2,956
300
4,066
1,644
(1,644)
Bad Debts
(1,644)
1,644
0
0
18
55
38
Bank Charges
485
277
208
20
573
1,508
250
(1,258)
Computer Related Costs
3,900
(3,076)
6,976
1,690
5,508
Donations
(55)
55
31
49
175
200
26
General Expenses
1,400
370
1,030
5
1,054
979
300
(679)
Health & Safety
2,100
(169)
2,269
744
2,069
1,892
1,600
(292)
Insurance - Overhead
15,500
2,041
13,459
1,587
15,104
1,259
1,275
16
Interest
11,625
(269)
11,894
1,215
11,854
23
(23)
Interest - Other
(164)
164
0
80
IRD Late Payment Penalty
(40)
40
0
0
Professional Services
(90)
90
0
0
Subscriptions
250
(751)
1,001
150
191
139
225
86
Vehicle Expenses
1,825
603
1,222
46
1,886
9,012
4,180
(4,832)
Overhead Costs - Admin
41,760
(3,888)
45,648
5,788
42,434
4,600
4,600
Depreciation - Chattels
41,400
41,400
5,700
51,300
4,600
4,600
Depreciation
41,400
41,400
5,700
51,300
(14,117)
26,666
(40,783)
Trading Profit
137,421
(94,090)
43,331
2,620
39,245
39
50
(11)
Interest Income
390
(90)
300
(35)
(344)
107
100
7
Commission Received - NZI
400
(187)
213
(107)
(320)
(145)
(150)
(5)
NonTrading Income
(790)
(277)
(513)
(142)
(664)
(13,972)
26,816
(40,788)
Profit Before Tax
138,211
(94,367)
43,844
2,478
38,581
(13,972)
26,816
(40,788)
Profit After Tax
138,211
(94,367)
43,844
2,478
38,581
Page 3 of 3
Printed on 11 Jun 2009 at 10:26 AM