BIM Period End Implementation

The BIM Period end consists of a series of tasks that calculate values and move costs through the system. 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.

• Cost Flow
• Pre-Implementation Steps
• Implementation

BIM Cost Flow

Pre-Implementation Steps

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.

• Data Review
• Preliminary Tasks
• Entity Balances
• Enter Inventory Quantities

Data Review

The following are a list of items that can be reviewed to ensure that period end will run efficiently.

1. Ensure that all Cost Centers are assigned to a farm or facility with the exception of Admin cost centers. Period end will not process if there are unassigned cost centers.
2. In Chart of Accounts, verify that for every manual account that is created, there is an account created with the following User Accounts

 

IN

OUT

 

3. Verify that the following transactions have 'Final Farm Pickup' flag selected. If there is no final pickup transaction, select the last transaction for each entity and unpost the transaction.

 

BMTS>Movements>Transfers BMTS>Transactions>Processing BMTS>Transactions>Order Shipments (if used to sell spent breeders)

 

4. Ensure that the following transactions are posted.

 

Chick Placements	Capitalizations
Chick Receivings	Processing Transactions
Field Transactions	Order Shipments
Feed Deliveries	Order Invoices
Feed Transfers	Product Usages

 

5. Ensure that the fiscal periods are set up in Admin>Business>General>Period End>Fiscal Calendar. Months and weeks should be set up.
6. Amortization tables are set up in Admin>Business>Poultry>BIM/LIM>Amortizations. If applicable, amortization tables assigned to Entities. This is only required if the amortization tables are not product specific or specific to an entity.

Preliminary Tasks

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.

1. Run Task 7000 B-BIM Hen Days. If there are any entities with negative inventory quantities or small quantities remaining, complete the following steps:
1. Unpost the final transfer or final processing transaction
2. Select the Final Farm Pickup flag in the transaction
3. Post the transaction
4. Re-run Task 7000 B-BIM Hen Days
5. Validate data
2. Run Task 7500 B-BIM Feed Consumption.
1. Go to General>Transactions>Journals
2. Make sure that the following fields appear in the index:
1. Trans Date - filter set to <= last day of period prior to first period end being run in MTech.
2. Cost Center No
3. Complex Entity No
4. Complex Account No - filtered for 'contains FDCONS'
5. Product No
6. Relative Amount
7. Relative Units
8. Post Reversed - filtered for unchecked
9. Void - filtered for unchecked
3. Export data to Excel.
4. In Excel, insert pivot table and group data based on Cost Center, Complex Account No, Complex Entity No, Product No. This will be the base for the journal to clear the balances.
5. Enter journal transaction in MTech dated for last day of prior period. From the Excel data, credit any debit amounts and debit any credit amounts. This journal must be entered by Complex Entity No and Product No to clear all amounts. Amount and Units must be entered. Note that if any entities are in Closed status, the status must be changed to Inactive in BMTS>Master Data>Entities before the transaction can be created.
6. In General>Transactions>Journals, filter data as outlined in Step #2. Verify that the balance of the Relative Amount and Relative Units columns equal '0.00'.
7. Post journal transactions.
   
3. In General>Transactions>Journals, filter data as outlined below. Verify that the balance of the Relative Amount column equals '0.00' for all entities.
1. Trans Date - filter set to <= last day of period prior to first period end being run in MTech.
2. Cost Center No
3. Complex Entity No
4. Complex Account No - filtered for 'begins with BRDR'
5. Relative Amount
6. Post Reversed - filtered for unchecked
7. Void - filtered for unchecked

Entity Balances

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:

• Inventory Valuation Wizard - only available in versions 7.24+. Wizard is used to automatically balance entities based on existing values in the system and the user entering the current balance.
• Manual - required for versions prior to v7.24. User manually clears and enters balances for entities.

Inventory Valuation Wizard

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.

