Logo.png

support

Sale Optimization

 

Overview

This screen was designed to help model projected revenue for a group of animals based on:

  • Sale to different abattoirs (get current schedules before launching screen)

  • Different Store vs. Prime cutoff weights

  • Selling today vs. a date in the future

To do this, there are three primary steps: 

  1. Define the subset of animals to sell by filtering the database by common animal attributes. 

  2. Entering abattoir schedule details and modeling revenue of different prime - store cutoff weights

  3. Entering cost and growth details to model impacts of sale timing

 

Filters

The first step to modeling different sale scenarios is to identify the subset of animals to sell using filters. To do this:

1. Select Animal Type ( Cattle, Deer, Sheep) - this will customize the list of available filters to the Animal Type (e.g. only wool filters for sheep)

2. Once this is selected:

  • A default Status filter will be added the essentially filters for live animals currently part of the farm - i.e. Sold or dead animals are filtered out

  • A count animals with individual records with that Animal Type will appear to the left of the " View Animal List" button. This count will be updated after additional filters are added.

​3. Now that you have selected the Animal Type, the ADD FILTER button is active. To select filters associated with the subset of animals that you would like to analyze, select ADD FILTER. This will present you a list of available filters for the Animal Type selected. 

​4. Find the filter that you would like to apply and select it (limited to one at a time). This will activate the NEXT button on the bottom right.

5. The next screens will vary based on the filter selected. The options are as follows:

  • Selections

    • Single filter selection (limited to one selection) - e.g. Animal Type - Cattle, Deer, etc.

    • Multiple filter selections (multiple selections allowed) - e.g. Birth Rank - Single, Twin, etc.

    • Multiple filter selections - Current (most recent entry for animals) - Group - 2018 Ewe Lambs - Current

    • Multiple filter selections with a date range - e.g. Condition Score - 2,3 or 4 between 1/1/17 and 1/1/18

  • Dates

    • Date Range - e.g. Birth Date between 1/1/17 and 1/1/18​

  • Text

    • Single text entry - e.g. DNA ID - 12345abcd

    • Text entry - Current (most recent entry for animals) - e.g. Comment - "Bad leg"

    • Text entry  with a date range - e.g. Comment - "Bad leg" between 1/1/17 and 1/1/18

  • Numbers

    • Exact number match - e.g. EID - 9821234567890123​ or Breeder Farm 12340408

    • Number range - most recent entry - e.g. Last entry weight 100 - 200kg

    • Number range with a date range - e.g. Weight between 100 - 200kg between 1/1/17 - 1/1/18

6. Review - this screen provides a summary of the filters selected to confirm before applying the filter with the COMPLETE button

7. Once you have selected a filter and COMPLETE, the system will:

  • Present the filter details below the header in the top section (in order that they were created)

  • Apply the filter to the database and update the count of animals that meet ALL defined filter criteria

8. To edit a filter, simply touch the filter details row.

9. To delete a filter, simply long press on the filter details row​ and confirm

10. The RESET FILTERS button will remove all previously added filters. If any analysis entries have been made they will be removed.

 

View Animal List

To ensure that the filtered subset of animals is correct before modeling different sale scenarios, the View Animal List button will provide you a listing of standard details for animals in the filtered subset. To do this:

1. Select the VIEW ANIMAL LIST button

2. This will present the standard view which contains (left to right)

  • System animal number - This is just a reference order number for this screen - it is not part of the actual animal data

  • VID - The VID (Visual Identification number) for the animal (if available)

  • VID Year - the VID Year associated with the VID (will be available if VID is)

  • Tag Color - The color of the tag (if available - this is optional for VID tags)

  • Weight - The most recent Weight (kg) recorded for the animal

  • Wt Gain/Day - The weight gain per day in grams between the last two weight entries for the animal

  • Total Weight Gain - The total weight gain (kg) for the animal between the 1st and last recorded weight entry

3. If you would like to see the full record of any animal in the list, just select any part of the row to the left of the vertical separation line which will bring you to the full animal record. From there, just select the back arrow to return to the list.

4. The CHANGE COLUMNS button enables the ability to change the data elements shown for all animals in the list. Simply select the button and select or deselect any of the data element listed. After you are finished, select NEXT to review and the COMPLETE button once satisfied with your selections.

5. This will change the headers in the list to correspond to the columns you have selected (NOTE: the 4 left hand columns will always remain). 

6. If you have selected more than 4 columns, the additional columns will be available to the right of the screen. To access these, simply swipe from right to left from the right part of the screen (right of the vertical column separator) to view the additional columns.

7. The CSV EXPORT button enables the ability to create a CSV file of the data shown on the screen and share the file via any of the methods setup on your Android tablet. Simply select CSV EXPORT and choose the application you would like to use to share the file. This will open the selected application and will place the file in the application for sharing.

