Showing posts with label Management Accounting Formulas. Show all posts
Showing posts with label Management Accounting Formulas. Show all posts

Tuesday, 5 January 2016

Over Absorption Formula

Over Absorption Formula

Over absorption result because absorption rate used by the organization due to technical reason i.e. actual information about cost is not available at time of production.

The use of predetermined rate may result in over or under absorption. When absorbed overhead are more than actual overheads, this is over absorption situation or case.

Over Absorption = Absorbed overhead – Actual Overheads

Over Absorption Formula Example

A product takes 5000 hr machine hour. The absorption rate was $ 5 per machine hour. Actual production overheads were $ 22,000. Calculate over or under absorption.

Absorbed overhead
(5000 hr x 5 per hour) =     $ 25,000
Less: Actual overheard    = $ 22,000

Over absorbed =                 $ 3,000

Labour Hour Absorption Rate Formula

Labour Hour Absorption Rate Formula

An absorption rate is calculated on the bases of Labour hour used by the different product is known as Labour hour absorption rate or absorption rate based on Labour hours. This absorption rate may be calculated by dividing production overheads with total number of Labour hours.

Absorption Rate (Labour Hr) = Production Overhead/Total Labour Hours

Labour Hour Absorption Rate Formula Example

Total overhead expenditure is $ 200,000 for two products (A, B). Total production hour is required for production is 10,000 (Hr). Calculate Labour Hour Absorption Rate

Solution

Absorption Rate (Labour Hr) = Production overhead/Total Labour hours

= $ 200,000 (production overhead)/ 10,000 Total Labour Hours
= $ 200,000/ 10,000
= $ 20 (labour hour absorption Rate)


Machine Hour Absorption Rate Formula

Machine Hour Absorption Rate Formula


An absorption rate is calculated on the bases of machine hour used by the different product is known as machine hour absorption rate or absorption rate based on machine hours. Machine hour absorption rate may be calculated by dividing production overheads with total number of machine hours.

Absorption Rate (Machine Hr) = Production Overhead/Total Machine Hours

Machine Hour Absorption Rate Formula Example

Total overhead expenditure is $ 150,000 for two products (A, B). Total production hour is required for production is 10,000 (Hr). Calculate machine Hour Absorption Rate

Absorption Rate (Machine Hr) = Production overhead/Total machine hours

= $ 150,000 (production overhead)/ 10,000 Total Machine Hours
= $ 150,000/ 10,000
= $ 15


Wednesday, 23 December 2015

Cost Sensitivity Formula

Cost Sensitivity Formula


NPV Cost sensitivity may be calculated by the Following Simple formula.

Sales Sensitivity =    Net Present Value of project (NPV)
                                         PV of Variable Cost

Example

Variable Cost = 8,000
NPV = 3,000
Calculate Cost sensitivity?

Solution

Variable Cost Sensitivity =    3,000 x100
                                           8,000
= 37.5%

It means if cost increases by 37.5%, then NPV will become Zero

Tuesday, 22 December 2015

Desired Profitability Formula

Desired Profitability Formula

Desired Level of profitability may be calculated by the following formula.

Desired Profitability = [Fixed Cost + Desired Profit]/unit Contribution

Example

Fixed Cost = 50,000
Profit = 30,000
Sales price = 30
Variable Cost = 18

Solution

Unit Contribution = 30-18
=12
= [50,000+30,000]/12
=80000/12

=6,667 (units)

Break Even Formula

Break Even Formula


Break even is a point, where organization is earning neither profit nor incurring any losses. This concept has fundamental importance for decision making. Break even point may be calculated by the following formula

Fixed Cost/ unit contribution

Where;

Unit contribution = unit Sale price – Unit Variable Cost

Example

Unit Sale Price = 60
Unit Variable Cost = 50
Fixed Cost = 50,000
What is break even point?

Solution

Unit contribution = 60-50
Unit contribution = 10
Required level     = Fixed Cost/unit Contribution
 =50,000/10
 =5,000 units



Target Cost Formula

Target Cost Formula

Target Cost can be calculated by the following Formula. Target cost concept is widely used in development of new product. This is an effective tool to control the cost of the new product.

