What we've done
Some examples
Below are a couple simple examples of what we can do and how our solutions work. Note that we are not limited to just these examples. We can create custom solutions for any business or industry. Please contact us for a free quote and proof of concept specific to your needs.
Cash Flow Forecast
This example forecasts expenses and revenue out into the future and consolidates them into a cash flow by month. The model uses a 10 period s-curve to allocate budgeted items over time. It also takes actuals into consideration and revises the forecast in future months. The solution can scale up to many projects and the data can be saved off into different versions. Download the Excel file and try it for yourself.
Budget Adjustments
This example shows how Finance can easily gather monthly budget adjustments from project managers. An Excel template is sent out to the managers. They select the project and cost code, and then enter budget adjustments and comments. The data is aggregrated for Finance to review. Data is also saved off on a monthly basis for historical purposes.
Change Tracking
This example demonstrates how changes can be tracked on a weekly basis. Data is saved off every week. A report compares the previous week's data to the current week's data and highlights the changes.
