I’m working out cash flow planning for a project. For each phase of a project I have a start date and and end date, which covers several weeks.
What I’m trying to do is both plan teams workflow (which is fine with start and end dates) and calculate the costs.
For example say I have Team A of 4 people at £100/day working from 4 Jan to 12 Feb on one project then 15 Feb to 2 April on a new project. The first project brings in a sale of £500 on 2 March.
Meanwhile Team B of 5 people at £80/day starts on 26 January through to 5 March and again 8 March to 2 April, with a sale of £1,000 on 12 March.
So as I said in addition to using the Gantt chart for planning, which works really well in Coda, I want to include these costs. I tried creating a separate table with week numbers (eg week 1 is 4 January, week 2 is 11 Jan etc) to get weekly costs but I can only get the lookup to search whether the phase start date matches the table, not to get all the relevant weeks and associated costs for each phase as well as a weekly cost for all my teams.
The relevant columns I have in my main table are for start date, end date, team involved (A/B). I assume I’ll need a column for income (eg at the end of a phase of sales activity), but what else and what formula should I use to get a cash flow forecast, ideally one where I can insert things such as starting balance, loans, fixed costs such as rent and so on.