13. Determine the monthly cash flows and total cash generated at the end of each month and just before the payment is received for the construction of a house with the following budget and schedule. 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 a 10% retention. Final payment is expected one month after completion of the project and includes the retention. The construction 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 a 10% retention from the subcontractor's payment. The construction company pays weekly for labor. Often costs will be paid throughout the month that costs are incurred. The projected monthly material, labor, subcontractor, and other costs follow. The construction company will add a 10% profit and overhead markup to these costs when billing the owner. Solve this problem using a spreadsheet. FINISH MAT. (S) LABOR ($) SUB. (S) OTHER (S) START ITEM 4-Jun 0 4-Jun 1,500 Sanitary Sewer 7-Jun 6-Jun 8-Jun 1,500 2,500 Water Line 11-Jun 0 Excavation 12-Jun 20-Jun 21-Jun 22-Jun 25-Jun 26-Jun 31-Jul 3,750 Footing and Foundation Sub-rough Plumbing Slab/Floor 3,490 0 2,000 600 0 1,150 27-Jun 12,340 18,560 Rough Carpentary 1-Aug 3-Aug 1,000 4,800 Ext. Doors and Windows 6-Aug 8-Aug 9-Aug 10-Aug 13-Aug 14-Aug 4,000 3,750 3,000 Rough Plumbing Rough HVAC Rough Electrical 17-Aug 17-Aug 1,650 Insulation 22-Aug 29-Aug 4,000 Drywall (Continued ITEM MAT. ($) LABOR ($) SUB. ($) OTHER ($) START FINISH Doors and Trim 6,250 1,000 30-Aug 4-Sep Paint 5-Sep 12-Sep 0 2,500 0 Cabinetry Overhead Door 13-Sep 17-Sep 13-Sep 13-Sep 6,800 0 600 0 Shower Surround 1,350 18-Sep 19-Sep 0 Hardware and Bath Access. 0 20-Sep 21-Sep 900 300 2,500 5,000 Ceramic Tile 24-Sep 27-Sep 0 0 2-Oct Floor Coverings 28-Sep 0 5-Oct Finish Plumbing 0 3-Oct 0 2,000 1,250 8-Out 8-Oct Finish Mechanical 0 0 9-Oct 10-0ct 3,000 0 Finish Electrical 11-Oct 11-Oct 200 2,300 Appliances 12-Oct 12-Oct 0 0 1,000 Blinds 17-Aug 21-Aug 22-Aug 28-Aug 4-Sep 5-Sep 2,070 0 Roofing 2,650 Masonry 29-Aug 3,870 Siding 5-Sep 6-Sep 12-Sep 500 Rain Gutters 1,220 1,365 Site Concrete 13-Sep 19-Sep 4,500 0 Fencing 20-Sep 26-Sep s,000 Landscaping Supervision Temporary Utilities Trash Disposal Building Permit Clean Up 1-Jun 18-Oct 1-Jun 18-Oct 1-Jun 18-Oct 1-Jun 2,000 2,100 1,500 1,000 1-Jun 17-Oct 18-Oct 750 4,600 67 490 23,160 39,815 Total OOO Oo