Docstoc

PRICING

Document Sample
PRICING Powered By Docstoc
					        MENU 5
        PRICING
By: Steve Moeller & Ron Stogsdill, Sr.
         MENU 5 PRICING
 Increase gross profit and establish an
  efficient pricing matrix.
 List Price and maintaining multipliers.

 Menu 5 has a new look that will enable
  workflow to be user friendly.
 Automatic Updates of Contract Pricing.

 Q&A session with Database Programmer
  and a Johnstone store pricing expert.
              List Price Matrix
   List Price Multiplier
    – Change “Thinking” to List Less on most
      products
   Mark-up from Cost (branch or direct)
    – Limited Use – Commodities
    – If Cost Goes Down, So Does Sell
   Fixed Price (Old Menu-5.2)
    – Labor Intensive to Maintain (review each qtr)
    – Lost Margin Opportunity when costs going up
    – Use only when there is no alternative
      Programs & Contracts
 Define different terminology
 Move from Contracts to Programs

 Stock status “P” option

 Stock status “C” option

 HOT-1 HOT-2 KEY spreadsheets –
  view of Customer Programs
 Daily reviews – EOD reports & JEN
        List Price Options

 Product  master maintenance
  (12.3.2.2) – change each price –
  auto change the list price
  immediately without waiting for EOD
  to calculate
 End-of-day program to refresh List
  Price on Non-catalog items (auto
  multiply Each/Qty Prices by 2.2223)
        List Price Multipliers

 Customer   ABC Ranking Parameters
  (35.23) – automatically runs at EOM
 Customer ABC Report (12.2.40)

 List Price Multiplier Upload (12.2.42)
  from Excel Spreadsheet
  Column A = A.CUST.NO
  Column B = LPM (ie .4750)
Old Menu-5 Pricing
New Menu 5
         Price Quantity Maintenance
         15. Pricing Matrix (old 5.33)
Product Master Maint. field (#21-Menu 5.33) - Enter a „Y‟ in this field to use the
pricing from Menu 5.33 (ALL customer) in all cases, even if it‟s higher than the
each price. Also, the flyer pricing will be blocked, and you will NOT have to block
the corp update of this product (Menu-12.3.2.2.9, field 4).
Price Quantity Maintenance
15. Pricing Matrix (old 5.33)
         Price Quantity Maintenance
         15. Pricing Matrix (old 5.33)
DPOINT - Points to a bucket:     CPOINT - Points to a cost:
 0 = Each Price                         0 = Each Price
01 = First bucket                      -1 = Branch Cost
02 = Second bucket etc...              -2 = Average Cost
06 = Last bucket                       -3 = Direct Cost
23 = LIST PRICE

If a matrix price is used, a code will display in the lower left hand
corner as follows:

CP – Customer, Product    PP – Program, Product    SP - Cust.Class, Product
CG – Customer, Category   PG – Program, Category   SG - Cust.Class, Category
CC – Customer, Class      PC – Program, Class      SC - Cust.Class, Prod.Class
CT – Customer, Type       PT – Program, Type       ST - Cust.Class, Prod.Type
CV – Customer, Vendor     PV – Program, Vendor     SV - Cust.Class, Vendor

Note: Program name will also display (i.e. PP*CON-1)
           Hierarchy for Pricing
• Individual contracts entered in 5.2 – if finds something
uses this price, if not moves on to …
• Program contracts entered in 5.2 – if finds something
uses this price, if not moves on to …
• Searches all of 5.33 to find the lowest price in any bucket
and uses that scenario, then compares this price to the
each price & lot pricing and uses the lowest price
   •    Any customer specific pricing setup in 5.33 (even for
      customer ALL) will always override program pricing,
      even if that program happens to be lower than the
      customer specific pricing.
   • Any Product Specific Pricing setup in 5.33 will
      always override vendor/product class/product
      type/category pricing even if that price happens to be
      lower then the product specific pricing.
          Hierarchy for Pricing
 Flyer Price
 Each Price

 List Price

 Quantity Break or Lot Pricing

 Discount Price

 Contract or Program Price

 Price Matrix
     Price Quantity Maintenance
     15. Pricing Matrix (old 5.33)
New updates:
 DPOINT - Points to a bucket:
  Add price pointer 23, (ie, discount of 55.00
  percent equals .45 multiplier)
 “S”ell option – S1, S2, SA, SB
 “V”endor option now uses Product Master vendor
 ABC is now active


U2007.1 changes:
 Effective/expiration dates and print in 5.21
 Select Vendor/Product Class combination
                 Price Quantity Maintenance
                 35. Matrix Listing (old 5.24)
   Pricing Matrix Listing

    Column Options:
     –   1.   Each Column
     –   2.   Bucket 1 Column
     –   3.   Bucket 2 Column
     –   4.   Bucket A Column
     –   5.   Bucket B Column
     –   6.   All Columns

     Selection Options
     –     1. Select for Specific Vendors
     –     2. Select for Specific Product Classes
     –     3. ALL records (Vendors, Classes, Customers)
     –     4. Select for Specific Customers
     –     5. Select for Specific Products
     –     6. Select for Specific Product Types
     –     7. Select for Specific Product Categories

     Specific Field Selection
     –     1. DPOINT (field #2) only
     –     2. CPOINT (field #4) only
     –     3. All fields
Auto Update Pricing Menu
Pricing Menu – Price Books
Auto Updates of Contract Prices
Questions & Answers
             100

              50                     East
                                     West
               0
                   1st   3rd         North
                   Qtr   Qtr



                         ??????




         CONTRACTS   LIST PRICING   MATRIX

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:9
posted:1/27/2012
language:
pages:20