Get help

Help center

Guides and answers

Contact support

Write to our team

Sign in to

Workflows

Build processes with your team

Automations

Connect files and automate tasks

One system, four parts

AI agents

Virtual Employees that work 24/7

Automations

Connect files and automate tasks

Workflows

Build processes with your team

Data Space

Trusted data sharing and control

Solutions by department

Finance

Reports, budgets, and reconciliations

Inventory and manufacturing

Stock, orders, and production in one view

HR

Timesheets, attendance, and reviews

Project management

Status and workload across projects

Sales and CRM

Leads and deals kept up to date

Education

Student records and school data

Finance

Turn manual finance work into reports that update themselves.

What Finance teams automate

  • Track payables and receivables
  • Build cash flow statements
  • Compare budget against actuals

Inventory and manufacturing

See stock levels and automate ordering.

What inventory and manufacturing teams automate

  • Track inventory across multiple sites
  • Connect sales, purchasing, and warehouse data
  • Link a barcode scanner to your sheet

HR

Run recruitment, attendance, and OKR tracking from your sheets.

What HR teams automate

  • Track recruitment and onboarding
  • Record team OKRs and results
  • Track check-ins, check-outs, and leave

Project management

Assign tasks and track hours without manual updates.

What project teams automate

  • Assign tasks and track status changes
  • Estimate effort and log hours worked
  • Track milestones across projects

Sales and CRM

Track leads and sales performance with automated reports.

What sales teams automate

  • Track and convert leads
  • Set sales goals and track team metrics
  • Monitor sales KPIs on dashboards

Education

Automate attendance, grades, and school purchasing.

What schools automate

  • Track attendance and notify parents
  • Record and compare class grades
  • Track inventory lent to students and staff

Find a use case

By department

How each team uses Sheetgo

By industry

How each industry uses Sheetgo

By company size

Small, medium-sized, or large

Learn

Blog

Guides and product news

Customer stories

How teams like yours use Sheetgo

Help center

Guides and answers

Why Sheetgo

Compare

How Sheetgo compares with other tools

Security

How we protect your data

Trust center

Our compliance details

Sign in to

Workflows

Build processes with your team

Automations

Connect files and automate tasks

One system, four parts

AI agents

Virtual Employees that work 24/7

Automations

Connect files and automate tasks

Workflows

Build processes with your team

Data Space

Trusted data sharing and control

Solutions by department

Finance

Reports, budgets, and reconciliations

Inventory and manufacturing

Stock, orders, and production in one view

HR

Timesheets, attendance, and reviews

Project management

Status and workload across projects

Sales and CRM

Leads and deals kept up to date

Education

Student records and school data

Find a use case

By department

How each team uses Sheetgo

By industry

How each industry uses Sheetgo

By company size

Small, medium-sized, or large

Get started

Templates

Ready-made workflows to start from

Learn

Blog

Guides and product news

Customer stories

How teams like yours use Sheetgo

Help center

Guides and answers

Why Sheetgo

Compare

How Sheetgo compares with other tools

Security

How we protect your data

Trust center

Our compliance details

Help center

Guides and answers

Contact support

Write to our team

Workflows

Build processes with your team

Automations

Connect files and automate tasks

How to find fixed cost (complete guide)

There are many costs associated with running a business, and if you want that business to stay alive, you need to keep track of all of them. You also need to be aware of the differences between fixed and variable costs, as they play different roles in your company’s finances. While there may be some wiggle room regarding lowering certain variable costs – for example, you may find vendors that charge less for the raw materials – fixed costs tend to be more difficult to decrease. The amount you pay for rent, for example, is unlikely to go anywhere but up.

In this article, you will learn about fixed costs and how to find fixed costs from total costs and total variable costs. You will also learn how to calculate the fixed cost per unit and the average fixed cost. Additionally, you will learn how to use Google Sheets to calculate the fixed cost per unit and average fixed costs.

What is fixed cost?

Fixed costs are those not directly associated with production. They are sometimes referred to as indirect or overhead costs. Unlike variable costs, they remain fixed regardless of production level. Common fixed costs include rent, licenses, and permits. You may not need them directly for production, but your business can’t run without paying for these fixed costs.

Salaries are a good example of a cost that is frequently considered fixed. However, in some cases, parts of the salary may be variable costs – like bonuses or commissions – which are affected by increased or decreased production. In these cases, the total amount paid out as salaries can be considered a semi-fixed or semi-variable cost, as it has both components. It’s important to identify these costs and divide them into fixed and variable components.

Whether you produce thousands of units of your product or none at all, fixed costs won’t change. This makes the total fixed cost and the average fixed cost important metrics to consider when evaluating a company. Fixed costs have to be covered even when production and sales are at a minimum, so you need to keep a close eye on them.