1. In General>Period End>Inventory Valuation>Accounts, select BIM/LIM and define all accounts required for all stages (BROOD, GROW, CAPHEN, LAY).
2. In General>Period End>Inventory Valuation>BMTS>BIM, select Entities.
3. Select
4. Select the fiscal period prior to the first fiscal period that will be run in MTech. For example, if starting MTech costing on 01/01/2014, select period ending 12/31/2013.
5. Click 'Next'.
6. In the 'Select Entities' screen, filter for the required entities and click on the 'Selected' flag to select the entities.
7. The accounts defined in General>Period End>Inventory Valuation>Accounts>BIM/LIM will default to the 'Entities and Accounts' screen with the current balance in MTech for the selected period.
8. Select the line for the required entity. The bottom grid will display the Current Balance for the selected entity
9. Enter the Actual Balance for each required account for the selected entity. The balance will be displayed for each account.
10. Click 'Next'.
11. A preliminary journal transaction will be displayed for the required adjustment by account and entity.
12. Once the journal has been reviewed, click 'Finish' to create the journal transaction.
13. The process will create a posted transaction.
14. Costs can be validated using the following options:
1. BIM>Master Data>Entities by selecting the Costs tab.
2. General>Transactions>Journals by filtering the journal index for the required details by cost center and entity.
3. General>Transactions>Financial Trial Balance by selecting the fiscal period and filtering for the required Cost Center and/or Entity No.
15. If any further changes are required, the transaction must be un-posted and corrected.
16. Transaction must be posted again for journals to be reflected in Entities.

Manual

1. Go to General>Transactions>Journals
2. Make sure that the following fields appear in the index:
1. Trans Date - filter set to <= last day of period prior to first period end being run in MTech.
2. Cost Center No
3. Complex Entity No
4. Complex Account No - filtered for 'begins with BRDR'
5. Relative Amount
6. Post Reversed - filtered for unchecked
7. Void - filtered for unchecked
3. Export data to Excel.
4. In Excel, insert pivot table and group data based on Cost Center, Complex Account No, Complex Entity No. This will be the base for the journal to clear the balances.
5. Enter journal transaction in MTech dated for last day of prior period. From the Excel data, credit any debit amounts and debit any credit amounts.
6. In General>Transactions>Journals, filter data as outlined in Step #2. Verify that the balance of the Relative Amount column equals '0.00'.
7. Post journal transactions.
8. Create journal transaction to enter period end inventory balances for each entity and account. When entering feed consumption amounts, the data needs to be entered according to the Feed Inventory Mode defined in Registry>Poultry>PMTS>Broiler Breeder>General.  The journal needs to be created for every account for the stage (BROOD, CAPHEN, LAY). Journals are only required for the LAY stage if there is ending farm egg inventory.

 

Stage	Account	Product No	Comments
Brood
Debit	BRDR-BROOD-[OBJECT]-[ELEMENT]-IN	Not Required	Required for all brood expenses
Debit	BRDR-INV-FEED-ING-IN	Feed Formula	Required if feed inventory quantity is entered
Credit	SYS-GLNPOST-00000-00000-00000	Not Required	Offset account
Capitalized
Debit	BRDR-CAPHEN-INV-BRDRFEMALE-IN	Not Required	Total capitalized cost
Credit	BBRDR-CAPHEN-ACMDEPR-BRDRFEMALE-IN	Not Required	Total accumulated depreciation
Credit	SYS-GLNPOST-00000-00000-00000	Not Required	Offset account
Lay (only required if farm egg inventory exists)
Debit	BRDR-LAY-INV-EGGS-IN	Not Required	Egg inventory amount **
Debit	BRDR-INV-FEED-ING-IN	Feed Formula	Required if feed inventory quantity is entered
Credit	SYS-GLNPOST-00000-00000-00000	Not Required	Offset account
** BRDR-LAY expenses can also be entered in detail by account if available

 

9. Post journal transactions.
10. Costs can be validated using the following options:
1. BIM>Master Data>Entities by selecting the Costs tab.
2. General>Transactions>Journals by filtering the journal index for the required details by cost center and entity.
3. General>Transactions>Financial Trial Balance by selecting the fiscal period and filtering for the required Cost Center and/or Entity No.

Enter Inventory Quantities

1. In BIM>Transactions>Field>Brood, enter the ending feed inventory. Formula Type or Formula No may need to be entered depending on the Feed Inventory Mode defined in Registry>Poultry>PMTS>Broiler Breeder>General.
2. In BIM>Transactions>Field>Lay:
1. Enter the ending feed inventory. Formula Type or Formula No may need to be entered depending on the Feed Inventory Mode defined in Registry>Poultry>PMTS>Broiler Breeder>General.
2. Enter the ending farm egg inventory.
3. Post field transactions.
4. Go to BIM>Master Data>Entities, select the Trans by Age tab and verify that the feed and egg inventory values are correct. Alternatively, the following reports can be run to validate data for the last date of the prior period.
1. BIM004>Breeder Field Transaction Report (Brood-Grow)>Field Trans Feed
2. BIM005>Breeder Field Transaction Report (Lay)>Field Trans Feed
3. BIM005>Breeder Field Transaction Report (Lay)>Field Trans Eggs
5. If any of the data is not correct, unpost the transaction, fix the data and post the transaction.

