The table below presents a cost estimate WBS submitted with a proposal to develop a surface water drainage plan for a new water treatment plant. Complete the following exercises regarding the anticipated financial performance of the project. Turn in printouts (neat and well organized) of your work. Personnelltem Unit Unit Rate Task Item Surface Water Drainage Plan Units! Items Item Subtotal Task Subtotal Labor Costs Principal Project Manager Project Engineer Staff Engineer AutoCAD Administrative Assistant hr 180.00 hr 150.00 hr 120.00 hr 90.00 hr 85.00 hr 55.00 Labor Subtotals 35 24 $ 16 $ 20 $ 24 $ 8 $ 95 540 3600 1920 1.800 2040 440 $10.340 Direct Costs Copies, shipping, binding mis Travel (Site Visit set day 500.00 6 $ 200.000 1$ Direct Costs Subtotal 3,000 200 $3,200 Outside Services Aerial Lidar Survey Cultural Resource Survey Is 4500.00 $ Is 3900.00 1$ Outside Services Subtotal 4.500 3.900 $8,400 Subtotal $21.940 Administrative Fee Direct Costs Fee Outside Services Fee 5% 15% 15% $517 $480 $1260 TOTAL ESTIMATE $24,197 1. The annual salaries of the proposed staff for this task are provided below. Develop a spreadsheet that calculates the labor price (PL), direct cost of labor (DCL), burdened cost of labor (BCL), overhead cost (OH), and profit ($ and %) that will report to the project for each individual and for the project as a whole (e.g. include a column for totals for each employee). Assume an Overhead Multiplier of 1.85? (12 points) Principal Project Manager Project Engineer Staff Engineer AutoCAD Administrative Assistant $130,000 $102,700 $75,000 $58,500 $58,000 $36,000 1- you will enter the DCL, OH, BCL, M$ and M% that report for each of your staff for the entire project, so don't forget to multiply the hourly figures by the number of hours per employee. (Omit the $$ sign, and use 2 decimal places, Example: 1234.56) Principle: DCL OH BCL M$ M% Project manager: DCL OH BCL M$ M% Project engineer DCL OH BCL M$ M% Staff engineer DCL OH BCL M$ M% AutoCAD technician DCL OH BCL M$ M% Administrative Assistant DCL OH BCL M$ M% 2- You will also enter the TOTAL DCL, OH, BCL, M$ AND M% for the project as a whole. 3- The target profit margin (M%) for your firm is: (Omit the % sign, and use 1 decimal place. Example: 12.3) 4- The 'ideal' annual salary for the Principal at his current billing rate is: (Omit the $ sign, and don't include cents. Example: 123,000) 5- The 'ideal' annual salary for the Project Manager at her current billing rate is: (Omit the $ sign, and don't include cents. Example: 123,000) 6- The 'ideal' annual salary for the Project Engineer at his current billing rate is: (Omit the $ sign, and don't include cents. Example: 123,000) 7- The "ideal' annual salary for the Staff Engineer at his current billing rate is: (Omit the $ sign, and don't include cents. Example: 123,000) 8- The 'ideal' annual salary for the AutoCAD Technician at his current billing rate is: (Omit the $ sign, and don't include cents. Example: 123,000) 9- The 'ideal' annual salary for the Administrative Assistant at her current billing rate is: (Omit the $ sign, and don't include cents. Example: 123,000)