B313F Management and Cost Accounting

Lecture 6 Cost Estimation By Charles Chiu, PhD, CFA B313F Management and Cost Accounting

Costbehavior Costprediction Relationshipbetweencost andactivity. Using knowledgeof cost behaviorto forecastlevel of cost ata particularactivity. Focusis on the future. Introduction Costestimation Process ofdeterminingcost behavior,often focusingon historicaldata.

Cost Terminology • Variable Costs – costs that change in total in relation to some chosen activity or output • Fixed Costs – costs that do not change in total in relation to some chosen activity or output • Mixed Costs – costs that have both fixed and variable components; also called semivariable costs

Cost Behavior Patterns

Unit Variable Cost Total Variable Cost Unit Fixed Cost Total Fixed Cost

Examples of variable costs Service Organizations Supplies and travel Merchandisers Cost of Goods Sold Merchandisers and Manufacturers Sales commissions and shipping costs Manufacturers Direct Material, Direct Labor, and Variable Manufacturing Overhead Examples of fixed costs Merchandisers, manufacturers, and service organizations Real estate taxes, Insurance, Sales salariesDepreciation, Advertising

Types of Fixed Costs Committed Long-term, cannot be reduced in the short term. Discretionary May be altered in the short-term by current managerial decisions Examples Depreciation on Buildings and Equipment Examples Advertising and Research and Development

Trends in Cost Structure A trend toward more fixed costs because of • Increased automation. • Stable workforce. Implications Managers are more “locked-in” with fewer decision alternatives. Planning becomes more crucial: fixed costs are difficult to change with current operating decisions.

Cost Functions • A cost function is a mathematical representation of how a cost changes with changes in the level of an activity relating to that cost (cost driver)

Identifying Cost Drivers

Criteria for Evaluating Alternative Cost Drivers • Economic Plausibility • Economic significance • Goodness of Fit • Significance of the Independent Variable • Statistical significance

The Linear Cost Function y = a + bX The Dependent Variable: The cost that is being predicted The Independent Variable: The cost driver The Slope of the Line: Variable cost per unit The Intercept: Fixed costs

Y X Cost Total Cost Y = a + bX Variable Cost Fixed Cost Number of Units Produced

The Linearity Assumption and the Relevant Range • Variations in the level of a singleactivity (the cost driver) explain the variations in the related total costs • Cost behavior is approximated by a linear cost function within therelevant range • Graphically, the total cost versus the level of a single activity related to that cost is a straight line within the relevant rage

A straight line closely approximates a curvilinear variable cost line within the relevant range. RelevantRange Accountant’s Straight-Line Approximation (constant unit variable cost) Economist’sCurvilinear Cost Function Total Cost Activity

Example: Office space is available at a rental rate of $30,000 per year in increments of 1,000 square feet. As the business grows more space is rented, increasing the total cost. Continue Fixed Costs and Relevant Range

90 Total cost doesn’t change for a wide range of activity, and then jumps to a new higher cost for the next higher range of activity. Relevant Range 60 Rent Cost in Thousands of Dollars 30 0 0 1,000 2,000 3,000 Rented Area (Square Feet)

Criteria for Classifying Variable and Fixed Components of a Cost • Choice of Cost Object – different objects may result in different classification of the same cost • Time Horizon – the longer the period, the more likely the cost will be variable • Relevant Range – behavior is predictable only within this band of activity

Cause-and-Effect Relationship for Cost Drivers • The most important issue in estimating a cost function is determining whether a cause-and-effect relationship exists between the level of an activity and the costs related to that level of activity. • A cause-and-effect relationship might arise as a result of: • A physical relationship between the level of activity and costs • A contractual agreement • Knowledge of operations • Note: a high correlation (connection) between activities and costs does not necessarily mean causality

Question for Discussion 1  Which of the following statements about cost behavior are true? • Fixed costs per unit vary with the level of activity. • Variable costs per unit are constant within the relevant range. • Total fixed costs are constant within the relevant range. • Total variable costs are constant within the relevant range.

Cost Estimation Methods • Industrial Engineering Method • Conference Method • Account Analysis Method • Quantitative Analysis Methods • High-Low Method • Regression Analysis

Industrial Engineering Method • Estimates cost functions by analyzing the relationship between inputs and outputs in physical terms • Includes time-and-motion studies • Very thorough and detailed, but also costly and time consuming • Also called the Work-Measurement Method

Direct Labor Direct Material • Analyze the kindof work performed. • Estimate the time required for each labor skill for each unit. • Use local wage rates to obtain labor costper unit. • Material requiredfor each unit isobtained from engineering drawings and specification sheets. • Material prices are determined fromvendor bids.

Nonlinear Cost Functions • Economies of Scale • Quantity Discounts • Step Cost Functions – resources increase in “lot-sizes,” not individual units • Learning Curves – labor hours consumed decrease as workers learn their jobs and become better at them • Experience Curve – broader application of learning curve that includes downstream activities including marketing and distribution

