How stock values are calculated in the stockflow report.
The Stockflow report is a fantastic tool in MaiaGrazing.
Uses of the stockflow report:
-
Financial year reporting for your accountant
-
Point in time reporting of stock class or enterprise numbers
-
Anytime reporting to determine productivity per enterprise.
Accessing the stockflow report
-
Click on the 'Analytics Tab' to open the drop down. (1.)
-
Click on 'Stockflow Report' from the drop down list. (2.)
Filtering the report
The report can be filtered by either Enterprise or Stock Class.
-
Click on the drop down box under 'Report Filter'.
-
Select either 'Enterprise' or 'Stock Class' (3.)
-
Select the date to start the report from (4.)
-
Select the date to end the report (5.)
-
Click on 'Create Report' (6.).
Example Report
Below is an example report filtered to Stock Class for a financial year:
-
Opening Values are determined by calculating a weighted average of all the $ values given to each stock group within that stock class. (1) The weighted average is calculated by the percentage of animals that are at a particular value, for example if 60% of the animals in that stock class are valued at $1000 and 40% are valued at $900 then the value would be: ($1000 x 60%) + ($900 x 40%) = $960.00.
-
Closing Values are calculated the same way as the opening values, based on the values for each stock class on the closing date of the report. (2)
-
Purchase Values are also calculated using a weighted average for all animals purchased in that stock class for the reporting period selected. (3) For example if 50 steers are purchased at $900/head, 40 steers are purchased for $1200/head and 10 steers are purchased for $1100/head in the reporting period selected then the Purchase Value for the stock Class Steers would be calculated by: ($900 x 50%) + ($1200 x 40%) + ($1100 x 10%) = $1040/head.
-
Sales Values are calculated the same way as the purchase values, based on the values for each stock class sale during the report period. (4)
Access the mob management screen
-
Click on 'Operations'
-
Click on 'Livestock'
-
Click on 'Mob List'
-
Click on the name of the mob containing the stock class you want to update the values for.
Editing stock item values
-
Enter the date you wish to change the value of the stock class. (1.)
-
Hover over the 3 dots
to the right of the box (2.) & Select 'Edit'.
-
Enter the Rating/hd, weight and $/kg value for that particular stock group within the stock class. (4.). Alternatively if just adjusting the value, only edit the $/kg.
-
This will adjust the overall Mob value (5.) and the value for this stock class in the stockflow report.
-
Click on 'Save' (6.)
A pop up box will open asking if you want to carry forward these changes.
If you choose YES the changes made to this stock item will carry forward until a future change is entered.
If you choose NO these changes will only apply for the one day on the date chosen at the top of the screen.
-
Click on 'PROCEED'