2 All Questions are compulsory 1 Al Zubair Automotive company have many branches across Oman. They are having a huge work force at different levels working in different areas. The company's 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), Ibri, Mahyul , Diama 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 40 days annual leave while male employees are eligible to 30 days annual leave. Employees working in Mahyul & Diama gets medical insurance of RO 40 per month. Employees working in Marketing department are eligible to travelling allowance of RO 50 extra than other department. The Basic Salary for employees is RO 550 in Muscat, RO 500 in Salalah, RO 450 in Duqm, RO 400 in Mahyul and RO 500 in Ibri. Other Information Dearness Allowance is 20% of basic. House rent allowance is RO 200 Travelling allowance is RO 40 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 Sno Employee Name Gender Location Department Working days Aaqeeb Al-Amri Male Muscat Abdulla Al-Kindi Ahmed Al Mahruqi Marketing Arham Al Busaidi Mahyul Azhar Al-Hinaai Dalel Al Abri Faiza Al Mahrouqi Mahyul Isah Al Mahruqi Marketing Kashif Al Khatri Male Mahyul Marketing Marwa Al-Jabri Female Ihri Accounts 3 HR 30 2 Male Ibri HR 27 3 Male Muscat 28 4 Male HR 28 5 Female Salalah Accounts 30 6 Male Muscat HR 29 7 Female Accounts 28 8 Male Ibri 26 9 26 10 30 11 Masood Al-Hoqani Female Ibri Marketing 30 13 14 29 16 24 28 12 Rashid Al Hinai Male Muscat Accounts 29 Rihana Al Khusaibi Female Muscat Accounts 29 Salam Al Sulaimani Male Salalah HR 27 15 Saleem Al Shuraiqi Male Daima Marketing Shiraj Al junaibi Male Daima Marketing 17 Zaika Al Tamimi Female Ibri Accounts 29 18 Zubair Al Khatri Male Salalah Marketing You are required to calculate the Net Salary for the employees for the month of April 2020 (10 marks) Formatting guidelines: Headings font: Type = Arial = 12, Bold Others font: Type = Arial; Size = 10 Column width: Auto fit Wrap text for headings Merge and center cells: Main Heading, All the cells for amounts = category=Number; Decimal places=0 and Use 1,000 separator, Shade the cells in the Heading row = Light purple Using the formula for calculation