The monthly outflow of each activity is shown below:

Note: cash ins are guessed/estimated

Additional, generate a Cash Flow Graph showing your monthly cash outflow (i.e., ignoring any cash ins), and provide a copy of it in your report. You are told by your project manager that the contract with the client allows for interim payments to be received according to the following schedule: The project manager wants you to develop a cashflow spreadsheet that lists the cash-outs - broken down by activity - and cash-ins for each month (**use weeks, if your project is shorter than 3 months!**). The spreadsheet shall show the cumulative cashflow values as well as the negative captim and the expected capital lockup associated with the project. The spreadsheet shall also include the cumulative cashflow as a graph. Assume a 10% profit margin. Clearly state any additional assumption you deem necessary to complete the calculations. Submit the spreadsheet as a separate file Excel file, but embed the cumulative cashflow graph from your spreadsheet in your report. Calculate and clearly state the maximum capital lockup (timing and value) and the total negative captim in your report