Make 2015 totally awesome. Take the Dummies challenge and you could win $1,000! Learn how.
Analyze Accounts to Separate Mixed Costs into Variable and Fixed Components
Bookkeeping: Posting Journal Information to the Appropriate Accounts
Top 10 Ways to Manage Your Business Cash with Your Books

Scattergraph to Separate Mixed Costs into Variable and Fixed Components

Step 3 of 3
Next Slideshow
Next Slideshow

On this graph, plot each point from the table.

Plot each data point on your graph. You can do so manually by using graph paper or electronically by using Excel’s Chart Wizard:

Enter the data from Step 1 into the Excel spreadsheet.

Select only the two columns of data (“Production” and “Total Cost”).

In the “Insert” menu, click on “Scatter” and then “Scatter with only Markers.”

Label the axes appropriately.

If you’re trying to predict total costs for a future month, select the anticipated activity level for that month along the x-axis. Then use data points from previous months to estimate the total cost.

  • Add a Comment
  • Print
  • Share

Recommends

Promoted Stories From Around The Web

blog comments powered by Disqus
Filing Year-End Summaries
Tracking Sales with Mobile Devices and Cash Sales
How to Adjust for General Ledger Errors
Top 10 Mobile Apps for Bookkeepers
Getting Started with Accounting Software
Advertisement