Fixed Overhead Calendar Variance

... From Page O:12
Fixed Overhead » Volume Variance = Calendar + Capacity + Efficiency : Variance  
 
The Fixed Overhead Volume variance which is the difference between the absorbed fixed overhead and budgeted fixed overhead is sub divided into three as fixed overhead Calendar variance, Fixed Overhead Capacity Variance and Fixed Overhead Efficiency Variance.

• Mathematical Derivation of the Constituents

Knowing how the volume variance is segregated into calendar, capacity and efficiency may aid your understand and recollection of the formulae.

Where

  1. FOHCA = Fixed Overhead Cost Absorbed
  2. BFOHC = Budgeted Fixed Overhead Cost
  3. FOHVolV = Fixed Overhead Volume Variance
  4. FOHCalV = Fixed Overhead Calendar Variance
  5. FOHCapV = Fixed Overhead Capacity Variance
  6. FOHEffV = Fixed Overhead Efficiency Variance
  7. SFOHC(T/O) = Standard Fixed Overhead Cost for Actual Activity (Time/Output)
  8. SFOHC(D) = Standard Fixed Overhead Cost for Actual Days
Fixed Overhead Volume Variance = Fixed Overhead Absorbed − Budgeted Fixed Overhead
⇒ FOHVolV = FOHCA − BFOHC
= FOHCA − BFOHC + SFOHC(T) − SFOHC(T) + SFOHC(D) − SFOHC(D)
    [Adding and deducting SFOHC(T/O) and SFOHC(D)]
= {FOHCA − SFOHC(T/O)} + {SFOHC(D) − BFOHC} + {SFOHC(T/O) − SFOHC(D)}
= FOHEffV + FOHCalV + FOHCapV
= Efficiency Variance + Calendar Variance + Capacity Variance

• Efficiency Variance

Thus,
Fixed Overhead Efficiency Variance = Fixed Overhead Cost Absorbed
    − Standard Fixed Overhead for Actual Activity (Time/Output)
⇒ FOHEffV = FOHCA − SFOHC(T/O)

• Calendar Variance

Thus,
Fixed Overhead Calendar Variance = Standard Fixed Overhead Cost for Actual Days − Budgeted Fixed Overhead Cost
⇒ FOHCalV = SFOHC(D) − BFOHC

• Capacity Variance

Thus,
Fixed Overhead Capacity Variance = Standard Fixed Overhead Cost for Actual (Time/Output)
    − Standard Fixed Overhead Cost for Actual Days
⇒ FOHCapV = SFOHC(T/O) − SFOHC(D)

Note

  1. Standard Fixed Overhead for Actual Days = Budgeted Fixed Overhead revised for the actual days worked.
  2. Standard Fixed Overhead for Actual Activity (Time/Output)
          = Budgeted Fixed Overhead revised for the actual time worked.
        (Or) = Budgeted Fixed Overhead revised for the actual time worked.

The Formulae » Fixed Overhead Calendar Variance (FOHCalV)  
 
The Fixed Overhead Calendar Variance gives an idea of how much more or less the budgeted fixed overhead cost is when compared to the budgeted fixed overheads revised for the actual days worked.

⇒ Fixed Overhead Calendar Variance
    = Standard Fixed Overhead Cost for Actual Days − Budgeted Fixed Overhead Cost
⇒ FOHCalV = SFOHC(D) − BFOHC

• In all Cases

Budgeted Fixed Overhead Cost = Budgeted Output × Budgeted Rate per unit BFOHC = BO × BR/U
(Or) = Budgeted Time × Budgeted Rate per hour (Or) = BT × BR/H

Standard Fixed Overhead Cost for Actual Days = Budgeted Fixed Overhead Cost revised for Actual Days
=
Actual Days
Budgeted Days
× Budgeted Fixed Overhead Cost
SFOHC(D) =
AD
BD
× BFOHC

FOHCalV = SFOHC(D) − BFOHC
=
(
AD
BD
× BFOHC) − (BFOHC)
=
BFOHC × (
AD
BD
− 1)

Therefore, FOHCalV =
BFOHC × (
AD
BD
− 1)

Since this formula does not involve Absorbed Overhead, the formula would be the same in all cases.

