In this link is a WeTransfer PDF of my excel spreadsheet that I fill in each month to compare my actual realised performance for the month vs what I forecasted / expected before launching my venture late last year.https://ift.tt/PIFALfZ reference:- I buy pallets of boxes- I sell boxes (100 cubes in a box) in two shapes, pillars and rocks- White cells are estimations of calculations from estimations- Lite Purple cells are my inputs for actual results each month- Dark Purple cells are calculations made from actual results each month- some columns/rows are hidden for simplicity (e.g. breakdown of cogs etc.)What I like about this sheet:- I get a good comparison between expected/actual- Easy to input each monthWhat I don't like:- I want to be able to easily alter my expectations each month to have a more accurate forecast of how the business will perform. For example, I overestimated how many active clients I'd do business with, but its not easy to change those forecasts in any given month to reflect something closer to the actuals since they're calculated from original conditions at the launch of the business (and modelled over each month)Does anyone recommend any platforms to track a businesses performance over time? An all in one I guess for CRM, financials etc. see hubwealthy.com/wealthy
0 comments:
Post a Comment