Food Service Menu Explosion INVENTORY:

How to use the Component Inventory System:

Elements of the system include Product sales, stock purchases, stock waste and transfers, sales product explosion into inventory, stock inventory, and functions to report and/or view all detail of the database.

Following are guides for proper systems use.

Building files for the Component Inventory:

1.	Create Inventory stock file.

 Each stock item has an SKU or UPC called its index.  The Inventory Maintenance dialog is used to create inventory records.  The acronym SKU means Stock Keeping Units and UPC means Universal Product Code.  UPC indices are usually bar codes used on scanned items.  SKU indices are designed by the end user.  The indices used in this system range from one (1) to twenty (20) alphanumeric digits.  Most applications use twelve (12) digits, which is the standard for the UPC.  Item indices are right justified.

2.	Create Product Sales records.

	A. Products are the item you sale which then deplete inventory.  Product indices (PLU’s or Price Lookup Units) identify product records in the inventory database.  Use the SALES entry dialog or the merge utility (MRGFDS32) to add sales to the inventory database.  PLU indices are 1-20 alphanumeric digits left justified.

3.	Create Stock Explosion records.

Explosion records (menu modeling) define the distribution of stock items that make up a product.  An example would be selling one case of beer may deplete inventory 24 bottles where the stocking units are bottles and not cases.   Use the Menu Modeling dialog to create explosion records.  The index to explosion records is the product PLU indices.  SKU and UPC indices identify the stock items that make up the menu explosion group.

4.	Order of Processing:

      A. Start new cycle (day, month, or year).
      B. Enter SALES.
      C. Enter PURCHASES.
           D. Enter WASTE, TANSFERS IN and OUT.
           E. POST Sales and Purchases.
           F. Run reports as necessary.|
           G. Enter PHYSICAL inventory quantities.

Physical counts should not be entered until the inventory is current.  When posting is executed, sales pass through the explosion records to deplete inventory stock.  Purchases are added to stock on hand at posting time.  These processes should be done in the proper sequence to insure that stock status corresponds to the condition when items are counted and the physical counts are entered.  

When physical counts are entered, the Quantity On Hand (QOH) is recomputed as are Over/Short values.  Quantity Over/Short is accumulative; i.e. the current short will add to the last is compensate for work in process or items not counted at this time.