Tag Archives: managerial accounting;

A financial statement analysis mini-dashboard for a quick data analytics exercise

Looking for a quick data analytics exercise for financial statement analysis in an introductory accounting class? You can give your students the link for this financial statement 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 […]

Continue reading

A job cost mini-dashboard for a quick data analytics exercise

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

What impact does the rising cost of avocados have on Wholly Guacamole’s variances?

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 reading

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