First of all, need to use Excel answer questions within the text of the case. Need Excel chart.
A. Develop a worksheet that can determine each salesperson’s base pay, commission, and gross pay.
B. Ensure that proper calculations are done for each employee’s pay based on Mr. Tarkio’s inputs.
C. Create a separate Weekly Productivity Report.
After that, please answer Information specification questions.
1. On average, how frequently will the sales staff make their quota?
2. What are the commissions and total sales for each sales position by department?
3. What are the base pay, commission, and gross pay categorized by sales position?
4. What are the total salaries and hours worked by department?
5. Which department’s staff met their quotas more often than other departments? Least?
I will also upload excel chart need to use.