Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Consolidating???
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 |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidating data from different workbooks | Excel Worksheet Functions | |||
how do you change pathways (links) when consolidating spreadsheet. | Excel Discussion (Misc queries) |