HomeMy WebLinkAboutACCOUNTS PAYABLE RECONCILIATION - 08-000335 - Madison High SchoolCity of Rexburg &Madison School Dfstr�c� Accounts Payable Reconciiia�ion 04f Z5f 14
Amounts Awed to City By School
Billing Date Amount Dpsrri tine
Amounts Owed to School by City
Billing Date nt Description Invoice
4/23/2013 561108.03.. Ico-st to budd
' Avenue as an rl ,ril Deer. Agreement 44431730
Over5izing of water line from r? required base to a 141f for Burton DeoAgreement-
4/23/2013,
Deo, Agreement -
4/23/'2013 1 ,,057,50 -Oversizing o4f sewer lire from 4" to 1201 for Burton Elementary Exhibit
.
Contractor r�
�t���d Construction Time Dela
and bond /o rhead Deo. Agreement -
37 �229 . Jerome BowenBonds/overhead for Burt nb
Elementary --Water Share Exhibit -I 46434718
Contractor Costs- kl nd Construction Time Delay and bonds o read
4 & Jerome Bowen Bonds/overhead for Burton e rata r -Wastewater b , reement-
. I Share
Exhibit -1 4.64.5718
4/23/2013 16,991.00 Change order 2 -Irrigation culvert at 12th i rerpt-
West E h I bit -1 � 44431722
4/23/2013 336.30 Change Order 3- 7th South Section
Upgrade Agreement -
Exhibit -I 44431730
Pressure Sewer Line upsize t from 'r/Add 1210 gravity sewer Deer,
r e m e rpt-
4/23/2013 1681195.55 line/14" ductile for 1300 West -Sewer Lif b
t ttr�tr- �gh ci Exhibit - 146435719
School Area Capacity Charge for City° incurred costs for water line Dev.
Agreement -
.4/23/2013 141.) extension -$730 per acre -20 acre
343464;
School Area Capacitor Charge for it's incurred costs for sewer fig -
4/23/2013 (14,600.00) extension- $730 per acre -20 acres
- 3534742
4/23/2013 (35X0.00) School Share Of Cost for future traffic
3001145,52 Total Due to School District 1001
Future seal coat of streets-re5POnsibility of school to pay 50Yo aser Development � � Agreement -To be billed after work occurs
n
0
113'.75
03791.6667
1
5043 Ga pe Lja vejgjo t dc4S4 Of 1 � � F. cy
$4,689.91 W fee
$15,ower MICCTi ll fee
S.20,070SI Tot-ni lees
k$78,6�7.�C� Amount billed o�� ���ilc�in�, perm ii
S58�62-6.19 Net deccreKase on 13H14
1 Ing
1. Plan Review: $6489.00
a.
07/29/08: Per Vak these will be a SD% discount for the stake of Idaho doing the play
review, 50% pian review is for site play review as well as Beet &Brad's review. Val
is okay with the State's Building &Mechanical reviews and has no additional
comments,
b. 09/25/O8: Pfau review fees are $12,978 - 5D% discount = X6489.
CW Pian review dee is 10/ of building hermit costs, $x.2,978 is 10% of building permit
fee, see item ria. 2.
2. Building Permit Fee:$129,789.05
a. Below contains information that was used to calculate the building permit fie
including construction type and occupancy, sq. ft. and prise per sq. ft. The fee is
based off the total valuation.
:' °
0 3r
20
001
:. ,. , .._.._:. mUOM
z
z
224 500, 00
a':•Wvva'aaar.'n%4,tiya•.y,•4'vxyrxeie'.Y.•�'a''.... swaun.v? _.T�}*I _ L �+
4 SQK
v!
7 605. Y.
nw.�°`r.•-v'a"•F,'ar•+*+�.,•g:u+,t>tiw.,arr.4,aw.,ti•�.:�r:,aw�h."i..�e.:�.c-�-a°,.�'rnr w,,.r.x,M....�'++ti�ayrr.,r_�W�,w,�,.r ..._. :` " - •
-
. • �'}1:+-r1•.vd9ufe:lf1faY�s:d+n}-°•'+4�wvL:+eShAASYfdAi" •, :-•,. "_.. yau,q•_b, ,
�F'aLT2:�YxYAYr"lei-tiara vx: •_• ••�• • •`•
.abOs'jf�Mebka,fir af±trk ®'a4'- .._.. , . .._ .._.._.._e •. .. r :
• .._.: v. .. - ,t .... .. r. a .. ... ,
p.•.,pati:vv,'Rvtiean4anauaavuvasa!k:h.,x,vr�•my%v1+MMe:°iYen,Wev em++e'i WFe3Y a'eu1Y�Y,aaanav v,n:i Yv a1'F4 h4 -.as ..envu: eeav ... .. a b,. _
�` �, *tie'.wtiara*.,..,++e°hw,fi°.�.,.hexya.vaba�eies�i-o- .:.Y.: , , a e.e....:::. '.:_:._,a: e:_4.•.•.:. ,:_::••.;. m
J
'u v'K h°K13Y.b LhA,.: L,:.. xav, a4 e,.e,:,:en: °. °r•'e*veaww•:vx v. r�:b i•.ein.�...s-.:. v:v vyeTvb a':a La•.vx:xv '.. - • • • • • • •• ••_� • e• • ea. _.._. .., - ..
L
,� +M1b"j�',v•:vv ativ a•mby.b Yba Wtienvauaysy}yyfyh°�+ti%1 �-YYsri'Yd 3R. .: .:, - °. � °
.c a •• •°: •.°.: .:.: :.: n:rb ... .......:•:.b-.. �e ., ., ..:�,.,, .,. _ ,
7 y
: { .. a ...... •.
•J4arde�e4w,hwv:�vwve.a=ebab'.w,:..vwv_v:.v..a, ,:,,v •.ab ::vmi h'. :M1:. :.::ti: i ': - 0 '
r T•.vM1h"rr1..4•.:�asn}}73�ew�4:eLa.�ax:K0.44h ac,aaJm vL.vv+A.._......, ...,.._.._e .._......... e.'} - 1
.... {. .,.:_. -•e t•.,.. ....... .., :.:.:: rb: ... .s ..:.._. a :.. .. .. ... ....v,v
.._:.-_..,v r .°e:rv.:.:. r.a•ab"- •.•.:_. ,•.x.,;�:aCae:,.,�„a... a ..... :. a .. i ,
7vrt r
ed e. ....... ...., ,
_ :••1,ifiAaeNhFAhL v:. •.� .::vv.v- k:.: _, ...., } �. •. .v v_:, _.._.. :
.. ,.... ,
�.._.-........ .... xnar:vY-ia•i,-."a•.xwwauw4YM4s'w"rai�m�v:+ti^ • � •..• • , ,. e <
, i'=rv4aa..a Yl4sx uvauacta•"i4.e.,ti}v vtitl:x rv.c "aarawn.,a,eks rx u.a - • •, • •_
o { 4iws„nrtxnv.:_vtiiyybq A,_,,.a:vati: a:a.:. b,r J - •v .. •
,e, a
,.,..,: re+..:$�:'°::.;. .", ,..•..:.. ....,,,.. °. '-• : •e 'f'"t'- #'a''*s' Fr;: +'° ``�',t"�,.>..:nJ^•'r°x„*, Ck+hy+n+ro�.:.'{r?r's• r ,::e
e ny Co T } r=1�
'<
x,p
4 tivefr,r, °L iEje�en ,ie{� �.
k }
b. Below is the table used to calculate thfee based off the valuation..
e
Lill'- ME ...... ----- --
11 W -N!
. U114-
:.
alite
0 % 3�0 C1
,
,
t
• ..,:::: a �-,_}•,.Y. .r.:•', ..•,tiny.:: •a •.t .-.. .,. .:�
e
0
__. _w,...tiro:.},::y},y4,e.A:s:;r•naS:i•i i4i$ti•{•,i�"+Y'QY:;v gti",citi,}�:•..v - 23.50 • - - , ,
-
,.. ,
}a r•.. ,,_.:=ti+C�U:G}}ak.a"J.}:•eiN1a7 }5Q!} sbyafti v.k.d}{• ,. ., - }'i,4"v?i�. e: heti "_. '�^
;• }te-.
00
,gv12000 a
1 I0,
—
125000
0-- 2 �J. 100 ()...j
......... 2000 r h t+__—.—ba'tl'+sbi:°-h�{}yrkvst',:i�C� •w.a, ._.-..... .. .... ,..
¢ }Ja>JcsF,•�aj•i+C•Aa-}xar.+cb: ct�z:_b�:.xy,r�cs•,�• •' 4�,;t+:t -.. s - ' + - - .. .. - �� is
¢ —""„ �#Fddho-�tibxra?.,.�.•:-0.4osmar�:. •..' } - - o
., •,-.�.e,Su.�a.._�-;:+o-ooapappp�r5:4LS6r�,. -,� - . ..,. ....
F
ky.:,�i° a*bi•e;e„wti:.Ya,a;;tiy:eas�.�atva„�a.,`.v +.tititi-w:•n�:.:�c��{• aa.�a. - .
�.• 'na..,v-d�a�i'�;•.;r: �...,M1sa:• a...:,..?w:ek4�tiyei:b;P:L •.:�•.•w,'+nitiieiti4i0t.L 4•:� .... '. :�,'a•,b°V.ian, r.. - .. ... _ •? 14, t00000
2 5 �aLSNF{s...na".n {1 {i MY_Y.:.:-:.:.:•_i^. n.,, ........
;. 0 0 .. 0000 ,a :.,�:: .:. : ro,aa�w.aaax�-�ti�,b "e:..,�.,'.I.M1. 44rG 4r. e..{_L:,x .: i•r.a..._.:. Y:.: e,e,. .... .:�::. Y., a
1:a
ee
391.75]� 25000% OGOOQ
.: •::- ..:.e: -m::.: :arW3rr,°:'r.+:i'7h7ilS'7e,£$i �`
r.
0001
�- �.p�'ya*{artdi.YLl..:;:ti:. ,.r.ti rti }.t �. ,-7i.e{xLa h:=-_:�ba,. • e
.: a .. . >. ..
0 0 0
x
' { pe. -
643,7- 0
.... �.:::.:,r_•;}-e ir..-.::sYa:,dti4i"+ai �L: htiLti•;.::.tti�c t•a t-:,. '+"r.a4;.=::_:•a:.._: .. ?
'10000
i 500000
.=rr,:.:,.:._Y�,.�L .. .Lit:+fr:i^�r:Gisric;,,:;-9:;Rr_i,7:4.:.§�.;R,,;,a�cy�,M,,,P,�:4•k•. }=f,'4Yr}.ee.: ;-„: �a
b.
...... .
5. 60 IFj'�J�
_.} ek,.-,. ':•'fax„-e',:,ti.:.:.a+.'-Y.tiY.,•rxt•,r�ea:.;:,.,,.Y ....+.7'�
10000 1 000 i.e�
{ �--._.:...Vn.v{•x=�.•,:,sT:�&{tas.a+n5�:w.,.J:,,:.:.t a...._.•;. ":,,. ''• a, r._. ... - , ..
0
• �F I_ . _•::�]��4 , r..vn ::: OdY v%r{°.1 Y f n 17 ...1000000
J.:°
...-..
� i
4L 75
:.. `. -. e�xxa•xo:son �•�.... .:-, ° ....:+...<.a+-r�,-:�,V:,.::.. - .._.. .. . .. _.,. .., .._.._. ._.....
1000099999999 ¢}YN�
_.0001-00000
4
Base`
34,021,778.75/1000=34,021.78 x 3 -65 -
Tot a
l=
S 51608.75
$ 124,179.49
$ 129,788.24
Electrical.- $20,513
.. ., -. •: �.+��ynrna ^. •.: �..t•�,�Y,..�.v,vyd�vrr:':.:::.s_:e..•srY.rdadne{sro"�: u:: s+w--+w�^raf!r:Yn� �mti:'�s•.�.sn
}'+1 Yh}: S':}171L:':L:VVAvrnyakY�'••'J::+:4'+.L+.s'3aJ✓e�^-'�Td'n'e tl.YPdditi-.rxvd++•drldM}Wdfed_'..JJ: _'..:VL^JLvrWf YYi e}i'iR_'.nMM• mr.ti Y±iYh'..:•.-:fa}:vim-
. -. P�"""i5'FlWff.'4. JL...'. Vai�+�tiY �e YdeYebYrR�• •^'}_LCJ °i1 �r"hYM1'.wfi1 iY. e . d:'_:._.. _: .C4±J_4 AJN_.n �Y19'r. J.'FAr.L': A'.. J:.•J'•%'uw�.TMT.'M' YA y nL i .r'v. •.ac xv rn w. yyJs.
Electrical
&ase Pe --r itPe:rcent
LowValue
High''
. al u -e Aniount tib ' �.m Multi fler-
2.y
CW. 1000 25 X0IGO:, Go. 2 G 1
le -o-00
-.0.0
159%9139,13913
•10,001 o00 i E. 1 n
2-0, 3 3 2
add base $ ISGA)o
C. IB i I I e d Arnou nt 20r-513
d. Bid price; $4,076,460.00
3. Fire Impart: $87G7.25
a. 245,375 sq. ft. X .03573 = $8767.25
4. Plan Review-, $800
a. Pian review $5Q0
b. Fire Alarm plan review: $20p
c. Fire Sprinkler plan review:$100
5. Hookup Sewer; $60,308.00, later reduced to $ 15,380.90 by Jahn Millar
a. Seg attached documentation
6. Hookup Wader: $18,389.00, later reduced to $ 4,689.91 by Cahn Millar
a. See attached documentation
7. Mechanical: $6,528.55
3P?
20, 001
High Valu
e- Base Amount
20,000
L0,00
100,000
x,00a
20D.G00
L000
500,OW
z,000
1.QOO,Q(#U
5
2.000,000
1..F000
4,OC}Q,OtiO
$
Bi -d Price 3.1532J26,
Less base value 2,000,,c)00 -
Value 1,-532J-26
/1000 17532
4c: 1,87 2t865
add base 9125
IM led Amount
W-1
4,750.00
6.625.04
9,125-.00-
a.
b. Bid Price from RM Mechanical: $1,081,095.84
8. Mechanical: $11,991
a
04
Mechanical
.Low Va I ue High. Value
Base Quantity
Per Qua ntl
1
L0,00
2%001
x,00a
1aa,00i
L000
200,001
z,000
5-00,001
i,000
1,0001t001
1..F000
210GO:tool
Loco
B'd Pri.ce 3,532,126
Less base valu e 2,Oooe000
Value 11532,126
1,53-2
2, 8 65 -
add base 91-25
----------
Billed Amount n $ 991 -
-----------
50,00
650.00
4 250.W'
%2504.00
4r7,50:,.00.
6,621,00.
9,125,U0
Bid price from Hobson" s fabrication: $3.,S32,126.
U t Percen
Amount'Multip
24,040
$
20'r-00111
i00,000
$
1-0-0.0.001
264,000
$
�Q0,001
500,000
-300
$
1,0001001
210000,000
1487
2.Cs60,001
410GO,00
B'd Pri.ce 3,532,126
Less base valu e 2,Oooe000
Value 11532,126
1,53-2
2, 8 65 -
add base 91-25
----------
Billed Amount n $ 991 -
-----------
50,00
650.00
4 250.W'
%2504.00
4r7,50:,.00.
6,621,00.
9,125,U0
Bid price from Hobson" s fabrication: $3.,S32,126.
U t Percen
Amount'Multip
Bid Price
11,081,.-096
Less base value LOO -0,00-O
Value 8-1,096
81
*2.50 2-03
add base 61625
B'I'led Amount 6*828
U n J" t Percen
luantit-v
Amount Malta .
L -1
30,wOO.
I...ro-0-0
20vO-G
L:._W
10"00
.0
LOGO
2:o.50
LO -00,
1487
Bid Price
11,081,.-096
Less base value LOO -0,00-O
Value 8-1,096
81
*2.50 2-03
add base 61625
B'I'led Amount 6*828
9. Plumbing. $7,074-53
Unit
Percent
Low Va I ue. High Value Amount Quantity Quantity Arnount Multiplie�r
20o 000
LOD 0.020
100, .1
4w
1.00
20%001... 9913199% 9919 3.e 2- 3 0. G- Cr, 2&0000
B i d rice
base va I u e
value 768,904
3t845
-add base 3�230.00
Bifted Amount 71,075
a.
b. Bid Price $968,904.16
10. Police Impact: $20,169-83
a. 245,375 sq. ft. X .0822 - $20,169-83
11. Street Impact: $61,834-58
a., Street Impact Fee Category: Education -High School, 15/1000 sq ft
b. 245,375 sq ft * 15/1000 z-- 3680-63 " $16.80 = $61,834-58,
12. Water Meter: $1906.02,
a. Flat fee price for a 3" meter
13. Water Meter-, $1518.20
a. Flat fee price for a 2" meter