Question: 13. Without using a function, calculate the 5% projection in 2024 using a formula that subtracts the manufacturing cost and the shipping cost from the

13. Without using a function, calculate the 5% projection in 2024 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.
-14. Calculate the 5% projection in 2025 by adding 1 to the percentage and then multiplying the result by the 2024 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.
\begin{tabular}{c|c|c|c|} & C & E \\ Scrub Jay Peripherals \end{tabular} Profit Projections \begin{tabular}{|l|l|l|l|r|r|} \hline \multicolumn{2}{|c|}{ Sales Projections } & \multicolumn{3}{|c|}{ Timeline } \\ \hline Manufacturing cost & $ & 26.80 & Current date & 4/20/2023 \\ Sales price & $ & 75.00 & Launch & 11/26/2024 \\ \hline Shipping cost & $ & 5.83 & Factory work days to market & 586 \\ \hline 2024 sales units & & 10,000 & & \end{tabular} Gross Profit From Sales Projections Year-over-year growth estimate 5% 10% 20% 25% 2024 30% 35%
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
