Please fill out the template below:

9. A construction company is negotiating on a construction project with a six-month duration. 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 15 days after they are received. The owner also holds 10% retention. Final payment is expected one month after completion of the project and includes payment of 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% from the subcontractor's payment. The construction company pays for labor weekly. The projected monthly material, labor, and subcontractor costs are shown in Table 12-10. Determine the monthly cash flows and the total cash generated by the project at the end of each month and just before each payment is received from the project's owner. What is the maximum amount of cash invested by the company during the completion of the project? Table 12-10 Data for Problem 90 Costs Month Materials ($) Labor ($) Sub. ($) Bill to Owner ($) 1 33,700 25,300 35,600 101,200 2 54,100 42,400 125,200 237,200 3 69.600 77,900 93,600 258,000 4 17,200 17,900 105,700 150,700 5 14,700 21,900 60.400 103,800 6 11,600 12,700 35,600 64,100 Total 200,900 198,100 456,100 915,000 B C D E F G I L M 2 0 P 1 2 3 4 5 6 7 8 9 10 11 12 A 1 Retention 2 Month Retention is Released 3 Payment in_days 4 5 Month 6 Bill to Owner 7 8 Materials 9 Labor 10 Subcontractor 11 Total Costs 12 13 P&O 14 15 Receipts 16 17 Payments 18 Materials 19 Labor 20 Subcontractor 21 Total Payments 22 23 Cash Flow Before Payment 24 25 Total Cash Before Payment 26 27 Cash Flow at Month's end 28 29 Total Cash at Month's End 30 31 $0 $0 SO $o $0 SO SO