Learning Curves There is often a systematic relationship between experiencein performing a task and the timerequired to do it. The average time per task declines by a constant percentage each time the quantity of tasks done doubles.

Types of Learning Curves • Cumulative Average-Time Learning Model – cumulative average time per unit declines by a constant percentage each time the cumulative quantity of units produced doubles • Incremental Unit-Time Learning Model – incremental time needed to produce the last unit declines by a constant percentage each time the cumulative quantity of units produced doubles

Effect of Learning on Cost Behavior Berry Co. makes products requiring labor that follows an 80 percent learning rate. If the first unit of such a product requires 10 hours, what is the average time for 16 units of this product? An 80 percent learning rate:the average time required to make 2 units is 80 percent of the time for 1 unit and the average time for 4 units is 80 percent of the time for 2 units, etc.

Cumulative Average-Time Learning Model The graphic presentation of the learning phenomenon is called the learning curve.

Learning Curve Learning effectsare large initially. Learning effectsbecome smaller, eventually reaching expected final time. Average LaborTime per Unit Cumulative Production Output

This is used to help determine investment required. This is used to estimate ongoing results. Average LaborTime per Unit Cumulative Production Output

Learning Curve Formula

Question for Discussion 2  • Time to produce the first unit = 100 minutes • Learning factor = ln(0.80)/ln2 = -0.32193 • What is the cumulative average time to produce 5 units? • What is the total time to produce 5 units? • What is the time it took to produce the 5th unit?

Incremental Unit-Time Learning Model Using the example of Berry Co. and using the incremental unit-time learning model

Conference Method • Estimates cost functions on the basis of analysis and opinions about costs and their drivers gathered from various departments of a company • Pools expert knowledge • Reliance on opinions still makes this method subjective

Account Analysis Method • Estimates cost functions by classifying various cost accounts as variable, fixed, or mixed with respect to the identified level of activity • Is reasonably accurate, cost-effective, and easy to use, but is subjective

Example Total Cost = $2 per unit + $1,650

Problems • what is the proper cost driver • what is truly fixed • changes in price • is a history available

Quantitative Analysis • Uses a formal mathematical method to fit cost functions to past data observations • Advantage: results are objective

Steps in Estimating a Cost Function Using Quantitative Analysis • Choose the dependent variable (the cost to be predicted) • Identify the independent variable or cost driver • Collect data on the dependent variable and the cost driver • Plot the data • Estimate the cost function using the High-Low Method or Regression Analysis • Evaluate the cost driver of the estimated cost function

The High-Low Method WiseCo recorded the following production activity and maintenance costs for two months: Using these two levels of activity, compute: • the variable cost per unit; • the fixed cost; and then • express the costs in equation form Y = a + bX.

The High-Low Method • Variable cost = $2,400 ÷ 3,000 units = $0.80 per unit • Fixed cost = Total cost – Total variable cost • Fixed cost = $9,800 – ($0.80 per unit × 8,000 units) • Fixed cost = $9,800 – $6,400 = $3,400 • Total cost = Fixed cost + Variable cost (Y = a + bX) Y = $3,400 + $0.80X

Question for Discussion 3  Sales salaries and commissions are $10,000 when 80,000 units are sold, and $14,000 when 120,000 units are sold. Using the high-low method, what is the variable portion of sales salaries and commission? a. $0.08 per unit b. $0.10 per unit c. $0.12 per unit d. $0.125 per unit

Question for Discussion 4  Sales salaries and commissions are $10,000 when 80,000 units are sold, and $14,000 when 120,000 units are sold. Using the high-low method, what is the fixed portion of sales salaries and commissions? a. $ 2,000 b. $ 4,000 c. $10,000 d. $12,000

Regression Analysis • Regression analysis is a statistical method that measures the average amount of change in the dependent variable associated with a unit change in one or more independent variables • Is more accurate than the High-Low method because the regression equation estimates costs using information from allobservations; the High-Low method uses only two observations

Types of Regression • Simple – estimates the relationship between the dependent variable and one independent variable • Multiple – estimates the relationship between the dependent variable and two or more independent variables

Terminology • Goodness of Fit – indicates the strength of the relationship between the cost driver and costs • Residual Term – measures the distance between actual cost and estimated cost for each observation

The simple cost model is actually a regression model: TC = F + VX Caution: Before doing the analysis, take time to determine if a logical relationship between the variables exists. This model will only be useful within a relevant range of activity.

Software can be used to fit a regression line through the data points. The cost analysis objective is the same: Y = a + bX Simple Regression Method Least-squares regression also provides a statistic, called the R2, that is a measure of the goodnessof fit of the regression line to the data points.

R2 is the percentage of the variation in total cost explained by the activity. Y 20 * * * * * * * * * * Total Cost 10 R2 for this relationship is near100% since the data points arevery close to the regression line. 0 X 0 1 2 3 4 Activity

Multiple Regression Multiple regression includes two or more independent variables: Terms in the equation have the samemeaning as in simple regression withonly one independent variable. TC = FC + V1X1 + V2X2

B313F Management and Cost Accounting