TCSOpBudget
Summary Budget for Year to 30 Jun 2008
Acme Motels
Jul 07
Aug 07
Sep 07
Oct 07
Nov 07
Dec 07
Jan 08
Feb 08
Mar 08
Apr 08
May 08
Jun 08
Year Total
%NI
GROSS MARGIN
123,259
107,422
135,891
Gross Sales
114,841
111,881
113,984
153,248
124,534
143,249
130,212
102,400
87,457
1,448,378
549
9,192
6,927
9,383
Gross Cost of Sales
9,744
6,966
7,970
8,404
8,556
15,283
7,677
9,800
13,351
113,253
42
114,067
100,495
126,508
Gross Margin
105,097
104,915
106,014
144,844
115,978
127,966
122,535
92,600
74,106
1,335,125
506
DIRECT COSTS
31,234
34,048
27,418
Personnel Expenses
31,603
27,382
34,608
38,022
31,534
33,709
33,482
33,077
26,220
382,337
145
48,143
38,514
38,514
Property Lease Expenses
38,514
38,514
48,143
48,143
38,514
38,514
47,451
39,206
38,514
500,684
189
3,484
3,936
3,814
Utilities Expenses
5,864
3,006
3,496
3,084
2,856
3,834
3,236
3,344
3,546
43,500
16
12,290
12,022
10,336
Other Costs
11,423
12,553
12,219
13,915
12,637
11,763
12,514
11,978
11,194
144,844
54
95,151
88,520
80,082
Direct Costs
87,404
81,455
98,466
103,164
85,541
87,820
96,683
87,605
79,474
1,071,365
406
18,916
11,975
46,426
Net Income
17,693
23,460
7,548
41,680
30,437
40,146
25,852
4,995
(5,368)
263,760
100
OVERHEAD COSTS
750
750
750
Sales & Mkting - Other
750
750
750
750
750
750
750
750
750
9,000
3
1,500
50
Sales & Mkting - Print Media
50
50
50
50
50
3,250
50
2,350
50
7,500
2
350
350
350
Sales & Mkting - TV/Radio
950
950
350
950
950
700
700
700
700
8,000
3
2,600
1,100
1,150
Overhead Costs - Marketing
1,750
1,750
1,150
1,750
1,750
4,700
1,500
3,800
1,500
24,500
9
4,075
4,825
6,280
Overhead Costs - Admin
4,330
4,280
4,480
5,055
4,255
4,180
4,630
5,655
9,645
61,690
23
4,600
4,600
4,600
Depreciation
4,600
4,600
4,600
4,600
4,600
4,600
4,600
4,600
4,600
55,200
20
11,275
10,525
12,030
Overhead Costs
10,680
10,630
10,230
11,405
10,605
13,480
10,730
14,055
15,745
141,390
53
7,641
1,450
34,396
Trading Profit
7,013
12,830
(2,682)
30,275
19,832
26,666
15,122
(9,060)
(21,113)
122,370
46
(140)
(40)
(40)
NonTrading Income
(40)
(50)
(140)
(150)
(40)
(150)
(50)
(30)
(130)
(1,000)
0.4
7,781
1,490
34,436
Profit Before Tax
7,053
12,880
(2,542)
30,425
19,872
26,816
15,172
(9,030)
(20,983)
123,370
46
7,781
1,490
34,436
Profit After Tax
7,053
12,880
(2,542)
30,425
19,872
26,816
15,172
(9,030)
(20,983)
123,370
46
Page 1 of 1
Printed on 11 Jun 2009 at 10:29 AM