The below table contains information related to 1,2,3 Monthly Stats including Active base (At beginning of...

  

Transcribed Image Text:

The below table contains information related to 1,2,3 Monthly Stats including Active base (At beginning of each month), Sales, Chum and Activated from Domant Please calculate the following: 1.Calculate the sales for each operator for Month of May-2018. 2.Calculate the Net Adds for each operator for the whole period. 3. Calculate Chum rate for month of Mar2018. Month Jan-18 Jan-18 Jan-18 Feb-18 Feb-18 Feb-18 Mar-18 Mar-18 Mar-18 Apr-18 Apr-18 Apr-18 May-18 May-18 May-18 Jun-18 Jun-18 Jun-18 Operator 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 Active Base 1,398,547 1,359,609 2,803,767 1,378,514 1,340,575 2,793,579 1,354,389 1,317,024 2,704,913 1,349,231 1,299,568 2,681,152 1,332,795 1,277,575 2,648,266 1,300,989 1,241,253 2,605,938 Sales 61,451 66,443 Churn 95,297 95,037 99,713 136,852 59,689 96,701 62,494 95,060 9,015 90,686 208,679 29,327 70,549 92,720 17,013 Activated 13,813 9,560 26,951 12,887 69,751 97,747 10,540 100,916 158,935 34,258 58,291 86,983 12,256 59,121 89,227 8,113 89,760 151,577 28,931 92,972 9,860 93,562 6,341 149,418 62,390 91,645 66,362 90,227 24,434 13,956 9,584 121.170 144,180 30,945 Month Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Man Jan J-1 No-11 Melf 11 M1 Apt A1 Aps www. Ant Operator 3 1 2 S 3 1 1 . 1 1 Action Base Active Base 1.396.547 TER 2802767 1378.514 1340575 2791879 1354.389 1317,004 2.764,913 1.343.221 1.200.000 2,881,162 1332,795 1377575 2.4.200 1.300 1,241,253 2.605.94 Chun Sales Chumn Activated BLASS $5.297 13.813 86,443 95,037 9.500 1711 138.852 26.951 50.409 94.701 12.887 12,404 95.000 8015 90.48 208.879 29.327 70.543 92,720 17,013 65.751 37.747 10.540 100.918 158.935 34258 34.201 M.33 56.121 12,254 85.227 1113 Ch 2017 $2,072 83.300 44.342 90.227 121.420 144.180 28.031 9.36 $1.543 6,341 149.418 24.434 $1,045 13.456 0,584 30.545 Operator NetAdd Month Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Operator Active Base 2 2 2 2 Sales 61,451 59,689 96,701 1.398,547 1,378,514 70,549 1,354,389 58,291 1,349,231 1,332.795 1,300,989 62,390 91,645 1,359.609 66,443 95,037 1.340.675 62,494 95,060 69,751 1.317.024 1.299.568 59,121 97,747 89,227 1.277.575 93,562 1.241.253 66,352 90,227 2,803,767 136,852 2,793,579 99,713 00,000 208,679 2,704,913 100.916 158,935 2,681,152 89,760 151,577 149,418 121.170 144.180 2 3 3 2.648.266 2.605.938 Churn Activated 95,297 92,720 86,983 92.972 13,813 12,887 17,013 12,256 9,860 13,956 9,560 9,015 10,540 8,113 6,341 9,584 26,951 29,327 34,258 28,931 24,434 30,945 The below table contains information related to 1,2,3 Monthly Stats including Active base (At beginning of each month), Sales, Chum and Activated from Domant Please calculate the following: 1.Calculate the sales for each operator for Month of May-2018. 2.Calculate the Net Adds for each operator for the whole period. 3. Calculate Chum rate for month of Mar2018. Month Jan-18 Jan-18 Jan-18 Feb-18 Feb-18 Feb-18 Mar-18 Mar-18 Mar-18 Apr-18 Apr-18 Apr-18 May-18 May-18 May-18 Jun-18 Jun-18 Jun-18 Operator 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 Active Base 1,398,547 1,359,609 2,803,767 1,378,514 1,340,575 2,793,579 1,354,389 1,317,024 2,704,913 1,349,231 1,299,568 2,681,152 1,332,795 1,277,575 2,648,266 1,300,989 1,241,253 2,605,938 Sales 61,451 66,443 Churn 95,297 95,037 99,713 136,852 59,689 96,701 62,494 95,060 9,015 90,686 208,679 29,327 70,549 92,720 17,013 Activated 13,813 9,560 26,951 12,887 69,751 97,747 10,540 100,916 158,935 34,258 58,291 86,983 12,256 59,121 89,227 8,113 89,760 151,577 28,931 92,972 9,860 93,562 6,341 149,418 62,390 91,645 66,362 90,227 24,434 13,956 9,584 121.170 144,180 30,945 Month Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Man Jan J-1 No-11 Melf 11 M1 Apt A1 Aps www. Ant Operator 3 1 2 S 3 1 1 . 1 1 Action Base Active Base 1.396.547 TER 2802767 1378.514 1340575 2791879 1354.389 1317,004 2.764,913 1.343.221 1.200.000 2,881,162 1332,795 1377575 2.4.200 1.300 1,241,253 2.605.94 Chun Sales Chumn Activated BLASS $5.297 13.813 86,443 95,037 9.500 1711 138.852 26.951 50.409 94.701 12.887 12,404 95.000 8015 90.48 208.879 29.327 70.543 92,720 17,013 65.751 37.747 10.540 100.918 158.935 34258 34.201 M.33 56.121 12,254 85.227 1113 Ch 2017 $2,072 83.300 44.342 90.227 121.420 144.180 28.031 9.36 $1.543 6,341 149.418 24.434 $1,045 13.456 0,584 30.545 Operator NetAdd Month Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Operator Active Base 2 2 2 2 Sales 61,451 59,689 96,701 1.398,547 1,378,514 70,549 1,354,389 58,291 1,349,231 1,332.795 1,300,989 62,390 91,645 1,359.609 66,443 95,037 1.340.675 62,494 95,060 69,751 1.317.024 1.299.568 59,121 97,747 89,227 1.277.575 93,562 1.241.253 66,352 90,227 2,803,767 136,852 2,793,579 99,713 00,000 208,679 2,704,913 100.916 158,935 2,681,152 89,760 151,577 149,418 121.170 144.180 2 3 3 2.648.266 2.605.938 Churn Activated 95,297 92,720 86,983 92.972 13,813 12,887 17,013 12,256 9,860 13,956 9,560 9,015 10,540 8,113 6,341 9,584 26,951 29,327 34,258 28,931 24,434 30,945

Answer rating: 100% (QA)

1 The sales for each operator for the month of May 2018 are as follows ... View the full answer