Sales section. The section has 8 salespersons. Their base pays vary from $12,000 to $36,000 per annum, according to their seniority, and are given corresponding sales targets. In addition, they get 5% commission of all sales they bring in and an additional 1% point commission for every dollar they sell above their targets. Any salesperson who sells $1 million or more gets an additional bonus of $2,000. The salespersons are ranked according to the percentage they achieve above their targets. Only if the person exceeds target, the first and second top ranked each get an incentive trip to the annual sales convention and a five-day all expenses paid vacation there for four. This year, it is in Hawaii and the incentive package is worth $6,000.
a. Construct a spreadsheet model for this. Simulate 8 salesperson’s data and compute the individual salesperson’s commission, bonus, incentive, and total compensation.
b. For your data, what is the total compensation the company has to give out?
c. What percentage of the compensation is for base pay, commission, bonus, and incentive?
d. Would you recommend any changes in the pay structure? Why?

Solution PreviewSolution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

Business Questions
    $55.00 for this solution

    PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

    Find A Tutor

    View available Business - Other Tutors

    Get College Homework Help.

    Are you sure you don't want to upload any files?

    Fast tutor response requires as much info as possible.

    Upload a file
    Continue without uploading

    We couldn't find that subject.
    Please select the best match from the list below.

    We'll send you an email right away. If it's not in your inbox, check your spam folder.

    • 1
    • 2
    • 3
    Live Chats