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. (4 marks) b) provide a table showing the total revenue and cost amounts for each period; and (4 marks) c) provide a chart showing the cumulative and periodic revenue and cost over time throughout the project. (2 marks)

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}