Implementation

There are two steps involved in implementing period end:

• Configuration
• Configuration - Standard Costs
• Allocation Definitions
• Define Predecessor Tasks
• Period End Tasks

Configuration

The configuration for period end is completed in the registry.

1. The registry is located in Admin>System>Registry>Poultry.
2. Select System>General>Protein Cost Mode and select the applicable cost mode:
1. Actual Cost - transfers are recorded based on the internal price if defined. All transfer costs are reversed at period end and calculated based on the actual cost.
2. Standard and Actual - transfers are recorded based in the internal price. Period end will create cost adjustments from standard to actual. The standard and adjustment flow through inventory to record the final product at standard with adjustment to actual. Additional configuration is required in Configuration-Standard Costs.
3. Select System>Period End and review the following settings:
1. Future Date Limit - indicates how many days in the future transactions can be entered.
2. Period End Tasks Company Mode - select if the period end tasks are run by company. If the option is not selected, all tasks for all companies will be generated.
3. Period End Mode - available modes are:
1. Monthly - tasks are run based on monthly fiscal periods.
2. Weekly with Estimates - tasks are run weekly with estimates. Estimates are reversed when the monthly task is run to calculate actual monthly data.
3. Weekly - period end tasks are run on a weekly basis. There will not be any monthly tasks run.
4. Select Poultry>Broiler Breeder>Period End and review the following settings:
1. BIM Farm Egg Room Mode - options are 'Use Farm Egg Room' where eggs are accounted for at the farm, including adjustments, disposals and other transactions and transferred to the hatchery or 'Direct Hatchery Deliveries' where eggs are delivered directly to the hatchery egg room.
2. Module Chick Cost Mode - cost of chicks is calculated by hatchery or the cost is calculated for all hatcheries within a division.
3. Combine Sex Separate Farm Allocations - if farms are defined as sex-separated, selecting this option will allocate overhead costs to both sexes on the farm. Otherwise BRDR will only be allocated to female entities and BRDRM will only be allocated to male entities.
4. Eggs Disposed Valuation Mode - if using Farm Egg Room mode, this option determines how the disposed eggs are accounted for. 'Flow Through Inventory' leaves the cost of the disposed eggs to the hatch eggs. The result will be a higher hatch egg cost. 'Charge off to Current Period' will expense the eggs to a variance account as a period expense and not allocate the cost to hatch eggs.
5. Eggs sold Valuation Mode - if using Farm Egg Room mode, this option determines how the sold eggs are accounted for. 'Flow Through Inventory' leaves the cost of the sold eggs to the hatch eggs. The result will be a higher hatch egg cost. 'Charge off to Current Period' will expense the sold eggs to cost of goods sold as a period expense and not allocate the cost to hatch eggs.
6. End of Lay Variance Mode - determines where the gain/loss on a spent breeder entity is allocated when the Final Farm Pickup flag is selected on the processing or order shipment transaction.
1. Egg Cost - expense will be allocated to BRDR-LAY-GAINLOSS-BRDRFEMALE-IN and allocated to the egg cost for the period. If there are no eggs produced, the cost will be allocated to all eggs in the hatchery for the period.
2. System Variance Account - allocates the gain/loss expense to SYS-GLPOST-GAINLOSS-BRDRFEMALE-IN as a period cost. Costs will not be allocated to egg cost.
3. Plant - allocates the gain/loss expense to PLANT-00000-SYS-BRDRFEMALE-IN as a period cost. External plants will be coded to SYS-GLPOST-GAINLOSS-BRDRFEMALE-IN as a period cost. In both cases, costs will not be allocated to egg cost.
7. Farm to Entity Feed Consumed Allocation Mode - determines if feed consumed costs are allocated based on hen days or feed consumed units entered in Field Transactions.
8. Feed Consumed Shrink Mode - this option is only used when Feed Consumption Valuation Unit Type is set to 'Delivery and Inventories with Shrink'. 'Flow Through Inventory' leaves the cost of the shrink with the feed consumption. 'Charge off to Current Period' will expense the shrink to a variance account as a period expense and not allocate the cost to feed consumed.
9. Feed Consumption Valuation Unit Type - determines how feed consumption is calculated:
1. Deliveries Only - feed consumption is calculated using accumulated feed deliveries only. Feed inventories will be ignored.
2. Deliveries and Inventories - feed consumption is calculated using beginning inventory adding feed deliveries less ending inventory.
3. Deliveries and Inventories with Shrink - feed consumption is calculated using beginning inventory adding feed deliveries less ending inventory. The derived feed consumption is then calculated based on Field Transactions>Feed Consumed with the difference being accounted for based on the Feed Consumed Shrink Mode.
4. Field Trans Accrual - the feed consumption will be accrued based on the values entered in Field Transaction>Feed Consumed and the Feed Inventory Valuation Mode defined in Registry>Growout>Global. Period end will reverse the accrual journals and record the feed consumption based on beginning inventory adding feed deliveries less ending inventory.
5. Field Trans - the feed consumption will be calculated based on the values entered in Field Transaction>Feed Consumed and the Feed Inventory Valuation Mode defined in Registry>Growout>Global. The period end feed consumption task will not be generated when this mode is selected.
10. Maximum Cost Center Threads - determines how many cost centers will be processed concurrently in the period end tasks. The default value is '5'. Modifying this value will affect the period end processing time.
11. Maximum Sub Threads - determines how many farms within a cost center will be processed concurrently in the period end tasks. The default value is '5'. Modifying this value will affect the period end processing time.
12. Movement Allocation Mode - determines how allocation logic when Chart of Accounts>Allocation Type is set to Allocated Daily:
1. Animal Days - period units/dollars are weighted to each day on the basis of daily animal inventory.
2. Entity Days - period units/dollars are weighted equally to each day the entity is on the premises.
3. Per Animal - period units/dollars are weighted unequally through the period so that each animal in inventory for any duration in the period consumes an equal amount.
13. Spiking Male Costs Mode -
1. Capitalize Spiking Male Costs - costs will be allocated to the capitalized value of the entity that the males are transferred to.
2. Expense Spiking Male Costs - period costs will be allocated to the lay entities. The spike males must be in dedicated stud farms and in the same cost center as the lay entities.
14. Period End Entity Granularity - indicates the granularity that period end will use to calculate costs. Options are Entity, House or Pen.
15. Pullet Sales Mode - determines where the revenue for pullet sales is coded. Options are 'Revenue to Inventory' where the revenue goes to BRDR-BROOD-INV-BRDRFEMALE-SLS to offest incurred brood costs and reduce capitalized costs or 'Revenue to Sales and Inventory to COGS' which will use the default revenue and cost of sales accounts defined on the product.
16. Use Farm Feed Inventories - determines if feed inventory is derived from physical inventories entered in BIM>Transactions>Feed Inventories>Physical Inventory or the inventory entered in BIM Field Transactions.
5. Select Poultry>Hatchery Period End (All Hatcheries) and review the following settings:
1. By Product Costing Mode - this option is only used when Protein Cost Mode=Actual Cost. Standard cost based on internal price will be used for the other cost modes. Options are:
1. ByProducts Transferred at Zero Cost - all byproducts will be transferred with no cost assigned.
2. ByProducts Transferred Using Previous Month Broiler Cost - all byproducts will be transferred based on the calculated previous month broiler cost.
3. Regraded ByProducts at Saleable Cost - regraded byproducts are transferred at calculated cost of a saleable chick. Non-regraded by products are transferred at zero cost.
2. Farm Egg Inventory Mode - determines if egg inventory is based on Farm Egg Room Inventory or Field Transactions.
3. HIM Egg Transfers Sequence Mode - determines the sequence used to transfer eggs between hatcheries:
1. Auto-Sequence - eggs may be transferred between any hatchery, but can only be transferred once in the period.
2. Manual Sequence - eggs are only transferred based on the hatcheries assigned in Admin>Business>General>Definitions>Facilities>Hatcheries.
4. HIM/EPS Costing Mode - determines the flow of costs in the period end process. Options are FIFO, Average Cost (inventory losses charged to usage), Average Cost Retain Losses (retain inventory losses to current inventory).
5. Maximum Cost Center Threads - determines how many cost centers will be processed concurrently in the period end tasks. The default value is '5'. Modifying this value will affect the period end processing time.
6. Maximum Sub Threads - determines how many farms or entities within a cost center will be processed concurrently in the period end tasks. The default value is '5'. Modifying this value will affect the period end processing time.

