TO WEBSITE READERS; THIS IS AN ACTUAL "BID/TURNKEY" SPREADSHEET FOR

A PLUMBING CONTRACTOR WHO I ASSISTED IN THE INSURANCE BIDDING PROCESS.

Contractor Spre

UGD Plumbing, Inc.

Date: started 5-16-05

Note: client'

EXPOSURE

Agent A

APPS

Agent A

Agent B

Agent C

2005-06

2006-07

Named Insd (s)

Same

DID NOT

Same

same as line 1&2.

MAKE CUT-

Note: all numbers in thousa

OFF DATE.

PROPERTY/IM

Bldg1*

451.5

465

451.5

465

485

Bpp 1*

189

258

189

258

address: 10009

Saluda Riv.

Rd, Cola 29209

Bldg 2

36.75

Bpp 2

None

address: 1050 Mason

Jones Rd, Cola, 29210

BI/EE

None

25-EE

(main loc)

Radio/TV antennae

None

Sewers/Drains/B/U

None

SIR?

coins/removed?

90/No

valuation

cause of loss

Special

deduct

EQ/Deduct

No Cov/NA

Yes/option

None

Incl/ded=?

Incl/10 & 5%

FLOOD

No Cov

None

Sign (unattached only)

7.5

5.9

A/Rec

None

Val Papers

None

EDP HW

9.6+30*

9.6

Data Media

7.5

Incl in 9.6

BI/EE

7.5

Deduct

0.5

Ord/Law

Not Addr

Underground pipes,

Not Addr

Incl

flues, drains

Rose colored highlights indicate significant areas of less cov'g,

cov/prem basis.

Brown higlights

where cov'g is shown, indicate more cov'g than asked for.

EXPOSURE

Property/IM, cont'd

Agent A

APPS

Agent A

Agent B

Agent C

2005-06

2006-07

Add'l Comments

* IM pol is wi

DID NOT

thus far:

F Fund/

MAKE CUT-

for some EDP/

OFF DATE.

also contr equip/

install floater

Util Serv (incl OH Trans line

s): 25

None

Poll Cleanup

Not Addr

prob 10

PP off prem (no

tools/equip

None

off prem)

Port Tools

100

10 (see equip)

See miscell

Max/item

Deduct

ACV/RCV

Not addr

ACV

Coins

Not addr

None

Contr Equip/Sched.

572.782

623

717.24

623

(list with policy/not incl here)

19 items, flood cov'd

25 items

Newly aquired:

25%/250k

143@ presen

Not addr

Max of decl page limit

Not addr

Leased/Rented Equip

130/item/occ

175 (incl/623)

130

175 (incl 623)

(3.00 per $100 expense)

Deduct

1(5%/cranes)

Miscell tools

100 (+717.24)

100 (incl 623)

Install Floater

per loc

125

None-proposal

per disaster

125

150

None-proposal

temp loc

None-proposal

transit

None-proposal

cause of loss/ded.

Special

Special/1

Special

Coins:

100%

Not addr

None

Loss Basis

Not addr

ACV

transit/not rel. to inst.

None

EE Tools

5(1 per EE)

None

boiler and mach

No Cov

None

EXPOSURE

Agent A

APPS

Agent A

Agent B

Agent C

CGL

2005-06

2006-07

occ/agg

1M/2M

1/2M

pers and adv inj.

rented prem

300

500

100

med pay

EBL

2/2M

class codes

91580-exec superv

67.04

24.1

98483-plumb/res

652.95

300

252.56

300

99946-water mains

208.8

210

265.28

210

98820-sewer mains

313.8

150

103.48

150

98482-plumb/comm

851.4

1.080.7M

91590-contr/perm yard

50.45

67.51

73124-EBL

90 (# EES)

per app

Liab ded, pd, per claim

0.5

.5/pd

1-pd

Pollution added

Yes

BI/not PD

None

CG 8320 03 94)

Exclusions added

These not

CG 22 79 07 98

Prof Services

addressed

?, but had

CG 84 08 03 03

EIFS

on apps/cer-

these before

CG 84 82 11 02

Fungi/Bacteria

tainly not

CG 84 94 10 02

Wrap Up/Co

requested.

