Using the Construction Program and the Contract Values provided in Attachment
A, prepare a cash flow forecast for this project. In your response, you must:
a) include a forecast of revenue and cost over time and be aligned with the Construction Program
b) provide a table showing the total revenue and cost amounts for each period, and
c) provide a chart showing the cumulative and periodic revenue and cost over time throughout the project.
\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{13}{|c|}{ Project Cost Forecast } \\ \hline \multirow{2}{*}{\begin{tabular}{|c|} Cost Code \\ 7ZD001 \\ \end{tabular}} & \multirow{2}{*}{\begin{tabular}{ll} & Description \\ Preliminaries \end{tabular}} & \multirow{2}{*}{\begin{tabular}{c} Quantity \\ 12 \\ \end{tabular}} & \multirow{2}{*}{moUOM} & \multicolumn{2}{|r|}{ Rate } & Original Budget & \multicolumn{2}{|c|}{ Cost to Date } & \multicolumn{2}{|c|}{ Cost to Complete } & \multicolumn{2}{|c|}{ Forecast Final Cos } \\ \hline & & & & $ & 65,217.39 & $782,608.70 & $ & - & $ & 65,217.39 & $ & 65,217.39 \\ \hline 7ZD002 & Design & 1 & Item & & 217,391.30 & $217,391.30 & $ & - & $ & 217,391.30 & $ & 217,391.30 \\ \hline 7ZD003 & Site Preparation (Earthworks, Site Clearing etc) & 10000 & m2 & $ & 4.35 & $43,478.26 & $ & - & $ & 4.35 & $ & 4.35 \\ \hline 7ZD004 & Foundations & 1 & Item & & 286,956.52 & $286,956.52 & $ & - & $ & 286,956.52 & $ & 286,956.52 \\ \hline 7ZD005 & Footings & 5000 & m2 & $ & 130.43 & $652,173.91 & $ & - & $ & 130.43 & $ & 130.43 \\ \hline 7ZD006 & External Walls and Glazing & 900 & m2 & $ & 182.61 & $164,347.83 & $ & - & $ & 182.61 & $ & 182.61 \\ \hline 7ZD007 & Roof & 5000 & m2 & $ & 130.43 & $652,173.91 & $ & - & $ & 130.43 & $ & 130.43 \\ \hline 7ZD008 & Internal Walls & 250 & linm & $ & 95.65 & $23,913.04 & $ & - & $ & 95.65 & $ & 95.65 \\ \hline 7ZD009 & Services & 1 & Item & & 130,434.78 & $130,434.78 & $ & - & $ & 130,434.78 & $ & 130,434.78 \\ \hline 7ZD010 & Floor Finishes & 5000 & m2 & $ & 43.48 & $217,391.30 & $ & - & $ & 43.48 & $ & 43.48 \\ \hline 7ZD011 & Commissioning & 1 & Item & & 130,434.78 & $130,434.78 & $ & - & $ & 130,434.78 & $ & 130,434.78 \\ \hline \end{tabular} Program ATTACHMENT A - TASK 1 \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{2}{|c|}{ Schedule 1 - Contract Sum } & & & & & \\ \hline \multicolumn{7}{|c|}{ All amounts exclude GST and are inclusive of profit and offsite overheads } \\ \hline Item & Description & Qty & UOM & & Rate & Total \\ \hline 1 & Preliminaries & 12 & mo & & 75,000.00 & $900,000.00 \\ \hline 2 & Design & 1 & Item & & 250,000.00 & $250,000.00 \\ \hline 3 & Site Preparation (Earthworks, Site Clearing etc) & 10000 & m2 & $ & 5.00 & $50,000.00 \\ \hline 4 & Foundations & 1 & Item & & 330,000.00 & $330,000.00 \\ \hline 5 & Footings & 5000 & m2 & $ & 150.00 & $750,000.00 \\ \hline 6 & External Walls and Glazing & 900 & m2 & $ & 210.00 & $189,000.00 \\ \hline 7 & Roof & 5000 & m2 & $ & 150.00 & $750,000.00 \\ \hline 8 & Internal Walls & 250 & linm & $ & 110.00 & $27,500.00 \\ \hline 9 & Services & 1 & Item & & 150,000.00 & $150,000.00 \\ \hline 10 & Floor Finishes & 5000 & m2 & $ & 50.00 & $250,000.00 \\ \hline \multirow[t]{2}{*}{11} & Commissioning & 1 & Item & & 150,000.00 & $150,000.00 \\ \hline & TOTAL & & & & & $3,796,500.00 \\ \hline \end{tabular}
