RIMAS for UNIX Software

To: All Input Scale Users of SLG

From: The SHARED LOGIC Group, Inc.

Re: Formula Pricing in the Scale Input Program

Date: April 26, 2002

This outlines the steps to be followed to implement formula pricing in the “Input Scale Receiving / Paying” program:

1. Enter the Market Prices

This is done in the “Maintain Market Prices” program on page 2 of the Purchase Contracts Menu. Market prices are entered for all magazines on which you will base formula. These might be AMM Dealer, AMM Consumer, Iron Age, Yellow Sheet, etc. Each market that you use must have a two-character code assigned to it, such as “AD”, “AC”, “IA”, “YS”, etc. Enter the market prices as follows:

a. Enter the first of the Market Codes that you selected. Examples from the discussion above are “AC”, “IA” and “YS”.

b. Enter the Market Description, such as “AMM Consumer” or “Iron Age”.

c. Enter the dates of the previous, current and next price list you plan to enter. These dates are for informational purposes only.

d. You will then enter a row for each commodity in the price list. There is room for 15 rows on the screen. If you need more than 15 rows, you will be able to enter “NXT” at the bottom of the screen to move from one set of 15 rows to the next. Entering “TOP” will always cause the program to return to the first 15 rows. You will use “ADD” to add a row, if one is still unused. Entering “DEL” and the row number, such as “DEL5” will cause a row to be removed from the price list. You should use “DTE” to change the dates at the top of the screen when a price list is changed. Pressing the [Enter] key alone causes the program to return to the Market Code at the top of the screen so you can enter or maintain another market’s price list.

e. You will enter the following on each row:

1) The market’s Commodity code. This need not be in your own inventory.

2) The market’s commodity Description. If the commodity code is in your inventory, you may press enter to default to your commodity description. If the commodity is not in your inventory, you must type the description.

3) Enter the Low-Price and UM. This U/M will be used on your scale tickets.

4) Enter the High-Price. Notice that the same U/M is always used.

Enter a separate row for every commodity in the market price list.

You can use the “Print Market Prices” program to list your entries for editing purposes.

2. Enter the pricing formula.

This is done in the “Maintain Vendor Pricing & Formulae”, as follows:

a. Enter your Vendor # and your Commodity #. This will display an existing record, or allow you to create a new one.

b. At the left center, enter the formula factors:

1) Based on Market will be a two-letter code for your market, such as “AC” for AMM Consumer prices, “AD” for AMM Dealer prices, “IA” for Iron Age, “YS” for Yellow Sheet, etc. You can only use a market code that you already created above.

2) You might find “Heavy Melting Steel” in the price list, but you don’t actually buy that grade. That’s okay; you can still use “HMS”, for example, as you did when entering the market prices earlier.

Referring to your market prices commodity coding, enter the proper code in the Using Commodity # field. For example, you might have entered Unprepared P&S as your commodity at the top of the screen, but price it based on HMS in the market prices. If so, enter “HMS” here.

3) Your actual formula is entered in the And Variance of field. If your formula is to pay a dollar amount above or below the market price, enter the dollar amount. If your formula is to pay a percentage above or below the market price, enter the percentage followed by a percent sign (%). If you pay below the market price, enter a minus sign (-) in front of the dollar amount or percentage. When used, percentages are entered as percent values, not decimal values. For example, 15 percent below market price is entered as “-15%”, not -.15%. Decimal points and digits are not required, unless required in your formula.

4) Enter a “Y” into the Bypass Prc Chg field.

5) You saw earlier that there are actually low side and high side market prices. If the formula is based on the low side price, enter a “1” in the Price Code field. If it is based on the high side price, enter a “2”. If it is based on an average of the low side and high side price, enter a “3”. This code not only tells the program which price to use, but also triggers the calculation of the formula price in the “Input Scale Receiving / Paying” program.

You will enter a formula for every Vendor and Commodity that you buy and want priced by formula in the scale input program.

3. Using Formula Pricing in the Scale Receiving program.

You don’t really have to do anything more to get this to work.

When you enter your commodities on your scale tickets, the program will look at the Vendor Price and Formula to see if there is a “1”, “2” or “3” in the Price Code for the Vendor and Commodity you are paying. If there is, it uses the Based on Market Code and Using Commodity # to look up the row from the Market prices. It then applies the formula to the low side, high side or average price.

The resulting, calculated price and U/M are displayed on the Scale Receiving screen. The message “VENDOR/COMMODITY PRICE & FORMULA” is displayed immediately below the price so that you know it was calculated from the formula.

You may proceed through the entries on the scale ticket, using formula pricing for any that you have set up as described above.