Modules»Inventory Control»Price Based on a Matrix Table …
  • RSS Feed

Last modified on 9/8/2015 11:59 AM by User.

Price Based on a Matrix Table - Originals x Copies x Price

This document is used when pricing for quantity breaks is based on a matrix table with a combination of copies and originals.

 

of Copies  

# of Originals¯

1

2-4

5-9

10-19

20-49

1-10

$.20

$.18

$.16

$.14

$.12

11-25

$.19

$.17

$.15

$.13

$.11

26-50

$.18

$.16

$.14

$.12

$.10

51-75

$.17

$.15

$.13

$.11

$.09

76-100

$.16

$.14

$.12

$.10

$.08

101-200

$.15

$.13

$.11

$.09

$.07

 

NOTE:  check the parameter DIM’ORDER= (found in 6/32/22/1).  This parameter controls the prompt as to which order Copies and Originals are asked in Order Processing.  N –Normal – prompts first copies, then originals.  If R – Reversed – is used, the system prompts originals, then copies.   IF yours is R, the system still follows the logic of the table (copies in the rows and originals in the column)

 

The price charged to a customer using the above matrix is as follows:

1 Original and 4 Copies - the price will be 4 @ $.18

30 Originals and 9 Copies - the price will be 270 @ $.14

Note

  • If pricing is strictly based on the number of copies times the number of originals - without regard to a different price based on the number of originals -  (30 originals x 9 copies = 270.  Quantity break is 270)- See document Price Using Discount Quantity Tables. 
  • If pricing is (using 30 originals/9 copies example) is $.18 for the first copy, $.16 for copies 2 -4 and $.14 for copies 5 - 9 then see document titled:  Price Based on the Step Method
  • If pricing is a combination of copies and originals, but the price is based only on the number of copies with the pricing coming from a table (similar to the one above), see the documents titled:  Price Based on a Matrix Table – Price x Copies
  • If pricing is based on the number of copies times the number of originals – with pricing based on a table then this document used.

 

DIMENSIONAL TYPE:

One of two dimensional types must be used when using the example table shown above: X or T: 

  • "X", "Bond copies" This whole logic is used for looking down the left edge of a matrix chart for the Originals then across for the number of Copies.  The price thus varies by Originals and Copies.
  • "T" , "Plot(S/O/W/H/X-disc)"  It combines the discount structure of dimensional type X (matrix table lookup based on # of originals, break point test based on # sets/copies) with the entries of dimensional type D (sets/orig/wid/ht). (NOTE: this means the discount table amounts of percent, amount or price level will relate to sq foot, NOT # of prints)

 

Dimensional Types can be found in the Inventory module, System Management Functions (Task 32), Modify Application Tables (Sub-task 17), and Dimensional Types (Option 18).

 

 

DISCOUNT TABLE:

  • Inventory (Module 5)
    • Discount Table Master (Task 22)

 

A discount table needs to be setup that prompts the system to use the copies/originals logic. Below is a partial sample of what a Discount Table (assuming Dimensional Type X is used):

 

01.    Table Name:                C1

02.    Table descr:               0001

03.    Break on D/Q:             Q

04.    Amount type:               $(%L$)

05. Fixed/cume:                        F

 

06.    Quantity:                   1

07.       Price:                        0.20

08.    Quantity:                   2

09.       Price:                        0.18

10.    Quantity:                   5

11.       Price:                        0.16

12.    Quantity:                    10

13.       Price:                        0.14

14.    Quantity:                   20

15.       Price:                        0.12

......

164. Quantity:                   110

165.       Price:                        0.09

 

The 0001 in the Table descr field means that the first break point on the number of Originals is 1. The quantity fields (i.e. 05, 07, etc) represent the number of copies. The next table in this sequence would be C2 with Table descr-0011, which gives a break at 11 originals - meaning that the system will look at the row of the matrix table that has 11-25 as the originals.  Next in the sequence would be another table named C3 with a Table descr- 0026, meaning that the system will look at the row of the matrix table that has 26-50 as the originals.  It is the number in the Table descr field that dictates where the break is on the originals!     NOTE:  The "Table descrfield can be called anything (i.e. 0001 Repro) but it is very important that the first 4 positions be reserved for the "breaks".  For example:  the table description could be, as noted, 0001Repro or it could also be called  1   Repro, the three spaces after the "1" must remain blank, it could not be called:1Repro.

 

Some clients understand it as:  the system will use the row on the matrix, using the number indicated in the Table descr field (i.e. 0001) until it finds anther row with the number in the Table/Table descr that is equal to or greater than the number of originals being ordered.  From the above matrix table any original quantity up to 10 will use the table with a Table descr of 0001 (C1), then look across the row to find the break on copy quantities for the price.  If the customer orders originals in quantities from 11 to 25, the table named C2 with Table descr 0011 is used and the break on the copies is used for the price.  And so on.

 

The letter or number following the C has no meaning, if needed tables can be set up to go beyond C9 and tables beginning with CA can be used.  Even the first letter has no meaning, the only first letters that have a meaning to the system are Q, M or G.

Do not use Q, M, or G as the starting letter in the table for pricing based on the example above.  Q & M are reserved quantity breads based on the combination of the number of copies times the number of originals, based on if selling or stocking units are sold.  The G is reserved for discounts based on Group discounts.

 

 

IMPORTANT:  the system needs to know which items can use the matrix table.  On the item, a couple of fields must be filed in: the Dimensional field must indicate if the item is a T or X (see top of page for explanation) and the Quantity Table field must "point" to the tables.

 

  • Inventory (Module 5)
    • Item Master (Task 17)
      • Dimensional? (Field 26)
      • Quantity Table (Field 30)

This example would have an "X" in field 26, then would have all C's in field 30, because the system will look at all tables that begin with an C because of the dimensional type of X or T. (Remember, the tables could also have been named A1, A2 etc. and then all A's would be put in field 30)