Suppose you are given the following data related to a week on each employee of a company: Employee code Employee Type Hours worked during the week Basic wage in Rupees per hour Number of pieces produced The basic wage in Rs/hour for a worker is not directly known. All employees are divided into five types A, B, C, D, and E. The basic wage varies from one type to another as shown in the following table: Employee Type Basic Wage A 20 B 25 C 30 D 40 E 45 Further, the following data that applies to all employees is also given: Standard rate of production in number of pieces per hour : 10 pieces per hour Extra pay (or, incentive pay) for each piece produced over and above the standard production, in Rupees per piece: 5 Rupees per piece Design a spreadsheet to contain the above data, and to compute using this data the following: For each employee, the regular pay for the week For each employee, the incentive wage, if any, for the week For each employee, the total pay for the week For all the employees put together, the sum of regular, incentive, and total pay Total sum of the incentive pay as a percentage of the sum of total pay. These formulae are devised based on the following rules: Extra production = Maximum of {(actual production- standard production),0} Regular pay = Basic wage in Rs per hour * hours worked Incentive pay = Extra production * incentive rate in Rs per piece Total pay = Regular pay + incentive pay Employee Code Employee Type Hours worked Pieces produced E1 A 40 440 E2 B 48 530 E3 E 56 490 E4 D 80 600 E5 C 20 200 E6 A 32 400 E7 A 45 600 E8 E 55 480 E9 D 50 540 E10 A 60 620