Inventory Master

Selecting the Inventory Master function provides access to all of the inventory items that are set up in the system.

 

Highlighting and selecting an inventory item will bring up the Inventory Item maintenance screen. This screen controls how the system tracks the items, from the stocking unit that the user orders from the vendors all the way down to the portion size that is used on the menu item.

 

 

Inventory Item

This is the name of the inventory item as it should appear on your inventory reports as well as how it will be referenced throughout the PrISM system.

 

Sort Order

This is the order in which the item will show up on inventory reports.

 

Inv. Cycle

This is the frequency of when a physical inventory is taken for this item. Your choices are D - Daily, W - Weekly, M - Monthly, B - Biweekly, or N - None.

Note: If W is entered, the system assumes that a physical inventory will be taken on the last day of the week.  If M is entered, the system assumes that a physical inventory will be taken on the last day of the month.  If no inventory is taken on these days, your inventory "usage" numbers for these items will be zero and as such, you will not see the Food Gap number on the Weekly Sales Recap.  Until an inventory is taken, the ending inventory will be calculated by subtracting the Ideal Usage from the beginning inventory.  Performing counts properly is critical to properly Inventory usage.

 

Cost Type

This is simply a definition of this item's inventory type.

 

Reorder Level

This is the level at which you would like the system to prompt you to order more of the item.  Enter this value as Stocking Units. This information can be seen on the  Re-order Level report.

 

Reorder Qty

This is the number of Stocking Units you want the system to prompt you to order when applicable.

 

Key Ingredient

Marking an inventory item as a Key Ingredient will allow it to be tracked on a Makeline Monitor.  This must be configured by Microworks Tech Support.

 

Key Ing. Code

If the item is marked as a Key Ingredient, this Code will be displayed on the Makeline Monitor next to the Count of the Key Ingredient.

 

Inactive

This will set the item as inactive.

 

Assembly Item

If this inventory item is created by combining other inventory items, i.e. pizza dough or sauce, then this box should be selected.  This tells the PrISM system that this is an assembled item.  Because of this, the Stock Price is automatically calculated base on the portions of each inventory item that is used to assemble this item.  See Assembly Item Setup for more information.

 

Batch Description

If this inventory item is an Assembly Item (see above), then this field becomes active allowing you to enter in a basic description for this batch.

 

Cost Center

A Cost Center can be assigned to each individual inventory item.

 

Location

An Inventory Location may be attached here.

 

Vendor Inventory / Stocking

 

Item Number

The vendor's item number.  If you do not purchase this item from a specific vendor, you may assign an arbitrary number to the item.  This is the number that is used when entering invoices. This number can have up to 6 characters and must be unique.

 

Stock Price

The price you pay per Stocking Unit when purchasing an item.

 

Stocking Unit

The unit in which you stock this item. This is a free form, four character field.  Examples of typical stocking units are cases, boxes, bags, jugs, etc.

 

Stocking Mult

The Stocking Multiplier is the number of Counting Units in the Stocking Unit.  For example, if an item is purchased by the case and there are four cans per case, the Stocking Multiplier would be four.

 

Vendors/Stocking

You may specify alternate vendors from which you may receive inventory items.  With this, you may also specify alternate means of pricing, stocking units, counting units, and portion amounts when an item is received from a specific vendor.  This option provides greater flexibility in maintaining multiple vendor options.

 

Counting Unit

The unit in which you count the item when doing a physical inventory.  This is a free form, four character field.  This is also the unit of measure that appears on the Daily Inventory screen.  Examples of typical counting units are cans, bags, each, etc.

 

Price

The price per counting unit is automatically calculated by the PrISM system.  It is simply the Stock Price divided by the Stocking Multiplier.

 

Portion Mult

The Portion Multiplier is similar to the Stocking Multiplier.  The Portion Multiplier, however, is the number of portioned units per Counting Unit.  For example, if you have a 32oz can of pizza sauce and portion it out by ounce, then the Portion Multiplier would be 32.

 

Portion Unit

This is a free form, four character field defining how this item is portioned out.  Examples of typical portion units are ounce, each, piece, etc.

 

Portion Price

The Portion Price is automatically calculated by the PrISM system.  It is simply the Counting Unit Price divided by the Portion Multiplier.  This shows you how much you are paying for each portion unit.