Create a column named Bonus and calculate the Bonus for all the rows using the following instructions: If the Sale Amount is greater than or equal to 15000, then the bonus will be 10% of the Sale Amount If the Sale Amount is between 8000 to 15000, then the bonus will be 7% of the Sale Amount. Otherwise, the bonus will be 3% of the

1. Create a column named Bonus and calculate the Bonus for all the rows using the following instructions:

If the Sale Amount is greater than or equal to 15000, then the bonus will be 10% of the Sale Amount

If the Sale Amount is between 8000 to 15000, then the bonus will be 7% of the Sale Amount.

Otherwise, the bonus will be 3% of the Sale Amount.

2. Create a column named Provident Fund and calculate the Provident Fund for all the rows using the following instructions:

If the Salary is greater than or equal to 42000, then the Provident Fund will be 12% of the Salary

If the Salary is between 35000 and 42000, then the Provident Fund will be 8% of the Salary.

Otherwise, the Provident Fund will be 4% of the Salary

3. Now, create a column named Monthly Income and calculate the Monthly Income by using the formula:

Monthly Income = Salary+Bonus- Provident Fund

4. Now, create a column named Employee Type and fill the Employee Type column with Platinum, Golden and Silver,Bronze, Copper,Aluminum. If the Monthly Income is:

>= 40000, then the employee type is Platinum

>= 38000, then the employee type is Bronze

>= 35000, then the employee type is Copper

>= 30000, then the employee type is Golden

>= 25000, then the employee type is Aluminum

Else, the employee type is Silver

5. Now, find out what percentage of the employees are of which type. You will have to display this in a pie chart and a bar chart. Follow steps:

1. In the same sheet, below the table of Table 1: Income Record, generate a small table with 2 columns (Employee Type and No. of Employees).

2. Give a header Table 2: For Charts to the table.

3. In the Type column, write all the types from Platinum to Silver. Then, for the No. of Employees column, use a COUNTIF function to find the number of employees who fall under the type in the left cell. Then, use this table to generate a pie chart and bar chart.

Please help by giving instructions on how to complete each step in Microsoft excel or google spreadsheet. Such as what formulas to put and how to complete each part. Here is the link file in the spreadsheet for convenience

https://docs.google.com/spreadsheets/d/1vkFYzWTLWuKRAjVzAhJMn_mm7K31WbvXDYBPfPbNk64/edit?usp=sharing

Thank you so much