Information Systems:CCP - Customer/Contract Pricing

There are no fixed selling prices; instead they are the result of a calculation based on the contents of several different files.

- File IXPRICP (CPP – Item Base Pricing) contains the vendor base cost (price type of VEBA) for all items.

- File IXMARKP (CCP – Item to mark Up Class Linkages) contains the markup class for each item. (For example ‘FS 5.5/7.5’, which is front store items with 5.5% markup for shareholders, and 7.5% for non-shareholders.)

- File MKCUPR (CCP – Customer to Price Links Master) gives the price list for each customer. (For example ‘SHARE-BC’ or ‘NON-SH-AB’.)

- File MKPERCP (CCP – Mark Up Percentages by Date Range) gives the markup percent for each price list within each markup class.

RPG program IXRUP500 (CCP – Item pricing lookup routine) is the black box that does all price lookup. Basically, it receives item, customer, and date, then returns all related price fields.

The high level process is –

- Read IXMARKP to get the item’s markup class.

- Read MKCUPR to get the customer’s price list.

- Read MKPERCP by markup class and price list to get the markup percentage.

- Read IXPRICP to get the vendor base cost.

- Multiple the vendor base cost by the markup percentage, and add it to the cost.

There is more to it; for example –

- Because of government legislation, vendors can have different selling prices by province. There is not a field for province on IXPRICP, so we use the warehouse field. ‘MAI’ for BC price, ‘CGY’ for Alberta, or ‘*ANY’ if the price is the same for both provinces.

- Items can be on contract, or on promo (see next two sections), so the black box must search for the lowest selling price effective on the requested date, that the customer is eligible for.

‘VEBA’ is not the only price type in IXPRICP. There are also –

CUSU      customer suggested retail price
CURE      customer rebate
VERE      vendor rebate

Contracts

This is when we get special prices from vendors. The effective prices for purchasing are in CXITPRP. Price types in this file are -

CUSU      customer suggested retail price
SUBS      subsidy (by uniPHARM)
VEBA      vendor base cost
VEDI      vendor debit – charged back to the vendor or rep 
VEOI      off invoice – taken off the purchase price at time of payment	

There are also sales dates in this file, or these special prices can be moved into a promotion.

Promotions

This is when we give special prices to our customers. The effective prices are in PXPRICP.

CUSU      customer suggested retail price
SUBS      subsidy (by uniPHARM)
VEBA      vendor base cost
VEDI      vendor debit – charged back to the vendor or rep 
VEBA      vendor base cost