Row definition example in Management Reporter

The following tables show the budget forecast Excel files for San Francisco, Denver, and Corporate Headquarters of Fabrikam, Inc. The row definition excerpt that is shown after the Excel files link to the Excel files to report total compensation expenses.

Budget forecast for San Francisco.

A

B

C

D

E

F

G

H

I

J

K

L

M

N

1

Fabrikam Works, Inc.

2

Budget - San Francisco

3

4

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Total

5

Sales

202,941

207,000

211,140

215,363

219,670

224,063

228,545

233,115

237,778

242,533

247,384

252,332

2,721,864

6

Sales Returns

(3,521)

(3,591)

(3,663)

(3,737)

(3,811)

(3,887)

(3,965)

(4,045)

(4,125)

(4,208)

(4,292)

(4,378)

(47,223)

7

Sales Discounts

(11,737)

(11,972)

(12,211)

(12,455)

(12,705)

(12,959)

(13,218)

(13,482)

(13,752)

(14,027)

(14,307)

(14,593)

(157,418)

8

Total Sales

187,683

191,437

195,265

199,171

203,154

207,217

211,362

215,589

219,901

224,299

228,785

233,360

2,517,223

9

10

Cost of Goods Sold

116,500

118,830

121,207

123,631

126,103

128,625

131,198

133,822

136,498

139,228

142,013

144,853

1,562,508

11

Gross Profit

71,183

72,607

74,059

75,540

77,051

78,592

80,164

81,767

83,402

85,070

86,772

88,507

954,714

12

13

Salary Expense

30,910

31,528

30,000

30,000

30,000

30,000

30,000

30,000

31,000

31,000

31,000

31,000

366,438

14

Commissions Expense

11,524

11,754

10,000

10,000

10,000

10,000

10,000

10,000

11,000

11,000

11,000

11,000

127,278

15

Total Compensation

42,434

43,282

40,000

40,000

40,000

40,000

40,000

40,000

42,000

42,000

42,000

42,000

493,716

16

17

Depreciation

2,500

2,550

2,601

2,653

2,706

2,760

2,815

2,872

2,929

2,988

3,047

3,108

33,529

18

Office Expense

1,841

1,878

1,915

1,954

1,993

2,033

2,073

2,115

2,157

2,200

2,244

2,289

24,692

19

Supplies

315

321

328

334

341

348

355

362

369

376

384

392

4,225

20

Maintenance

620

632

645

658

671

685

698

712

726

741

756

771

8,315

21

Rent

4,500

4,590

4,682

4,775

4,871

4,968

5,068

5,169

5,272

5,378

5,485

5,595

60,353

22

Travel

4,075

4,157

4,240

4,324

4,411

4,499

4,589

4,681

4,775

4,870

4,967

5,067

54,655

23

Advertising

3,359

3,426

3,495

3,565

3,636

3,709

3,783

3,858

3,936

4,014

4,095

4,176

45,052

24

Total Other G&A

17,210

17,554

17,906

18,263

18,629

19,002

19,381

19,769

20,164

20,567

20,978

21,398

230,821

25

26

Before Tax Income

11,539

11,770

12,005

12,245

12,490

12,740

12,995

13,255

13,520

13,790

14,066

14,347

143,223

Budget forecast for Denver.

A

B

C

D

E

F

G

H

I

J

K

L

M

N

1

Fabrikam Works, Inc.

2

Budget - Denver

3

4

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Total

5

Sales

230,008

234,608

239,300

244,086

248,968

253,947

259,026

264,207

269,491

274,881

280,378

285,986

3,084,886

6

Sales Returns

(3,850)

(3,927)

(4,006)

(4,086)

(4,167)

(4,251)

(4,336)

(4,422)

(4,511)

(4,601)

(4,693)

(4,787)

(51,637)

7

Sales Discounts

(12,832)

(13,089)

(13,350)

(13,617)

(13,890)

(14,168)

(14,451)

(14,740)

(15,035)

(15,335)

(15,642)

(15,955)

(172,104)

8

Total Sales

213,326

217,593

221,944

226,383

230,911

235,529

240,240

245,045

249,945

254,944

260,043

265,244

2,861,147

9

10

Cost of Goods Sold

123,700

126,174

128,697

