Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

If the managers of Jubilee Stores were evaluating whether to keep or drop each of its segments (catalog, store, and website), which totals would be

  1. If the managers of Jubilee Stores were evaluating whether to keep or drop each of its segments (catalog, store, and website), which totals would be most relevant to the decision-making process? (Name the totals, no numbers are necessary here)
  2. How could this dashboard help the company in its decision-making?
  3. What overall strategy questions could this dashboard address?

image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Cases An Interactive Learning Approach

Authors: Steven M Glover, Douglas F Prawitt

4th Edition

0132423502, 978-0132423502

More Books

Students also viewed these Accounting questions