- What is the total contribution margin for Jubilee Superstores for the current year? (You will need to add some numbers on the dashboard to arrive at the total contribution margin for the current year.)
- What product had the highest CM ratio in the Store distribution channel in the current year?
- What was the CM ratio for the product with the highest CM ratio in the Store distribution channel in the current year?
Contribution margin (CM) by distribution channel Product Distribution channel Y Calendars A Catalog Total Catalog contribution margin $55,031 Camera and photo Contribution margin (CM) by product CM provided by Calendars: Current vs. prior year Current Prior Distributi Contribution margin % A Prior year Contribution margin Catalog $ Store $ 112 -66.90% $ 340 Website $ 342 -24.37% $ 452 Grand Total $ $ 1.88% A $ Store Cell phones 352 Website Computers Top 5 CM ratios sold via the Calendars distribution channel Nonfiction - History 806 791 Nonfiction - Leaders... Nonfiction - Self-help Nonfiction - Technol... The Catalog product with the HIGHEST CM ratio was Computers The Catalog product with the LOWEST CM ratio was Writing CM ratio - Current year 55.28% 52.929 51.00% 50.20% 48.66% Computers Nonfiction - History Camera and photo TV and video Office basics CM provided by Calendars: Current year $352 $342 $19,052 $112 $12,426 $11 166 $5,819 IN $2,234 $2,394 $352 $183 $69 $234 $108 $994 Catalog Store Website Paper Overall distribution channel segment margins: Current year Writing Calendars Cell phones Computers Nonfiction - History Nonfiction - Leadership Nonfiction - Self-help Nonfiction - Technology Office basics TV and video Catalog Camera and photo The MOST Catalog CM was provided by the product TV and video The LEAST Catalog CM was provided by the product Nonfiction - History Sales revenue Variable cost of goods sold Total contribution margin Direct fixed costs Segment margin $ $ $ $ $ 115,180 60,150 55,031 11,000 44,031 Store 100.0% $ 204,470 52.2% $ 95,019 47.8% $ 109,451 $ 16,000 $ 93,451 Website 100.0% $ 292,320 100.0% 46.5% $ 186,239 63.7% 53.5% $ 106,081 36.3% 24,000 $ 82,081 nnnnn Contribution margin (CM) by distribution channel Product Distribution channel Y Calendars A Catalog Total Catalog contribution margin $55,031 Camera and photo Contribution margin (CM) by product CM provided by Calendars: Current vs. prior year Current Prior Distributi Contribution margin % A Prior year Contribution margin Catalog $ Store $ 112 -66.90% $ 340 Website $ 342 -24.37% $ 452 Grand Total $ $ 1.88% A $ Store Cell phones 352 Website Computers Top 5 CM ratios sold via the Calendars distribution channel Nonfiction - History 806 791 Nonfiction - Leaders... Nonfiction - Self-help Nonfiction - Technol... The Catalog product with the HIGHEST CM ratio was Computers The Catalog product with the LOWEST CM ratio was Writing CM ratio - Current year 55.28% 52.929 51.00% 50.20% 48.66% Computers Nonfiction - History Camera and photo TV and video Office basics CM provided by Calendars: Current year $352 $342 $19,052 $112 $12,426 $11 166 $5,819 IN $2,234 $2,394 $352 $183 $69 $234 $108 $994 Catalog Store Website Paper Overall distribution channel segment margins: Current year Writing Calendars Cell phones Computers Nonfiction - History Nonfiction - Leadership Nonfiction - Self-help Nonfiction - Technology Office basics TV and video Catalog Camera and photo The MOST Catalog CM was provided by the product TV and video The LEAST Catalog CM was provided by the product Nonfiction - History Sales revenue Variable cost of goods sold Total contribution margin Direct fixed costs Segment margin $ $ $ $ $ 115,180 60,150 55,031 11,000 44,031 Store 100.0% $ 204,470 52.2% $ 95,019 47.8% $ 109,451 $ 16,000 $ 93,451 Website 100.0% $ 292,320 100.0% 46.5% $ 186,239 63.7% 53.5% $ 106,081 36.3% 24,000 $ 82,081 nnnnn
