AutoSave OFF WorkTech_MAC (3) Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) 11 A A Wrap Text General [A Paste BI U A Merge & Center 030 Distribution channel 2 3 Catalog 4 Store Website $%9 1 7 Conditional Format Cell Formatting as Table Styles B C D G H | J Contribution margin (CM) by distribution channel Total Catalog contribution margin $ 76,952 Overall distribution channel segment margins: Current year Catalog Store Website 10 Sales revenue 11 Variable cost of goods sold $ $ 150,990 74,038 100.0% $ 175,520 49.0 % $ 85,235 100.0% $ 299,430 48.5% $ 195,441 100.0% 65.6% 12 Total contribution margin $ 76,952 51.0 % $ 90,285 51.4% $ 102,989 34.4% 13 Direct fixed costs $ 11,000 $ 16,000 $ 24,000 14 Segment margin $ 65,952 $ 74,285 78,989 15 16 17 57999 18 19 20 21 $17,306 515,247 22 $6,926 23 5490 24 + 52885 $1,00 $40 25 26 27 28 29 30 C Cand Cphones Comp Nefcion Leafeni Nonfiction Sell P W 31 The MOST Catalog CM was provided by the product TV and video 32 The LEAST Catalog CM was provided by the product Nonfiction - History 33 34 35 36 37 38 39 40 dashboard + Ready Accessibility: Investigate Cata Product Share Comments Insert Delete Format v me v Sort & Filter Find & Select Analyze Data Tasks M N 0 P a R Contribution margin (CM) by product Calendars CM provided by Calendars: Current vs. prior year Camera and photo Cell phones Computers Nonfiction History Nonfiction Leadership Nonfiction Self-help Nonfiction Technology Store San Store W 5424 CM provided by Calendars: Current year T Distribution channel Catalog Current Contribution margin Prior 5 S 190 207 %A Prior year 39.16% 2302.98% Contribution $ $ Website 5 Grand Total $ 424 1,721 11.85% 125.13% $ $ Top 5 CM ratios sold via the Calendars distribution channel Camera and photo Nonfiction Leadership IV and video Computers Cell phones CM ratio - Current year 61.34% 58.48% 53.92% 49.36% 48.45% The Catalog product with the HIGHEST CM ratio was Camera and p The Catalog product with the LOWEST CM ratio was Nonfiction - T 100%