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 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 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 10% retention from the subcontractor’s payment. The construction company pays weekly for labor. Other costs will be paid throughout the month that costs are incurred. The projected monthly material, labor, subcontractor, and other costs are shown in profit and overhead markup to these costs when billing the owner. Solve this problem using a spread sheet .Table 12-14. The construction company will add a 10%

Item 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 Mat. (S) 0 0 0 3,490 0 1,150 18,560 4,800 0 0 0 0 0 6,250 0 0 0 0 900 Labor ($) 0 0 0 3,750 0 600 12,340 1,000 0 0 0 0 0 1,000 0 0 0 0 300 Sub. (S) 1,500 1,500 2,500 0 2,000 0 0 0 4,000 3,750 3,000 1,650 4,000 0 2,500 6,800 600 1,350 0 Other (S) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Start 4-Jun 6-Jun 8-Jun 12-Jun 21-Jun 25-Jun 27-Jun 1-Aug 6-Aug 9-Aug 13-Aug 17-Aug 22-Aug 30-Aug 5-Sep 13-Sep 13-Sep 18-Sep 20-Sep Finish 4-Jun 7-Jun 11-Jun 20-Jun 22-Jun 26-Jun 31-Jul 3-Aug 8-Aug 10-Aug 14-Aug 18-Aug 29-Aug 4-Sep 12-Sep 17-Sep 13-Sep 19-Sep 21-Sep