Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The following worksheet shows the salary calculations for employees in the sales department of a company. A B C D E 1 2 SALARY CALCULATIONS
The following worksheet shows the salary calculations for employees in the sales department of a company.
| A | B | C | D | E |
1 |
|
|
|
|
|
2 | SALARY CALCULATIONS | ||||
3 | EMPLOYEES NAMES | MARITAL STATUS | BASIC SALARY | MONTHLY SALES | DEDUCTIONS |
4 | Barak M.O. | Married | 27000 | 250000 | 8000 |
5 | Njuguna S. M. | Single | 23000 | 234000 | 3000 |
6 | Odhiambo W. O. | Married | 28000 | 170000 | 4500 |
7 | Macharia R. M. | Married | 17000 | 213000 | 7000 |
8 | Wanjiku E. M. | Single | 22000 | 234000 | 5200 |
9 | Kioo J. M. | Single | 14000 | 567000 | 3200 |
10 | Boit T. | Married | 18000 | 123000 | 5000 |
11 |
|
|
|
|
|
- Open a new workbook and save it as QUESTION TWO. (1 Mark)
- Enter the data above with the necessary format into the first worksheet of QUESTION TWO workbook and rename the worksheet as Salaries. (2 Marks)
- Make the Main heading to be Bold, Arial and size 16. The contents of cells A3:E3 should be size 14. The original numeric data should have a KSH currency format.(4 Marks)
- Calculate the commission for each employee if an employee is entitled to 4% commission on the monthly sales. (2 Marks)
- Calculate the monthly relief, which is 5% of the basic pay for the married employees. (2 Marks)
- Use an appropriate logical test to determine if an employee is entitled to the monthly relief. (3 Marks)
- Calculate the net pay for each employee. (2 Marks)
- On the second worksheet of the workbook, plot a column chart to compare the basic salaries and the net salaries of the employees. Rename this sheet as Chart. (4 Marks)
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