How to Find COGS Variable and Fixed Cost?

I am very frustrated. I am taking one summer class on Financial Management and our professor is making us do a 2-statement forecast (apparently, basic cash flow projection is too hard, so balance sheet is not balanced at all, lol).

I was taught by WallStreetPrep and few banking models that COGS is 100% variable cost. If Revenue goes up by 10%, COGS goes up by 10% or somewhat similar.

My professor says I am wrong. He said COGS includes things like CEO's salaries and others that are constant (aren't they in SG&A?). He said COGS has a variable part, that is a certain percentage of revenue (for example, 60% of revenue is variable part of COGS). COGS also has a fixed part: a percentage of previous year's COGS.

What is Variable and Fixed Cost of Goods Sold?

While the vast majority of COGS expenses are variable costs, in some cases (especially for companies that are manufacturers) there is a fixed cost associated with the production of goods such as the utilities at the manufacturing plant. The cost of keeping the lights on and running AC, will be the same whether you manufacture 100 gadgets or 10,000 gadgets (unless overtime is factored in). It is important note that there is a difference between the cost of lighting your office building where management works (which would fall under SG&A expenses) and the cost of lighting your plant where you produce the goods (which would fall under COGS).

Therefore, variable costs will represent the majority of cost of goods sold and there will be a small portion of fixed costs. However, when modeling - due to the small portion that this will make up, it is safe to model as if COGS is a variable percentage.

COGS Formula

At a simple level, the cost of goods sold is the beginning inventory for a period + the purchase or manufacturing of goods - the ending total of goods. This will be the COGS sold and represents the cost to purchase or create the goods that you sold during the period. You can see a video about this below.

Read More About COGS on WSO

Preparing for Investment Banking Interviews?

The WSO investment banking interview course is designed by countless professionals with real world experience, tailored to people aspiring to break into the industry. This guide will help you learn how to answer these questions and many, many more.

Investment Banking Interview Course Here

 

Let me take a shot. I am still new at this, so I may not be 100% right.

COGS does not include the CEO's salary (that is SG&A). It does, however, include some labor costs such as the worker who produces the good.

COGS = Variable COGS + Fixed COGS. There are fixed COGS such as repairs to M&E. They should be small compared to the variable COGS.

Also, if revenue goes up by 10%, it does not necessarily mean that COGS goes up 10%. This is because higher revenue could be due to higher prices, which does not affect the cost of making the goods. Similarly, revenue could be from licensing/royalty fees, which again do not cause a proportional increase in COGS.

Hope that helps, anyone who disagrees feel free to correct me.

 
Best Response

Though I am not an expert on accounting, I assume COGS to be variable.

First of all, "cost of goods sold" indicates already that the costs are directly related to output. Although, as already mentioned, COGS do no necessarily have to increase with sales.

COGS includes all kinds of costs that can be directly allocated to a product or service, e.g. labor costs, utility costs for certain production processes, material etc. Fixed costs which are not direclty allocated are mostly depreciated (like plants) or impaired (like goodwill).

So I may be wrong on this point and open to correction, but this would be my first thought on the issue.

I have never come across the formula, but one reason your profs says there is a fixed variable in COGS might be some time delay. For instance, although labor costs are clearly variable, they are obviously fixed in the short run. This may be one reasons why your prof includes previous year's cogs in his formula. (obviously I am only guessing here)

 

how is impairment of goodwill a fixed charge? Doesn't mngemnt test goodwill annually for impairment and obviously its not a systematically depreciated item?

KICKIN ASS AND TAKING NAMES
 
BudFox24:
how is impairment of goodwill a fixed charge? Doesn't mngemnt test goodwill annually for impairment and obviously its not a systematically depreciated item?

Yeah, your are right, it is tested annually and not depreciated systematically. (it used to be some years ago). So bad example from my part. Sorry for that.

 

Generally speaking, COGS will always have a fixed and variable component. For example, manufacturing businesses generally include direct costs (e.g. materials and direct labor) and an allocation for overhead (e.g. utilities, supervisor salaries, maintenance, operating lease payments on equipment, etc.) in the COGS line item. Using percentages to forecast materials provides a good proxy, but supervisor salaries, operating lease payments and utilities are fixed and should be forecast accordingly.

Hope this helps.

 
jdm05520:
Generally speaking, COGS will always have a fixed and variable component. For example, manufacturing businesses generally include direct costs (e.g. materials and direct labor) and an allocation for overhead (e.g. utilities, supervisor salaries, maintenance, operating lease payments on equipment, etc.) in the COGS line item. Using percentages to forecast materials provides a good proxy, but supervisor salaries, operating lease payments and utilities are fixed and should be forecast accordingly.

Hope this helps.

If you're talking about a factory, then the factory labor, foreman, electricity, etc... should be allocated down to COGS... but your executive offices, marketing, etc... are definitively SG&A.

 

What an absolutely ridiculous way to project COGS. Do yourself a favor, make an estimate on gross margin based on intelligent insight or some equity research. His method of calculating COGS is incredibly stupid. Arbitrarily picking %A and %B can end up yielding you incoherent operating results. Tell him he is an idiot and by him a book by damodoran.

 

It all depends on the company. We're evaluating a company right now that claims they have very few variable COGs. After diligencing their numbers, it turns out quite a few of the COGs were fixed and a number of the SG&A expenses were variable.

~~~~~~~~~~~ CompBanker

CompBanker’s Career Guidance Services: https://www.rossettiadvisors.com/
 
CompBanker:
It all depends on the company. We're evaluating a company right now that claims they have very few variable COGs. After diligencing their numbers, it turns out quite a few of the COGs were fixed and a number of the SG&A expenses were variable.

~~~~~~~~~~~ CompBanker

Is this a trend that is more prevalent in certain industries/companies? And how does this impact valuation? Would I be correct in assuming it's not preferable?

 

The Sales Method of projecting future financial statements is based on the assumption that Sales is the main driver. I am sure if you run a regression or crystal ball analysis like one of professors used to obsess about you will see there is fixed portion for some companies in COGS.

I bet your professor comes from a Credit Risk or Management Accounting background.

 

Perferendis nesciunt voluptatem incidunt perspiciatis dolor praesentium quis. Dolores omnis veniam repudiandae soluta dolores nemo consectetur harum. Mollitia molestiae cumque exercitationem nostrum repudiandae.

Itaque id dolore illo doloribus. Ab pariatur vel voluptates fugiat ea vero expedita. Qui sunt natus fugiat accusamus pariatur.

Et impedit molestiae molestiae ad commodi. Consectetur a qui velit esse et quod repellat. Debitis placeat quasi recusandae nam.

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (87) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
kanon's picture
kanon
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
numi's picture
numi
98.8
10
Kenny_Powers_CFA's picture
Kenny_Powers_CFA
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”