Description
An excel spreadsheet which explains how the process of Bid 2 Win works. It is a extension to the document "Differential Benefits Scheme"
Outlet Name A B C D E F G H I J K L M N O P Q R Near Month 100 200 300 350 100 150 240 25 300 130 125 250 100 25 30 0 260 230
Quarterly Sales Mid Month 100 200 300 340 50 100 230 25 100 150 150 250 100 30 30 100 300 200
Far Month 100 200 300 300 50 100 100 25 75 130 180 250 100 50 30 150 200 200
Total Sales 300 600 900 990 200 350 570 75 475 410 455 750 300 105 90 250 760 630
Customer Category
300 600 900 990 200 350 570 75 475 410 455 750 300 105 90 250 760 630
Sales Range 0-200 201-500 501-800 801 & above
LEGEND Customer Category
New Point Multiplier 1 1.5 2 3
New Points Multiplier Points Earned Accrued Points 1.5 2 3 3 1 1.5 2 1 1.5 1.5 1.5 2 1.5 1 1 1.5 2 2 450 1200 2700 2970 200 525 1140 75 712.5 615 682.5 1500 450 105 90 375 1520 1260 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100
Total Points 550 1300 2800 3070 300 625 1240 175 813 715 783 1600 550 205 190 475 1620 1360
Points Used 300 1100 2100 3000 250 500 900 75 800 500 500 800 550 0 80 200 1000 1000
Points Left 250 200 700 70 50 125 340 75 13 215 283 800 0 105 90 275 620 360
Cash-In Points Points Expired Carry forward Multiplier Points Carried Forward 50 0 100 100 40 50 200 100 13 100 83 500 0 110 100 500 20 60 0 0 0 0 0 0 0 25 0 0 0 0 0 100 20 0 0 0 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 100 100 300 0 5 37.5 70 0 0 57.5 100 150 0 0 0 0 300 150
doc_990426654.xls
An excel spreadsheet which explains how the process of Bid 2 Win works. It is a extension to the document "Differential Benefits Scheme"
Outlet Name A B C D E F G H I J K L M N O P Q R Near Month 100 200 300 350 100 150 240 25 300 130 125 250 100 25 30 0 260 230
Quarterly Sales Mid Month 100 200 300 340 50 100 230 25 100 150 150 250 100 30 30 100 300 200
Far Month 100 200 300 300 50 100 100 25 75 130 180 250 100 50 30 150 200 200
Total Sales 300 600 900 990 200 350 570 75 475 410 455 750 300 105 90 250 760 630
Customer Category
300 600 900 990 200 350 570 75 475 410 455 750 300 105 90 250 760 630
Sales Range 0-200 201-500 501-800 801 & above
LEGEND Customer Category
New Point Multiplier 1 1.5 2 3
New Points Multiplier Points Earned Accrued Points 1.5 2 3 3 1 1.5 2 1 1.5 1.5 1.5 2 1.5 1 1 1.5 2 2 450 1200 2700 2970 200 525 1140 75 712.5 615 682.5 1500 450 105 90 375 1520 1260 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100
Total Points 550 1300 2800 3070 300 625 1240 175 813 715 783 1600 550 205 190 475 1620 1360
Points Used 300 1100 2100 3000 250 500 900 75 800 500 500 800 550 0 80 200 1000 1000
Points Left 250 200 700 70 50 125 340 75 13 215 283 800 0 105 90 275 620 360
Cash-In Points Points Expired Carry forward Multiplier Points Carried Forward 50 0 100 100 40 50 200 100 13 100 83 500 0 110 100 500 20 60 0 0 0 0 0 0 0 25 0 0 0 0 0 100 20 0 0 0 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 100 100 300 0 5 37.5 70 0 0 57.5 100 150 0 0 0 0 300 150
doc_990426654.xls