Tag Archives: managerial accounting;

What do you think of the new blog post format that includes a tutorial video?

Earlier today, I shared a new blog post (How does Amazon’s stock split impact its stockholders’ equity? link.) In this blog post, I experimented with a new blog post format. I started with the story about Amazon’s stock split as I have done in the past. Next, however, I included a short explanatory video about […]

Continue reading

New! Beginning Data Cleaning (ETL) & Analytics Project for Excel: KAT Concession Supply

Just posted this project on the other blog I co-author, Accounting Is Analytics. I am really excited about this project – it introduces accounting students to basic data cleaning and analytics concepts using Excel. Read on for how to request this first beginning level project that uses Excel for data cleaning and analytics. A key […]

Continue reading

What costs are relevant when determining how many pizzas a month Stellar Pizza must sell to break even?

Stellar Pizza has a pizza-making robotic machine that was built by three former SpaceX engineers. More than 23 former SpaceX employees work at Stellar Pizza. The pizza-making robot can produce a pizza every 45 seconds. A pizza can be customized, baked, and topped in less than five minutes by the robotic machine. Stellar Pizza will […]

Continue reading

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

Recap of all data analytics projects available

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. (Heads up: I will be posting a new managerial accounting data analytics case within the next week too!) Here goes: Project 1: Transaction analysis for […]

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