Question
13. Without using a function, calculate the 5% projection in 2021 using a formula that subtracts the manufacturing cost and the shipping cost from
13. Without using a function, calculate the 5% projection in 2021 using a formula that subtracts the manufacturing cost and the shipping cost from the sales price and then multiplies the result by the number of sales units. The formula should always reference those exact cells. Copy the formula across the row. Use absolute references in a formula. X Create a formula without a function. In the Profit Projections worksheet, the formula in cell B13 should subtract the values in cell 85 and cell 87 from the value in cell B6, and then multiply the result by the value in cell 88. X Copy a formula into a range. In the Profit Projections worksheet, cell B13 contains an incorrect formula. 14. Calculate the 5% projection in 2022 by adding 1 to the percentage and then multiplying the result by the 2021 projection. Update the formula to always reference the percentage row. Copy the formula down to fill the remaining years, and then across to fill the remaining percentages. X Use a mixed reference in a formula. In the Profit Projections worksheet, the formula in cell B14 should contain a mixed reference to cell B$12. X Create a formula without using a function. In the Profit Projections worksheet, the formula in cell B14 should add 1 to the value in cell B12, and then multiply the result by the value in cell B13. X Copy a formula into a range. In the Profit Projections worksheet, cell B14 contains an incorrect formula. X Copy a formula into a range. Sales Projections B fx =($B$6-$B$5-$B$7)*$B$8*812 C D E Manufacturing cost $ ales price hipping cost 555 26.80 75.00 $ 5.83 021 sales units 10,000 Current date Launch G H Timeline 9/2/2021 11/26/2021 62 Factory work days to market Gross Profit From Sales Projections Year-over-year growth estimate 5% 10% 15% 20% 25% 30% 35% 2021 $ 2022 $ 21,185.00 $ 1,271.10 $ 42,370.00 $ 63,555.00 $ 84,740.00 $ 105,925.00 $ 127,110.00 $ 148,295.00 2,542.20 $ 3,813.30 $ 5,084.40 $ 6,355.50 $ 7,626.60 $ 8,897.70 2023 $ 76.27 $ 152.53 $ 228.80 $ 305.06 $ 381.33 $ 457.60 $ 2024 $ 4.58 $ 9.15 $ 2025 $ 0.27 $ 0.55 $ 13.73 $ 0.82 $ 18.30 $ 22.88 $ 27.46 $ 533.86 32.03 1.10 $ 1.37 $ 1.65 $ 1.92
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Lets break down the requirements and the solution for each step Part 1 Calculate the 5 Projection fo...Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started