Fill in the calculations for sales revenue, totalcost, and gross profit columns in the Data worksheet.

There are some typographical errors in the data set in the Region fields. Find and correct these errors by using a pivot table. Analyze sales revenue by inserting a pivot chart that shows the sales revenue trend by region over the four-year period.

Analyze sales revenue, variable cost, and contribution margin for each year for each region using a pivot table.

Analyze contribution margin by using a pivot table.

Analyze the contribution margin ratio by using a pivot table. Sort the collections by contribution margin ratio, from the largest to the smallest.

Analyze segment margin and operating income for 2018 using the table provided.

This project only has one attempt. Review the check figures with your data file results before answering the questions. If your check figures do not match, do not proceed with answering the questions until you have asked for assistance from your instructor.

Using the data worksheet for Requirement 1 in Kitchen Life, what is the contribution margin for customer number 291137 on 1/18/2015? (To find customer 291137 in Excel, in the Homeribbon, click on Find & Select and choose the option toFind.)

$5,889.38

$1,982.40

$1,331.71

$3,906.98

Using the pivot table you created for Requirement 2 in Kitchen Life, what were total sales for 2016 in the Southwestregion?

$18,958,413.57

$8,992,565.62

$14,925,242.98

$21,271,784.69

Using the pivot table you created for Requirement 3 in Kitchen Life, what was the contribution margin for the Gulf Coast region in 2015?

$7,520,767.75

$4,569,689.88

$5,054,947.82

$6,987,241.54

Using the pivot table you created for Requirement 4 in Kitchen Life, what was the most profitable brand in

2018, as measured by contribution margin?

Au Courant

Classique

Using the pivot table you created for Requirement 5 in Kitchen Life, what was the most profitable collection in 2018, for the Classique brand as measured by the contribution marginratio?

Rochester

Key West

Syracuse

Aiden

Using the data set for requirement 6 in Kitchen Life, what was the segment margin for the Pacific Northwestregion?

$3,911,361

$2,360,899

$185,500

$7,119,819

This question already exists on the platform, I need the answer.

Check Figures Check Figures