Note from Wendy: This case is the fourth of the four interactive Excel dashboard cases I created around the Jubilee Superstores data set – so if you have been following this blog, you have already seen the prebuilt dashboard in financial accounting project, the constructing a dashboard project for financial accounting, and the prebuilt dashboard […]
Continue readingNew! Prebuilt Interactive Excel Dashboard project for introductory managerial accounting available
This new case has students use a prebuilt interactive Excel dashboard to analyze a company’s product contribution margins and segment margins. This dashboard is ready for students to use; students will view a tutorial video about the case, read the instructions, and use the Excel dashboard to answer the case questions. The case will take, […]
Continue reading7 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 readingNEW! 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 readingA 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 reading7 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 readingData 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 reading7 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 readingKaren Braun’s 7 Excel projects for managerial accounting
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 step-by-step student instructions and instructor solutions. The topics include: Job costing Cost behavior CVP analysis Process costing Budgeting Flexible budgeting Division evaluation […]
Continue readingIntroductory managerial accounting Jeopardy game for end-of-semester review
A few days ago, I shared a Jeopardy-style PowerPoint file that can be used for an end-of-semester review in introductory financial accounting classes. In this post, I am sharing a Jeopardy-style game that covers basic topics within an introductory managerial accounting course. This PowerPoint file contains a Jeopardy-style game suitable for use in an introductory […]
Continue reading