Through the new Expense Transfer Reconciliation form, AeLive has the ability to reconcile outstanding expenses left from discrepancies in head counts during the process of transferring animals from one group to another. 

Image RemovedImage Added 

Once all expenses, feed deliveries, ending feed inventory and/or feed returns are entered into the system and all transfer-outs are finalized, select the Reconcile button for the selected flock and perform the steps shown in this document.

At the end of the group the starting number of head minus mortalities and transfer outs may not equal zero. Because of this, remaining dollars that belong to those birds (that really do not exist because of count discrepancies) remain in the flock. Through the reconciliation form, AeLive will give the user the option of applying those remaining dollars to the last transfer or allocate Once a flock is finalized by selecting the Finalize button on the transfer out form the remaining dollars will be allocated among the transfers based on the percentage of the dollars originally transferred.  The reconcile form shows where those dollars went.  When you click on the reconcile form this will retrigger the expense transfer process to ensure that all costs have been distributed.  More information on the business rules of the expense transfer process can be found here.

This article describes how to use this form with the example of a pullet flock transferring into two different commercial egg laying houses.

After entering all transfer outs from a pullet flock to a layer flock, select the “Finalize” button on the bottom left of the form. The finalize button will move the flock from active status to settlement status. When the flock is in a status of “Settlement,” users are allowed to enter any additional expenses, feed deliveries, ending feed inventory and/or feed returns against that flock.

The Finalize button creates a clear stop date for feed consumption, allowing for accurate feed consumption calculations for transfer-outs in AeLive.  Clicking this button tells AeLive that the animals are done moving and it is time to reconcile the numbers. AeLive will reconcile against all transfers marked to “Transfer Expenses”, as displayed below.

  Image Added Image Removed  Image Added

In the example above, the “On-Hand” count indicates that there are 310 birds remaining at the end of the flock.  This is a discrepancy with the bird count at some point (bad mortality record, incorrect starting count, etc.).  At this point, the best number is the count of birds transferred. 

The 310 birds may or may not have existed, however at the end of the flock what really matters is that all of the dollars get transferred.  All of the birds are gone but because of a small discrepancy in count something needs to be done with the dollars that belong to those 310 birds.

The “Reconciliation” form, found in the main ribbon bar and context menu, allows users to choose one of two options. The first is to update the dollars of those remaining birds to the “Last” transfer and the other will update the dollars to “All” transfersfinalize transfer out button will change the in house flock amount to zero and costs will be allocated to the other existing transfers.  The reconcile form will show you exactly how much each placement received.  If there are remaining costs on the reconcile form, that means the flock has not yet been finalized.  If there are any differences this usually means that all of the expenses did not transfer and you may want to check your transfer outs.

Select the flock and click the Reconcile form button:

 Image RemovedImage Added

The following form displays:

  Image RemovedImage Added

The Reconciliation form has two sections, a top half and a bottom half:

• The top half, “Transfers Out (with Expense Transfers Configurations” Transfer Configurations)” displays the transfers currently entered for the flock, the amount of birds transferred, the cost transferred and the cost per head.  It will also show you the remaining costs left before flock finalization if a flock has not been finalized yet.
• The bottom half, “Remaining” displays what is remaining in the flock.

If no changes are to be made to the head counts of the existing transfers, what should be done with the remaining $923.05 (Cost per Head multiplied by the Head Count or the Cost Transferable minus the Cost Transferred). 

Update Last

“Update Last” will take the remaining dollars and apply those dollars to the last transfer. Upon save, the total cost of the transfer that occurred on 5/7/2011 would increase from $507,680.86 to $508,603.91. The Cost Transferable and the Cost Transferred now match.

 Image Removed
 

Update All

“Update All” will take the remaining dollars and apply them to all transfers allocating dollars based on the total cost of the original dollars transferred. In this case the first transfer would receive close to 49% of the remaining cost and the second transfer would receive roughly 51%.

The allocation is based off of dollars and not birds because of the effect of feed consumed in expense transfers. In the above transfers, the second transfer had dollars transferred based on a per bird cost of $2.98/bird because those birds consumed more feed than the first set of birds since they remained in the pullet barn for an additional five days.

Image Removed 

• Transfer results.  This shows each expense and how much of those expenses each placement received and the date the flock received each expense.  This also includes consumption costs.

It always figures out what to transfer by taking the remaining amount * the percent transferred.

Before a flock is finalized, we create a record representing all birds that haven’t transferred, we sort the transfers by date and put the remaining at the end. We loop through all transfers including the remaining birds, giving each a chunk that should add up to 100% the cost of the expense.

When the flock is finalized we stop making the remaining record. We use the same calculation to keep dividing up the expense. All transfers that are not behind the accounting close date get a cut of the expense based off of their percent transferred, while remaining get none.

Some procedures to highlight that should occur when dealing with multiple transferred and feed consumed are the following:

1. There must be an ending feed inventory or a feed return at the end of the flock.
2. Multiple transfers will receive the same amount of feed consumed unless an ending feed inventory is entered on each day that a transfer exists.
3. The feed consumed will not calculate correctly for the existing portion of the flock unless an actual starting amount of feed for the remaining birds is present.

Aeros LIVE User Manual