The purpose of this document is to outline the basic steps to utilize the FDSA (Feed Delivery Scheduling Assistant) in Version 7.0+ and preliminary steps required to run the projections. FDSA is a feed delivery planning tool that provides a complete and efficient delivery plan based on the parameters established by each farm. The process uses feed consumption tables and feeding programs to determine the feed deliveries.
The following sections are outlined in this document to assist the user in the required day-to-day tasks and represent the typical order of data entry and data generation.
The following diagram represents the basic flow of all of the components in the FDSA process.
Before creating any Feed Projections in the system, flock (s) with bird placement must exist before executing any of the functions within FDSA. The flock (s) can either be created manually, or by the MTech Planning Modules: BPA (Breeder Planning Assistant) / BRPA (Broiler Planning Assistant). All steps needed to configure, execute, and review the results of FDSA will be included in the outline below.
The purpose of the setup overview is to review some of the switches required for FDSA. It is not required to establish every switch during the pre-implementation session; however careful consideration is required before implementation. All switches must be defined for all primary feed mills that supply feed to the entities.
There are three sections in the FDSA Setup section:
In Admin>System>Registry>Poultry Registry>Feed Mills>FDSA, select General.
Bin Adjustment Safety Factor – modifies the bin capacity used for feed delivery to reduce the chance that too much feed will be delivered. The factor is entered in percentage so that a value of 80 will project deliveries at 80% of the bin capacity.
Bin Delivery Mode – if there are multiple bins, this option determines how the feed is delivered to the bin.
Always Alternate – FDSA projects deliveries alternating between bins. Example: Bin A, Bin B, Bin A, Bin B.
First Bin Except First Delivery – will always project to Bin A except for first delivery. First delivery has the option to project to the empty bin.
House Capacity – will project to use all bins on the house. Only one feed type per bin.
House Capacity Mix Feeds - will project to use all bins on the house. Multiple feed types per bin.
House Even Bin Ending Inventory – FDSA projects to balance all ending inventories in the bins. Multiple feed types per bin.
Compartment Rounding – rounds deliveries to the nearest value entered in this field. Example, 3,000 will round the delivery to the nearest 3,000 lbs.
Feed Rounding Direction – determines how the feed deliveries are rounded.
Round Up – always rounds up. Example: 1.4 rounds up to 2.0
Round Down – always rounds down. Example: 1.4 rounds down to 1.0
Round Combination – rounds down or up. Example: 1.4 rounds down to 1.0 and 1.5 rounds up to 2.0.
Feed Rounding Mode - if a load is comprised of multiple formulas, the switch determines how the feed is rounded. For example, a load of 12,000lbs has 3,000 Starter and 9,000 Grower.
Precise Feed Type Amounts – projects 3,000 Starter and 9,000 Grower
Advance to Next Feed Type – projects 12,000 Grower
Extend Previous Type – projects 12,000 Starter
Formula Assignment Effective Date Mode – links the effective date of the formula assignment to the entity based on either Placement Date or Projection Date.
Harvest Date Delivery – if selected, FDSA will project feed on harvest date.
Limit Projection to Truck Capacity – limits the projected delivery amount to a single truck.
Load Compartment Rounding – factor to round loads for delivery. Example, 1,000 will round load to nearest 1,000 lbs.
Min Head Count for Rounding - represents the number of head that must reside in a house before rounding occurs. For example, if the value is 6,000 head and the house contains 5,000 head, the projected load will not round the feed to be delivered. If the house contains over 6,000 head, the projected loaded will be rounded according to the parameters defined in Compartment Rounding, Feed Rounding Mode and Load Compartment Rounding.
Min Percent Delivery Factor – used to determine minimum percentage of compartment that can be delivered.
Next Feed Type Mode – determines how the projection transitions to the next feed type.
Stay on Previous Type – projection will remain on existing feed type until the feed program changes types or a new feed type is delivered.
Feed Program – delivers feed type based on the feed program.
Projection Granularity Mode – determines if deliveries are projected by entity, house or pen.
Projection Mode – specifies the flock number format for the lowest granularity that is delivered. Available options are:
Farm – projects all of the houses on a farm in a single unit. Each house is analyzed but only a single projection for the farm.
Farm House – projects based on a single delivery date for all houses prioritizing houses based on the lowest to highest days to empty.
House Independent – projects based on different delivery dates for houses prioritizing houses based on the lowest to highest days to empty.
Rounding Days Prior to Harvest – represents the number of days prior to harvest that compartment rounding will be ignored.
Standard House Delivery – standard house amount used to project delivery. The value will not overwrite bin capacity.
Standard Truck Capacity – maximum standard truck capacity used for projections.
System Delivery Rounding – rounding factor used when no compartment rounding or feed type rounding are defined. Factor is entered in percentage.
In Admin>System>Registry>Poultry Registry>Feed Mills>FDSA, select BIM.
Days Before Placement – number of days before placement that feed delivery is scheduled.
Even Bins – this option is used when Projection Mode is set to Farm House. Selecting this option will project deliveries to the houses so that the bins will be empty on the same day.
Even Bin Threshold – limits the even bin option to farms that have house head capacities less than the threshold.
Manual Days Before Sale – number of days prior to slaughter that deliveries are defined as manual deliveries. Entities will remain in projection but identified as a manual delivery.
Max Feed Days on Farm – represents the maximum number of days that the feed can be stored at the farm.
Min Age for Debit Delivery – determines the age that feed transferred into the entity from another entity can be used in the projection. For example, if withdrawal feed is transferred into the entity, the number of days from placement date that the withdrawal feed can be used.
Max Withdrawl Time – minimum number of days prior to slaughter that withdrawal feed is required.
Reorder Days – FDSA projects to deliver feed when the number of days to empty is zero. If more lead time is required, enter the number of lead days. For example, if a value of ‘1’ is entered, the projection will occur when there is one day to empty.
Delivery Sunday-Saturday – select the days of the week that feed can be projected to be delivered.
In Admin>System>Registry>Poultry Registry>Feed Mills>FDSA, select BRIM.
Days Before Placement – number of days before placement that feed delivery is scheduled.
Even Bins – this option is used when Projection Mode is set to Farm House. Selecting this option will project deliveries to the houses so that the bins will be empty on the same day.
Even Bin Threshold – limits the even bin option to farms that have house head capacities less than the threshold.
Manual Days Before Sale – number of days prior to slaughter that deliveries are defined as manual deliveries. Entities will remain in projection but identified as a manual delivery.
Max Feed Days on Farm – represents the maximum number of days that the feed can be stored at the farm.
Min Age for Debit Delivery – determines the age that feed transferred into the entity from another entity can be used in the projection. For example, if withdrawal feed is transferred into the entity, the number of days from placement date that the withdrawal feed can be used.
Min Withdrawal Time – minimum number of days prior to slaughter that withdrawal feed is required.
Reorder Days – FDSA projects to deliver feed when the number of days to empty is zero. If more lead time is required, enter the number of lead days. For example, if a value of ‘1’ is entered, the projection will occur when there is one day to empty.
Use Standard Mortality– selecting this option will reduce projected head count for delivery based on the following. If BRPA is not being used, then the only option is Field Mortality.
Field Mortality - reduce projected head based on values entered in Field Transactions.
Standard Mortality - reduces projected head based on the mortality percentage entered in BRPA> Products> Performance Curves.
Field and Standard Mortality - logic reduces projected head based on the last date that a field transaction has been entered and standard mortality for any day after the actual field transaction has been entered. Standard mortality is defined in BRPA> Products> Performance Curves.
Delivery Sunday-Saturday – select the days of the week that feed can be projected to be delivered.
In Admin>System>Registry>Poultry Registry>Feed Mills>FDSA, select LIM.
Days Before Placement – number of days before placement that feed delivery is scheduled.
Even Bins – this option is used when Projection Mode is set to Farm House. Selecting this option will project deliveries to the houses so that the bins will be empty on the same day.
Even Bin Threshold – limits the even bin option to farms that have house head capacities less than the threshold.
Manual Days Before Sale – number of days prior to slaughter that deliveries are defined as manual deliveries. Entities will remain in projection but identified as a manual delivery.
Max Feed Days on Farm – represents the maximum number of days that the feed can be stored at the farm.
Min Age for Debit Delivery – determines the age that feed transferred into the entity from another entity can be used in the projection. For example, if withdrawal feed is transferred into the entity, the number of days from placement date that the withdrawal feed can be used.
Min Withdrawal Time – minimum number of days prior to slaughter that withdrawal feed is required.
Reorder Days – FDSA projects to deliver feed when the number of days to empty is zero. If more lead time is required, enter the number of lead days. For example, if a value of ‘1’ is entered, the projection will occur when there is one day to empty.
Delivery Sunday-Saturday – select the days of the week that feed can be projected to be delivered.
In Admin>System>Registry>Poultry Registry>Feed Mills>FDSA, select TIM.
Days Before Placement – number of days before placement that feed delivery is scheduled.
Even Bins – this option is used when Projection Mode is set to Farm House. Selecting this option will project deliveries to the houses so that the bins will be empty on the same day.
Even Bin Threshold – limits the even bin option to farms that have house head capacities less than the threshold.
Manual Days Before Sale – number of days prior to slaughter that deliveries are defined as manual deliveries. Entities will remain in projection but identified as a manual delivery.
Max Feed Days on Farm – represents the maximum number of days that the feed can be stored at the farm.
Min Age for Debit Delivery – determines the age that feed transferred into the entity from another entity can be used in the projection. For example, if withdrawal feed is transferred into the entity, the number of days from placement date that the withdrawal feed can be used.
Min Withdrawal Time – minimum number of days prior to slaughter that withdrawal feed is required.
Reorder Days – FDSA projects to deliver feed when the number of days to empty is zero. If more lead time is required, enter the number of lead days. For example, if a value of ‘1’ is entered, the projection will occur when there is one day to empty.
Use Standard Mortality– selecting this option will reduce projected head count for delivery based on the following. If BRPA is not being used, then the only option is Field Mortality.
Field Mortality - reduce projected head based on values entered in Field Transactions.
Standard Mortality - reduces projected head based on the mortality percentage entered in TPA> Products> Performance Curves.
Field and Standard Mortality - logic reduces projected head based on the last date that a field transaction has been entered and standard mortality for any day after the actual field transaction has been entered. Standard mortality is defined in TPA> Products> Performance Curves.
Delivery Sunday-Saturday – select the days of the week that feed can be projected to be delivered.
In Admin>System>Registry>Swine Registry>Feed Mills>FDSA, select SIM.
Days Before Placement – number of days before placement that feed delivery is scheduled.
Even Bins – this option is used when Projection Mode is set to Farm House. Selecting this option will project deliveries to the houses so that the bins will be empty on the same day.
Even Bin Threshold – limits the even bin option to farms that have house head capacities less than the threshold.
Manual Days Before Sale – number of days prior to slaughter that deliveries are defined as manual deliveries. Entities will remain in projection but identified as a manual delivery.
Max Feed Days on Farm – represents the maximum number of days that the feed can be stored at the farm.
Min Age for Debit Delivery – determines the age that feed transferred into the entity from another entity can be used in the projection. For example, if withdrawal feed is transferred into the entity, the number of days from placement date that the withdrawal feed can be used.
Min Withdrawal Time – minimum number of days prior to slaughter that withdrawal feed is required.
Reorder Days – FDSA projects to deliver feed when the number of days to empty is zero. If more lead time is required, enter the number of lead days. For example, if a value of ‘1’ is entered, the projection will occur when there is one day to empty.
Delivery Sunday-Saturday – select the days of the week that feed can be projected to be delivered.
In Admin>System>Registry>Swine Registry>Feed Mills>FDSA, select GIM.
Days Before Placement – number of days before placement that feed delivery is scheduled.
Even Bins – this option is used when Projection Mode is set to Farm House. Selecting this option will project deliveries to the houses so that the bins will be empty on the same day.
Even Bin Threshold – limits the even bin option to farms that have house head capacities less than the threshold.
Manual Days Before Sale – number of days prior to slaughter that deliveries are defined as manual deliveries. Entities will remain in projection but identified as a manual delivery.
Max Feed Days on Farm – represents the maximum number of days that the feed can be stored at the farm.
Min Age for Debit Delivery – determines the age that feed transferred into the entity from another entity can be used in the projection. For example, if withdrawal feed is transferred into the entity, the number of days from placement date that the withdrawal feed can be used.
Min Withdrawal Time – minimum number of days prior to slaughter that withdrawal feed is required.
Reorder Days – FDSA projects to deliver feed when the number of days to empty is zero. If more lead time is required, enter the number of lead days. For example, if a value of ‘1’ is entered, the projection will occur when there is one day to empty.
Delivery Sunday-Saturday – select the days of the week that feed can be projected to be delivered.
The Master Data section is comprised of two components:
Product Profiles are created to define the based parameters for FDSA projections. A profile must be created for each animal product that requires feed delivery projections. Prior to creating FDSA Products, Animal Products must be created.
In FMTS>FDSA>Master Data, select Products.
Select the Product No from the list of available animal products.
Set Min Withdrawl Mode to determine if feed withdrawal is set to Days or lbs/kgs per day.
Enter the number of days or lbs/kgs that are required for withdrawal in Max Withdrawl Time. The value is entered baaed on the withdrawal mode.
Often feed is left on the farm for the next entity. The feed must be transferred to the new entity using Feed Deliveries>Transfers. FDSA will ignore the debit transactions created from the feed transfer until the entity reaches the age specified in Min Age Debit Delivery Consumption. The age in days entered in this field determines when debit transactions are recognized and available for feed consumption.
The Feed Formula Assignments determines the feed type and formulas that are assigned to the product at placement. The Feed Formula Assignment can be defined by entity or alternatively derived based on product, feed mill and effective date. The order of selection of the formula assignment is Entity>Farm>Feed Program or Derived based on the default formula assignment. If the default is not defined, the system will randomly select a formula assignment for the product.
In FMTS>General>Master Data, select Formula Assignments.
Enter the Formula Assignment No to identify the feed formula assignment (alphanumeric, max 20 characters).
Enter a description in Formula Assignment Name for the feed program (alphanumeric, max 50 characters).
Select the Feed Mill No to assign the formula assignment to the feed mill.
Select the Product No to assign the formula assignment to the product.
Select the Default option if the Formula Assignment is the default for the product. If the assignment is not defined on the farm, entity or feed program, the default assignment will always be selected.
Enter an Effective Date to establishes the first date that the assignment becomes in effect.
Select the Feed Type No that is being assigned to the product. Feed types are user-defined values.
Select the Formula No for the assignment. The Formula No will be filtered based on the Feed Type No.
Enter the Sequence to determine the order of the formula assignment for the feed formula.
Select Alternate if the feed formula is an alternate formula for the feed assignment. The projection will always project for feed formulas that do not have the Alternate flag selected, however, if required, the alternate feed can be delivered.
The Projection Basis section is comprised of two components:
Feed consumption tables are determined by product and feed mill. The values are entered in lbs. Prior to creating a consumption table, the following items must be set up:
In FMTS>FDSA>Projection Basis, select Consumption Tables.
While in the Consumption Edit screen,
click the 
button to create a new record.
Enter the code for the Consumption Table No which will be used throughout the process to identify the consumption table.
Enter a description for the Consumption Table Name.
Enter the Effective Date to indicate the start date of the consumption table.
Select the Product No that the consumption table will be assigned to.
Select the Farm Type where the product is placed.
Select the Feed Mill No for the feed mill that is supplying the feed to the product.
Click the OK button to open the consumption table.
Consumption table information is derived from the Consumption Table prompt.
Age indicates the age of the entity in days. The consumption values will be entered for each day.
Enter the amount of feed consumed per chick in the Consumption field.
ACM Cons is a calculated field which represents the accumulated feed consumed per 100 chicks.
In FMTS>FDSA>Projection Basis, select Feeding Programs.
In
the FDSA Feeding Programs, click the button to
create a new feeding program record.
Enter the Feed Program No to identify the program (alphanumeric, max 20 characters).
Enter a description for the Feed Program Name (max 40 characters).
Enter an Effective Date to establish the first date that the program becomes effective.
Select the Feed Mill No to assign the feed program to the feed mill.
Select the Product No which assigns the feed program to the product.
Select the Feed Type No that is being assigned to the feed program. Feed types are user-defined values.
Basis determines how the feed program is calculated. Available options are:
Amount – if the basis is Amount, the value is entered in lbs that will be fed before moving to the next formula.
Days – when the basis is selected as Days, the value is entered based on the age in days that the formula will be fed before moving to the next formula.
Sequence indicates the order that the feed is fed.
Once the Formula Assignments and Feed Programs have been defined, the modules must be configured based on how the options are assigned. If the Formula Assignment is derived based on the following order:
For each of the suites and modules that will be using FDSA, the following Master Data must be reviewed and fields populated as required.
The following are the options that can be defined at the farm related to FDSA. The Primary Feed mill is the only required field. All other fields are optional.
Bins and bin capacities must be defined at the house level for FDSA projections.
to add a new house bin.In the Bin Name field, enter a unique code to identify the feed bin (alphanumeric, max 100 characters).
Enter the bin feed Capacity. This can be entered in either lbs or kgs depending on the unit of measure utilized.
From Bin Sex Type, select the sex type for the feed bin. Available options are: Male, Female or Straight Run. This field is only displayed for certain modules and suites that may house multiple sexes in a house.
The Active flag will be selected by default and indicates if the house is available and used in placements or production. De-select the flag if the house is no longer available.
House Index is an automatically-assigned reference number for the house.
Formula Assignments and Feeding Programs may optionally be assigned directly to the entity.
Feed projections can be done individually or in filtered groups. The projection will incorporate existing feed and field transactions and project the future feed requirements for the entity and houses. There are options to project feed at the entity, house or pen level. If the source data is not at the projected delivery granularity, there is a pro-rata option that will restate all historical deliveries to the house or pen level. The pro-rata must be completed before FDSA projections are calculated.
The Projections section is comprised of four tabs:
Before you run the projection, make sure that the Projection date is set to the date when you want this projection run and remember that you cannot go back in time to run a projection.
The Farm tab displays all of the summary data related to the entity. Each type of transaction is represented by a separate color. Data for the entire entity is displayed in the color coded section. By clicking on any line in the Farm Projection section, house and pen details will be displayed in the Details section.
Green – actual feed deliveries
White – projected feed deliveries or inventories
Feed Trans Code indicates the type of feed delivery. Available options are: Delivery, Debit, Credit, Haul back or Return. Non-feed transactions will be recorded as Not Set.
Event Type represents the type of transaction. Examples are: Delivery, Field, Thinning and Projection.
Event Date indicates the actual date or projected date for the specified transaction.
Day displays the week of the day that the transaction will occur.
Age displays the age of the entity at the time of the projection record.
Feed Type No indicates the feed type that was delivered or is projected to be delivered.
Formula No represents the feed formula that was delivered or is projected to be delivered based on formula assignments.
Current Days to Empty based on feed consumption and head inventory, this is a calculated field to represent the number of days of feed remaining for consumption.
Beginning Feed Inventory is either calculated or feed inventory from field transactions for the specified event date.
Projected Total Amount displays the amount of feed that is required based on remaining inventory and feed consumption tables. Past deliveries will always display delivered amount.
Total Feed Delivered represents the amount of feed delivered on actual delivery. Projected deliveries will display zero until feed load is created.
Days to Empty After Delivery is a calculated field based on feed consumption and head inventory that represents the number of days until the bins are empty after the projected/actual delivery.
Head Inventory is the number of birds in inventory that will be used for the feed consumption calculation.
The Feed Remaining tab displays the data for the summary data for the
entity by feed type. Feed Remaining is calculated by taking the feed program
and applying mortality and thinning transactions to determine the required
feed quantities by feed type. House details are not included on this tab,
however, there are other tabs that will provide that data.
Feed Type No indicates the feed type for the projection record.
Projected Amount is the calculated amount that represents the projected feed by feed type. The projected amount is sourced from Feeding Programs and takes into account the FDSA switches established such as rounding feed delivery amounts, no rounding before processing, skip to next feed type, etc. The projected amount will be displayed in lbs or kgs depending on the unit of measure utilized.
Delivered Amount is sourced from feed deliveries and purchases, represents the amount of feed that has been delivered to the entity by feed type. The delivered amount will be displayed in lbs or kgs depending on the unit of measure utilized.
Variance is a calculated value representing: Projected Amount – Delivered Amount.
Feed Budget simplified budget calculation that is sourced from Feeding Programs and the average head inventory for the feed period. The calculation does not take into account FDSA switches.
Budget Variance is a calculated value representing: Budget Amount – Delivered Amount.
The House Details displays the feed delivery transactions and projections at the house level. Although all columns are not displayed below, the description of the field will be defined in this document.
Event Type represents the type of transaction. Examples are: Delivery, Field, Thinning and Projection.
Event Date indicates the actual date or projected date for the specified transaction.
Projection Type is only displayed for projected deliveries. Some examples are: Pre-Placement, Kill Date, First Delivery, Last Delivery.
Houses/Pen indicates the house or pen for the transaction or projection.
Animal Product No represents the product that was placed in the house.
Age indicates the age of the entity, in days, that resides in the house.
Current Days to Empty is a calculated field based on feed consumption table, age, feed inventory and feed delivered that represents the number of days before the feed level is depleted.
Feed Type No represents the feed type of the feed that is being delivered or projected for the house.
Beginning Feed Inventory is the perpetual inventory that is calculated based on the feed delivered and consumption tables and feeding programs. Beginning inventory will be adjusted if inventories are entered in field transactions.
Total Feed Delivered represents the quantity of feed delivered to the house.
Days to Empty after Delivery is a calculated field based on beginning inventory and feed delivered to determine the number of days to empty.
Physical Feed Inventory is the quantity of feed inventory that has been entered in field transactions.
Ending Inventory is the perpetual inventory that is calculated based on the feed delivered and consumption tables and feeding programs. Ending inventory will be adjusted if inventories are entered in field transactions.
Head Inventory indicates the number of head in inventory for the feed delivery date. Projections will have projected inventory if expected mortality is defined.
Last Date Sold is the projected sold date of the entity. This date will be derived from the following in the established order:
Planned projected kill schedule
Planned placement schedule
Placement date and the target number of days defined on the product
Date Moved In indicates the date that the entity was moved into the house or the planned date that the entity is scheduled to be moved in for future entities.
Processing Time displays the time that the transactions were processed if time is recorded in the source transaction.
Vehicle No will be displayed if there is a vehicle defined on the feed delivery transaction.
Bin Amount 1-4 displays the feed that was delivered to each bin. Amount is displayed in lbs or kgs depending on the unit of measure utilized.
Bin Capacity 1-4 displays the feed capacity for each bin. Capacity is displayed in lbs or kgs depending on the unit of measure utilized.
The House Feed Remaining tab displays the data for the summary data for the houses by feed type. Feed Remaining is calculated by taking the feed program and applying mortality and thinning transactions to determine the required feed quantities by feed type. There is a tab for projected and delivered feed.
