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: Material Invoices Time sheets Account Sitework Concrete Vendor Invoices $84,500 $10,875 6 workers at an ave. pay of $15/hr worked 115 hrs ea. Masonry Steel $16,785 $8,000 $975 Pre-Engineered Trusses $500 $3,000 1 worker @ $25/hr working 22 hrs 7 workers @ $18/hr working 40 hrs ea. Timesheets total $12,000 Carpentry $4,642 $1,200 $2,400 Insulation Doors & Hardware $3,200 1 man/1 hr per door @ $56/hr $1892 2672 Drywall Painting Flooring HVAC Plumbing Electrical Office Overhead and General Conditions Costs $2,200 $4,285 $5,600 $15,000 $6000 $16,985 $30,000 in expenses . . . 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. ...- Li- Careless Construction Co. Project Estimate Code 02100 03300 04400 05500 06149 06500 07100 08100 09100 09500 09900 15100 15500 16000 NO 0 Description Sitework Concrete Masonry Steel Pre-Engineered Trusses Carpentry Insulation Doors & Hardware Drywall Painting Flooring HVAC Plumbing Electrical Sub Total Profit & Overhead Final Total Estimate Budget Bid Schedule QTY. Unit Material Labor Subcontracts Amount of Values 1 LS 0 0 80000 $ 80,000.00 $ 80,000.00 105 CY 92 85 0 $ 18,585.00 $ 22,000.00 1 LS 0 0 17500 $ 17,500.00 $ 18,000.00 10 EA 0 0 800 $ 8,000.00 8,000.00 1 LS 3000 3000 0 $ 6,000.00 $ 6,000.00 2880 SF 2 4 $ 17,280.00 $ 17,500.00 1 LS 2500 $ 2,500.00 $ 2,000.00 16 EA 0 $ 4,960.00 $ 5,000.00 500 LE 0 $ 4,000.00 $ 4,000.00 2880 SF 1.05 $ 3,024.00 $ 3,000.00 800 SF 6 $ 5,600.00 $ 5,800.00 1 LS 14895 $ 14,895.00 $ 15,000.00 1 LS 7650 $ 7,650.00 $ 7,650.00 1 LS 16985 $ 16,985.00 $ 16,985.00 $ 206,979.00 $ 210,935.00 0.1 % $ 20,697.90 $ 20,000.00 $ 227,676.90 $ 230,935.00 215 95 4 4 0 OOHOOO 0 0 o 0 Job Cost Report COSTS Hours Totals Contract Amount Billed to Date Actual Budgeted Over/Under Actual Budgeted Over/Under Actual $ 5 S en in is in $ $ $ Over/Under $ $ $ $ $ Code 02100 03300 04400 05500 06149 06500 07100 08100 09100 09500 09900 15100 15500 16000 Description Sitework Concrete Masonry Steel Pre-Engineered Trusses Carpentry Insulation Doors & Hardware Drywall Painting Flooring HVAC Plumbing Electrical Profit & Overhead Job Total sunun Budgeted S $ S $ $ S $ $ $ $ $ $ S $ $ $ $ S $ $ $ $ $ $ $ $ $ S S $ $ $ $ $ $ $ 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: Material Invoices Time sheets Account Sitework Concrete Vendor Invoices $84,500 $10,875 6 workers at an ave. pay of $15/hr worked 115 hrs ea. Masonry Steel $16,785 $8,000 $975 Pre-Engineered Trusses $500 $3,000 1 worker @ $25/hr working 22 hrs 7 workers @ $18/hr working 40 hrs ea. Timesheets total $12,000 Carpentry $4,642 $1,200 $2,400 Insulation Doors & Hardware $3,200 1 man/1 hr per door @ $56/hr $1892 2672 Drywall Painting Flooring HVAC Plumbing Electrical Office Overhead and General Conditions Costs $2,200 $4,285 $5,600 $15,000 $6000 $16,985 $30,000 in expenses . . . 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. ...- Li- Careless Construction Co. Project Estimate Code 02100 03300 04400 05500 06149 06500 07100 08100 09100 09500 09900 15100 15500 16000 NO 0 Description Sitework Concrete Masonry Steel Pre-Engineered Trusses Carpentry Insulation Doors & Hardware Drywall Painting Flooring HVAC Plumbing Electrical Sub Total Profit & Overhead Final Total Estimate Budget Bid Schedule QTY. Unit Material Labor Subcontracts Amount of Values 1 LS 0 0 80000 $ 80,000.00 $ 80,000.00 105 CY 92 85 0 $ 18,585.00 $ 22,000.00 1 LS 0 0 17500 $ 17,500.00 $ 18,000.00 10 EA 0 0 800 $ 8,000.00 8,000.00 1 LS 3000 3000 0 $ 6,000.00 $ 6,000.00 2880 SF 2 4 $ 17,280.00 $ 17,500.00 1 LS 2500 $ 2,500.00 $ 2,000.00 16 EA 0 $ 4,960.00 $ 5,000.00 500 LE 0 $ 4,000.00 $ 4,000.00 2880 SF 1.05 $ 3,024.00 $ 3,000.00 800 SF 6 $ 5,600.00 $ 5,800.00 1 LS 14895 $ 14,895.00 $ 15,000.00 1 LS 7650 $ 7,650.00 $ 7,650.00 1 LS 16985 $ 16,985.00 $ 16,985.00 $ 206,979.00 $ 210,935.00 0.1 % $ 20,697.90 $ 20,000.00 $ 227,676.90 $ 230,935.00 215 95 4 4 0 OOHOOO 0 0 o 0 Job Cost Report COSTS Hours Totals Contract Amount Billed to Date Actual Budgeted Over/Under Actual Budgeted Over/Under Actual $ 5 S en in is in $ $ $ Over/Under $ $ $ $ $ Code 02100 03300 04400 05500 06149 06500 07100 08100 09100 09500 09900 15100 15500 16000 Description Sitework Concrete Masonry Steel Pre-Engineered Trusses Carpentry Insulation Doors & Hardware Drywall Painting Flooring HVAC Plumbing Electrical Profit & Overhead Job Total sunun Budgeted S $ S $ $ S $ $ $ $ $ $ S $ $ $ $ S $ $ $ $ $ $ $ $ $ S S $ $ $ $ $ $ $