Configuration - Standard Costs

The following two items need to be defined if the Protein Cost Mode is set to Standard and Actual or Standard with Variance.

1. In General>Products>Prices>Internal Prices>Animals, define the standard rates for each required movement type.
2. Define all other standard prices for products in General>Products>Prices>Internal Prices.
3. Create Overhead Estimates for all farms and facilities used in the BIM period end process.

Allocation Definitions

Allocation Definitions are created to allocated departmental and administration costs entities. Examples of such costs are service crews, cleanout and breeder administration. The Allocation Definition tool is flexible and has many pre-defined allocation basis.

1. Create a list of all required allocation definitions where costs are allocated to entities.
2. In Admin>Business>General>Period End>Allocation Definitions, create all of the required allocations. Generally, BMTS>BIM allocation definitions should be numbered between 7001 and 7499 to ensure that all costs are allocated before the system defined tasks are run.

Define Predecessor Tasks

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.

• Identify that the task must be run prior to another task that contains relevant details
• Establish the rule that if the predecessor task is re-run, the journals for all assigned tasks are deleted and must be re-calculated.

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.

1. Select Admin>Business>Period End>Task Definitions
2. Click on the to expose the list of tasks available to set as a predecessor.
3. Click to select the required predecessor tasks.
4. Click to save the Task Definition list.

