One of the most important functions in setting up new items (or modifying existing ones) is setting up correct multipliers for your item.
Most reporting tools in DL – including COGS, IvA, TvA, etc – are affected by what your multipliers are.
The multipliers you set also affect how you count your items during an inventory, how you will use them in recipes, how you will order and receive them, etc.
Given how many facets of DL these multipliers impact, it’s easy to see the importance of correct multipliers for accurate, reliable data.
To learn how these are used in reporting visit Supply Chain Reporting
Let’s start by defining key terms we’ll be using:
Now that we’ve seen a handful of examples, let’s list out some common conversions and on the next page, answer some questions and actually fill out some examples (pop quiz style). This will help you apply these concepts. The answers will be on the next page after to review if you answered correctly.
Common Conversions:
16 oz = 1 lb (pound) | 128 oz = 1 gallon |
16 oz = 1 pint | 1 gallon = 16 cups |
8 oz = 1 cup | 1 lb = 2 cups |
32 oz = 1 quart | 4 quarts = 1 gallon |
1 oz = 6 teaspoons | 1 lb = 96 teaspoons |
1 oz = 2 tablespoons |
Let’s look at a couple examples on how multiplier conversions work.
Example 1: We have an 8 oz Sirloin Steak that has a package size of 40 lbs. We want to inventory it by the pound but our recipes use it by the each (EA) (for example a recipe will call for one 8 oz steak).
Since we want to inventory this by the pound, our Inventory Measure would be LB (Pound). For each order of this item (each case), according to the package size, we get a total of 40 lbs, so our Inventory Multiplier would be 40 LB.
Since our recipes call for a single 8 oz steak our Recipe Measure would be EA (each). Now to calculate our Recipe Multiplier, we need to ask how many EA (Rec Multiplier) there are in one LB (Invt Multiplier). Since an EA refers to an 8 oz steak, and there is 16 oz in 1 pound, there would be 2 steaks (each) in 1 pound. So our Recipe Multiplier would be 2 EA.
Example 2: We have a 7-ounce boneless chicken breast that we order in a case. This case has 6 bags of 12 breasts. Although I order it by the case, when we are counting inventory we count how many individual chicken breasts we have on hand. Our recipes also call for individual chicken breasts (i.e. a recipe will call for one 7oz breast).
Since I order this by the case but want to inventory it by the each, the Inventory Measure would be EA (each). Now, the inventory multiplier would be 72 because in each case, we have 72 individual chicken breasts (6 bags of 12 à 6 x 12 = 72). So our Inventory Multiplier on our bid file would show 72 EA.
Since our recipes use this item by the individual breast, our Recipe Measure would be EA (each). Now for the Recipe multiplier, we need to determine how many EA (recipe measure) are in an EA (inventory measure). There is 1 EA in every EA so our full Recipe Multiplier would show 1 EA.
Example 3: We have an 8-ounce chicken breast with a package size of 6 - 5LB bags. We want to inventory this item by the bag, but use it in recipes by each individual chicken breast.
Since the package size is 6-5LB bags, and we want to inventory it by the bag, our Inventory Multiplier would be 6 Bags.
Since our recipes call for this item by the individual breast, our Recipe Measure would be EA. Now to derive our recipe multiplier, we need to consider how many EA (recipe measure) are in a Bag (inventory measure). Since each bag holds 5 lbs of chicken breasts, and each breast is 8 ounces, seeing how there are 16 ounces in a pound it would take 2 breasts to make 1 lb. So for every pound, we have 2 breasts, so we need to multiply that by the total in each bag (5). So our conversion is 5 x 2 = 10. Our Recipe Multiplier would be 10 EA.
Example 4: We have that same 8-ounce chicken breast with a package size this time of 1 case. However, the item has a catchweight set to 40 lbs. (In other words, there are approximately 40 lbs in a case). We want to inventory these chicken breasts by the pound, but they’re used in recipes by the EA.
Since we want to count this item in our inventories by the pound, our Inventory Measure would be LB. As our catch weight tells us, there are 40lbs to each case we order so our Inventory Multiplier would be 40 LB.
Since we recipe this item by the individual 8-ounce chicken breast, our Recipe Measure would be EA. Now we need to find out how many EA (recipe measure) are in an LB (inventory measure). Since each breast is 8 ounces and there are 16 ounces in 1lb, it would take 2 breasts to make 1 lb. Therefore our Recipe Multiplier is 2 EA.
Example 5: We have a garlic butter spread with a package size of 4 – ½ GAL (four half-gallons). We want to inventory it by the half gallon, but our recipes use this item by the ounce.
Since we want to count this item by the ½ gallon, our Inventory Measure would be “1/2 Gal.” With a pack size of 4-1/2 Gallons per case (order) our Inventory Multiplier would be 4 (1/2 Gal).
Since our recipes use this item by the ounce, our Recipe Measure would be OZ. To figure out the recipe multiplier we need to know how many ounces (recipe measure) are in one half-gallon (inventory multiplier). Since 1 GAL = 128 OZ, a half gallon would be 64 ounces. So our Recipe Multiplier is 64 OZ.
Additional Examples:
*Pack size 12 - 16 oz bottles
Inventory Multiplier is 12 bottles and the Recipe Multiplier is 16 ounces (how many ounces is in ONE bottle)
*Pack Size 6 Gallons
Inventory Multiplier is 6 Gallons and the Recipe Multiplier is 128 ounces (how many ounces is in ONE gallon)
*Pack Size is one case with 24 bottles
Inventory Multiplier is 1 case and the Recipe Multiplier is 24 bottles
If the Inventory measure is +bottle+ instead of the case then the Inventory Multiplier is 24 bottles and the Recipe Multiplier is 1 bottle
*Pack size is 2 boxes with 24 ounces per box
Inventory Multiplier is 2 boxes and the Recipe Multiplier is 24 ounces (how many ounces in ONE box)
-If the Inventory Multiplier is Pound and the recipe multiplier is ounces, then the Inventory Multiplier would be 3 pounds (convert by 2*24=48/16=3) and the Recipe Multiplier would be 16 ounces
-If the Inventory Multiplier is boxes and the recipe multiplier is also boxes, then the Inventory Multiplier would be 2 boxes and the Recipe Multiplier would be 1 box
For items that are not included in recipes set RMX (Recipe Multiplier) = 0. This way those items will report as just an Actual cost in TvA reporting. Examples of these are Soda Syrup and table condiments.
On the following examples, please fill out the “ RMX” (Recipe Multiplier) and “IMX” (Inventory Multiplier) for each item.
Take note of the “Pk/Size” (Package size) as that determines how the distributor sends the item.
Also note the measure is already set for each item.
1.
2.
3.
4.
5.
Answer Key:
1.
2.
3.
4.
4
5.
Bid File items that are not inventoried do not always need an ingredient mapped* To set up these items follow the steps below:
Table of Contents
For additional questions or assistance please submit a support ticket by visiting the Decision Logic Help Center.