Docstoc

Media Billing Performance Excel Template

Document Sample
Media Billing Performance Excel Template Powered By Docstoc
					Monthly Media Billing Performance Reporting FY '07 YTD
Monthly Net Billing YTD
Period 1st Quarter FY'07 July August September October November December January February March April May June $ $ $ $ $ $ $ Total $$ Billed 6,444,180.79 5,528,010.04 5,286,344.74 10,735,912.42 9,981,266.33 10,101,208.05 18,047,841.57 $ $ $ $ $ $ $ Total $$ Held 107,977.85 109,571.58 79,411.19 460,992.21 (34,914.23) 45,040.60 641,898.89 $ $ $ $ $ $ $ Total Billing Sent 6,336,202.94 5,418,438.46 5,206,933.55 10,274,920.21 10,016,180.56 10,056,167.45 17,405,942.68 $ $ $ $ $ $ Total $$ Approved 6,253,253.57 5,138,396.38 5,187,693.96 7,875,082.35 9,997,941.93 10,015,908.12 Approval % 98.69% 94.83% 99.63% 76.64% 99.82% 99.60% Total $$ Rejected $ 82,949.37 $ 280,042.08 $ 19,239.59 $ 2,399,837.86 $ 18,238.63 $ 40,259.33 Rejection % 1.31% 5.17% 0.37% 23.36% 0.18% 0.40%

2nd Quarter

3rd Quarter

4th Quarter

Monthly Invoice Volume YTD
Period 1st Quarter FY'07 July August September October November December January February March April May June Total Invoices 357 247 218 267 281 216 394 Invoices Held 40 31 30 21 41 45 51 Total Invoices Sent 317 217 188 246 240 171 343 Line Items Sent 468 412 265 421 334 219 639 Invoices Approved 310 213 180 232 238 166 Approval % 97.79% 98.15% 95.74% 94.31% 99.16% 97.08% Invoices Rejected 7 4 8 14 2 5 Rejection % 2.21% 1.85% 4.26% 5.69% 0.84% 2.92%

2nd Quarter

3rd Quarter

4th Quarter

$$ Billed By Media YTD
Period 1st Quarter FY'07 July August September October November December January February March April May June Digital $$ Billed $ 2,281,035.39 $ 2,167,501.62 $ 563,173.07 $ 1,610,108.36 $ 2,437,286.13 $ 1,123,876.18 $ 1,228,722.95 $ $ $ $ $ $ $ Mag $$ Billed 807,418.42 986,464.43 1,144,942.53 2,514,831.34 419,450.31 1,710,713.77 6,029,478.57 $ $ $ $ $ $ $ OOH $$ Billed 1,563,595.92 1,275,348.71 1,057,279.49 1,238,702.05 758,539.06 408,812.49 3,067,052.56 $ $ $ $ $ $ $ News $$ Billed 394,167.00 227,304.45 1,930,733.83 2,821,481.63 1,593,213.08 563,446.00 725,265.40 $ $ $ $ $ $ $ Trade $$ Billed 272,401.91 165,672.60 219,294.58 241,706.43 287,883.38 297,135.67 368,003.26 $ $ $ $ $ $ $ Spot $$ Billed 14,343.75 3,988.20 3,988.20 3,666.90 3,666.90 3,988.20 3,666.90 $ $ $ $ $ $ $ Net $$ Billed 1,003,240.55 592,158.45 287,521.85 1,844,423.50 4,516,141.70 5,948,195.14 5,983,753.04 $ $ $ $ $ $ $ Total Billing 6,336,202.94 5,418,438.46 5,206,933.55 10,274,920.21 10,016,180.56 10,056,167.45 17,405,942.68

2nd Quarter

3rd Quarter

4th Quarter

Monthly Media Billing Performance Reporting FY '07 YTD
Invoice Volume by Media YTD
Period 1st Quarter FY'07 July August September October November December January February March April May June Digital Invoices 161 114 96 119 137 60 113 Mag Invoices 32 27 28 43 16 42 102 OOH Invoices 19 14 8 17 10 6 26 News Invoices 4 2 8 12 4 1 3 Trade Invoices 54 29 42 48 57 50 68 Spot Invoices 6 2 2 2 2 2 2 Net Invoices 41 29 4 5 14 10 29 Total Invoices 317 217 188 246 240 171 343

2nd Quarter

3rd Quarter

4th Quarter

Monthly Media Billing Performance Reporting FY '07 YTD
1st Quarter Results FY '07
Vo lu m e

JUL '07

AUG '07

SEP '07

Total/Average

