|
•
<br /> City of Everett Date: 23-May-13
<br /> PROJECT HOURS AND BUDGET ESTIMATE
<br /> Direct Salary HOURS FOR EACH TASK Total
<br /> Labor Caregory Rates' - Task 1 'Task 2 Task 3 Task 4 Task 5 Task 6 Task 7 Task 8 • Task 9 Task 10 Task 11 Task 12 Hours Cost
<br /> 1 Principal Manager $ 59.00 128 56 184 $ 10,856
<br /> 2 Principal Structural $ 54.50 76 76 $ 4,142
<br /> 3 Principal Engineer $ 46.50 128 128 $ 5,952
<br /> 4 QA/QC-DL $ 75.00 12 12 $ 900
<br /> 5 Staff Structural-VP $ 34.00 48 48 $ 1,632
<br /> 6 Const.PM $ 48.00 68 68 $ 3,264
<br /> 7 CAD Technician $ 37.00 128 128 $ 4,736
<br /> 8 Clerical-SF $ 18.00 72 12 84 $ 1,512
<br /> 9
<br /> - $- $ -
<br /> -
<br /> 10
<br /> $
<br /> 11 •
<br /> 12 -
<br /> 13
<br /> Total Task Hours 200 0 0 0 0 0 0 0 0 528 0 728
<br /> _
<br /> Subtotal Direct Salary Cost(DSC),$ 8,848 0 - 0 0 0 0 0 0 0 24,146 0 ' $ 32,994
<br /> Overhead on DSC(Indirect cost)© 146'.84% 12,992 0 0 0 0 0 0 0 0 35,456 0 ; $ 48,448
<br /> Total Labor Cost,$ 21,840 0 0 0 0 0 0 0 0 59,602 0 $ 81,442
<br /> Expenses,'$ Task 1 Task 2 Task 3 Task 4 , Task 5 Task 6 Task 7 Task 8 Task 9 Task 10 Task'12 Expenses
<br /> Direct Expenses 2,500 $ 2,500
<br /> Construction Phase Eng.Support358,000 i $ 358,000
<br /> $
<br /> $ -
<br /> ' 0 0 0 0 0 0 0 0 0 0 0 $ -
<br /> Total Expenses 0 0 0 0 0 0 0 0 0 2,500 358,000 $ 360,500
<br /> .,..L TOTAL LABOR AND EXP 21,840 0 0 . 0 0 0 0 0 0 62,102 358,000 $ 441,942
<br /> CO Subconsultant Expenses,$ ^ . Task 1 Task 2 , Task 3 Task 4" Task 5 Task'6 •Task•? Task 8 Task59 Task 10 Task 12 Sub Expenses
<br /> Makers&Jack McKay 14,640 $14,640
<br /> MSA . 11,925 $11,925
<br /> Perteet47,452 $47,452
<br /> $0
<br /> Total Subconsultant Expense: 0 ' 0 0 0 14,640 11,925 0 0 47,452 0 0 $74,017
<br /> TOTAL SUBCONSULTANTS 0 0 0 0 14,640 11,925 0 0 47,452 0 0 _ $74,017'
<br /> Subconsultant Admin Mark-un 0.0% 0 0 0 0 0 0 0 0 0 0 0 $0
<br /> Subtotal Cost by Task 21,840 0 0 0 14,640 11,925 0 0 47,452 62,102 358,000 $ 515,959
<br /> FEE(as%of Total DSC&Overhead) 0.0511 0 0 0 0 0 0 0 0 0 0 0 , $
<br /> FEE(as%of DSC Only) 3031% 2,655 0 0 0 0 0 0 0 0 7,244 0 $ 9,899
<br /> Next Year's Labor Escalation" 0.0% 0 0 0 0 0 0 0 0 0 0 0 $
<br /> Task 1 Task 2 Task 3 Task 4 Task 5 Task 6 Task 7 Task 8 Task 9 Task 10 Task 12 i Total
<br /> TOTAL ESTIMATED COST AND FEE,'$ 24,495 0 0 0 14,640 11,925 0 0 47,452 69,346 358,000 $ 525,858
<br /> •
<br /> Enter data in yellow&green shaded _ cells only. Other formula cells are locked to prevent accidental changes. There is no password protection.
<br /> I Overall'ProjecUMultiplier l X21771
<br /> Profit as a%of DirecttSalary'Costt(DSC)'I .-- 3010%1 •
<br />
|