Accounting Cost of Goods Manufactured Sheet - Excel

Document Sample
Accounting Cost of Goods Manufactured Sheet - Excel Powered By Docstoc
					                         INTRODUCTION TO MANAGERIAL ACCOUNTING
                               1st Edition, Folk, Garrison & Noreen

   PROBLEM                                REPORT                         REFERENCE PRINT AREA

Problem 01-07   Financial Statements; Cost Behavior
                Schedule of Costs of Goods Manufactured                  M1        M5:O31
                Income Statement and Parts 4 and 5                       M50       M54:O86
                Given Data                                               T1

Problem AT01    Analytical Thinking
                Cost of Goods Manufactured and Part 2 Computations       M1        M5:O45
                Income Statement                                         M50       M54:O75
                Given Data                                               T1

Problem 02-04   Comprehensive Problem
                General Journal for Parts 1 and 3                        M1        M5:P44
                Income Statement                                         N50       N54:P71
                Given Data                                               T1

Problem 02-06   Overhead Analysis; Schedule of Cost of Goods Manufactured
                Schedule of Cost of Goods Manufactured                M1           M5:O25
                Computations for Parts 1, 3, 4 and 5                  L40          L44:O105
                Given Data                                            T1

Problem 02-07   Multiple Departments; Applying Overhead
                Computations for Parts 1 through 4                       M1        M4:Q40
                Given Data                                               T1

Problem 03-06   Activity-Based Costing Cost Flows and Income Statement
                Activity Rates and General Journal                     M1          M5:Q52
                Computation for Part 4 and Income Statement            M60         M64:P95
                Given Data                                             T1

Problem 04-04   Step-by-Step Production Report-Weighted Average Method
                Parts 1, 2 and 3                                      M1           M5:R53
                Given Data                                            T1

Problem 04-05   Preparation of Production Report from Analysis of Work
                in Process-Weighted Average Method
                Production Report                                        M1        M5:Q51
                Given Data                                               T1

Problem 04-07   Comprehensive Process Costing Problem-Weighted Average Method
                General Journal                                     L1             L5:O32
                Production Report                                   M40            M44:R91
                Given Data                                          T1

Problem AT04    Analytical Thinking
                Production Report                                        M1        M4:R53
                Given Data                                               T1
                         INTRODUCTION TO MANAGERIAL ACCOUNTING
                               1st Edition, Folk, Garrison & Noreen

   PROBLEM                                REPORT                      REFERENCE PRINT AREA

Problem 05-02   Contribution Format Income Statement
                Traditional Income Statement                          M1          M5:O31
                Contribution Income Statement                         M50         M54:O81
                Given Data                                            T1

Problem 05-05   Cost Behavior; High-Low Analysis; Contribution Format Income Statement
                Expenses                                                M1         M5:P40
                Income Statement                                        M50        M54:O75
                Given Data                                              T1

Problem 05-09   High-Low Analysis; Cost of Goods Manufactured
                Parts 1 through 3                                     M1          M4:O53
                Given Data                                            T1

Problem 06-01   Basic CVP Analysis
                Calculations (Parts 1 through 4)                      M1          M6:O38
                Contribution Income Statement                         M49         M54:Q70
                Incremental Analysis                                  M90         M95:N104
                Given Data                                            T1

Problem 06-02   Basic CVP Analysis; Cost Structure
                Calculations                                          L1          L4:S76
                Given Data                                            T1

Problem 06-04   Multiproduct Break-Even Analysis
                Calculations                                          L1          L4:Q36
                Given Data                                            T1

Problem 07-03   Cash Budget; Income Statements; Balance Sheet
                Schedule of Cash Receipts and Cash Budget             M1          M6:N43
                Budgeted Income Statement                             M55         M60:O79
                Budgeted Balance Sheet                                M90         M95:N115
                Given Data                                            T1

Problem 07-06   Cash Budget with Supporting Schedules
                Schedules for Cash Collections and Disbursements      M1          M6:R39
                Expected Cash Payments                                M50         M55:R70
                Cash Budget                                           M80         M85:R110
                Given Data                                            T1

Problem AT07    Analytical Thinking
                Budgets                                               M1          M7:Q42
                Cash Budget                                           M58         M64:Q93
                Budgeted Income Statement                             M108        M114:O137
                Budgeted Balance Sheet                                M151        M157:O194
                Given Data                                            T1
                         INTRODUCTION TO MANAGERIAL ACCOUNTING
                               1st Edition, Folk, Garrison & Noreen

   PROBLEM                                REPORT                               REFERENCE PRINT AREA

Problem 08-01   Variance Analysis in a Hospital
                Materials Price & Quantity Variance                            M1          M6:S45*
                Labor Rate & Efficiency Variances                              M22
                Variable OH Spending & Efficiency Variances                    M35
                Given Data                                                     U1
                * All three reports are contained in one print area: M6:S45.

