B2 Strategic Planning: Techniques for Forecasting, Budgeting, and Analysis-Profitability and Pricing analysis Flashcards

1
Q

Profitability and Pricing Analysis

Contribution Approach (Direct Costing)

&

Absorption Approach (GAAP)

Formulas

A

Contribution approach

used for breakeven analysis.

Revenue

- VC (DM +DL + Variable OH +Variable SG&A)

=Contribution Margin

- Fixed Costs (Fixed OH +Fixed SG&A)

= Profit

Absorption Approach (GAAP)

Revenue

- COGS(DM+DL+OH-fixed and variable) {product costs}

= Gross Margin

Less operating expenses (SG&A-fixed and variable) {period costs}

=Net income

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Profitability and Pricing Analysis

Contribution Margin Ratio

A

Contribution Margin / Revenue

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Profitability and Pricing Analysis

Absorption Approach vs Contribution Approach-biggest difference is the treatment of what?

A

The main difference is the treatment of fixed factory overhead. SG&A are period costs under both methods.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Profitability and Pricing Analysis

Contribution Approach (Direct Costing)

vs

Absorption Approach (GAAP)

A

Absorption-all fixed factory overhead treated as product cost and included in inventory values. GOGS includes both fixed costs and variable costs

Contribution-All fixed factory overhead is treated as period cost and is expensed in the period incurred. Inventory values include only the variable manufacturing costs, so COGS includes only variable costs-not gaap

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Profitability and Pricing Analysis

  • Contribution Approach (Direct Costing)*
  • &*
  • Absorption Approach (GAAP)*

Effect on Income

A

Production Greater than Sales=Inventory increases- if units produced exceed units sold, then some units are added to ending inventory and income is higher under absorption costing than variable costing

  • under absorption costing, a portion of FOH is included with each unit of ending inventory (on B/S, not I/S)
  • under variable (direct) costing, all FOH is considered a period cost and is expensed during the period

Sales Greater than Production=Inventory Decrease-if units sold exceed units produced, then ending inventory is less than beginning inventory and income is lower under absorption costing than under variable.

  • under absorption, fixed MOH is carried over from a previous period as a part of beg inventory and is charged to cost of sales
  • under variable (direct) costing, those fixed costs were charged to income in a previous period.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Profitability and Pricing Analysis

Absorption Costing

Benefits and Limitations

A

Benefits

  1. Is GAAP
  2. IRS requires this method for financial reporting

Limitations

  1. level of inv affects net income b/c fixed costs are a component of product cost
  2. NI is less reliable (esp for perform evals) than variable method b/c cost of product includes fixed costs and, therefore, the level of inventory affects net income
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Profitability and Pricing Analysis

Variable (Direct) Costing

Benefits and Limitations

A

Benefits

  1. Variable and fixed costs are separated and can be easily traced to and controlled by mgmnt
  2. Net Income more reliable than Absorp.Costing method(esp for perform evals) b/c cost of product does not include fixed costs and, therefore, the level of inventory does not affect net income
  3. Variable costing isolates the contribution margins in f/s to aid in decision making

Limitations

  1. not GAAP
  2. IRS does not allow for financial reporting
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Profitability and Pricing Analysis

Breakeven(BE) Computation

BE in Units

A

Total Fixed costs / contribution margin per unit

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Profitability and Pricing Analysis

Breakeven(BE) Computation

BE in Dollars

A

Unit Price x breakeven point (in units)= BE point (dollars)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Profitability and Pricing Analysis

Breakeven(BE) Computation

Contribtion Margin Ratio

A

Contribution margin/sales

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Profitability and Pricing Analysis

CVP-Profit Performance

Required Sales Volume for Target Profit

Sales Units Needed to Obtain a Desired Profit formula

A