Notes:

  • To ensure less than 2 second list creation time, we have limited the number of animal shown on the list to the first 200 of the filtered subset sorted by VID Year first (high to low) and Visual Tag # second (low to high). If you choose CSV EXPORT, all records and selected data will be exported, regardless of animal count. If the total records count is greater than 200, you may experience a short delay while the tablet is processing the file.

  • Data shown in View Animal List is the most recent entry for the animal for any specified data element. If a data element has more than one entry, only the most recent will be shown - e.g. weight, condition score, etc. 

 

 Prime vs. Store Analysis

Once the filtered subset of animals is confirmed using the tools above, you are ready to model different sale scenarios. The first step is to model different prime vs. store cutoff weights vs. abattoir schedule and optima this. To do this:

1. Select the expand (down) arrow next to the ANALYZE button in the Prime v.s Store Analysis section. This will show you the abattoir schedule entries that are required (above the along with the analysis points that will be calculated. 

2. Select the ANALYZE button in this section. This will open a wizard for you to enter the following abattoir schedule details:

  • Prime Maximum Carcass Weight

  • Prime Minimum Carcass Weight 

  • Store Maximum Average Weight (live weight)

  • Store Minimum Average Weight (live weight)

  • Prime $/kg (carcass weight)

  • Estimated Yield %

  • Store $/kg (live weight)

  • Store Minimum Weight (live weight)

  • Review - presents a summary of entries and COMPLETE button

3. Once the entries are made and COMPLETE button selected, the system will calculate the following items based on the entries with the Prime - Store cutoff weight defaulted to the Store Minimum Weight:​

  • < Store Count - number of animals in the filtered list that are below the Store Minimum Weight

  • > Prime Count - number of animals in the filtered list that are above the Prime Maximum Carcass Weight (based on live weight * yield %)

  • Store Count - number of store animals based on the current Prime - Store cutoff weight

  • Prime Count - number of prime animals based on the current Prime - Store cutoff weight

  • Store Average Weight - the average weight of the Store animals based on the current Prime - Store cutoff weight

  • Prime Average Weight - the average weight of the Prime animals based on the current Prime - Store cutoff weight

  • Store $ - the revenue associated with the Store animals based on the current Prime - Store cutoff weight

  • Prime $ - the revenue associated with the Prime animals based on the current Prime - Store cutoff weight

4. Model different Prime - Store cutoff weights using the slider tool. Simply touch the dot on the slider and move left or right and the tool will dynamically update the calculation below it. Move back and forth until the total of Store $ and Prime $ is optimal. 

Notes:

  • The slider tool will default to the Store Min Av Wt. The low end of the range will be the Store Min Wt and the high end will be Prime Max CWT/Yield %

  • To see the total revenue of Store & Prime animals, please expand the Sell vs. Keep Analysis and you will see this under Sell Total Revenue

  • A pending improvement is to highlight the Store Av Wt in bold red if it falls below the minimum limit. This currently must be checked manually.

  • The modeling is a relatively intensive system calculation. Depending on the number of animals, it may take some time to update the calculations.

 Sell vs. Keep Analysis

If it is an option to keep animals longer, you can use this section to determine whether this is projected to be revenue positive or negative relative to sale revenue. To do this:

1. Select the expand (down) arrow next to the ANALYZE button in the Sell vs. Keep Analysis section. This will show you the required entries along with the analysis points that will be calculated.

 

2. Select the ANALYZE button in this section. This will open a wizard for you to enter the following required entries:

  • Feed $/Animal/Day - the actual cost to feed the listed animals per day. If you have enough feed and it is not needed for other animals, this can be set to $0

  • Wt Gain/Animal/Day - the anticipated average weight gain per day (kg) per animal if they are kept

  • Mgmnt $/Day - the incremental management costs per day to manage the listed animals. Like feed costs, this can be set to $0 if no incremental costs will be incurred

  • #of Days - the number of days that you would like to model. This is typically set based on the amount of projected extra feed available.

  • Review - presents a summary of entries and COMPLETE button

3. Once the entries are made and COMPLETE button selected, the system will calculate the same items as the Prime vs. Store section but will adjust these based on the growth in animals if they are kept. Depending on the inputs, this may push some < Store animals into Store and some Prime animals into > Prime. The financial impacts of this will be shown under the Keep Gain/Loss cell. 

4. Model different Prime - Store cutoff weights using the slider tool. This works in the same way as outlined above except now it will update the calculations for both sections. Move this back and forth until you have optimized the sale revenue based on realistic Keep inputs while ensuring that you meet the Store Minimum Average Weight limit.

 

 Save As Group

The SAVE AS A GROUP button can be selected at any point to add an ID Group name to the individual animal records in the filtered list. This can be used later to quickly identify sale animals if they are combined with non sale animals. To do this:

1. Select the SAVE AS GROUP button (active once a filter has been added)

2. Select a Group name from the list (limited to ID Groups associated with the Animal Type selected in filters)

3. Review and select COMPLETE

4. This will add the Group selected to the individual animal record for all animals in the filtered subset

Notes:

  • After the analysis is complete, you may want to adjust the filters to exclude animals that are < Store or > Prime and then Save As A Group

  • You may also want to note the Prime - Store cutoff weight and use this later in Configured Events as drafting criteria