Table 12-14 Budget and Schedule for Problem 18 Item Finish Start Sub. (S) Other (8) mat. (5) 0 0 Labor (8) 0 0 0 3,750 1,500 1,500 2,500 O 3,490 2.000 1,150 18,560 4,800 600 12,340 1,000 10-Aug 0 0 4,000 3,750 3,000 1,650 4,000 0 2,500 6,800 600 1,350 6,250 1,000 300 0 21-Sep Sanitary Sewer Water Line Excavation Footing and Foundation Sub-rough Plumbing Slab/Floor Rough Carpentry Ext. Doors and Windows Rough Plumbing Rough HVAC Rough Electrical Insulation Drywall Doors and Trim Paint Cabinetry Overhead Door Shower Surround Hardware and Bath Accessories Ceramic Tile Floor Coverings Finish Plumbing Finish Mechanical Finish Electrical Appliances Blinds Roofing Masonry Siding Rain Gutters Site Concrete Fencing Landscaping Supervision Temporary Utilities Trash Disposal Building Permit Cleanup 0 4-Jun 4-Jun 6-Jun 7-Jun 8-Jun 11-Jun 12-Jun 20-Jun 21-Jun 22-Jun 25-Jun 26-Jun 27-Jun 31-Jul 1 - Aug 3-Aug 6-Aug 8-Aug 9-Aug 13-Aug 14-Aug 17-Aug 17-Aug 22-Aug 29-Aug 30-Aug 4-Sep 5-Sep 12-Sep 13-Sep 17-Sep 13-Sep 13-Sep 18-Sep 19-Sep 20-Sep 24-Sep 27-Sep 28-Sep 2-Oct 3-Oct 5-Oct 8-Oct 8-Out 9-Oct 10-Oct 11-Oct 11-Oct 12-Oct 12-Oct 17-Aug 21-Aug 22-Aug 28-Aug 29-Aug 4-Sep 5 -Sep 5-Sep 6-Sep 12-Sep 13-Sep 19-Sep 20-Sep 26-Sep 1-Jun 18-Oct 1-Jun 18-Oct 1-Jun 18-Oct 1-Jun 1-Jun 17-Oct 18-Oct 2,500 5,000 2,000 1.250 3,000 0 0 0 200 O 2.300 1,000 0 2,070 0 0 2,650 3,870 500 0 4,500 5,000 1,365 1,220 O 0 0 O 2,000 0 0 0 0 0 2,100 1,500 1,000 0 4,600 750 0 Total 39,815 23,160 67,490 173 Cash Flows for Construction Projects but withholds retention from the subcontractor's payment. The construction company pays for labor weekly. Use the spreadsheet to solve Example 12-3 and Problems 8 and 9. Create a spreadsheet to prepare a cash flow from a hous- ing project like the one in Example 12-6. The spread- sheet should cover 12 months and allow for four house types with a duration of eight months. Use the spread- sheet to solve Example 12-6 and Problems 10 and 11. 17. Modify the spread sheet in Problem 15 to handle devel- opment costs. Use the spreadsheet to solve Example 12-7 and Problems 12 and 13. Determine the monthly cash flows and total cash gener- ated at the end of each month and just before the pay- ment is received for the construction of a house with the budget and schedule shown in Table 12-14. On the last day of each month the construction company may bill the owner for the work completed during the month. The owner pays the monthly bills one month after they are received. The owner also holds 10% retention. Final payment is expected one month after completion of the project and includes the retention. The construc- tion company pays material suppliers in full when it receives payment from the owner. The construction company pays subcontractors when it receives payment from the owner but withholds 10% retention from the subcontractor's payment. The construction company pays weekly for labor. Other costs will be paid through- out the month that costs are incurred. The projected monthly material, labor, subcontractor, and other costs are shown in Table 12-14. The construction company will add a 10% profit and overhead markup to these costs when billing the owner. Solve this problem using a spreadsheet. Table 12-14 Budget and Schedule for Problem 18 Item Finish Start Sub. (S) Other (8) mat. (5) 0 0 Labor (8) 0 0 0 3,750 1,500 1,500 2,500 O 3,490 2.000 1,150 18,560 4,800 600 12,340 1,000 10-Aug 0 0 4,000 3,750 3,000 1,650 4,000 0 2,500 6,800 600 1,350 6,250 1,000 300 0 21-Sep Sanitary Sewer Water Line Excavation Footing and Foundation Sub-rough Plumbing Slab/Floor Rough Carpentry Ext. Doors and Windows Rough Plumbing Rough HVAC Rough Electrical Insulation Drywall Doors and Trim Paint Cabinetry Overhead Door Shower Surround Hardware and Bath Accessories Ceramic Tile Floor Coverings Finish Plumbing Finish Mechanical Finish Electrical Appliances Blinds Roofing Masonry Siding Rain Gutters Site Concrete Fencing Landscaping Supervision Temporary Utilities Trash Disposal Building Permit Cleanup 0 4-Jun 4-Jun 6-Jun 7-Jun 8-Jun 11-Jun 12-Jun 20-Jun 21-Jun 22-Jun 25-Jun 26-Jun 27-Jun 31-Jul 1 - Aug 3-Aug 6-Aug 8-Aug 9-Aug 13-Aug 14-Aug 17-Aug 17-Aug 22-Aug 29-Aug 30-Aug 4-Sep 5-Sep 12-Sep 13-Sep 17-Sep 13-Sep 13-Sep 18-Sep 19-Sep 20-Sep 24-Sep 27-Sep 28-Sep 2-Oct 3-Oct 5-Oct 8-Oct 8-Out 9-Oct 10-Oct 11-Oct 11-Oct 12-Oct 12-Oct 17-Aug 21-Aug 22-Aug 28-Aug 29-Aug 4-Sep 5 -Sep 5-Sep 6-Sep 12-Sep 13-Sep 19-Sep 20-Sep 26-Sep 1-Jun 18-Oct 1-Jun 18-Oct 1-Jun 18-Oct 1-Jun 1-Jun 17-Oct 18-Oct 2,500 5,000 2,000 1.250 3,000 0 0 0 200 O 2.300 1,000 0 2,070 0 0 2,650 3,870 500 0 4,500 5,000 1,365 1,220 O 0 0 O 2,000 0 0 0 0 0 2,100 1,500 1,000 0 4,600 750 0 Total 39,815 23,160 67,490 173 Cash Flows for Construction Projects but withholds retention from the subcontractor's payment. The construction company pays for labor weekly. Use the spreadsheet to solve Example 12-3 and Problems 8 and 9. Create a spreadsheet to prepare a cash flow from a hous- ing project like the one in Example 12-6. The spread- sheet should cover 12 months and allow for four house types with a duration of eight months. Use the spread- sheet to solve Example 12-6 and Problems 10 and 11. 17. Modify the spread sheet in Problem 15 to handle devel- opment costs. Use the spreadsheet to solve Example 12-7 and Problems 12 and 13. Determine the monthly cash flows and total cash gener- ated at the end of each month and just before the pay- ment is received for the construction of a house with the budget and schedule shown in Table 12-14. On the last day of each month the construction company may bill the owner for the work completed during the month. The owner pays the monthly bills one month after they are received. The owner also holds 10% retention. Final payment is expected one month after completion of the project and includes the retention. The construc- tion company pays material suppliers in full when it receives payment from the owner. The construction company pays subcontractors when it receives payment from the owner but withholds 10% retention from the subcontractor's payment. The construction company pays weekly for labor. Other costs will be paid through- out the month that costs are incurred. The projected monthly material, labor, subcontractor, and other costs are shown in Table 12-14. The construction company will add a 10% profit and overhead markup to these costs when billing the owner. Solve this problem using a spreadsheet