Formulation Inquiry (MCI620)

How To

This program allows you to display information about any formula. When you first access the Formulation Inquiry program, you can use the Go To field in the upper portion of the screen to locate specific finished items. Select the $image\find_shg.gif$ icon to search for finished items.

The Go To field is case sensitive. This means that if you enter i100 to lookup an item number when someone entered it as I100, the item record you are looking for will not appear in the browser.

You can select the $image\filter.gif$ (filters) icon if you want to limit the number of records that appear in the inquiry browser. You can also choose Options-->Filter Values.

In the Formulation Inquiry program you can access 8 views of information from the center section of the screen.

Inquiry information for each formula includes:

Ingredients
Finished
Planned
Production
Cost
History
Requirements
General

In the lower portion of the screen, FACTS displays information for the selected finished item.

To search records for the finished item, use the Starts From option in the lower left-hand corner of the screen. This search uses only the first column of the Layout list for the search. To use Starts With, enter one or more characters to match the beginning of the records for the search. Then, choose the Go button or press Enter to begin the search. Select $image\ex_allft_shg.gif$ to display the first record on file for the finished item; press $image\excl_right_shg.gif$ to display the next record. The Starts From option is available for all inquiry views except General.

For example, if you enter D as the Starts With in the Item Lookup and press Enter, the Lookup list will redisplay records showing the first item that begins with a D. If there are no matches for your selection, a message displays and the Lookup list does not change.

When you are finished reviewing formula items, press Exit to return to the Manufacturing Control main menu.

Formulation Inquiry View Details

The following fields are involved in displaying formula information:

Ingredients	Displays ingredient information including the item number, description, number of units, unit of measure and memo.
Finished Items	Displays the finished items in summary. Summary information includes the item number and description, stocking unit of measure and the amount of formula required for the finished item. Press the Packaging button to display the Packaging Items for the Selected Formula (MCI622) program for packaging information for the finished item.
Planned	Displays the planned production currently in the formulation system for the formula. Planned production is displayed in date order. You can to display requirements for ingredients or finished items for the highlighted formula. Press the Ingredients button to display the Production Planning Ingredients (MCI623) program for the highlighted formula. Press the Finished button to display the Production Planning Finished Items (MCI623) program for the highlighted formula.
Production-	Displays summary information of the production tickets in process for the formula. Summary information includes for each ticket, ticket number, status (E-entered, P-printed and C-confirmed), entry date, planned production date, production date (if not confirmed, date is blank), units planned to be produced and actual units produced. Press the Line Detail button to display Production Detail for the Selected Ticket (MCI624), where ticket detail is displayed in the same screen format as it was entered.
Cost	Displays costing information by warehouse to produce one formula. Information for each ingredient item includes item number and description, units needed to produce one formula, stocking unit of measure, cost, costing unit of measure and extension. The cost per unit is listed along with the total information, which includes the ingredient, overhead, labor and total cost. Press the Next Whse button to view costing information for the next available warehouse.
History.	Displays the history of the item. Information by warehouse includes month-to-date, year-to-date and prior year units produced and the last date produced
Requirements	Displays the requirements for producing a number of units as entered by the user. Press the # of Units button to enter the number of units to be produced The requirements to produce the finished item are displayed including the following for each component: the item number and a part of the description, units required, stocking unit of measure, on hand, on order and committed quantities. An asterisk (*) displayed next to the units indicates that the number of units required is greater than available (available = on hand + on order - committed).
General	Displays additional information about the formula item, including the overhead percentage, packaging and labor costs, standard production quantity, stocking unit of measure and production waste percentage.