{"id":266790,"date":"2024-03-13T20:08:20","date_gmt":"2024-03-13T19:08:20","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=266790"},"modified":"2026-11-18T15:49:21","modified_gmt":"2026-11-18T14:49:21","slug":"calculer-couts-fixes","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/finance-processes\/fixed-cost\/","title":{"rendered":"Comment calculer les co\u00fbts fixes (guide complet)"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221; da_disable_devices=&#8221;off|off|off&#8221;][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>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\u2019s finances. While there may be some wiggle room regarding lowering certain variable costs &#8211; for example, you may find vendors that charge less for the raw materials &#8211; fixed costs tend to be more difficult to decrease. The amount you pay for rent, for example, is unlikely to go anywhere but up.<\/p>\n<p>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.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;what-is-fixed-cost&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>What is fixed cost?<\/h2>\n<p>Fixed costs are those not directly associated with production. They are sometimes referred to as indirect or overhead costs. Unlike <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/variable-cost\/\">variable costs<\/a>, 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\u2019t run without paying for these fixed costs.<\/p>\n<p>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 &#8211; like bonuses or commissions &#8211; 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\u2019s important to identify these costs and divide them into fixed and variable components.<\/p>\n<p>Whether you produce thousands of units of your product or none at all, fixed costs won\u2019t 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.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;how-do-you-calculate-fixed-cost&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How do you calculate fixed cost?<\/h2>\n<p>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:<\/p>\n<blockquote>\n<p>Fixed costs = Total costs &#8211; Variable costs<\/p>\n<\/blockquote>\n<p>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\u2019ll need to calculate the total fixed costs for a given period to find the average fixed costs.<\/p>\n<h3>How to find total fixed cost?<\/h3>\n<p>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.<\/p>\n<p>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.<\/p>\n<blockquote>\n<p>Total fixed costs = Total costs &#8211; (Variable cost per unit * Total number of units)<\/p>\n<\/blockquote>\n<h3>How to find average fixed cost?<\/h3>\n<p>While fixed costs are not directly related to production, for accounting purposes, it\u2019s 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.<\/p>\n<blockquote>\n<p>Average fixed costs = Total fixed costs \/ Total number of units made<\/p>\n<\/blockquote>\n<p>If your company makes multiple products, you need to ensure that your total number of units includes all products.<\/p>\n<p>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 <a href=\"https:\/\/www.sheetgo.com\/automations\/\">Sheetgo&#8217;s AI automations<\/a> to connect those files and update your calculations automatically.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;fixed-costs-examples&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Fixed costs examples<\/h2>\n<p>Company X\u2019s 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\u2019s costs.<\/p>\n<h3>Step 1: identify all fixed costs<\/h3>\n<p>Either of the methods mentioned in the previous sections can be used to find fixed costs. Company X can go through the <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-templates\/expense-tracker-template-in-google-sheets\/\">expense records<\/a> adding up all the costs that aren\u2019t directly related to production. However, if they know their total costs and their total variable costs, they can use that instead.<\/p>\n<p><strong>1.<\/strong> In Sheets, type in the values you need: total costs and variable costs for the month.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/how-to-find-fixed-cost-production-data.webp&#8221; alt=&#8221;How to find fixed cost \u2014 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&#8221; title_text=&#8221;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&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2.<\/strong> You can calculate total variable costs by multiplying the variable cost per unit by the total number of units made that month.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/total-variable-cost-formula-1.webp&#8221; alt=&#8221;Total variable cost \u2014 formula =B5*(B4+C4) typed into the Total Variable Costs row&#8221; title_text=&#8221;Formula =B5*(B4+C4) typed into the Total Variable Costs row&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3.<\/strong> The total variable cost for the month is $3,260.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/total-variable-cost-result-1.webp&#8221; alt=&#8221;Total variable cost \u2014 Total Variable Costs row showing $3,260.00&#8243; title_text=&#8221;Total Variable Costs row showing $3,260.00&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Step 2: calculate total fixed costs<\/h3>\n<p>Now, you just need to apply the fixed cost formula.<\/p>\n<p><strong>1.<\/strong> Subtract the total variable costs from the total costs.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/how-to-find-total-fixed-cost-formula.webp&#8221; alt=&#8221;How to find total fixed cost \u2014 formula =B3-B6 typed into the Total Fixed Costs row&#8221; title_text=&#8221;Formula =B3-B6 typed into the Total Fixed Costs row&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2.<\/strong> The total fixed cost for the month is $2,240.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/how-to-find-total-fixed-cost-result.webp&#8221; alt=&#8221;How to find total fixed cost \u2014 Total Fixed Costs row showing $2,240.00&#8243; title_text=&#8221;Total Fixed Costs row showing $2,240.00&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Step 3: calculate average fixed costs<\/h3>\n<p>Now that you know the total fixed cost, calculating the average fixed cost is easy.<\/p>\n<p><strong>1.<\/strong> Divide the amount for total fixed costs by the total number of units made of both products.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/average-fixed-cost-formula.webp&#8221; alt=&#8221;Average fixed cost \u2014 formula =B7\/(B4+C4) typed into the Average Fixed Costs row&#8221; title_text=&#8221;Formula =B7\/(B4+C4) typed into the Average Fixed Costs row&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2.<\/strong> That\u2019s it. The average fixed cost for Company X is $2.24.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/average-fixed-cost-result.webp&#8221; alt=&#8221;Average fixed cost \u2014 Average Fixed Costs row showing $2.24&#8243; title_text=&#8221;Average Fixed Costs row showing $2.24&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;conclusion&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Conclusion<\/h2>\n<p>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 <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/financial-statement-analysis\/\" rel=\"noreferrer noopener\" target=\"_blank\">financial analysis<\/a>, like <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/profitability-analysis\/\" rel=\"noreferrer noopener\" target=\"_blank\">profitability<\/a> and <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/break-even-point\/\">break-even<\/a> analyses. Sheetgo&#8217;s <a href=\"https:\/\/www.sheetgo.com\/virtual-employees\/finance\/\">AI virtual employee for finance<\/a> can pull cost data from files in different formats and keep these calculations up to date.<\/p>\n<p>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.<\/p>\n<p>Fixed costs also feed your budget and your income statement. To track them month by month, start from a <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-templates\/google-sheets-budget-template\/\">Google Sheets budget template<\/a> or our <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-templates\/profit-and-loss-statement-template\/\">profit and loss statement template<\/a>. Then check your plan against real spending with a <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/budget-vs-actual-how-to-find-and-analyze-variances\/\">budget vs actual analysis<\/a>.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Comment calculer les co\u00fbts fixes : soustrayez les co\u00fbts variables des co\u00fbts totaux ou additionnez chaque co\u00fbt fixe. Calculez ensuite le co\u00fbt fixe moyen dans Google Sheets.<\/p>","protected":false},"author":2,"featured_media":266798,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[36],"tags":[],"class_list":["post-266790","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-finance-processes"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/266790","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=266790"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/266790\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/266798"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=266790"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=266790"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=266790"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}