Target Cost = Target Price-Target Profit

Example

Target Sales Price of Product= 120
Target Profit of Product= 70
Calculate Target Cost

Solution

Target Cost = Target Price-Target Profit
=120-70

=50 (Target Cost)

Cost of Goods Available for Sale Formula

Cost of Goods Available for Sale Formula

Cost of Goods available for sale is calculated by the following formula. This concept is quite different from the cost of Goods sold.

Cost of Goods Sold=Opening Finished Goods + Good Manufactured

Example

Opening Finished Goods =                   15,000
Goods Produced =                              20,000
Closing Finished Goods                        15,000

Solution

Opening Finished Goods =                   15,000
Add: Goods Produced =                       20,000

Cost of Goods available for Sale      35,000




Cost of Goods Sold Formula

Cost of Goods Sold Formula

Cost of goods sold is one of the important costs in the financial accounting system, because this cost is used to calculate the gross profit for the year (period). Cost of Goods sold formula is given below

Cost of Goods Sold=Opening Finished Goods + Good Manufactured – Closing Finished Goods

Example

Opening Finished Goods =        10,000
Goods Produced =                   16,000
Closing Finished Goods             15,000

Solution

Opening Finished Goods =        10,000
Add: Goods Produced =            16,000
Closing Finished Goods            (15,000)

Cost of Goods Sold               11,000


Cost of Goods Manufactured Formula

Cost of Goods Manufactured Formula

Cost of Goods manufacture means that how money good are produced during the year (Finished Goods). This concept is quite different from the cost of goods sold. All goods manufacture is not supposed to be sold in the current year.

Cost of Good Manufactured = WIP Opening + Factory Cost this Year – WIP Closing

Example

WIP-Opening = 10,000
Direct Labour =   5,000
Direct Material = 6,000
Factory Overhead= 8000

Solution

WIP-Opening =                      10,000
Add: Direct Labour =               5,000
Add: Direct Material =             6,000
                                          21,000
Factory Overhead=                (8000)
Cost of Goods Manufactures   13,000



Prime Cost Formula

Prime Cost Formula

Prime cost includes the direct labour & direct material cost. in other word prime cost can be calculated by adding direct material and direct labour cost.

Prime Cost = Direct Labour + Direct Labour

Example

Direct Labour = 5
Direct Material = 6
Prime Cost=?

Solution

Prime Cost = Direct Labour + Direct Labour
=5+6

=11 (Prime Cost)

Factory Cost Formula

Factory Cost Formula

Factory Cost formula includes three cost Direct Labour, Direct material, Factory Overheads.
Factory Cost Formula = Direct Material + Direct Labour + Factory overhead

Example

Unit Material Cost = $7
Unit Labour Cost = $8
Factory overhead = $ 2

Solution


Factory Cost Formula = Direct Material + Direct Labour + Factory overhead
Unit Material =                      7
Unit Labour =                        8
Factory Overheads=              2
Factory Cost =                     17





Monday, 21 December 2015

Fixed Overhead Capacity Variance Formula

Fixed Overhead Capacity Variance Formula

Fixed overhead Capacity variance is the difference between budgeted hours and actual hour worked and such difference is measured at standard hours.

Fixed overhead capacity = standard rate x (budgeted hours x actual Hours)

Example
Budgeted Unit Produced = 1400
Actual production= 1200
Budgeted hour per unit = 6
Actual hours taken = 7000
Standard absorption rate= 10
Calculated fixed capacity variance?

Solution

Budgeted hours = 1400 x 6= 8400
Fixed overhead capacity = standard rate x (budgeted hours x actual Hours)
= $ 10 x (8400-7000)
= $ 10 – 1400
= 14000 (Adverse)

Actual hour are lower than budgeted hours.







Fixed overhead volume Variance Formula

Fixed overhead volume Variance Formula

Fixed overhead volume variance is calculated by the following formula. Variable overheads volume variance may be favorable or adverse.

Standard Rate x (Budgeted Production – Actual Production)

Example
Actual Production = 1200
Budgeted Production = 800
Standard absorption Rate= $ 6

Solution

