Skip to main content

How to prepare Flexible budget?


Example: The budgeted expenses of 4000 units are given below and only 50% capacity is used:
Fixed expenses:
·         Overhead expenses Rs. 10, 000
·         Factory expenses Rs. 38, 500
·         Administrative expenses Rs. 40, 000
Variable Expenses:
·         Repair and maintenance charges Rs. 15 000
·         Labour cost @ Rs.3 per unit
·         Raw material cost @Rs.0.60 per unit
Semi-variable expenses:
·         Selling and distribution expenses Rs. 20, 000
·         Salary and wages Rs.16,800
 Fixed expenses do not change with changes in unit level. If 70% capacity is used then the expenses increases by 10% and if 100% capacity is used then variable expenses increases by 30%. Prepare flexible budget with the help of above information.

Solution:
Particulars
50% production capacity
70% production capacity
100% production capacity
Fixed expenses:



Overhead expenses
10, 000
10, 000
10, 000
Factory expenses
38, 500
38, 500
38, 500
Administrative expenses
40, 000
40, 000
40, 000
Total
88, 500
88, 500
88, 500
Variable expenses:



Repair and maintenance charges
15, 000
21, 000
30, 000
Labour cost
2, 400
3, 360
4, 800
Total
17, 400
24, 360
34, 800
Semi-variable cost:



Selling and distribution expenses
20, 000
22, 000
26, 000
Salary and wages
16, 000
17, 600
20, 800
Total
36, 000
39, 600
46, 800
Total cost
1, 41, 900
1, 52, 460
1, 70, 100

Working notes:
Variable expenses of repair and maintenance charges:
 For 70% capacity = (15,000/50)*70
= Rs. 21, 000
For 100% capacity = (15,000/50)*100
= Rs. 30, 000
Variable expenses of labour cost:
For 50% capacity = 0.60*4000 =Rs. 2, 400
For 70% capacity = (2, 400/50)*70
= Rs. 3, 360
For 100% capacity = (2, 400/50)*100
= Rs. 4, 800
Semi variable expenses (Selling and distribution):
For 70% capacity = 20, 000 + (20, 000*10/100)
= 20, 000 + 2, 000
= Rs. 22, 000
For 100% capacity = 20, 000 + (20, 000*30/100)
= 20, 000 + 6, 000
Rs. 26, 000
Salary and wages:
For 70% capacity = 16, 000 + (16, 000*10/100)
= 16, 000 + 1, 600
= Rs. 17, 600
For 100% capacity = 16, 000 + (16, 000*30/100)
= 16, 000 + 4, 800
Rs. 20, 800

Example: The budgeted expenses of 10, 000 units are as follows:
·         Selling and distribution expenses(15% fixed) = Rs. 5 per unit
·         direct labour (fixed expenses)Rs. 2 per unit
·         Maintenance charges (fixed20%) =Rs. 4.2 per unit
·         Wages and salaries (variable expenses)= Rs. 4.5 per unit
·         Office expenses (variable expenses) = Rs. 6 per unit
·         Raw material (fixed expenses) =Rs. 3.5 per unit
Prepare the flexible budget of 6, 000 units and 8, 000 units.

Solution:
Particulars
10,000 units
6, 000 units
8, 000 units
Fixed expenses:
(In Rs.)
(In Rs.)
(In Rs.)
Direct labour
20, 000
20, 000
20, 000
Raw material
35, 000
35, 000
35, 000
Total
55, 000
55, 000
55, 000
Variable expenses:



Wages and salaries
45, 000
27, 000
36, 000
Office expenses
60, 000
36, 000
48, 000
Total
1,05, 000
63, 000
84, 000
Semi-variable expenses:



Selling and distribution expenses
50, 000
33, 000
41, 500
Maintenance charges
42, 000
28, 560
35, 280
Total
92, 000
61, 560
76, 780
Total cost
2, 52, 000
1, 79, 560
2, 15, 780
Cost per unit (total cost /units produced)
25.2
29.92
26.97