131,271

133,897

136,575

139,306

142,092

144,934

147,833

150,790

153,805

1,659,075

11

Gross Profit

89,626

91,419

93,247

95,112

97,014

98,954

100,934

102,953

105,011

107,111

109,253

111,439

1,202,073

12

13

Salary Expense

35,800

36,516

35,000

35,000

35,000

35,000

35,000

36,000

36,000

36,000

36,000

36,000

427,316

14

Commissions Expense

13,972

14,251

12,000

12,000

12,000

12,000

12,000

13,000

13,000

13,000

13,000

13,000

153,223

15

Total Compensation

49,772

50,767

47,000

47,000

47,000

47,000

47,000

49,000

49,000

49,000

49,000

49,000

580,539

16

17

Depreciation

2,355

2,402

2,450

2,499

2,549

2,600

2,652

2,705

2,759

2,814

2,871

2,928

31,584

18

Office Expense

1,782

1,818

1,854

1,891

1,929

1,967

2,007

2,047

2,088

2,130

2,172

2,216

23,901

19

Supplies

350

357

364

371

379

386

394

402

410

418

427

435

4,693

20

Maintenance

550

561

572

584

595

607

619

632

644

657

670

684

7,375

21

Rent

4,675

4,769

4,864

4,961

5,060

5,162

5,265

5,370

5,478

5,587

5,699

5,813

62,703

22

Travel

3,700

3,774

3,849

3,926

4,005

4,085

4,167

4,250

4,335

4,422

4,510

4,600

49,623

23

Advertising

3,666

3,739

3,814

3,890

3,968

4,048

4,129

4,211

4,295

4,381

4,469

4,558

49,168

24

Total Other G&A

17,078

17,420

17,767

18,122

18,485

18,855

19,233

19,617

20,009

20,409

20,818

21,234

229,047

25

26

Before Tax Income

22,776

23,231

23,696

24,170

24,653

25,146

25,649

26,162

26,686

27,219

27,764

28,320

305,472

Budget forecast for Corporate Headquarters.

A

B

C

D

E

F

G

H

I

J

K

L

M

N

1

Fabrikam Works, Inc.

2

Budget - Denver

3

4

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Total

5

Officers' Compensation

25,000

25,250

25,503

25,758

26,015

26,275

26,538

26,803

27,071

27,342

27,616

27,892

317,063

6

7

Other G&A Expense

2,000

2,020

2,040

2,061

2,081

2,102

2,123

2,144

2,166

2,187

2,209

2,231

25,364

8

9

Interest Income

228

230

233

235

237

240

242

244

247

249

252

254

2,891

10

Interest Expense

1,125

1,136

1,148

1,159

1,171

1,182

1,194

1,206

1,218

1,230

1,243

1,255

14,267

11

Total Other Income/(Expense)

(897)

(906)

(915)

(924)

(934)

(942)

(952)

(962)

(971)

(981)

(991)

(1,001)

(11,376)

12

13

Net Income Before Tax

(27,897)

(28,176)

(28,458)

(28,742)

(29,030)

(29,320)

(29,613)

(29,909)

(30,208)

(30,511)

(30,816)

(31,124)

(353,804)

The following table shows example rows from the row definition that links the San Francisco, Denver, and Corporate Headquarters external worksheet files.

Description

Normal Balance

Link to Financial Data Source

Link to Worksheet Req Link

Link to Worksheet HQ Link

Gross Sales

C

(410?-4109)

A5/CPO

Returns

C

4110

A6/CPO

Discounts

C

4250

A7/CPO

Compensation Expense

5000+(5050)+(5400)

A15/CPO

A5/CPO

In this row definition, the Link to Worksheet Req Link column links with the San Francisco and Denver external worksheet files, and the Link to Worksheet HQ Link column links with the Corporate Headquarters external worksheet file. In the previous tables, row 14 (the Compensation Expense row) in the row definition links to row 15 (the Total Comp row) in the San Francisco and Denver external worksheet files and row 5 (the Officers' Comp row) in the Corporate Headquarters external worksheet file. The San Francisco and Denver spreadsheets each require only one link, because they have identical external worksheet files. The Corporate Headquarters spreadsheet requires a separate Link column because it has a different external worksheet file.

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×