Period End Tasks

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.

1. Right-click and calculate task.
2. If errors occur, the error log will appear. The error log can also be viewed by right-clicking and selecting 'View Error Log'.
3. Fix any errors.
4. Right-click and calculate task.
5. Review journals if journals are created from task by selecting the task and right-clicking to select Journals.
6. Review task log for accuracy of data. Task logs are available by clicking on task and selecting the required log. Some tasks have multiple logs.

** Note: In the BIM tasks, there are references to specific system reports for the B-BIM module basic tasks. If a system report is not available for a specific module, the report can be duplicated and modified as required.

The following tasks are outlined in this document for the BIM module:

Global Pre-Run Data Checks

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:

• Validate cost centers are assigned to facilities
• Global Transactions are posted - Sales and Purchase transactions
• Identify any accounts that do not have an account defined with the OUT user account.

FMIM OPS Allocation

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.

1. Calculate task.

2. 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:

• FMIM OPS Allocation Log

• FMIM OPS Allocation Detail Log

Summary:

Detail:

BMTS Pre-Run Data Checks

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.

BMTS Overhead Estimates

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.

BMTS Standard Journals

This task creates the standard journals for transfers, capitalization, transfers to plant and spent breeder journals. The journals are created based on rates entered in General>Product>Prices>Internal Prices>Animals. The standard journals for purchases is created at receiving. With the exception of spent breeders, the standard journals for sales is created at shipment. This task is not used when the Protein Cost Mode is set to Actual.

B-BIM Hen Days

This task calculates the hen days incurred by entities in the current fiscal period. The bird days will be calculated by sex 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 7000 and right-clicking to select option.

1. Run task.
2. Generate report PE048 - 7000 B-BIM Hen Days for the period.
3. Review the data for accuracy. If there are negative inventories or small quantities for entities, complete the following:
1. Unpost the final transfer or final processing transaction
2. Select the Final Farm Pickup flag in the transaction
3. Post the transaction
4. Re-run Task 7000 B-BIM Hen Days
5. Validate data

B-BIM Feed Consumption

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>Broiler Breeder>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:

• Registry>Poultry>Broiler Breeder>General>Feed Inventory Mode - determines if the feed type, feed formula or all feed.
• Registry>Growout>Global>Feed Inventory Valuation Mode - determines if the feed formula is valued based on average cost or last delivery price.
• Registry>Poultry>Broiler Breeder>Period End>Feed Consumption Valuation Unit Type - determines how feed consumption is calculated.

