Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

In Costing what are the methods for separating mixed costs into fixed and variable?

user-image
Question ajoutée par Rehan Qureshi , Financial Consultant , Self Employeed
Date de publication: 2014/01/10
Rehan Qureshi
par Rehan Qureshi , Financial Consultant , Self Employeed

I know of three methods for separating mixed costs into their fixed and variable cost components:1. Prepare a scatter graph by plotting points onto a graph.2. High-low method.3. Regression analysis. It is wise to prepare the scatter graph even if you use the high-low method or regression analysis. The benefit of the scatter graph is that it allows you to see if some of the plotted points are simply out of line. These points are referred to as outliers and will need to be reviewed and possibly adjusted or eliminated. In other words, you don't want incorrect data to distort your calculations under any of the three methods. Let's assume that a company uses only one type of equipment and it wants to know how much of the monthly electricity bill is a constant amount and how much the electricity bill will increase when its equipment runs for an additional hour. The scatter graph's vertical or y-axis will indicate the dollars of total monthly electricity cost. Its horizontal or x-axis will indicate the number of equipment hours. For each monthly electricity bill, a point will be entered on the graph at the intersection of the dollar amount of the total electricity bill and the equipment hours occurring between the meter reading dates shown on the electricity bill. If you plot this information for the most recent12 months, you may see some type of pattern, such as a line that rises as the number of equipment hours increase. If you draw a line through the plotted points and extend the line through the y-axis, the amount where the line crosses the y-axis is the approximate amount of fixed costs for each month. The slope of the line indicates the variable cost per equipment hour. The slope or variable rate is the increase in the total monthly electricity cost divided by the change in the total number of equipment hours. The high-low calculation is similar but it uses only two of the plotted points: the highest point and the lowest point. Regression analysis uses all of the monthly electricity bill amounts along with their related number of equipment hours in order to calculate the monthly fixed cost of electricity and the variable rate for each equipment hour. Software can be used for regression analysis and it will also provide statistical insights. If  a scatter graph of data shows no clear pattern, you should not place much confidence in the calculated amount of  the fixed cost and variable rate regardless of the method used.

Ahmed Abd Alwahab Awad Ibrahim
par Ahmed Abd Alwahab Awad Ibrahim , Chief Accounting , ICCDP

by simple way there many  statistical method Like 

"Trend analysis" "High Low Method"

Mohammed Hussain Shah
par Mohammed Hussain Shah , Finance Manager , Al-Naba Contracting Co. Ltd

Besides, the methods enuanciated as above, to understand the behaviour of the costs by trend analysis, one can also attempt at identifying the cost drivers and see where these drivers fall in the cost structure of the organization. Travelling expenses , for example, may be seggregated in to those incurred by salesmen and those incurred by the managment. Insurance may likewise be divided into transit insurance for raw materials and final products and general insurance for company assets. Same may be applied for many other expenses like R&M etc.

Mohammad Tohamy Hussein Hussein
par Mohammad Tohamy Hussein Hussein , Chief Executive Officer & ERP Architect , Egyptian Software Group

Fixed cost is the cost related to the unit of the product. Variable cost is the cost related to the quantity produced.

More Questions Like This