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 aspreadsheet.

MAT. ($) LABOR () SUB. S) OTHER () START FINISH Excavation Footing and Foundation Sub-rough Plumbing 3,490 3,750 0 12-Jun 20-Jun 0 21-Jun 22-Jun 0 25-Jun 26-Jun 0 27-un 31-Jul 0 -Aug 3-Aug 0 6-Aug 8-Aug 0 9-Aug 10-Aug 0 13-Aug 14-Aug 0 17-Aug 17-Aug 0 22-Aug 29-Aug 0 30-Aug 4-Sep 0 5-Sep 12-Sep 0 13-Sep 17-Sep 0 13-Sep 13-Sep 0 18-Sep 19-Sep 0 20-Sep 21-Sep 0 24-Sep 27-Sep 0 28-Sep 2-Oct 2 Rough Carpentary Ext. Doors and Windows Rough Plumbing Rough HVAC Rough Electrical Insulation 18,560 12,340 1 Doors and Trim Overhead Door Hardware and Bath Access Floor Coverings Finish Plumbing Finish Mechanical Finish Electrical Appliances 0 9-Oct 10-Oct 0 11-Oct 11-Oct 0 12-Oct 12-Oct 0 17-Aug 21-Aug 0 22-Aug 28-Aug 0 29-Aug 4-Sep Roofing 0 2,070 5 0 3,870 Rain Gutters 1,365 1,220 2 rete 0 13-Sep 19-Sep 0 20-Sep 26-Sep 0 1Jun 18-Oct 0 2,100 -Jun 18-Oct 0 1,500 -Jun 18-Oct 0 1,000 -Jun 1-Jun 0 17-Oct 18-Oct 5 Landscaping Supervision Temporary Utilities Trash Disposal Building Permit 2 39,815 23,160 67,490 4,600