Use excle please

OMASCO LLC have many branches across Oman. The companys accountant in muscat is facing difficulty in calculating the salary of 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 sales locations, different levels, positions, having different gender. The main branches are at Muscat(H.O), Sur , Ibri , Adam and Duqm . 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. Annual leave for Female employees is 45 days and male is 30 days. Employees working in Marketing department are eligible to travelling allowance of 50 extra than other department. Employees working in Sur and Duqm are entitled to Medical allowance due to their location. The Basic Salary for employees is RO 600 in Muscat, RO 500 in Sur, RO 500 in Ibri , RO 450 in Adam and RO 500 in Duqm Other Information 1 Dearness Allowance is 25% of basic. 2 House rent allowance is RO 150 3 Travelling allowance is RO 60 Medical allowance as specified above 5 Deduction for Gratuity is 5% of Gross salary

Please use excle to solve please

CANDO LLC has e The d. The macho... Dep. The way of Alohxech 4dm rade den beweginurkong patendigheid Occordiparus. Hipovedala Sarded Motel di destek The Bank Selyemken har 30 in Sw.1000 450 AM . Home 2 The per il bebek Le War IT IR Med M M M 2 A ENIM There Make Peale HI 11 Na 12 M NA 14 Make Sur 15 TAM Yalova A 13 YA Zainab AIT Make Posle You were received se propertie Mel Salary for the entire web 2018 Stered.com culle: Making The U State the theo 3. OMASCO LLC have many branches across Oman. The company's accountant in muscat is facing difficulty in calculating the salary of 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 sales locations, different levels, positions, having different gender. The main branches are at Muscat(H.O), Sur, Ibri, Adam and Duqm. 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. Annual leave for Female employees is 45 days and male is 30 days. Employees working in Marketing department are eligible to travelling allowance of 50 extra than other department. Employees working in Sur and Duqm are entitled to Medical allowance due to their location. The Basic Salary for employees is RO 600 in Muscat, RO 500 in Sur, RO 500 in Ibri, RO 450 in Adam and RO 500 in Duqm Other Information Dearness Allowance is 25% of basic. House rent allowance is RO 150 3 Travelling allowance is RO 60 2 4 Medical allowance as specified above Deduction for Gratuity is 5% of Gross salary 5 3. OMASCO LLC have many branches across Oman. The company's accountant in muscat is facing difficulty in calculating the salary of 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 sales locations, different levels, positions, having different gender. The main branches are at Muscat(H.O), Sur, Ibri, Adam and Duqm. 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. Annual leave for Female employees is 45 days and male is 30 days. Employees working in Marketing department are eligible to travelling allowance of 50 extra than other department. Employees working in Sur and Duqm are entitled to Medical allowance due to their location. The Basic Salary for employees is RO 600 in Muscat, RO 500 in Sur, RO 500 in Ibri, RO 450 in Adam and RO 500 in Duqm Other Information Dearness Allowance is 25% of basic. House rent allowance is RO 150 3 Travelling allowance is RO 60 2 4 Medical allowance as specified above Deduction for Gratuity is 5% of Gross salary 5 The Details of employees for the month of June is given below Sno Employee Name Gender Location Department Working days Abdullah Al Farqani Male Muscat HR 27 2 Abdullah Al Sulaimani Male Sur HR 28 3 Ahmed Al Mahruqi Male Muscat Marketing 29 4 Basma Al Abri Female Muscat Accounts 28 5 Ebtihal Al Subhi Female Ibri Accounts 30 6 Eman Al Mahrouqi Female Adam Accounts 26 7 Jawaher Al Aamri Female Sur Accounts 28 8 Mahmood Al Hadhrami Male Ibri Marketing 30 9 Mazin Al-Hoqani Female Ibri Marketing 30 10 Mohammed Al Nadabi Male Adam Marketing 26 11 Rushda Mohammed Al Male Muscat Accounts Hinai 30 12 Said Al Mahrooqi Male Duqm HR 28 13 Saleem Al-Majizi Male Duqm Marketing 25 14 Sulaiman Al Khatri Male Sur Marketing 29 15 Talal Al Abri Male Muscat HR 30 16 Yahya Al Shuaili Male Adam HR 30 17 Yaseer Ali Al Hanai Male Duqm Accounts 29 18 Zainab Al Tamimi Female Ibri Accounts 26 You are required to prepare the Net Salary for the employees for the month of June 2019