Complete a three-part assessment in a supplied Excel template in which you apply regression analysis to decision making, determine unit costs, and analyze overhead using a predetermined rate.
Introduction
Cost estimation involves the use of a familiar accounting and finance tool: cost/benefit analysis. Through cost/benefit analysis, managers can explore and evaluate multiple alternatives to choose the one most beneficial to the organization’s bottom line. When evaluating alternatives, it is imperative that comparisons are “apples to apples;” that is, when estimating costs across multiple alternatives, cost data must be expressed in terms of variable and fixed costs, along with the drivers of these costs.
In Assessment 2, you will present information about estimating costs using multiple analysis methods, such as account analysis, statistical analysis, and regression output. Upon completion of this assessment, you will have demonstrated an understanding of the role that cost estimation plays in capturing and using existing accounting information for decision making by managers.
This assessment includes alternative cost systems, beginning with product and service costs.
Before beginning this assessment, take time to review the following topics:
Regression analysis.
Operations costing.
Overhead analysis.