HPA Configuration & Procedures

 

The purpose of this document is to outline the basic steps to define the parameters and generate the HPA projections. 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.

 

Hatchery Planning Assistant (HPA)

The HPA module is a supply and demand tool that is used to analyze the variance between the eggs and chicks that can be produced as compared to the demand. The process uses the demand created by the BPA to create the supply. The HPA then takes the demand from internal placements and external orders to create the demand.  There is some configuration related to farms and entities that is covered in the BPA document. Some notes about HPA:

 

 

Process Flow

The following diagram represents the basic flow of all of the components in the HPA process.

 

 

Setup

This section will guide the user to set up all prerequisites needed to operate HPA.

 

The Setup section contains the following components:

 

Products

The details related to the products have been established in the other modules. The section that relates to HPA is Internal Mappings. The Internal Mappings indicates products that can be used interchangeably if the original product is unavailable. *Note: For the Source Breed tab, HPA requires that the source breed be selected.

 

  1. In General>General>Products>Animals, select Poultry.

  2. Click on the Internal Mapping tab.

  3. Select the New button or click F4.

  4. Select the product that can be used interchangeably *Note: Can only select products that have been set up or if product is new the new product must be set up.

 

 

Purchases

Purchases will increase the future supply for HPA. In order to increase and project supply, purchase orders must be entered in the system for all future planned egg chick purchases.

 

  1. In General>General>Purchases, select Orders.

 

 

Header

The following fields are required for the HPA Header level:

  1. PO No – auto generated when the purchase order is saved.
  2. PO Date – date of the purchase.
  3. Vendor No – must be selected
  4. Dest. Cost Center No – select the cost center receiving the purchase (chicks or eggs).

PO Line Item Details

The following fields are required for the PO Line Item details.

  1. Click in the PO Line Items section to set the focus, and then click on the new button or F4.

  2. Dest Cost Center – auto-populates from header of the PO.

  3. Vendor Sku No – select the vendor selling the product.

  4. Freight Type – select the Freight Type. Available options are:  

  5. Vendor Units – enter the number of eggs or chicks purchasing.

  6. Price – enter the unit price

 

BRPA Planned Placements

The BRPA plans future placements based on target processing volumes. If the BRPA module is not used, the planned placements can be manually entered.

 

 

Sales Order Planning

The Sales Order Planning screen allows the user to enter egg and chick orders in a grid style format. The order planning screen is in a calendar format that allows the user to easily move around orders if required. Alternatively, sales orders can be entered individually in the Sales>Orders screen.

 

  1. In BMTS>HPA>Planning, select Order Planning.

  2. Click on the button  and a new line will appear in the HIM Order Planning grid.

 

 

The following fields are required for HPA Order Planning:

  1. Order No will auto-populate when the order is saved.
  2. Customer (Ship To) – select the customer receiving the product.
  3. Cost Center No – select the cost center shipping the product.
  4. Customer (Bill To) – defaults from the Ship To customer.
  5. Order Date – enter the date the order was entered.
  6. Delivery Date – enter the date the product is being delivered.
  7. Open the child grid by clicking on the button in the Order No column.
    1. Set the focus on the line item and click .
    2. Select the Sales SKU No.
    3. Enter the number of Order Units.
    4. If a specific breed has to be utilized for this order, then click in the Line Item No.
      1. Set the focus on the Breed No and select .
      2. Select the Breed No.
      3. Select the Sex.
      4. Enter the Priority – if there are multiple breeds that can source this order, enter `1` for the first breed priority and `2` for the second breed priority, etc. If only one breed is used, then Priority is optional.

 

 

Hatcheries

The hatcheries must be configured if eggs/chicks are being transported between hatcheries.  

Hatchery Mapping

The first item related to hatcheries is that the hatcheries must be mapped for interdependencies when volumes become low or exhausted. The hatcheries are mapped in: Admin>Business>General>Definitions>Facilities>Hatcheries.

 

  1. Select the hatchery and then open the child grid by clicking on the Hatchery No field.

  2. Set the focus in the grid and then click .

  3. Enter the Source Hatcher – hatchery that can supply eggs to the selected hatchery.

  4. Enter the number of Move Days – number of days to move from the source hatchery to destination hatchery.

  5. Enter the Distance – number of miles or kms from source hatchery to destination hatchery.

  6. Repeat steps 2 – 5 for every hatchery that can supply the selected hatchery.

 

