Looking for a quick data analytics exercise for introductory managerial accounting? You can give your students the link for this job cost analysis dashboard and then ask a series of questions. There is no software for students to install; the dashboard is hosted on Tableau Public and can be accessed by anyone with the link […]
Continue reading
Tag Archives: managerial accounting;
What impact does the rising cost of avocados have on Wholly Guacamole’s variances?
April 7, 2022 
2 Comments
The cost of avocados is rising. For example, the price of a 20-pound box of avocados from the state of Avocado prices from Michoacán state in Mexico has jumped to $38 from $21, which is an 81% increase. The current price of avocados is the highest price on record in data that goes back to […]
Continue readingWhat do you think of the new blog post format that includes a tutorial video?
March 28, 2022 30 Comments
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 readingNew! Beginning Data Cleaning (ETL) & Analytics Project for Excel: KAT Concession Supply
March 25, 2022 0 Comments
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 readingWhat costs are relevant when determining how many pizzas a month Stellar Pizza must sell to break even?
January 4, 2022 0 Comments
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 readingHow 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 readingRecap of all data analytics projects available
January 4, 2019 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. (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 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 reading
Accounting in the Headlines 