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: contribution 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 case for introductory managerial accounting available – KAT Insurance!
March 2, 2019 1 Comment
In addition to the data analytics case we posted last week for introductory financial accounting, we have also developed a case, using the same KAT Insurance Company data set, for introductory managerial accounting. The three of us who teach introductory accounting (Wendy Tietz, Jennifer Cainas, and Tracie Miller-Nobles) developed a KAT Insurance case to introduce […]
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 readingDoes each Subway $5 Footlong cost the franchisee more than $5?
January 31, 2018 0 Comments
Subway, the fast food restaurant franchise, recently announced it is bringing back the “$5 Footlong” promotion. Hundreds of Subway franchise owners are protesting the promotion, saying that they cannot afford to sell the footlong sub sandwiches for $5. Assume that the costs related to a Subway footlong and a Subway franchisee include the following: Cost […]
Continue readingWhich iPhone model is the most profitable for Apple?
November 14, 2017 2 Comments
In late September 2017, Apple Inc. (NYSE: AAPL) announced that it would be releasing three new models of its iPhone in the fourth quarter of 2017: the iPhone X, the iPhone 8 Plus, and the iPhone 8. In addition, it would continue to sell some of the older models. To follow is a table containing […]
Continue readingHow does the change in selling price impact the break even point for Amazon’s Fire Phone?
November 18, 2014 0 Comments
In July of 2014, Amazon came out with a smartphone, the Amazon Fire phone. The phone sports 3-D visuals and is tightly integrated into the Amazon ecosystem. For example, the Firefly feature can scan and recognize over 70 million products that the consumer is able to purchase or look up immediately from his or her […]
Continue readingHow does outfitting AMC movie theaters with recliners affect the company’s break even point and operating leverage?
July 18, 2014 0 Comments
AMC Entertainment Holdings Inc. is spending millions of dollars to install recliner-seating in its theaters. AMC Entertainment Holdings Inc. is outfitting about 1,800 of its nearly 3,000 auditoriums with recliners for a total cost of about $600 million. The recliners will remove up to two-thirds of the seating capacity in each theater, due to […]
Continue readingHow many aircraft must be in service to break even at Virgin America?
September 4, 2013 0 Comments
After several years of losses, Virgin America recently announced that it anticipates a profit for 2013. Although the company is expecting a profit for 2013, it still is not out of the woods. Critics have called for greater cost control at Virgin America. The following table contains selected financial and other data for Virgin America […]
Continue reading
Accounting in the Headlines 