HPA Master Data

The Master Data section contains one crucial component:

 

Hatchery Capacity

HPA Hatchery Capacity must be set up. The hatchery capacity can be entered weekly or daily, depending on the level of detail that is required. Capacity is entered based on egg set capacity.

Create Hatchery Capacity

  1. In BMTS>HPA>Master Data, select Hatchery Capacity.

  2. In the Hatchery Capacity screen, set the focus in the gird and click the button.

  3. In the New Record pop up box, enter the Hatchery No.

  4. Enter the First Date that projections will be calculated from – today's date will default.

 

 

  1. In the Hatchery Capacity screen, Select the Hatchery No.

  2. Enter the Date – new record will default with today's date.

  3. Enter the Capacity (Daily or Weekly)

    1. To enter the Capacity manually, click the button and repeat steps 1–3.

    2. To enter the Capacity as a batch, right-click the hatchery capacity line and select `Copy`.

 

  1. In the Appointment screen that will appear, click the Recurrence button.

 

 

  1. In the Appointment Recurrence dialog box, select the Recurrence pattern of Daily or Weekly.
  2. Select the Range of Recurrence.
  3. Enter the Start date and the End date and then click the OK button.

 

Weekly or Daily Options

 

  1. Set the projection view to daily or weekly.

  2. In the menu, select the Options button.

  3. Click Calendar Options, and then select Weekly or Days. 

 

HPA Profiles

Profiles are created so the user will have the ability to create different scenarios.  

 

The Profiles section is comprised of the following:

 

Projection Profiles

Projection Profiles establish the rules for the HPA supply and demand projection. Several profiles can be created to analyze various scenarios.

Create a Projection Profile

The profile creation section contains the following components:

 

  1. In BMTS>HPA>Profiles, select Profiles.

  2. In the HPA Projection profile index screen, select the button to create a new profile.

 

 

General

The General section contains the basic information for the profile being created. The following fields are required for HPA:

  1. Enter a Profile No to identify the profile being created.

  2. Enter a Profile Name to describe the profile.

  3. Enter the Start Egg Inventory Date – must be within the date ranges of the BRPA and BPA profiles selected in the Demand tab of this screen.

  4. Enter the Ending Plan Date – the date projecting will be stopped.

  5. The Import Farm Inventory flag is optional – select the flag only if the farm egg room inventory should be included in the projections.

  6. Select the Order Status Filter Type – available options are:

  7. Select the Hatchery Utilization Mode – available options are:

Hatchery

The Hatchery tab assigns the hatcheries to the profile and establishes the hatchery priority for the profile.

 

  1. In the Hatchery tab, set the focus in the grid and click .

  1. Select the Hatchery No from the drop-down menu.

  2. The Priority option is used if more than one hatchery is being utilized. If applicable, enter the priority of each hatchery.

  3. Select the Import Egg Purchase Orders flag to import the egg purchases in HPA.

  4. Select the Import Chick Purchase Orders flag to import the chick purchases in HPA.

  5. Select the Hatchery Full Capacity flag to fill the hatchery before transferring to another hatchery.

  6. Select the Transfer Eggs to Full Capacity flag to transfer eggs to fill other hatchery capacities.

  7. Minimum Transfer Eggs – enter the minimum number of eggs that can be transferred in one shipment.

Demand

The Demand section utilizes the sales order as well as the BPRA and BPA Placement Profiles in order to calculate the total amount of demand needed.

 

  1. Select the Profile No – this is the BRPA profile.

  2. Priority  if more than one BRPA Profile is being utilized, enter the priority of each profile.

  3. Select Source Info – this is BRPA Movements or Targets.

  4. Weeks before Targets – if Source info is “Targets”, enter the number of weeks the system will use movements before it uses Targets.

 

Supply

The Supply tab identifies the BPA profiles and the priority that will be used to source the supply for the projection.

 

  1. Select the Profile No from the drop-down list. The profile must first be setup in BPA as a BPA Profile.

  2. Profile Name will default based on the profile selected.

  3. Enter the Priority in which the profiles are to be used.

