Please submit your professional letter to Jubilee, which should completely and accurately addresses all of the case questions in the student handout.

Suggested resource: the COBE writing style guide, which includes business letter formats.

Use the interactive Excel dashboard you built to answer the following questions:

1. What total is calculated by taking sales revenue less variable costs? How does this total differ from net income? Why is it important in decision making? What assumptions should you share with them?
2. 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.)
3. Which 3 products have the highest CM ratios in the current year? Which 3 products have the lowest CM ratios in the current year?
4. Would you recommend that any products be completely discontinued? Would you recommend that any products be discontinued in a specific channel(s)?
5. Are all 3 channels (segments) performing well? Should any be discontinued?
6. What is the segment margin for the Store distribution channel? For the Website distribution channel?
7. What is the contribution margin provided by the Computers product in the current year? What is the percentage change from the prior year for the Computers product?
8. How could this dashboard help the company in its decision-making? What overall strategy questions could this dashboard address?

Contribution margin (CM) by distribution channel Total Store contribution margin Distribution channel Catalog Store website $ 100,218 Overall distribution channel segment margins Product Calendars Camera and photo Cell phones Computers Nonfiction - History Nonfiction - Leadership Nonfiction - Self-help Nonfiction - Technology Chart Title $577 $37.994 $453 $40000 $35.000 $30,000 $25000 $20,000 $15.000 $10000 $5,000 $ $ $ $ $ $ $ $ $59 Calendars Nonditions Catalog Store website Camera and photo Cellphones Computers Nonfiction - History Nonfiction Leadership Max average Nordiction Technology office basics Paper TV and video writing CM provided by Calendars: Current year The MOST Store CM was provided by the product TV and video The LEAST Store CM was provided by the product Nonfiction - History Contribution margin (CM) by distribution channel Total Store contribution margin Distribution channel Catalog Store website $ 100,218 Overall distribution channel segment margins Product Calendars Camera and photo Cell phones Computers Nonfiction - History Nonfiction - Leadership Nonfiction - Self-help Nonfiction - Technology Chart Title $577 $37.994 $453 $40000 $35.000 $30,000 $25000 $20,000 $15.000 $10000 $5,000 $ $ $ $ $ $ $ $ $59 Calendars Nonditions Catalog Store website Camera and photo Cellphones Computers Nonfiction - History Nonfiction Leadership Max average Nordiction Technology office basics Paper TV and video writing CM provided by Calendars: Current year The MOST Store CM was provided by the product TV and video The LEAST Store CM was provided by the product Nonfiction - History