My client, a start up with a lot of experience in their field, had identified an important gap in the market. Large sums of money were being invested, with very long payback periods, without access to effective performance tracking tools.
They designed a tool to cover the gap and asked me to create a demonstration system in preparation for generating interest and raising capital.
The resulting system imports the base data and generates monthly cost and revenue forecasts, taking into account seasonal variations, tax allowances and more.
The main management screen gives quick access to some key performance indicators.
Constraints can be defined, and potential investments can be checked against them.
Actual results can be compared against the projections.
Different heat maps show absolute or relative performance by state or county.
This was an eight month intensive project, resulting in a demo site which generated a lot of interest in the industry and allowed the client to achieve their first round of funding.