The URL can be used to link to this page

Home My WebLink AboutWestlake Facilities Planning Matrix6We s t l a k e A c a d e m y Fa c i l i t i e s P l a n n i n g Ma r c h 1 0 , 2 0 1 1 Gr o w t h M o d e l O p t i o n s TAB 1 Westlake Academy Snapshot of Options 4 Section Primary School moving into5 Section Primary School moving into 4 Section Secondary School4 Section Secondary School Option 1-A Option 2-A 6th Grade in Middle School Bld'g 6th Grade in Middle School Bld'g Option 1-B Option 2-B 6th Grade in Primary School Bld'g6th Grade in Primary School Bld'g Option 3 Option 4 One phase of construction Two phases of construction Westlake Academy Summary of Options General Comments: 1 Model assumes that new classroom sections can be readily populated at all grade levels 2 Assumes the capital campaign can continue to generate an average of $800K/student per year 3 Other capital campaign funds would be developed the black box and tennis court were desired 4 Option 1-A 1 Construction to Start August 2012, and finish August 2013 2 4 Sections of Primary School moving into 4 sections of Secondary School 3 6th grade will be in the Middle School Building - PYP is through 5th grade only 4 Least Expensive Capital Improvement Model 5 Culture hurdle by introducing new 6th grade students could make preformance more difficult 6 Construction in 2012 introduces risk of escalation of interest and construction costs BuildingSq FtCost High School22,570 5,363,908$ Middle School19,320 4,269,020$ Media Center3,000 1,007,449$ Multi-Purpose Bld'g4,500 1,627,656$ Existing Kitchen Reno759,755$ TOTAL49,390 13,027,788$ Surplus/Shortfall Projections 2012-2013 2013-2014$348,000 2014-2015$110,000 2015-2016$122,000Assumed State Fund 3% increase year Option 1-B 1 Same model as 1-A, except 6th grade will be in the Primary School 2 The option is more expensive than 1-A, because it costs more to expand the existing Primary School Building, than buildng a larger new Middle School Building BuildingSq FtCost High School22,570 5,363,908$ Middle School15,445 3,504,317$ Media Center3,000 1,007,449$ Multi-Purpose Bld'g4,500 1,627,656$ Primary School Addition3,500 990,207$ Existing Kitchen Reno759,754$ TOTAL49,015 13,253,291$ Surplus/Shortfall Projections 2012-2013 2013-2014$181,000 2014-2015 -$56,000 2015-2016 -$48,000 Assumed State Fund 3% increase year Some of the model assumptions for teacher to staff ratios and other staffing assumptions are based on data and discussion with a local peer, high performing IB school, as well as existing operation data and salaries for the current operations. 3/4/2011,5:46 PM Option 2-A 1 Construction to Start August 2012, and finish August 2013 2 Agressive school growth in enrollment from grade to grade is a concern 3 Natural "organic" school growth in enrollment from grade to grade - no culture hurdles 4 5 Sections of Primary School moving into 4 sections of Secondary School 5 6th grade will be in the Middle School Building - PYP is through 5th grade only 6 Construction in 2012 introduces risk of escalation of interest and construction costs BuildingSq FtCost High School22,570 5,363,908$ Middle School19,320 4,269,020$ Media Center3,000 1,007,449$ Multi-Purpose Bld'g4,500 1,627,656$ Primary School Addition5,200 1,383,525$ Existing Kitchen Reno759,754$ TOTAL54,590 14,411,312$ Surplus/Shortfall Projections 2012-2013 2013-2014$503,000 2014-2015$245,000 2015-2016$261,000Assumed State Fund 3% increase year Option 2-B 1 Same model as 2-A, except 6th grade will be in the Primary School 2 The option is more expensive than 2-A, because it costs more to expand the existing Primary School Building, than buildng a larger new Middle School Building 3 Most Expensive Capital Improvement Model due to large Primary School BuildingSq FtCost High School22,570 5,363,908$ Middle School15,445 3,504,317$ Media Center3,000 1,007,449$ Multi-Purpose Bld'g4,500 1,627,656$ Primary School Addition10,368 2,558,796$ Existing Kitchen Reno759,754$ TOTAL55,883 14,821,880$ Surplus/Shortfall Projections 2012-2013 2013-2014$416,000 2014-2015$155,000 2015-2016$175,000Assumed State Fund 3% increase year 3/4/2011,5:46 PM Option 3 1 Phase 1 Construction to Start October 2011, and finish August 2012 2 Phase 2 Construction to Start August 2013, and finish August 2014 3 Culture hurdle by introducing new 6th grade students could make preformance more difficult 4 4 Sections of Primary School moving into 4 sections of Secondary School 5 6th grade will be in the Middle School Building - PYP is through 5th grade only 6 Construction in 2013 introduces high risk of escalation of interest and construction costs BuildingSq FtCost High School22,570 5,363,908$ Media Center3,000 1,007,449$ Multi-Purpose Bld'g4,500 1,627,656$ Existing Kitchen Reno759,754$ PHASE 1 SUBTOTAL30,070 8,758,767$ PHASE 2 Middle School19,320 4,286,115 PHASE 2 SUBTOTAL19,320 4,286,115$ TOTAL PHASE 1&249,390 13,044,882$ Surplus/Shortfall Projections 2012-2013 $144,000 2013-2014 $204,000 2014-2015 $100,200 2015-2016 $112,000Assumed State Fund 3% increase year Option 4 1 Phase 1 Construction to Start October 2011, and finish August 2012 2 Phase 2 Construction to Start August 2013, and finish August 2014 3 Natural "organic" school growth in enrollment from grade to grade - no culture hurdles 4 Agressive school growth in enrollment from grade to grade is a concern 5 5 Sections of Primary School moving into 4 sections of Secondary School 6 6th grade will be in the Middle School Building - PYP is through 5th grade only 7 Construction in 2013 introduces high risk of escalation of interest and construction costs BuildingSq FtCost PHASE 1 High School22,570 5,363,908$ Media Center3,000 1,007,449$ Multi-Purpose Bld'g4,500 1,627,656$ Existing Kitchen Reno759,754$ PHASE 1 SUBTOTAL30,070 8,758,767$ PHASE 2 Middle School19,320 4,286,115 Primary School Addition5,200 1,415,435 PHASE 2 SUBTOTAL24,520 5,701,550$ TOTAL PHASE 1&254,590 14,460,317$ Surplus/Shortfall Projections 2012-2013 $138,000 2013-2014 $72,000 2014-2015 $235,000 2015-2016 $251,000Assumed State Fund 3% increase year 3/4/2011,5:46 PM TAB 2 TAB 3 Pr o g r a m D e v e l o p m e n t M a s t e r S c h e d u l e Pr e - d e s i g n De s i g n Bi d Co n s t r u c t i o n Pe r m i t t i n g Mo v e I n DE C J A N F E B M A R A P R M A Y J U N J U L A U G S E P T O C T N O V D E C J A N F E B M A R A P R M A Y J U N J U L A U G S E P T O C T N O V D E C J A N F E B M A R A P R M A Y J U N J U L A U G S E P T O C T N O V D E C We s l l a k e A c a d e m y We s t l a k e A c a d e m y O p t i o n 1 o r 2 Pl a n n i n g / P r o g r a m d e v e l o p m e n t Co n s u l t a n t S e l e c t i o n s / C o n t r a c t i n g De s i g n Pe r m i t Bi d / A w a r d Co n s t r u c t i o n SC Ca f e t e r i a De s i g n Bi d / A w a r d Co n s t r u c t i o n We s t l a k e A c a d e m y O p t i o n 3 o r 4 , P h a s e 1 Pl a n n i n g / P r o g r a m d e v e l o p m e n t Co n s u l t a n t S e l e c t i o n s / C o n t r a c t i n g De s i g n Pe r m i t Bi d / A w a r d Co n s t r u c t i o n SC Ca f e t e r i a De s i g n Bi d / A w a r d Co n s t r u c t i o n 20 1 2 Ca m pus 20 1 1 2013 Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 3/4/2011 TAB 4 Westlake Academy Budget for Option 1-A High School, 6th-8th grade Middle School, Media Center, Muli-Purpose Bld'g and Existing Kitchen Renovation all to open year four, Fall 2013 Budget Detail Report Cost Code DescriptionBudgetNotes 01Professional Services 01100Project Management Services$271,137 Based on 3% of construction cost 01120Project Management Additional Services $0 01130Project Management Reimbursables $27,114 01200A/E Services - Planning (---)$0 01210A/E Services - Basic Services $602,526 Based on 7% of construction cost 01220A/E Additional Services $30,126 01230A/E Services Reimbursables $30,000 Other Consultants & Related Expenses $0 01300Civil Engineer (---)$190,000 01310Surveying (---)$45,000 Allowance 01320Signage (---)$17,000 01330Geotechnical (---)$36,000 01340Environmental/AHERA Report $20,000 01350Materials Testing (---)$115,146 1% of construction 01360[blank]$0 01370Data/IT/Security $82,000 ` 01380Regulatory/Printing/Permits/Advert $86,075 1% of const 01390Other Reimbursables/Expenses $45,000 Subtotal Professional Services $1,597,124 02Prime Construction Contract 02200Construction Contract $8,607,509 See Detail Estimates 02210Contractor Contingency $0 Inc. in construction costs above 02220Construction Contingency - 5%$430,375 Subtotal Prime Construction Contract$9,037,885 03Other Capital Improvement Contracts 03100HVAC System Test., Adjust. & Balancing $0 In Construction Contract 03110Telephone $75,500 Allowance 03120Utility Service/Easements/Tap Fees $40,000 Allowance 03130Temporary Utilities $0 In Construction Contract 03140Signs $21,000 Allowance 03150Fencing/Covered Canopy $175,000 03160Security Systems $96,433 $1.75/SF 03170IT/Data (infrastructure)$133,475 $2.50/SF 03180IT Hardware $628,000 03200Furnishings/Equipment $603,000 Subtotal Other Construction Contracts$1,772,408 Totals $12,407,416 04Owner's Internal Costs 04100Internal costs, fees, etc.$0 04200Interest/closing expenses$0 04300Blank$0 Subtotal Internal Costs$0 05Owner's Contingency 05100Owner's Project Contingency - (5%)$620,372 Subtotal Contingency*$620,372 Project Grand Totals$13,027,788 3/4/2011, 4:23 PM Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s In p u t P a g e E n r o l l m e n t / T e a c h i n g S t a f f Ye a r 1 8 1 9 2 0 Se c t i o n s 2 0 1 2 / 1 3 2 0 1 3 / 1 4 2 0 1 4 / 2 0 1 5 Pr e K - - - K4 4 4 1s t 4 4 4 2n d 4 4 4 3r d 4 4 4 4t h 4 4 4 5t h 4 4 4 6t h 4 4 4 7t h 4 4 4 8t h 4 4 4 9t h 4 4 4 10 t h 4 4 4 11 t h 4 4 4 12 t h 4 4 4 To t a l P r i m a r y 24 24 24 To t a l M i d d l e 12 12 12 To t a l H i g h 16 16 16 To t a l 52 52 52 St u d e n t s Pr e K - - - K 88 88 88 1s t 88 88 88 2n d 88 88 88 3r d 88 88 88 4t h 88 88 88 5t h 88 88 88 6t h 10 8 10 8 10 8 7t h 10 8 10 8 10 8 8t h 10 8 10 8 10 8 9t h 10 8 10 8 10 8 10 t h 10 8 10 8 10 8 11 t h 97 97 97 12 t h 97 97 97 To t a l P r i m a r y 52 8 52 8 52 8 P Y P To t a l M i d d l e 54 0 54 0 54 0 M Y P To t a l H i g h 19 4 19 4 19 4 D P To t a l 1, 2 6 2 1, 2 6 2 1, 2 6 2 Te a c h i n g S t a f f Pr i m a r y 38 . 4 0 38 . 4 0 38 . 4 0 Mi d d l e 16 . 8 0 16 . 8 0 16 . 8 0 Hi g h 23 . 2 0 23 . 2 0 23 . 2 0 78 . 4 0 78 . 4 0 78 . 4 0 St u d e n t / T e a c h e r R a t i o 16 . 1 0 16 . 1 0 16 . 1 0 Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 1 A _ 4 s e c t i o n . x l s i n p e n r o l l Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s In c o m e S t a t e m e n t ( 0 0 0 ) No S t a t e i n c N o S t a t e i n c 3 % S t a t e i n c 6. 7 5 8 6 . 7 5 8 6 . 9 6 1 Ye a r 1 8 1 9 2 0 Re v e n u e s 2 0 1 3 / 1 4 2 0 1 4 / 1 5 2 0 1 5 / 1 6 St u d e n t E n r o l l m e n t 1, 2 6 2 1, 2 6 2 1, 2 6 2 Sc h o o l St a t e R e v e n u e s 8 , 5 3 1 $ 8 , 5 3 1 $ 8 , 7 8 7 $ Ti t l e M o n i e s - - - Gr a n t s Pr i v a t e D o n a t i o n s - P l e d g e d Pr i v a t e D o n a t i o n s - P l a n n e d t o R a i s e 1 , 0 1 0 1, 0 1 0 1, 0 1 0 To t a l 9, 5 4 1 $ 9, 5 4 1 $ 9, 7 9 7 $ St a t e R e v e n u e p e r S t u d e n t $6 , 7 5 3 $6 , 7 5 3 $6 , 9 5 6 4 4 5 Ex p e n s e s Sc h o o l P e r s o n n e l N o S a l I n c r 3 % i n c r 3 % i n c r Su b - T o t a l S c h o o l P e r s o n n e l 5, 2 0 7 $ 5 , 3 6 3 $ 5 , 5 2 4 $ Va r i a b l e B e n e f i t s 2 0 1 $ 2 0 7 $ 2 1 3 $ Fi x e d B e n e f i t s 4 1 2 4 1 2 4 1 2 To t a l B e n e f i t s 61 3 $ 6 1 9 $ 6 2 5 $ To t a l S c h o o l P e r s o n n e l 5 , 8 2 0 $ 5 , 9 8 2 $ 6 , 1 4 9 $ Sc h o o l N o n - P e r s o n n e l 3 % i n c r 3 % i n c r 3 % i n c r Pr o f . C o n t r a c t e d S e r v i c e s 7 8 3 $ 8 0 6 $ 8 3 1 $ Su p p l i e s & M a t e r i a l s 4 4 1 4 5 4 4 6 7 Ut i l i t i e s a n d M a i n t 6 2 2 6 4 0 6 6 0 Ot h e r O p e r a t i n g c o s t s 3 2 4 3 3 4 3 4 4 Mi s c e l l a n e o u s - - - CM O C h a r g e 33 4 34 4 35 5 To t a l S c h o o l N o n - P e r s o n n e l 2, 5 0 4 $ 2, 5 7 9 $ 2, 6 5 6 $ To t a l S c h o o l E x p e n s e s 8, 3 2 4 $ 8, 5 6 1 $ 8, 8 0 5 $ Re v e n u e A v a i l a b l e f o r D e b t S e r v i c e 1, 2 1 8 $ 98 0 $ 99 2 $ De b t S e r v i c e 87 0 87 0 87 0 87 0 $ 87 0 $ 87 0 $ Su r p l u s / S h o r t f a l l 34 8 $ 11 0 $ 12 2 $ Co v e r a g e 1. 4 0 1. 1 3 1. 1 4 Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 1 A _ 4 s e c t i o n . x l s I S Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s As s u m p t i o n P a g e Sa l a r y A s s u m p t i o n s 2 0 0 6 20 1 0 He a d C o u n t A s s u m p t i o n s N o n - p e r s o n n e l C o s t s Av e r a g e T e a c h e r S a l a r y 4 4 $ $ 5 0 Pr i m a r y Pr o f . C o n t r a c t e d S e r v i c e s 7 3 8 . 0 1 Su p e r i n t e n d e n t 8 0 $ 9 0 Pr e K S t u d e n t s / S e c t i o n - Ut i l i t i e s a n d M a i n t 586.10 Se c o n d a r y S c h o o l L e a d e r 80 $ 9 0 St u d e n t s / S e c t i o n 22 S u p p l i e s & M a t e r i a l s 415.30 Pr i m a r y S c h o o l L e a d e r 80 $ 9 0 Te a c h e r s / S e c t i o n 1. 6 0 Ot h e r O p e r a t i n g c o s t s 305.40 Adm i n . C o o r d 58 $ 6 5 Mi d d l e Mi s c e l l a n e o u s DP C o o r d i n a t o r 58 $ 6 5 St u d e n t s / S e c t i o n 27 MY P C o o r d 5 8 $ 6 5 Te a c h e r s / S e c t i o n 1 . 4 0 Be n e f i t C o s t A s s u m p t i o n s At t e n d a n c e C l e r k 18 $ 2 0 Hi g h Fi x e d B e n e f i t s - $ 3 . 7 K 3.70$ St r i n gs s t a f f 27 $ 3 0 St u d e n t s / S e c t i o n 27 V a r i a b l e B e n e f i t s - 3 . 8 6 % 3.86% Li b r a r i a n 4 4 $ 5 0 Te a c h e r s / S e c t i o n 1 . 4 5 0. 5 5 0 0 % T R S Te a c h e r ' s A i d e s 18 $ 2 0 An n u a l R e t e n t i o n 9 , 1 0 1 0 0 % 0. 8 4 0 0 % U n e m p l o y m e n t IT 59 $ 6 6 Ann u a l R e t e n t i o n 1 1 , 1 2 90 % 0. 5 1 9 1 % W o r k e r ' s c o m p Fa c i l i t i e s M a n a ger 29 $ 3 2 Re v e n u e A s s u m p t i o n s 1. 4 5 0 0 % M e d i c a r e Nu r s e 4 4 $ 5 0 AD A % 97 % 0. 5 0 0 0 % T R S - n e w h i r e s Re g i s t r a r 20 $ 2 3 St a t e F u n d i n g / A D A 6. 1 9 $ PY P C o o r d / D e a n o f S t u d e n t s 58 $ 6 5 Ti t l e $ - Co u n s e l o r s / I n s t r u c t i o n a l C o a c h 49 $ 5 5 Ti t l e % 0 % Of f i c e A i d e 1 8 $ 2 0 Lu n c h r o o m p e r s o n n e l (co n t r a c t ) - $0 Gr o w t h A s s u m p t i o n s Ja n i t o r 18 $ 2 0 In f l a t i o n R a t e - 3 % 3 % 15 % b u m p f o r g r o w t h Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 1 A _ 4 s e c t i o n . x l s a s s m p Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s I n p u t P a g e E m p l o y e e s Ye a r 1 8 1 9 2 0 Em p l o y e e s 2 0 1 3 / 1 4 2 0 1 4 / 1 5 2 0 1 5 / 1 6 Su p e r i n t e n d e n t - - - Se c o n d a r y S c h o o l L e a d e r 1. 0 0 1. 0 0 1. 0 0 Pr i m a r y S c h o o l L e a d e r 1. 0 0 1 1 . 0 0 1. 0 0 Ad m i n . C o o r d 1. 0 0 1. 0 0 1. 0 0 PY P C o o r d / D e a n o f S t u d e n t s 2. 0 0 2 2 . 0 0 2. 0 0 DP C o o r d i n a t o r 1. 0 0 1. 0 0 1. 0 0 MY P C o o r d 1. 0 0 1. 0 0 1. 0 0 At t e n d a n c e C l e r k 1. 0 0 1. 0 0 1. 0 0 St r i n g s s t a f f 1. 0 0 1. 0 0 1. 0 0 Li b r a r i a n 2. 0 0 2. 0 0 2. 0 0 Te a c h e r ' s A i d e s 8. 0 0 8. 0 0 8. 0 0 IT 1. 0 0 1. 0 0 1. 0 0 Fa c i l i t i e s M a n a g e r 1. 0 0 1. 0 0 1. 0 0 Nu r s e 2. 0 0 2. 0 0 2. 0 0 Re g i s t r a r 1. 0 0 1. 0 0 1. 0 0 Co u n s e l o r s / I n s t r u c t i o n a l C o a c h 3. 0 0 1 3 . 0 0 3. 0 0 Of f i c e A i d e 4. 0 0 2 4 . 0 0 4. 0 0 Lu n c h r o o m p e r s o n n e l ( c o n t r a c t ) - - - Ja n i t o r 2. 0 0 2. 0 0 2. 0 0 To t a l F T E ' s 33 . 0 0 6 3 3 . 0 0 33 . 0 0 Po s i t i o n s 26 . 0 0 26 . 0 0 26 . 0 0 12 6 2 . 4 1 2 6 2 . 4 1 2 6 2 . 4 Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 1 A _ 4 s e c t i o n . x l s i n p e m p Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s Pr o j e c t e d C a s h F l o w a n d D e b t S e r v i c e C o v e r a g e Fi s c a l R e v e n u e Projected Ye a r A v a i l a b l e P r o j e c t e d D e b t S e r v i c e P r o j e c t e d C u m u l a t i v e En d F o r D e b t O w n e r I n t . N e w M o n e y C a s h C a s h 30 - A u g S e r v i c e E x i s t i n g L o a n S e r i e s x S e r i e s y T o t a l F l o w F l o w 20 1 3 1 , 2 1 7 , 5 8 0 8 7 0 , 0 0 0 - - 87 0 , 0 0 0 34 7 , 5 8 0 347,580 20 1 4 98 0 , 2 4 0 87 0 , 0 0 0 - - 87 0 , 0 0 0 11 0 , 2 4 0 457,820 20 1 5 99 1 , 7 1 5 87 0 , 0 0 0 - - 87 0 , 0 0 0 12 1 , 7 1 5 579,535 Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 1 A _ 4 s e c t i o n . x l s C F TAB 5 Westlake Academy Budget for Option 1-B High School, 7th & 8th grade Middle School, Media Center, Muli-Purpose Bld'g and Existing Kitchen Renovation all to open year four, Fall 2013 Budget Detail Report Cost Code DescriptionBudgetNotes 01Professional Services 01100Project Management Services$274,978 Based on 3% of construction cost 01120Project Management Additional Services $0 01130Project Management Reimbursables $27,498 01200A/E Services - Planning (---)$0 01210A/E Services - Basic Services $611,063 Based on 7% of construction cost 01220A/E Additional Services $30,553 01230A/E Services Reimbursables $36,000 Other Consultants & Related Expenses $0 01300Civil Engineer (---)$205,000 01310Surveying (---)$50,000 Allowance 01320Signage (---)$19,000 01330Geotechnical (---)$44,000 01340Environmental/AHERA Report $25,000 01350Materials Testing (---)$122,034 1% of construction 01360[blank]$0 01370Data/IT/Security $102,000 ` 01380Regulatory/Printing/Permits/Advert $87,295 1% of const 01390Other Reimbursables/Expenses $55,000 Subtotal Professional Services $1,689,422 02Prime Construction Contract 02200Construction Contract $8,729,473 See Detail Estimates 02210Contractor Contingency $0 Inc. in construction costs above 02220Construction Contingency - 5%$436,474 Subtotal Prime Construction Contract$9,165,947 03Other Capital Improvement Contracts 03100HVAC System Test., Adjust. & Balancing $0 In Construction Contract 03110Telephone $85,500 Allowance 03120Utility Service/Easements/Tap Fees $40,000 Allowance 03130Temporary Utilities $0 In Construction Contract 03140Signs $23,000 Allowance 03150Fencing/Covered Canopy $175,000 03160Security Systems $95,776 $1.75/SF 03170IT/Data (infrastructure)$132,538 $2.50/SF 03180IT Hardware $628,000 03200Furnishings/Equipment $587,000 Subtotal Other Construction Contracts$1,766,814 Totals $12,622,182 04Owner's Internal Costs 04100Internal costs, fees, etc.$0 04200Interest/closing expenses$0 04300Blank$0 Subtotal Internal Costs$0 05Owner's Contingency 05100Owner's Project Contingency - (5%)$631,109 Subtotal Contingency*$631,109 Project Grand Totals$13,253,291 3/4/2011, 4:23 PM Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s In p u t P a g e E n r o l l m e n t / T e a c h i n g S t a f f Ye a r 1 8 1 9 2 0 Se c t i o n s 2 0 1 2 / 1 3 2 0 1 3 / 1 4 2 0 1 4 / 2 0 1 5 Pr e K - - - K4 4 4 1s t 4 4 4 2n d 4 4 4 3r d 4 4 4 4t h 4 4 4 5t h 4 4 4 6t h 4 4 4 7t h 4 4 4 8t h 4 4 4 9t h 4 4 4 10 t h 4 4 4 11 t h 4 4 4 12 t h 4 4 4 To t a l P r i m a r y 24 24 24 To t a l M i d d l e 12 12 12 To t a l H i g h 16 16 16 To t a l 52 52 52 St u d e n t s Pr e K - - - K 88 88 88 1s t 88 88 88 2n d 88 88 88 3r d 88 88 88 4t h 88 88 88 5t h 88 88 88 6t h 88 88 88 7t h 10 8 10 8 10 8 8t h 10 8 10 8 10 8 9t h 10 8 10 8 10 8 10 t h 10 8 10 8 10 8 11 t h 97 97 97 12 t h 97 97 97 To t a l P r i m a r y 61 6 61 6 61 6 P Y P To t a l M i d d l e 43 2 43 2 43 2 M Y P To t a l H i g h 19 4 19 4 19 4 D P To t a l 1, 2 4 2 1, 2 4 2 1, 2 4 2 Te a c h i n g S t a f f Pr i m a r y 38 . 4 0 38 . 4 0 38 . 4 0 Mi d d l e 16 . 8 0 16 . 8 0 16 . 8 0 Hi g h 23 . 2 0 23 . 2 0 23 . 2 0 78 . 4 0 78 . 4 0 78 . 4 0 St u d e n t / T e a c h e r R a t i o 15 . 8 5 15 . 8 5 15 . 8 5 Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 1 B _ 4 s e c t i o n . x l s i n p e n r o l l Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s In c o m e S t a t e m e n t ( 0 0 0 ) No S t a t e i n c N o S t a t e i n c 3 % S t a t e i n c 6. 7 5 8 6 . 7 5 8 6 . 9 6 1 Ye a r 1 8 1 9 2 0 Re v e n u e s 2 0 1 3 / 1 4 2 0 1 4 / 1 5 2 0 1 5 / 1 6 St u d e n t E n r o l l m e n t 1, 2 4 2 1, 2 4 2 1, 2 4 2 Sc h o o l St a t e R e v e n u e s 8 , 3 9 6 $ 8 , 3 9 6 $ 8 , 6 4 8 $ Ti t l e M o n i e s - - - Gr a n t s Pr i v a t e D o n a t i o n s - P l e d g e d Pr i v a t e D o n a t i o n s - P l a n n e d t o R a i s e 99 4 99 4 99 4 To t a l 9, 3 9 0 $ 9, 3 9 0 $ 9, 6 4 2 $ St a t e R e v e n u e p e r S t u d e n t $6 , 7 5 3 $6 , 7 5 3 $6 , 9 5 6 4 4 5 Ex p e n s e s Sc h o o l P e r s o n n e l N o S a l I n c r 3 % i n c r 3 % i n c r Su b - T o t a l S c h o o l P e r s o n n e l 5, 2 0 7 $ 5 , 3 6 3 $ 5 , 5 2 4 $ Va r i a b l e B e n e f i t s 2 0 1 $ 2 0 7 $ 2 1 3 $ Fi x e d B e n e f i t s 4 1 2 4 1 2 4 1 2 To t a l B e n e f i t s 61 3 $ 6 1 9 $ 6 2 5 $ To t a l S c h o o l P e r s o n n e l 5 , 8 2 0 $ 5 , 9 8 2 $ 6 , 1 4 9 $ Sc h o o l N o n - P e r s o n n e l 3 % i n c r 3 % i n c r 3 % i n c r Pr o f . C o n t r a c t e d S e r v i c e s 7 8 3 $ 8 0 6 $ 8 3 1 $ Su p p l i e s & M a t e r i a l s 4 4 1 4 5 4 4 6 7 Ut i l i t i e s a n d M a i n t 6 2 2 6 4 0 6 6 0 Ot h e r O p e r a t i n g c o s t s 3 2 4 3 3 4 3 4 4 Mi s c e l l a n e o u s - - - CM O C h a r g e 33 4 34 4 35 5 To t a l S c h o o l N o n - P e r s o n n e l 2, 5 0 4 $ 2, 5 7 9 $ 2, 6 5 6 $ To t a l S c h o o l E x p e n s e s 8, 3 2 4 $ 8, 5 6 1 $ 8, 8 0 5 $ Re v e n u e A v a i l a b l e f o r D e b t S e r v i c e 1, 0 6 6 $ 82 9 $ 83 7 $ De b t S e r v i c e 88 5 88 5 88 5 88 5 $ 88 5 $ 88 5 $ Su r p l u s / S h o r t f a l l 18 1 $ (5 6 ) $ (4 8 ) $ Co v e r a g e 1. 2 0 0. 9 4 0. 9 5 Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 1 B _ 4 s e c t i o n . x l s I S Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s As s u m p t i o n P a g e Sa l a r y A s s u m p t i o n s 2 0 0 6 20 1 0 He a d C o u n t A s s u m p t i o n s N o n - p e r s o n n e l C o s t s Av e r a g e T e a c h e r S a l a r y 4 4 $ $ 5 0 Pr i m a r y Pr o f . C o n t r a c t e d S e r v i c e s 7 3 8 . 0 1 Su p e r i n t e n d e n t 8 0 $ 9 0 Pr e K S t u d e n t s / S e c t i o n - Ut i l i t i e s a n d M a i n t 586.10 Se c o n d a r y S c h o o l L e a d e r 80 $ 9 0 St u d e n t s / S e c t i o n 22 S u p p l i e s & M a t e r i a l s 415.30 Pr i m a r y S c h o o l L e a d e r 80 $ 9 0 Te a c h e r s / S e c t i o n 1. 6 0 Ot h e r O p e r a t i n g c o s t s 305.40 Adm i n . C o o r d 58 $ 6 5 Mi d d l e Mi s c e l l a n e o u s DP C o o r d i n a t o r 58 $ 6 5 St u d e n t s / S e c t i o n 27 MY P C o o r d 5 8 $ 6 5 Te a c h e r s / S e c t i o n 1 . 4 0 Be n e f i t C o s t A s s u m p t i o n s At t e n d a n c e C l e r k 18 $ 2 0 Hi g h Fi x e d B e n e f i t s - $ 3 . 7 K 3.70$ St r i n gs s t a f f 27 $ 3 0 St u d e n t s / S e c t i o n 27 V a r i a b l e B e n e f i t s - 3 . 8 6 % 3.86% Li b r a r i a n 4 4 $ 5 0 Te a c h e r s / S e c t i o n 1 . 4 5 0. 5 5 0 0 % T R S Te a c h e r ' s A i d e s 18 $ 2 0 An n u a l R e t e n t i o n 9 , 1 0 1 0 0 % 0. 8 4 0 0 % U n e m p l o y m e n t IT 59 $ 6 6 Ann u a l R e t e n t i o n 1 1 , 1 2 90 % 0. 5 1 9 1 % W o r k e r ' s c o m p Fa c i l i t i e s M a n a ger 29 $ 3 2 Re v e n u e A s s u m p t i o n s 1. 4 5 0 0 % M e d i c a r e Nu r s e 4 4 $ 5 0 AD A % 97 % 0. 5 0 0 0 % T R S - n e w h i r e s Re g i s t r a r 20 $ 2 3 St a t e F u n d i n g / A D A 6. 1 9 $ PY P C o o r d / D e a n o f S t u d e n t s 58 $ 6 5 Ti t l e $ - Co u n s e l o r s / I n s t r u c t i o n a l C o a c h 49 $ 5 5 Ti t l e % 0 % Of f i c e A i d e 1 8 $ 2 0 Lu n c h r o o m p e r s o n n e l (co n t r a c t ) - $0 Gr o w t h A s s u m p t i o n s Ja n i t o r 18 $ 2 0 In f l a t i o n R a t e - 3 % 3 % 15 % b u m p f o r g r o w t h Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 1 B _ 4 s e c t i o n . x l s a s s m p Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s I n p u t P a g e E m p l o y e e s Ye a r 1 8 1 9 2 0 Em p l o y e e s 2 0 1 3 / 1 4 2 0 1 4 / 1 5 2 0 1 5 / 1 6 Su p e r i n t e n d e n t - - - Se c o n d a r y S c h o o l L e a d e r 1. 0 0 1. 0 0 1. 0 0 Pr i m a r y S c h o o l L e a d e r 1. 0 0 1 1 . 0 0 1. 0 0 Ad m i n . C o o r d 1. 0 0 1. 0 0 1. 0 0 PY P C o o r d / D e a n o f S t u d e n t s 2. 0 0 2 2 . 0 0 2. 0 0 DP C o o r d i n a t o r 1. 0 0 1. 0 0 1. 0 0 MY P C o o r d 1. 0 0 1. 0 0 1. 0 0 At t e n d a n c e C l e r k 1. 0 0 1. 0 0 1. 0 0 St r i n g s s t a f f 1. 0 0 1. 0 0 1. 0 0 Li b r a r i a n 2. 0 0 2. 0 0 2. 0 0 Te a c h e r ' s A i d e s 8. 0 0 8. 0 0 8. 0 0 IT 1. 0 0 1. 0 0 1. 0 0 Fa c i l i t i e s M a n a g e r 1. 0 0 1. 0 0 1. 0 0 Nu r s e 2. 0 0 2. 0 0 2. 0 0 Re g i s t r a r 1. 0 0 1. 0 0 1. 0 0 Co u n s e l o r s / I n s t r u c t i o n a l C o a c h 3. 0 0 1 3 . 0 0 3. 0 0 Of f i c e A i d e 4. 0 0 2 4 . 0 0 4. 0 0 Lu n c h r o o m p e r s o n n e l ( c o n t r a c t ) - - - Ja n i t o r 2. 0 0 2. 0 0 2. 0 0 To t a l F T E ' s 33 . 0 0 6 3 3 . 0 0 33 . 0 0 Po s i t i o n s 26 . 0 0 26 . 0 0 26 . 0 0 Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 1 B _ 4 s e c t i o n . x l s i n p e m p Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s Pr o j e c t e d C a s h F l o w a n d D e b t S e r v i c e C o v e r a g e Fi s c a l R e v e n u e Projected Ye a r A v a i l a b l e P r o j e c t e d D e b t S e r v i c e P r o j e c t e d C u m u l a t i v e En d F o r D e b t O w n e r I n t . N e w M o n e y C a s h C a s h 30 - A u g S e r v i c e E x i s t i n g L o a n S e r i e s x S e r i e s y T o t a l F l o w F l o w 20 1 4 1 , 0 6 6 , 4 2 2 8 8 5 , 0 0 0 - - 88 5 , 0 0 0 18 1 , 4 2 2 181,422 20 1 5 82 9 , 0 8 2 88 5 , 0 0 0 - - 88 5 , 0 0 0 (5 5 , 9 1 8 ) 125,504 20 1 6 83 6 , 5 0 2 88 5 , 0 0 0 - - 88 5 , 0 0 0 (4 8 , 4 9 8 ) 77,006 Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 1 B _ 4 s e c t i o n . x l s C F TAB 6 Westlake Academy Budget for Option 2-A High School, 6th - 8th grade Middle School, Media Center, Muli-Purpose Bld'g and K-5 Primary School Addition and Existing Kitchen Renovation all to open year four, Fall 2013 Budget Detail Report Cost Code DescriptionBudgetNotes 01Professional Services 01100Project Management Services$300,656 Based on 3% of construction cost 01120Project Management Additional Services $0 01130Project Management Reimbursables $30,066 01200A/E Services - Planning (---)$0 01210A/E Services - Basic Services $668,124 Based on 7% of construction cost 01220A/E Additional Services $33,406 01230A/E Services Reimbursables $36,000 Other Consultants & Related Expenses 01300Civil Engineer (---)$205,000 01310Surveying (---)$50,000 Allowance 01320Signage (---)$19,000 01330Geotechnical (---)$44,000 01340Environmental/AHERA Report $25,000 01350Materials Testing (---)$124,986 1% of construction 01360[blank]$0 01370Data/IT/Security $102,000 ` 01380Regulatory/Printing/Permits/Advert $95,446 1% of const 01390Other Reimbursables/Expenses $55,000 Subtotal Professional Services $1,788,685 02Prime Construction Contract 02200Construction Contract $9,544,634 See Detail Estimates 02210Contractor Contingency $0 Inc. in construction costs above 02220Construction Contingency - 5%$477,232 Subtotal Prime Construction Contract$10,021,866 03Other Capital Improvement Contracts 03100HVAC System Test., Adjust. & Balancing $0 In Construction Contract 03110Telephone $85,500 Allowance 03120Utility Service/Easements/Tap Fees $40,000 Allowance 03130Temporary Utilities $0 In Construction Contract 03140Signs $23,000 Allowance 03150Fencing/Covered Canopy $175,000 03160Security Systems $105,533 $1.75/SF 03170IT/Data (infrastructure)$146,475 $2.50/SF 03180IT Hardware $694,000 03200Furnishings/Equipment $645,000 Subtotal Other Construction Contracts$1,914,508 Totals $13,725,058 04Owner's Internal Costs 04100Internal costs, fees, etc.$0 04200Interest/closing expenses$0 04300Blank$0 Subtotal Internal Costs$0 05Owner's Contingency 05100Owner's Project Contingency - (5%)$686,253 Subtotal Contingency*$686,253 Project Grand Totals$14,411,311 3/4/2011, 4:23 PM Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s In p u t P a g e E n r o l l m e n t / T e a c h i n g S t a f f Ye a r 1 8 1 9 2 0 Se c t i o n s 2 0 1 3 / 1 4 2 0 1 4 / 1 5 2 0 1 5 / 1 6 Pr e K - - - K5 5 5 1s t 5 5 5 2n d 5 5 5 3r d 5 5 5 4t h 5 5 5 5t h 5 5 5 6t h 4 4 4 7t h 4 4 4 8t h 4 4 4 9t h 4 4 4 10 t h 4 4 4 11 t h 4 4 4 12 t h 4 4 4 To t a l P r i m a r y 30 30 30 To t a l M i d d l e 12 12 12 To t a l H i g h 16 16 16 To t a l 58 58 58 St u d e n t s Pr e K - - - K 11 0 11 0 11 0 1s t 11 0 11 0 11 0 2n d 11 0 11 0 11 0 3r d 11 0 11 0 11 0 4t h 11 0 11 0 11 0 5t h 11 0 11 0 11 0 6t h 10 8 10 8 10 8 7t h 10 8 10 8 10 8 8t h 10 8 10 8 10 8 9t h 10 8 10 8 10 8 10 t h 10 8 10 8 10 8 11 t h 97 97 97 12 t h 97 97 97 To t a l P r i m a r y 66 0 66 0 66 0 P Y P To t a l M i d d l e 54 0 54 0 54 0 M Y P To t a l H i g h 19 4 19 4 19 4 D P To t a l 1, 3 9 4 1, 3 9 4 1, 3 9 4 Te a c h i n g S t a f f Pr i m a r y 4 8 . 0 0 48 . 0 0 48 . 0 0 Mi d d l e 16 . 8 0 16 . 8 0 16 . 8 0 Hi g h 23 . 2 0 23 . 2 0 23 . 2 0 88 . 0 0 88 . 0 0 88 . 0 0 St u d e n t / T e a c h e r R a t i o 15 . 8 5 15 . 8 5 15 . 8 5 Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 2 A _ 5 s e c t i o n . x l s i n p e n r o l l Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s In c o m e S t a t e m e n t ( 0 0 0 ) No S t a t e i n c N o S t a t e i n c 3 % S t a t e i n c 6. 7 5 8 6 . 7 5 8 6 . 9 6 1 Ye a r 1 8 1 9 2 0 Re v e n u e s 2 0 1 3 / 2 0 1 4 2 0 1 4 / 2 0 1 5 2 0 1 5 / 2 0 1 6 St u d e n t E n r o l l m e n t 1, 3 9 4 1, 3 9 4 1, 3 9 4 Sc h o o l St a t e R e v e n u e s 9 , 4 2 3 $ 9 , 4 2 3 $ 9 , 7 0 6 $ Ti t l e M o n i e s - - - Gr a n t s Pr i v a t e D o n a t i o n s - P l e d g e d Pr i v a t e D o n a t i o n s - P l a n n e d t o R a i s e 1 , 1 1 6 1, 1 1 6 1, 1 1 6 To t a l 10 , 5 3 9 $ 10 , 5 3 9 $ 10 , 8 2 1 $ St a t e R e v e n u e p e r S t u d e n t $6 , 7 5 3 $6 , 7 5 3 $6 , 9 5 6 4 4 5 Ex p e n s e s Sc h o o l P e r s o n n e l N o s a l a r y i n c 3 % i n c r 3 % i n c r Su b - T o t a l S c h o o l P e r s o n n e l 5, 8 0 3 $ 5 , 9 7 7 $ 6 , 1 5 6 $ Va r i a b l e B e n e f i t s 2 2 4 $ 2 3 1 $ 2 3 8 $ Fi x e d B e n e f i t s 4 5 5 4 5 5 4 5 5 To t a l B e n e f i t s 67 9 $ 6 8 6 $ 6 9 3 $ To t a l S c h o o l P e r s o n n e l 6 , 4 8 2 $ 6 , 6 6 2 $ 6 , 8 4 9 $ Sc h o o l N o n - P e r s o n n e l 3 % i n c r 3 % i n c r 3 % i n c r Pr o f . C o n t r a c t e d S e r v i c e s 8 1 7 $ 8 4 2 $ 8 6 7 $ Su p p l i e s & M a t e r i a l s 4 6 2 4 7 6 4 9 0 Ut i l i t i e s a n d M a i n t 6 5 2 6 7 1 6 9 2 Ot h e r O p e r a t i n g c o s t s 3 2 4 3 3 4 3 4 4 Mi s c e l l a n e o u s - - - CM O C h a r g e 33 4 34 4 35 5 To t a l S c h o o l N o n - P e r s o n n e l 2, 5 8 9 $ 2, 6 6 7 $ 2, 7 4 7 $ To t a l S c h o o l E x p e n s e s 9, 0 7 1 $ 9, 3 2 9 $ 9, 5 9 5 $ Re v e n u e A v a i l a b l e f o r D e b t S e r v i c e 1, 4 6 8 $ 1, 2 1 0 $ 1, 2 2 6 $ De b t S e r v i c e 96 5 96 5 96 5 96 5 $ 96 5 $ 96 5 $ Su r p l u s / S h o r t f a l l 50 3 $ 24 5 $ 26 1 $ Co v e r a g e 1. 5 2 1. 2 5 1. 2 7 Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 2 A _ 5 s e c t i o n . x l s I S Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s As s u m p t i o n P a g e Sa l a r y A s s u m p t i o n s 2 0 0 6 20 1 0 He a d C o u n t A s s u m p t i o n s N o n - p e r s o n n e l C o s t s Av e r a g e T e a c h e r S a l a r y 4 4 $ $ 5 0 Pr i m a r y Pr o f . C o n t r a c t e d S e r v i c e s 7 7 0 . 0 9 Su p e r i n t e n d e n t 8 0 $ 9 0 Pr e K S t u d e n t s / S e c t i o n - Ut i l i t i e s a n d M a i n t 614.48 Se c o n d a r y S c h o o l L e a d e r 80 $ 9 0 St u d e n t s / S e c t i o n 22 S u p p l i e s & M a t e r i a l s 435.41 Pr i m a r y S c h o o l L e a d e r 80 $ 9 0 Te a c h e r s / S e c t i o n 1. 6 0 Ot h e r O p e r a t i n g c o s t s 305.40 Adm i n . C o o r d 58 $ 6 5 Mi d d l e Mi s c e l l a n e o u s DP C o o r d i n a t o r 58 $ 6 5 St u d e n t s / S e c t i o n 27 MY P C o o r d 5 8 $ 6 5 Te a c h e r s / S e c t i o n 1 . 4 0 Be n e f i t C o s t A s s u m p t i o n s At t e n d a n c e C l e r k 18 $ 2 0 Hi g h Fi x e d B e n e f i t s - $ 3 . 7 K 3.70$ St r i n gs s t a f f 27 $ 3 0 St u d e n t s / S e c t i o n 27 V a r i a b l e B e n e f i t s - 3 . 8 6 % 3.86% Li b r a r i a n 4 4 $ 5 0 Te a c h e r s / S e c t i o n 1 . 4 5 0. 5 5 0 0 % T R S Te a c h e r ' s A i d e s 18 $ 2 0 An n u a l R e t e n t i o n 9 , 1 0 1 0 0 % 0. 8 4 0 0 % U n e m p l o y m e n t IT 59 $ 6 6 Ann u a l R e t e n t i o n 1 1 , 1 2 90 % 0. 5 1 9 1 % W o r k e r ' s c o m p Fa c i l i t i e s M a n a ger 29 $ 3 2 Re v e n u e A s s u m p t i o n s 1. 4 5 0 0 % M e d i c a r e Nu r s e 4 4 $ 5 0 AD A % 97 % 0. 5 0 0 0 % T R S - n e w h i r e s Re g i s t r a r 20 $ 2 3 St a t e F u n d i n g / A D A 6. 1 9 $ PY P C o o r d / D e a n o f S t u d e n t s 58 $ 6 5 Ti t l e $ - Co u n s e l o r s / I n s t r u c t i o n a l C o a c h 49 $ 5 5 Ti t l e % 0 % Of f i c e A i d e 1 8 $ 2 0 Lu n c h r o o m p e r s o n n e l (co n t r a c t ) - $0 Gr o w t h A s s u m p t i o n s Ja n i t o r 18 $ 2 0 In f l a t i o n R a t e - 3 % 3 % 20 % b u m p f o r g r o w t h Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 2 A _ 5 s e c t i o n . x l s a s s m p Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s I n p u t P a g e E m p l o y e e s Ye a r 1 8 1 9 2 0 Em p l o y e e s 2 0 1 3 / 1 4 2 0 1 4 / 1 5 2 0 1 5 / 1 6 Su p e r i n t e n d e n t - - - Se c o n d a r y S c h o o l L e a d e r 1. 0 0 1. 0 0 1. 0 0 Pr i m a r y S c h o o l L e a d e r 1. 0 0 1 1 . 0 0 1. 0 0 Ad m i n . C o o r d 1. 0 0 1. 0 0 1. 0 0 PY P C o o r d / D e a n o f S t u d e n t s 3. 0 0 2 3 . 0 0 3. 0 0 DP C o o r d i n a t o r 1. 0 0 1. 0 0 1. 0 0 MY P C o o r d 1. 0 0 1. 0 0 1. 0 0 At t e n d a n c e C l e r k 1. 0 0 1. 0 0 1. 0 0 St r i n g s s t a f f 1. 0 0 1. 0 0 1. 0 0 Li b r a r i a n 2. 0 0 2. 0 0 2. 0 0 Te a c h e r ' s A i d e s 8. 0 0 8. 0 0 8. 0 0 IT 1. 0 0 1. 0 0 1. 0 0 Fa c i l i t i e s M a n a g e r 1. 0 0 1. 0 0 1. 0 0 Nu r s e 2. 0 0 2. 0 0 2. 0 0 Re g i s t r a r 1. 0 0 1. 0 0 1. 0 0 Co u n s e l o r s / I n s t r u c t i o n a l C o a c h 4 . 0 0 2 4 . 0 0 4. 0 0 Of f i c e A i d e 4. 0 0 2 4 . 0 0 4. 0 0 Lu n c h r o o m p e r s o n n e l ( c o n t r a c t ) - - - Ja n i t o r 2. 0 0 2. 0 0 2. 0 0 To t a l F T E ' s 35 . 0 0 7 3 5 . 0 0 35 . 0 0 Po s i t i o n s 26 . 0 0 26 . 0 0 26 . 0 0 13 9 4 . 4 1 3 9 4 . 4 1 3 9 4 . 4 Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 2 A _ 5 s e c t i o n . x l s i n p e m p Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s Pr o j e c t e d C a s h F l o w a n d D e b t S e r v i c e C o v e r a g e Fi s c a l R e v e n u e Projected Ye a r A v a i l a b l e P r o j e c t e d D e b t S e r v i c e P r o j e c t e d C u m u l a t i v e En d F o r D e b t O w n e r I n t . N e w M o n e y C a s h C a s h 30 - A u g S e r v i c e E x i s t i n g L o a n S e r i e s x S e r i e s y T o t a l F l o w F l o w 20 1 3 1 , 4 6 7 , 9 7 9 9 6 5 , 0 0 0 - - 96 5 , 0 0 0 50 2 , 9 7 9 502,979 20 1 4 1, 2 0 9 , 5 1 0 96 5 , 0 0 0 - - 96 5 , 0 0 0 24 4 , 5 1 0 747,489 20 1 5 1, 2 2 5 , 9 8 2 96 5 , 0 0 0 - - 96 5 , 0 0 0 26 0 , 9 8 2 1,008,471 Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 2 A _ 5 s e c t i o n . x l s C F TAB 7 Westlake Academy Budget for Option 2-B High School, 7th & 8th grade Middle School, Media Center, Muli-Purpose Bld'g & K-6 PS School Addition and Existing Kitchen Renovation all to open year four, Fall 2013 Budget Detail Report Cost Code DescriptionBudgetNotes 01Professional Services 01100Project Management Services$310,756 Based on 3% of construction cost 01120Project Management Additional Services $0 01130Project Management Reimbursables $31,076 01200A/E Services - Planning (---)$0 01210A/E Services - Basic Services $690,569 Based on 7% of construction cost 01220A/E Additional Services $34,528 01230A/E Services Reimbursables $36,000 Other Consultants & Related Expenses 01300Civil Engineer (---)$205,000 01310Surveying (---)$50,000 Allowance 01320Signage (---)$19,000 01330Geotechnical (---)$44,000 01340Environmental/AHERA Report $25,000 01350Materials Testing (---)$133,960 1% of construction 01360[blank]$0 01370Data/IT/Security $102,000 ` 01380Regulatory/Printing/Permits/Advert $98,653 1% of const 01390Other Reimbursables/Expenses $55,000 Subtotal Professional Services $1,835,542 02Prime Construction Contract 02200Construction Contract $9,865,269 See Detail Estimates 02210Contractor Contingency $0 Inc. in construction costs above 02220Construction Contingency - 5%$493,263 Subtotal Prime Construction Contract$10,358,532 03Other Capital Improvement Contracts 03100HVAC System Test., Adjust. & Balancing $0 In Construction Contract 03110Telephone $85,500 Allowance 03120Utility Service/Easements/Tap Fees $40,000 Allowance 03130Temporary Utilities $0 In Construction Contract 03140Signs $23,000 Allowance 03150Fencing/Covered Canopy $175,000 03160Security Systems $107,795 $1.75/SF 03170IT/Data (infrastructure)$149,708 $2.50/SF 03180IT Hardware $705,000 03200Furnishings/Equipment $636,000 Subtotal Other Construction Contracts$1,922,003 Totals $14,116,077 04Owner's Internal Costs 04100Internal costs, fees, etc.$0 04200Interest/closing expenses$0 04300Blank$0 Subtotal Internal Costs$0 05Owner's Contingency 05100Owner's Project Contingency - (5%)$705,804 Subtotal Contingency*$705,804 Project Grand Totals$14,821,881 3/4/2011, 4:23 PM Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s In p u t P a g e E n r o l l m e n t / T e a c h i n g S t a f f Ye a r 1 8 1 9 2 0 Se c t i o n s 2 0 1 3 / 1 4 2 0 1 4 / 1 5 2 0 1 5 / 1 6 Pr e K - - - K5 5 5 1s t 5 5 5 2n d 5 5 5 3r d 5 5 5 4t h 5 5 5 5t h 5 5 5 6t h 5 5 5 7t h 4 4 4 8t h 4 4 4 9t h 4 4 4 10 t h 4 4 4 11 t h 4 4 4 12 t h 4 4 4 To t a l P r i m a r y 30 30 30 To t a l M i d d l e 13 13 13 To t a l H i g h 16 16 16 To t a l 59 59 59 St u d e n t s Pr e K - - - K 11 0 11 0 11 0 1s t 11 0 11 0 11 0 2n d 11 0 11 0 11 0 3r d 11 0 11 0 11 0 4t h 11 0 11 0 11 0 5t h 11 0 11 0 11 0 6t h 11 0 11 0 11 0 7t h 10 8 10 8 10 8 8t h 10 8 10 8 10 8 9t h 10 8 10 8 10 8 10 t h 10 8 10 8 10 8 11 t h 97 97 97 12 t h 97 97 97 To t a l P r i m a r y 77 0 77 0 77 0 P Y P To t a l M i d d l e 43 2 43 2 43 2 M Y P To t a l H i g h 19 4 19 4 19 4 D P To t a l 1, 3 9 6 1, 3 9 6 1, 3 9 6 Te a c h i n g S t a f f Pr i m a r y 48 . 0 0 48 . 0 0 48 . 0 0 Mi d d l e 18 . 2 0 18 . 2 0 18 . 2 0 Hi g h 23 . 2 0 23 . 2 0 23 . 2 0 89 . 4 0 89 . 4 0 89 . 4 0 St u d e n t / T e a c h e r R a t i o 15 . 6 2 15 . 6 2 15 . 6 2 Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 2 B _ 5 s e c t i o n . x l s i n p e n r o l l Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s In c o m e S t a t e m e n t ( 0 0 0 ) No S t a t e i n c N o S t a t e i n c 3 % S t a t e i n c 6. 7 5 8 6 . 7 5 8 6 . 9 6 1 Ye a r 1 8 1 9 2 0 Re v e n u e s 2 0 1 3 / 2 0 1 4 2 0 1 4 / 2 0 1 5 2 0 1 5 / 2 0 1 6 St u d e n t E n r o l l m e n t 1, 3 9 6 1, 3 9 6 1, 3 9 6 Sc h o o l St a t e R e v e n u e s 9 , 4 3 7 $ 9 , 4 3 7 $ 9 , 7 2 0 $ Ti t l e M o n i e s - - - Gr a n t s Pr i v a t e D o n a t i o n s - P l e d g e d Pr i v a t e D o n a t i o n s - P l a n n e d t o R a i s e 1 , 1 1 7 1, 1 1 7 1, 1 1 7 To t a l 10 , 5 5 4 $ 10 , 5 5 4 $ 10 , 8 3 7 $ St a t e R e v e n u e p e r S t u d e n t $6 , 7 5 3 $6 , 7 5 3 $6 , 9 5 6 4 4 5 Ex p e n s e s Sc h o o l P e r s o n n e l N o s a l a r y i n c 3 % i n c r 3 % i n c r Su b - T o t a l S c h o o l P e r s o n n e l 5, 8 7 2 $ 6 , 0 4 8 $ 6 , 2 2 9 $ Va r i a b l e B e n e f i t s 2 2 7 $ 2 3 3 $ 2 4 0 $ Fi x e d B e n e f i t s 4 6 0 4 6 0 4 6 0 To t a l B e n e f i t s 68 7 $ 6 9 4 $ 7 0 1 $ To t a l S c h o o l P e r s o n n e l 6 , 5 5 9 $ 6 , 7 4 2 $ 6 , 9 3 0 $ Sc h o o l N o n - P e r s o n n e l 3 % i n c r 3 % i n c r 3 % i n c r Pr o f . C o n t r a c t e d S e r v i c e s 8 1 7 $ 8 4 2 $ 8 6 7 $ Su p p l i e s & M a t e r i a l s 4 6 2 4 7 6 4 9 0 Ut i l i t i e s a n d M a i n t 6 5 2 6 7 1 6 9 2 Ot h e r O p e r a t i n g c o s t s 3 2 4 3 3 4 3 4 4 Mi s c e l l a n e o u s - - - CM O C h a r g e 33 4 34 4 35 5 To t a l S c h o o l N o n - P e r s o n n e l 2, 5 8 9 $ 2, 6 6 7 $ 2, 7 4 7 $ To t a l S c h o o l E x p e n s e s 9, 1 4 8 $ 9, 4 0 9 $ 9, 6 7 7 $ Re v e n u e A v a i l a b l e f o r D e b t S e r v i c e 1, 4 0 6 $ 1, 1 4 5 $ 1, 1 6 0 $ De b t S e r v i c e 99 0 99 0 98 5 99 0 $ 99 0 $ 98 5 $ Su r p l u s / S h o r t f a l l 41 6 $ 15 5 $ 17 5 $ Co v e r a g e 1. 4 2 1. 1 6 1. 1 8 Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 2 B _ 5 s e c t i o n . x l s I S Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s As s u m p t i o n P a g e Sa l a r y A s s u m p t i o n s 2 0 0 6 20 1 0 He a d C o u n t A s s u m p t i o n s N o n - p e r s o n n e l C o s t s Av e r a g e T e a c h e r S a l a r y 4 4 $ $ 5 0 Pr i m a r y Pr o f . C o n t r a c t e d S e r v i c e s 7 7 0 . 0 9 Su p e r i n t e n d e n t 8 0 $ 9 0 Pr e K S t u d e n t s / S e c t i o n - Ut i l i t i e s a n d M a i n t 614.48 Se c o n d a r y S c h o o l L e a d e r 80 $ 9 0 St u d e n t s / S e c t i o n 22 S u p p l i e s & M a t e r i a l s 435.41 Pr i m a r y S c h o o l L e a d e r 80 $ 9 0 Te a c h e r s / S e c t i o n 1. 6 0 Ot h e r O p e r a t i n g c o s t s 305.40 Adm i n . C o o r d 58 $ 6 5 Mi d d l e Mi s c e l l a n e o u s DP C o o r d i n a t o r 58 $ 6 5 St u d e n t s / S e c t i o n 27 MY P C o o r d 5 8 $ 6 5 Te a c h e r s / S e c t i o n 1 . 4 0 Be n e f i t C o s t A s s u m p t i o n s At t e n d a n c e C l e r k 18 $ 2 0 Hi g h Fi x e d B e n e f i t s - $ 3 . 7 K 3.70$ St r i n gs s t a f f 27 $ 3 0 St u d e n t s / S e c t i o n 27 V a r i a b l e B e n e f i t s - 3 . 8 6 % 3.86% Li b r a r i a n 4 4 $ 5 0 Te a c h e r s / S e c t i o n 1 . 4 5 0. 5 5 0 0 % T R S Te a c h e r ' s A i d e s 18 $ 2 0 An n u a l R e t e n t i o n 9 , 1 0 1 0 0 % 0. 8 4 0 0 % U n e m p l o y m e n t IT 59 $ 6 6 Ann u a l R e t e n t i o n 1 1 , 1 2 90 % 0. 5 1 9 1 % W o r k e r ' s c o m p Fa c i l i t i e s M a n a ger 29 $ 3 2 Re v e n u e A s s u m p t i o n s 1. 4 5 0 0 % M e d i c a r e Nu r s e 4 4 $ 5 0 AD A % 97 % 0. 5 0 0 0 % T R S - n e w h i r e s Re g i s t r a r 20 $ 2 3 St a t e F u n d i n g / A D A 6. 1 9 $ PY P C o o r d / D e a n o f S t u d e n t s 58 $ 6 5 Ti t l e $ - Co u n s e l o r s / I n s t r u c t i o n a l C o a c h 49 $ 5 5 Ti t l e % 0 % Of f i c e A i d e 1 8 $ 2 0 Lu n c h r o o m p e r s o n n e l (co n t r a c t ) - $0 Gr o w t h A s s u m p t i o n s Ja n i t o r 18 $ 2 0 In f l a t i o n R a t e - 3 % 3 % 20 % b u m p f o r g r o w t h Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 2 B _ 5 s e c t i o n . x l s a s s m p Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s I n p u t P a g e E m p l o y e e s Ye a r 1 8 1 9 2 0 Em p l o y e e s 2 0 1 3 / 1 4 2 0 1 4 / 1 5 2 0 1 5 / 1 6 Su p e r i n t e n d e n t - - - Se c o n d a r y S c h o o l L e a d e r 1. 0 0 1. 0 0 1. 0 0 Pr i m a r y S c h o o l L e a d e r 1. 0 0 1 1 . 0 0 1. 0 0 Ad m i n . C o o r d 1. 0 0 1. 0 0 1. 0 0 PY P C o o r d / D e a n o f S t u d e n t s 3. 0 0 2 3 . 0 0 3. 0 0 DP C o o r d i n a t o r 1. 0 0 1. 0 0 1. 0 0 MY P C o o r d 1. 0 0 1. 0 0 1. 0 0 At t e n d a n c e C l e r k 1. 0 0 1. 0 0 1. 0 0 St r i n g s s t a f f 1. 0 0 1. 0 0 1. 0 0 Li b r a r i a n 2. 0 0 2. 0 0 2. 0 0 Te a c h e r ' s A i d e s 8. 0 0 8. 0 0 8. 0 0 IT 1. 0 0 1. 0 0 1. 0 0 Fa c i l i t i e s M a n a g e r 1. 0 0 1. 0 0 1. 0 0 Nu r s e 2. 0 0 2. 0 0 2. 0 0 Re g i s t r a r 1. 0 0 1. 0 0 1. 0 0 Co u n s e l o r s / I n s t r u c t i o n a l C o a c h 4 . 0 0 2 4 . 0 0 4. 0 0 Of f i c e A i d e 4. 0 0 2 4 . 0 0 4. 0 0 Lu n c h r o o m p e r s o n n e l ( c o n t r a c t ) - - - Ja n i t o r 2. 0 0 2. 0 0 2. 0 0 To t a l F T E ' s 35 . 0 0 7 3 5 . 0 0 35 . 0 0 Po s i t i o n s 26 . 0 0 26 . 0 0 26 . 0 0 13 9 6 . 4 1 3 9 6 . 4 1 3 9 6 . 4 Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 2 B _ 5 s e c t i o n . x l s i n p e m p Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s Pr o j e c t e d C a s h F l o w a n d D e b t S e r v i c e C o v e r a g e Fi s c a l R e v e n u e Projected Ye a r A v a i l a b l e P r o j e c t e d D e b t S e r v i c e P r o j e c t e d C u m u l a t i v e En d F o r D e b t O w n e r I n t . N e w M o n e y C a s h C a s h 30 - A u g S e r v i c e E x i s t i n g L o a n S e r i e s x S e r i e s y T o t a l F l o w F l o w 20 1 3 1 , 4 0 5 , 9 0 8 9 9 0 , 0 0 0 - - 99 0 , 0 0 0 41 5 , 9 0 8 415,908 20 1 4 1, 1 4 5 , 2 7 8 99 0 , 0 0 0 - - 99 0 , 0 0 0 15 5 , 2 7 8 571,186 20 1 5 1, 1 5 9 , 9 3 2 99 0 , 0 0 0 - - 99 0 , 0 0 0 16 9 , 9 3 2 741,118 Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 2 B _ 5 s e c t i o n . x l s C F TAB 8 Westlake Academy Budget for Option 3 High School, Media Center, Muli-Purpose Bld'g and Kitchen Renovation to open Fall 2012 Middle School to open Fall 2014 Budget Detail Report Cost Code DescriptionBudgetNotes 01Professional Services 01100Project Management Services$271,576 Based on 3% of construction cost 01120Project Management Additional Services $0 01130Project Management Reimbursables $27,158 01200A/E Services - Planning (---)$0 01210A/E Services - Basic Services $603,501 Based on 7% of construction cost 01220A/E Additional Services $30,175 01230A/E Services Reimbursables $30,000 Other Consultants & Related Expenses $0 01300Civil Engineer (---)$190,000 01310Surveying (---)$45,000 Allowance 01320Signage (---)$17,000 01330Geotechnical (---)$36,000 01340Environmental/AHERA Report $20,000 01350Materials Testing (---)$115,146 1% of construction 01360[blank]$0 01370Data/IT/Security $82,000 ` 01380Regulatory/Printing/Permits/Advert $86,214 1% of const 01390Other Reimbursables/Expenses $45,000 Subtotal Professional Services $1,598,770 02Prime Construction Contract 02200Construction Contract $8,621,447 See Detail Estimate 02210Contractor Contingency $0 Inc. in construction costs above 02220Construction Contingency - 5%$431,072 Subtotal Prime Construction Contract$9,052,519 03Other Capital Improvement Contracts 03100HVAC System Test., Adjust. & Balancing $0 In Construction Contract 03110Telephone $75,500 Allowance 03120Utility Service/Easements/Tap Fees $40,000 Allowance 03130Temporary Utilities $0 In Construction Contract 03140Signs $21,000 Allowance 03150Fencing/Covered Canopy $175,000 03160Security Systems $96,433 $1.75/SF 03170IT/Data (infrastructure)$133,475 $2.50/SF 03180IT Hardware $628,000 03200Furnishings/Equipment $603,000 Subtotal Other Construction Contracts$1,772,408 Totals $12,423,697 04Owner's Internal Costs 04100Internal costs, fees, etc.$0 04200Interest/closing expenses$0 04300Blank$0 Subtotal Internal Costs$0 05Owner's Contingency 05100Owner's Project Contingency - (5%)$621,185 Subtotal Contingency*$621,185 Project Grand Totals$13,044,882 3/4/2011, 4:23 PM Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s In p u t P a g e E n r o l l m e n t / T e a c h i n g S t a f f Ye a r 1 7 1 8 1 9 2 0 Se c t i o n s 2 0 1 2 / 1 3 2 0 1 3 / 1 4 2 0 1 4 / 1 5 2 0 1 5 / 1 6 Pr e K - - - - K4 4 4 4 1s t 4 4 4 4 2n d 4 4 4 4 3r d 4 4 4 4 4t h 4 4 4 4 5t h 4 4 4 4 6t h 3 4 4 4 7t h 3 3 4 4 8t h 3 3 4 4 9t h 3 3 4 4 10 t h 3 3 4 4 11 t h 3 3 4 4 12 t h 3 3 4 4 To t a l P r i m a r y 24 24 24 24 To t a l M i d d l e 9 10 12 12 To t a l H i g h 12 12 16 16 To t a l 45 46 52 52 St u d e n t s Pr e K - - - - K 88 88 88 88 1s t 88 88 88 88 2n d 88 88 88 88 3r d 88 88 88 88 4t h 88 88 88 88 5t h 88 88 88 88 6t h 81 10 8 10 8 10 8 7t h 81 81 10 8 10 8 8t h 81 81 10 8 10 8 9t h 81 81 10 8 10 8 10 t h 81 81 10 8 10 8 11 t h 73 73 97 97 12 t h 73 73 97 97 To t a l P r i m a r y 52 8 52 8 52 8 52 8 To t a l M i d d l e 24 3 27 0 32 4 32 4 To t a l H i g h 30 8 30 8 41 0 41 0 To t a l 1, 0 7 9 1, 1 0 6 1, 2 6 2 1, 2 6 2 Te a c h i n g S t a f f Pr i m a r y 38 . 4 0 38 . 4 0 38 . 4 0 38 . 4 0 Mi d d l e 12 . 6 0 14 . 0 0 16 . 8 0 16 . 8 0 Hi g h 17 . 4 0 17 . 4 0 23 . 2 0 23 . 2 0 68 . 4 0 69 . 8 0 78 . 4 0 78 . 4 0 St u d e n t / T e a c h e r R a t i o 15 . 7 7 15 . 8 4 16 . 1 0 16 . 1 0 Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 3 _ 4 s e c t i o n . x l s i n p e n r o l l Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s In c o m e S t a t e m e n t ( 0 0 0 ) No S t a t e i n c N o S t a t e i n c N o S t a t e i n c 3 % S t a t e i n c 6. 7 5 8 6 . 7 5 8 6 . 7 5 8 6 . 9 6 1 Ye a r 1 7 1 8 1 9 2 0 Re v e n u e s 2 0 1 2 / 1 3 2 0 1 3 / 1 4 2 0 1 4 / 1 5 2 0 1 5 / 1 6 St u d e n t E n r o l l m e n t 1, 0 7 9 1, 1 0 6 1, 2 6 2 1, 2 6 2 Sc h o o l St a t e R e v e n u e s 7 , 2 9 0 $ 7 , 4 7 3 $ 8 , 5 3 1 $ 8 , 7 8 7 $ Ti t l e M o n i e s - - - - Gr a n t s Pr i v a t e D o n a t i o n s - P l e d g e d Pr i v a t e D o n a t i o n s - P l a n n e d t o R a i s e 86 3 88 5 1, 0 1 0 1, 0 1 0 To t a l 8, 1 5 3 $ 8, 3 5 8 $ 9, 5 4 1 $ 9, 7 9 7 $ St a t e R e v e n u e p e r S t u d e n t $6 , 7 5 3 $6 , 7 5 3 $6 , 7 5 3 $6 , 9 5 6 4 4 4 5 Ex p e n s e s Sc h o o l P e r s o n n e l N o S a l I n c r N o S a l I n c r 3 % i n c r 3 % i n c r Te a c h e r s S a l a r i e s 3, 3 8 7 $ 6 8 3 , 4 5 7 $ 3 , 9 9 9 $ 7 8 4 , 1 1 9 $ Su b - T o t a l S c h o o l P e r s o n n e l 4, 6 5 6 $ 4 , 7 2 6 $ 5 , 3 6 3 $ 5 , 5 2 4 $ Va r i a b l e B e n e f i t s 1 8 0 $ 1 8 2 $ 2 0 7 $ 2 1 3 $ Fi x e d B e n e f i t s 3 7 1 3 7 7 4 1 2 4 1 2 To t a l B e n e f i t s 55 1 $ 5 5 9 $ 6 1 9 $ 6 2 5 $ To t a l S c h o o l P e r s o n n e l 5 , 2 0 8 $ 5 , 2 8 5 $ 5 , 9 8 2 $ 6 , 1 4 9 $ Sc h o o l N o n - P e r s o n n e l 3 % i n c r 3 % i n c r 3 % i n c r 3 % i n c r Pr o f . C o n t r a c t e d S e r v i c e s 7 2 7 $ 7 4 9 $ 8 0 6 $ 8 3 1 $ Su p p l i e s & M a t e r i a l s 3 5 1 3 6 1 4 5 4 4 6 7 Ut i l i t i e s a n d M a i n t 4 9 5 5 1 0 6 4 0 6 6 0 Ot h e r O p e r a t i n g c o s t s 3 1 5 3 2 4 3 3 4 3 4 4 Mi s c e l l a n e o u s - - - - CM O C h a r g e 32 5 33 4 34 4 35 5 To t a l S c h o o l N o n - P e r s o n n e l 2, 2 1 2 $ 2, 2 7 9 $ 2, 5 7 9 $ 2, 6 5 6 $ To t a l S c h o o l E x p e n s e s 7, 4 2 0 $ 7, 5 6 3 $ 8, 5 6 1 $ 8, 8 0 5 $ Re v e n u e A v a i l a b l e f o r D e b t S e r v i c e 73 4 $ 79 4 $ 98 0 $ 99 2 $ De b t S e r v i c e 59 0 59 0 88 0 88 0 59 0 $ 59 0 $ 88 0 $ 88 0 $ Su r p l u s / S h o r t f a l l 14 4 $ 20 4 $ 10 0 $ 11 2 $ Co v e r a g e 1. 2 4 1. 3 5 1. 1 1 1. 1 3 Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 3 _ 4 s e c t i o n . x l s I S Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s As s u m p t i o n P a g e Sa l a r y A s s u m p t i o n s 2 0 0 6 He a d C o u n t A s s u m p t i o n s No n - p e r s o n n e l C o s t s Av e r a g e T e a c h e r S a l a r y 44 $ $ 4 9 . 5 2 Pr i m a r y Pr o f . C o n t r a c t e d S e r v i c e s 705.92 Su p e r i n t e n d e n t 80 $ 9 0 Pr e K S t u d e n t s / S e c t i o n - Pr o f . C o n t r a c t e d S e r v i c e s 806.44 Se c o n d a r y S c h o o l L e a d e r 80 $ 9 0 St u d e n t s / S e c t i o n 22 U t i l i t i e s a n d M a i n t Ph 1 480.66 Pr i m a r y S c h o o l L e a d e r 80 $ 9 0 Te a c h e r s / S e c t i o n 1. 6 0 Ut i l i t i e s a n d M a i n t Ph 2 640.45 Ad m i n . C o o r d 58 $ 6 5 Mi d d l e Su p p l i e s & M a t e r i a l s Ph 1 340.58 DP C o o r d i n a t o r 58 $ 6 5 St u d e n t s / S e c t i o n 27 S u p p l i e s & M a t e r i a l s Ph 2 453.81 MY P C o o r d 58 $ 6 5 Te a c h e r s / S e c t i o n 1. 4 0 Ot h e r O p e r a t i n g c o s t s 305.40 Att e n d a n c e C l e r k 18 $ 2 0 Hi g h Mi s c e l l a n e o u s St r i n gs s t a f f 27 $ 3 0 St u d e n t s / S e c t i o n 27 Li b r a r i a n 4 4 $ 5 0 Te a c h e r s / S e c t i o n 1 . 4 5 Be n e f i t C o s t A s s u m p t i o n s Te a c h e r ' s A i d e s 18 $ 2 0 An n u a l R e t e n t i o n 9 , 1 0 1 0 0 % F i x e d B e n e f i t s - $ 3 . 7 K 3.70$ IT 59 $ 6 6 Ann u a l R e t e n t i o n 1 1 , 1 2 90 % V a r i a b l e B e n e f i t s - 3 . 8 6 % 3.86% Fa c i l i t i e s M a n a ger 29 $ 3 2 Re v e n u e A s s u m p t i o n s 0. 5 5 0 0 % T R S Nu r s e 4 4 $ 5 0 AD A % 97 % 0. 8 4 0 0 % U n e m p l o y m e n t Re g i s t r a r 20 $ 2 3 St a t e F u n d i n g / A D A 6. 1 9 $ 0. 5 1 9 1 % W o r k e r ' s c o m p PY P C o o r d / D e a n o f S t u d e n t s 58 $ 6 5 Ti t l e $ - 1. 4 5 0 0 % M e d i c a r e Co u n s e l o r s / i n s t r u c t i o n a l C o a c h 49 $ 5 5 Ti t l e % 0 % 0 . 5 0 0 0 % T R S - n e w h i r e s Of f i c e A i d e 18 $ 2 0 Lu n c h r o o m p e r s o n n e l (co n t r a c t ) - $0 Gr o w t h A s s u m p t i o n s Ja n i t o r 18 $ 2 0 In f l a t i o n R a t e - 3 % 3 % 10 % b u m p f o r g r o w t h i n c r e m e n t a l P h a s e 1 10 % b u m p f o r g r o w t h i n c r e m e n t a l P h a s e 2 Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 3 _ 4 s e c t i o n . x l s a s s m p Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s I n p u t P a g e E m p l o y e e s Ye a r 1 7 1 8 1 9 2 0 Em p l o y e e s 2 0 1 2 / 1 3 2 0 1 3 / 1 4 2 0 1 4 / 1 5 2 0 1 5 / 1 6 Su p e r i n t e n d e n t - - - - Se c o n d a r y S c h o o l L e a d e r 1. 0 0 1. 0 0 1. 0 0 1. 0 0 Pr i m a r y S c h o o l L e a d e r 1. 0 0 1 1 . 0 0 1. 0 0 1. 0 0 Ad m i n . C o o r d 1. 0 0 1. 0 0 1. 0 0 1. 0 0 PY P C o o r d / D e a n o f S t u d e n t s 2. 0 0 2 2 . 0 0 2. 0 0 2. 0 0 DP C o o r d i n a t o r 1. 0 0 1. 0 0 1. 0 0 1. 0 0 MY P C o o r d 1. 0 0 1. 0 0 1. 0 0 1. 0 0 At t e n d a n c e C l e r k 1. 0 0 1. 0 0 1. 0 0 1. 0 0 St r i n g s s t a f f 1. 0 0 1. 0 0 1. 0 0 1. 0 0 Li b r a r i a n 2. 0 0 2. 0 0 2. 0 0 2. 0 0 Te a c h e r ' s A i d e s 8. 0 0 8. 0 0 8. 0 0 8. 0 0 IT 1. 0 0 1. 0 0 1. 0 0 1. 0 0 Fa c i l i t i e s M a n a g e r 1. 0 0 1. 0 0 1. 0 0 1. 0 0 Nu r s e 2. 0 0 2. 0 0 2. 0 0 2. 0 0 Re g i s t r a r 1. 0 0 1. 0 0 1. 0 0 1. 0 0 Co u n s e l o r s / i n s t r u c t i o n a l C o a c h 2 . 0 0 1 2 . 0 0 3. 0 0 3. 0 0 Of f i c e A i d e 4. 0 0 2 4 . 0 0 4. 0 0 4. 0 0 Lu n c h r o o m p e r s o n n e l ( c o n t r a c t ) - - - - Ja n i t o r 2. 0 0 2. 0 0 2. 0 0 2. 0 0 To t a l F T E ' s 32 . 0 0 32 . 0 0 33 . 0 0 33 . 0 0 Po s i t i o n s 26 . 0 0 26 . 0 0 26 . 0 0 26 . 0 0 Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 3 _ 4 s e c t i o n . x l s i n p e m p Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s Pr o j e c t e d C a s h F l o w a n d D e b t S e r v i c e C o v e r a g e Fi s c a l R e v e n u e Projected Ye a r A v a i l a b l e P r o j e c t e d D e b t S e r v i c e P r o j e c t e d C u m u l a t i v e En d F o r D e b t O w n e r I n t . N e w M o n e y C a s h C a s h 30 - A u g S e r v i c e E x i s t i n g L o a n S e r i e s x S e r i e s y T o t a l F l o w F l o w 20 1 2 7 3 3 , 7 9 8 5 9 0 , 0 0 0 - - 59 0 , 0 0 0 14 3 , 7 9 8 143,798 20 1 3 79 4 , 3 1 0 59 0 , 0 0 0 - - 59 0 , 0 0 0 20 4 , 3 1 0 348,107 20 1 4 98 0 , 2 4 0 59 0 , 0 0 0 29 0 , 0 0 0 - 88 0 , 0 0 0 10 0 , 2 4 0 448,347 20 1 5 99 1 , 7 1 5 59 0 , 0 0 0 29 0 , 0 0 0 - 88 0 , 0 0 0 11 1 , 7 1 5 560,062 Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 3 _ 4 s e c t i o n . x l s C F TAB 9 Westlake Academy Budget for Option 4 High School, Media Center, Muli-Purpose Bld'g and Kitchen Renovation to open Fall 2012 Middle School, Primary School Addition to open Fall 2014 Budget Detail Report Cost Code DescriptionBudgetNotes 01Professional Services 01100Project Management Services$301,239 Based on 3% of construction cost 01120Project Management Additional Services $0 01130Project Management Reimbursables $30,124 01200A/E Services - Planning (---)$0 01210A/E Services - Basic Services $669,420 Based on 7% of construction cost 01220A/E Additional Services $33,471 01230A/E Services Reimbursables $36,000 Other Consultants & Related Expenses $0 01300Civil Engineer (---)$205,000 01310Surveying (---)$50,000 Allowance 01320Signage (---)$19,000 01330Geotechnical (---)$44,000 01340Environmental/AHERA Report $25,000 01350Materials Testing (---)$125,034 1% of construction 01360[blank]$0 01370Data/IT/Security $102,000 ` 01380Regulatory/Printing/Permits/Advert $95,631 1% of const 01390Other Reimbursables/Expenses $55,000 Subtotal Professional Services $1,790,920 02Prime Construction Contract 02200Construction Contract $9,563,146 See Detail Estimate 02210Contractor Contingency $0 Inc. in construction costs above 02220Construction Contingency - 5%$478,157 Subtotal Prime Construction Contract$10,041,303 03Other Capital Improvement Contracts 03100HVAC System Test., Adjust. & Balancing $0 In Construction Contract 03110Telephone $85,500 Allowance 03120Utility Service/Easements/Tap Fees $65,000 Allowance 03130Temporary Utilities $0 In Construction Contract 03140Signs $23,000 Allowance 03150Fencing/Covered Canopy $175,000 03160Security Systems $105,533 $1.75/SF 03170IT/Data (infrastructure)$146,475 $2.50/SF 03180IT Hardware $694,000 03200Furnishings/Equipment $645,000 Subtotal Other Construction Contracts$1,939,508 Totals $13,771,731 04Owner's Internal Costs 04100Internal costs, fees, etc.$0 04200Interest/closing expenses$0 04300Blank$0 Subtotal Internal Costs$0 05Owner's Contingency 05100Owner's Project Contingency - (5%)$688,587 Subtotal Contingency*$688,587 Project Grand Totals$14,460,3173/4/2011, 4:23 PM Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s In p u t P a g e E n r o l l m e n t / T e a c h i n g S t a f f Ye a r 1 7 1 8 1 9 2 0 Se c t i o n s 2 0 1 2 / 1 3 2 0 1 3 / 1 4 2 0 1 4 / 1 5 2 0 1 5 / 1 6 Pr e K - - - - K4 4 5 5 1s t 4 4 5 5 2n d 4 4 5 5 3r d 4 4 5 5 4t h 4 4 5 5 5t h 4 4 5 5 6t h 4 4 4 4 7t h 3 3 4 4 8t h 3 3 4 4 9t h 3 3 4 4 10 t h 3 3 4 4 11 t h 3 3 4 4 12 t h 3 3 4 4 To t a l P r i m a r y 24 24 30 30 To t a l M i d d l e 10 10 12 12 To t a l H i g h 12 12 16 16 To t a l 46 46 58 58 St u d e n t s Pr e K - - - - K8 8 88 11 0 11 0 1s t 88 88 11 0 11 0 2n d 88 88 11 0 11 0 3r d 88 88 11 0 11 0 4t h 88 88 11 0 11 0 5t h 88 88 11 0 11 0 6t h 10 8 10 8 10 8 10 8 7t h 81 81 10 8 10 8 8t h 81 81 10 8 10 8 9t h 81 81 10 8 10 8 10 t h 81 81 10 8 10 8 11 t h 73 73 97 97 12 t h 73 73 97 97 To t a l P r i m a r y 52 8 52 8 66 0 66 0 P Y P To t a l M i d d l e 43 2 43 2 54 0 54 0 M Y P To t a l H i g h 14 6 14 6 19 4 19 4 D P To t a l 1, 1 0 6 1, 1 0 6 1, 3 9 4 1, 3 9 4 Te a c h i n g S t a f f Pr i m a r y 3 8 . 4 0 38 . 4 0 48 . 0 0 48 . 0 0 Mi d d l e 14 . 0 0 14 . 0 0 16 . 8 0 16 . 8 0 Hi g h 17 . 4 0 17 . 4 0 23 . 2 0 23 . 2 0 69 . 8 0 69 . 8 0 88 . 0 0 88 . 0 0 St u d e n t / T e a c h e r R a t i o 15 . 8 4 15 . 8 4 15 . 8 5 15 . 8 5 Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 4 _ 5 s e c t i o n . x l s i n p e n r o l l Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s In c o m e S t a t e m e n t ( 0 0 0 ) No S t a t e i n c N o S t a t e i n c N o S t a t e i n c 3 % S t a t e i n c 6. 7 5 8 6 . 7 5 8 6 . 7 5 8 6 . 9 6 1 Ye a r 1 7 1 8 1 9 2 0 Re v e n u e s 2 0 1 2 / 1 3 2 0 1 3 / 1 4 2 0 1 4 / 1 5 2 0 1 5 / 1 6 St u d e n t E n r o l l m e n t 1, 1 0 6 1, 1 0 6 1, 3 9 4 1, 3 9 4 Sc h o o l St a t e R e v e n u e s 7 , 4 7 3 $ 7 , 4 7 3 $ 9 , 4 2 3 $ 9 , 7 0 6 $ Ti t l e M o n i e s - - - - Gr a n t s Pr i v a t e D o n a t i o n s - P l e d g e d Pr i v a t e D o n a t i o n s - P l a n n e d t o R a i s e 88 5 88 5 1, 1 1 6 1, 1 1 6 To t a l 8, 3 5 8 $ 8, 3 5 8 $ 10 , 5 3 9 $ 10 , 8 2 1 $ St a t e R e v e n u e p e r S t u d e n t $6 , 7 5 3 $6 , 7 5 3 $6 , 7 5 3 $6 , 9 5 6 4 4 4 5 Ex p e n s e s Sc h o o l P e r s o n n e l N o S a l I n c r N o S a l I n c r 3 % i n c r 3 % i n c r Su b - T o t a l S c h o o l P e r s o n n e l 4, 8 4 6 $ 4 , 8 4 6 $ 5 , 9 7 7 $ 6 , 1 5 6 $ Va r i a b l e B e n e f i t s 1 8 7 $ 1 8 7 $ 2 3 1 $ 2 3 8 $ Fi x e d B e n e f i t s 3 8 4 3 8 4 4 5 5 4 5 5 To t a l B e n e f i t s 57 1 $ 5 7 1 $ 6 8 6 $ 6 9 3 $ To t a l S c h o o l P e r s o n n e l 5 , 4 1 7 $ 5 , 4 1 7 $ 6 , 6 6 2 $ 6 , 8 4 9 $ Sc h o o l N o n - P e r s o n n e l 3 % i n c r 3 % i n c r 3 % i n c r 3 % i n c r Pr o f . C o n t r a c t e d S e r v i c e s 7 2 7 $ 7 4 9 $ 8 4 2 $ 8 6 7 $ Su p p l i e s & M a t e r i a l s 3 5 1 3 6 1 4 7 6 4 9 0 Ut i l i t i e s a n d M a i n t 4 9 5 5 1 0 6 7 1 6 9 2 Ot h e r O p e r a t i n g c o s t s 3 1 5 3 2 4 3 3 4 3 4 4 Mi s c e l l a n e o u s - - - - CM O C h a r g e 32 5 33 4 34 4 35 5 To t a l S c h o o l N o n - P e r s o n n e l 2, 2 1 2 $ 2, 2 7 9 $ 2, 6 6 7 $ 2, 7 4 7 $ To t a l S c h o o l E x p e n s e s 7, 6 2 9 $ 7, 6 9 6 $ 9, 3 2 9 $ 9, 5 9 5 $ Re v e n u e A v a i l a b l e f o r D e b t S e r v i c e 72 8 $ 66 2 $ 1, 2 1 0 $ 1, 2 2 6 $ De b t S e r v i c e 59 0 59 0 97 5 97 5 59 0 $ 59 0 $ 97 5 $ 97 5 $ Su r p l u s / S h o r t f a l l 13 8 $ 72 $ 23 5 $ 25 1 $ Co v e r a g e 1. 2 3 1. 1 2 1. 2 4 1. 2 6 Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 4 _ 5 s e c t i o n . x l s I S Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s As s u m p t i o n P a g e Sa l a r y A s s u m p t i o n s 2 0 0 6 20 1 0 He a d C o u n t A s s u m p t i o n s N o n - p e r s o n n e l C o s t s Av e r a g e T e a c h e r S a l a r y 4 4 $ $ 5 0 Pr i m a r y Pr o f . C o n t r a c t e d S e r v i c e s 7 0 5 . 9 2 Su p e r i n t e n d e n t 8 0 $ 9 0 Pr e K S t u d e n t s / S e c t i o n - Pr o f . C o n t r a c t e d S e r v i c e s 841.50 Se c o n d a r y S c h o o l L e a d e r 80 $ 9 0 St u d e n t s / S e c t i o n 22 U t i l i t i e s a n d M a i n t Ph 1 480.66 Pr i m a r y S c h o o l L e a d e r 80 $ 9 0 Te a c h e r s / S e c t i o n 1. 6 0 Ut i l i t i e s a n d M a i n t Ph 2 671.46 Ad m i n . C o o r d 58 $ 6 5 Mi d d l e Su p p l i e s & M a t e r i a l s Ph 1 340.58 DP C o o r d i n a t o r 58 $ 6 5 St u d e n t s / S e c t i o n 27 S u p p l i e s & M a t e r i a l s Ph 2 475.78 MY P C o o r d 58 $ 6 5 Te a c h e r s / S e c t i o n 1. 4 0 Ot h e r O p e r a t i n g c o s t s Ph 1 305.40 At t e n d a n c e C l e r k 18 $ 2 0 Hi g h Ot h e r O p e r a t i n g c o s t s Ph 2 305.40 St r i n gs s t a f f 27 $ 3 0 St u d e n t s / S e c t i o n 27 Mi s c e l l a n e o u s Li b r a r i a n 44 $ 5 0 Te a c h e r s / S e c t i o n 1. 4 5 Te a c h e r ' s A i d e s 18 $ 2 0 Ann u a l R e t e n t i o n 9 , 1 0 10 0 % Be n e f i t C o s t A s s u m p t i o n s IT 59 $ 6 6 Ann u a l R e t e n t i o n 1 1 , 1 2 90 % F i x e d B e n e f i t s - $ 3 . 7 K 3.70$ Fa c i l i t i e s M a n a ger 29 $ 3 2 Re v e n u e A s s u m p t i o n s Va r i a b l e B e n e f i t s - 3 . 8 6 % 3.86% Nu r s e 4 4 $ 5 0 AD A % 97 % 0. 5 5 0 0 % T R S Re g i s t r a r 20 $ 2 3 St a t e F u n d i n g / A D A 6. 1 9 $ 0. 8 4 0 0 % U n e m p l o y m e n t PY P C o o r d / D e a n o f S t u d e n t s 58 $ 6 5 Ti t l e $ - 0. 5 1 9 1 % W o r k e r ' s c o m p Co u n s e l o r s / I n s t r u c t i o n a l C o a c h 49 $ 5 5 Ti t l e % 0 % 1 . 4 5 0 0 % M e d i c a r e Of f i c e A i d e 1 8 $ 2 0 0. 5 0 0 0 % T R S - n e w h i r e s Lu n c h r o o m p e r s o n n e l (co n t r a c t ) - $0 Gr o w t h A s s u m p t i o n s Ja n i t o r 18 $ 2 0 In f l a t i o n R a t e - 3 % 3 % 20 % b u m p f o r g r o w t h i n c r e m e n t a l Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 4 _ 5 s e c t i o n . x l s a s s m p Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s I n p u t P a g e E m p l o y e e s Ye a r 1 7 1 8 1 9 2 0 Em p l o y e e s 2 0 1 2 / 1 3 2 0 1 3 / 1 4 2 0 1 4 / 1 5 2 0 1 5 / 1 6 Su p e r i n t e n d e n t - - - - Se c o n d a r y S c h o o l L e a d e r 1. 0 0 1. 0 0 1. 0 0 1. 0 0 Pr i m a r y S c h o o l L e a d e r 1. 0 0 1. 0 0 1. 0 0 1. 0 0 Ad m i n . C o o r d 1. 0 0 1. 0 0 1. 0 0 1. 0 0 PY P C o o r d / D e a n o f S t u d e n t s 3. 0 0 3. 0 0 3. 0 0 3. 0 0 DP C o o r d i n a t o r 1. 0 0 1. 0 0 1. 0 0 1. 0 0 MY P C o o r d 1. 0 0 1. 0 0 1. 0 0 1. 0 0 At t e n d a n c e C l e r k 1. 0 0 1. 0 0 1. 0 0 1. 0 0 St r i n g s s t a f f 1. 0 0 1. 0 0 1. 0 0 1. 0 0 Li b r a r i a n 2. 0 0 2. 0 0 2. 0 0 2. 0 0 Te a c h e r ' s A i d e s 8. 0 0 8. 0 0 8. 0 0 8. 0 0 IT 1. 0 0 1. 0 0 1. 0 0 1. 0 0 Fa c i l i t i e s M a n a g e r 1. 0 0 1. 0 0 1. 0 0 1. 0 0 Nu r s e 2. 0 0 2. 0 0 2. 0 0 2. 0 0 Re g i s t r a r 1. 0 0 1. 0 0 1. 0 0 1. 0 0 Co u n s e l o r s / I n s t r u c t i o n a l C o a c h 3 . 0 0 3. 0 0 4. 0 0 4. 0 0 Of f i c e A i d e 4. 0 0 4. 0 0 4. 0 0 4. 0 0 Lu n c h r o o m p e r s o n n e l ( c o n t r a c t ) - - - - Ja n i t o r 2. 0 0 2. 0 0 2. 0 0 2. 0 0 To t a l F T E ' s 34 . 0 0 34 . 0 0 35 . 0 0 35 . 0 0 Po s i t i o n s 26 . 0 0 2 6 . 0 0 2 6 . 0 0 2 6 . 0 0 11 0 5 . 8 1 1 0 5 . 8 1 3 9 4 . 4 1 3 9 4 . 4 Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 4 _ 5 s e c t i o n . x l s i n p e m p Fi n a n c i a l S t a t e m e n t s a n d D e b t C a p a c i t y A n a l y s i s Pr o j e c t e d C a s h F l o w a n d D e b t S e r v i c e C o v e r a g e Fi s c a l R e v e n u e Projected Ye a r A v a i l a b l e P r o j e c t e d D e b t S e r v i c e P r o j e c t e d C u m u l a t i v e En d F o r D e b t O w n e r I n t . N e w M o n e y C a s h C a s h 30 - A u g S e r v i c e E x i s t i n g L o a n S e r i e s x S e r i e s y T o t a l F l o w F l o w 20 1 2 7 2 8 , 1 9 7 5 9 0 , 0 0 0 - - 59 0 , 0 0 0 13 8 , 1 9 7 138,197 20 1 3 66 1 , 8 3 3 59 0 , 0 0 0 - - 59 0 , 0 0 0 71 , 8 3 3 210,030 20 1 4 1, 2 0 9 , 5 1 0 59 0 , 0 0 0 38 5 , 0 0 0 - 97 5 , 0 0 0 23 4 , 5 1 0 444,539 20 1 5 1, 2 2 5 , 9 8 2 59 0 , 0 0 0 38 5 , 0 0 0 - 97 5 , 0 0 0 25 0 , 9 8 2 695,522 Pr o j e c t M a n a g e m e n t S e r v i c e s , I n c . 03 0 3 1 1 _ W A _ F i n a n c e _ M o d e l _ O p t 4 _ 5 s e c t i o n . x l s C F TAB 10 Westlake Academy High School Budget 4 Section High School 22,570 SF Budget Detail Report To Open Fall 2013 in All Options 1-4 Cost Code DescriptionBudgetNotes 01Professional Services 01100Project Management Services$116,992 Based on 3% of construction cost 01120Project Management Additional Services $0 01130Project Management Reimbursables $11,699 01200A/E Services - Planning (---)$0 01210A/E Services - Basic Services $259,983 Based on 7% of construction cost 01220A/E Additional Services $12,999 01230A/E Services Reimbursables $6,000 Other Consultants & Related Expenses 01300Civil Engineer (---)$75,000 01310Surveying (---)$15,000 Allowance 01320Signage (---)$5,000 01330Geotechnical (---)$12,000 01340Environmental/AHERA Report $5,000 01350Materials Testing (---)$38,997 1% of construction 01360[blank] 01370Data/IT/Security$20,000 01380Regulatory/Printing/Permits/Advert$37,140 1% of const 01390Other Reimbursables/Expenses $10,000 Subtotal Professional Services $625,812 02Prime Construction Contract 02200Construction Contract $3,714,047 See Detail Estimate 02210Contractor Contingency $0 Inc. in construction costs above 02220Construction Contingency - 5%$185,702 Subtotal Prime Construction Contract$3,899,749 03Other Capital Improvement Contracts 03100HVAC System Test., Adjust. & Balancing $0 In Construction Contract 03110Telephone $25,000 Allowance 03120Utility Service/Easements/Tap Fees $20,000 Allowance 03130Temporary Utilities In Construction Contract 03140Signs $5,000 Allowance 03150Fencing $0 None Anticipated 03160Security Systems $39,498 $1.75/SF 03170IT/Data (infrastructure)$56,425 $2.50/SF 03180IT Hardware $269,000 $11K/clsrm + 1 Lab @ $40K ea + 2 IDF @ $10K 03200Furnishings/Equipment $168,000 furnish all classrooms ($7K/clsrm) + fac. + Sci Subtotal Other Construction Contracts$582,923 Totals $5,108,484 04Owner's Internal Costs 04100Internal costs, fees, etc.$0 04200Interest/closing expenses$0 04300Blank$0 Subtotal Internal Costs$0 05Owner's Contingency 05100Owner's Project Contingency - (5%)$255,424 Subtotal Contingency*$255,424 Project Grand Totals$5,363,908 TAB 11 Westlake Academy Middle School Budget 4 Section Middle School - To open Fall 2013 in Option 1A or 2A Budget Detail Report19,320 SF Cost Code DescriptionBudgetNotes 01Professional Services 01100Project Management Services$89,947 Based on 3% of construction cost 01120Project Management Additional Services $0 01130Project Management Reimbursables $8,995 01200A/E Services - Planning (---)$0 01210A/E Services - Basic Services $199,883 Based on 7% of construction cost 01220A/E Additional Services $9,994 01230A/E Services Reimbursables $6,000 Other Consultants & Related Expenses 01300Civil Engineer $50,000 01310Surveying $15,000 Allowance 01320Signage $5,000 01330Geotechnical $8,000 01340Environmental/AHERA Report $5,000 01350Materials Testing $60,000 1% of construction 01360[blank] 01370Data/IT/Security$20,000 01380Regulatory/Printing/Permits/Advert$28,555 1% of const 01390Other Reimbursables/Expenses $10,000 Subtotal Professional Services $516,374 02Prime Construction Contract 02200Construction Contract $2,855,475 See Detail Estimate 02210Contractor Contingency $0 Inc. in costs above 02220Construction Contingency - 5%$142,774 Subtotal Prime Construction Contract$2,998,249 03Other Capital Improvement Contracts 03100HVAC System Test., Adjust. & Balancing $0 In Construction Contract 03110Telephone $25,000 Allowance 03120Utility Service/Easements/Tap Fees $20,000 Allowance 03130Temporary Utilities In Construction Contract 03140Signs $5,000 Allowance 03150Fencing $0 None Anticipated 03160Security Systems $33,810 $1.75/SF 03170IT/Data (infrastructure)$48,300 $2.50/SF 03180IT Hardware $214,000 $11K/clsrm + 1 Lab @ $40K ea + 2 IDF @ $10K 03200Furnishings/Equipment $205,000 furnish all classrooms ($7K/clsrm) + fac. + Sci Subtotal Other Construction Contracts$551,110 Totals $4,065,733 04 Owner's Internal Costs 04100Internal costs, fees, etc.$0 04200Interest/closing expenses$0 04300Blank$0 Subtotal Internal Costs$0 05Owner's Contingency 05100Owner's Project Contingency - 5%$203,287 Subtotal Contingency*$203,287 Project Grand Totals$4,269,020 Westlake Academy Middle School Budget 4 Section Middle School - To open Fall 2013 in Option 1B or 2B Budget Detail Report15,445 SF Cost Code DescriptionBudgetNotes 01Professional Services 01100Project Management Services$73,126 Based on 3% of construction cost 01120Project Management Additional Services $0 01130Project Management Reimbursables $7,313 01200A/E Services - Planning (---)$0 01210A/E Services - Basic Services $162,502 Based on 7% of construction cost 01220A/E Additional Services $8,125 01230A/E Services Reimbursables $6,000 Other Consultants & Related Expenses 01300Civil Engineer $50,000 01310Surveying $15,000 Allowance 01320Signage $5,000 01330Geotechnical $8,000 01340Environmental/AHERA Report $5,000 01350Materials Testing $60,000 1% of construction 01360[blank] 01370Data/IT/Security$20,000 01380Regulatory/Printing/Permits/Advert$23,215 1% of const 01390Other Reimbursables/Expenses $10,000 Subtotal Professional Services $453,280 02Prime Construction Contract 02200Construction Contract $2,321,452 See Detail Estimate 02210Contractor Contingency $0 Inc. in costs above 02220Construction Contingency - 5%$116,073 Subtotal Prime Construction Contract$2,437,524 03Other Capital Improvement Contracts 03100HVAC System Test., Adjust. & Balancing $0 In Construction Contract 03110Telephone $25,000 Allowance 03120Utility Service/Easements/Tap Fees $20,000 Allowance 03130Temporary Utilities In Construction Contract 03140Signs $5,000 Allowance 03150Fencing $0 None Anticipated 03160Security Systems $27,029 $1.75/SF 03170IT/Data (infrastructure)$38,613 $2.50/SF 03180IT Hardware $170,000 $11K/clsrm + 1 Lab @ $40K ea + 2 IDF @ $10K 03200Furnishings/Equipment $161,000 furnish all classrooms ($7K/clsrm) + fac. + Sci Subtotal Other Construction Contracts$446,641 Totals $3,337,445 04 Owner's Internal Costs 04100Internal costs, fees, etc.$0 04200Interest/closing expenses$0 04300Blank$0 Subtotal Internal Costs$0 05Owner's Contingency 05100Owner's Project Contingency - 5%$166,872 Subtotal Contingency*$166,872 Project Grand Totals$3,504,317 Westlake Academy Middle School Budget 4 Section Middle School -To open Fall 2014 in Option 3 or 4 Budget Detail Report19,320 SF Cost Code DescriptionBudgetNotes 01Professional Services 01100Project Management Services$90,386 Based on 3% of construction cost 01120Project Management Additional Services $0 01130Project Management Reimbursables $9,039 01200A/E Services - Planning (---)$0 01210A/E Services - Basic Services $200,859 Based on 7% of construction cost 01220A/E Additional Services $10,043 01230A/E Services Reimbursables $6,000 Other Consultants & Related Expenses 01300Civil Engineer $50,000 01310Surveying $15,000 Allowance 01320Signage $5,000 01330Geotechnical $8,000 01340Environmental/AHERA Report $5,000 01350Materials Testing $60,000 1% of construction 01360[blank] 01370Data/IT/Security$20,000 01380Regulatory/Printing/Permits/Advert$28,694 1% of const 01390Other Reimbursables/Expenses $10,000 Subtotal Professional Services $518,021 02Prime Construction Contract 02200Construction Contract $2,869,412 See Detail Estimate 02210Contractor Contingency $0 Inc. in costs above 02220Construction Contingency - 5%$143,471 Subtotal Prime Construction Contract$3,012,883 03Other Capital Improvement Contracts 03100HVAC System Test., Adjust. & Balancing $0 In Construction Contract 03110Telephone $25,000 Allowance 03120Utility Service/Easements/Tap Fees $20,000 Allowance 03130Temporary Utilities In Construction Contract 03140Signs $5,000 Allowance 03150Fencing $0 None Anticipated 03160Security Systems $33,810 $1.75/SF 03170IT/Data (infrastructure)$48,300 $2.50/SF 03180IT Hardware $214,000 $11K/clsrm + 1 Lab @ $40K ea + 2 IDF @ $10K 03200Furnishings/Equipment $205,000 furnish all classrooms ($7K/clsrm) + fac. + Sci Subtotal Other Construction Contracts$551,110 Totals $4,082,014 04 Owner's Internal Costs 04100Internal costs, fees, etc.$0 04200Interest/closing expenses$0 04300Blank$0 Subtotal Internal Costs$0 05Owner's Contingency 05100Owner's Project Contingency - 5%$204,101 Subtotal Contingency*$204,101 Project Grand Totals$4,286,115 TAB 12 Westlake Academy Media Center Building To Open Fall 2013 in All Options 1-4 3,000 SF Budget Detail Report Cost Code DescriptionBudgetNotes 01Professional Services 01100Project Management Services$17,712 Based on 3% of construction cost 01120Project Management Additional Services $0 01130Project Management Reimbursables $1,771 01200A/E Services - Planning (---)$0 01210A/E Services - Basic Services $39,359 Based on 7% of construction cost 01220A/E Additional Services $1,968 01230A/E Services Reimbursables $6,000 Other Consultants & Related Expenses 01300Civil Engineer (---)$50,000 01310Surveying (---)$10,000 Allowance 01320Signage (---)$5,000 01330Geotechnical (---)$8,000 01340Environmental/AHERA Report $5,000 01350Materials Testing (---)$5,904 1% of construction 01360[blank] 01370Data/IT/Security$20,000 01380Regulatory/Printing/Permits/Advert$5,623 1% of const 01390Other Reimbursables/Expenses $10,000 Subtotal Professional Services $186,337 02Prime Construction Contract 02200Construction Contract $562,275 See Detail Estimate 02210Contractor Contingency $0 Inc. in construction costs above 02220Construction Contingency - 5%$28,114 Subtotal Prime Construction Contract$590,389 03Other Capital Improvement Contracts 03100HVAC System Test., Adjust. & Balancing $0 In Construction Contract 03110Telephone $15,000 Allowance 03120Utility Service/Easements/Tap Fees $0 Allowance 03130Temporary Utilities In Construction Contract 03140Signs $5,000 Allowance 03150Fencing $0 None Anticipated 03160Security Systems $5,250 $1.75/SF 03170IT/Data (infrastructure)$7,500 $2.50/SF 03180IT Hardware $100,000 03200Furnishings/Equipment $50,000 Allowance Subtotal Other Construction Contracts$182,750 Totals $959,475 04Owner's Internal Costs 04100Internal costs, fees, etc.$0 04200Interest/closing expenses$0 04300Blank$0 Subtotal Internal Costs$0 05Owner's Contingency 05100Owner's Project Contingency - (5%)$47,974 Subtotal Contingency*$47,974 Project Grand Totals$1,007,449 TAB 13 Westlake Academy Multi-Purpose Building To Open Fall 2013 in All Options 1-4 4,500 SF Budget Detail Report Cost Code DescriptionBudgetNotes 01Professional Services 01100Project Management Services$30,735 Based on 3% of construction cost 01120Project Management Additional Services $0 01130Project Management Reimbursables $3,073 01200A/E Services - Planning (---)$0 01210A/E Services - Basic Services $68,300 Based on 7% of construction cost 01220A/E Additional Services $3,415 01230A/E Services Reimbursables $6,000 Other Consultants & Related Expenses 01300Civil Engineer (---)$15,000 01310Surveying (---)$5,000 Allowance 01320Signage (---)$2,000 01330Geotechnical (---)$8,000 01340Environmental/AHERA Report $5,000 01350Materials Testing (---)$10,245 1% of construction 01360[blank] 01370Data/IT/Security$20,000 01380Regulatory/Printing/Permits/Advert$9,757 1% of const 01390Other Reimbursables/Expenses $10,000 Subtotal Professional Services $196,525 02Prime Construction Contract 02200Construction Contract $975,713 See Detail Estimate 02210Contractor Contingency $0 Inc. in construction costs above 02220Construction Contingency - 5%$48,786 Subtotal Prime Construction Contract$1,024,498 03Other Capital Improvement Contracts 03100HVAC System Test., Adjust. & Balancing $0 In Construction Contract 03110Telephone $10,000 Allowance 03120Utility Service/Easements/Tap Fees $0 Allowance 03130Temporary Utilities In Construction Contract 03140Signs $5,000 Allowance 03150Drop-Off/Pick-Up Canopy & Fencing $175,000 03160Security Systems $7,875 $1.75/SF 03170IT/Data (infrastructure)$11,250 $2.50/SF 03180IT Hardware $40,000 03200Furnishings/Equipment $80,000 Furniture+Equip+Warming Kitchen Equipment Subtotal Other Construction Contracts$329,125 Totals $1,550,149 04Owner's Internal Costs 04100Internal costs, fees, etc.$0 04200Interest/closing expenses$0 04300Blank$0 Subtotal Internal Costs$0 05Owner's Contingency 05100Owner's Project Contingency - (5%)$77,507 Subtotal Contingency*$77,507 Project Grand Totals$1,627,656 TAB 14 Westlake Academy Primary School Addition (4 Rooms) Option 1B to open Fall 2013 3,500 SF Budget Detail Report Cost Code DescriptionBudgetNotes 01Professional Services 01100Project Management Services$20,664 Based on 3% of construction cost 01120Project Management Additional Services $0 01130Project Management Reimbursables $2,066 01200A/E Services - Planning (---)$0 01210A/E Services - Basic Services $45,919 Based on 7% of construction cost 01220A/E Additional Services $2,296 01230A/E Services Reimbursables $6,000 Other Consultants & Related Expenses 01300Civil Engineer (---)$15,000 01310Surveying (---)$5,000 Allowance 01320Signage (---)$2,000 01330Geotechnical (---)$8,000 01340Environmental/AHERA Report $5,000 01350Materials Testing (---)$6,888 1% of construction 01360[blank] 01370Data/IT/Security$20,000 01380Regulatory/Printing/Permits/Advert$6,560 1% of const 01390Other Reimbursables/Expenses $10,000 Subtotal Professional Services $155,393 02Prime Construction Contract 02200Construction Contract $655,988 See Detail Estimate 02210Contractor Contingency $0 Inc. in construction costs above 02220Construction Contingency - 5%$32,799 Subtotal Prime Construction Contract$688,787 03Other Capital Improvement Contracts 03100HVAC System Test., Adjust. & Balancing $0 In Construction Contract 03110Telephone $10,000 Allowance 03120Utility Service/Easements/Tap Fees $0 Allowance 03130Temporary Utilities In Construction Contract 03140Signs $2,000 Allowance 03150Fencing $0 None Anticipated 03160Security Systems $6,125 $1.75/SF 03170IT/Data (infrastructure)$8,750 $2.50/SF 03180IT Hardware $44,000 $11k/classroom 03200Furnishings/Equipment $28,000 $7k/classroom Subtotal Other Construction Contracts$98,875 Totals $943,055 04Owner's Internal Costs 04100Internal costs, fees, etc.$0 04200Interest/closing expenses$0 04300Blank$0 Subtotal Internal Costs$0 05Owner's Contingency 05100Owner's Project Contingency - (5%)$47,153 Subtotal Contingency*$47,153 Project Grand Totals$990,207 Westlake Academy Primary School Addition (6 Rooms) Option 2A to open Fall 2013 5,200 SF Budget Detail Report Cost Code DescriptionBudgetNotes 01Professional Services 01100Project Management Services$29,519 Based on 3% of construction cost 01120Project Management Additional Services $0 01130Project Management Reimbursables $2,952 01200A/E Services - Planning (---)$0 01210A/E Services - Basic Services $65,599 Based on 7% of construction cost 01220A/E Additional Services $3,280 01230A/E Services Reimbursables $6,000 Other Consultants & Related Expenses 01300Civil Engineer (---)$15,000 01310Surveying (---)$5,000 Allowance 01320Signage (---)$2,000 01330Geotechnical (---)$8,000 01340Environmental/AHERA Report $5,000 01350Materials Testing (---)$9,840 1% of construction 01360[blank] 01370Data/IT/Security$20,000 01380Regulatory/Printing/Permits/Advert$9,371 1% of const 01390Other Reimbursables/Expenses $10,000 Subtotal Professional Services $191,561 02Prime Construction Contract 02200Construction Contract $937,125 See Detail Estimate 02210Contractor Contingency $0 Inc. in construction costs above 02220Construction Contingency - 5%$46,856 Subtotal Prime Construction Contract$983,981 03Other Capital Improvement Contracts 03100HVAC System Test., Adjust. & Balancing $0 In Construction Contract 03110Telephone $10,000 Allowance 03120Utility Service/Easements/Tap Fees $0 Allowance 03130Temporary Utilities In Construction Contract 03140Signs $2,000 Allowance 03150Fencing $0 None Anticipated 03160Security Systems $9,100 $1.75/SF 03170IT/Data (infrastructure)$13,000 $2.50/SF 03180IT Hardware $66,000 $11k/classroom 03200Furnishings/Equipment $42,000 $7k/classroom Subtotal Other Construction Contracts$142,100 Totals $1,317,642 04Owner's Internal Costs 04100Internal costs, fees, etc.$0 04200Interest/closing expenses$0 04300Blank$0 Subtotal Internal Costs$0 05Owner's Contingency 05100Owner's Project Contingency - (5%)$65,882 Subtotal Contingency*$65,882 Project Grand Totals$1,383,525 Westlake Academy Primary School Addition (11 Rooms) Option 2B to open Fall 2013 10,368 SF Budget Detail Report Cost Code DescriptionBudgetNotes 01Professional Services 01100Project Management Services$56,441 Based on 3% of construction cost 01120Project Management Additional Services $0 01130Project Management Reimbursables $5,644 01200A/E Services - Planning (---)$0 01210A/E Services - Basic Services $125,425 Based on 7% of construction cost 01220A/E Additional Services $6,271 01230A/E Services Reimbursables $6,000 Other Consultants & Related Expenses 01300Civil Engineer (---)$15,000 01310Surveying (---)$5,000 Allowance 01320Signage (---)$2,000 01330Geotechnical (---)$8,000 01340Environmental/AHERA Report $5,000 01350Materials Testing (---)$18,814 1% of construction 01360[blank] 01370Data/IT/Security$20,000 01380Regulatory/Printing/Permits/Advert$17,918 1% of const 01390Other Reimbursables/Expenses $10,000 Subtotal Professional Services $301,513 02Prime Construction Contract 02200Construction Contract $1,791,783 See Detail Estimate 02210Contractor Contingency $0 Inc. in construction costs above 02220Construction Contingency - 5%$89,589 Subtotal Prime Construction Contract$1,881,372 03Other Capital Improvement Contracts 03100HVAC System Test., Adjust. & Balancing $0 In Construction Contract 03110Telephone $10,000 Allowance 03120Utility Service/Easements/Tap Fees $0 Allowance 03130Temporary Utilities In Construction Contract 03140Signs $2,000 Allowance 03150Fencing $0 None Anticipated 03160Security Systems $18,144 $1.75/SF 03170IT/Data (infrastructure)$25,920 $2.50/SF 03180IT Hardware $121,000 $11k/classroom 03200Furnishings/Equipment $77,000 $7k/classroom Subtotal Other Construction Contracts$254,064 Totals $2,436,949 04Owner's Internal Costs 04100Internal costs, fees, etc.$0 04200Interest/closing expenses$0 04300Blank$0 Subtotal Internal Costs$0 05Owner's Contingency 05100Owner's Project Contingency - (5%)$121,847 Subtotal Contingency*$121,847 Project Grand Totals$2,558,796 Westlake Academy Primary School Addition (6 Rooms) To open Fall 2014 in Option 4 5,200 SF Budget Detail Report Cost Code DescriptionBudgetNotes 01Professional Services 01100Project Management Services$29,664 Based on 3% of construction cost 01120Project Management Additional Services $0 01130Project Management Reimbursables $2,966 01200A/E Services - Planning (---)$0 01210A/E Services - Basic Services $65,919 Based on 7% of construction cost 01220A/E Additional Services $3,296 01230A/E Services Reimbursables $6,000 Other Consultants & Related Expenses 01300Civil Engineer (---)$15,000 01310Surveying (---)$5,000 Allowance 01320Signage (---)$2,000 01330Geotechnical (---)$8,000 01340Environmental/AHERA Report $5,000 01350Materials Testing (---)$9,888 1% of construction 01360[blank] 01370Data/IT/Security$20,000 01380Regulatory/Printing/Permits/Advert$9,417 1% of const 01390Other Reimbursables/Expenses $10,000 Subtotal Professional Services $192,150 02Prime Construction Contract 02200Construction Contract $941,699 See Detail Estimate 02210Contractor Contingency $0 Inc. in construction costs above 02220Construction Contingency - 5%$47,085 Subtotal Prime Construction Contract$988,784 03Other Capital Improvement Contracts 03100HVAC System Test., Adjust. & Balancing $0 In Construction Contract 03110Telephone $10,000 Allowance 03120Utility Service/Easements/Tap Fees $25,000 Allowance 03130Temporary Utilities In Construction Contract 03140Signs $2,000 Allowance 03150Fencing $0 None Anticipated 03160Security Systems $9,100 $1.75/SF 03170IT/Data (infrastructure)$13,000 $2.50/SF 03180IT Hardware $66,000 $11k/classroom 03200Furnishings/Equipment $42,000 $7k/classroom Subtotal Other Construction Contracts$167,100 Totals $1,348,034 04Owner's Internal Costs 04100Internal costs, fees, etc.$0 04200Interest/closing expenses$0 04300Blank$0 Subtotal Internal Costs$0 05Owner's Contingency 05100Owner's Project Contingency - (5%)$67,402 Subtotal Contingency*$67,402 Project Grand Totals$1,415,435 TAB 15 Westlake Academy Existing Kitchen Renovation To Open Fall 2013 in all options 1-4 Budget Detail Report Cost Code DescriptionBudgetNotes 01Professional Services 01100Project Management Services$15,750 Based on 3% of construction cost 01120Project Management Additional Services $0 01130Project Management Reimbursables $1,575 01200A/E Services - Planning (---)$0 01210A/E Services - Basic Services $35,000 Based on 7% of construction cost 01220A/E Additional Services $1,750 01230A/E Services Reimbursables $6,000 Other Consultants & Related Expenses 01300Civil Engineer (---)$0 01310Surveying (---)$0 Allowance 01320Signage (---)$0 01330Geotechnical (---)$0 01340Environmental/AHERA Report $0 01350Materials Testing (---)$0 1% of construction 01360[blank] 01370Data/IT/Security$2,000 01380Regulatory/Printing/Permits/Advert$5,000 1% of const 01390Other Reimbursables/Expenses $5,000 Subtotal Professional Services $72,075 02Prime Construction Contract 02200Construction Contract $500,000 Allowance 02210Contractor Contingency $0 Inc. in construction costs above 02220Construction Contingency - 5%$25,000 Subtotal Prime Construction Contract$525,000 03Other Capital Improvement Contracts 03100HVAC System Test., Adjust. & Balancing $0 In Construction Contract 03110Telephone $500 Allowance 03120Utility Service/Easements/Tap Fees $0 Allowance 03130Temporary Utilities In Construction Contract 03140Signs $1,000 Allowance 03150Drop-Off/Pick-Up Canopy & Fencing $0 03160Security Systems $10,000 03170IT/Data (infrastructure)$10,000 03180IT Hardware $5,000 03200Furnishings/Equipment $100,000 Subtotal Other Construction Contracts$126,500 Totals $723,575 04Owner's Internal Costs 04100Internal costs, fees, etc.$0 04200Interest/closing expenses$0 04300Blank$0 Subtotal Internal Costs$0 05Owner's Contingency 05100Owner's Project Contingency - (5%)$36,179 Subtotal Contingency*$36,179 Project Grand Totals$759,754