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. 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 Table. The construction company will add a 10% profit and overhead markup to these costs when billing the owner. Solve this problem using a spreadsheet