TCSOpForecast
Detailed Forecast for Year to 30 Jun 2008
Acme Motels
Year Total
OPERATING REVENUE
101,070
66,693
105,853
Accommodation Sales
94,431
72,569
82,629
100,116
89,901
84,704
105,287
77,342
67,254
1,047,849
1,172,783
3,343
1,707
3,360
Beverage Sales
3,694
1,461
2,041
2,095
3,264
2,276
2,217
2,878
2,528
30,863
31,007
149
154
212
Communication Sales
335
104
160
237
125
146
173
335
233
2,362
3,506
3,609
2,218
1,878
Conference Sales
1,138
622
2,258
676
1,813
1,618
3,355
4,110
1,358
24,652
27,009
396
249
862
Miscellaneous Income
427
859
539
1,370
1,166
468
553
331
199
7,419
5,026
19,431
16,645
11,530
Restaurant Sales
14,603
10,448
14,733
12,943
20,391
14,136
18,627
17,404
15,885
186,776
209,047
127,998
87,666
123,694
Gross Sales
114,627
86,063
102,361
117,436
116,660
103,348
130,212
102,400
87,457
1,299,921
1,448,378
OPERATING COSTS
Accommodation Costs
1,328
1,328
0
1,094
685
693
Beverage Costs
1,476
1,231
1,627
662
1,339
531
1,018
1,680
1,461
13,497
15,093
265
1,546
1,107
Communication Costs
950
867
902
866
773
1,189
936
1,593
5,083
16,079
16,995
22
389
Conference Costs
6
1,045
1,462
2,996
320
(166)
318
Miscellaneous Cost of Sales
224
665
656
39
271
161
409
343
332
3,573
5,023
5,973
5,966
5,108
Restaurant Costs
6,308
4,471
4,208
5,673
6,047
4,084
5,314
5,139
6,475
64,768
73,146
7,675
8,031
7,616
Gross Cost of Sales
10,286
7,234
7,394
7,241
8,430
5,972
7,677
9,800
13,351
100,708
113,253
GROSS MARGIN
101,070
66,693
105,853
Accommodation Gross Margin
93,103
72,569
82,629
100,116
89,901
84,704
105,287
77,342
67,254
1,046,521
1,172,783
2,249
1,022
2,667
Beverage Gross Margin
2,217
230
414
1,433
1,924
1,745
1,199
1,198
1,067
17,366
15,914
(116)
(1,392)
(896)
Communication Gross Margin
(615)
(763)
(742)
(630)
(647)
(1,044)
(763)
(1,258)
(4,850)
(13,716)
(13,489)
3,587
2,218
1,489
Conference Gross Margin
1,138
622
2,258
676
1,813
1,612
3,355
3,065
1,358
23,190
24,013
75
415
544
Miscellaneous Gross Margin
203
194
(117)
1,331
894
307
144
(12)
(133)
3,846
3
13,457
10,679
6,421
Restaurant Gross Margin
8,296
5,977
10,524
7,270
14,344
10,052
13,313
12,265
9,410
122,008
135,901
120,323
79,635
116,078
Gross Margin
104,341
78,829
94,967
110,195
108,230
97,376
122,535
92,600
74,106
1,199,214
1,335,125
DIRECT COSTS
6,580
2,828
16,085
Other Personnel Expenses
7,779
8,485
1,348
6,425
6,335
9,487
5,833
5,833
5,833
82,850
69,996
Employee Training
59
206
117
1,000
1,382
1,500
Recruitment
105
105
0
137
Uniforms
176
323
635
500
21,269
29,998
23,634
Wages & Salaries
24,987
30,609
29,774
28,245
30,380
29,005
26,649
27,244
20,387
322,180
310,341
27,985
32,825
39,719
Personnel Expenses
32,930
39,475
31,239
34,993
36,715
38,492
33,482
33,077
26,220
407,152
382,337
Page 1 of 4
Printed on 11 Jun 2009 at 10:55 AM
TCSOpForecast
Detailed Forecast for Year to 30 Jun 2008
Acme Motels
Year Total
487
487
Insurance
487
487
518
2,467
0
8,987
7,190
7,190
Rates - General
7,190
8,987
8,987
7,190
7,190
8,987
8,987
7,189
7,189
95,265
93,460
696
556
556
Rates - Water
556
696
696
556
556
696
695
556
556
7,371
7,228
38,462
30,769
30,769
Rental/Lease
30,769
38,462
38,462
30,769
30,769
38,462
37,769
31,461
30,769
407,691
399,996
48,632
39,003
38,516
Property Lease Expenses
39,003
48,632
48,145
38,516
38,516
48,663
47,451
39,206
38,514
512,795
500,684
3,640
2,932
2,901
Electricity
2,334
2,429
4,652
2,257
2,496
2,510
2,690
2,860
31,701
35,000
368
372
281
Gas
240
276
327
327
235
287
326
314
346
3,700
4,000
358
444
341
Waste Removal
326
493
342
341
403
349
400
340
340
4,476
4,500
4,366
3,748
3,522
Utilities Expenses
2,899
770
3,099
5,320
2,895
3,132
3,236
3,344
3,546
39,877
43,500
0
0
(4)
Cashiers Discrepancies
1
13
0
22
4
2
39
0
1,901
2,008
1,081
Cleaning Supplies
1,111
2,489
2,153
2,473
2,345
1,881
2,252
1,546
1,317
22,558
23,500
775
1,191
594
Commission Charge Card
891
619
1,033
980
1,085
757
1,350
1,400
1,200
11,873
17,575
211
Commission Other
22
200
100
100
633
1,775
311
523
57
Commission Travel Agent
406
157
289
380
1,438
529
400
400
400
5,290
5,690
1,085
1,054
879
Equip Rental - Other
1,559
879
879
879
879
367
1,054
1,054
1,054
11,623
12,648
1,203
1,203
1,203
Equip Rental - TV & Sky
1,203
1,203
1,203
1,203
1,231
1,231
1,203
1,203
1,203
14,489
14,436
4
5
Guest Checkin Beverage
60
30
25
124
500
Laundry
100
100
100
300
1,200
260
Low Value Assets
260
0
119
120
250
Newspapers for Guests
71
171
138
182
162
138
350
200
150
2,051
3,200
613
60
185
Printing & Stationery
139
1,013
783
106
657
70
300
700
400
5,026
5,500
29
215
Repl - China Glass Silverware
230
108
100
100
100
882
1,000
105
34
Repl - Kitchen Utensils
124
18
9
100
100
100
589
1,000
Repl - Linen (Restaurant)
110
925
100
100
100
1,335
1,000
Repl - Sheets/Slips
1,225
185
250
250
250
2,159
3,000
Repl - Towels
48
250
250
250
798
3,000
307
667
Repl - Unit Contents
262
1,491
153
1,000
1,000
1,000
5,879
10,000
597
1,328
1,878
Repairs & Maintenance
1,659
1,192
2,745
1,379
2,396
4,293
3,445
3,445
3,445
27,803
39,820
6,945
7,811
7,295
Other Costs
8,865
8,785
9,223
7,712
11,777
9,616
12,514
11,978
11,194
113,714
144,844
87,928
83,387
89,051
Direct Costs
83,697
97,661
91,704
86,540
89,903
99,904
96,683
87,605
79,474
1,073,538
1,071,365
32,394
(3,752)
27,027
Net Income
20,644
(18,832)
3,263
23,655
18,327
(2,528)
25,852
4,995
(5,368)
125,676
263,760
Page 2 of 4
Printed on 11 Jun 2009 at 10:55 AM
TCSOpForecast
Detailed Forecast for Year to 30 Jun 2008
Acme Motels
Year Total
483
Internet Ads
710
483
85
56
1,818
0
483
Sales & Mkting - Internet
710
483
85
56
1,818
0
380
Other Marketing
100
2,400
500
300
750
750
750
5,930
9,000
Promotions
200
200
0
380
Sales & Mkting - Other
300
2,400
500
300
750
750
750
6,130
9,000
75
75
75
Telephone Book Ads
121
36
36
81
499
0
75
75
75
Sales & Mkting - Phonebook
121
36
36
81
499
0
150
150
Brochures
300
1,500
1,197
Magazine Ads
1,197
0
Magazine Ads
550
550
550
2,300
3,950
5,500
Newspaper Ads
283
50
50
50
433
500
1,347
150
Sales & Mkting - Print Media
283
550
550
550
50
2,350
50
5,880
7,500
Radio Ads
1,590
700
700
700
3,690
8,000
Sales & Mkting - TV/Radio
1,590
700
700
700
3,690
8,000
377
ACC Levy
377
377
377
377
377
377
4,540
7,180
4,540
56
830
Accounting Fees
1,070
1,000
275
275
275
3,781
5,500
Bad Debts
1,644
1,644
0
18
18
16
Bank Charges
18
18
60
27
18
18
55
55
55
373
650
181
1,861
1,206
Computer Related Costs
648
188
788
188
408
1,508
300
1,200
600
9,076
6,000
20
Donations
35
55
0
15
154
General Expenses
654
15
10
7
175
200
200
200
1,630
2,000
315
Health & Safety
3
331
190
196
255
979
300
300
300
3,169
3,000
1,374
1,099
2,074
Insurance - Overhead
1,099
1,374
1,374
2,074
1,099
1,892
1,600
1,800
1,600
18,459
20,500
1,302
1,345
1,347
Interest
1,346
1,303
1,302
1,346
1,345
1,259
1,275
1,300
1,300
15,769
15,500
23
Interest - Other
23
23
26
23
23
23
164
0
IRD Late Payment Penalty
40
40
0
Professional Services
90
90
0
690
89
Subscriptions
222
400
300
550
2,251
1,500
60
239
Vehicle Expenses
450
75
34
225
139
225
225
225
1,897
2,500
2,945
5,247
6,517
Overhead Costs - Admin
3,963
4,433
4,428
5,536
3,566
9,012
4,630
5,655
9,645
65,578
61,690
Page 3 of 4
Printed on 11 Jun 2009 at 10:55 AM
TCSOpForecast
Detailed Forecast for Year to 30 Jun 2008
Acme Motels
Year Total
Depreciation - Chattels
4,600
4,600
4,600
13,800
55,200
Depreciation
4,600
4,600
4,600
13,800
55,200
28,890
(10,421)
19,905
Trading Profit
16,380
(23,386)
(2,194)
14,649
13,625
(14,117)
15,122
(9,060)
(21,113)
28,280
122,370
50
22
23
Interest Income
21
34
37
41
34
39
50
30
30
410
500
107
Commission Received - NZI
107
100
313
500
(50)
(128)
(23)
NonTrading Income
(21)
(34)
(37)
(41)
(34)
(145)
(50)
(30)
(130)
(723)
(1,000)
28,940
(10,293)
19,928
Profit Before Tax
16,402
(23,352)
(2,157)
14,690
13,659
(13,972)
15,172
(9,030)
(20,983)
29,003
123,370
28,940
(10,293)
19,928
Profit After Tax
16,402
(23,352)
(2,157)
14,690
13,659
(13,972)
15,172
(9,030)
(20,983)
29,003
123,370
Page 4 of 4
Printed on 11 Jun 2009 at 10:55 AM