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 ar 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 Item Mat. ($) Labor ($) Sub. (8) Other ($) Start 0 0 0 3,490 1,500 1,500 2,500 0 2,000 3,750 1,150 18,560 600 12,340 1,000 4,800 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 8 OOOOO 4,000 3,750 3,000 1,650 4,000 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 24-Sep 28-Sep 3-Oct 8-Oct 9-Oct 11-Oct 2 OS 0 900 2,500 6,800 600 1,350 3000 2,500 5,000 0 2,000 0 1,250 0 3,000 200 0 8 OOOOO 8 2,300 0 1,000 2,070 2,650 3,870 500 220 0 Blinds Roofing Masonry Siding Rain Gutters Site Concrete Fencing Landscaping Supervision Temporary Utilities Trash Disposal Building Permit Cleanup 1,365 0 0 0 0 0 2,000 4,500 5,000 12-Oct 17-Aug 22-Aug 29-Aug 5-Sep 6-Sep 13-Sep 20-Sep 1-Jun 1-Jun 1-Jun 1-Jun 17-Oct 0 0 0 OOO 2,100 1,500 1,000 0 0 7 50 Total 39,815 23,160 67,490 4,600