Crystal Report Viewer

TCSOpBudget

Detailed 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

OPERATING REVENUE

97,610

88,266

115,862

Accommodation Sales

93,426

93,113

91,200

133,028

98,389

112,006

105,287

77,342

67,254

1,172,783

444

3,741

2,087

2,275

Beverage Sales

2,329

2,703

2,341

2,324

2,452

3,132

2,217

2,878

2,528

31,007

197

217

357

Communication Sales

211

313

309

283

323

555

173

335

233

3,506

2,080

2,681

2,402

Conference Sales

2,380

1,616

1,791

726

1,599

2,911

3,355

4,110

1,358

27,009

260

365

319

Miscellaneous Income

376

509

345

610

595

564

553

331

199

5,026

19,371

13,806

14,676

Restaurant Sales

16,119

13,627

17,998

16,277

21,176

24,081

18,627

17,404

15,885

209,047

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

OPERATING COSTS

1,206

1,010

1,089

Beverage Costs

1,505

1,427

1,063

697

1,495

1,442

1,018

1,680

1,461

15,093

291

1,181

2,108

Communication Costs

1,067

771

1,073

989

1,903

936

1,593

5,083

16,995

189

162

Conference Costs

127

189

1,193

1,045

2,996

357

414

265

Miscellaneous Cost of Sales

431

337

317

444

751

623

409

343

332

5,023

7,149

4,231

5,759

Restaurant Costs

6,741

4,304

5,328

6,274

6,310

10,122

5,314

5,139

6,475

73,146

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

GROSS MARGIN

97,610

88,266

115,862

Accommodation Gross Margin

93,426

93,113

91,200

133,028

98,389

112,006

105,287

77,342

67,254

1,172,783

444

2,535

1,077

1,186

Beverage Gross Margin

824

1,276

1,278

1,627

957

1,690

1,199

1,198

1,067

15,914

(94)

(964)

(1,751)

Communication Gross Margin

(856)

(458)

(764)

(706)

323

(1,348)

(763)

(1,258)

(4,850)

(13,489)

5.1

1,891

2,590

2,240

Conference Gross Margin

2,380

1,489

1,602

726

1,599

1,718

3,355

3,065

1,358

24,013

(97)

(49)

Miscellaneous Gross Margin

(55)

172

166

(156)

(59)

144

(12)

(133)

0.0

12,222

9,575

8,917

Restaurant Gross Margin

9,378

9,323

12,670

10,003

14,866

13,959

13,313

12,265

9,410

135,901

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

5,833

Other Personnel Expenses

5,833

69,996

Employee Training

500

1,000

1,500

300

Uniforms

200

500

25,101

28,215

21,585

Wages & Salaries

25,770

21,549

28,775

32,189

25,501

27,376

26,649

27,244

20,387

310,341

117

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

8,987

7,189

Rates - General

7,189

8,987

7,189

8,987

7,189

93,460

695

556

Rates - Water

556

695

556

695

556

7,228

Page 1 of 3

Printed on 11 Jun 2009 at 10:29 AM

TCSOpBudget

Detailed 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

38,461

30,769

Rental/Lease

30,769

38,461

30,769

37,769

31,461

30,769

399,996

151

48,143

38,514

Property Lease Expenses

38,514

48,143

38,514

47,451

39,206

38,514

500,684

189

2,840

3,380

2,970

Electricity

5,100

2,340

2,610

2,390

2,280

3,030

2,510

2,690

2,860

35,000

304

226

444

Gas

364

266

526

354

226

304

326

314

346

4,000

340

330

400

Waste Removal

400

360

340

350

500

400

340

4,500

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

2,268

2,075

1,279

Cleaning Supplies

1,641

1,956

2,922

3,183

1,825

1,236

2,252

1,546

1,317

23,500

1,475

1,500

1,150

Commission Charge Card

1,300

2,100

1,150

1,200

2,150

1,600

1,350

1,400

1,200

17,575

100

Commission Other

100

275

250

200

100

1,775

630

480

440

Commission Travel Agent

280

580

280

1,000

400

5,690

1,054

Equip Rental - Other

1,054

12,648

1,203

Equip Rental - TV & Sky

1,203

14,436

Guest Checkin Beverage

500

100

Laundry

100

1,200

300

250

150

Newspapers for Guests

300

150

350

400

300

350

200

150

3,200

550

650

250

Printing & Stationery

650

500

450

500

150

400

300

700

400

5,500

Repl - China Glass Silverware

100

1,000

Repl - Kitchen Utensils

100

1,000

Repl - Linen (Restaurant)

100

1,000

250

Repl - Sheets/Slips

250

3,000

250

Repl - Towels

250

3,000

700

Repl - Unit Contents

700

800

1,000

10,000

3,240

Repairs & Maintenance

3,245

3,240

3,345

3,445

39,820

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

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

750

Other Marketing

750

9,000

750

Sales & Mkting - Other

750

9,000

1,500

Brochures

1,500

Magazine Ads

3,200

2,300

5,500

Newspaper Ads

500

Page 2 of 3

Printed on 11 Jun 2009 at 10:29 AM

TCSOpBudget

Detailed 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

1,500

Sales & Mkting - Print Media

3,250

2,350

7,500

350

Radio Ads

950

350

950

700

8,000

350

Sales & Mkting - TV/Radio

950

350

950

700

8,000

ACC Levy

4,540

275

2,475

Accounting Fees

275

5,500

Bank Charges

650

300

Computer Related Costs

450

500

300

1,000

500

250

300

1,200

600

6,000

150

General Expenses

150

200

2,000

200

Health & Safety

300

200

300

200

300

3,000

1,600

2,100

1,600

Insurance - Overhead

1,600

1,900

1,600

1,800

1,600

20,500

1,300

Interest

1,300

1,275

1,300

15,500

250

Subscriptions

400

300

550

1,500

200

Vehicle Expenses

200

225

2,500

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

4,600

Depreciation - Chattels

4,600

55,200

4,600

Depreciation

4,600

55,200

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

Interest Income

500

100

Commission Received - NZI

100

500

(140)

(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

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

Page 3 of 3

Printed on 11 Jun 2009 at 10:29 AM