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