How to solve

a contain viruses. Unless you need to edlit it's safer to stay in Protected View,

Enable Editing

$8.$ In cell C$14,$ identify the vendor with the lowest cost per unit by creating a formula using the VLOOKUP function to look up the value from cell $812($the lowest vendor cost$)$ in the range B$5$:C$8($the vendor cost per unit table$),$ return the name of the vendor $($column $2),$ and specify an exact match. Copy the formula to cell F$14$ to identify the shipper with the lowest cost per unit.

$9.$ Switch to the Profit Projections worksheet, which sets a schedule for developing and launching the new product and projects its profits for five years. In cell $17,$ use the TODAY function to insert the current date.

$10.$ In cell $19,$ create a formula that uses the NETWORKDAYS function to calculate the number of working days between the dates in cells I$7$ and I$8.$ Leave the Holidays argument blank.

$11.$ Use the values in the range C$14$:D$14$ to fill the range E$14$:I$14$ with a series of incremented percentages.

$12.$ Use the values in the range $B15$:$B16$ to extend the list of years to the range $B17$ :B$19$ for five years of projections.

$13.$ Estimate the gross profit for $2024$ as follows:

a$.$ In cell C$15,$ create a formula without using a function that subtracts the vendor cost $($cell c$7)$ and the shipping cost $($cell $09)$ from the sales price $($cell cB$),$ and then multiplies the result by the projected number of units for sale in $2024($cell C$11).$

b$.$ Use absolute references to each cell in the formula.

c$.$ Copy the formula from cell C$15$ to the range D$15$:I$15$ to complete the estimates for $2024.$

a contain viruses. Unless you need to edlit it's safer to stay in Protected View,

Enable Editing

$8.$ In cell C$14,$ identify the vendor with the lowest cost per unit by creating a formula using the VLOOKUP function to look up the value from cell $812($the lowest vendor cost$)$ in the range B$5$:C$8($the vendor cost per unit table$),$ return the name of the vendor $($column $2),$ and specify an exact match. Copy the formula to cell F$14$ to identify the shipper with the lowest cost per unit.

$9.$ Switch to the Profit Projections worksheet, which sets a schedule for developing and launching the new product and projects its profits for five years. In cell $17,$ use the TODAY function to insert the current date.

$10.$ In cell $19,$ create a formula that uses the NETWORKDAYS function to calculate the number of working days between the dates in cells I$7$ and I$8.$ Leave the Holidays argument blank.

$11.$ Use the values in the range C$14$:D$14$ to fill the range E$14$:I$14$ with a series of incremented percentages.

$12.$ Use the values in the range $B15$:$B16$ to extend the list of years to the range $B17$ :B$19$ for five years of projections.

$13.$ Estimate the gross profit for $2024$ as follows:

a$.$ In cell C$15,$ create a formula without using a function that subtracts the vendor cost $($cell c$7)$ and the shipping cost $($cell $09)$ from the sales price $($cell cB$),$ and then multiplies the result by the projected number of units for sale in $2024($cell C$11).$

b$.$ Use absolute references to each cell in the formula.

c$.$ Copy the formula from cell C$15$ to the range D$15$:I$15$ to complete the estimates for $2024.$