Archive | Managerial accounting RSS feed for this section

How will Walmart’s use of robots change its break even point?

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 reading

7 Excel projects for managerial accounting

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 reading

NEW! Data analytics project: Contribution margin analysis and segment margins for introductory managerial accounting

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 reading

A recap of the Excel data analytics project blog posts

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 reading

7 Excel projects for your managerial accounting course

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 reading

Data analytics project: Budgeting and performance evaluation for introductory managerial accounting using the City of Somerville, MA, online checkbook data set

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 reading

New! Accounting Review Games site is now live

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 reading

What would be the impact of the polysilicon cost increase on Canadian Solar’s gross profit and on its standard variances?

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 reading

Does each Subway $5 Footlong cost the franchisee more than $5?

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

7 Excel projects for your managerial accounting course

Welcome to 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 with […]

Continue reading