1. Calculate the feed consumption task.
2. When complete, right-click on the feed consumption task and select Feed Consumption Log.
3. Verify the per unit values for the ending inventory and unadjusted amounts. The Unadjusted Amount represents the value of feed delivered to entities that have not yet been placed. These amounts will remain in inventory until the next period when the entity is placed.
4. Run PE046 - Period End Breeder Feed Inventory Report for the end of the period.
5. Validate that the value on the feed inventory report to the BIM Feed Consumption Log. The value on the feed inventory report should equal the total of the Period End Inventory Value + Unadjusted Amount from the Feed Consumption Log. If the values do not balance compare the two sources to find the differences and review the details for each entity with a difference to determine the issue.
6. Once the sources are balanced, the PE046 - Period End Breeder Feed Inventory report or PE053 - 7500 B-BIM Feed Consumed (Feed Consumption Summary) report can be used as an audit report for the feed inventory valuation.

The following log is generated when the period end task is run. Click on the task and right-click to select the log:

• BIM Feed Consumption Log

Protein Cost Mode=Actual

Protein Cost Mode=Standard and Actual Cost

B-BIM Field Product Allocations

BIM 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.

1. Calculate task.

2. 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 product usage costs. If this warning is received, verify that the transactions was keyed to the correct farm. If correct, the amount will remain in the product inventory account until the next entity is placed at the farm.

3. Inventory usage can be reviewed for the period by generating report PE055 - 7600 B-BIM Field Product Allocation (Breeder Product Usage Summary). This report will display all usages to the farm and entity INV account for the period. Review report for accuracy. This report can be run at any time during the period.

4. After the allocation task has been run, generate the report 7600 B-BIM Field Product Allocation (Breeder Field Product Inventory Summary) for the end of the period. This report will display the amount remaining in inventory for the farm or entity. This should typically be zero unless the warning has been received that there are cost on a farm that cannot be allocated.

5. To view the costs allocated to the entity and stage for the period, generate PE056 - 7600 B-BIM Field Product Allocation (Entity Allocation by Stage). This report will display the amounts allocated to entities in the period.

Protein Cost Mode=Actual

Protein Cost Mode=Standard and Actual Cost (adjustment to actual w ill be recorded at movement transaction based on internal prices defined for the movement type)

B-BIM Farm to Entity Allocations

The Farm to Entity task allocates any costs that have been recorded at the farm level to the stages and 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 BRDR-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.

1. Calculate the task.

2. 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.

3. View the logs to review the data created by the task.

4. Generate report 7700 B-BIM 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.

5. Generate report PE058 - 7700 B-BIM 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

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.)

B-BIM Movements-[Generation]-Brood

BIM Movements calculate the cost of the transfer for brood to lay, or for multi-stage operations, from brood to grow.  There is a task for each generation. If the transfer is brood to grow, the stage will change from brood to grow. In the transfer from brood to lay, the process credits each brood account for the source entity and debits the brood account for the destination entity. The stage at the destination will remain as brood until the entity is capitalized. If the transfer is brood to grow, the task will credit each brood account for the source entity and debit the grow account for the destination entity.

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.

1. Calculate the task.

2. 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 BIM 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.

   Non-Allocated - the costs are allocated to the entity based on the transaction date. For example, chick cost would be a  non-allocated cost as it is not allocated to all entities on the farm in the period.

   Allocated Daily - amounts are summed for the month and then prorated to each day of the month based on either Entity Days or Animal Days depending on a registry switch

3. Generate report PE028 - 10300 B-BIM Movements Brood Parent (Brood Movement Summary) to view the entities that were moved in the period.

4. Generate report PE027 - 10300 B-BIM Movements Brood Parent (Breeder Brood Transfer Out Summary) to view the entities moved out by account.

The following log is generated when the period end task is run. Click on the task and right-click to select the log:

• BIM Movements Log

Protein Cost Mode=Actual

Protein Cost Mode=Standard and Actual Cost (adjustment to actual will be recorded based on internal prices defined for the movement type.)

B-BIM Capitalizations

The capitalization task is based on the capitalizations transactions that are entered for the period. The process moves the entity costs from the brood or grow stage to the capitalization account.

1. Calculate task.

2. Right-click and view the details for the entities capitalized in the period. To view the details of the amounts capitalized, click on the required capitalization line and double click to display 'BIM Capitalization Costs'. This will display the amounts transferred to capitalization by account.