Ins Programs

Electronic data cov'g

None

Yes/sublimit

None

Prop dam'g, borrowed equip

None

Incl

Vol prop dam'g

None

1k/extra prem

Add'l Insured's, other

UGD Trust

Incl/if agreed

UGD Trust

CRIME

empl theft

50+10

150

forg/alt

None

inside/out

10 and 5

10 and 10

None

10 and 10

10 and 5

ERISA bond

None

computer fraud

None

funds transfer fraud

None

money orders and …

None

Ded

EPL

claim/agg

None

500/1M

None

500

SIR

Did not addr

Prior acts

Did not addr

Incl

Did not ask

cause of loss

Did not addr

Outstanding

about

DID NOT

cov'g form

MAKE CUT-

OFF DATE.

EXPOSURE

Agent A

APPS

Agent A

Agent B

Agent C

AUTO

2005-06

2006-07

liab/symb

1M/1

# units

per app

um/uim

1M/1M

hired/n/o

Incl

comp/sym

1/sym 7

1/sym 2

per app

1/per app

coll/sym

1/sym 7

1/sym 2

per app

1/ per app

# units

per app

Note: need to change comp/

hired pdam

No, because

symbol.

DOC

None

Your 4 officers

Pollution

Yes

CA 99 48

AA 4035/yes

None

add'l insds

None, other t

None needed

lessors

NOTE: WORKER'S COMP

NOTICE.

C UMB

SIR

Not addr

?/prob none

Third party discrim

Not addr

None before

?/prob yes

Exclusion

Contractural

CU 61 50 06 97

(need intent

?/prob still

for this!)

have

Contr E&O

limit

No Cov

Not addr on

None

500

None

ded

apps

0.5

COMPARATIVE COMMEN

Both Agents B and C paid close attention to the specs. Agent A, your incumbent, did not! Agent

B did the best job on the specs, though. Agent C has an excellent value added service with claims

mgmt/loss control coordination, etc.

They have a professional who specializes in this and

seems very knowledgeable. This should especially be helpful in worker's comp claims mgmt,

but if they insured other lines, there as well.

Agent A

APPS

Agent A

Agent B

Agent C

Best's Ratings

2005-06

2006-07

F Fund=A

DID NOT

Cincy, A++

Penn Nat,

OH Cas, A-

MAKE CUT-

USLI, A++

A-

OFF DATE.

Accid Fund,

THIS AREA OF SPREADSHEET LEFT BLANK INTENTIONALLY

ANNUAL PREMIUM COMPARISON

Agent A

APPS

Agent A

Agent B

Agent C

EXPOSURE

2005-06

2006-07

Property

1.249

1.352

1.647

5.052

F Fund

7.584

10.45

10.875

9.424

Oh Cas

1.222

0.2

26.943

21.903

16.402

40.321

EBL

0.195

Crime

0.512

1.945

0.768

Incl

Auto

26.461

26.875

28.648

46.642

EPL

None

4.350

4.798

E&O

None

1.702

C Umb.

29.615

19.721

11.235

23.079

WORK COMP TEMP REM

Terrorism

0.386

(incl carrying charge for CIN

Subtotal

93.781

82.446

76.013

129.316

Add/Subtract for 'Apples'

7.5

REAL TOTAL

93.781

89.946

76.013

129.316

Pay plans:

Penn N, 11 pays. Accid Fund, 10. EPL, prob annual. Cincy, Q installments,

$5 per installment.

Note about Agent A, BPP is about 69K too short, and Earthquake is not quoted,

data and media about 50k short, 90k too much on portable tools, 45k short on

leased/rent

ed equip, GL prem basis not correct, employee theft 100k short,

no EPL, no Contractor's E&O (Cincy most likely the only agency carrier that

writes this). From the looks of this, the specs you paid for were given little to

no consideration.

Note: for apples to apples for Agent A, I just took the E&O and EPL (abt 6k, plus added 1.5k more

for earthquake and taking 50k employee theft to 150k/this is a conservative figure)

To the website reader; Agent B was recommended by me to write this business,

my client concurred!

Please consult your policies for full details of your coverage. This spreadsheet is not a

substitute for your policies, which are your legal contract for your insurance programs.