Consolidating???

[Guest]

Hi,

I have to set up a cash flow forecast sheet for 60 months.

The details of cash inflows and outflows come in from several projects.

Each project will have several account heads, and conversely, each account
head (over 50 of them) has several projects. The timing and volume of cash
flows for each project are obviously different.

Information on this worksheet needs to be summarised for top management, and
very detailed for the departmental managers.

Can anyone please suggest a model? How do I make it flexible enough to
accommodate a new project or new account head addition?

Thank you in advance

 

[Dave O]

Is it feasible to create a separate cash flow for each dept manager?
That way each manager could have all the excrutiating detail they need,
and the cash flow presented to upper management could be the summary of
each dept manager. (In fact, the dept manager's performance is
probably measured by their department's financial performance.)
Additionally, adding a new project would just be a matter of adding a
new row to that manager's cash flow; adding a new manager would be a
matter of adding a new tab.

Do-able?