Total $$ Billed Total $$ Held Total Billing Sent Total $$ Approved $$ Approval % Total $$ Rejected $$ Rejection %

$ 6,444,180.79 $ 107,977.85 $ 6,336,202.94 $ 6,253,253.57 98.69% $ 82,949.37 1.31%

$ 5,528,010.04 $ 109,571.58 $ 5,418,438.46 $ 5,138,396.38 94.83% $ 280,042.08 5.17%

$ 5,286,344.74 $ 79,411.19 $ 5,206,933.55 $ 5,187,693.96 99.63% $ 19,239.59 0.37%

$ $ $ $ $

17,258,535.57 296,960.62 16,961,574.95 16,579,343.91 97.72% 382,231.04 2.28%

$$ vo ic e Vo lu m e

Total Invoices Invoices Held Total Invoices Sent Total Line Items Sent Total Invoices Approved Approval % Total Invoices Rejected Rejection %

357 40 317 468 310 97.79% 7 2.21%

247 31 217 412 213 98.15% 4 1.85%

218 30 188 265 180 95.74% 8 4.26%

822 101 722 1145 703 97.23% 19 2.77%

In

Br e

ak o

ut b

y

M ed ia

Digital $$ Billed Mag $$ Billed OOH $$ Billed News $$ Billed Trade $$ Billed Spot $$ Billed Network $$ Billed

$ 2,281,035.39 $ 807,418.42 $ 1,563,595.92 $ 394,167.00 $ 272,401.91 $ 14,343.75 $ 1,003,240.55

$ 2,167,501.62 $ 986,464.43 $ 1,275,348.71 $ 227,304.45 $ 165,672.60 $ 3,988.20 $ 592,158.45

$ 563,173.07 $ 1,144,942.53 $ 1,057,279.49 $ 1,930,733.83 $ 219,294.58 $ 3,988.20 $ 287,521.85

$ $ $ $ $ $ $

5,011,710.08 2,938,825.38 3,896,224.12 2,552,205.28 657,369.09 22,320.15 1,882,920.85

FY '07 1st Quarter $$ Volume
$18,000,000.00

$16,000,000.00

$14,000,000.00

$12,000,000.00

$10,000,000.00

$8,000,000.00

$6,000,000.00

$4,000,000.00

$2,000,000.00

$Total $$ Billed $6,444,180.7 $5,528,010.0 $5,286,344.7 Total $$ Held Total Billing Sent $6,336,202.9 $5,418,438.4 $5,206,933.5 $16,961,574. Total $$ Approved $6,253,253.5 $5,138,396.3 $5,187,693.9 $16,579,343. $$ Approval % 98.69% 94.83% 99.63% 97.72% Total $$ Rejected $82,949.37 $280,042.08 $19,239.59 $382,231.04 $$ Rejection % 1.31% 5.17% 0.37% 2.28%

JUL '07 AUG '07

$107,977.85
$109,571.58 $79,411.19 $296,960.62

SEP '07

Total/Average $17,258,535.

FY '07 1st Quarter Invoice Volume
1200

1000

800

600

400

200

0 Total Invoices JUL '07 AUG '07 SEP '07 Total/Average 357 247 218 822 Invoices Held 40 31 30 101 Total Invoices Sent 317 217 188 722 Total Line Items Sent 468 412 265 1145 Total Approval % Total Rejection % Invoices Invoices Approved Rejected 310 97.79% 7 2.21% 213 180 703 98.15% 95.74% 97.23% 4 8 19 1.85% 4.26% 2.77%

FY '07 1st Quarter $$ by Media

$6,000,000.00

$5,000,000.00

$4,000,000.00

$3,000,000.00

$2,000,000.00

$1,000,000.00

$Digital $$ Billed $2,281,035.3 $2,167,501.6 $563,173.07 Mag $$ Billed $807,418.42 $986,464.43 $1,144,942.5 OOH $$ Billed $1,563,595.9 $1,275,348.7 $1,057,279.4 News $$ Billed $394,167.00 $227,304.45 $1,930,733.8 Trade $$ Billed $272,401.91 $165,672.60 $219,294.58 Spot $$ Billed $14,343.75 $3,988.20 $3,988.20 Network $$ Billed $1,003,240.5 $592,158.45 $287,521.85

JUL '07 AUG '07 SEP '07

Total/Average $5,011,710.0

$2,938,825.3

$3,896,224.1

$2,552,205.2

$657,369.09

$22,320.15

$1,882,920.8

Monthly Media Billing Performance Reporting FY '07 YTD
2nd Quarter Results FY '07
Vo lu m e

OCT '07

NOV '07

DEC '07

