TAILIEUCHUNG - Lecture Managerial accounting for Managers (3e): Chapter 2A - Garrison, Noreen, Brewer

The reason is that there are many types of costs, and these costs are classified differently according to the immediate needs of management. For example, managers may want cost data to prepare external financial reports, to prepare planning budgets, or to make decisions. Each different use of cost data demands a different classification and definition of costs. This chapter analyze a mixed cost using the least-squares regression method. | Least-Squares Regression Computations Appendix 2A Learning Objective 2-8 Analyze a mixed cost using a scattergraph plot and the least-squares regression method. Simple Regression Analysis Matrix, Inc. wants to know its average fixed cost and variable cost per meals served. Using the data to the right, let’s see how to do a regression using Microsoft Excel. Simple Regression Using Excel You will need three pieces of information from your regression analysis: Estimated Variable Cost Per Unit (line slope) Estimated Fixed Costs (line intercept) Goodness of fit, or R2 To get these three pieces information we will need to use three Excel functions. SLOPE, INTERCEPT, and RSQ Simple Regression Using Excel Place your cursor in cell F4 and press the = key. Click on the pull down menu and scroll down to “More Functions . . .” Scroll down to the “Statistical” functions. Now scroll down the statistical functions until you highlight “SLOPE” Simple Regression Using Excel 1. In the Known_y’s box, enter C4:C19 for the range. 2. In the Known_x’s box, enter D4:D19 for the range. Simple Regression Using Excel Here is the estimate of the slope of the line. 1. In the Known_y’s box, enter C4:C19 for the range. 2. In the Known_x’s box, enter D4:D19 for the range. Simple Regression Using Excel With your cursor in cell F5, press the = key and go to the pull down menu for “Special Functions.” Select Statistical and scroll down to highlight the INTERCEPT function. Simple Regression Using Excel 1. In the Known_y’s box, enter C4:C19 for the range. 2. In the Known_x’s box, enter D4:D19 for the range. Here is the estimate of the fixed costs. Simple Regression Using Excel Finally, we will determine the “goodness of fit”, or R2, by using the RSQ function. Simple Regression Using Excel 1. In the Known_y’s box, enter C4:C19 for the range. 2. In the Known_x’s box, enter D4:D19 for the range. Here is the estimate of R2. Simple Regression Using Excel End of Appendix 2A

• Kế toán - Kiểm toán
• Managerial accounting
• Lecture Managerial accounting
• Least squares regression computations
• Scattergraph plot
• Simple regression using excel
• Scattergraph plot
• Managerial accounting for managers
• Profitability analysis
• Decision making
• Operations management majors
• Nonmanufacturing costs
• Classifications of costs
• Kế toán quản trị
• Managerial accounting information
• General cost classifi cations
• Product costs
• Process costing
• Standard costing systems
• Accounting information
• Managerial decision
• Process management
• Financial statement
• Cost concepts
• Managerial accounting basics
• Managerial cost
• Period costs
• Lecture Financial and managerial accounting
• Financial statements
• Managerial decisions
• Financial accounting
• Dynamic business environment
• Reporting manufacturing activities
• Accounting principles
• Fundamental accounting principles
• Lecture Fundamental accounting principles
• Relevant costing
• Accounting activities
• Business activities
• Income statement
• Accounting cycle
• Accounting for merchandising operations
• Merchandising operations
• Capital budgeting decisions
• Time value of money
• Income taxes
• After tax cost