Read the following passage carefully and answer the question. XYZ Ltd. funrnished you with the following information: Budgeted overhead rate is Rs. 1 per unit. In a particular month the actual hours worked were 31,500.Budget Actual (in a particular month) No. of working days 25 27 Production (in units) 20,000 22,000 Fixed overhead (in Rupees) 30,000 31,000
Given the information in the passage, what is the calendar variance for the month?
Rs. 2,400 (Favourable)
The question asks us to calculate the calendar variance for fixed overheads based on the provided budget and actual data for XYZ Ltd. Calendar variance is a part of fixed overhead variance analysis and specifically measures the impact of having more or fewer working days than budgeted.
Fixed overhead calendar variance arises solely due to the difference between the budgeted number of working days and the actual number of working days in a period. It is calculated using the budgeted fixed overhead rate per day.
The formula for Fixed Overhead Calendar Variance is:
\( \text{Calendar Variance} = (\text{Actual number of working days} - \text{Budgeted number of working days}) \times \text{Budgeted fixed overhead rate per day} \)
We are given the total budgeted fixed overhead and the budgeted number of working days.
Budgeted fixed overhead rate per day is calculated as:
\( \text{Budgeted rate per day} = \frac{\text{Budgeted Fixed Overhead}}{\text{Budgeted Working Days}} \)
\( \text{Budgeted rate per day} = \frac{30,000}{25} = \text{Rs. } 1,200 \text{ per day} \)
Now we use the actual and budgeted working days and the budgeted rate per day.
\( \text{Calendar Variance} = (27 \text{ days} - 25 \text{ days}) \times \text{Rs. } 1,200 \text{ per day} \)
\( \text{Calendar Variance} = 2 \text{ days} \times \text{Rs. } 1,200 \text{ per day} \)
\( \text{Calendar Variance} = \text{Rs. } 2,400 \)
The variance is favourable if the actual working days are more than the budgeted working days, as more fixed overhead can be absorbed over a longer period at the budgeted daily rate. Conversely, it is adverse if the actual working days are fewer than budgeted.
In this case, Actual Working Days (27) > Budgeted Working Days (25). The difference is 2 extra days. Since the actual days are more, the variance is Favourable.
The Calendar Variance is Rs. 2,400 Favourable.
| Item | Calculation | Value |
|---|---|---|
| Budgeted Fixed Overhead | Given | Rs. 30,000 |
| Budgeted Working Days | Given | 25 days |
| Budgeted Rate per Day | Rs. 30,000 / 25 days | Rs. 1,200 per day |
| Actual Working Days | Given | 27 days |
| Difference in Days | 27 - 25 | 2 days |
| Calendar Variance | 2 days × Rs. 1,200/day | Rs. 2,400 (Favourable) |
The calculated calendar variance of Rs. 2,400 (Favourable) matches one of the given options.
| Concept | Description | Formula |
|---|---|---|
| Fixed Overhead Variance | Difference between actual fixed overhead and fixed overhead absorbed. | Actual Fixed Overhead - Fixed Overhead Absorbed |
| Fixed Overhead Volume Variance | Difference between budgeted fixed overhead and fixed overhead absorbed. Caused by difference in production volume. | Budgeted Fixed Overhead - Fixed Overhead Absorbed OR (Actual Production - Budgeted Production) × Standard Fixed Overhead Rate per Unit |
| Fixed Overhead Expenditure Variance | Difference between budgeted fixed overhead and actual fixed overhead. | Budgeted Fixed Overhead - Actual Fixed Overhead |
| Fixed Overhead Volume Variance Break-up | Volume Variance can be broken down into Capacity Variance and Efficiency Variance. | Volume Variance = Capacity Variance + Efficiency Variance |
| Fixed Overhead Capacity Variance | Impact of difference between actual hours worked (or capacity utilized) and budgeted hours (or capacity) on fixed overhead absorption. Can be further broken down into Calendar and Idle Time variances. | (Actual Hours - Budgeted Hours) × Standard Fixed Overhead Rate per Hour |
| Fixed Overhead Efficiency Variance | Impact of difference between standard hours for actual production and actual hours worked on fixed overhead absorption. | (Standard Hours for Actual Production - Actual Hours) × Standard Fixed Overhead Rate per Hour |
| Fixed Overhead Calendar Variance | Impact of difference between actual working days and budgeted working days. Calculated based on budgeted fixed overhead rate per day. | (Actual Days - Budgeted Days) × Budgeted Fixed Overhead Rate per Day |
Fixed Overhead Variance analysis helps management understand why actual fixed overhead costs or absorption differ from budgeted amounts. While fixed costs are often considered constant in total within a relevant range, their variance analysis is crucial for control and future budgeting.
Which of the following may be the reasons for a material usage variance?
(A) Negligence in the use of materials
(B) Changes in basic prices of materials
(C) Poor or improper machine handling
(D) Wastage due to inefficient production methods
(E) Change in product design requiring usuage different from the standard
Choose the correct answer from the options given below:
An unfavourable overhead volume variance indicates that:
As per the information given below, what is the correct material yield variance ?
Standard input = 100 kg
Standard yield = 90 kg
Standard cost per kg of output = Rs. 20
Actual input = 200 kg
Actual yield = 182 kg
Actual cost per kg of output = Rs. 19
What is the total overhead variance in the given month experienced by the XYZ Ltd?
What is the expenditure variance of XYZ Ltd as on given month?