Total/Average

Total $$ Billed Total $$ Held Total Billing Sent Total $$ Approved $$ Approval % Total $$ Rejected $$ Rejection %

$ $ $ $ $

10,735,912.42 460,992.21 10,274,920.21 7,875,082.35 76.64% 2,399,837.86 23.36%

$ $ $ $ $

9,981,266.33 (34,914.23) 10,016,180.56 9,997,941.93 99.82% 18,238.63 0.18%

$ $ $ $ $

10,101,208.05 45,040.60 10,056,167.45 10,015,908.12 99.60% 40,259.33 0.40%

$ $ $ $ $

30,818,386.80 471,118.58 30,347,268.22 27,888,932.40 92.02% 2,458,335.82 7.98%

$$ vo ic e Vo lu m e

Total Invoices Invoices Held Total Invoices Sent Total Line Items Sent Total Invoices Approved Approval % Total Invoices Rejected Rejection %

267 21 246 421 232 94.31% 14 5.69%

281 41 240 334 238 99.16% 2 0.84%

216 45 171 219 166 97.08% 5 2.92%

764 107 657 974 636 96.85% 21 3.15%

In

Br ea ko ut b

y

M

ed ia

Digital $$ Billed Mag $$ Billed OOH $$ Billed News $$ Billed Trade $$ Billed Spot $$ Billed Network $$ Billed

$ $ $ $ $ $ $

1,610,108.36 2,514,831.34 1,238,702.05 2,821,481.63 241,706.43 3,666.90 1,844,423.50

$ $ $ $ $ $ $

2,437,286.13 419,450.31 758,539.06 1,593,213.08 287,883.38 3,666.90 456,141.70

$ $ $ $ $ $ $

1,123,876.18 1,710,713.77 408,812.49 563,446.00 297,135.67 3,988.20 5,948,195.14

$ $ $ $ $ $ $

5,171,270.67 4,644,995.42 2,406,053.60 4,978,140.71 826,725.48 11,322.00 8,248,760.34

FY '07 2nd Quarter $$ Volume
$35,000,000.00

$30,000,000.00

$25,000,000.00

$20,000,000.00

$15,000,000.00

$10,000,000.00

$5,000,000.00

$-

$(5,000,000.00) Total $$ Billed $10,735,912. $9,981,266.3 $10,101,208. Total $$ Held Total Billing Sent $10,274,920. $10,016,180. $10,056,167. $30,347,268. Total $$ Approved $7,875,082.3 $9,997,941.9 $10,015,908. $27,888,932. $$ Approval % 76.64% 99.82% 99.60% 92.02% Total $$ Rejected $2,399,837.8 $18,238.63 $40,259.33 $2,458,335.8 $$ Rejection % 23.36% 0.18% 0.40% 7.98%

OCT '07 NOV '07

$460,992.21
$(34,914.23) $45,040.60 $471,118.58

DEC '07

Total/Average $30,818,386.

FY '07 2nd Quarter Invoice Volume
1000 900 800

700
600 500 400 300 200 100 0 Total Invoices OCT '07 NOV '07 DEC '07 Total/Average 267 281 216 764 Invoices Held 21 41 45 107 Total Invoices Sent 246 240 171 657 Total Line Items Sent 421 334 219 974 Total Approval % Total Rejection % Invoices Invoices Approved Rejected 232 94.31% 14 5.69% 238 166 636 99.16% 97.08% 96.85% 2 5 21 0.84% 2.92% 3.15%

FY '07 2nd Quarter $$ by Media

$9,000,000.00 $8,000,000.00 $7,000,000.00 $6,000,000.00 $5,000,000.00 $4,000,000.00 $3,000,000.00 $2,000,000.00 $1,000,000.00 $Digital $$ Billed $1,610,108.3 $2,437,286.1 $1,123,876.1 Mag $$ Billed $2,514,831.3 $419,450.31 $1,710,713.7 OOH $$ Billed $1,238,702.0 $758,539.06 $408,812.49 News $$ Billed $2,821,481.6 $1,593,213.0 $563,446.00 Trade $$ Billed $241,706.43 $287,883.38 $297,135.67 Spot $$ Billed $3,666.90 $3,666.90 $3,988.20 Network $$ Billed $1,844,423.5 $456,141.70 $5,948,195.1

OCT '07 NOV '07 DEC '07

Total/Average $5,171,270.6

$4,644,995.4

$2,406,053.6

$4,978,140.7

$826,725.48

$11,322.00

$8,248,760.3


				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:908
posted:1/18/2008
language:English
pages:10
Description: Media Billing Performance Excel Template