TO WEBSITE READERS; THIS IS AN ACTUAL "BID/TURNKEY" SPREADSHEET FOR
A PLUMBING CONTRACTOR WHO I ASSISTED IN THE INSURANCE BIDDING PROCESS.
Contractor Spreadsheet for   UGD Plumbing, Inc.        
Date: started 5-16-05 Note: client's and agent/agency names all changed          
EXPOSURE Present Carrier Agent A APPS Agent A Agent B   Agent C
    2005-06 2006-07 2006-07 2006-07   2006-07
Named Insd (s)   Same DID NOT Same   Same
same as line 1&2.   MAKE CUT-    
Note: all numbers in thousands, unless noted otherwise.     OFF DATE.    
PROPERTY/IM          
           
Bldg1*   451.5 465 451.5 465   485
Bpp 1*   189 258 189 258   258
address: 10009 Broad R. Rd Saluda Riv.            
Rd, Cola 29209              
Bldg 2   36.75 38 36.75 38   38
Bpp 2   None None None None   None
address: 1050 Mason            
Jones Rd, Cola, 29210            
BI/EE   40 None ? 50   25-EE
(main loc)            
               
Radio/TV antennae 2 None ? None   None
Sewers/Drains/B/U 25 None ? 10   10
           
SIR?   No No No No   No
coins/removed?   90/No 90/No 90/No 90/No   90/No
valuation   RC RC RC RC   RC
cause of loss   Special Special Special Special   Special
deduct   1 1 1 1   1
EQ/Deduct   No Cov/NA Yes/option None Incl/ded=?   Incl/10 & 5%
FLOOD   No Cov None None None   None
           
Sign (unattached only) 7.5 9 5.9 10   10
           
A/Rec   25 None ? 50   25
           
Val Papers   10 None ? 50   25
           
EDP HW   9.6+30* 40 9.6 40   40
Data Media   7.5 50 Incl in 9.6 50   50
BI/EE   7.5 7.5 ? 8   7.5
Deduct   0.5 1 0.5 1   1
         
Ord/Law   ? Not Addr ? 20   ?
         
Underground pipes, ? Not Addr ? Incl   ?
flues, drains        
    1    
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 2006-07 2006-07   2006-07
Add'l Comments * IM pol is with   DID NOT      
thus far:   F Fund/   MAKE CUT-    
    for some EDP/   OFF DATE.    
    also contr equip/        
    install floater        
Util Serv (incl OH Trans lines) s): 25 None ? None   ?
Poll Cleanup   25 Not Addr ? 20   prob 10
PP off prem (no tools tools/equip 25 None ? 10   ?
off prem)            
Port Tools   100 10 (see equip) See miscell 10   10
Max/item   5 1 ? 1   1
Deduct   ? 1 ? 1   1
ACV/RCV   ? Not addr ? ACV   ?
Coins   ? Not addr ? None   ?
               
Contr Equip/Sched. 572.782 623 717.24 623   623
(list with policy/not incl here)            
19 items, flood cov'd   25 items 26 25 25
Newly aquired: 25%/250k 143@ present Not addr ?    
Max of decl page limit   Not addr ?      
Leased/Rented Equip 130/item/occ 175 (incl/623) 130 175 (incl 623) 175 (incl 623)
(3.00 per $100 expense)            
Deduct   1(5%/cranes) 1 1(5%/cranes) 1    
Miscell tools       100 (+717.24) 100 (incl 623) 100 (incl 623)
             
Install Floater            
per loc   125 125 125 125 None-proposal
per disaster   125 150 ? 150   None-proposal
temp loc   25 75 ? 75   None-proposal
transit   25 25 ? 25   None-proposal
             
cause of loss/ded. Special Special/1 Special Special NA
Coins:   100% Not addr ? None NA
Loss Basis   ? Not addr ? ACV NA
             
             
transit/not rel. to inst. 15 None ? 10   25
             
EE Tools   5(1 per EE) None 5 None None
             
             
boiler and mach No Cov None None None   None
               
             
             
             
             
             
      2        
EXPOSURE              
    Agent A APPS Agent A Agent B   Agent C
