Note from Wendy: This case is the fourth of the four interactive Excel dashboard cases I created around the Jubilee Superstores data set – so if you have been following this blog, you have already seen the prebuilt dashboard in financial accounting project, the constructing a dashboard project for financial accounting, and the prebuilt dashboard […]
Continue reading
Tag Archives: segment margin
New! Prebuilt Interactive Excel Dashboard project for introductory managerial accounting available
February 8, 2021 
5 Comments
This new case has students use a prebuilt interactive Excel dashboard to analyze a company’s product contribution margins and segment margins. This dashboard is ready for students to use; students will view a tutorial video about the case, read the instructions, and use the Excel dashboard to answer the case questions. The case will take, […]
Continue readingSummary of seven data analytics projects for introductory accounting
April 7, 2019 0 Comments
There has been a lot of interest in the data analytics cases for introductory accounting that have been posted on this blog. I am providing a summary of the seven data analytics cases and related links in the table below to make it more convenient to see, at a glance, what projects are available and […]
Continue readingNEW! Data analytics project: Contribution margin analysis and segment margins for introductory managerial accounting
January 5, 2019 2 Comments
This blog post contains a data analytics project that is suitable for introductory managerial accounting. The student uses Excel to analyze a data set that contains more than 48,000 records. The data analytics project can be assigned in the course once the concepts of contribution margin, contribution margin ratio, and segment margins reviewed. Overview of […]
Continue readingHow should the cost of national advertising by Whole Foods impact the performance report (and segment margin) for each store?
October 24, 2014 0 Comments
Whole Foods Market, Inc., is a supermarket chain based in Austin, Texas, with 381 stores in the US (it also has stores in the UK and Canada.) Whole Foods specializes in natural and organic food and has annual sales of $13 billion. In October 2014, Whole Foods rolled out its first national advertising campaign in […]
Continue reading
Accounting in the Headlines 