http://help.mtech-systems.com/mergedProjects/BMTS/HPA/zImage/HPA_Profile_Supply.gif

Products

The Product tab specifies the products to be used in the profile.

 

  1. Product No will default when products are created in the Animal or Egg Products.

  2. Product Name will default when products are created in the Animal or Egg Products.

  3. Product Type will default when products are created in the Animal or Egg Products.

  4. Check the Selected box if the product is to be used in the profile. *Note: If selected, HPA will restrict the system to only those selected products. If left de-selected, all products will be available to be used.

http://help.mtech-systems.com/mergedProjects/BMTS/HPA/zImage/HPA_Profile_Products.gif

Categories

The Categories tab further defines the projection into user defined categories based upon bird age and weight.

 

  1. Enter a Category Name to define the category.

  2. Enter the Min Flock Age to be used in the category.

  3. Enter the Max Flock Age to be used in the category.

  4. Enter the Min Weight to be used in the category.

  5. Enter the Max Weight to be used in the category.

  6. Enter the Priority in which the categories are to be used.

  7. Save and close the profile.

 

http://help.mtech-systems.com/mergedProjects/BMTS/HPA/zImage/HPA_Profile_Categories.gif

HPA Projections

The HPA Projections section is comprised of the following components:

 

Product Availability

Product Availability is the projection of product and hatchery utilization matching supply to demand within the constraints of breed to product and hatchery mappings to create a view of available product to utilize. The Product Availability can be viewed based on egg projections or chick projections. There are also filters available to limit the data to product and/or breed if required. Product Availability is a read-only screen that is driven by BPA/BRPA planning, and sales orders for demand and supply is driven by actual production (BIM) and BPA Placement Schedules.

Once the profiles have been created, they will appear in the Product Availability main screen.

 

  1. In BMTS>HPA>Projections, select Product Availability.

 

 

  1. Before the profile can be viewed, the profile must first be calculated. Select the profile to be calculated and click the calculate    button. *Note: This process may take several minutes depending upon the size of the profiles.

  2. Once the calculation has finished, double-click on the profile  or click on the Edit button in the menu to view the projections.

 

  1. In the Select Products prompt box, enter the Product No and/or Breed No. By entering a product or breed, the prompt will restrict the next screen to only the product and/or breed entered in the prompt box.

  2. To view all products and/or breeds, click the OK button. HPA Projections will appear.

 

 

Weekly Grid

The Weekly gird contains all the details related to the division and is displayed as totals for all hatcheries. This screen is read-only and can be viewed as eggs, chicks or both.  Hovering over the column title will display the column definition. The example below is filtered by breed and viewed as Eggs. 

 

  1. Egg W/E Date the week ending date the egg were produced.

  2. Eggs Supply represents: the Beginning Inventory + Eggs Received + Eggs Purchased + Egg Reductions.

  3. Eggs Demand represents: Eggs Set + Eggs Sold.

  4. Eggs Utilized represents: Eggs Set + Eggs Sold.

  5. Egg Remaining   indicates the Ending Egg Inventory.

  6. Eggs Utilized vs Demand – represents: Eggs Utilized – Egg Demand. *Note: If there is a negative number, it indicates that you are short for this weekending period (see week ending date 10/25/14).

  7. Egg Capacity – indicates the hatchery capacity.

  8. Eggs % Capacity – indicates the hatchery % of capacity.

 

Chicks View
  1. Chick W/E Date  – indicates the week ending date the chicks were hatched.

  2. Chicks Supply represents: the Beginning Inventory + Projected Chicks Supply + Chicks Purchased + Chicks Imported – Actual Chick Disposal.

  3. Chicks Demand represents: Chick Placements + Chick Sales.

  4. Hatch % projected percentage used to calculated chicks hatched.

  5. Saleable % projected percentage used to calculated chicks sold.

  6. Chicks Utilized represents: Chick Placements + Chick Sales.

  7. Eggs Utilized vs Demand – represents: Chicks Utilized – Chick Demand. *Note: If there is a negative number, it indicates that you are short for this weekending period (see week ending date 11/15/14).

  8. Egg Remaining   indicates the Ending Chick Inventory + Projected Chicks Inventory.

 

Eggs and Chicks

 

Hatcheries Grid

The hatcheries gird is a weekly view by hatchery. Inside the Child grid, each hatchery is broken down by day. The data is the same as the Weekly gird.  Click on the  to expand the daily view and click on the – sign to collapse the daily view.

 

 

Projection Options

Right-Click Options

Right-clicking on a particular week in the Weekly gird allows the user to select views that detail projections, transactions and utilization.

 

Projection Details

These screens are read only. The Projection Details section is comprised of three sections:

 

Supply Details

The Supply Details screen will provide a makeup of the supply by product type and supply type.

 

  1. The makeup of the Product Type is:
    1. Eggs:
      • Red or Purple: Disposal
      • Blue: Opening or Beginning Inventory
      • Gray: Produced
    1. Chicks:
      • Yellow: Produced
      • Blue: Opening or Beginning Inventory
  2. Supply Type – describes the type of supply: Disposal, Opening, Purchased or Produced. Available options are:
  3. Inventory Date – date of inventory.
  4. Hatchery No – defines the hatchery.
  5. Parent Complex Entity No – identifies the entity being utilized.
  6. Breed No – breed being utilized.
  7. Egg Age – age of egg when utilized.
  8. Flock Age – age of flock when utilized.
  9. Production Date – the date the eggs are produced.
  10. Set Date, Transfer Date and Hatch Date – indicate the date the eggs were set, the date the eggs were transferred, and the date the eggs hatched.
  11. Hatch %, Saleable % projected percentages used to calculated chicks hatched and sold.
  12. Egg  the amount of eggs produced, projected or purchased.
  13. Proj Chicks – the total number of chicks hatched.
  14. Chicks the saleable amount of chicks.

 

Utilization Details

The Utilization Details screen will provide an outline of how the product is utilized by Demand Type (Chick Sales, BRPA Placement and Egg Sales).

 

The most used columns in the Utilization Details section are the following:

  1. Processing Sequencedefined in the Sales Order and used to identify the order of importance. 0 is no importance, 1 is first, 2 is second, etc.

  2. Demand Type – when the usage requirement is sourced: BPA Movements, BRPA Movements, Chick Sale, Egg Sale or Surplus Set.

  3. Eggs Set/Sold – the date that the eggs are utilized for set or sale.

  4. Chicks Placed/Date Sold –  the date that the chicks were sold or placed.

  5. Demand Date – date that the product is required to be utilized.

  6. Demand ID – where the demand is being created: a destination entity/product/demand date or sales order number.

  7. Egg Set Demand ID – identifies the Order No for which the eggs were set.

  8. Destination Name –  customer name or the entity that the product is being placed.

  9. Hatchery No – identifies the hatchery setting the eggs or selling the chicks.

  10. Parent Complex Entity No – the entity that is producing the product for utilization.

  11. Breed No – identifies the breed of the entity being used.

  12. Flock Age – the age of the entity when the eggs are produced.

  13. Egg Age – the number of days from production to set or sale.

  14. Production Date – the date that the eggs were produced if in inventory or projected date of production if eggs are being projected.

  15. Set Date – will be displayed if the eggs have been set or planned to be set on a specified date

  16. Hatch Date –will be displayed if the eggs have been set or planned to be set on a specified date. The Set Date will be calculated for projected hatches based on the number of days defined in Registry>Hatcheries>Eggs Set>Incubation Days.  If the eggs do not have a set date, the value will be displayed as 11/30/1899.

  17. Hatch % – the actual or projected hatch percentage for the selected product line.

  18. Saleable % the actual or projected saleable percentage for the selected product line.

  19. Eggs Set/Sold  the number of eggs that are required for the utilization of eggs or chicks.

  20. Proj Chicks  the number of projected chicks based on the Hatch %: Eggs x Hatch %.

  21. Chicks Placed/Sold – the number of chicks utilized for the placement or order.

  22. Color coded lines:

 

Inventory Details

Inventory Details identify the remaining egg left in inventory. The screen can be viewed as eggs or chicks by filtering the Product Type.

 

Transactions

To view the transaction details of a line, right-click in the HPA Projections>Weekly grid. Records in these screens can be edited or new records created. The Transaction screen is comprised of four sections:

 

 

Orders

In the Transactions right-click menu, select Orders. All Sales Orders associated with the line will appear. By double clicking on the order, the order will appear and can be edited if needed. New orders can also be added here by selecting the button or F4.

 

 

