1. Fill in the calculations for sales revenue, total cost, and gross profit columns in the Data worksheet.

2. 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.

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

  

 

Transcribed Image Text:

B3 X A fx Intermountain 1 Segment Margin Report 2 For Year of 2018 3 4 Sales revenue 5 Less variable expenses 6 Contribution margin 7 Less direct fixed expenses 8 Segment margin 9 Less common fixed costs allocated to regions 10 Operating income (loss) 11 12 13 14 15 B Intermountain C Mid Atlantic D International E F G Great Plains Atlantic Northeast Pacific Northwest H Gulf Coast | Southwest J Total of all regions K B3 X A fx Intermountain 1 Segment Margin Report 2 For Year of 2018 3 4 Sales revenue 5 Less variable expenses 6 Contribution margin 7 Less direct fixed expenses 8 Segment margin 9 Less common fixed costs allocated to regions 10 Operating income (loss) 11 12 13 14 15 B Intermountain C Mid Atlantic D International E F G Great Plains Atlantic Northeast Pacific Northwest H Gulf Coast | Southwest J Total of all regions K

Answer rating: 100% (QA)

Question 1 Fill in the calculations for sales revenue total cost and gross profit columns in the Data worksheet Answer The calculations for sales reve... View the full answer