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. Units/ Item Task Item Personnel/Item Unit Unit Rate Task Subtotal Items Subtotal Surface Water Drainage Plan Labor Costs Principal Project Manager Project Engineer Staff Engineer AutoCAD Administrative Assistant 180.00 150.00 120.00 90.00 85.00 3 S 24 $ 16 $ 20 $ 24 $ 8 S hr 540 3,600 1,920 1,800 2,040 hr hr hr hr 55.00 Labor Subtotals hr 440 95 $10,340 Direct Costs Copies, shipping, binding mtls Travel (Site Visit) 500.00 200.00 set 6 $ 3,000 day 200 Direct Costs Subtotal $3,200 Outside Services Aerial Lidar Survey Cultural Resource Survey 4500.00 3900.00 Is 2$ 4,500 3,900 $8,400 Subtotal Is 1 $ Outside Services Subtotal $21,940 $517 $480 $1,260 Administrative Fee 5% Direct Costs Fee 15% Outside Services Fee 15% 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 $130,000 Project Manager $102,700 Project Engineer $75,000 Staff Engineer $58,500 AutoCAD $58,000 Administrative Assistant $36,000

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Concept explainers

Question

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)

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.
Units/
Item
Task Item
Personnel/Item
Unit
Unit Rate
Task Subtotal
Items
Subtotal
Surface Water Drainage Plan
Labor Costs
Principal
Project Manager
Project Engineer
Staff Engineer
AutoCAD
Administrative Assistant
180.00
150.00
120.00
90.00
85.00
hr
24 $
16 $
20 $
24 $
8 $
540
3,600
1,920
1,800
2,040
hr
hr
hr
hr
55.00
Labor Subtotals
hr
440
95
$10,340
Direct Costs
Copies, shipping, binding mtls
Travel (Site Visit)
500.00
200.00
set
6 $
3,000
day
200
Direct Costs Subtotal
$3,200
Outside Services
Aerial Lidar Survey
Cultural Resource Survey
4500.00
3900.00
Is
4,500
3,900
$8,400
Subtotal
2$
Is
1 $
Outside Services Subtotal
$21,940
$517
$480
$1,260
Administrative Fee
5%
Direct Costs Fee
15%
Outside Services Fee
15%
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
$130,000
Project Manager
$102,700
Project Engineer
$75,000
Staff Engineer
$58,500
AutoCAD
$58,000
Administrative Assistant
$36,000

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions