Calculate the 5% projection in 2022 using a formula that multiplies the 2021 value by the percentage and then adds the 2021 value to the result. Be sure that the formula always references the percentage row. Copy the formula down to fill the remaining years and then across to fill the remaining percentages. Switch to the Cost Estimates worksheet, which shows the cost per unit for manufacturing and shipping among various vendors. Danillo wants extra data to help make vendor and shipper recommendations. Use a function to calculate the average manufacturing cost per unit in the appropriate cell. Use a similar function to calculate the average shipping cost per unit. Use a function to calculate the maximum manufacturing cost per unit in the appropriate cell. Use a similar function to calculate the maximum shipping cost per unit. B15 1 2 3 4 5 6 7 8 10 11 12 13 14 A X fx B C D E G Scrub Jay Peripherals Sales Projections Yearly Sales Projections (units) Year-over-year growth estimate 10% 15% 20% 25% 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 5% 2021 10000 2022 2023 2024 2025 F BA 30% 10000 10000 10000 H 35% 10000 10000 10000