Consider the following scenario: As supervisor for a retail company, you supervise six people in your location.
Question:
Consider the following scenario:
As supervisor for a retail company, you supervise six people in your location. You are responsible for their payroll and commissions each week.
Use the data provided to create a worksheet described below:
Required:
Create a workbook with separate sheets for each week that would allow sales managers to compare sales figures and commissions from one week to the next. Each worksheet should calculate the payroll amount for each of your six employees. If sales are below $1,000, then the commission paid is 5% of the sales. If sales are between $1,000 and $3,999.99, the commission paid is 10% of the sales. If sales are $4,000 or higher, the sales person receives a 12.5% commission rate.
Sales people will be paid either their commission or hourly pay earned amount?whichever is higher.
Hourly employees receive 150% of their hourly rate for any hours worked over 40 hours per week (time and a half for overtime worked).
Fundamentals of Corporate Finance
ISBN: 978-0077861629
8th edition
Authors: Richard Brealey, Stewart Myers, Alan Marcus