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: 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? 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.) Which 3 products have the highest CM ratios in the current year? Which 3 products have the lowest CM ratios in the current year? Would you recommend that any products be completely discontinued? Would you recommend that any products be discontinued in a specific channel(s)? Are all 3 channels (segments) performing well? Should any be discontinued? What is the segment margin for the Store distribution channel? For the Website distribution channel? 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? 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 $100,218 = 5 website Overall distribution channel segment margins Product Calendars Camera and photo Cell phones Computers Nonfiction - History Nonfiction - Leadership Nonfiction - Self-help Nonfiction Technology Chart Title 5577 5453 SU 550 C CM provided by Calendars: current year MOST Store CM was provided by the product TV and video LEAST Store CM was provided by the product Nonfiction History Contribution margin (CM) by product CM provided by Calendars: Current vs. prior year Distribution channel Catalog Store website Grand Total Current Contribution Margin $ $ % prior year 59 577 453 1,088 178.57% 14,81% -36 89% 12.31% Prior Contribution Margin $ $ $ $ 21 502 717 1,241 $ Top 5 CM ratios sold via the Calendars distibution channel Camera and photo TV and video Calendars Office basics Computers Sum of CM ratio- current year 48.41% 45.45% 45.33% 45.22% 45.21% The Store product with the HIGHEST CM ratio was Camera and photo The Store product with the LOWEST CM ratio was Nonfiction History Sales revenue Variable cost of goods sold Total contribution margin Direct fixed costs Segment margin $ $ $ $ $ 85.450 44.797 40.653 15.000 29,653 100.00% $ 212 230 52.42% 5.112.012 47.58% $. 100.218 $ 16,000 $ 84,218 100.00% $ 378,350 52.78% $ 214.271 47.22% $ 164.079 $ 24,000 $ 140.079 100.00% 56.63% 43.37%