Problem 08-07   Comprehensive Variance Problem
                Computations (Parts 1 through 5)                               M1          M7:O49
                Labor Rate Variance                                            A27         A33:F68*
                Variable Overhead Spending Variance                            A58
                Standard Cost Card                                             S1          S7:V20
                Given Data                                                     AA1
                *The Variances will print in one print area: A33:F68

Problem 08-10   Comprehensive Variance Analysis with Incomplete Data; Journal Entries
                Materials Price and Quantity Variances & Journal Entries    M1      M7:R45
                Labor Rate and Efficiency Variances & Journal Entries       M50     M56:S91
                Variable Overhead Spending and Efficiency Variances         M100    M106:S131*
                Standard Cost Card                                          M125
                Given Data                                                  U1
                *Variable Overhead Variances and Standard Cost Card will print
                 in one print area: M106:S131.

Problem 09-03   Comprehensive Standard Cost Variances
                Standard Cost Card                                               S1        S7:V20
                Materials and Labor Variances                                    M1        M7:O34
                Variable Overhead Variances                                      A30       A36:G61*
                Fixed Overhead Variances                                         C52
                Given Data                                                       AA1
                *The Variable and Fixed Variances will print in one print area: A36:G61.

Problem 09-08   Flexible Budget and Overhead Performance Report
                Flexible Budget                                                M1          M5:R52
                Performance Report                                             M32
                Given Data                                                     U1
                *Both reports print in one print area: M5:R52.

Problem AT09    Analytical Thinking
                Incomplete Data                                                M1          M4:O31
                Variable and Fixed Overhead Analysis                           A25         A28:G63

Problem 10-04   Return on Investment (ROI) and Residual Income
                Computations                                                   M1          M4:N29
                Given Data                                                     T1
                         INTRODUCTION TO MANAGERIAL ACCOUNTING
                               1st Edition, Folk, Garrison & Noreen

   PROBLEM                                REPORT                         REFERENCE PRINT AREA

Problem 10-06   Return on Investment (ROI) Analysis
                Computations                                             M1         M4:O65
                Given Data                                               T1

Problem AT10    Analytical Thinking
                Computations                                             M1         M4:P41
                Given Data                                               T1

Problem 11-01   Equipment Replacement Decision
                Summary Income Statement & Relevant Costs                M1         M4:P28
                Given Data                                               T1

Problem 11-05   Accept or Reject a Special Order
                Computations (Parts 1 through 3)                         M1         M4:O42
                Given Data                                               T1

Problem 11-06   Utilization of a Constrained Resource
                Contribution Margin                                      M1         M4:R40*
                Schedule of Direct Labor-Hours                           M29
                Given Data                                               T1
                * Both reports print in one print area: M4:R40

Problem 12-01   Basic Net Present Value Analysis
                Net Annual Cash Inflows & Net Present Value              M1         M4:Q27
                Given Data                                               T1

Problem 12-06   Simple Rate of Return and Payback Methods
                Computations (Parts 1 through 3)                         M1         M4:O37
                Given Data                                               T1

Problem 12-07   Simple Rate of Return and Payback Analyses of Two Machines
                Computations (Parts 1 through 3)                      M1            M4:O58
                Given Data                                            T1

Problem 13-04   Prepare a Statement of Cash Flows (Indirect Method)
                Statement of Cash Flows                                  M1         M5:O40
                Worksheet                                                A30        A34:G73
                Given Data                                               T1

Problem 13-06   Prepare and Interpret a Statement of Cash Flows (Indirect Method)
                Statement of Cash Flows                                   M1        M5:O44
                Worksheet                                                 A30       A34:G73
                Given Data                                                T1
                         INTRODUCTION TO MANAGERIAL ACCOUNTING
                               1st Edition, Folk, Garrison & Noreen

   PROBLEM                                REPORT                           REFERENCE PRINT AREA

Problem 13-07   Prepare and Interpret a Statement of Cash Flows (Direct Method)
                Income Statement Adjustments                             M1              M5:O32
                Statement of Cash Flows                                  M45             M49:O83
                Given Data                                               T1

Problem AT13    Analytical Thinking
                Computations                                               M55           M60:O81
                Statement of Cash Flows                                    M1            M6:O44
                Worksheet                                                  A34           A39:G80
                Given Data                                                 T1

Problem 14-01   Common-Size Statements and Financing Ratios for Creditors
                Ratios                                                L1                 L6:Q42
                Common-Size Balance Sheets                            S1                 S6:U33
                Common-Size Income Statements                         S42                S47:U63
                Given Data                                            AA1

Problem 14-06   Comprehensive Ratio Analysis
                Rates of Return                                            M1            M6:O32
                Stockholders' Well Being                                   M50           M55:O87
                Ratios                                                     S1            S6:W42
                Given Data                                                 AA1

Problem AT14    Analytical Thinking
                Computation of Missing Amounts                                 M1          M6:O76
                Balance Sheet                                                  M85         M90:N130*
                Income Statement                                               M118
                Given Data                                                     T1
                *The Income Stmt. and Balance Sheet will print with one print area: M90:N130.

				
DOCUMENT INFO
Description: Accounting Cost of Goods Manufactured Sheet document sample