Scribd
Upload
13 views1 page

Practical

The document contains a salary report for employees at Polonnaruwa Super Mart, detailing both temporary and permanent staff, their salaries, working hours, and employee status. It includes a total payment calculation for day laborers and permanent staff, amounting to a combined total of 172,600. Additionally, practical notes outline the formulas used for salary calculations and employee evaluations.

Uploaded by

anuradhasakuna
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
13 views1 page

Practical

The document contains a salary report for employees at Polonnaruwa Super Mart, detailing both temporary and permanent staff, their salaries, working hours, and employee status. It includes a total payment calculation for day laborers and permanent staff, amounting to a combined total of 172,600. Additionally, practical notes outline the formulas used for salary calculations and employee evaluations.

Uploaded by

anuradhasakuna
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Microsoft Excel - Activity

Student ID: - Student Name: -

Polonnaruwa Super Mart


Salary
Day Labours (Temp) Permanent Staff
EMP ID Name Address Contact Number Gender Staff Type
Salary Per Working Hours Working Days Temp EMP Working Days
Salary Per Day Monthly Salary Salary Per Day Monthly Salary
Hour (Per Day) (Per Month) Status (Per Month)

PSME0001 S.D. Kavindu Gihan Polonnaruwa 0714786529 Male Temporary රු. 125.00 8 රු. 1,000.00 10 Bad Employee රු. 10,000.00 - - -
PSME0002 M.K. Theekshana Perera Kaduruwela 0776987235 Male Permanent - - - - - - රු. 1,200.00 22 රු. 26,400.00
PSME0003 I.D.K. Gihani Thashmila Bendiwewa 0701456927 Female Temporary රු. 100.00 8 රු. 800.00 14 Good Employee රු. 11,200.00 - - -
PSME0004 C.N.D. Minakshi Pramodya Girithale 0748653479 Female Permanent - - - - - - රු. 1,000.00 22 රු. 22,000.00
PSME0005 S.A. Ranmalitha Kodithuwakku New Town 0783346923 Male Temporary රු. 125.00 8 රු. 1,000.00 22 Good Employee රු. 22,000.00 - - -
PSME0006 D.M. Menaki Dilhara Diyabeduma 0778586934 Female Temporary රු. 100.00 8 රු. 800.00 19 Good Employee රු. 15,200.00 - - -
PSME0007 P.V. Krishani Sugandi B.O.P. 317 0704478935 Female Permanent - - - - - - රු. 1,000.00 22 රු. 22,000.00
PSME0008 H.M. Saubhagya Adhikari Polonnaruwa 0711238796 Female Temporary රු. 100.00 8 රු. 800.00 3 Bad Employee රු. 2,400.00 - - -
PSME0009 P.T. Supun Chandima Jayanthipura 0718877364 Male Permanent - - - - - - රු. 1,200.00 22 රු. 26,400.00
PSME0010 J.D. Kasun Malaka Hingurakgoda 0779636427 Male Temporary රු. 125.00 8 රු. 1,000.00 15 Good Employee රු. 15,000.00 - - -

Total Payment - Day Labours: - රු. 75,800.00 Total Payment - Normal Staff: - රු. 96,800.00 Total Employee Payment: - රු. 172,600.00

Practical Notes
1. Salary Per Day - Function / Formula
2. Temp EMP Status - Function / Formula (Working Days>11=Good Employee, Working Days<11 Bad Employee)
3. Monthly Salary on Day Labours - Function / Formula
4. Monthly Salary on Permanent Staff - Function / Formula
5. Total Payment - Day Labours - Function / Formula
6. Total Payment - Normal Staff - Function / Formula
7. Total Employee Payment - Function / Formula

You might also like