Al Hashar company have many branches across Oman. They are having a huge work force at different levels working in different areas. The companys accountant is facing difficulty in calculating the pay roll for the employees at the end of each month. You have been appointed by the company as payroll manager to solve the problem. You have observed that the employees are working at different locations, different levels, positions, having different gender. The main branches are at Muscat(H.O), Nizwa , Fahud , Duqm and Salalah. The salary of employees differs based on the Position, location, Gender. Muscat employees get House Rent Allowance each month of RO 100 extra than other location. Female employees are eligible to 50 days annual leave while male employees are eligible to 30 days annual leave. Employees working in Fahud & Duqm get medical for medical insurance of RO 30 per month. Employees working in Marketing department are eligible to travelling allowance of RO 80 extra than other department. The Basic Salary for employees is RO 650 in Muscat, RO 550 in Salalah, RO 500 in Duqm , RO 500 in Fahud and RO 600 in Nizwa.

Other Information

1 Dearness Allowance is 30% of basic.

2 House rent allowance is RO 250

3 Travelling allowance is RO 50

4 Medical insurance as above

5 Deduction for Gratuity is 5% of Gross salary

The Details of employees for the month of April is given below

You are required to Calculate the Net Salary for the employees for the month of April 2020

other details:

Subject Name : Computer Application in Finance

I hope the answer is in Excel Program.

Working days 28 2 30 30 29 5 28 The Details of employees for the month of April is given below Sno Employee Name Gender Location Department 1 Riham Al Khusaibi Female Muscat Accounts Maryam Al-Jabri Female Nizwa Accounts 3 Akram Al Busaidi Male Fahud HR 4 Dawood Al Shuraiqi Male Duqm Marketing Azhar Al-Hinaai Female Salalah Accounts 6 Adil Al-Amri Male Muscat HR 7 Ebrahim Al Mahruqi Male Nizwa Marketing 8 Khalid Al Khatri Male Fahud Marketing 9 Saleem Al junaibi Male Duqm Factory Abdul Samad Al-Kindi Male Nizwa HR 11 Ahmed Al Mahruqi Male Muscat Marketing 12 Rushda Mohammed Al Hinai Male Muscat Accounts 27 30 26 25 10 28 29 30 Male Salalah HR 28 Male Salalah 29 Male 30 Salim Abdullah Al Sulaimani 14 Said Rashid Al Khatri 15 Talal Al Abri 16 Mazin Al-Hoqani 17 Fatema Al Mahrouqi 18 Zainab Al Tamimi Muscat Nizwa Marketing HR Marketing Accounts Female 30 Fahud 26 Female Female Nizwa Accounts 26 You are required to Calculate the Net Salary for the employees for the month of April 2020