Excel Data Analysis
STAFF NAME
MOSES BENSON
JACKSON MORRIS
NGOZI MORGAN
JOY MORGU
WILLIAMS NOBIS
JACK BROWN
LINDA MIRA
MANDELA DIM
JAMES WALKER
MEDICAL
FEEDING
TRANSPORT HOUSING
ALLOW
ALLOW
ALLOW
BASIC SALARY ALLOW
$78,000.00
$7,800.00
$5,460.00
$3,900.00
$6,240.00
$101,000.00
$10,100.00
$7,070.00
$5,050.00
$8,080.00
$88,000.00
$8,800.00
$6,160.00
$4,400.00
$7,040.00
$97,000.00
$9,700.00
$6,790.00
$4,850.00
$7,760.00
$120,000.00
$12,000.00
$8,400.00
$6,000.00
$9,600.00
$77,000.00
$7,700.00
$5,390.00
$3,850.00
$6,160.00
$130,000.00
$13,000.00
$9,100.00
$6,500.00 $10,400.00
$120,000.00
$12,000.00
$8,400.00
$6,000.00
$9,600.00
$145,000.00
$14,500.00 $10,150.00
$7,250.00 $11,600.00
Row Labels
JUNIOR
JACK BROWN
MOSES BENSON
NGOZI MORGAN
SENIOR
JACKSON MORRIS
JAMES WALKER
JOY MORGU
LINDA MIRA
MANDELA DIM
WILLIAMS NOBIS
Grand Total
SALARY
% OF SALARY
₦243,-%
₦77,-%
₦78,-%
₦88,-%
₦713,-%
₦101,-%
₦145,-%
₦97,-%
₦130,-%
₦120,-%
₦120,-%
₦956,-%
TAX
$2,340.00
$3,030.00
$2,640.00
$2,910.00
$3,600.00
$2,310.00
$3,900.00
$3,600.00
$4,350.00
GROSS
PAYMENT
NET PAYMENT RANK
$101,400.00
$99,060.00 JUNIOR
$131,300.00
$128,270.00 SENIOR
$114,400.00
$111,760.00 JUNIOR
$126,100.00
$123,190.00 SENIOR
$156,000.00
$152,400.00 SENIOR
$100,100.00
$97,790.00 JUNIOR
$169,000.00
$165,100.00 SENIOR
$156,000.00
$152,400.00 SENIOR
$188,500.00
$184,150.00 SENIOR
SALARY % OF SALARY
JUNIOR
RANK
STAFF NAME
SENIOR
WILLIAMS NOBIS
MANDELA DIM
LINDA MIRA
JOY MORGU
JAMES WALKER
JACKSON MORRIS
NGOZI MORGAN
MOSES BENSON
JACK BROWN
₦160,000.00
₦140,000.00
₦120,000.00
₦100,000.00
₦80,000.00
₦60,000.00
₦40,000.00
₦20,000.00
₦0.00
16.00%
14.00%
12.00%
10.00%
8.00%
6.00%
4.00% Values
2.00%
SALARY
0.00%
% OF SALARY