Compute the average hourly cost of a carpenter to a contractor

Problem Set 6 (Ch. 16 & 17) Cost Estimation
Your Name Here
Overview:
Final ‘problem sets’ should include a word document (.docx) (12-point font, 1” margins, times new roman) that responds to each individual problem below. Include the problem statement in this document, as well as your solution. Make sure that each solution includes:
A description of what you did and how you did it;
All values clearly labeled with units (e.g., “work days”, “crews”, “workers”);
A reference included for any reference to a table, figure, or equation provided in a text; and
A clear description/reference to what you found;
All calculations (formulas and how they are used) must be shown; and
Calculations can be completed in excel, but must be documented in full professionally in this word document.
Given Information:
Problem #1: Compute the average hourly cost of a carpenter to a contractor. Assume the work is in a subsistence area and the daily subsistence rate is $19.50. The carpenter works the second shift on a two-shift project where a project labor contract establishes a “work 7 pay 8 hour” pay basis for straight time. He works 6 days, 10 hours a day. In addition to time and a half for overtime Monday through Friday, the contract calls for double time for all work on weekends.
Use 6.2% FICA and 5.0% for unemployment insurance.
Assume all data relating to the workman’s comp, public liability, property damage, fringes, and wage are as given in Table 16.5.
Assume the maximum coverage is $5,000 per person and $10,000 per accident for public liability;
Assume the maximum coverage is $5,000 per person and $25,000 per accident for property damage; and
Note that the subsistence rate is not the same as the base wages from Table 16.5.
Show your work in excel or by hand, but make sure to provide each step of this problem including calculation of:
hours worked, straight time, and premium time;
straight time pay, premium pay, and gross pay;
fringe costs;
Workman’s comp, public liability, and property damage costs;
FICA, unemployment, and subsistence; and
Total costs (for the week) and average hourly cost (considering hours worked, not straight or premium hours).

Solution #1:

Problem #2: You are a contractor assigned to estimate the cost of this development. After completing the quantity takeoff of the given materials, you have compiled the following list of materials, quantities, as well as cost estimates based on quoted values or ranges and productivity rates based on your most recent jobs. Estimate the following for each material:
Hours of time spent on each material;
Cost of each material quantity (e.g., total cost for each material); and
Total cost per unit if your crew’s total hourly billing rate (including all overhead) is $170/hour; and
Cost per unit of each material quantity including both estimated labor and material costs for each material.
Table 2 Estimated Costs and Productivity Rates by Material
Material Material Notes Quantity Unit Cost Productivity Rate
[$/unit] [Unit/hour]
A Masonry 8″ 1200 sf $ 2.39 45
B 10″ 600 sf $ 2.50 38
C Finish 1800 sf $ 0.50 40
D Installation loose-fill 24 cyd $ 1.08 4.5
E rigid 30 cyd $ 1.40 3.5
F Concrete 15 cyd $ 105.00 12
G Rebar <#5 100 lb $ 1.06 65 H #5-#6 120 lb $ 1.12 60 I >#6 90 lb $ 1.17 55
J Fill rock 20 cyd $ 32.00 14
K Plywood 1300 sf $ 1.09 100
L Moisture barrier 1800 sf $ 0.11 60
M Studs 150 bf $ 42.50 120
N Light fixtures 30 each $ 38.00 2.5
O Doors 15 each $ 90.00 1.2
P Windows 25 each $ 65.00 1.4
Notes:
` Cyd: cubic yard; lb: pounds; sf: square feet; bf: board feet

Solution #2: