KODEMEDIA

Detailed Expense Estimates

Planned Expenses Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YEAR

Employee Costs Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YEAR

Wages Rp 85,000 Rp 85,000 Rp 85,000 Rp 87,500 Rp 87,500 Rp 87,500 Rp 87,500 Rp 92,400 Rp 92,400 Rp 92,400 Rp 92,400 Rp 92,400 Rp 1,067,000

Benefits Rp 22,950 Rp 22,950 Rp 22,950 Rp 23,625 Rp 23,625 Rp 23,625 Rp 23,625 Rp 24,948 Rp 24,948 Rp 24,948 Rp 24,948 Rp 24,948 Rp 288,090

Subtotal Rp 107,950 Rp 107,950 Rp 107,950 Rp 111,125 Rp 111,125 Rp 111,125 Rp 111,125 Rp 117,348 Rp 117,348 Rp 117,348 Rp 117,348 Rp 117,348 Rp 1,355,090

Office Costs Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YEAR

Office lease Rp 9,800 Rp 9,800 Rp 9,800 Rp 9,800 Rp 9,800 Rp 9,800 Rp 9,800 Rp 9,800 Rp 9,800 Rp 9,800 Rp 9,800 Rp 9,800 Rp 117,600

Gas Rp 400 Rp 400 Rp 100 Rp 100 Rp 100 Rp 100 Rp 100 Rp 100 Rp 100 Rp 400 Rp 400 Rp 2,300

Electric Rp 300 Rp 300 Rp 300 Rp 300 Rp 300 Rp 300 Rp 300 Rp 300 Rp 300 Rp 300 Rp 300 Rp 300 Rp 3,600

Water Rp 40 Rp 40 Rp 40 Rp 40 Rp 40 Rp 40 Rp 40 Rp 40 Rp 40 Rp 40 Rp 40 Rp 40 Rp 480

Telephone Rp 250 Rp 250 Rp 250 Rp 250 Rp 250 Rp 250 Rp 250 Rp 250 Rp 250 Rp 250 Rp 250 Rp 250 Rp 3,000

Internet access Rp 180 Rp 180 Rp 180 Rp 180 Rp 180 Rp 180 Rp 180 Rp 180 Rp 180 Rp 180 Rp 180 Rp 180 Rp 2,160

Office supplies Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 2,400

Security Rp 600 Rp 600 Rp 600 Rp 600 Rp 600 Rp 600 Rp 600 Rp 600 Rp 600 Rp 600 Rp 600 Rp 600 Rp 7,200

Subtotal Rp 11,370 Rp 11,770 Rp 11,770 Rp 11,470 Rp 11,470 Rp 11,470 Rp 11,470 Rp 11,470 Rp 11,470 Rp 11,470 Rp 11,770 Rp 11,770 Rp 138,740

Marketing Costs Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YEAR

Web site hosting Rp 500 Rp 500 Rp 500 Rp 500 Rp 500 Rp 500 Rp 500 Rp 500 Rp 500 Rp 500 Rp 500 Rp 500 Rp 6,000

Web site updates Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 1,000 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 1,000 Rp 4,000

Collateral preparation Rp 5,000 Rp - Rp - Rp 5,000 Rp - Rp - Rp 5,000 Rp - Rp - Rp 5,000 Rp - Rp - Rp 20,000

Collateral printing Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 2,400

Marketing events Rp 2,000 Rp 2,000 Rp 2,000 Rp 5,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 5,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 5,000 Rp 33,000

Miscellaneous expenses Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 2,400

Subtotal Rp 8,100 Rp 3,100 Rp 3,100 Rp 11,100 Rp 3,100 Rp 3,900 Rp 8,100 Rp 6,100 Rp 3,100 Rp 8,100 Rp 3,100 Rp 6,900 Rp 67,800

Training/Travel Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YEAR

Training classes Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 24,000

Training-related travel costs Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 24,000

Subtotal Rp 4,000 Rp 4,000 Rp 4,000 Rp 4,000 Rp 4,000 Rp 4,000 Rp 4,000 Rp 4,000 Rp 4,000 Rp 4,000 Rp 4,000 Rp 4,000 Rp 48,000

TOTALS

Monthly Planned Expenses Rp 131,420 Rp 126,820 Rp 126,820 Rp 137,695 Rp 129,695 Rp 130,495 Rp 134,695 Rp 138,918 Rp 135,918 Rp 140,918 Rp 136,218 Rp 140,018 Rp 1,609,630

TOTAL Planned Expenses Rp 131,420 Rp 258,240 Rp 385,060 Rp 522,755 Rp 652,450 Rp 782,945 Rp 917,640 Rp 1,056,558 Rp 1,192,476 Rp 1,333,394 Rp 1,469,612 Rp 1,609,630

Page 1 of 4
KODEMEDIA
Detailed Expense Estimates
Shaded cells are calculations.

Actual Expenses Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YEAR

Employee Costs Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YEAR

Wages Rp 85,000 Rp 85,000 Rp 85,000 Rp 88,000 Rp 88,000 Rp 88,000 Rp 519,000

