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 reading
Archive | Managerial accounting RSS feed for this section
How will Walmart’s use of robots change its break even point?
January 21, 2019 
0 Comments
Walmart (WMT) is robotic janitors in some of its stores. Walmart has purchased several Autonomous Cleaner (Auto-C) robots from Brain Corporation. An Auto-C robot looks like a Zamboni, the machine used to clean ice rinks. The robots scrub floors and clean store aisles. Sensors in the robots allow them to navigate around customers and other […]
Continue reading7 Excel projects for managerial accounting
January 14, 2019 6 Comments
Welcome to the spring semester! I thought I would repost this information as you are getting ready to kick off the new semester. If you teach managerial accounting, you may want to look at Dr. Karen Braun’s Excel projects for managerial accounting. She has created seven Excel projects on various topics in managerial accounting, complete […]
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 readingA recap of the Excel data analytics project blog posts
August 19, 2018 0 Comments
Hello! I have posted a few data analytics projects here on my blog and thought it might be useful as the semester starts to post the links in one post. Here goes: Project 1: Transaction analysis for Introductory financial accounting using the City of Somerville, MA, online checkbook data set (link) Project 2: Budgeting and […]
Continue reading7 Excel projects for your managerial accounting course
August 19, 2018 0 Comments
Ready or not, welcome to the fall semester! I thought I would repost this information as you are getting ready to kick off the new semester. If you teach managerial accounting, you may want to look at Dr. Karen Braun’s Excel projects for managerial accounting. She has created seven Excel projects on various topics in […]
Continue readingData analytics project: Budgeting and performance evaluation for introductory managerial accounting using the City of Somerville, MA, online checkbook data set
May 10, 2018 4 Comments
As promised in my data analytics introductory financial accounting project blog post, here is the second data analytics project I have developed. This one covers budgeting and performance evaluation in introductory managerial accounting. Background After thinking about the best tool to use for data analytics in the introductory classes, I decided to use Excel as […]
Continue readingNew! Accounting Review Games site is now live
April 20, 2018 3 Comments
For some time, I have been occasionally using a variety of PowerPoint games in the classroom for review. Classroom games can inject some energy into a class and change things up. Used in moderation, review games can add a fun dimension to a course. Starting today, my new “Accounting Review Games” blog is now live. […]
Continue readingWhat would be the impact of the polysilicon cost increase on Canadian Solar’s gross profit and on its standard variances?
March 23, 2018 0 Comments
Canadian Solar (NASDAQ: CSIQ) and other solar panel manufacturers are facing a shortage of a key raw material used in the production of solar panels, polysilicon. Environmental regulators in China shut down several factories, triggering the shortage. The cost of polysilicon has risen by as much as 35% in the past several months. A kilogram […]
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 reading