How to calculate the last four columns? Decile 10 9 8 7 6 5 4 3 21

How to calculate the last four columns?

 

Transcribed Image Text:

Decile 10 9 8 7 6 5 4 3 21 Cumulated % of total hits - RFM 14,7% 20,6% 34,8% 42,2% 58,9% 71,1% 40,7% 80,0% 46,6% 85,4% 62,7% 88,3% 66,2% 94,2% 80,9% 97,5% Cumulated % of total hits - Logit 90,2% 100,0% 99,5% 100,0% No. of Mailings 5000 10000 15000 20000 25000 30000 35000 40000 45000 50000 Cost of mailing $3 250 $6 500 $9 750 $13 000 $16 250 $19 500 $22 750 $26 000 $29 250 $32 500 RFM Units sold 652 913 1 543 1 804 2 065 2 783 2935 3 587 4 000 4 435 Logit Units sold 1 871 2 612 3 153 3 548 3 787 3 916 4 178 4 324 4 413 4 435 RFM Profit $3 402 $2 813 $5 993 $5 404 $4 815 $8 883 $7 185 $10 587 $11 550 $12 735 Logit Profit $15 839 $20 143 $22 412 $23 188 $22 381 $20 442 $19 861 $18 104 $15 759 $12 735 Decile 10 9 8 7 6 5 4 3 21 Cumulated % of total hits - RFM 14,7% 20,6% 34,8% 42,2% 58,9% 71,1% 40,7% 80,0% 46,6% 85,4% 62,7% 88,3% 66,2% 94,2% 80,9% 97,5% Cumulated % of total hits - Logit 90,2% 100,0% 99,5% 100,0% No. of Mailings 5000 10000 15000 20000 25000 30000 35000 40000 45000 50000 Cost of mailing $3 250 $6 500 $9 750 $13 000 $16 250 $19 500 $22 750 $26 000 $29 250 $32 500 RFM Units sold 652 913 1 543 1 804 2 065 2 783 2935 3 587 4 000 4 435 Logit Units sold 1 871 2 612 3 153 3 548 3 787 3 916 4 178 4 324 4 413 4 435 RFM Profit $3 402 $2 813 $5 993 $5 404 $4 815 $8 883 $7 185 $10 587 $11 550 $12 735 Logit Profit $15 839 $20 143 $22 412 $23 188 $22 381 $20 442 $19 861 $18 104 $15 759 $12 735

Answer rating: 100% (QA)

To calculate the last four columns we need to perform the following calculations 1 RFM Units Mu... View the full answer