2018	2019	2020	2021	Total
Gross Sales	3,985.00	4,104.55	4,227.69	4,354.52	16,671.75
Less: Returns & Allowances	79.70	82.09	84.55	87.09	333.44
Net Sales	3,905.30	4,022.46	4,143.13	4,267.43	16,338.32
Direct Materials	811.30	827.53	844.08	860.96	3,343.86
Direct Labor	749.50	779.48	810.66	843.09	3,182.72
Factory Overhead	1,371.02	1,439.57	1,511.55	1,587.13	5,909.27
Cost of Goods Sold	2,931.82	3,046.58	3,166.29	3,291.17	12,435.85
Gross Profit	973.48	975.88	976.85	976.26	3,902.47
General & Admin Exp.	781.06	804.49	828.63	853.49	3,267.66
Profit before Tax	192.42	171.39	148.22	122.77	634.80
Taxes	57.73	51.42	44.47	36.83	190.44
Profit after Tax	134.69	119.97	103.75	85.94	444.36

Nested Ifs and Lookup Tables Applicable tax is summarized as follows: Range Tax If 0 < Profit Before Tax (PBT) <= 50 15% of PBT If 50 < PBT <= 75 7.5 + 25% of (PBT-50) If 75 < PBT 13.75 + 34% of (PBT-75) Based on the above information, perform the following steps: 1. Insert (i.e. Type) the above tax table in cells B29:D31 as follows: B C D 29 0 0 0.15 30 50 7.5 0.25 31 75 13.75 0.34 2. Delete the previous formulas in row 25, and replace them with Nested Ifs in reference to the tax table in cells B29:D31 to compute taxes for years 2018-2021 and the totals in column F. Make sure to use copy command whenever you can. 3. Print the resulting table from Step 2 above (cells A1:F26) into one page and in good format. 4. Print cell formulas in the range B25:F25. If the formulas are too long, you could cut and paste the formulas to another area so that the whole formulas can be shown and printed. 5. Reduce the Gross Sales Growth rate in 1 percent increments until the total profit after tax in cell F26 becomes negative. Print the resulting table (cells A1:F26) again into one page and in good format. 6. Reset the parameters are the original figures. Delete the formulas in row 25, and replace them with Vlookup functions in reference to the tax table in cells B29:D31 to compute taxes for years 2018-2021 and the totals in column F. Make sure to use copy command whenever you can also.