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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!