Standard Rate x (Budgeted Production – Actual Production)

= $ 6 x (1200-800)
= $6 x 400
=2400 Favorable

Variance is favorable because actual production is more than budgeted.


Fixed Overhead Efficiency Variance Formula

Fixed Overhead Efficiency Variance Formula


Fixed overheads efficiency Variance is difference between standard hr and actual hour taken by the production and such difference is measured at standard rate.

Fixed overhead efficiency variance = Standard rate (Standard hour – Actual Hrs)

Example
Unit produced = 5000
Standard hrs = 5 Hr per unit
Actual Hours = 24,000
Standard Rate = $ 6

Solution
Standard Hours = Production x standard hours =

5000 units x 5 hr= 25,000 hrs

Fixed overhead efficiency variance = Standard rate (Standard hour – Actual Hrs) 
= $ 6 x (25,000-24,000)
= $ 6 x 1000
= $ 6000


Fixed Overhead Expenditure Formula

Fixed Overhead Expenditure Formula

Fixed overhead expenditure is difference between budgeted fixed overhead expenditure and actual fixed overhead expenditure. This variance can be expressed as under

Fixed overhead Expenditure = Budgeted FOH – Actual FOH

Example
Budgeted Expenditure = 40,000
Actual Expenditure = 45,000

Solution
Fixed overhead Expenditure = Budgeted FOH – Actual FOH
=40,000-45000

=5000

Fixed Overheads Total Variance Formula

Fixed Overheads Total Variance Formula

Fixed overhead Total variance is difference between Fixed overhead incurred and Fixed overhead observed. Fixed overhead total variance may be favorable or adverse.

Fixed Overhead Total Variance =FOH Absorbed – FOH incurred

Example

Unit Produced= 10,000
Absorption Rate = $ 4 per unit
Actual Fixed overheads = 50,000

Solution

Absorbed = unit produced x Rate
 = 10,000 x $ 4
= $ 40,000

Fixed Overhead Total Variance = Fixed overhead incurred – FOH Absorbed

= 50,000-40,000
=10,000 (Fixed overhead total variance)

 Fixed overhead variance amounting 10,000/- is favorable.







Variable Overhead Expenditure Variance Formula

Variable Overhead Expenditure Variance Formula

Variable overhead Expenditure variance can be calculated by the following simple formula. Variable overhead expenditure variance can be favorable or adverse.

Actual Variable Overhead – (Actual Hr x Standard Rate per Hr)

Example
Actual Expenditure 100,000
Actual Hr 25,000
Standard Rate $ 5

Solution
Actual Variable Overhead – (Actual Hr x Standard Rate per Hr)
= 100,000 – (25,000 x 5)
= 100,000- 125,000

=-25,000


Variable Overhead Efficiency Variance Formula

Variable Overhead Efficiency Variance Formula

Variable overheads efficiency variance can be calculated by the following formula. Variable overhead efficiency variance may be favorable or adverse.

Variable overhead efficiency = Standard Rate x (Standard Hr-Actual Hr)

Example
Standard rate = $ 10
Standard Hr = 8 Hr per unit
Unit produced= 10,000
Actual Hr = 70,000

Solution
Standard hour = units produced x Hr taken per unit
= 10,000 x 8
=80,000 Hr

Variable overhead efficiency = Standard Rate x (Standard Hr-Actual Hr)
= 10 x (70,000-80,000)
= 10 x -10,000

=-100,000 (adverse Variable overhead efficiency variance).


Sunday, 20 December 2015

Material Usage Variance Formula

Material Usage Variance Formula

Material usage variance is difference between standard quantity and actual quantity and such difference is measured at standard cost. Material usage variance may be favorable or adverse.

Material usage Variance = Standard Price x (Standard Quantity- Actual Quantity).

Example
Actual Quantity Consumed = 5000 kg
Per unit Standard Price of material A = $ 8
Units produced=1000
Standard usage per unit = 6 kg
Price of Material = 40,000
Calculate Material Price Variance

Solution
Standard consumption = Units produced x standard usage
=1000 x 6
=6,000 kg

$ 8 x (6000-5000)
= $ 8 x 1000
= $8000 (material usage variance)