please answer its urgent, fill out the chart please

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. Subcontractor'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). Month Direct Costs 3 Total Materials S1,500 $7,000 $4,500 $13,000 Labor 52,200 $700 53.000 55.900 Equipment SI,200 $1,700 1,200 54.100 Troject Overhead 52.100 $1,200 $1,400 $4,700 Sub Contractor $2,000 54.000 55.000 $11.000 59.000 $14.0 15.100 $38.700 Total Direct Costs Profit&Go Indirect Costs) BU Toner Money Received from Owner/GC Money Received from the owner Rent held by the owner Retention related by the owner Total Money Reerived Cashtu Payments made to suppliers, labor, and sub Paid for Materials Paid for Lab Paid to Equipment Supplier Paid to Project Overhead Paid to Sub Contractor Revell from Nab Contact Relation released to the Sun Total Payments (Chout) Nel Cash Flow at Month's end (Cash in-Cashout) Total cash gynerated 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 Dire 37 3 SU TIES) SK SION M Tra ST IS 100 HINI IN 1 | Prath Acatcatireate Money Karda M Hal T - Maa Cat is Tala ) Ca Tala Mari 1 2 3 4 Month Direct Costs Materials Labor Equipment Troject Overhead Sub Contacto $1.500 $2.200 $1,200 $2.100 $2,000 59,000 $7,000 $700 $1,700 SI: 200 $4,000 S14,600 $4,500 $3.000 $1,200 $1,400 55,000 $15,100 Totals $13,000 55.900 $4,100 $4,700 $11,000 SIA 700 + Total Direct Costs Profit &GOH (Indirect Costs) BUT owner Money Received from Owner/GC Money Received from the owner Retention held by the owner Retention released by the owner Tom Money Received (Cash In) Payments made to suppliers, labor, and sub Paid for Maletins Paid for Labor Paid to Equipment Supplier Paid to Project Overhead Paid to Sub Contractor Retention held from the Contractor Hertion related to the Sub Total Payments (Cashout Net Cash Flow at Month end (Cash in Cash out) Total cash generated at Month's cada her 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