Working notes:
Selling and distribution (10, 000 units):
Total cost = Rs. (5 * 10,000) = Rs. 50, 000
Fixed cost = 15/100 *50,000 = Rs. 7, 500
Variable cost = Rs. (50,000 – 7, 500) = 42, 500
6000 units selling and distribution (variable cost):
7, 500+ (42, 500/10,000)*6000
= Rs. (7,500+25, 500) = Rs. 33, 000
8000 units selling and distribution cost:
 7, 500 + (42,500 / 10, 000)*8000
 = Rs. (7,500 + 34, 000) = Rs. 41, 500
Maintenance charges (10, 000 units):
Total expenses = Rs. 4.2*10, 000 = Rs. 42, 000
Fixed cost = 42, 000*0.20 = Rs. 8,400
Variable cost = Rs. (42, 000 – 8, 400) = Rs.33, 600
Maintenance charges (6000 units):
8, 400 + (33, 600 / 10, 000)*6000
= 8, 400 + 20, 160
= Rs. 28, 560
Maintenance charges (8000 units):
8, 400 + (33, 600 / 10, 000)*8000
= 8,400 + 26, 880
= Rs. 35, 280















Comments

Post a Comment

Popular posts from this blog

How to calculate Cost of Preference Share Capital?

Cost of Preference Share Capital:  An amount paid by company as dividend to preference shareholder is known as Cost of Preference Share Capital. Preference share is a small unit of a company’s capital which bears fixed rate of dividend and holder of it gets dividend when company earn profit. Dividend payable is not a tax deductible amount. So, there is no tax adjustments required for comparing with cost of debt. Formula for Cost of Preference Share: Irredeemable Preference Share Redeemable Preference Share K p  = Dp/NP K p  = D p +((RV-NP)/n )/ (RV+NP)/2 Where, K p  = Cost of Preference Share D p  = Dividend on preference share NP = Net proceeds from issue of preference share (Issue price – Flotation cost) RV = Redemption Value N = Period of preference share Example:  A company issues 20,000 irredeemable preference share at 8% whose face value is Rs.50 each at 4% discount. Find out the Cost of Preference Share Capital.
87 comments
Read more

What is the difference between Cheque book and Pass book?

 Cheque book is issued by bank in customers / account holder request. With the help of this book account holder can withdraw cash from his/her account. Bank does not charge any fee to issued cheque book to its customer. But afterward bank charges some amount for using bank facility like cheque book, Debit card etc.So, Automatic some definite amount deducted from customer bank account. Pass book is  also issued by bank to its customer. It helps to record all the bank related activity according to date that is withdrawal and deposit. It is recorded by bank but the book is kept by customer to know the current balance of  his /her account.  Point of difference Pass book Cheque book What is the meaning of pass book and cheque book? Passbook is a book in which all withdrawal and deposit against customer account is recorded.   Cheque book is a book of cheques which are used to withdrawal the money to bank account.
Post a Comment
Read more

How to calculate interest on Hire Purchase System?

Interest on hire purchase:  Interest is calculated on Cash value of goods not in instalment value which includes cash value of goods and interest amount. It is calculated on yearly, quarterly and yearly basis. Interest is not calculated on down payment which is paid at delivery of goods. Depreciation is also charged on the hire purchase goods at the end of financial year. The method applies for depreciation is based on the contract between the parties.   Example:  Company V purchased a machine of Rs.70, 000 and paid Rs.5, 000 as down payment. The interest charged @6% and 8% depreciation annually. The instalment value for each year is Rs. 10,000. Find out the interest amount for 5 years. Solution: Interest calculated on Rs. Interest Instalment Cash Value 65, 000 65, 000*0.06 = 3, 900 12, 500 8, 600 56, 400 56, 400*0.06 = 3, 384 12, 500 9, 116 47, 284 47, 284*0.06 = 2, 837 12, 500 9, 6
3 comments
Read more