Answered step by step
Verified Expert Solution
Question
1 Approved Answer
FLI'H'I [F J. acltson's Guitars uses an incentive scheme to pay itsr salespeople- All employees are paid a base atainer and sales in excess of
\"FLI'H'I [F J. acltson's Guitars uses an incentive scheme to pay itsr salespeople- All employees are paid a base atainer and sales in excess of the quota set for each employee are subject to an extra ommission. Details for july are as follows. 1 Jackson's Guitars p oyee Mont y Ea es Sales Name Retainer Quota Achieved W Figure 1: .I'ocirson's Guitars Soles Data ommlsslon Scales: I Sales in excess of quota from $0 to $5,030 get 10% commission I Sales in excess of quota from $5,001 to $10,000 get 159-6 commission I Sales in excess of quota from $10,001 to $15,000 get 20% commission I Sales in excess of quota greater than $15,001 get 2535 commission .equired: Task 1. On a new worksheet in the same workbook, create a spreadsheet model to calculate the total wage {including commission earned} for each empioyee- The IF statement must be used in your model- Format your range as table to reflect corporate colours- Name your worksheet as Assessment Activity 2 - Part Axlsx. Task 1. Then, highlight the employees with a green flag whose total wage is higher than $4,000 [e.g.- I $6,0[ll I sLEDoJ and with a red fiag whose total wage is lower than $2,000 [e_g_;. Task 3. Caiculate the following using appropriate functions: 3.1. How much commission and gross wage paid to employees in total? 3.2. What is the average monthly retainer paid to employees? 3.3. How many employees are working in Jackson's Guitar and what is The number of employees who are eligibie to receive commission? 3.4. What are the lowest sales achieved? What is the highest sale achieved
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started