RPP Calculator - Theatre Xyz

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 8

Forward Rate Card Reverse Rate Card

Metro Metro
Rest of Special Rest of
Bill Local Regional to Local Regional to
India States India
Weight Metro Bill Weight Metro
0.5 30 32 39 44 52 0.5
1 55 58 74 78 100 1
1.5 1.5
2 70 75 92 104 130 2
2.5 2.5
3 100 113 132 146 180 3
3.5 3.5
4 4
4.5 4.5
5 5
5.5 5.5
6 6
6.5 6.5
7 7
7.5 7.5
8 8
8.5 8.5
9 9
9.5 9.5
10 10
10.5 10.5
11 11
11.5 11.5
12 12
12.5 12.5
13 13
13.5 13.5
14 14
14.5 14.5
15 15
15.5 15.5
16 16
16.5 16.5
17 17
17.5 17.5
18 18
18.5 18.5
19 19
19.5 19.5
20 20
20.5 20.5
21 21
21.5 21.5
22 22
22.5 22.5
23 23
23.5 23.5
24 24
24.5 24.5
25 25
25.5 25.5
26 26
26.5 26.5
27 27
27.5 27.5
28 28
28.5 28.5
29 29
29.5 29.5
30 30
30.5 30.5
31 31
31.5 31.5
32 32
32.5 32.5
33 33
33.5 33.5
34 34
34.5 34.5
35 35
35.5 35.5
36 36
36.5 36.5
37 37
37.5 37.5
38 38
38.5 38.5
39 39
39.5 39.5
40 40
40.5 40.5
41 41
41.5 41.5
42 42
42.5 42.5
43.5 43.5
44 44
44.5 44.5
45 45
45.5 45.5
46 46
46.5 46.5
47 47
47.5 47.5
48 48
48.5 48.5
49.5 49.5
50 50
50.5 50.5
51 51
52 52
53 53
53.5 53.5
54 54
55 55
55.5 55.5
57 57
58.5 58.5
60 60
60.5 60.5
62 62
65 65
68 68
68.5 68.5
72.5 72.5
78.5 78.5
80 80
81 81
86 86
87.5 87.5
90 90
93.5 93.5
95 95
99.5 99.5
Overall Overall
WPS 0.92 FSC 0% DTO 1.30
ate Card WT_check 100.00% Zone_chk 100%
Metro Blended Blended
Special Rest of Special
Weight Local Regional to Forward Reverse
States India States
Bill Weight Mix Metro Rate Rate
0.5 60% 5% 15% 40% 40% 0% 40 0
1 20% 5% 15% 40% 40% 0% 72 0
1.5 0% 5% 15% 40% 40% 0% 0 0
2 18% 5% 15% 45% 40% 0% 98 0
2.5 0% 5% 15% 45% 40% 0% 0 0
3 2% 5% 15% 45% 40% 0% 140 0
3.5 0% 5% 15% 45% 40% 0% 0 0
4 0% 5% 15% 45% 40% 0% 0 0
4.5 0% 5% 15% 45% 40% 0% 0 0
5 0% 5% 15% 45% 40% 0% 0 0
5.5 0% 5% 15% 45% 40% 0% 0 0
6 0% 5% 15% 45% 40% 0% 0 0
6.5 0% 5% 15% 45% 40% 0% 0 0
7 0% 5% 15% 45% 40% 0% 0 0
7.5 0% 5% 15% 45% 40% 0% 0 0
8 0% 5% 15% 45% 40% 0% 0 0
8.5 0% 5% 15% 45% 40% 0% 0 0
9 0% 5% 15% 45% 40% 0% 0 0
9.5 0% 5% 15% 45% 40% 0% 0 0
10 0% 5% 15% 45% 40% 0% 0 0
10.5 0% 5% 15% 45% 40% 0% 0 0
11 0% 5% 15% 45% 40% 0% 0 0
11.5 0% 5% 15% 45% 40% 0% 0 0
12 0% 5% 15% 45% 40% 0% 0 0
12.5 0% 5% 15% 45% 40% 0% 0 0
13 0% 5% 15% 45% 40% 0% 0 0
13.5 0% 5% 15% 45% 40% 0% 0 0
14 0% 5% 15% 45% 40% 0% 0 0
14.5 0% 5% 15% 45% 40% 0% 0 0
15 0% 5% 15% 45% 40% 0% 0 0
15.5 0% 5% 15% 45% 40% 0% 0 0
16 0% 5% 15% 45% 40% 0% 0 0
16.5 0% 5% 15% 45% 40% 0% 0 0
17 0% 5% 15% 45% 40% 0% 0 0
17.5 0% 5% 15% 45% 40% 0% 0 0
18 0% 5% 15% 45% 40% 0% 0 0
18.5 0% 5% 15% 45% 40% 0% 0 0
19 0% 5% 15% 45% 40% 0% 0 0
19.5 0% 5% 15% 45% 40% 0% 0 0
20 0% 5% 15% 45% 40% 0% 0 0
20.5 0% 5% 15% 45% 40% 0% 0 0
21 0% 5% 15% 45% 40% 0% 0 0
21.5 0% 5% 15% 45% 40% 0% 0 0
22 0% 5% 15% 45% 40% 0% 0 0
22.5 0% 5% 15% 45% 40% 0% 0 0
23 0% 5% 15% 45% 40% 0% 0 0
23.5 0% 5% 15% 45% 40% 0% 0 0
24 0% 5% 15% 45% 40% 0% 0 0
24.5 0% 5% 15% 45% 40% 0% 0 0
25 0% 5% 15% 45% 40% 0% 0 0
25.5 0% 5% 15% 45% 40% 0% 0 0
26 0% 5% 15% 45% 40% 0% 0 0
26.5 0% 5% 15% 45% 40% 0% 0 0
27 0% 5% 15% 45% 40% 0% 0 0
27.5 0% 5% 15% 45% 40% 0% 0 0
28 0% 5% 15% 45% 40% 0% 0 0
28.5 0% 5% 15% 45% 40% 0% 0 0
29 0% 5% 15% 45% 40% 0% 0 0
29.5 0% 5% 15% 45% 40% 0% 0 0
30 0% 5% 15% 45% 40% 0% 0 0
30.5 0% 5% 15% 45% 40% 0% 0 0
31 0% 5% 15% 45% 40% 0% 0 0
31.5 0% 5% 15% 45% 40% 0% 0 0
32 0% 5% 15% 45% 40% 0% 0 0
32.5 0% 5% 15% 45% 40% 0% 0 0
33 0% 5% 15% 45% 40% 0% 0 0
33.5 0% 5% 15% 45% 40% 0% 0 0
34 0% 5% 15% 45% 40% 0% 0 0
34.5 0% 5% 15% 45% 40% 0% 0 0
35 0% 5% 15% 45% 40% 0% 0 0
35.5 0% 5% 15% 45% 40% 0% 0 0
36 0% 5% 15% 45% 40% 0% 0 0
36.5 0% 5% 15% 45% 40% 0% 0 0
37 0% 5% 15% 45% 40% 0% 0 0
37.5 0% 5% 15% 45% 40% 0% 0 0
38 0% 5% 15% 45% 40% 0% 0 0
38.5 0% 5% 15% 45% 40% 0% 0 0
39 0% 5% 15% 45% 40% 0% 0 0
39.5 0% 5% 15% 45% 40% 0% 0 0
40 0% 5% 15% 45% 40% 0% 0 0
40.5 0% 5% 15% 45% 40% 0% 0 0
41 0% 5% 15% 45% 40% 0% 0 0
41.5 0% 5% 15% 45% 40% 0% 0 0
42 0% 5% 15% 45% 40% 0% 0 0
42.5 0% 5% 15% 45% 40% 0% 0 0
43.5 0% 5% 15% 45% 40% 0% 0 0
44 0% 5% 15% 45% 40% 0% 0 0
44.5 0% 5% 15% 45% 40% 0% 0 0
45 0% 5% 15% 45% 40% 0% 0 0
45.5 0% 5% 15% 45% 40% 0% 0 0
46 0% 5% 15% 45% 40% 0% 0 0
46.5 0% 5% 15% 45% 40% 0% 0 0
47 0% 5% 15% 45% 40% 0% 0 0
47.5 0% 5% 15% 45% 40% 0% 0 0
48 0% 5% 15% 45% 40% 0% 0 0
48.5 0% 5% 15% 45% 40% 0% 0 0
49.5 0% 5% 15% 45% 40% 0% 0 0
50 0% 5% 15% 45% 40% 0% 0 0
50.5 0% 5% 15% 45% 40% 0% 0 0
51 0% 5% 15% 45% 40% 0% 0 0
52 0% 5% 15% 45% 40% 0% 0 0
53 0% 5% 15% 45% 40% 0% 0 0
53.5 0% 5% 15% 45% 40% 0% 0 0
54 0% 5% 15% 45% 40% 0% 0 0
55 0% 5% 15% 45% 40% 0% 0 0
55.5 0% 5% 15% 45% 40% 0% 0 0
57 0% 5% 15% 45% 40% 0% 0 0
58.5 0% 5% 15% 45% 40% 0% 0 0
60 0% 5% 15% 45% 40% 0% 0 0
60.5 0% 5% 15% 45% 40% 0% 0 0
62 0% 5% 15% 45% 40% 0% 0 0
65 0% 5% 15% 45% 40% 0% 0 0
68 0% 5% 15% 45% 40% 0% 0 0
68.5 0% 5% 15% 45% 40% 0% 0 0
72.5 0% 5% 15% 45% 40% 0% 0 0
78.5 0% 5% 15% 45% 40% 0% 0 0
80 0% 5% 15% 45% 40% 0% 0 0
81 0% 5% 15% 45% 40% 0% 0 0
86 0% 5% 15% 45% 40% 0% 0 0
87.5 0% 5% 15% 45% 40% 0% 0 0
90 0% 5% 15% 45% 40% 0% 0 0
93.5 0% 5% 15% 45% 40% 0% 0 0
95 0% 5% 15% 45% 40% 0% 0 0
99.5 0% 5% 15% 45% 40% 0% 0 0
Overall 100%
Monthly Volume (Absolute) 10,000.00

P&L INR % COD Rate


Forward Rate 58.5
COD 19.6 70% 28
RTO 7.0 12%
DTO
RPP 85.2
RPK 92.6

You might also like