Given the following cost expenditures for a small ware$-$house project $($to include direct and indirect charges$),$ calculate the peak financial requirement, the average overdraft,and the ROR on invested money. Sketch a diagram of the overdraft profile. Assume $12\%$ markup Retainage $10\%$ throughout project Finance charge $=1\mathrm{.}5\%-$month Payments are billed at end of month and received one month later. TABLE $12\mathrm{.}3$ Overdraft Calculations with Mobilization Payment

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline & $\backslash$multicolumn$\{11\}\{|$c$|\}\{$Month$\}\backslash \backslash$

$\backslash$hline & $1$ & & $2$ & & $3$ & & $4$ & & $5$ & & $6\backslash \backslash$

$\backslash$hline Direct cost & $\backslash$$$25,000$ & & $\backslash$$$65,000$ & & $\backslash$$$75,000$ & & $\backslash$$$15,000$ & & & & $\backslash \backslash$

$\backslash$hline Indirect cost & $5,000$ & & $5,000$ & & $5,000$ & & $5,000$ & & & & $\backslash \backslash$

$\backslash$hline Subtotal & $30,000$ & & $70,000$ & & $80,000$ & & $20,000$ & & & & $\backslash \backslash$

$\backslash$hline Markup $(25\backslash \%)$ & $7,500$ & & $17,500$ & & $20,000$ & & $5,000$ & & & & $\backslash \backslash$

$\backslash$hline Total billed & $37,500$ & & $87,500$ & & $100,000$ & & $25,000$ & & & & $\backslash \backslash$

$\backslash$hline Retainage withheld $(10\backslash \%)$ & $3,750$ & & $8,750$ & & $0$ & & $0$ & & & & $\backslash \backslash$

$\backslash$hline Payment received & & $\backslash$$$20,000$ & & $\backslash$$$33,750$ & & $\backslash$$$78,750$ & & $\backslash$$$100,000$ & & $\backslash$$$17,500$ & $\backslash \backslash$

$\backslash$hline Total cost to date & $30,000$ & & $100,000$ & & $180,000$ & & $200,000$ & & $200,000$ & & $\backslash \backslash$

$\backslash$hline Total amount billed to date & $37,500$ & & $125,000$ & & $225,000$ & & $250,000$ & & $250,000$ & & $\backslash \backslash$

$\backslash$hline Total paid to date & & $\backslash$$$20,000$ & & $\backslash$$$53,750$ & & $\backslash$$$132,000$ & & $\backslash$$$232,500$ & & $\backslash$$$250,000$ & $\backslash \backslash$

$\backslash$hline Overdraft end of month & $30,000$ & & $80,300$ & & $127,353$ & & $69,877$ & & $\backslash ((29,424)^\{$a$\}\backslash )$ & & $\backslash ((46,924)^\{$a$\}\backslash )\backslash \backslash$

$\backslash$hline Interest on overdraft balance & $300$ & & $803$ & & $1,274$ & & $699$ & & $0$ & & $0\backslash \backslash$

$\backslash$hline Total amount financed & $\backslash$$$30,300$ & & $\backslash$$$81,103$ & & $\backslash$$$128,627$ & & $\backslash$$$70,576$ & & $\backslash ((29,424)\backslash )$ & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

$\backslash (\{\}^\{$a$\}\backslash )$ Parentheses indicate a positive balance.