All Questions are compulsory 2 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 payroll 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.0), Ibri, Mahyul , Diama and Salalah. The salary of employees differs based on the Position, location, Gender. Muscat employees get House Rent Allowance cach 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 I Dearness Allowance is 20% of basic. House rent allowance is RO 200 3 Travelling allowance is RO 40 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 Employee Name Gender Location Department Working days Aaqeeb Al-Amri Male Abdulla Al-Kindi Male Ahmed Al Mahruqi Marketing Arham Al Busaidi Male Mahyul HR Azhar Al-Hinaai Female Salalah Accounts Dalel Al Abri Male Muscat Faiza Al Mahrouqi Female Mahyul Isah Al Mahruqi Male Ibri Marketing Kashif Al Khatri Male Mahyul Marketing 4 Sno Muscat HR 30 2 Ibri HR 27 3 Male Muscat 28 4 28 5 30 HR 29 7 Accounts 28 8 26 9 26 10 Marwa Al-Jabri Female Ibri Accounts 30 11 Masood Al-Hoqani Female Ibri Marketing 30 6 Male Muscat HR 7 Female Accounts 28 Mahyul Ibri 8 26 Dalel Al Abri Faiza Al Mahrouqi Isahq Al Mahruqi Kashif Al Khatri Marwa Al-Jabri Masood Al-Hoqani 9 Mahyul 26 Male Male Female Female Marketing Marketing Accounts Marketing 10 Ibri 30 11 Ibri 30 3 Female 16 18 28 12 Rashid Al Hinai Male Muscat Accounts 29 13 Rihana Al Khusaibi Muscat Accounts 29 14 Salam Al Sulaimani Male Salalah HR 27 15 Saleem Al Shuraiqi Male Daima Marketing 29 Shiraj Al junaibi Male Daima Marketing 24 17 Zaika Al Tamimi Female Ibri Accounts 29 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