Sales (units)= (Fixed Cost+Pretax profit/CM per unit

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Profitability and Pricing Analysis

CVP-Profit Performance

Required Sales Volume for Target Profit

Sales Dollars Needed to Obtain a Desired Profit formula

A

Sales dollars= VC + FC + pretax profit

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Profitability and Pricing Analysis

Margin of Safety

A

excess of sales over BE sales and generally expressed as either dollars or a percentage.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Profitability and Pricing Analysis

Target Costing

A

Technique used to establish the product cost allowed to ensure both profitability per unit and total sales volume.

Target cost= market price - required profit

example

market price per unit = $5

required profit margin=60%

desired profit=$5 x 60%=$3

Target Costs=$5 - $3 = $2

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Marginal Analysis

A

used when analyzing business decisions such as the introduction of a new product or changes in output levels of existing products, acceptance or rejection of special orders, making or buying a product or service, selling or processing further, and adding or dropping a segment. Focuses on relevant revenues and costs.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Marginal Analysis

vocab and relevant or not?

Direct Costs

Prime Costs

Discretionary Costs

Incremental Costs

Opportunity Costs

Irrelevant Costs

Sunk costs

Controllable Costs

Avoidable costs

Unavoidable Costs

A
  1. Direct costs-costs that can be identified or traced to a given cost object. Usually relevant.
  2. Prime Costs-include DM and DL and are generally relevant
  3. DiscretionaryCosts-costs arising from periodic budgeting decisions by mgmnt to spend in areas not directly related to mfg. Generally relevant
  4. Incremental costs(aka marginal costs, differential costs, or out of pocket costs)-additional costs incurred to produce an additional amount of the unit over the present output. Relevant and inc all VC and any avoidable fixed costs
  5. Opportunity Costs-cost of foregoing the next best alternative when making a decision. Relevant.
  6. Irrelevant Costs-costs that do not differ among alternatives and should be ignored in marginal analysis
  7. sunk costs-unavoiable b/c incurred in past and cant be recovered. Not relevant
  8. Controllable Costs-costs that are authorized by the business unit manager or the decision maker. Controllable costs are relevant if they will change as a result of selecting different alternatives.
  9. Avoidable Costs and Revenues-result from chossing one course of action instead of another. They are relevant
  10. Unavoidable Costs-Costs will be the same regardless of the chosen course of action. not relevant
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Marginal Analysis

Special Order Decisions

Presume Excess Capacity

A

If selling price per unit is greater than variable cost per unit than accept

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Marginal Analysis

Special Order Decisions

Presumed Full Capacity

A

Price > VC per unit + opp cost per unit

19
Q

Marginal Analysis

Make Vs Buy

Excess Capacity

A

Relevant costs=avoidable costs

20
Q

Marginal Analysis

Make Vs Buy

No Excess Capacity

A

Relevant Costs=Avoidable costs + opportunity costs

21
Q

Forecasting and Projection

Decision Models

Sensitivity Analysis

A

Also called “what if” analysis. A risk mgmnt tool that is used to test the effect of specific variables on overall profitability. Managers incorporate sensitivity analysis into the budgeting process to determine which variables are the most sensitive to change and therefore will have the biggest impact on the bottom line.

22
Q

Forecasting and Projection

Decision Models

Forecasting Analysis

A

Extension of sensitivity analysis

Involves predicting future values of a dependent variable (the variable one is trying to explain) using info from previous time periods. Dependent variables can be Revenues and Expenses.

23
Q

Forecasting and Projection

Regression Analysis

Simple Linear Regression Model (y=a + Bx)

A

(y=a + Bx)

24
Q

Forecasting and Projection

The Coefficient of Correlation (r) Intrepretation

A

positive correlation = +1

negative= -1

no correlation= 0

25
Forecasting and Projection The Coefficient of Determination (R2)
is the proportion of the total variation in the dependent variable (y) explained by the independent variable.
26
Forecasting and Projection ## Footnote High-Low Method
used to estimate fixed and variable portions of cost 1. Compare high and low volumes and costs 2. divide difference between high and low dollar total costs by the difference in hgih and low volumes to obtain VC per unit 3. use either high or low volume to calc VC by multiplying the volume times the VC per unit 4. subtract total calculated VC from total costs to obtain fixed costs formula TC=FC + (VC per unit x # of units)
27
Budgeting Master Budgets (annual business plan)
Documents specific short-term operating performance goals for a period, normally one year or less aka as static budgets, annual business plans, profit planning, or targeting budgets
28
Budgeting Master Budgets (annual business plan) Which Proforma F/S?
1. Balance Sheet 2. Income Statement 3. Statement of Cash Flows
29
Budgeting Master Budgets (annual business plan) 1. Operating Budgets 2. Financial Budgets
Operating: 1. *Sales budgets*-first budget prepared and drives the development of most other components of the master budget. 2. Production budgets 3. Selling and Admin budgets 4. Personnel budgets Financial: 1. Pro forma f/s 2. Cash budgets
30
Budgeting ## Footnote **Master Budgets (annual business plan)** Establishing Required Level of Production Formula
Budgeted sales +Desired ending inventory -Beginning Inventory =Budgeted Production
31
Budgeting ## Footnote **Master Budgets (annual business plan)** Direct Materials Budget * 1. # of units to be purchased formula* * 2. cost of DM to be purchased* * 3. DM usage budget*
1. Units of DM needed for a production period + Desired ending inventory at the end of the period _- Beg Inv at the start of the period_ =Units of DM to be purchased for the period 2. Units of DM to be purchased for the period _x cost per unit_ =cost of DM to be purchased for the period 3. Beg inv at cost + purchases at cost _- end inv at cost_ =DM usage (cost of material used)
32
Budgeting Master Budgets (annual business plan) Cost of Goods Sold
Cost of goods manufactured + Beg finished goods inventory _- Ending finished goods inv_ =COGS example DM used - 1,432,000 DL - 1,480,000 FactoryOH (variable)- 370,000 Factory OH (fixed)- 300,000 Finished Goods Beg- 1,000,000 Finished goods End- 750,000 Compute COG Manufactured DM used 1,432,000 DL 1,480,000 FOH Variable 370,000 _FOH Fixed 300,000_ =Total cost of goods manufactured 3,582,000 _Plus finished goods, beg 1,000,000_ =Goods Available for Sale 4,582,000 _Less finished goods, ending (750,000)_ =COGS 3,832,000
33
Budgeting Master Budgets (annual business plan) Cash Budget Format
1. Beginning Cash 2. + Cash collections from sales (add) 3. - Cash Disbursements for purchases and operating expenses (subtract) 4. =Computed Ending Cash 5. -Cash requirements to sustain operations (subtract) 6. =Working Capital loans to maintain cash requirements
34
Budgeting Master Budgets (annual business plan) Capital Budgets
Allow mgmnt to evaluate the capital additions or the org, often over a multi year period. Highly dependent on the availability of cash or credit, and they generally involve L-T commitments by the org
35
Budgeting ## Footnote Flexible Budgets
Use in conjunction with master budget. Allows for adjustments for changes in production or sales and accurately reflects expected costs for the adjusted output.
36
Budgeting Flexible Budgets Benefits and Limitations
Benefits 1. display different volume levels within the relevant range to pinpoint areas in which efficiencies have been achieved or waste has occurred. Limitations 1. highly dependent on the accurate indentification of fixed and variable costs and the determination of the relevant range.
37
Variance Analysis
tool for comparing some measure of performance to a plan, budget, or standard for that measure. Used for planning and control purposes and can be used to evaluate revenues and costs. Comparison of actual results to the annual business plan is the first and most basic level of control and evaluation of operations.
38
Variance Analysis Performance Report Step 1: budget vs actual Step 2: prep flexible budget
Actual results may be easily compared with budgeted results. However, usefulness is limited by the existence of budget variances that may be strictly related to volume Example _Budgeted_ Sell 10,000 units at $15 a piece CM % = 20% FC= $25,000 _Actual_ Actual units sold= 8,000 (totaling $112,000 in revenues) Variable expenses= $100,800 and FC = $24,000 Units: 10,000 8,000 _Budget_ _Actual_ Variance F/U Revenue 150,000 112,000 (38,000) U Variable Exp _(120,000) (100,800) 19,200 F_ CM 30,000 11,200 18,800 U Fixed Costs _(25,000) (24,000) 1,000 F_ Net Income(loss) 5,000 (12,800) (17,800) U Variances need significant analysis before they are useful. The favorable variance in varaible expenses, for example, don't represent efficiencies. Budgeted CM ratios are 20%; actual cm ratio are 10%. Sales in units were off budget by 20%, yet revenues are down by 25%. Something is wrong but what? Step 2: see page 50
39
Variance Analysis Using Standards ## Footnote Std Costing Systems
Std costs in aggregate, measure the costs the firm expects that it should incur during production.
40
Variance Analysis Using Standards ## Footnote **Std Costing Systems** Uses
1. Cost control 2. Data for performance evaluations (variance analysis) 3. Ability to learn from standards and improve various processes.
41
Variance Analysis Using Standards ## Footnote Direct Materials and Direct Labor Variance (PURE DADSDADS)
* DM **P**rice Variance*= Actual Quantity purchased x (Actual price - Standard Price) * DM quantity **U**sage variance* = Standard Price x (Actual quantity used - Std quantity allowed) DL **R**ate variance= Actual hours worked x (Actual rate-Std rate) DL **E**fficiency Variance= Std rate x (Actual hours worked-Std hours allowed) Difference x Actual **(DA)** Difference x Actual **(DS)** Difference x Actual **(DA)** Difference x Actual **(DS)**
42
Variance Analysis Using Standards VOH and FOH variances
VOH Rate (spending) variance= Actual Hoursx (Actual Rate-Std Rate)-tells managers whether more or less was spent on Variable OH than expected. VOH Efficiency variance= Std Rate x ( Actual hours - Std hours allowed for actual production volume)-tied to the efficiency with which labor hours are utilized. FOH Budget (spending) variance= Actual Fixed OH-Budgeted fixed OH- FOH Volume Variance=Budgeted Fixed OH - Std Fixed OH cost allocated to production\* \*Based on Actual production x Std Rate
43
Balanced Scorecard
gathers information on multiple dimensions of an org's performance defined by critical success factors necessary to accomplish the firm's stragtegy.
44
Balanced Scorecard Critical Success factors
1. Financial-Responsibility segment/SBU 2. Internal business processes-Efficient/effective operations 3. Customer Satisfaction-customers happy 4. Advancement of innovation and human resource development (learning and growth)