Question

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 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

This is only a preview of the solution. Please use the purchase button to see the entire solution

Related Homework Solutions

Business Questions - Organizational Management
Homework Solution
$30.00
Business
Organisation
Design
Structure
Organizational Chart
Mechanistic
Organic
Management
Effectiveness
Change
Learning
Competitive Advantage
HR
Work Environment
Motivation
Innovation
Maslow’s Hierarchy
Needs
Privacy Risk Analysis (6 slides)
Homework Solution
$43.00
Business
Privacy
Risk
Analysis
Employee
Employer
Company
Information
Email
Data
Leakage
Hackers
Internet
Monitoring
Training
Investment
Building an Effective Global Business Team
Homework Solution
$120.00
Business
Administration
Finance
Economics
Management
MGI Team
HBS Students
Companies
Projects
Leadership
Human Resources
Working Environment
Diversity
Patagonia - Employees' Motivation Analysis (580 Words)
Homework Solution
$43.00
Business
Company
Patagonia
Motivation
Analysis
Consultant
Work Environment
Social Responsibility
Flex-time Working
Innovation
Environmental Preservation
Competitive Salaries
Day Care
Ethical Company
CSR
Activities
Cooperative Culture
Get help from a qualified tutor
Live Chats