$($x$)$ Read Only $-$ Save a copy to edit.

Save a cop

PROJECT STEPS

Danilo Lewellen is an entrepreneur planning to manufacture and market an innovative handheld controller for virtual reality gaming. Danilo is building a business plan as he recruits investors and plans logistics for the launch of his new company, Scrub Jay Peripherals, and wants to use Excel to summarize data and create projections. Switch to the Sales Projections worksheet. The table for yearly sales projections should show year$-$over$-$year growth projections ranging from $5\%$ at the low end to $35\%$ at the high end, from $2021$ through $2025.$

Extend the percentages horizontally up to $35\%.$

Extend the list of years down to $2025.$

AutoFill the formatting from $A7$:$H8$ through to cell $H11$ to format the rest of the table.

Calculate the $5\%$ projection in $2022$ using a formula that multiplies the $2021$ value by the percentage and then adds the $2021$ value to the result. Be sure that the formula always references the percentage row. Copy the formula down to fill the remaining years and then across to fill the remaining percentages.

Switch to the Cost Estimates worksheet, which shows the cost per unit for manufacturing and shipping among various vendors. Danillo wants extra data to help make vendor and shipper recommendations.

Use a function to calculate the average manufacturing cost per unit in the appropriate cell. Use a similar function to calculate the average shipping cost per unit.

Use a function to calculate the maximum manufacturing cost per unit in the appropriate cell. Use a similar function to calculate the maximum shipping cost per unit.

Use a function to calculate the minimum manufacturing cost per unit in the appropriate cell. Use a similar function to calculate the minimum shipping cost per unit.

Use a function in the appropriate cell to determine the best manufacturing candidate based on minimum cost. Specify an exact match in your function since the values are not sorted. Use a similar formula in the appropriate cell to find the best shipping candidate based on minimum cost.$|$Please answer $1-8$