Please complete the following Job Cost Report:
Based on the information below:
Job Cost Report Code Description 02100 Sitework 03300 Concrete 04400 Masonry 05500 Steel 06149 06500 07100 08100 09100 09500 09900 15100 HVAC 15500 16000 Pre-Engineered Trusses Carpentry Insulation Doors & Hardware Drywall Painting Flooring Plumbing Electrical Profit & Overhead Job Total Contract Amount Billed to Date Actual COSTS Budgeted Over/Under Actual $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Hours Budgeted Over/Under Actual $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Totals Budgeted $ $ $ $ $ $ Over/Under $ $ $ $ $ $ $ $ $ $ $ Careless Construction Co. Case Study You have been hired to do a post mortem audit on a project that was riddled with problems for a local construction firm, Careless Construction Co. The project management team for this project was Mrs. Anita NuJob as the PM, Mr. Lemme Spendall as the superintendent, and Mr. Gonna Gain as the company owner. Your team spends three weeks analyzing data and finds the attached items: Original Project Budget/Estimate List of Home Depot and Lowes receipts totaling $18,000 included in the accounting reports A report from the accounting department showing the following totals: Account Material Invoices Time sheets Vendor Invoices $84,500 Sitework Concrete $10,875 6 workers at an ave. pay of $15/hr worked 115 hrs ea. $16,785 Masonry Steel $975 $8,000 1 worker @ $25/hr working 22 hrs Pre-Engineered Trusses $500 $3,000 7 workers @ $18/hr working Carpentry $4,642 40 hrs ea. Timesheets total $12,000 $1,200 Insulation $2,400 Doors & Hardware $3,200 1 man/1 hr per door @ $56/hr Drywall $1892 $2,200 Painting 2672 $4,285 Flooring $5,600 HVAC $15,000 Plumbing $6000 Electrical $16,985 Office Overhead and General $30,000 in expenses Conditions Costs Additionally, of the few subcontracts you found, a few were signed by only one party. There was no documentation indicating any approval process for the contracts or po's. All items have been billed to date. Mr. Spendall and Mrs. NuJob have a good working relationship but that's mostly because they don't spend much time talking to each other. Mr. Gain has two other businesses that he is very worried about and thus has hired you to solve his construction company's problem. To better analyze the project you need to complete a job cost report using the attached template. To help Careless Construction Co. avoid these problems in the future prepare a one to two page professional report on your findings and provide some recommended procedures to help this company better manage their projects in the future. Careless Construction Co. Project Estimate Code Description QTY. Unit Material Labor Subcontracts 02100 Sitework 1 LS 0 03300 Concrete 105 CY 92 04400 Masonry 1 LS 0 05500 Steel 10 EA 0 06149 Pre-Engineered Trusses 1 LS 3000 3000 06500 Carpentry 2880 SF 2 4 07100 Insulation 1 LS 0 0 08100 Doors & Hardware 16 EA 215 95 09100 Drywall 500 LF 4 4 09500 Painting 2880 SF 0 0 09900 Flooring 800 SF 1 0 15100 HVAC 1 LS 15500 Plumbing 1 LS 16000 Electrical 1 LS Sub Total Profit & Overhead Final Total Estimate 0.1 % 85 Budget Bid Schedule Amount of Values 80000 $80,000.00 $ 80,000.00 0 $ 18,585.00 $ 22,000.00 17500 $ 17,500.00 $ 18,000.00 800 $ 8,000.00 $ 8,000.00 0 $ 6,000.00 $ 6,000.00 $ 17,500.00 17,280.00 $ $2,500.00 $ 2,000.00 0 $ 4,960.00 $ 5,000.00 0 $ 4,000.00 $ 4,000.00 1.05 $ 3,024.00 $ 3,000.00 6 $ 5,600.00 $ 5,800.00 14895 $ 14,895.00 $ 15,000.00 7650 $ 7,650.00 $ 7,650.00 16985 $ 16,985.00 $ 16,985.00 $206,979.00 $ 210,935.00 $ 20,697.90 $ 20,000.00 $ 227,676.90 $ 230,935.00 2500 Job Cost Report Code Description 02100 Sitework 03300 Concrete 04400 Masonry 05500 Steel 06149 06500 07100 08100 09100 09500 09900 15100 HVAC 15500 16000 Pre-Engineered Trusses Carpentry Insulation Doors & Hardware Drywall Painting Flooring Plumbing Electrical Profit & Overhead Job Total Contract Amount Billed to Date Actual COSTS Budgeted Over/Under Actual $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Hours Budgeted Over/Under Actual $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Totals Budgeted $ $ $ $ $ $ Over/Under $ $ $ $ $ $ $ $ $ $ $ Careless Construction Co. Case Study You have been hired to do a post mortem audit on a project that was riddled with problems for a local construction firm, Careless Construction Co. The project management team for this project was Mrs. Anita NuJob as the PM, Mr. Lemme Spendall as the superintendent, and Mr. Gonna Gain as the company owner. Your team spends three weeks analyzing data and finds the attached items: Original Project Budget/Estimate List of Home Depot and Lowes receipts totaling $18,000 included in the accounting reports A report from the accounting department showing the following totals: Account Material Invoices Time sheets Vendor Invoices $84,500 Sitework Concrete $10,875 6 workers at an ave. pay of $15/hr worked 115 hrs ea. $16,785 Masonry Steel $975 $8,000 1 worker @ $25/hr working 22 hrs Pre-Engineered Trusses $500 $3,000 7 workers @ $18/hr working Carpentry $4,642 40 hrs ea. Timesheets total $12,000 $1,200 Insulation $2,400 Doors & Hardware $3,200 1 man/1 hr per door @ $56/hr Drywall $1892 $2,200 Painting 2672 $4,285 Flooring $5,600 HVAC $15,000 Plumbing $6000 Electrical $16,985 Office Overhead and General $30,000 in expenses Conditions Costs Additionally, of the few subcontracts you found, a few were signed by only one party. There was no documentation indicating any approval process for the contracts or po's. All items have been billed to date. Mr. Spendall and Mrs. NuJob have a good working relationship but that's mostly because they don't spend much time talking to each other. Mr. Gain has two other businesses that he is very worried about and thus has hired you to solve his construction company's problem. To better analyze the project you need to complete a job cost report using the attached template. To help Careless Construction Co. avoid these problems in the future prepare a one to two page professional report on your findings and provide some recommended procedures to help this company better manage their projects in the future. Careless Construction Co. Project Estimate Code Description QTY. Unit Material Labor Subcontracts 02100 Sitework 1 LS 0 03300 Concrete 105 CY 92 04400 Masonry 1 LS 0 05500 Steel 10 EA 0 06149 Pre-Engineered Trusses 1 LS 3000 3000 06500 Carpentry 2880 SF 2 4 07100 Insulation 1 LS 0 0 08100 Doors & Hardware 16 EA 215 95 09100 Drywall 500 LF 4 4 09500 Painting 2880 SF 0 0 09900 Flooring 800 SF 1 0 15100 HVAC 1 LS 15500 Plumbing 1 LS 16000 Electrical 1 LS Sub Total Profit & Overhead Final Total Estimate 0.1 % 85 Budget Bid Schedule Amount of Values 80000 $80,000.00 $ 80,000.00 0 $ 18,585.00 $ 22,000.00 17500 $ 17,500.00 $ 18,000.00 800 $ 8,000.00 $ 8,000.00 0 $ 6,000.00 $ 6,000.00 $ 17,500.00 17,280.00 $ $2,500.00 $ 2,000.00 0 $ 4,960.00 $ 5,000.00 0 $ 4,000.00 $ 4,000.00 1.05 $ 3,024.00 $ 3,000.00 6 $ 5,600.00 $ 5,800.00 14895 $ 14,895.00 $ 15,000.00 7650 $ 7,650.00 $ 7,650.00 16985 $ 16,985.00 $ 16,985.00 $206,979.00 $ 210,935.00 $ 20,697.90 $ 20,000.00 $ 227,676.90 $ 230,935.00 2500
