Formulation Requirements Report (MCR770)

This program allows the user of the FACTS system to print up to five time periods of formulation quantity requirements based on planned production. The user prints a listing of what formulas will be required to produce, what ingredients will be needed, what finished items are required to produce, and what packaging items are needed based on all planned production that has been entered in the Formulation Planned Production Entry program. At the end of the report, the user may remove the planned production information, convert to production or leave requirements alone.

The user has the option to:

Select the beginning and ending formula to print.
Select warehouse(s) to print.
Print detail information - ingredients, finished items, packaging items.
Determine the number of time groupings.
Determine the number of days to be used for automatic date increments.
Select the dates for time groupings.

Report information includes the following:

Formulas: Formula number, description, unit of measure, required amount for each time period and total required. The total number of formulas listed is also included.
Ingredients: Item number, on hand, on order and committed quantities, stocking unit of measure, required amount for each time period and total required. The total number of ingredients listed is also included.
Finished items: The same information as ingredients. The total number of finished items listed is also included.
Packaging items: The same information as ingredients. The total number of packaging items listed is also included.

Use the following fields to print the Formulation Requirements Report:

1. Beginning Formula

Enter the beginning formula to print. Select the $image\ex_allft.gif$ icon to start with the first formula code on file. Press F2 or select the $image\find_shg.gif$ icon to perform a search.

2. Ending Formula

Enter the ending formula to print. Select the $image\end.gif$ icon to start with the last formula code on file. Press F2 or select the $image\find_shg.gif$ icon to perform a search.

3. Warehouse

Enter the warehouse to print requirements. The entry must be a valid warehouse. Press Enter (CR) to default to the warehouse assigned to the terminal. Press F2 or select the $image\find_shg.gif$ icon to perform a search.

4. Include detail

Select the checkbox to include requirements of the ingredients, finished items and packaging items needed to produce the formulas. Press Enter (CR) to default to N.

5. Groupings

Enter the number of date groupings to print (2-5). Press Enter (CR) to default to 5.

6. Auto Increment

Enter the number of days to be used for automatic date increments (0-99). Press Enter (CR) to default to 7. Press $image\add_shg.gif$ to manually enter the dates of time groupings.

7. Dates

Enter the ending date for the first date grouping. Press $image\sysdate_shg.gif$ to default to the system date. If automatic increments are to be used, the next dates are calculated automatically. If automatic increments are not used, enter each group ending date up to the number of groups selected.

8. Check report. Do you wish to remove printed records, convert to production or neither?

Enter whether to R-remove planned production records for the formulas just printed, C-convert planned production just printed to production tickets, or N-neither, where no updating occurs.