Calendar Variance » Formula Interpretation  
 

• Where Data relating to days is not available

Where the data relating to days is not available in the problem, then we assume that there is no calendar variance, i.e. we worked for that many days as planned. In such a case the calendar variance should be zero. This would be so, if we consider AD = BD i.e the ratio AD/BD to be equal to 1.

A Problem  
 
A factory was to budgeted to produce 2,000 units of output @ one unit per 10 hours productive time working for 25 days. Rs. 40,000 of variable overhead cost and Rs. 80,000 of fixed overhead cost were budgeted to be incurred during that period.

The factory worked for 26 days putting in 860 hours work every day and achieved an output of 2,050 units. The expenditure incurred as overheads was Rs. 49,200 as variable overheads and Rs. 86,100 as fixed overheads.

What is the variation in total overhead cost on account of a variation in the number of days worked??

This information is provided by the fixed overhead calendar variance

Solution » Working Table  
 
The problem data arranged in a working table:

Particulars Budgeted Actual
a) Output 2,000 2,050
b) Working Days 25 26
c) Total Time Worked (in hrs) 20,000 22,360
d) Overhead Cost (in Rs.)
Variable
Fixed
Total

40,000
80,000
1,20,000

49,200
86,100
1,35,300
e) Overhead Rates [(d) ÷ (a)] (in Rs./Unit)
Variable   [(40,000 ÷ 2,000)]
Fixed       [(80,000 ÷ 2,000)]
Total       [(1,20,000 ÷ 2,000)]

20
40
60
 
f) Overhead Rates [(d) ÷ (c)] (in Rs./hr)
Variable   [(40,000 ÷ 20,000)]
Fixed       [(80,000 ÷ 20,000)]
Total       [(1,20,000 ÷ 20,000)]

2
4
6
 

• Note

This working table gives all the data that would be needed to solve a problem involving all overhead variances. In Calculating only the total overhead cost variance you may not need all that data.

We give it here so that you get accustomed to preparing the working table by the time you complete going through all the overhead variances.

Solution » Working Notes  
 

• Working Time

» Budgeted Time [BT]

BT = Budgeted Output × Budgeted Time/unit
= 2,000 units × 10 labor/labour hrs/unit
[@ one unit per 10 hours productive time]
= 20,000 labor/labour hrs

» Actual Time [AT]

AT = Number of Days × Actual Time/day
= 26 days × 860 labour/labor hrs/day
= 22,360 labor/labour hrs

Solution [in all cases]  
 

» Calculations Based on Units

Budgeted Fixed Overhead Cost = Budgeted Output × Budgeted Rate/Unit
⇒ BFOHC = (BO × BR/U)
= Rs. 80,000 [Given]   [(Or) 2,000 units × Rs. 40/unit]

» Calculations Based on Units

Budgeted Fixed Overhead Cost = Budgeted Time × Budgeted Rate/Hour
⇒ BFOHC = (BT × BR/H)
= Rs. 80,000 [Given]   [(Or) 20,000 hours × Rs. 4/hour]

• Calculation of Variance

• FOHCalV =
BFOH (
AD
BD
− 1)
=
Rs. 80,000 (
26 days
25 days
− 1)
= Rs. 80,000 (1.04 − 1)
= + Rs. 80,000 (+ 0.04)
= + Rs. 3,200 [Fav]

Formulae using Inter-relationships among Variances  
 
  1. FOHVolV = FOHEffV + FOHCalV + FOHCapV   → (1)

    From (1)
    FOHCalV = FOHVolV − FOHEffV − FOHCapV

  2. FOHCV = FOHVolV + FOHExpV   → (2)

    From (1) and (2)
    FOHCalV = FOHCV − FOHExpV − FOHEffV − FOHCapV

• Verification

The interrelationships between variances would also be useful in verifying whether our calculations are correct or not. After calculating the three fixed overhead variances we can verify whether FOHEffV, FOHCalV and FOHCapV add up to FOHVolV or not. If FOHEffV + FOHCalV + FOHCapV = FOHVolV we can assume our calculations to be correct.
Author Credit : The Edifier ... Continued Page O:14

♣ Copyright Krishbhavara. All rights reserved ♣ Site optimized for Internet Explorer 5.5 and above