Figured's standard Milk Tracker has multiple columns that automatically calculates values for the budgets and forecasts.
Below is the breakdown of how those payments have been calculated.
Standard advance payment & this season payment
The Standard Advance Payment column is calculated by Production kgMS x Milk Price (this will always come from the Your Milk Price column unless left blank, in which case it will default to the Company Milk Price).
Then further across is This Season Payment, which is Standard Advance Payment + Further Payments.
Further payments, milk price increase, & capacity adjustment
First up is the milk price increase, which is calculating the adjusted payment you will receive for the milk prices increasing as the year progresses.
Milk price increase is calculated from Difference between this months milk price and last months milk price x Total historical milk production for the year.
Shown above that is written as -
- Milk price increase: $3.10 less $3.00 = $0.10 cents
- Total milk historical milk production: 1000 kgMS x 3 = 3000 kgMS
- 3000 kgMS x $0.10 cents = $300
This is then popped into the Further Payments column.
Next is the calculation on your Seasonal/Capacity Adjustment. The calculation for that is kgMS x Season Adjustment, which then flows through to your Further Payments column.
Deferred income & total payment
In the budget you have the option to manually enter Deferred Income or you can overflow it from the previous year manually. When working in the forecast these deferred payments will overflow automatically.
The final column of your milk tracker, Total Payment, is then the sum of This Season Payment (Standard Advance Payment + Further Payments) + Deferred Income.