3. The details can also be viewed in PE031 - B-BIM Capitalization (Period End Capitalization)>Capitalization Detail. Generate the report and click on the '+' to view the amounts capitalized by account.

4. A summary of the capitalized entities can be viewed in PE031 - B-BIM Capitalization (Period End Capitalization)>Capitalization Summary.

5. PE030 - B-BIM Capitalization (Breeder Capitalized Summary) and PE029 - B-BIM Capitalization Summary (Breeder Brood Summary by Account) display the details based on journal transactions if verification is required.

6. Once the details are finalized, PE023 - Period End Breeder Brood Inventory can be generated which represents the period end brood inventory value by entity. This is considered the audit report to the brood inventory for the period.

If Protein Cost Mode is set to Standard with Actual Cost or Standard Cost with Variance, the capitalization task will transfer values based on the rates entered in internal prices for capitalization transactions. Differences between actual and standard will be recorded to either an adjustment account or a variance account depending on the mode.

Protein Cost Mode=Actual

Protein Cost Mode=Standard and Actual Cost (adjustment to actual will be recorded based on internal prices defined for capitalization)

B-BIM Depreciation-[Generation]-[Mode]

The depreciation task calculates the depreciation cost for the period. There is a task for each generation and depreciation method. The process will credit accumulated depreciation for the period and debit the depreciation expense for the entity.

• Straight Line

• Percentage

• HE/HH

1. Calculate the required depreciation task.

2. Right-click and select Depreciation Log. The log displays the details for the calculation for depreciation for each entity. The details can also be viewed in the report PE033 - 10500 B-BIM Depreciation Straight Line (Depreciation Summary). Reports for other depreciation modes can be run as they become available in the system.

3. Generate PE032 - 10500 B-BIM Depreciation (Breeder Depreciation Summary) to view the summary of the journals recorded for depreciation. This should match the depreciation log.

Protein Cost Mode=Actual

Protein Cost Mode=Standard and Actual Cost

B-BIM Movements-[Generation]-Lay

The Lay Movements task calculates the gain or loss on spent breeders transferred to an internal plant or sold to an external plant. The cost that is transferred is based on the salvage value defined in the depreciation method. The task will credit the capitalization cost and debit accumulated depreciation. On the final transfer from the farm to the plant or customer, the system will calculate the gain or loss on the entity to set the net book value to zero. The account for the calculated gain/loss is determined by the account defined in Poultry>Broiler Breeder>Period End>End of Lay Variance Mode.

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.

1. Calculate task.

2. 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 BIM 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. To view a summary of the details, generate report PE036 - B-BIM Movements Lay (Lay Movement Summary).

   Non-Allocated - the costs are allocated to the entity based on the transaction date. For example, chick cost would be a  non-allocated cost as it is not allocated to all entities on the farm in the period.

   Allocated Daily - amounts are summed for the month and then prorated to each day of the month based on either Entity Days or Animal Days depending on a registry switch

3. To view the details for farm to plant transfers, generate report PE035 - B-BIM Movements Lay (Farm to Plant Summary). This report will display the amounts removed from the capitalization accounts and the gain/loss recorded for each entity.

4. To view the details for lay farm to farm transfers, generate report PE034 - B-BIM Movements Lay (Farm to Farm Summary)>Breeder Farm to Farm Transfer In or PE034 - B-BIM Movements Lay (Farm to Farm Summary)>Breeder Farm to Farm Transfer Out.

5. Once this task is complete and reconciled, generate PE047 - Period End Capitalization Inventory. This report provides a summary of the capitalized inventory at the end of the period that can be used for audit purposes.

Protein Cost Mode=Actual

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)

B-BIM Expense Spike Male Costs

If the option in Registry>Poultry>BroilerBreeder>Spike Male Cost Mode is set to Expense Spiking Male Costs, this task is used to allocate the spiking costs to BRDR-LAY. The Costs are allocated by hen days based on the cost center relationship as defined in BIM Spike Male Mapping. .

1. Calculate task
2. Generate report 10850 B-BIM Spike Male Costs (Spike Farm Costs) to see the total amount for each dedicated stud farm.
3. Generate report 10850 B-BIM Spike Male Costs (Spike Cost Allocation) to view the spike amount allocated to each lay entity.

Protein Cost Mode=Actual