Benefits Rp 22,950 Rp 22,950 Rp 22,950 Rp 23,760 Rp 23,760 Rp 23,760 Rp - Rp - Rp - Rp - Rp - Rp - Rp 140,130

Subtotal Rp 107,950 Rp 107,950 Rp 107,950 Rp 111,760 Rp 111,760 Rp 111,760 Rp - Rp - Rp - Rp - Rp - Rp - Rp 659,130

Office Costs Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YEAR

Office lease Rp 9,800 Rp 9,800 Rp 9,800 Rp 9,800 Rp 9,800 Rp 9,800 Rp 58,800

Gas Rp 4 Rp 430 Rp 385 Rp 230 Rp 87 Rp 88 Rp 1,224

Electric Rp 288 Rp 278 Rp 268 Rp 299 Rp 306 Rp 290 Rp 1,729

Water Rp 35 Rp 33 Rp 34 Rp 36 Rp 34 Rp 36 Rp 208

Telephone Rp 224 Rp 235 Rp 265 Rp 245 Rp 245 Rp 220 Rp 1,434

Internet access Rp 180 Rp 180 Rp 180 Rp 180 Rp 180 Rp 180 Rp 1,080

Office supplies Rp 256 Rp 142 Rp 160 Rp 221 Rp 256 Rp 240 Rp 1,275

Security Rp 600 Rp 600 Rp 600 Rp 600 Rp 600 Rp 600 Rp 3,600

Subtotal Rp 11,387 Rp 11,698 Rp 11,692 Rp 11,611 Rp 11,508 Rp 11,454 Rp - Rp - Rp - Rp - Rp - Rp - Rp 69,350

Marketing Costs Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YEAR

Web site hosting Rp 500 Rp 500 Rp 500 Rp 500 Rp 500 Rp 500 Rp 3,000

Web site updates Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 1,500 Rp 2,500

Collateral preparation Rp 4,800 Rp - Rp - Rp 5,500 Rp - Rp - Rp 10,300

Collateral printing Rp 100 Rp 500 Rp 100 Rp 100 Rp 600 Rp 180 Rp 1,580

Marketing events Rp 1,800 Rp 2,200 Rp 2,200 Rp 4,700 Rp 1,500 Rp 2,300 Rp 14,700

Miscellaneous expenses Rp 145 Rp 156 Rp 123 Rp 223 Rp 187 Rp 245 Rp 1,079

Subtotal Rp 7,545 Rp 3,556 Rp 3,123 Rp 11,223 Rp 2,987 Rp 4,725 Rp - Rp - Rp - Rp - Rp - Rp - Rp 33,159

Training/Travel Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YEAR

Training classes Rp 1,600 Rp 2,400 Rp 1,400 Rp 1,600 Rp 1,200 Rp 2,800 Rp 11,000

Training-related travel costs Rp 1,200 Rp 2,200 Rp 1,400 Rp 1,200 Rp 800 Rp 3,500 Rp 10,300

Subtotal Rp 2,800 Rp 4,600 Rp 2,800 Rp 2,800 Rp 2,000 Rp 6,300 Rp - Rp - Rp - Rp - Rp - Rp - Rp 21,300

TOTAL Planned Expenses

Monthly Actual Expenses Rp 129,682 Rp 127,804 Rp 125,565 Rp 137,394 Rp 128,255 Rp 134,239 Rp - Rp - Rp - Rp - Rp - Rp - Rp 782,939

TOTAL Actual Expenses Rp 129,682 Rp 257,486 Rp 383,051 Rp 520,445 Rp 648,700 Rp 782,939 Rp 782,939 Rp 782,939 Rp 782,939 Rp 782,939 Rp 782,939 Rp 782,939

Page 2 of 4
KODEMEDIA
Detailed Expense Estimates
All cells are calculations.

Expense Variances Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YEAR

Employee Costs Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YEAR

Wages Rp - Rp - Rp - -Rp 500 -Rp 500 -Rp 500 Rp 87,500 Rp 92,400 Rp 92,400 Rp 92,400 Rp 92,400 Rp 92,400 Rp 548,000

Benefits Rp - Rp - Rp - -Rp 135 -Rp 135 -Rp 135 Rp 23,625 Rp 24,948 Rp 24,948 Rp 24,948 Rp 24,948 Rp 24,948 Rp 147,960

Subtotal Rp - Rp - Rp - -Rp 635 -Rp 635 -Rp 635 Rp 111,125 Rp 117,348 Rp 117,348 Rp 117,348 Rp 117,348 Rp 117,348 Rp 695,960

Office Costs Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YEAR

Office lease Rp - Rp - Rp - Rp - Rp - Rp - Rp 9,800 Rp 9,800 Rp 9,800 Rp 9,800 Rp 9,800 Rp 9,800 Rp 58,800

Gas -Rp 4 -Rp 30 Rp 15 -Rp 130 Rp 13 Rp 12 Rp 100 Rp 100 Rp 100 Rp 100 Rp 400 Rp 400 Rp 1,076

Electric Rp 12 Rp 22 Rp 32 Rp 1 -Rp 6 Rp 10 Rp 300 Rp 300 Rp 300 Rp 300 Rp 300 Rp 300 Rp 1,871

Water Rp 5 Rp 7 Rp 6 Rp 4 Rp 6 Rp 4 Rp 40 Rp 40 Rp 40 Rp 40 Rp 40 Rp 40 Rp 272

Telephone Rp 26 Rp 15 -Rp 15 Rp 5 Rp 5 Rp 30 Rp 250 Rp 250 Rp 250 Rp 250 Rp 250 Rp 250 Rp 1,566

Internet access Rp - Rp - Rp - Rp - Rp - Rp - Rp 180 Rp 180 Rp 180 Rp 180 Rp 180 Rp 180 Rp 1,080

Office supplies -Rp 56 Rp 58 Rp 40 -Rp 21 -Rp 56 -Rp 40 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 1,125

Security Rp - Rp - Rp - Rp - Rp - Rp - Rp 600 Rp 600 Rp 600 Rp 600 Rp 600 Rp 600 Rp 3,600

Subtotal -Rp 17 Rp 72 Rp 78 -Rp 141 -Rp 38 Rp 16 Rp 11,470 Rp 11,470 Rp 11,470 Rp 11,470 Rp 11,770 Rp 11,770 Rp 69,390

Marketing Costs Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YEAR

Web site hosting Rp - Rp - Rp - Rp - Rp - Rp - Rp 500 Rp 500 Rp 500 Rp 500 Rp 500 Rp 500 Rp 3,000

Web site updates Rp - Rp - Rp - Rp - Rp - -Rp 500 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 1,000 Rp 1,500

Collateral preparation Rp 200 Rp - Rp - -Rp 500 Rp - Rp - Rp 5,000 Rp - Rp - Rp 5,000 Rp - Rp - Rp 9,700

Collateral printing Rp 100 -Rp 300 Rp 100 Rp 100 -Rp 400 Rp 20 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 820

Marketing events Rp 200 -Rp 200 -Rp 200 Rp 300 Rp 500 -Rp 300 Rp 2,000 Rp 5,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 5,000 Rp 18,300

Miscellaneous expenses Rp 55 Rp 44 Rp 77 -Rp 23 Rp 13 -Rp 45 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 200 Rp 1,321

Subtotal Rp 555 -Rp 456 -Rp 23 -Rp 123 Rp 113 -Rp 825 Rp 8,100 Rp 6,100 Rp 3,100 Rp 8,100 Rp 3,100 Rp 6,900 Rp 34,641

Training/Travel Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YEAR

Training classes Rp 400 -Rp 400 Rp 600 Rp 400 Rp 800 -Rp 800 Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 13,000

Training-related travel costs Rp 800 -Rp 200 Rp 600 Rp 800 Rp 1,200 -Rp 1,500 Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 2,000 Rp 13,700

Subtotal Rp 1,200 -Rp 600 Rp 1,200 Rp 1,200 Rp 2,000 -Rp 2,300 Rp 4,000 Rp 4,000 Rp 4,000 Rp 4,000 Rp 4,000 Rp 4,000 Rp 26,700

TOTALS

Monthly Expense Variances Rp 1,738 -Rp 984 Rp 1,255 Rp 301 Rp 1,440 -Rp 3,744 Rp 134,695 Rp 138,918 Rp 135,918 Rp 140,918 Rp 136,218 Rp 140,018 Rp 826,691

TOTAL Expense Variances Rp 1,738 Rp 754 Rp 2,009 Rp 2,310 Rp 3,750 Rp 6 Rp 134,701 Rp 273,619 Rp 409,537 Rp 550,455 Rp 686,673 Rp 826,691

Page 3 of 4
KODEMEDIA
Detailed Expense Estimates

Expense Category Planned Expenses Actual Expenses Expense Variances Variance Percentage
Employee Costs Rp 1,355,090 Rp 659,130 Rp 695,960 51%
Office Costs Rp 138,740 Rp 69,350 Rp 69,390 50%
Marketing Costs Rp 67,800 Rp 33,159 Rp 34,641 51%
Training/Travel Rp 48,000 Rp 21,300 Rp 26,700 56%
TOTALS Rp 1,609,630 Rp 782,939 Rp 826,691 51%

Planned Expenses Actual Expenses

Office Costs; Office Costs;

8.62% 8.86%
Marketing Marketing
Employee Costs; 4.21% Employee Costs; 4.24%
Costs; 84.19% Training/Trav Costs; 84.19% Training/Trav
el; 2.98% el; 2.72%

Employee Costs Office Costs Employee Costs Office Costs

Marketing Costs Training/Travel Marketing Costs Training/Travel

Monthly Expenses
Rp160,000

Rp140,000

Rp120,000

Rp100,000

Rp80,000
Expenses

Rp60,000

Rp40,000

Rp20,000

Rp-
1 2 3 4 5 6 7 8 9 10 11 12

-Rp20,000

Month

Planned Actual Variance