A construction company is negotiating on a construction project with a four-month duration. On the last day of each month the construction compe one month after they are received. The owner holds 7 % retention. Retention is paid twice during the project: at the end of month 3 (includes retent Additionally following information is provided. 35% of Material is paid at the time of delivery. Rest 65% of material is pay when paid. 45% of project overhead is paid at the time of delivery or when the cost in incurred. Rest 55% of project overhond is pay when puid. Equipment suppliers work under pay when paid. The construction company pays subcontractors when it receives payment from the owner but withholds 11% retention. SC retention is release the end of month 6 (any retention that was not released earlier). The company pays for labor weekly. Indirect costs are 21% for the construction company. The projected monthly direct costs are shown in the attached table. Complete the project cash flow table. 2 Direet Ceuts Materials Labor Equipment Project Overbread Sub-Contractor 5800 $1,000 $5,000 $1,200 $4,000 $2,500 $500 $5,000 $500 $8,000 $1,500 $2,000 $1,200 $1,100 $2,000 $2,000 $1,200 $500 $600 $2,700 Total Direct Costa Profit AGOH (Indirect Costs) BATE Meesy Received from Owen GC (CASH IN) Money Received from the owner Retetlen held by the owner Retentis released by the owner Total Money Received (Cash In) Payments made to suppliers, labor, and (CASH OUT) Paid for Materials Paid for Labor Paid to Equipment Supplier Paid to Project Overhead Paid to Subcontractor 2 3 rials abor ment rhead ractor $800 $1,000 $5,000 $1,200 $4,000 $2,500 $500 $5,000 S500 $8,000 $1,500 $2,000 $1,200 $1,100 $2,000 $2,000 $1,200 $500 5600 $2,700 Totals 56,800 $4,700 $11.700 $3,400 $16,700 Money Received front OWNER/GC (CASH IN) Payments made to suppliers, labor, and veb (CASH OUT) Retention released by the owner Total Money Received (Cash la) Payments made to suppliers, labor, and sub (CASH OUT) Paid for Materials Paid for Labor Paid to Equipment Supplier Paid to Project Overhead Paid to Sul Contractor Retention held from Sub Contractor Retention released to the Sub Total Payments (Cashout) Cash Flow Net Cash Flow at Month's end (Cash in-Cash out) Total cash generated at Month's end (after payment is received from the owner) Cask levested . for the project before payment is received from the owner Effective Cash needed for the project before payment is received from the owner Total Cask levested in the project before payment is received from the owner Month with a cash seed and the amount Total amount of cash needed for the projects Total Money Received (Cash In) 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 (Cash out) Net Cash Flow at Month's end (Cash in - Cash out) 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 = A construction company is negotiating on a construction project with a four-month duration. On the last day of each month the construction compe one month after they are received. The owner holds 7 % retention. Retention is paid twice during the project: at the end of month 3 (includes retent Additionally following information is provided. 35% of Material is paid at the time of delivery. Rest 65% of material is pay when paid. 45% of project overhead is paid at the time of delivery or when the cost in incurred. Rest 55% of project overhond is pay when puid. Equipment suppliers work under pay when paid. The construction company pays subcontractors when it receives payment from the owner but withholds 11% retention. SC retention is release the end of month 6 (any retention that was not released earlier). The company pays for labor weekly. Indirect costs are 21% for the construction company. The projected monthly direct costs are shown in the attached table. Complete the project cash flow table. 2 Direet Ceuts Materials Labor Equipment Project Overbread Sub-Contractor 5800 $1,000 $5,000 $1,200 $4,000 $2,500 $500 $5,000 $500 $8,000 $1,500 $2,000 $1,200 $1,100 $2,000 $2,000 $1,200 $500 $600 $2,700 Total Direct Costa Profit AGOH (Indirect Costs) BATE Meesy Received from Owen GC (CASH IN) Money Received from the owner Retetlen held by the owner Retentis released by the owner Total Money Received (Cash In) Payments made to suppliers, labor, and (CASH OUT) Paid for Materials Paid for Labor Paid to Equipment Supplier Paid to Project Overhead Paid to Subcontractor 2 3 rials abor ment rhead ractor $800 $1,000 $5,000 $1,200 $4,000 $2,500 $500 $5,000 S500 $8,000 $1,500 $2,000 $1,200 $1,100 $2,000 $2,000 $1,200 $500 5600 $2,700 Totals 56,800 $4,700 $11.700 $3,400 $16,700 Money Received front OWNER/GC (CASH IN) Payments made to suppliers, labor, and veb (CASH OUT) Retention released by the owner Total Money Received (Cash la) Payments made to suppliers, labor, and sub (CASH OUT) Paid for Materials Paid for Labor Paid to Equipment Supplier Paid to Project Overhead Paid to Sul Contractor Retention held from Sub Contractor Retention released to the Sub Total Payments (Cashout) Cash Flow Net Cash Flow at Month's end (Cash in-Cash out) Total cash generated at Month's end (after payment is received from the owner) Cask levested . for the project before payment is received from the owner Effective Cash needed for the project before payment is received from the owner Total Cask levested in the project before payment is received from the owner Month with a cash seed and the amount Total amount of cash needed for the projects Total Money Received (Cash In) 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 (Cash out) Net Cash Flow at Month's end (Cash in - Cash out) 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 =