The GIM Period end consists of a series of tasks that calculate values and move costs through the system. The GIM tasks calculate all costs after the entity has been placed. There is an option to define the granularity of the period end process to the entity, house or pen level. The system also has the ability to define allocation definitions for administration and service departments to allocate the costs to the entities in the period. There are several allocation basis that may be used for the administration and services costs to provide added flexibility.
The following are the steps that must be completed and balanced prior to starting the period end process. This is the most important section of the implementation process as if the beginning balances are not accurate, the MTech period end process will not generate the correct data.
The following details are validated/entered in the month prior to the first period end. Any journal transactions should be entered on the last day of the period prior to the first period end to be generated in MTech. For example, if beginning to run period end in MTech on 01/01/2014, these transactions should be entered with a date of 12/31/2013. Period End tasks to review bird days and other costs will be generated for F2013-12.
The following details are outlined in this document.
The following are a list of items that can be reviewed to ensure that period end will run efficiently.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
The Preliminary Task requires the user to run period end tasks for clearing balances and validation. These tasks are run for the period prior to the first period being run in MTech. For example, if the first period in MTech is 01/2014, then these tasks will be run for period 12/2013.
The first step in the process is to enter the beginning entity balances. These balances are entered on the last day of the period prior to the first period being run in MTech.
There are two options available to enter inventory balances:
The Inventory Valuation Wizard is a tool to enter beginning balances for entities. When the process is completed, the result is a journal transaction that creates an adjusting entry to record the inventory balances for the entity.
Stage | Account | Product No | Comments |
Nursery |
|||
Debit | PIGGO-NUR-[OBJECT]-[ELEMENT]-IN | Not Required | Required for all nursery expenses |
Debit | PIGGO-INV-FEED-ING-IN | Feed Formula | Required if feed inventory quantity is entered |
Credit | SYS-GLNPOST-00000-00000-00000 | Not Required | Offset account |
Finisher |
|||
Debit | PIGGO-FIN-[OBJECT]-[ELEMENT]-IN | Not Required | Required for all finisher expenses |
Debit | PIGGO-INV-FEED-ING-IN | Feed Formula | Required if feed inventory quantity is entered |
Credit | SYS-GLNPOST-00000-00000-00000 | Not Required | Offset account |
Wean to Finish | |||
Debit | PIGGO-WTF-[OBJECT]-[ELEMENT]-IN | Not Required | Required for all wean-to-finish expenses |
Debit | PIGGO-INV-FEED-ING-IN | Feed Formula | Required if feed inventory quantity is entered |
Credit | SYS-GLNPOST-00000-00000-00000 | Not Required | Offset account |
There are two steps involved in implementing period end:
The configuration for period end is completed in the registry.
The following two items need to be defined if the Protein Cost Mode is set to Standard and Actual or Standard with Variance.
Allocation Definitions are created to allocated departmental and administration costs entities. Examples of such costs are service crews, cleanout and broiler administration. The Allocation Definition tool is flexible and has many pre-defined allocation basis.
This process defines the predecessor tasks that must be run so that costs are defined in the proper order. Predecessors are used to establish two parameters related to period end.
Predecessors can only be established on tasks that appear in the list prior to the task that requires the predecessor. Period end tasks are defined in Admin>Business>General>Period End>Task Definitions.
Once all of the above steps have been completed and opening balances are verified, the period end process can be completed. There are a series of tasks required. For each of the steps, the following need to occur before moving to the next task.
The following tasks are outlined in this document for the BIM module:
The purpose of this task is to review all transactions and data in the system to ensure that period end can be processed. It is important that this task is run to ensure that all required data is included in the period end process. Not running this task can result in inaccurate costing data. The process verifies the following:
This task is only generated if FMIM is being used and there are overhead allocations to be allocated to feed deliveries. The task will allocate any overhead to period deliveries and ending inventory at the feed mill. There is an option to allocate overheads from a summary account or allocate in detail. All overhead to be allocated must be defined in Admin>Business>General>Period End>FMIM Overhead Mappings.
Calculate task.
Generate report 900 FMIM OPS Allocation (Journal Trans Summary) to verify all required accounts are zero. The net of all accounts should be zero unless accounts are not mapped in FMIM Overhead Mapping. If the balance is not zero, verify that all accounts in the report have been mapped. If there are any accounts that are required to be mapped, add to the overhead mapping and re-run the task. Generate report again to ensure balance is zero.
Click on the required log to view the details from the FMIM OPS Allocation task:
Summary:
Credit | FDM-OPS-ALLOC-00000-OUT | Credit to allocate balance of defined overhead accounts |
Debit | BRLR-INV-FEED-MAN-IN | Debit to feed deliveries for manufacturing costs |
Debit | FDM-INV-FEED-MAN-IN | Debit to feed mill finished feed inventory for manufacturing costs |
Detail:
Credit | FDM-OPS-[Object]-[Element]-OUT | Credit to allocate balance of defined overhead accounts |
Debit | BRLR-INV-FEED-MAN-IN | Debit to feed deliveries for manufacturing costs |
Debit | FDM-INV-FEED-MAN-IN | Debit to feed mill finished feed inventory for manufacturing costs |
The purpose of this task is to review all BMTS transactions and data in the system to ensure that period end can be processed. It is important that this task is run to ensure that all required data is included in the period end process. Not running this task can result in inaccurate costing data. There are no journals created from this task.
This task generates overhead estimates for standard costs incurred for BIM, HIM and BRIM. The overhead estimates are created in General> Products> Prices> Overhead Estimates. The task will create standard journals to debit the standard overhead and credit the actual overhead so that it can be used to calculate variances in movement tasks. This task is not used when the Protein Cost Mode is set to Actual.
Trans Code | Account | Standard Cost Type | Variance Type | Comments |
Debit | BRLR-GROW-[OBJECT]-[ELEMENT]-IN | Standard Cost | Not Set | Records the standard overhead estimate calculated on the basis and rate in overhead estimated |
Credit | BRLR-GROW-[OBJECT]-[ELEMENT]-OUT | Actual Cost | Not Set | Removes the actual offset to the same account to be used in movements to calculate variances |
This task creates the standard journals for transfers. The journals are created based on rates entered in General>Product>Prices>Internal Prices>Animals. The standard journals for purchases is created at receiving. The standard journals for sales is created at shipment. This task is not used when the Protein Cost Mode is set to Actual.
Trans Code | Account | Standard Cost Type | Variance Type | Comments |
Credit | BRLR-GROW-[OBJECT]-[ELEMENT]-OUT | Standard Cost | Not Set | Records the standard cost transferred from grow to the plant |
Debit | PLANT-00000-INV-[ELEMENT]-IN | Standard Cost | Not Set | Records the standard cost transferred from grow to the plant |
This task calculates the hen days incurred by entities in the current fiscal period. The bird days will be calculated by entity and stage. These values are used to allocate costs at various stages in the period end process. There are no journals created from this task, however the Bird Days Inventory Log can be reviewed by selecting task and right-clicking to select option. If there are negative inventories or small quantities for entities, complete the following:
The Feed Consumption task calculates the feed consumption based on the parameters defined in Configuration related to feed. Feed consumption may be calculated based only on feed deliveries or based on feed deliveries and inventory. As well, depending on the option defined in Registry> Poultry> PMTS> Broilers> General>Feed Inventory Mode, the journal may be created by product (Mode=Feed Type or Formula No) or a single amount for all feed deliveries (Mode=Single Inventory). If there are amounts allocated to Cost Elements MAN, DEL, LDG, MED and/or MEDSPCL, then these amounts will also be allocated in this process.
The following tasks affect how feed consumption is calculated:
The following log is generated when the period end task is run. Click on the task and right-click to select the log:
Protein Cost Mode=Actual
Trans Code | Account | Standard Cost Type | Variance Type | Comments |
Credit | BRLR-INV-FEED-ING-OUT | Actual Cost | Not Set | Removes the feed consumed ingredient cost from feed inventory |
Credit | BRLR-INV-FEED-MAN-OUT | Actual Cost | Not Set | Removes the feed consumed manufacturing cost from feed inventory |
Debit | BRLR-[STAGE]-FEED-ING-IN | Actual Cost | Not Set | Feed consumption ingredient cost by entity stage |
Debit | BRLR-[STAGE]-FEED-MAN-IN | Actual Cost | Not Set | Feed consumption manufacturing cost by entity stage |
Protein Cost Mode=Standard and Actual Cost
Trans Code | Account | Standard Cost Type | Variance Type | Comments |
Credit | BRLR-INV-FEED-ING-OUT | Standard Cost | Not Set | Removes the standard feed consumed ingredient cost from feed inventory |
Debit/Credit | BRLR-INV-FEED-ING-OUT | Price Variance | Feed Production | Removes the feed consumed ingredient adjustment cost from feed inventory |
Credit | BRLR-INV-FEED-MAN-OUT | Standard Cost | Not Set | Removes the standard feed consumed manufacturing cost from feed inventory |
Debit/Credit | BRLR-INV-FEED-MAN-OUT | Price Variance | Feed Overhead | Removes the feed consumed manufacturing adjustment cost from feed inventory |
Debit | BRLR-[STAGE]-FEED-ING-IN | Standard Cost | Not Set | Standard feed consumption ingredient cost by entity stage |
Debit/Credit | BRLR-[STAGE]-FEED-ING-IN | Price Variance | Feed Production | Adjustment for feed consumption ingredient cost by entity stage |
Debit | BRLR-[STAGE]-FEED-MAN-IN | Standard Cost | Not Set | Standard feed consumption manufacturing cost by entity stage |
Debit/Credit | BRLR-[STAGE]-FEED-MAN-IN | Price Variance | Feed Overhead | Adjustment for Feed consumption manufacturing cost by entity stage |
BRIM Field Product allocations are used to allocate field products that have been delivered at the farm to the entity stage. There is an option to automatically create a usage when field products are received to the farm when farm inventory levels are not maintained. Otherwise, farm product inventory is maintained and field product allocations are only completed for those products that have been recorded as used in the period. If the usage is recorded to the farm, this task will allocate that cost to the stages on the farm in the period based on bird days. The allocation to the entity will occur in the farm to entity allocation task. If the field product was initially recorded to the entity, this task will record the allocation to the correct stage and no further transactions are recorded.
Note: This logic is currently being added to the BRIM Field Product Allocation task. The existing logic does not allocate costs to the BRIM stage as field product usage transactions must be coded to 'Farm' where the Farm to Entity task will allocate the amount to the stage. Documentation will be updated when the logic is available. The existing process until the change is made is to code all BRIM usages for inventory and non-inventory product as 'Farm' usages.
Protein Cost Mode=Actual
Trans Code | Account | Standard Cost Type | Variance Type | Comments |
Credit | BRLR-INV-SUPPLIES-[ELEMENT]-OUT | Actual Cost | Not Set | Credits the actual field product cost from product inventory |
Debit | BRLR-[STAGE]-SUPPLIES-[ELEMENT]-IN | Actual Cost | Not Set | Applies actual field product cost to entity stage |
Protein Cost Mode=Standard and Actual Cost (adjustment to actual will be recorded at movement transaction based on internal prices defined for the movement type)
Trans Code | Account | Standard Cost Type | Variance Type | Comments |
Credit | BRLR-INV-SUPPLIES-[ELEMENT]-OUT | Actual Cost | Not Set | Credits the actual field product cost from product inventory |
Debit | BRLR-[STAGE]-SUPPLIES-[ELEMENT]-IN | Actual Cost | Not Set | Applies actual field product cost to entity stage |
The Farm to Entity task allocates any costs that have been recorded at the farm level to the entities. For example, indirect costs for labor, utilities and maintenance may be directly recorded to the farm. This task will take those costs recorded to the farm using BRLR-OPS-[OBECT]-[ELELMENT]-[USER] and allocate the costs to the entities on the farm based on bird days. The method that these costs are allocated are dependent on the allocation type assigned to the specific account.
Non-Allocated – the cost is recorded on a specified date in the period. The expense will only be allocated to those entities that are active on the farm on that date. Any entity in the period that is not in existence on the transaction date will not be allocated any expense from a non-allocated account.
Allocated Daily – accounts with an allocation type specified as allocated daily will have those costs allocated to all entities in the period, regardless of the date that the transaction was entered.
Calculate the task.
Possible warning resulting from this task may be due to the fact that there are field products that have been used at the farm and there are no entities to allocate the operation or farm costs. If this warning is received, verify that the transactions were keyed to the correct farm. If correct, the amount will remain in the OPS account until the next entity is placed at the farm.
View the logs to review the data created by the task.
Generate report 13700 BRIM Farm to Entity Allocation (Journal Balance Report). The amount on this report should be zero unless the warning message has been received where the amounts will be allocated to entities in subsequent months.
Generate report PE058 - 13700 BRIM Farm to Entity Allocation (Entity Allocation by Stage) to view the amounts allocated to the entities.
The Farm to Entity Allocation task runs in two phases, therefore there is a log for each phase:
Farm OPS Allocation Log - allocates the OPS expenses to the stages at the farm in the period.
Farm to Entity Allocation Log - allocates the expenses from the farm to the entities in the period
Protein Cost Mode=Actual
Trans Code | Account | Standard Cost Type | Variance Type | Comments |
Credit | BRLR-OPS-[OBJECT]-[ELEMENT]-OUT | Actual Cost | Not Set | Credits the actual amount from the farm overhead account |
Debit | BRLR-[STAGE]-[OBJECT]-[ELEMENT]-IN | Actual Cost | Not Set | Applies actual amount to entity stage |
Protein Cost Mode=Standard and Actual Cost (adjustment to actual will be recorded at movement transaction based on internal prices defined for the movement type. Farm to Entity will inherit the Standard Cost Type and Variance Type of the source transaction.)
Trans Code | Account | Standard Cost Type | Variance Type | Comments |
Credit | BRLR-OPS-[OBJECT]-[ELEMENT]-OUT | Actual Cost | Not Set | Credits the actual amount from the farm overhead account |
Debit | BRLR-[STAGE]-[OBJECT]-[ELEMENT]-IN | Actual Cost | Not Set | Applies actual amount to entity stage |
BRIM Movements is most commonly used to calculate the cost of transferring birds from farm to plant, however if there are multiple stages or transfers to other farms in the process, the task will also move costs between entities. The process will also use the account type to determine how the costs are transferred.
Non-Allocated – the cost is recorded on a specified date in the period. The expense will only be allocated to those entities that are active on the farm on that date. Any entity in the period that is not in existence on the transaction date will not be allocated any expense from a non-allocated account.
Allocated Daily – accounts with an allocation type specified as allocated daily will have those costs allocated to all entities in the period, regardless of the date that the transaction was entered.
If Protein Cost Mode is set to Standard with Actual Cost or Standard Cost with Variance, the movements task will transfer values based on the rates entered in internal prices for the selected movement type. Differences between actual and standard will be recorded to either an adjustment account or a variance account depending on the mode.
Calculate the task.
Right-click and select Movements Log to view the details created by the task. To view the costs for a movement line, double-click on the detail line and the BRIM Movement Costs will be displayed. This tab displays the prior period costs, current period costs and costs moved. The details will also indicate if the cost is Allocated Daily or Non-Allocated.
Generate report PE042 - 13800 BRIM Movements (Broiler Movement Summary) ) to view the entities that were processed in the period.
Once the data is reconciled, PE025 Period End Broiler Inventory report can be generated. This report can be used for audit purposes to view the broiler inventory value for the end of the fiscal period.
Protein Cost Mode=Actual
Trans Code | Account | Standard Cost Type | Variance Type | Comments |
Credit | BRLR-GROW-[OBJECT]-[ELEMENT]-OUT | Actual Cost | Not Set | Credits the entity for the actual amount |
Debit | PLANT-00000-INV-[ELEMENT]-IN | Actual Cost | Not Set | Debits the plant for the actual amount |
Credit | BRLR-BROOD-[OBJECT]-[ELEMENT]-OUT | Actual Cost | Not Set | Credits the source entity for the actual amount |
Debit | BRLR-GROW-[OBJECT]-[ELEMENT]-IN | Actual Cost | Not Set | Debits the destination entity for the actual amount |
Protein Cost Mode=Standard and Actual Cost (adjustment to actual will be recorded based on internal prices defined for the movement type. All standard costs are recorded in the Standard Journals, therefore movements only records the variances.)
Trans Code | Account | Standard Cost Type | Variance Type | Comments |
Debit/Credit | BRLR-GROW-[OBJECT]-[ELEMENT]-OUT | Price Variance | Breeder Production | Records the adjustment standard to actual for breeder production |
Debit/Credit | BRLR-GROW-[OBJECT]-[ELEMENT]-OUT | Price Variance | Hatchery Overhead | Records the adjustment standard to actual for hatchery overhead |
Debit/Credit | BRLR-GROW-[OBJECT]-[ELEMENT]-OUT | Performance Variance | Breeder Production | Records the adjustment standard to standard for breeder production |
Debit/Credit | BRLR-GROW-[OBJECT]-[ELEMENT]-OUT | Performance Variance | Hatchery Production | Records the adjustment standard to standard for hatchery production |
Debit/Credit | BRLR-GROW-[OBJECT]-[ELEMENT]-OUT | Performance Variance | Hatchery Overhead | Records the adjustment standard to standard for hatchery overhead |
Debit/Credit | BRLR-GROW-[OBJECT]-[ELEMENT]-OUT | Performance Variance | Broiler Production | Records the adjustment standard to standard for broiler production |
Debit/Credit | PLANT-00000-INV-[ELEMENT]-IN | Price Variance | Broiler Production | Records the adjustment from standard to actual |
Debit/Credit | PLANT-00000-INV-[ELEMENT]-IN | Performance Variance | Broiler Production | Records the adjustment from standard to actual |
Debit/Credit | BRLR-BROOD-[OBJECT]-[ELEMENT]-OUT | Price Variance | Breeder Production | Records the adjustment standard to actual for breeder production |
Debit/Credit | BRLR-BROOD-[OBJECT]-[ELEMENT]-OUT | Price Variance | Hatchery Overhead | Records the adjustment standard to actual for hatchery overhead |
Debit/Credit | BRLR-BROOD-[OBJECT]-[ELEMENT]-OUT | Price Variance | Broiler Production | Records the adjustment standard to actual for broiler production |
Debit/Credit | BRLR-BROOD-[OBJECT]-[ELEMENT]-OUT | Performance Variance | Breeder Production | Records the adjustment standard to standard for breeder production |
Debit/Credit | BRLR-BROOD-[OBJECT]-[ELEMENT]-OUT | Performance Variance | Hatchery Production | Records the adjustment standard to standard for hatchery production |
Debit/Credit | BRLR-BROOD-[OBJECT]-[ELEMENT]-OUT | Performance Variance | Hatchery Overhead | Records the adjustment standard to standard for hatchery overhead |
Debit/Credit | BRLR-BROOD-[OBJECT]-[ELEMENT]-OUT | Performance Variance | Broiler Production | Records the adjustment standard to standard for broiler production |
Debit/Credit | BRLR-GROW-[OBJECT]-[ELEMENT]-IN | Price Variance | Breeder Production | Records the adjustment standard to actual for breeder production |
Debit/Credit | BRLR-GROW-[OBJECT]-[ELEMENT]-IN | Price Variance | Hatchery Overhead | Records the adjustment standard to actual for hatchery overhead |
Debit/Credit | BRLR-GROW-[OBJECT]-[ELEMENT]-IN | Price Variance | Broiler Production | Records the adjustment standard to actual for broiler production |
Debit/Credit | BRLR-GROW-[OBJECT]-[ELEMENT]-IN | Performance Variance | Breeder Production | Records the adjustment standard to standard for breeder production |
Debit/Credit | BRLR-GROW-[OBJECT]-[ELEMENT]-IN | Performance Variance | Hatchery Production | Records the adjustment standard to standard for hatchery production |
Debit/Credit | BRLR-GROW-[OBJECT]-[ELEMENT]-IN | Performance Variance | Hatchery Overhead | Records the adjustment standard to standard for hatchery overhead |
Debit/Credit | BRLR-GROW-[OBJECT]-[ELEMENT]-IN | Performance Variance | Broiler Production | Records the adjustment standard to standard for broiler production |