CGL   2005-06 2006-07 2006-07 2006-07   2006-07
occ/agg   1M/2M 1M/2M 1M/2M 1/2M 1/2M 1/2M
pers and adv inj. 1M 1M 1M 1M 1M 1M
rented prem   300 50 300 500   100
med pay   10 5 10 5 10
EBL   2/2M 1M 2/2M 1M 1M 1M
class codes            
91580-exec superv 67.04 80 24.1 80   80
98483-plumb/res 652.95 300 252.56 300 300
99946-water mains 208.8 210 265.28 210   210
98820-sewer mains 313.8 150 103.48 150 150
98482-plumb/comm 851.4 1M 1.080.7M 1M 1M 1M
91590-contr/perm yard 50.45 44 67.51 44 44
73124-EBL   90 (# EES) 75 ? 75   per app
Liab ded, pd, per claim 0.5 .5/pd ?   1-pd
             
Pollution added   Yes Yes ? BI/not PD None
CG 8320 03 94)              
Exclusions added   These not   NA NA
CG 22 79 07 98 Prof Services addressed ?, but had NA NA
CG 84 08 03 03 EIFS on apps/cer- these before NA NA
CG 84 82 11 02 Fungi/Bacteria tainly not   NA NA
CG 84 94 10 02 Wrap Up/Consol requested.   NA NA
    Ins Programs     NA   NA
Electronic data cov'g None Yes/sublimit None None   None
Prop dam'g, borrowed equip None None ? Incl ?
Vol prop dam'g   None None ? 1k/extra prem   ?
Add'l Insured's, other UGD Trust UGD Trust ? Incl/if agreed UGD Trust
               
               
             
               
CRIME            
empl theft   50+10 150 50 150   150
forg/alt   None None None None None
inside/out   10 and 5 10 and 10 None 10 and 10   10 and 5
ERISA bond   None None None None None
computer fraud   None None None None   None
funds transfer fraud None None None None None
money orders and None None None None   None
Ded   1 1 1 1 1
             
EPL            
claim/agg   None 500/1M None 500   1M
SIR   NA Did not addr NA 5 10
Prior acts   NA Did not addr NA Incl   Did not ask
cause of loss   NA Did not addr NA Outstanding   about
        DID NOT cov'g form  
        MAKE CUT-    
      3 OFF DATE.      
EXPOSURE              
    Agent A APPS Agent A Agent B   Agent C
AUTO   2005-06 2006-07 2006-07 2006-07   2006-07
liab/symb   1M/1 1M/1 1M 1M   1M
# units   54 50 50 50   per app
um/uim   1M/1M 1M/1M 1M/1M 1M/1M   1M/1M
hired/n/o   Incl Incl Incl Incl   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   54 50 48 50   per app
Note: need to change comp/coll to sym 2        
hired pdam   No, because sym 7 used for phys dam symbol!     symbol.    
DOC   4* None 4 None   None
Your 4 officers              
             
Pollution Yes CA 99 48 ? AA 4035/yes None
add'l insds   None, other than   ? None needed   ?
    lessors          
       
       
NOTE: WORKER'S COMP REMOVED FROM THIS SPREADSHEET UNTIL FURTHER            
NOTICE.              
               
         
C UMB   5M 5M 5M 5M   5M
SIR   10 Not addr 10 ?/prob none   ?
Third party discrim No Not addr None before ?/prob yes   ?
Exclusion   Contractural Liab        
CU 61 50 06 97   (need intent of carrier   ?/prob still    
    for this!)   have    
           
           
Contr E&O          
limit   No Cov Not addr on None 500   None
ded   NA apps NA 0.5   NA
           
               
      4        
COMPARATIVE COMMENTS          
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 2006-07 2006-07   2006-07
F Fund=A NA DID NOT Cincy, A++   Penn Nat,
OH Cas, A- MAKE CUT- USLI, A++ A-
  OFF DATE. Accid Fund,
  A
   
           
         
               
   
   
   
               
         
         
         
         
     
         
         
         
  THIS AREA OF SPREADSHEET LEFT BLANK INTENTIONALLY      
         
         
         
         
         
         
         
           
         
     
     
         
               
   
   
   
   
   
               
5
    ANNUAL PREMIUM COMPARISON      
    Agent A APPS Agent A Agent B   Agent C
EXPOSURE   2005-06 2006-07 2006-07 2006-07   2006-07
         
Property   1.249   1.352 1.647   5.052
           
IM F Fund 7.584   10.45 10.875   9.424
  Oh Cas 1.222   0.2      
GL   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   0   None 4.350   4.798
         
E&O   0   None 1.702   0
         
C Umb.   29.615   19.721 11.235   23.079
           
    WORK COMP TEMP REMOVED FROM THIS SPREADSHEET          
         
Terrorism     0 0.386 ?
(incl carrying charge for CINCY)        
Subtotal   93.781   82.446 76.013   129.316
         
Add/Subtract for 'Apples' NA   7.5 0   ?
         
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/rented equip, 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.  
   
   
               
   
   
   
      6