Formula of Predetermined Overhead Rate (Table of Contents)
What is Predetermined Overhead Rate Formula?
Predetermined Overhead rate is that rate which shall be used to calculate an estimate on the projects which are yet to commence for overhead costs. This would involve calculating a known cost (like Labor cost) and then applying an overhead rate (which was predetermined) to this in order to project an unknown cost (which is the overhead amount). The formula for calculating Predetermined Overhead Rate is represented as follows
Where,
- O/H is overhead
- Total base units could be the number of units or labor hours etc.
Explanation of the Predetermined Overhead Rate Formula
The predetermined overhead rate equation can be calculated using the below steps:
- Gather total overhead variables and the total amount which is spent on the same.
- Find out a relationship of cost with the allocation base which could be labor hours or units and further it should be continuous in nature.
- Determine one allocation base for the department in question.
- Now take a total of overhead cost and then divide the same by allocation base determined in step 3.
- The rate computed in step 4 can be applied to other products or departments as well.
Examples of Predetermined Overhead Rate Formula (with Excel Template)
Let’s see some simple to advanced examples of the Predetermined Overhead Rate Equation to understand it better.
Example #1
Suppose that X limited produces a product X and uses labor hours to assign the manufacturing overhead cost. The estimated manufacturing overhead was $155,000 and the estimated labor hours involved were 1,200 hours. You are required to compute a predetermined overhead rate.
Solution
Here the labor hours will be base units.
Use the following data for calculation predetermined overhead rate
Calculation of predetermined overhead rate can be done as follows:
=150000/1200
Predetermined Overhead Rate will be –
Predetermined Overhead Rate = 125 per direct labor hour
Example #2
Gambier is head of TVS Inc. He is considering the launching of new product VXM, however, he wants to consider the pricing for the same. He has asked the production head to come up with the details of costing based on existing product overhead cost so as to apply the same to product VXM while making its pricing decisions. The details from the production department are as follows:
The production head wants to calculate a predetermined overhead rate as that is the main cost which would be allocated to new product VXM. You are required to calculate the predetermined overhead rate.
4.8 (614 ratings)
As the production head wants to calculate the predetermined overhead rate, all the direct costs will be ignored in the calculation whether it be direct cost (labor or material).
Solution
Calculation of Total Manufacturing Overhead
The total manufacturing overhead cost will compose of variable overhead and fixed overhead which is the sum of 145,000 + 420,000 equals to 565,000 total manufacturing overhead.
=145000+420000
Total Manufacturing Overhead = 565000
Here the labor hours will be base units
Calculation of predetermined overhead rate can be done as follows:
=565000/8500
Predetermined Overhead Rate will be –
= 66.47 per direct labor hour
Hence, this predetermined overhead rate of 66.47 shall be applied to the pricing of new product VXM.
Example #3
Company X and Company Y are competing to acquire a huge order as that will make them much recognized in the market and also the project is lucrative for both of them. After going to its terms and conditions of the bidding, it stated the bid will do on the basis of the overhead rate percentage. The one with the lower shall be awarded the auction winner. Since this project would involve more overheads. Both of the companies have reported the following overheads.
You are required to calculate the predetermined overhead rate based on the above information and determine the chances of which company is more?
Solution:
We shall first calculate the total manufacturing overhead cost for Company A
=35000+120000+155670+45009+345600
- Total Manufacturing Overheads = 701279
Total Labor Hours will be –
=2000*2
- Total Labor Hours =4000
Calculation of Predetermined Overhead Rate for Company A is as follows
=701279/4000
Predetermined Overhead Rate for Company A will be –
Predetermined Overhead Rate = 175.32
We shall first calculate the total manufacturing overhead cost for Company B
=38500 + 115000 + 145678 + 51340 + 351750
- Total Manufacturing Overheads = 702268
Total Labor Hours will be –
=2500*1.5
- Total Labor Hours =3750
Calculation of Predetermined Overhead Rate for Company B is as follows
=702268/3750
Predetermined Overhead Rate for Company B will be –
Predetermined Overhead Rate = 187.27
Hence, preliminary it appears that company A could be the winner of the auction even though labor hour use by company B is less and units produce are more only because its overhead rate is more than that of company A.
Relevance and Uses
Commonly, in the manufacturing industry, the manufacturing overhead cost for machine hours can be ascertained from the predetermined overhead rate. In the case of machine production, this rate can be used for identifying the expected costs, which shall allow the firm to allocate their financial resources properly which are needed so as to ensure the efficient and proper working of operations and production. Further, it is stated as estimated the reason for the same is overhead are based on estimations and not the actuals.
Recommended Articles
This has been a guide to the Predetermined Overhead Rate Formula. Here we discuss the calculation of predetermined overhead rate using its formula and downloadable excel template. You can learn more about accounting from the following articles –
