The Cash Flow Planning template must clearly indicate the expected cash inflows and outflows along with the expected or scheduled date. Cash Flow template must also indicate the source or destination of the flow respectively along with the amount of the cash flow.
The template could also, specify the effect on the monthly or any other periodic balance as a result of this flow, in order to help managers plan better.
Part B Problem Solving
The overall project duration is 4.75 months.
Figure Expected Cumulative VAlue Forecast of the Project. (Numbers outisde of boxes indicate the dollar value of the expenses required for the sctivity. Retention Fees have been metioned separately)
The total amount must be paid over a period of 4 months, out of which the month of January (Total sum of $30,000) is expected to have the greatest sum of cash outflows, followed by January ($26,000) followed by February 2019 ($20,000). A Total of $80,000 in expenses while $4000 in retention fees are required at the minimum. Mark-up costs are not considered in this assessment.
The expected expenses are $84000 (including the retention Fees). Considering the mark up price, the total maximum expected expenses should be $92,400/-.
The maximum amount shall be required in expenses paid over a period of time between September 2018 and February 2019.
Hardin, B. (2016). Project Planning, Control, and Uncertainty Management. Published online https://www.vitalsource.com/products/wcs-project-planning-control-and-uncertainty-brad-hardin-v9781119313755: Wiley Custom select.