Scribd
Upload
41 views3 pages

19 Free Goods Calculation Rule

Uploaded by

VK Roy

This document summarizes different calculation rules for free goods promotions. It includes 4 cases: 1) Buy 1 Get 1 Pro Rata 1 Free, 2) Buy 1 Get 1 Pro Rata 1 Free, 3) Buy 1 Get 1 Pro Rata 1 Free, and 4) Buy 1 Get 2 Unit 1 Free Reference. For each case it shows the order quantity, quantity from, free goods, and free percentage. It also provides definitions for different calculation methods for determining the free goods amount.

Copyright:

© All Rights Reserved
Download as XLSX, PDF, TXT or read online from Scribd
Download as xlsx, pdf, or txt

19 Free Goods Calculation Rule

Uploaded by

VK Roy
41 views3 pages
This document summarizes different calculation rules for free goods promotions. It includes 4 cases: 1) Buy 1 Get 1 Pro Rata 1 Free, 2) Buy 1 Get 1 Pro Rata 1 Free, 3) Buy 1 Get 1 Pro Rata 1 Free, and 4) Buy 1 Get 2 Unit 1 Free Reference. For each case it shows the order quantity, quantity from, free goods, and free percentage. It also provides definitions for different calculation methods for determining the free goods amount.

Original Description:

Free Goods-Calculation Rule

Copyright

© © All Rights Reserved

Available Formats

XLSX, PDF, TXT or read online from Scribd

Did you find this document useful?

Is this content inappropriate?

This document summarizes different calculation rules for free goods promotions. It includes 4 cases: 1) Buy 1 Get 1 Pro Rata 1 Free, 2) Buy 1 Get 1 Pro Rata 1 Free, 3) Buy 1 Get 1 Pro Rata 1 Free, and 4) Buy 1 Get 2 Unit 1 Free Reference. For each case it shows the order quantity, quantity from, free goods, and free percentage. It also provides definitions for different calculation methods for determining the free goods amount.

Copyright:

© All Rights Reserved
Download as XLSX, PDF, TXT or read online from Scribd
Download as xlsx, pdf, or txt
41 views3 pages

19 Free Goods Calculation Rule

Uploaded by

VK Roy
This document summarizes different calculation rules for free goods promotions. It includes 4 cases: 1) Buy 1 Get 1 Pro Rata 1 Free, 2) Buy 1 Get 1 Pro Rata 1 Free, 3) Buy 1 Get 1 Pro Rata 1 Free, and 4) Buy 1 Get 2 Unit 1 Free Reference. For each case it shows the order quantity, quantity from, free goods, and free percentage. It also provides definitions for different calculation methods for determining the free goods amount.

Copyright:

© All Rights Reserved
Download as XLSX, PDF, TXT or read online from Scribd
Download as xlsx, pdf, or txt
You are on page 1/ 3

Calculation Order Min From Are

Status Case Free Goods Free Free %


Rule Qty Qty Goods

1-Inclusive
Buy 1 Get 1-Pro Rata rebate (with
Pass 2 2 2 1 50%
1 Free item
generation)

1-Inclusive
Buy 1 Get 1-Pro Rata rebate (with
Fail 3 2 2 1 50%
1 Free item
generation)

2-Inclusive
rebate (w/o
Buy 1 Get 1-Pro Rata
Pass item 2 2 2 1 50%
1 Free generation; only
for sales)

2-Inclusive
rebate (w/o
Buy 1 Get 1-Pro Rata
Fail item 3 2 2 1 50%
1 Free generation; only
for sales)

1-Inclusive
Buy 1 Get 2-Unit rebate (with 8 2 2 1 50%
1 Free Reference item
generation)

1-Pro Rata 3 2 2 1 50%

2-Unit 149 100 25 1 4%


Reference

3-Whole Unit 4 2 2 1 50%


Bill
Main Free Amoun
Method Prd Goods t-100 Definition
Qty Qty Inr Per
Pcs

System calculates the free goods in


Round(A2/B2,0) 1 1 100 correct proportion to the document
(ordered) quantity.

System calculates the free goods in


Round(A2/B2,0) 1 2 100 correct proportion to the document
(ordered) quantity.

System calculates the free goods in


Round(A2/B2,0) 1 1 100 correct proportion to the document
(ordered) quantity.

System calculates the free goods in


Round(A2/B2,0) 1 2 100 correct proportion to the document
(ordered) quantity.

If order qty is non multiple of from qty in


that case decimal qty will be turncated
(A3-MOD(A3,B3))/B3 4 4

System calculates the free goods in


Round(A2/B2,0) 1 2 correct proportion to the document
(ordered) quantity.
If order qty is non multiple of from qty in
(A3-MOD(A3,B3))/B3 144 5 that case decimal qty will be turncated

If order qty is non multiple of from qty in


IF(MOD(A4,B4)=0,A4/B4,0) 2 2 that case free goods qty will be zero
Calculation Free Goods
Case Free Goods Status
Rule
1-Inclusive rebate (with item 2-Inclusive rebate (w/o item
Buy 1 Get 1 Free 1-Pro Rata Fail
generation) generation; only for sales)

You might also like