In cell B$12,$ find the lowest vendor cost per unit by creating a formula using the MIN function to identify the minimum value in the range B$5$:B$8.$ Copy the formula to cell E$12$ to find the lowest shipping cost per unit.

In cell $C14,$ identify the vendor with the lowest cost per unit by creating a formula using the VLOOKUP function to look up the value from cell B$12($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.

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 I$7,$ use the TODAY function to insert the current date.