The steps you will follow for this project are as follows. 1) Review the studiont handout. 2) Review the yddeo andior the scripted PDF for Windows and MAC 3) Download the Windows dashbeard file or download the MAC dashboard fil. While the dashboards are based on the same data set, they are not interchangeable. Be sure fo use the data file for Windows (Excel) or Mac, depending on which operating system you are using. (Aller you download the fle, YOU NEED IO "SAVE" YOUR ASSIGNMENT BY CLICKING THE SAVE BUTTON IN THE UPPER PIGHT HAND CORNER BEFORE YOU EXIT If you do not save your assignment, the next time you enter; you may see different company and dashboard.) 4) Use the Excel file to answer the six multiple choice questions below (You wil have to scroll down to see all of the questions) Resources This project only has one attempt. Review the dashboard before answering the questions. What is the contribution margin provided by camera and photo products sold threugh the store distribution channol for the current year? A. $34,923 B. 58.934 C. $13,924 D. 512,066 What is the percentage change in the contribution margin over the prior year for the compulers products sold through the wabsile distribution channel? What is the percentage change in the contribution margin over the prior year for the computers products sold through the website distribution channel? A. 2727% B. 3237% C. 22.28% D. 40,65% What is the total contribution margin provided by camera and photo products for the current year? A. 534,923 B. $47,701 C. $269,440 D. 582,624 What is the segment margin provided by the store distribution channel in the current year? A. $50,890 B. $84,916 C. $82,634 D. $66,890 What is the total contribution margin provided by writing products for the prior year? A. $5,621 B. $5,730 C. $11,352 D. $314,067 What is the overall contribution margin ratio for the catalog distribution channel for the current year? A. 53.2% B. 47.1% C. 49.9% D. 38.3% Contribution margin (CM) by distribution channel Total Catalog contribution margin $93,634 Top 5CM ratios sold via the Catalog distribution channel The Catalog product with the HIGHEST CM ratio was Nonfiction - Leadership The Catalog product with the LOWEST CM ratio was Nonfiction - Contribution margin (CM) by product CM provided by Calendars: Current vs. prior year CM provided by Calendars: Current year Overall distribution channel segment margins: Current year The steps you will follow for this project are as follows. 1) Review the studiont handout. 2) Review the yddeo andior the scripted PDF for Windows and MAC 3) Download the Windows dashbeard file or download the MAC dashboard fil. While the dashboards are based on the same data set, they are not interchangeable. Be sure fo use the data file for Windows (Excel) or Mac, depending on which operating system you are using. (Aller you download the fle, YOU NEED IO "SAVE" YOUR ASSIGNMENT BY CLICKING THE SAVE BUTTON IN THE UPPER PIGHT HAND CORNER BEFORE YOU EXIT If you do not save your assignment, the next time you enter; you may see different company and dashboard.) 4) Use the Excel file to answer the six multiple choice questions below (You wil have to scroll down to see all of the questions) Resources This project only has one attempt. Review the dashboard before answering the questions. What is the contribution margin provided by camera and photo products sold threugh the store distribution channol for the current year? A. $34,923 B. 58.934 C. $13,924 D. 512,066 What is the percentage change in the contribution margin over the prior year for the compulers products sold through the wabsile distribution channel? What is the percentage change in the contribution margin over the prior year for the computers products sold through the website distribution channel? A. 2727% B. 3237% C. 22.28% D. 40,65% What is the total contribution margin provided by camera and photo products for the current year? A. 534,923 B. $47,701 C. $269,440 D. 582,624 What is the segment margin provided by the store distribution channel in the current year? A. $50,890 B. $84,916 C. $82,634 D. $66,890 What is the total contribution margin provided by writing products for the prior year? A. $5,621 B. $5,730 C. $11,352 D. $314,067 What is the overall contribution margin ratio for the catalog distribution channel for the current year? A. 53.2% B. 47.1% C. 49.9% D. 38.3% Contribution margin (CM) by distribution channel Total Catalog contribution margin $93,634 Top 5CM ratios sold via the Catalog distribution channel The Catalog product with the HIGHEST CM ratio was Nonfiction - Leadership The Catalog product with the LOWEST CM ratio was Nonfiction - Contribution margin (CM) by product CM provided by Calendars: Current vs. prior year CM provided by Calendars: Current year Overall distribution channel segment margins: Current year