How do you calculate fixed cost?

Total fixed costs can be calculated by adding up all fixed costs for a given period. They can also be calculated by subtracting variable costs from total costs. The fixed cost formula looks like this:

Fixed costs = Total costs – Variable costs

Depending on the number of products made by your company, you will need to calculate a few other metrics associated with fixed costs. For example, you’ll need to calculate the total fixed costs for a given period to find the average fixed costs.

How to find total fixed cost?

There are different methods that can be used to calculate total fixed costs. The first is to go through your records, making a note of all costs not directly related to making your product and adding them up.

If you already know the total variable costs for a given period, you can subtract them from the total costs for that period to find the total fixed costs. The total variable costs can be calculated by multiplying the variable cost per unit by the total number of units made.

Total fixed costs = Total costs – (Variable cost per unit * Total number of units)

How to find average fixed cost?

While fixed costs are not directly related to production, for accounting purposes, it’s useful to assign a proportion of these costs to each unit of output: the average fixed cost. Use the average fixed cost formula to calculate it for a given period.

Average fixed costs = Total fixed costs / Total number of units made

If your company makes multiple products, you need to ensure that your total number of units includes all products.

Since these calculations need to be repeated periodically, it makes sense to set up a template in Google Sheets or Excel to speed up the process. The next section includes examples that have been done using Google Sheets. If you work in a team and have cost data spread out over different files, you can use Sheetgo’s AI automations to connect those files and update your calculations automatically.

Fixed costs examples

Company X’s accounting team is working on fixed costs. They want to calculate their total fixed costs for break-even analysis, but they also want to know their average fixed costs. For this example, calculations will be based on the previous month’s costs.

Step 1: identify all fixed costs

Either of the methods mentioned in the previous sections can be used to find fixed costs. Company X can go through the expense records adding up all the costs that aren’t directly related to production. However, if they know their total costs and their total variable costs, they can use that instead.

1. In Sheets, type in the values you need: total costs and variable costs for the month.

How to find fixed cost — Google Sheets table for Company X with total costs of $5,500.00, 500 units each of Product A and Product B, and a $3.26 average variable cost

2. You can calculate total variable costs by multiplying the variable cost per unit by the total number of units made that month.

Total variable cost — formula =B5*(B4+C4) typed into the Total Variable Costs row

3. The total variable cost for the month is $3,260.

Total variable cost — Total Variable Costs row showing $3,260.00

Step 2: calculate total fixed costs

Now, you just need to apply the fixed cost formula.

1. Subtract the total variable costs from the total costs.

How to find total fixed cost — formula =B3-B6 typed into the Total Fixed Costs row

2. The total fixed cost for the month is $2,240.

How to find total fixed cost — Total Fixed Costs row showing $2,240.00

Step 3: calculate average fixed costs

Now that you know the total fixed cost, calculating the average fixed cost is easy.

1. Divide the amount for total fixed costs by the total number of units made of both products.

Average fixed cost — formula =B7/(B4+C4) typed into the Average Fixed Costs row

2. That’s it. The average fixed cost for Company X is $2.24.

Average fixed cost — Average Fixed Costs row showing $2.24

Conclusion

Keeping accurate and detailed records of all costs is an important part of running a profitable business. These costs need to be categorized as fixed or variable in order to carry out further financial analysis, like profitability and break-even analyses. Sheetgo’s AI virtual employee for finance can pull cost data from files in different formats and keep these calculations up to date.

You now know about fixed costs and how to find them from total costs or by identifying all fixed costs and adding them up. You also know how to use Google Sheets to calculate total fixed cost, fixed cost per unit, and average fixed cost.

Fixed costs also feed your budget and your income statement. To track them month by month, start from a Google Sheets budget template or our profit and loss statement template. Then check your plan against real spending with a budget vs actual analysis.

● Available 24/7

Put Owen on your finance ops

Sheetgo's finance virtual employee keeps your numbers current and your reporting on time. Your data stays in Google Sheets; you work with Owen in Slack, Teams, or Google Chat.

You may also like…

simple finance add on featured image

Build a stock portfolio spreadsheet, track your investments

Staying on top of your investments can be a real challenge, particularly if you manage them through many brokers. In this post we will...
finance

How to use Google Sheets for currency conversion

Staying up to date with the latest conversion rates can be a daunting task. But it doesn’t have to be. Read on to learn how to use Google...
finance processes and templates

8 steps to prepare a bank reconciliation statement

Bank reconciliation is a crucial financial process for businesses to ensure that records match bank statements. In this post, we'll...