BRPA Placements

A BRPA Movement must be created prior to assigning the Movement Schedule to the HPA profile. If no profile is set up and assigned, the screen will be blank. Double-click on a line to edit the record or choose the Edit button from the menu.  A new BRPA placement can be added by selecting the button or F4.  Placements can only be added if the BRPA Placement profile is created.

 

 

BRPA Targets

All BRPA Targets will appear. A BRPA Target must be created prior to assigning the Target to the HPA profile. If there are no profiles set up and assigned, the screen will be blank. Double-click on a line to edit the record or choose the button from the menu.  A new BRPA Target can be added by selecting the button or F4.  Targets can only be added if the BRPA Target profile is created.

 

 

BPA Placements

All BPA Planned Movements will appear.  A BPA Placement must be created prior to assigning the Placement to the HPA profile. If there are no profiles set up and assigned, the screen will be blank. New placements can be created or existing placements can be edited in this screen. BPA Placements can only be added if the BPA Placement profile is created.

 

 

HPA Planning

The planning node is where Product is assigned to orders, eggs are assigned to setters and chicks are assigned to deliveries.

The HPA Planning section is comprised of the following components:

 

Egg Distributions

Egg Distributions is the projection of specific eggs allocated to the orders of that date by hatchery. If the distribution date and hatchery have the actual eggs in inventory, then the HPA projection will populate the allocations automatically for the user to adjust. The HIM Egg Distributions screen allows the user to allocate eggs to egg orders, chick orders and internal placements.

Create a New Egg Distribution

  1. In BMTS>HPA>Planning, select Egg Distributions.

  2. Click the button or F4.

  1. In the New Record dialog box, enter the Date - Set or Sold date of the eggs.

  2. Enter the Hatchery No.

  3. Enter the Profile No.


  4. Click the OK button, and the Entity Allocation screen will appear.

Entity Allocation > Demand

The Demand grid displays the demand from existing egg orders, chick orders and internal placements.  For each egg distribution date, there will a transaction type for Surplus Set where the user can set additional eggs that are not allocated to an individual order or placement. When the egg distribution is posted, the eggs become available for the Egg Set Distribution. *Note: The entire day must be posted at the same time. You cannot post one order and then post another order later.

 

 

Egg Sources > Egg Allocations

When the sources have been determined for the order via Import from HPA or Allocate direct, the sources will appear in the Egg Allocations Grid.

 

 

Cross Utilizations

If the order was sourced from cross utilizations, the egg sources will be displayed in the Cross Utilizations grid. If  no eggs were cross utilized for the order, there will be no sources appearing in this grid.

 

 

Assigning Eggs to Orders

Options for assigning eggs to orders are:

Short Range Egg Distribution Options

Import Allocations from HPA > Inventory

This option will allocate the eggs in inventory to the selected order.  This option is recommended when all eggs are in inventory.

 

 

  1. Right-click on the order that to be sourced.

  2. Select Import Allocations From HPA.

  3. Select Inventory.

  4. Egg sources will be assigned in the Egg Allocations Grid.

 

 

  1. If you want to keep this allocation, go on to the next order and repeat steps 1 – 3.

  2. If all orders are sourced to your satisfaction, close the screen, which will take you to the Egg Distribution index screen.

  3. Highlight all the orders for this day.

  4.  In the menu ,select the Post option, the green check  . This will post all the records for that day.  *Note: The entire day must be posted.  

  5. If you do not like the system generated sources, there is another option.

Allocate Direct > Inventory

  1. Highlight the Order in the Demand screen and select Allocate Direct>Inventory.

    1. This will allow the user to manual select the eggs of their choosing from inventory for the selected order. This is also the option to allow the user to manually select egg sources.

 

 

  1. The Egg Source (inventory) screen will appear.

  1. In the Eggs to Allocate column, enter the number of eggs from the Available Eggs column.

 

  1. Click the OK button.

  2. If all eggs are not selected, the remaining eggs will go back in inventory.

  3. After the order/s have been manually sourced, close the screen. This will open the Egg Distribution index screen.

  4. Highlight all the orders for this day.

  5. In the menu, select the green check mark, Post button.Tthis will post all the records for that day.  *Note: The entire day must be posted.