Loading...
HomeMy WebLinkAbout32766Exhibit B - Attachment 4 Fresno County Budget Cost Sheet - Year 3 Fresno County 14-10501 A05 2016 - 2017 2018 PROJECT BUDGET Personnel Position Title and Number of each FTE Salary Cost FTE Salary Cost FTE Salary Cost FTE Salary Cost FTE Salary Cost FTE Salary Cost FTE Salary Cost Public Health Nurse (1)35%87,254$ $30,539 -$ $0 -$ $0 -$ $0 30%87,060$ $26,118 25%74,890$ $18,723 15%74,890$ $11,234 324,094$ $56,657 Coordinator (1)25%67,998$ $17,000 -$ $0 -$ $0 -$ $0 -$ $0 -$ $0 -$ $0 67,998$ $0 PHEP Coordinator (2) (1)45%78,040$ $35,118 -$ $0 -$ $0 -$ $0 10%77,680$ $7,768 35%78,300$ $27,405 10%77,680$ $7,768 311,700$ $50,654 Health Education Specialist (3) (2)69%42,743$ $29,493 -$ $0 -$ $0 -$ $0 30%43,473$ $13,042 -$ $0 29%42,541$ $12,337 128,758$ $54,872 Epidemiologist (2) (1)47%59,770$ $28,092 -$ $0 -$ $0 -$ $0 -$ $0 -$ $0 -$ $0 59,770$ $28,092 System Procedure Analyst (1)10%70,079$ $7,008 -$ $0 -$ $0 -$ $0 -$ $0 -$ $0 -$ $0 70,079$ $0 Staff Analyst (1) (2)43%50,930$ $21,900 -$ $0 -$ $0 -$ $0 4%49,465$ $1,979 27%50,811$ $13,719 4%49,475$ $1,979 200,681$ $39,577 Staff Analyst I (1)100%42,330$ $42,330 -$ $0 -$ $0 -$ $0 -$ $0 -$ $0 -$ $0 42,330$ $0 Office Assistant (1)30%35,487$ $10,646 -$ $0 -$ $0 -$ $0 70%35,487$ $24,841 -$ $0 -$ $0 70,974$ $0 Program Technician (1)40%39,478$ $15,791 -$ $0 -$ $0 -$ $0 50%39,507$ $19,754 10%39,320$ $3,932 -$ $0 118,305$ $39,477 Sr Public Health Microbiologist (1)-$ $0 83%68,648$ $56,978 -$ $0 -$ $0 -$ $0 -$ $0 -$ $0 68,648$ $56,978 Public Health Microbiologist (1)-$ $0 22%47,186$ $10,381 -$ $0 -$ $0 -$ $0 -$ $0 -$ $0 47,186$ $10,381 Lab Assistant (1)-$ $0 23%31,278$ $5,343 -$ $0 -$ $0 -$ $0 -$ $0 -$ $0 31,278$ $5,343 HPP Coordinator (1)-$ $0 -$ $0 -$ $0 -$ $0 -$ $0 35%68,000$ $27,046 -$ $0 68,000$ $27,046 LEMSA Coordinator (1)-$ $0 -$ $0 -$ $0 -$ $0 -$ $0 50%28,064$ $14,032 -$ $0 28,064$ $0 Sr. Epidemiologist (1) (2)25%67,248$ $16,812 -$ $0 -$ $0 -$ $0 -$ $0 -$ $0 -$ $0 67,248$ $16,812 Supervising PHN (1)17%101,947$ $17,331 -$ $0 -$ $0 -$ $0 -$ $0 -$ $0 -$ $0 101,947$ $17,331 Lab Trainee (1)-$ $0 100%18,275$ $18,275 -$ $0 -$ $0 -$ $0 -$ $0 -$ $0 18,275$ $0 PHN, Coalition Coordinator (1)-$ $0 -$ $0 -$ $0 -$ $0 -$ $0 20%87,165$ $17,433 -$ $0 87,165$ $17,433 PHN/ Pan Flu Coordinator (1)-$ $0 -$ $0 -$ $0 -$ $0 -$ $0 -$ $0 15%87,160$ $13,074 87,160$ $13,074 -$ $0 -$ $0 -$ $0 -$ $0 -$ $0 -$ $0 -$ $0 -$ $0 $195,076 $72,702 $0 $0 $68,660 $62,130 $35,158 $433,726 Fringe Benefits %%%%%%% 73.28%$142,947 79.22%$57,592 #DIV/0!$0 #DIV/0!$0 76.84%$52,761 72.81%$45,235 79.29%$27,878 $326,413 Subtotal Personnel and Fringe $338,023 $130,294 $0 $0 $121,421 $107,365 $63,036 $760,139 Operating Expenses $138,940 $84,651 $0 $0 $49,542 $188,751 $16,601 $478,484 Equipment (Minor)Quantity Unit Price Total Quantity Unit Price Total Quantit Unit Price Total Quantit Unit Price Total Quantity Unit Price Total Quantity Unit Price Total Quantity Unit Price Total Folding Chairs 24 52.47 $1,259 $0 $0 $0 $0 $0 $0 $0 Folding Stacked Chair Cart 1 235.66 $236 $0 $0 $0 $0 $0 $0 $0 Crown Control Barricade 3 227.27 $682 $0 $0 $0 $0 $0 $0 $0 Victor X4 $0 1 $28,158 $28,158 $0 $0 $0 $0 $0 $0 Laptop/Tablet $0 1 $1,500 $1,500 $0 $0 5 $2,500 $12,500 $0 $0 $0 16' Storage Trailer $0 $0 $0 $0 $0 3 $7,146 $21,438 $0 $0 Gamma Scout Hand Held Geiger Counter $0 $0 $0 $0 $0 1 $670 $670 $0 $0 Shelter 20x10 ft $0 $0 $0 $0 $0 1 $481 $481 $0 $0 Motorola XPR6550 Portable Radio $0 $0 $0 $0 $0 3 $981 $2,942 $0 $0 Portable Generator $0 $0 $0 $0 $0 $0 3 $4,842 $14,526 $0 Lab/ Pharmacy Refrigerator 2 $6,955 $13,910 $0 $0 $0 $0 $0 $0 $13,910 Hood Fan Replacement $0 1 $14,395 $14,395 $0 $0 $0 $0 $0 $14,395 Bio Safety Hood - 6ft $0 2 $10,449 $20,897 $0 $0 $0 $0 $0 $20,897 Bio Safety Hood - 3ft $0 1 $6,920 $6,920 $0 $0 $0 $0 $0 $6,920 Generator for HVAC $0 $0 $0 $0 $0 1 $7,239 $7,239 $0 $0 Demistifier $0 $0 $0 $0 $0 $0 $0 Lab Fan Controls 1 $16,267 $16,267 $0 $0 $0 $16,267 Freezer 1 $11,275 $11,275 $0 $0 $0 $11,275 Demistifier (Standard 2000A - Peace Medical)1 $6,765 $6,765 $0 $6,765 $0 $0 $0 $0 $0 $0 $0 $0 Equipment Subtotal $13,910 $69,753 $0 $0 $0 $6,765 $0 $90,428 TOTALSCDC PHEP Base Funds Laboratory Funds Laboratory Trainee Funds Laboratory Training Assistance Funds GFPFCities Readiness Initiative Funds HPP Funds Exhibit B - Attachment 4 Fresno County Budget Cost Sheet - Year 3 Fresno County 14-10501 A05 2016 - 2017 2018 PROJECT BUDGET TOTALSCDC PHEP Base Funds Laboratory Funds Laboratory Trainee Funds Laboratory Training Assistance Funds GFPFCities Readiness Initiative Funds HPP Funds In State Travel/Per Diem (Be sure travel is referenced in the SOW)$2,229 $0 $0 $0 $1,077 $3,797 $670 $7,773 Out of State Travel/Per Diem (Be sure OST is referenced in the SOW)$3,111 $0 $0 $0 $0 $4,520 $0 $7,631 Subcontracts Resources for Independence, Central Valley (RICV)$4,984 $0 $0 $0 $11,006 $0 $0 $15,990 HMS, Inc.$20,500 $0 $0 $0 $0 $0 $0 $20,500 Verizon $3,193 $0 $0 $0 $0 $0 $0 $0 Sprint $3,307 $0 $0 $0 $0 $0 $0 $0 DOC phone lines $3,090 $0 $0 $0 $0 $0 $0 $0 SAS License $1,800 $0 $0 $0 $0 $0 $0 $0 Peninsula Courier $0 $500 $0 $0 $0 $0 $0 $500 New Life Technologies $0 $18,320 $0 $0 $0 $0 $3,000 $0 Flu media campaign $0 $0 $0 $0 $0 $0 $0 $0 Inland Empire Health Information Exchange (IEHIE)$21,499 $0 $0 $0 $0 $0 $0 $21,499 Prezi Software (2)$480 $0 $0 $0 $0 $0 $0 $480 Jerry Petersen, Lab Director $0 $11,100 $0 $0 $0 $0 $0 $11,100 Bio Defense $0 $0 $0 $0 $57,485 $0 $0 $0 Closed POD Recruitment $0 $0 $0 $0 $67,970 $0 $0 $67,970 Contract w/ Mosquito Abatement Districts $79,999 $0 $0 $0 $0 $0 $0 $79,999 Godfred Masinde, Lab Director $0 $21,000 $0 $0 $0 $0 $0 $21,000 Courier Service/ Crosstown $0 $1,500 $0 $0 $0 $0 $0 $1,500 $0 $0 $0 $0 $0 $0 $0 $0 Subcontract Subtotal $127,462 $34,100 $0 $0 $78,976 $0 $0 $240,538 Other Costs Software and Licenses $15,246 $12,000 $0 $0 $0 $0 $0 $15,246 Training $8,305 $245 $0 $0 $2,000 $24,917 $0 $33,222 Exercise Materials $0 $0 $0 $0 $5,142 $31,920 $5,000 $0 Maintenance Agreements $0 $37,720 $0 $0 $0 $0 $0 $37,720 $0 $0 $0 $0 $0 $0 $0 $0 $0 Other Costs Subtotal $23,551 $37,720 $0 $0 $0 $24,917 $0 $86,188 Total Direct Costs $647,225 $356,518 $0 $0 $251,016 $336,115 $80,306 $1,671,181 Total Indirect Costs $94,987 $52,323 $0 $0 $36,839 $49,328 $11,786 $245,262 (14.67% 14.7% of Total Direct Costs) Total Costs $742,212 $408,841 $0 $0 $287,855 $385,443 $92,092 $1,916,443 Out of State Travel: CSTE Conferences, TBD; PHEP Summit, Atlanta GA.; Conventional BT Methods, Richmond, CA; National Healthcare Coalition Conference, Washington, DC. Supplies means: consumables office supply these are item that may be destroyed, dissipated, wasted are products that consumers buy recurrently i.e., items which "get used up" or discarded. For example consumable office supplies are such products as paper, pens, file folder, binders, post-it notes, computer disks, and toner or ink cartridges..etc.. Note: Supplies do not include capital goods such as computers, fax machines, and other business machines or office furniture these would need to be set up in there own line item. Note: Budget should link back to the SOW i.e. subcontractors/conferences/meeting/training/travel/printing/major equipment etc.... these types of services must be identified in the SOW (who/what/when and where) CCC:04/2017 CERTIFICATION ltile offfoia! nllmed be!ow.J;'.!~RTIFYUNQER PEN;ALi-Y .OF PEEJURY that tam dul~ i;t1;1th91'.iie~ 10 legaUx bind .the ptospect[Vi;:{;onttac;ot to th<,·~lause(s) liste.d below. 1'hii; eertificationOis .rnade und~r the fa.,:vs ot'the State ofC.-iHtbmia. By (Arithoffzed Stjhiitti/'e) ATTEST: Fedefr1l ID Number 94600 ; 51-2 .. BERNICE E. SEIDEL Exe,auted hf the: (}J)unty of Fresno CONTRACTOR CERTIFICATION CLAlJSES l .. STATEMENTQF COlvIPUANCfa Contra~tor h~s, unlessi,Mtemptedi-compliec.Lwith· U1e:nt,ndJscrhninq,tio11 p,rQgramr~itir~mebts. ,aov~J:bd; §JM.91) (~4) and CCR, 'ritle2; Se.etion J 1JQ2) (Noprppfiga4le to pµblfo. eritiiie~) . 2. DRUG-FREE WORKFLACEREQUIR:EIYLENTS: Contractor will c.ompJy with the requirements offhe Dtug-Fi,ee Workplace Act ofT9.9'0 and ,viii provide :a drug-'free workpl~l!e bytakfog.tI1~Ioifow4tg 11cti9ns: · a, Ptt~lish a ~atement 11otifyiug•employeesthap.1nla\.vful mamrfactute, distribi1tion, · dispensafiQr1, possession qr~w:ie.qfa controlled subs1ai1ce 'is prohihitca m1d spec:ifying acfipn$ to betaken a~ainsteiilf:iloyoos for viqla.tions; · · · b.Estahlish.a Dn1g,-Free.Awa:ren,ess.Prti$rrun to infonn emp1Qy¢es .about: 1,) the dangers of di:ug abuse .in the \.Vorkplac¢; t} the persl~n's or orgµnization 1s po.Hey oftnaintaininga dru,g-free W(lr~pfac.e; ,:?.) ru1y1;1i.:aflablc colmselir1g,reha.h.ilitatfo11 ande'lnp.loye¢ ass1ii:tancc pri)gratns; ah~, 4) penalties ~ha~ may be itnposcd up¢tl cinpfoyeesibr drug abuse vio.lation~ •. C: Every employee who works <:in the proposed Agreement will: l) r.ece:fvea copy ofthe cbmpilny!s drug-free wotkplac~poiicystatenie11t;ilnd, 2) agi;e~·to ~bide by thet~rm$ qf~he tjom1tany's statement as .a c~ndi1:ibn $f@n111!t?~'rnent on"the Agre~inent . . .... . . . Failute'tO ~omplr with thes:e reqiifr~ments,may re.st!.lt In $J,l$pensioti 9fpaJm~rit:l under the.Agreement or terminatiollofthe Agreement or both an<l'<::ontractoimay he 1n~Ugible · fqt award ofhny futtlte ,State ag~ements, if'the µMa.rtment det~rinittes to4t. any 'of the fo llmvii1g H'~s. occui±ed :,the COrftrac.tor'has made false ce11iffoijtkm. m· -yiolateaihe· j \ STATEOF CAUF0RNIA OALIFd'.RNlA CIVIL RIGHTS LAWS ATTACHMENT .DG$ Ot:,S 04{R~;_ 01t11) -. , -- DEP'ARTMEITT OF GENERAi. SERVICES OFFICE OF LEGAL SER'fl£ES P!.!t'.$Yant t0 PubHc Cootr~gt'Cqde:$€QtiQi1 iow1-~,persorrt~atsub,m~s :a biti or ptol'.!q~a\ to, Of ¢"tn~r,vis~ pr:9pps(?s to ~)1\er:into or renew a cp;ritrn.¢fv,1th, a sf~tij_gg~n~ viifh,J~~p_eey t~tany contract in ths amount of$10{J,0'00 or abov~ shall.certify, µod.erpeti;:il~,p~rju.fy, ~t tbe time fl)e old or.proposal is submitted or.:tlie.oontractis reliei.ved, alldfthe:following; . i, _ CALIFORNIACIVIL RIGHTSLAWS:-Forv0!1~ra¢t~ execut~9 or ~t;inev,ed_affer January 1, 2017, the i;iontra_c"tor cert,ifies compl1artqe 11111th the l)fln.1h Ciyil J~ightsAd ($ectjon s1-of:th e Civil Code) and the Fatr Emplaymentand Housing ;Act (Stactlon 12960 of the $.overnm:ent Code); and 2. EMPLOYER DJSCRiMINATO.RYPOLICIES:For contracts executed or ren~weo after J~nuary 1, 2017i if a Contractor ha$ ~n '.iriterrr~I poliqy ?.Qaihst a<sover~fgn n~Uon or pe9ples recognized by th~ Unit{:}d Stat~s g¢ve(nmefit, the Qontractor ¢erlif.ie~ \h.~fsuch p9lic!ijs are not used in}1iolation otthe:Unruh Civil Righ1s A9t'($ection 51 of tt\e,Givil t'Soo!;!) or the F:air Ernpl oymentand Housing Act (Seclion 129.60 of the Govemmerit Co:de). CERTIFICATION p; tne·official nameabelowi_certry tinder penaltt'?fp~rjury under: l tl:i~ layvs Of the·State of €ahfqm1a thatfhe foregomg IS tni~ Gl_!1d 1 correct. Propdser/Bjddet Ffim .N€}me (Printed) county of Fresno "'if/'(Authotiied Signature) ATTEST: Feaetano Number - BERNICE E. SEIDEL : -~-..,,-----~ Clerk to the Board of Supervisors P' te N --: e. • a Tftle ofP~rsotl Signing County of Fresno, State of California Sal Qbintero, Chairmanj Soard bf:Supervlsors By~ e__. V ti Deputy DB!'~ Executed ----fExecuted in the Cou,it;yand Btate of · :r 1 ~ J Fresno Californi,a CUI\·}~ DI&,_ ______ _,____ ------. ------------------~--..