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
Archive | Managerial accounting RSS feed for this section
NEW! 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 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 reading7 Excel projects for your managerial accounting course
August 19, 2018 0 Comments
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 readingData analytics project: Budgeting and performance evaluation for introductory managerial accounting using the City of Somerville, MA, online checkbook data set
May 10, 2018 4 Comments
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 readingNew! Accounting Review Games site is now live
April 20, 2018 3 Comments
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 readingWhat would be the impact of the polysilicon cost increase on Canadian Solar’s gross profit and on its standard variances?
March 23, 2018 0 Comments
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 readingDoes each Subway $5 Footlong cost the franchisee more than $5?
January 31, 2018 0 Comments
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 reading7 Excel projects for your managerial accounting course
January 5, 2018 0 Comments
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 readingWhat 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”?
November 28, 2017 0 Comments
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