PEAC Rate Swap Report

How to read this

▲ OVERCHARGED = BW impressions billed at the Color rate. The customer paid more than they should. Your boss is overcharging this customer.

▼ UNDERCHARGED = Color impressions billed at the BW rate. The company collected less than it should. This customer is underpaying.

COHEN & THOMAS6 months

+$1313.55 over -$2092.99 under ▼

▲ OVERCHARGED — This customer paid too much

BW impressions were billed at $0.10102/imp (the color rate) instead of $0.01450/imp (the B&W rate).

Usage	Charged	Should Have Been	Overcharged
15,182	$1533.69	$220.14	+$1313.55

▼ UNDERCHARGED — Company lost revenue here

COL impressions were billed at $0.01450/imp (the B&W rate) instead of $0.10102/imp (the color rate).

Usage	Collected	Should Have Collected	Revenue Lost
24,191	$350.78	$2443.77	-$2092.99

Why it happenedThe BW and COL pool rates were swapped. BW=$0.10102 COL=$0.01450 — B&W should always cost less than Color.

Rate ratioBW is 7.0x higher than COL (should be opposite)

Net resultCompany LOSES $779.44 overall (undercharge exceeds overcharge)

Invoices41442400, 41586318, 41720540, 41866239, 41999877, 42166032

IBEW LOCAL 426 months

+$63.00 over -$194.33 under ▼

▲ OVERCHARGED — This customer paid too much

BW impressions were billed at $0.01561/imp (the color rate) instead of $0.00835/imp (the B&W rate).

Usage	Charged	Should Have Been	Overcharged
8,248	$131.87	$68.87	+$63.00

▼ UNDERCHARGED — Company lost revenue here

COL impressions were billed at $0.00835/imp (the B&W rate) instead of $0.01561/imp (the color rate).

Usage	Collected	Should Have Collected	Revenue Lost
27,378	$233.04	$427.37	-$194.33

Why it happenedThe BW and COL pool rates were swapped. BW=$0.01561 COL=$0.00835 — B&W should always cost less than Color.

Rate ratioBW is 1.9x higher than COL (should be opposite)

Net resultCompany LOSES $131.33 overall (undercharge exceeds overcharge)

Invoices41440815, 41584706, 41718994, 41864934, 41998355, 42164736

ALL PETS CLUB6 months

+$31.51 over -$46.48 under ▼

▲ OVERCHARGED — This customer paid too much

BW impressions were billed at $0.02768/imp (the color rate) instead of $0.01596/imp (the B&W rate).

Usage	Charged	Should Have Been	Overcharged
2,689	$74.43	$42.92	+$31.51

▼ UNDERCHARGED — Company lost revenue here

COL impressions were billed at $0.01596/imp (the B&W rate) instead of $0.02768/imp (the color rate).

Usage	Collected	Should Have Collected	Revenue Lost
3,965	$63.27	$109.75	-$46.48

Why it happenedThe BW and COL pool rates were swapped. BW=$0.02768 COL=$0.01596 — B&W should always cost less than Color.

Rate ratioBW is 1.7x higher than COL (should be opposite)

Net resultCompany LOSES $14.97 overall (undercharge exceeds overcharge)

Invoices41440609, 41584482, 41718790, 41864751, 41998151, 42164557

BETTER HEALTHCARE SOLUTIONS4 months

+$10.50 over -$36.05 under ▼

▲ OVERCHARGED — This customer paid too much

BW impressions were billed at $0.02420/imp (the color rate) instead of $0.01210/imp (the B&W rate).

Usage	Charged	Should Have Been	Overcharged
867	$20.99	$10.49	+$10.50

▼ UNDERCHARGED — Company lost revenue here

COL impressions were billed at $0.01210/imp (the B&W rate) instead of $0.02420/imp (the color rate).

Usage	Collected	Should Have Collected	Revenue Lost
2,980	$36.07	$72.12	-$36.05

Why it happenedThe BW and COL pool rates were swapped. BW=$0.02420 COL=$0.01210 — B&W should always cost less than Color.

Rate ratioBW is 2.0x higher than COL (should be opposite)

Net resultCompany LOSES $25.55 overall (undercharge exceeds overcharge)

Invoices41441127, 41865267, 41998640, 42165057

FRANK J MONGILLO III MD6 months

+$43.27 over -$18.39 under ▼

▲ OVERCHARGED — This customer paid too much

BW impressions were billed at $0.02287/imp (the color rate) instead of $0.01319/imp (the B&W rate).

Usage	Charged	Should Have Been	Overcharged
4,471	$102.24	$58.97	+$43.27

▼ UNDERCHARGED — Company lost revenue here

COL impressions were billed at $0.01319/imp (the B&W rate) instead of $0.02287/imp (the color rate).

Usage	Collected	Should Have Collected	Revenue Lost
1,900	$25.06	$43.45	-$18.39

Why it happenedThe BW and COL pool rates were swapped. BW=$0.02287 COL=$0.01319 — B&W should always cost less than Color.

Rate ratioBW is 1.7x higher than COL (should be opposite)

Net resultCompany GAINS $24.88 overall (overcharge exceeds undercharge)

Invoices41441128, 41585091, 41719290, 41865268, 41998641, 42165058

MONGILLO & INSLER ATTORNEYS AT LAW3 months

+$0.00 over -$13.04 under ▼

▲ OVERCHARGED — This customer paid too much

BW impressions were billed at $0.02287/imp (the color rate) instead of $0.01319/imp (the B&W rate).

Usage	Charged	Should Have Been	Overcharged
0	$0.00	$0.00	+$0.00

▼ UNDERCHARGED — Company lost revenue here

COL impressions were billed at $0.01319/imp (the B&W rate) instead of $0.02287/imp (the color rate).

Usage	Collected	Should Have Collected	Revenue Lost
1,347	$17.77	$30.81	-$13.04

Why it happenedThe BW and COL pool rates were swapped. BW=$0.02287 COL=$0.01319 — B&W should always cost less than Color.

Rate ratioBW is 1.7x higher than COL (should be opposite)

Net resultCompany LOSES $13.04 overall (undercharge exceeds overcharge)

Invoices41441129, 41865269, 42165059

FIRST CHURCH OF WINSTED6 months

+$2.42 over -$0.00 under ▼

▲ OVERCHARGED — This customer paid too much

BW impressions were billed at $0.02662/imp (the color rate) instead of $0.01597/imp (the B&W rate).

Usage	Charged	Should Have Been	Overcharged
227	$6.05	$3.63	+$2.42

▼ UNDERCHARGED — Company lost revenue here

COL impressions were billed at $0.01597/imp (the B&W rate) instead of $0.02662/imp (the color rate).

Usage	Collected	Should Have Collected	Revenue Lost
0	$0.00	$0.00	-$0.00

Why it happenedThe BW and COL pool rates were swapped. BW=$0.02662 COL=$0.01597 — B&W should always cost less than Color.

Rate ratioBW is 1.7x higher than COL (should be opposite)

Net resultCompany GAINS $2.42 overall (overcharge exceeds undercharge)

Invoices41442801, 41586797, 41720932, 41866640, 42000244, 42166418