Improve your cash flow for HW-6 by applying all the following changes in one time: 1. The owner is releasing the retention in two stages, after completing 50% and 100% of the work. 2. Leveling the labor cost (same for all months) 3. Increasing subcontractor participation by moving $20,000/month from labor cost to subcontractor 4. Increase P&GOH to 15%. 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 and in which month? Determine the amount of cash that the construction company and its suppliers and subcontractors are providing to the project's owner

Improve your cash flow for HW- 6 by applying all the following changes in one time: 1. The owner is releasing the retention in two stages, after completing 50% and 100% of the work. 2. Leveling the labor cost (same for all months) 3. Increasing subcontractor participation by moving $20,000/ month from labor cost to subcontractor 4. Increase P&GOH to 15%. 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 and in which month? Determine the amount of cash that the construction company and its suppliers and subcontractors are providing to the project's owner Retention Rate from Owner Retention Hold for Subcontrctor P\&GOH 10% 11% 10% \begin{tabular}{lrrrr} Month & 1 & 2 & 3 & 4 \\ \hline Direct Costs & 34900 & 48900 & 73100 & 34000 \\ Materials & 30400 & 57300 & 80500 & 29200 \\ Labor & 13500 & 13500 & 13500 & 13500 \\ Equipment & 15000 & 15000 & 15000 & 15000 \\ Project overhead & 106800 & 123800 & 136400 & 55000 \\ \hline Subcontractor & & & & \end{tabular} Total Direct Costs P\&GOH (Indirect Costs) Bill to Owner (Total Direct\&Indirect) Money Received From Own Money Received from the owner Retention held by the owner Retention released by the owner Total Money Received (In Flow, Receipt) Payments Paid for Materials Paid for Labor Paid to Equipment Supplier Paid to Project Overhead Paid to SubContractor Retention held from Sub Contractor Retention released to the Sub Total Payments (Out Flow, Disbursment) Cash Flow before Payment (CF')