As farming conditions change, it’s important to keep a close eye on your business, so Figured gives you an adjustable forecast to work with which we call the planning grid.
Livestock and production tracker income and expenses
All livestock and production income information (actuals and forecasts) is entered and edited via each of your production trackers ****and automatically pulls through into your planning grid.
NOTE: These production figures will be uneditable in your planning grid because they originate from your production trackers.
Other income and expenses
All other income and expenses will be entered in your planning grid. When editing, ensure your global settings allow you to enter a forecast in the months you wish. This is commonly used through selecting Actuals + Forecast and Actuals to Last Month.
This example was taken in August 21, therefore Actuals to Last Month shows Actuals up to July 21 and then the rest of the year available for forecasting.
To take a look at a full years forecast, set actuals to the last month of the previous season year, or actuals to none.
Fast track adding in your transactions
There’s a variety of ways to enter values into your plan, depending on whether the amounts are fixed, or regularly change e.g. they fluctuate.
Fluctuate – If you’re budgeting for random or fluctuating amounts, then enter these manually into each cell.
Fixed – If you’re looking to copy or spread a fixed amount across the year, then you'd use the function as per below.
Click into a cell, enter a value at the bottom, and copy or spread it across the year.
You can also proportionally spread according to your last years locked budget / annual plan using a distribution curve like below.
Copy allows you to have a particular value copied across all cells in the same row in the time frame of your choosing
Spread allows for a yearly budget spread across each cell in the entire row
Adjust By % means you can enter a value on the starting cell and you can have it increase by a certain percentage in the following cells
Calculations in the planning grid
The planning grid supports entering calculations into each cell - we allow subtraction, addition, multiplication, division, and brackets.
All you'll need to do is click into your cell and enter your formula!
Dynamic planning using the auto calculation allows for planning expenses and/or income as percentages of a particular account, as a dollar per hectare, dollar per Milk Production unit or stock unit allowing you to plan more efficiently and accurately. More on that here.
Resetting an account for an entire year
If you want to reset any account for the year, click on the green arrow and set a fixed amount back to $0 per month.
Enter values as a positive - or a negative?
For your budgets and forecasts you need to enter your $ values against these accounts as either positives or negatives, depending on the account type and if you're wanting to reflect an increase or decrease in bank account balance.
For video tutorials on the planning grid check out your YouTube playlist here.