please fill out the chart, its urgent

A construction company is negotiating on a construction project with a three-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 one month after they are received. The owner also holds 9% retention. Final payment is expected one month after completion of the project and will include payment of retention. Additionally. The construction company pays material suppliers, equipment vendors, and project overhead in full when it receives payment from the owner - pay when paid. The construction company pays subcontractors when it receives payment from the owner but withholds 11% retention-pay when paid. - Suboontractor's retention is paid in full one month after the completion of the project The company pays for labor weekly Indirect costs are 18% for the construction company The projected monthly direct costs are shown in the attached table. Complete the project cash flow table (must fill all green highlighted cells). 1 2 34 Month Direct Cous Materials SI SOC $7,000 $4.500 $13,000 Labor S2.2005700 53.000 $5.900 Equipment 1,200 $1,700 1.200 54.100 Project Overhead 2.100 $1,200 $1,400 54.700 Sub Contractor $2,000 $4,000 $3,000 $11.000 $9.000 514,600 IS. 100 N700 Total Direct Costs Profit & GOH (Intret Ceuts) Money Received from me Money Received from the owner Retention held by the Rot released by the owner Total Money Received (Cashfa) Payments made to suppliers, labor, and sub Paid for Materials Paid for Paid to Equipment Supplier Paid to Project Overhead Paid to Sub Contractor Retention held froni Sub Contractor Retention released to the Sun Total Payments (Cashout) Net Cash Flow at Month's end (Cash in Cashout) Total cash generated at Month's end (after payment is received from the owner) Cash needed for the project before payment is received from the owner Effective Cash needed for the project before payment is received from the owner Total Cash invested in the project before payment is received from the owner Month with max cash need and the amount: Total amount of cash needed for the project is tary HO ST 3 HE 33 SK SION 36 15 3 + |trati Aattaarate Mar MW Pl PL MC Cat ) C Talaic Mad use these instructions to fill in the chart. A construction company is negotiating on a construction project with a three-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 monthy bills one month after they are received. the owner also holds 9% retention. final payment is expected one month after completion of the project and will include retention. additionally, - the company pays material suppliers, equipment vendors, and project overhead in full when it receives payment from the owner (pay when paid) - the company pays subcontractors when i receives payment from the owner but withholds 11% retention (pay when paid) - subcontractors retention is paid in full one month after the completion of the project - the company pays for labor weekly - indirect costs are 18% for the company THE PROJECTED MONTHLY DIRECT COSTS ARE SHOWN IN THE ATTACHED TABLE. COMPLETE THE PROJECT CASH FLOW TABLE (MUST FILL ALL GREEN HIGHLIGHTED CELLS) ive uploaded 3 pictures of the table. A construction company is negotiating on a construction project with a three-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 one month after they are received. The owner also holds 9% retention. Final payment is expected one month after completion of the project and will include payment of retention. Additionally. The construction company pays material suppliers, equipment vendors, and project overhead in full when it receives payment from the owner - pay when paid. The construction company pays subcontractors when it receives payment from the owner but withholds 11% retention-pay when paid. - Suboontractor's retention is paid in full one month after the completion of the project The company pays for labor weekly Indirect costs are 18% for the construction company The projected monthly direct costs are shown in the attached table. Complete the project cash flow table (must fill all green highlighted cells). 1 2 34 Month Direct Cous Materials SI SOC $7,000 $4.500 $13,000 Labor S2.2005700 53.000 $5.900 Equipment 1,200 $1,700 1.200 54.100 Project Overhead 2.100 $1,200 $1,400 54.700 Sub Contractor $2,000 $4,000 $3,000 $11.000 $9.000 514,600 IS. 100 N700 Total Direct Costs Profit & GOH (Intret Ceuts) Money Received from me Money Received from the owner Retention held by the Rot released by the owner Total Money Received (Cashfa) Payments made to suppliers, labor, and sub Paid for Materials Paid for Paid to Equipment Supplier Paid to Project Overhead Paid to Sub Contractor Retention held froni Sub Contractor Retention released to the Sun Total Payments (Cashout) Net Cash Flow at Month's end (Cash in Cashout) Total cash generated at Month's end (after payment is received from the owner) Cash needed for the project before payment is received from the owner Effective Cash needed for the project before payment is received from the owner Total Cash invested in the project before payment is received from the owner Month with max cash need and the amount: Total amount of cash needed for the project is ! Month Direct Costs 1 1 3 4 Materia Labor Fones Project Overhead SCO $2200 $1,200 52.100 $2.000 57.000 5700 $1,200 51200 SCO S1400 S4 500 $8.000 $1,200 51400 Totals ST1000 $5.900 SC100 54,700 511.000 53,00 $15.10 Total Dirert Costs Profit&GOH (Indirect Costs) To owner Monty Received frem OwGC Money Received from the owne Retention held by the owner Retention released by the Total Money Received this) Payments made to suppliers, laborando Paid for Materials Pald for Labor Paid to Feanent Supplier Paid to Project Overhead Paid to Sub Contractor Retete from Sul Contractor Retention released to the Sab Total Payments Cashout) Net Cash Flow Month's (Cash Cashet) Total cash generated at Month's and after payment is received from the owner) Culmended for the project before payment is received from the owner Effective Cushneeded for the project before payment is received from the Total Cash invested in the project before payment is received from the Meath with a cash need and the amount Total amount of cash needed for the project is A construction company is negotiating on a construction project with a three-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 one month after they are received. The owner also holds 9% retention. Final payment is expected one month after completion of the project and will include payment of retention. Additionally. The construction company pays material suppliers, equipment vendors, and project overhead in full when it receives payment from the owner - pay when paid. The construction company pays subcontractors when it receives payment from the owner but withholds 11% retention-pay when paid. - Suboontractor's retention is paid in full one month after the completion of the project The company pays for labor weekly Indirect costs are 18% for the construction company The projected monthly direct costs are shown in the attached table. Complete the project cash flow table (must fill all green highlighted cells). 1 2 34 Month Direct Cous Materials SI SOC $7,000 $4.500 $13,000 Labor S2.2005700 53.000 $5.900 Equipment 1,200 $1,700 1.200 54.100 Project Overhead 2.100 $1,200 $1,400 54.700 Sub Contractor $2,000 $4,000 $3,000 $11.000 $9.000 514,600 IS. 100 N700 Total Direct Costs Profit & GOH (Intret Ceuts) Money Received from me Money Received from the owner Retention held by the Rot released by the owner Total Money Received (Cashfa) Payments made to suppliers, labor, and sub Paid for Materials Paid for Paid to Equipment Supplier Paid to Project Overhead Paid to Sub Contractor Retention held froni Sub Contractor Retention released to the Sun Total Payments (Cashout) Net Cash Flow at Month's end (Cash in Cashout) Total cash generated at Month's end (after payment is received from the owner) Cash needed for the project before payment is received from the owner Effective Cash needed for the project before payment is received from the owner Total Cash invested in the project before payment is received from the owner Month with max cash need and the amount: Total amount of cash needed for the project is tary HO ST 3 HE 33 SK SION 36 15 3 + |trati Aattaarate Mar MW Pl PL MC Cat ) C Talaic Mad use these instructions to fill in the chart. A construction company is negotiating on a construction project with a three-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 monthy bills one month after they are received. the owner also holds 9% retention. final payment is expected one month after completion of the project and will include retention. additionally, - the company pays material suppliers, equipment vendors, and project overhead in full when it receives payment from the owner (pay when paid) - the company pays subcontractors when i receives payment from the owner but withholds 11% retention (pay when paid) - subcontractors retention is paid in full one month after the completion of the project - the company pays for labor weekly - indirect costs are 18% for the company THE PROJECTED MONTHLY DIRECT COSTS ARE SHOWN IN THE ATTACHED TABLE. COMPLETE THE PROJECT CASH FLOW TABLE (MUST FILL ALL GREEN HIGHLIGHTED CELLS) ive uploaded 3 pictures of the table. A construction company is negotiating on a construction project with a three-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 one month after they are received. The owner also holds 9% retention. Final payment is expected one month after completion of the project and will include payment of retention. Additionally. The construction company pays material suppliers, equipment vendors, and project overhead in full when it receives payment from the owner - pay when paid. The construction company pays subcontractors when it receives payment from the owner but withholds 11% retention-pay when paid. - Suboontractor's retention is paid in full one month after the completion of the project The company pays for labor weekly Indirect costs are 18% for the construction company The projected monthly direct costs are shown in the attached table. Complete the project cash flow table (must fill all green highlighted cells). 1 2 34 Month Direct Cous Materials SI SOC $7,000 $4.500 $13,000 Labor S2.2005700 53.000 $5.900 Equipment 1,200 $1,700 1.200 54.100 Project Overhead 2.100 $1,200 $1,400 54.700 Sub Contractor $2,000 $4,000 $3,000 $11.000 $9.000 514,600 IS. 100 N700 Total Direct Costs Profit & GOH (Intret Ceuts) Money Received from me Money Received from the owner Retention held by the Rot released by the owner Total Money Received (Cashfa) Payments made to suppliers, labor, and sub Paid for Materials Paid for Paid to Equipment Supplier Paid to Project Overhead Paid to Sub Contractor Retention held froni Sub Contractor Retention released to the Sun Total Payments (Cashout) Net Cash Flow at Month's end (Cash in Cashout) Total cash generated at Month's end (after payment is received from the owner) Cash needed for the project before payment is received from the owner Effective Cash needed for the project before payment is received from the owner Total Cash invested in the project before payment is received from the owner Month with max cash need and the amount: Total amount of cash needed for the project is ! Month Direct Costs 1 1 3 4 Materia Labor Fones Project Overhead SCO $2200 $1,200 52.100 $2.000 57.000 5700 $1,200 51200 SCO S1400 S4 500 $8.000 $1,200 51400 Totals ST1000 $5.900 SC100 54,700 511.000 53,00 $15.10 Total Dirert Costs Profit&GOH (Indirect Costs) To owner Monty Received frem OwGC Money Received from the owne Retention held by the owner Retention released by the Total Money Received this) Payments made to suppliers, laborando Paid for Materials Pald for Labor Paid to Feanent Supplier Paid to Project Overhead Paid to Sub Contractor Retete from Sul Contractor Retention released to the Sab Total Payments Cashout) Net Cash Flow Month's (Cash Cashet) Total cash generated at Month's and after payment is received from the owner) Culmended for the project before payment is received from the owner Effective Cushneeded for the project before payment is received from the Total Cash invested in the project before payment is received from the Meath with a cash need and the amount Total amount of cash needed for the project is