Open the Data File from the D2L content. Save the file as NewSight_DigTechnology.

Analyze the current speaker sales by creating a PivotTable from the Current Sales table.

The company wants to be able to see the sales by channel and location for each of the speaker types.

Add a PivotChart so a visual will be available of the data.

Provide easy ways to filter the data on various fields.

Appropriately label and format all objects and sheets to create a professional document.

On the Critical Thinking Questions sheet, answer the following questions using the PivotTable, PivotChart, and filters:

Which country does the Mini 1 speaker sell best in?

Which speaker sells best in Mexico?

Which speaker has only sold in the US?

Now you will provide help to DIG Technology on analyzing the projected sales of their new product using the What If Analysis tools you have learned in module 8. On the Sales Projections sheet, they have provided the projected gross profit based on a unit price of $159.99 and unit sales of 22,000.

They want to see how the gross profit changes if two variables change, the price per unit and the units sold. Provide a table that will show the gross profit for the following two variables:

Unit prices from $149.99 to $189.99 in intervals of $10.

Units sold from 10,000 to 40,000 in intervals of 5,000.

Format the table appropriately.

Provide a visualization of the data from the table.

On the Critical Thinking Questions sheet, answer the following questions using the data from the table and visualization:

At the Price per unit of $149.99, approximately how many units need to be sold to break even?

Which combination of unit price and units sold provides a gross profit closest to $300,000?

Given this data, what advice would you give DIG technology to make a reasonable gross profit?

To further analyze sales projections for the new Virtual Assistant, the company would like to consider the impact on gross profit if more variables change other than the unit price and units sold. They would like to see the results given three situations:

Status Quo units sold is 22,000, price per unit is $159.99, variable cost per unit is $135.00, and the total fixed cost is $255,000.

Increased Production units sold is 30,000, price per unit is $159.99, variable cost per unit is $132.00, and the total fixed cost is $255,000.

Increased Expenses units sold is 22,000, price per unit is $159.99, variable cost per unit is $137.00, and the total fixed cost is $270,000.

For each of the situations, they would like to see the impact on the Total sales, Total expenses, and Gross profit.

Provide appropriate summary reports that are clearly labeled and easy to interpret.

On the Critical Thinking Questions sheet, answer the following questions using the data generated from step 7 above:

Which situation provides the highest gross profit?

What steps do you recommend to DIG Technology to counteract the potential loss in profit from the Increased Expenses situation?