Question: THIS IS AN EXCEL PROBLEM THAT I NEED HELP WITH PLEASE Without using a function, calculate the 5% projection in 2021 using a formula that

THIS IS AN EXCEL PROBLEM THAT I NEED HELP WITH PLEASE

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.

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. THIS IS AN EXCEL PROBLEM THAT I NEED HELP WITH

Sales Projections Manufacturing cost $ 26.80 Sales price $ 75.00 Shipping cost $ 5.83 2021 sales units 10,000 Timeline Current date Launch Factory work days to market 5/26/2021 11/26/2021 -133 Gross Profit From Sales Projections Year-over-year growth estimate 15% 20% 25% 5% 10% 30% 35% 2021 2022 2023 2024 2025 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. 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

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 General Management Questions!

Switch to the Profit Projections worksheet. This worksheet shows cost and sales numbers for 2 0 2 1 , a table similar to the one on the Sales Projections worksheet, and a timeline to launch. The...

Please List the steps to get the answer 9. Switch to the Profit Projections worksheet. This worksheet shows cost and sales numbers for 2021, a table similar to the one on the Sales Projections...

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...

1 3 . Without using a function, calculate the 5 % projection in 2 0 2 4 using a formula that subtracts the manufacturing cost and the shipping cost from the sales price and then multiplies the result...

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...

1. 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...

1 3 . Without using a function, calculate the 5 % projection in 2 0 2 1 using a formula that subtracts the manufacturing cost and the shipping cost from the sales price and then multiplies the result...

Extend the list of years down to 2 0 2 8 . Without using a function, calculate the 5 % projection in 2 0 2 4 using a formula that subtracts the manufacturing cost and the shipping cost from the sales...

Consider the finite-length sequence x[n] in Figure. The five-point DFT of x[n] is denoted by x[k]. Plot the sequence y[n] whose DFT is 3. -1

The important role that leaders/managers (beyond an organizations HR professionals) play in the effective management of the organizations workforce. Provide an example where good line management,...

Stated capital is the amount of capital that under law cannot be returned to the corporations owners except upon liquidation true or false

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...