Scribd Logo
Upload

Welcome to Scribd!

  • 11 views

    Checking

    Uploaded by

    pratik
    The document shows Phoenix Car Insurance quarterly sales data for 8 agents, including their policy sales amounts for October, November and December, their quarterly totals, percentage of the company total, sales targets, and any bonuses earned. Overall the total sales were $543,050 for the quarter, exceeding the company target of $505,000. The total commissions paid were $78,216, with the highest earning agent receiving $21,440 for exceeding their target by 34%.

    Copyright:

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

    Checking

    Uploaded by

    pratik
    11 views2 pages
    The document shows Phoenix Car Insurance quarterly sales data for 8 agents, including their policy sales amounts for October, November and December, their quarterly totals, percentage of the company total, sales targets, and any bonuses earned. Overall the total sales were $543,050 for the quarter, exceeding the company target of $505,000. The total commissions paid were $78,216, with the highest earning agent receiving $21,440 for exceeding their target by 34%.

    Original Description:

    Checking of advanced spreedsheets

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document shows Phoenix Car Insurance quarterly sales data for 8 agents, including their policy sales amounts for October, November and December, their quarterly totals, percentage of the company total, sales targets, and any bonuses earned. Overall the total sales were $543,050 for the quarter, exceeding the company target of $505,000. The total commissions paid were $78,216, with the highest earning agent receiving $21,440 for exceeding their target by 34%.

    Copyright:

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

    Checking

    Uploaded by

    pratik
    The document shows Phoenix Car Insurance quarterly sales data for 8 agents, including their policy sales amounts for October, November and December, their quarterly totals, percentage of the company total, sales targets, and any bonuses earned. Overall the total sales were $543,050 for the quarter, exceeding the company target of $505,000. The total commissions paid were $78,216, with the highest earning agent receiving $21,440 for exceeding their target by 34%.

    Copyright:

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

    Phoenix Car Insurance (Quarter 4)

    Policy Sales Commission & Bonuses

    Agent Code Oct Nov Dec Qtr4 % of Total Target Bonus


    S0067 15,000 16,500 18,250 49,750 9.16% 51,000 0
    S1068 25,000 22,000 18,500 65,500 #DIV/0! 55,000 2,620.00
    A5543 8,000 12,750 15,000 35,750 #DIV/0! 40,000 0
    J2401 20,000 27,500 34,250 81,750 #DIV/0! 75,000 3,270.00
    S2000 13,900 21,400 40,000 75,300 #DIV/0! 80,000 0
    D4409 18,000 19,000 19,000 56,000 #DIV/0! 64,000 0
    E3250 16,000 17,000 12,000 45,000 #DIV/0! 40,000 1,800.00
    N8511 27,500 40,000 66,500 134,000 #DIV/0! 100,000 5,360.00
    TOTAL 143,400 176,150 223,500 543,050 #DIV/0! 505,000 13,050.00
    Commission 12%
    Bonus 4%

    Total % of Target
    $5,970.00 97.5%
    $10,480.00 119.1%
    $4,290.00 89.4%
    $13,080.00 109.0%
    $9,036.00 94.1%
    $6,720.00 87.5%
    $7,200.00 112.5%
    $21,440.00 134.0%
    $78,216.00 107.5%

    You might also like