...
Image 1: Lifecycle of Raw Material, Work in Process, and Finished Good Items
Item Types
NorthScope supports multiple ‘Item Types’ to help organize your item master. These Item Types behave one of two ways with respect to managing perpetual inventory balances.
...
While these types of codes are physically managed in nearly all food companies, not all companies manage them within their ERP system. These are discussed separately from Packaging and Ingredients because they often have a much higher cost, may be in multiple physical locations, and have expiration dates that must be managed.
Image 2: Product Flow
As raw product is offloaded it is “Graded” (separated by size and/or quality) into 1 of 3 different WIP codes. Each WIP code then becomes the main input for one or more finished good item codes. Assume the truck is unloaded in 45 minutes and each of the 45 WIP Totes were immediately moved to one of 3 different production lines as it was filled. On average, one tote is filled and issued to a production line each minute. As one tote is emptied, the next one is consumed, until they are all gone. If this were recorded manually, the minimum data entry would be:
...
What makes Items unique?
In some systems, the Item Master is nothing more than a list of product codes that are only used to save users from manually typing descriptions on sales invoices. In NorthScope, the Item Master is the foundation of the entire system. To best capitalize on many of the features in NorthScope, including those you may not implement until a future date, a dedicated effort should be placed on constructing the Item Master.
...
There There are several factors to consider when creating your Item Master so simply cloning the Item setup from your current system may not be best choice. NorthScope may have different functionality, you may want to manage aspects of your business differently, and/or you may want to set it up to accommodate growth or expansion. There are several areas within NorthScope that rely on Item ID’s including: Inventory, Sales Order, Pricing, Sales Programs, Costing, Manufacturing, and Sales Analysis so having a well thought out plan may save you from costly rework later. Because of this, you should consider this from several angles.
...
As you are going through this exercise, you may discover that you have too many options for how you package your product. Companies often find themselves in this situation over time because they may be selling anything “requested” rather than sticking to an intentional list. For example, if you sell Sockeye Salmon Portions, of various portion sizes, packed in a 10# Case your sales may look as follows:
| Portion Size | # Sales Orders | Total Lbs. |
|---|
Times Sold Transactions
| 2-3 oz. | 5 | 80 |
| 2-4 oz. | 475 | 10,250 |
| 3-4 oz. | 12 | 250 |
12
| 3-5 oz. | 425 | 18,000 |
| 4-6 oz. | 150 | 5,000 |
| 5-6 oz. | 150 | 2,500 |
| Totals |
| 1,217 | 36,080 |
You need to decide if the cost/effort of maintaining all these items is strategic or if simplifying by offering fewer options would be better. The additional labor and management cost of the few orders for 2-3oz or 3-4oz portions may be costing you substantially more per pound in labor than the 2-4 or 3-5 oz.
...
We strongly encourage you to NOT to use use full length intelligent Item Codes.
To re-label or not to re-label
...
An on-screen inquiry of non-lot tracked inventory would look like this:
Lot Tracked
...
An on-screen inquiry of lot tracked inventory would look like this (assumes company owned product):
Even if you decide to setup your items as Lot Tracked, you need to decide what “footprint” you want your lots to cover in NorthScope. There are several procedural options for adding this detail to NorthScope.
...
In the figure below, there are 9 cases from 5 production batches meaning there are 5 unique inventory lots represented. If an order were placed for 3 cases, you would need to ensure the correct Lots were allocated so that your perpetual inventory balances remained accurate. The person picking the order would need to accurately record which Lots they took, and you would need to correctly allocate the same Lots to the order. A mistake on this simple order could be the difference in failed product recall.
In a company with a low volume of orders containing one or two unique items, that has easy communication with the warehouse, this will be much easier to maintain than it would in a company doing more than 50 orders a day containing an average of 10 unique items that are shipping from multiple cold storages.
...
The easiest step in managing variable weight items is recording the initial production, but for companies that sell in less than pallet quantities, the hardest part comes later. In the figure below, there are 9 Variable Weight cases in inventory each weighing between 10.00 and 10.25 lbs.
If an order was placed for 3 cases, you would need to ensure the correct weight was allocated to it so that billing and perpetual inventory balances were accurate. The person picking the order would need to accurately record which cases they took to give you the correct total weight and you would need to correctly allocate the same amounts against the order. A mistake on this simple order could be the difference between 30.06 lbs. and 30.63 lbs.
...