Tag Archives: managerial accounting;

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

What managerial accounting tools could be used to determine whether it would be profitable to redevelop Grossinger’s Catskill Resort Hotel, the inspiration for the movie “Dirty Dancing”?

The Grossinger’s Catskill Resort Hotel in the Catskill Mountains in Liberty, New York, was the inspiration for screenwriter Eleanor Bergstein when writing the “Dirty Dancing” movie screenplay. Her fictional Kellerman’s was a family resort, full of activities such as swimming, tennis, and dancing. Opened in 1919, Grossinger’s contained 35 buildings and attracted up to 150,000 […]

Continue reading

Which iPhone model is the most profitable for Apple?

In late September 2017, Apple Inc. (NYSE: AAPL) announced that it would be releasing three new models of its iPhone in the fourth quarter of 2017: the iPhone X, the iPhone 8 Plus, and the iPhone 8. In addition, it would continue to sell some of the older models. To follow is a table containing […]

Continue reading

How does the drop in the price of eggs impact Kellogg’s® variances for its Eggo® Homestyle waffles?

In 2015, when the avian flu hit egg producers hard, there was a shortage of eggs. Egg prices increased dramatically. Over the years since 2015 however, egg production has ramped back up as egg producers have restocked their flocks of egg-laying chickens.  There is now a glut of eggs, putting causing the price of eggs […]

Continue reading