Question
Could someone help me with this excel homework, please? I have posted all the information necessary... I took a screenshot of all the instructions. Thanks
Could someone help me with this excel homework, please? I have posted all the information necessary... I took a screenshot of all the instructions.
Thanks in advance! Sales Commission Objective: Using nested formulas, If a function, and logical (AND/OR) functions The starting of the year 2008 provided a great setback to the US industry. Companies like Citi group, Merill Lynch, and JP Morgan have shown exceptional losses, and the recession seems to be a reality rather than a rumor. In this turbulent market, UBM computers presented exceptional results and proved that even in recessionary conditions, companies have still not cut their IT expenditure. To reward its high profile sales team, UBM decided to offer 12% bonus to each of its employee whose salary is at least $100000 but not greater than $200000 in the year 2007. Following table provides a summary of salaries of UBM employees in the Michiana area. Determine the total pay-package, salary, and bonus of these employees for the year 2007.
Guidelines: First enter all the input data, as shown in the figure 1 (input data are highlighted in the green shade). Now to find the bonus information, enter If and AND function and use cell referencing. Subsequently, add bonus and salary together to find the total package. Your final solution should be similar to the one shown in the figure 2
figure 1
figure 2
Employee Salary Vivian Richards 87925 Malcolm Marshal 100000 Alan Border 145000 Steven Fleming 200750 Shane Warne 178650 Kris Shrikanth 99555 Steve Waugh 147000 Richard Hadley 213450 Ian Bothom 122680 Don Bradman 92500 BC Salary Bonus DIE Total Package Lower Limit Upper Limit Bonus (%) 87925 87925 100000 200000 12% Employee Vivian Richards Malcom 3 Marshal 4 Alan Border Steven 5 Fleming 6 Shane Warne 7 Kris Shrikanth 8 Steve Waugh 100000 145000 112000 12000 17400 162400 21438 200750 178650 99555 147000 200750 200088 99555 164640 17640 9 Richard Hadley 10 Ian Bothom 11 Don Bradman 213450 122680 9 2500 14721.6 213450 137401.6 92500 Employee Salary Vivian Richards 87925 Malcolm Marshal 100000 Alan Border 145000 Steven Fleming 200750 Shane Warne 178650 Kris Shrikanth 99555 Steve Waugh 147000 Richard Hadley 213450 Ian Bothom 122680 Don Bradman 92500 BC Salary Bonus DIE Total Package Lower Limit Upper Limit Bonus (%) 87925 87925 100000 200000 12% Employee Vivian Richards Malcom 3 Marshal 4 Alan Border Steven 5 Fleming 6 Shane Warne 7 Kris Shrikanth 8 Steve Waugh 100000 145000 112000 12000 17400 162400 21438 200750 178650 99555 147000 200750 200088 99555 164640 17640 9 Richard Hadley 10 Ian Bothom 11 Don Bradman 213450 122680 9 2500 14721.6 213450 137401.6 92500Step 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