Suggested Assignments for Introductory Managerial Accounting

The table below shows typical managerial accounting topics which are matched to recommended Microsoft Excel exercises.

Managerial Accounting Topic                 Recommended Excel Exercises


1.  Introduction to Managerial             74   Cost of Goods Manufactured and Cost of
     Accounting                                          Goods Sold
                                                         75   Income Statement

2.   Analyzing Cost Behavior              26   Cost-Volume-Profit Analysis
                                                         27   Cost-Volume-Profit Analysis

3.   Job Order Costing                       76   Work in Progress and Questions
 
4.   Process Costing                          77   Compute Equivalent Units: FIFO
                                                        78   Compute Equivalent Units: Weighted Avg.

5.   Overhead Costs &                     84   Cost Allocation Rates
      Activity Based Costing               85   Budgeted Costs, ABC Cost Per Unit
                                                       86   Manufacturing Cost Based on ABC Unit
                                                               Cost

6.  Cost-Volume-Profit Analysis       26   Cost-Volume-Profit Analysis
                                                       27   Cost-Volume-Profit Analysis
                                                       28   Cost-Volume-Profit Analysis: Graph
                                                       29   Cost-Volume-Profit Analysis: Graph
                                                       79   Graph Cost Behavior Patterns
                                                       80   Contribution Margin Income Statement

7.  Costs                                          81   Departmental Income Statement

8.  Budgeting                                  82   Flexible Budget
                                                      83   Graph Total Cost Line

9.  Responsibility Accounting           89   Best Use of Facilities Analysis

10. Use of Managerial Accounting    87   Product Mix Analysis
      Data for Decision-Making          88   Make or Buy Analysis

11.  Capital Budgeting                      82   Flexible Budget
                                                       83   Graph Total Cost Line

12. Financial Statement Analysis       30   Financial Ratios
                                                       31   Financial Ratios
                                                       32   Common Size Balance Sheets
                                                       33   Common Size Balance Sheets
                                                       73   Horizontal Analysis of Income Statement
 
13. Statement of Cash Flows          71   Statement of Cash Flows
                                                      72   Statement of Cash Flows

Back to Microsoft Excel for Accounting Principles Homepage