Estimating Softwares

Takeoff Tools

Estimating Services

 

How to use regression and scatter plot method to figure out fix and variable cost

 

 

Charlie Cai explains regression and scatter plot method, that can be applied through excel to create estimation of fix and variable cost, by this useful construction video.

 

Scatter graph method refers to a graphical process for segregating fixed and variable components concerning mixed cost through plotting activity level near x-axis and equivalent total cost (mixed cost) near y-axis.

 

A regression line is then sketched on the graph with visual inspection to compute the total fixed cost and variable cost for each unit. The meeting point of line in y-axis denotes the calculated fixed cost and the slope of the line denotes the average variable cost for each unit.

 

This method should be used cautiously as the visual inspection does not include any mathematical testing.

 

 

Estimating Fix and Variable Cost using Excell

 

Estimating Sheets

DISCLAIMER: "Autodesk, AutoCAD, Revit, Navisworks, Ecotect, QTO, DWG, 3ds Max, are registered trademarks or trademarks of Autodesk, Inc. All other brand names, product names, or trademarks belong to their respective holders. 2010 Autodesk, Inc. All rights reserved.
HOME | SERVICES | SHEETS | DIRECTORY | CONTACT | ABOUT US | PRESS RELEASES | EVENTS | ADVERTISING

Site Design & Develop by

Global Associates

Join Our Email List