| Description |
!pastedImage_d36437_0.png! *Pricing Method Formula*
*1. Fixed Dollar Amount*
a. Unit Price will be recalculated.
b. Formula is:
(Retail Price * Unit Qty) + (Amount entered in Amount field * Unit Qty)
Sample 1:
i. Retail Price is 10.00
ii. Unit Qty is 1.00, Amount is 3.00.
iii. (10.00*1) + (3.00*1.00) = 13.00
iv. 10 + 3 = 13
Sample 2:
i. Retail Price is 10.00
ii. Unit Qty is 5.00, Amount is 3.00.
iii. (10.00*5.00) + (3.00*5.00) = 65
iv. 50 + 15 = 65
*2. Mark Up Standard Cost*
a. Unit Price will be recalculated.
b. Formula is (Retail Price * Unit Qty) x (100% + rate entered in Percent field)
Sample 1:
i. Retail Price is 10.00, Unit Qty is 1.00, Percent is 25.
ii. (10.00 * 1) x (100% + 25%) = 12.50
iii. 10.00 x (1 + .25) = 12.50
Sample 2:
i. Retail Price is 10.00, Unit Qty is 5.00, Percent is 25.
ii. (10.00 * 5) x (100% + 25%) = 12.50
iii. 10.00 x (1 + .25) = 62.50
*3. Percent of Margin*
a. Unit Price will be recalculated.
b. Formula is (Retail Price * Unit Qty. ) divided by (100% - Amount/Percent entered)
Sample 1:
i. Retail Price is 10.00, Unit Qty is 1.00, Percent is 25.
ii. (10.00*1) / (100% - 25%) = 13.33.
iii. 10.00 / .75 = 13.33.
Sample 2:
i. Retail Price is 10.00, Unit Qty is 5.00, Percent is 25.
ii. (10.00*5) / (100% - 25%) = 13.33.
iii. 50.00 / .75 = 13.33.
*4. Discount Retail Price.*
a. Formula to compute Unit Price field is (Retail Price * Unit Qty) – [(Retail price * Unit Qty) * Rate entered)]
Sample 1:
i. Retail price is 187.50, Unit Qty is 1, Percent is 2.
ii. (187.50 * 1.00) – [(187.50 *1.00) * 2%)] = 183.75.
iii. 187.50 – (187.50 * 2%) = 183.75
iv. 187.50 - 3.75 = 183.75.
Sample 2:
i. Retail price is 187.50, Unit Qty is 5, Percent is 2.
ii. (187.50 * 5.00) – [(187.50 *5.00) * 2%)] = 918.75
iii. 937.50 – (937.50 * 2%) = 918.75
iv. 937.50 - 18.75 = 918.75
*5. MSRP Discount.*
a. Formula to compute Unit Price field is (MSRP * Unit Qty) – [(MSRP * Unit Qty) * Rate entered)]
Sample 1:
i. MSRP is 190, Unit Qty is 1.00, Percent is 2%
ii. (190.00 * 1.00) - (190.00 * 2%) = 186.20
iii. 190.00 - 3.80= 186.20.
Sample 2:
i. MSRP is 190, Unit Qty is 5.00, Percent is 2%
ii. (190.00 * 5.00) – [(190.00 * 5.00) * 2%)] = 931
iii. 950 – (950 * 2%) = 931
iv. 950 – 19 = 931.
*6. Percent of Margin (MSRP)*
a. Formula to compute Unit Price field is [(MSRP – Standard Cost) x (Unit Qty * Percent] + (Standard Cost * Unit Qty)
Sample 1:
i. MSRP is 190, Standard Cost is 150, Unit Qty 1, Percent is 80%
ii. [(190.00 - 150.00) * .8] + 150.00 = 182.00
iii. (40.00 * .8) + 150 = 182.00
iv. 32.00 + 150.00 = 182.00
Sample 2:
i. MSRP is 190.00, Standard Cost is 150, Unit Qty 5.00, Percent is 80%
ii. [(190.00 - 150.00) * .8] + (150.00 * 5) = 910
iii. [(40.00 * 4) + 750 = 910.00
iv. 160 + 750 = 910.00
|