Assume that you are working as an Accountant in Gypsum (SAOC) Company, Salalah. One of the important roles of your job is the preparation of the monthly Salary Sheet for all employees working in the company, by using a spreadsheet in Excel. Therefore, by 15 of every month, you are required to input general details of employees like Name, Employee ID, along with Salary particulars includes Basic Salary, Dearness Allowances, House Rent Allowance, and other allowances in a spreadsheet. Apart from these, input the details of salary advances, Pension Contribution, and any other deductions from salary as per the agreement of the employment in the same salary sheet. Thereafter, you have to send this sheet for approval from the Finance Manager and then, once approved it will be forwarded to Human Resource Manager. Here you are provided with June 2020 month salary, allowances, and deductions from salary particulars of sixteen employees working in the HR Department. By using the given data, you are required to construct the Salary Sheet Spreadsheet for the month of June for sixteen employees with complete information. All amounts in OMR only. S1 DA Name of the HRA Employee Other Total Allowances Salary Advance Salary Net Salary 500 Salary 1400 1500 1500 1200 1100 400 300 400 1 176158 Ms. Muda 2 176123 Mr. Nasser 3 176001 Mr. Khalid 4 176145 Mr. Bassam 5 176125 Mr. Yousel 6 176225 Ms. Mizoon 7 176201 Ms. Tatool 176185 Mr. Ahmed 9 176152 Ms. Noor 10 176120 Mr. Salim 11 176132 Ms. Salma 12 176148 Ms. Ghada 13 176150 Marwan 14 176106 Ms. Manwa 15 176151 Mr. Salim 16 176129 Mr. Said 900 900 1500 1400 1400 300 400 1500 1200 Mr. 1500 200 1200 400 1500 1200 SIP Required: Complete the table as per the following specifications using formula in MS Excel a) DA is 50% of Basic Salary: HR allowance is 25% of Basic Salary, while other allowances are 25% of Basic salary Calculate the total salary for each employee. c Contribution for PF is to be deducted from each employee's salary at 5% of the total What is the balance payable to each employee after deductions? b) salary d)