Retention held by the owner $=$ x$\%$ of bill to owner $8\%92\mathrm{.}00\%$ Gross Profit Margin $20\%$

Retention held from the sub $=$ y$\%$ of sub amount $11\%89\mathrm{.}00\%$

Sub, material, equipment, and other costs are pay when paid; Labor is paid weekly

You will send the invoice to owner at the end of the month; you will receive payment one month after the invoice is sent.

All previously held Retention will be released two months after the project is over both for the GC and the Sub contractor.

Month $123456$

Direct Costs Totals

Materials $$2,000$ $$7,000$ $$4,500$ $$2,000$ $$15,500$

Labor $$700$ $$800$ $$3,000$ $$12,00$ $$5,700$

Equipment $$2,000$ $$1,700$ $$1,200$ $$500$ $$5,400$

Project Overhead $$2,100$ $$1,200$ $$1,100$ $$600$ $$5,000$

Sub Contractor $$3,000$ $$5,000$ $$7,000$ $$2,700$ $$17,700$

Total Direct Costs $$9,800$ $$15,700$ $$16,800$ $$7,000$ $$49,300$

Profit &GOH $($Indirect Costs$)$

Bill To owner

Money Received from Owner$/$GC $($CASH IN$)$

Money Received from the owner

Retention held by the owner

Retention released by the owner

Total Money Received $($Cash In$)$

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 SubContractor

Retention held from Sub Contractor

Retention released to the Sub

Total Payments $($Cash out$)$

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 owner$)$

Cash Invested

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 $=$

$\backslash$table$[[$Retention held by the owner $=$x$\%$ of bill to owner,$8\%,92\mathrm{.}00\%,$Gross Profit Margin,$20\%,,],[\backslash$table$[[$You will send the invoice to owner at the end of the month; you will receive payment one month after the invoice is sent.$],[$All previously held Retention will be released two months after the project is over both for the GC and the Sub contractor.$]]],[$Equipment$,$$$2,000,$$$1,700,$$$1,200,$$$500,,,$$$5,400],[$Profit &GOH $($Indirect Costs$)],[$Retention released by the owner$],[,,,,,,,],[$Retention held from Sub Contractor$],[$Retention released to the Sub$],[$Total Payments $($Cash out$)],[$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$]]$