Cash Conversion Cycle (CCC) Defined

Cash Conversion Cycle (CCC) DefinedThis metric, which is also referred to as the cash cycle or the net operating cycle, looks at the time a business takes to recover its investment in inventory to eventually sell. The process starts from selling its goods, collecting on outstanding receivables or invoices, and satisfying its operating costs with the sale proceeds. It’s normally measured in days to determine the company’s financial health.

The less time necessary to complete the CCC, the healthier a company is financially because it means the business’ money spends less time tied up in inventory or collecting on outstanding inventory. It’s important to be mindful that different industries have different CCC time frames. Generally speaking, most calculations are done on either a quarterly (90 day) or an annual basis (365 days).

How to Calculate CCC

The formula is as follows:

(CCC) = Days Inventory Outstanding (DIO) + Days Sales Outstanding (DSO) − Days Payable Outstanding (DPO)

It can be broken down into three different stages:

Stage 1

Days Inventory Outstanding (DIO) looks at how many days the inventory takes to sell to customers. It’s calculated as follows:

DIO = (Average Inventory (AI) / COGS) x Time-Frame (In Days)

AI = 1/2 x (BI + FI)

BI = Beginning Inventory

FI = Final Inventory

It’s important to define COGS, taken from the Income Statement, which is Cost of Goods Sold or the costs personally connected to creation of goods or services (raw materials, labor or electricity). The lower the number, the faster a business is selling its goods.

Stage 2

Days Sales Outstanding (DSO) measures the time it takes the business to collect payment from all outstanding sales completed.

DSO = Average Accounts Receivable (AAR) / Daily Revenue

AAR = 1/2 x (SAR + FAR)

SAR = Starting AR

FAR = Final AR

Accounts Receivable are what companies record on their balance sheet to keep track of what customers owe for the goods delivered or services rendered. The lower the results, the better the company’s cash position is because they’re able to satisfy outstanding invoices.

Stage 3

Days Payable Outstanding (DPO) is the third and final stage that calculates how much businesses owe to their suppliers the business has sourced input materials from, within the time frame the suppliers’ invoices are due.  

DPO = Average Accounts Payable (AAP) / Daily COGS

Where:

AAP = 0.5 x (SAP + FAP)

SAP = Starting AP

FAP = Final AP

COGS = Cost of Goods Sold

There are different ways to interpret the DPO result. A low DPO means the business is taking care of its bills from suppliers. However, potential investors, internal managers, and supervisors can see if the business can either negotiate lengthier payment terms while still maintaining good terms or if the company negotiates early payment terms or invests the money on a short-term basis to earn more for the company before paying suppliers’ bills. A high DPO, after an investigation of a company’s financials, might show the company is taking longer than its peers to pay creditors.

While calculating the CCC is relatively straightforward, the more complex process is interpreting it correctly and using judgment for a business based on industry averages and how the numbers relate to current economic conditions.

How to Measure the Quality of Accounts Receivable

How to Measure the Quality of Accounts ReceivableAnalyzing a company’s Accounts Receivables is an effective way to measure its current cash flows and the likelihood of maintaining healthy cash flows. According to the U.S. Chamber of Commerce’s Small Business Index (Third Quarter 2024), 68 percent of small business owners reported being content with their third quarter cash flow performance. This illustrates the importance for small business owners to do everything possible to maintain healthy cash flows, including evaluating the quality of accounts receivables (A/R).

Defining Accounts Receivables

This account or line item on the balance sheet gives the business’ managers/owners and investors a measure on how much money a business expects to receive from selling goods or services. It’s an important metric because it’s a measure of what’s owed, but not yet collected from rendered services/goods.

Consideration for Uncollectable Accounts Receivables

While businesses hope to collect 100 percent of their A/Rs, businesses take a realistic view that not everyone will pay up. For whatever reason, A/Rs aren’t always collected and must be accounted for as uncollectable. Therefore, a contra account is setup to account for accounts receivables that turn into bad debt. This contra account is linked to the accounts receivable, an asset reported on the balance sheet, offsetting the accounts receivable balance. However, there are many metrics for companies to manage their health internally, and some of these metrics are discussed below.

Accounts Receivable-to-Sales Ratio

This is determined by taking a “snapshot” of the ratio or division of the accounts receivables divided by sales over a period of time. The resulting calculation is the percentage of a business’ unpaid sales. The higher the accounts receivable-to-sales ratio, the riskier the company’s financial health. It indicates a business has accounts receivables with a low likelihood of being collected. It’s calculated as follows:

AR to Sales = AR / Sales

Since it measures the mix of how much a business relies on cash versus credit, it can prompt an analyst to determine whether a company is able to operate on minimal cash with low fixed costs and limited outstanding debt. It can also prompt an analyst to determine if a company is subject to cyclical sales and is dependent on the business cycle and whether it’s the right time to invest in a company or hold off until a better entry point is established.

Accounts Receivable Turnover Ratio

This calculation determines how fast a business can convert its accounts receivables into cash. It calculates this over a discrete period, be it a month, quarter, year, etc. It’s calculated as the sales over a period divided by the average accounts receivables balance over the same period. It’s calculated as follows:

ARTR = Net Credit Sales / Average Accounts Receivable

Net Credit Sales = Sales on Credit – Sales Returns – Sales Allowances

Average Accounts Receivable = (Starting + Ending A/R Over a Fixed Time) / 2

The higher the ratio, the less friction businesses have in converting their accounts receivables into cash. One important consideration to keep in mind is that if total sales are used for this calculation, which some business do, the results don’t reflect the original formula because it doesn’t remove the sales on credit or sales allowances.

Days Sales Outstanding (DSO)

This metric reveals how fast (in average number of days) a company is able to turn its receivables into cash. It’s the average accounts receivables divided by net credit sales multiplied by 365. It’s calculated as follows:

DSO = (A/R / net credit sales) x 365 days

The lower the DSO, the better quality and the more efficient a company is in converting its accounts receivables into cash. The higher the DSO, and especially when it goes beyond 90 days, can represent two different financial measures. The first is that the business’ accounts receivables might not be collectable. The second is that the company might be able to make sales but with deteriorating earnings.

While there are many ways to analyze a company’s health, along with many ways to analyze the quality of existing and future accounts receivables, these are a few ways to evaluate a company’s present financial health and prospects for the future.

Sources

https://www.uschamber.com/sbindex/key-findings

Looking at the Expanded Accounting Equation

Whether it’s a private equity transaction or an institutional or retail investor, analyzing a company’s financial statements is an important part of fundamental analysis. One important but basic way to analyze whether a company is worth investing in is through the expanded accounting equation. The most straightforward equation to analyze a business’ balance sheet is:

Assets = Liabilities + Shareholder’s Equity

However, there are more detailed equations that analysts can employ to more closely examine a company’s financial situation. One way to look at it is by more comprehensive equations that break down net income and the transactions related to the equity owners (dividends, etc.).

This equation is a building block of accounting because it focuses on double-entry accounting – or that each occurrence impacts the bifurcated accounting equation – requiring the correct solution to always be in balance. This system is used for journal entries, regardless of the type of transaction. Looking at this equation in greater detail, here’s a more granular example:

Assets = Retained Earnings + Liabilities + Share Capital

Assets are the capital that give a business the ability to benefit from projected, increased productivity and hopefully increased gains. Whether it’s short-term (less than 12 months) or long-term (more than 12 months), it can take the form of real estate, cash, cash-equivalents, pre-paid expenses, accounts receivable, etc.

Liabilities are the amounts owed to lenders due to past agreements. This is related to the sum of liabilities, which is the total of current (up to 12 months) liabilities, plus long-term (more than 12 months) debt and related obligations. This takes the form of loans, accounts payable, owed taxes, etc. Shareholder’s equity is how much the company owners may assert ownership on after accounting for all liabilities.

Another way this equation can be expressed is as follows:

Assets = Liabilities + Contributed Capital + Beginning Retained Earnings + Revenue + Expenses + Dividends

Depending on the financial outcome of the company, dividends and expenses may be negative numbers.

To further explain, these variations on the equation help analysts break down shareholder’s equity. Revenues and expenses illustrate the delta in net income over discrete accounting/earning periods from sales and costs, respectively. Stockholder transactions are able to be accounted for by looking at what capital the original stockholders provided to the business and dividends, or earnings distributed to the company’s stockholders. Retained earnings are carried over from a prior accounting period to the present accounting period. Despite being elementary, the information is helpful for business managers and investors to develop a higher level of analysis.

When it comes to evaluating bankruptcy, it can help investors determine the likelihood of receiving compensation. When it comes to liabilities, should debts be due sooner or over longer periods of time, these debts always have priority. When it comes to liquidated assets, these are then used to satisfy shareholders’ equity, until funds are exhausted.  

While this is not a comprehensive look at how to analyze a company, it provides internal and external stakeholders with a way to build a strong financial analytical foundation.

Accounting Considerations for Capital Expenditures and Operating Expenses

When it comes to running a business, there are a lot of expenses incurred during operations. As of January 2024, New York University’s Stern School of Business had recorded nearly $1.2 trillion in capital expenditures by U.S. sectors. Considering this, there are two important concepts that are imperative to study for effective accounting treatment: capital expenditures (CapEx) and operating expenses (OpEx).

Defining CapEx and OpEx

Operating expenses (OpEx) are required outlays a company incurs on a more frequent basis to take care of day-to-day expenditures. Capital expenditures (CapEx), conversely, are larger purchases that businesses intend to use over the long term (at least 12 months). 

Different Considerations

OpEx

This type of asset is more of a short-term consideration. Expenses that fall under this category include utilities, wages, rent, taxes, selling, general and administrative expenses (SG&A). Unlike CapEx, businesses may benefit from tax deductions for these types of expenditures, as long as the business incurs the expense during the same tax year. These expenses reduce a company’s net income. However, they are not eligible for depreciation, which is how CapEx reduces a business’ net income. Since the entire expense is recognized right away, they’re reported on the income statement.

CapEx

This type of asset is intended to have a useful life of more than one year. Examples of these types of assets include warehouses, data centers, work trucks, etc. Many of these items fall under PPE or property, plant and equipment (PP&E) on the balance sheet. On the cash flow statement, it can be reported under the investing activities section.

Since these items are intended to last for a considerable time frame, such investments are planned to improve the profitability/capabilities of the business. Unlike OpEx, these expenditures are not tax deductible. It’s also important to understand this applies to intangible assets, such as patents, goodwill, etc.  

These types of assets are financed by either collateral or debt. Businesses also can issue bonds or get creative with their financing partners. Listed as a capitalized asset on the balance sheet, it’s depreciated over the asset’s useful life. However, it’s important to note that land is not depreciated.

Considerations between CapEx and OpEx

When it comes to CapEx, it’s important to know that some transactions can be paid for during the acquisition period; but acquisition costs also can occur over multiple accounting periods if it’s a long-term project, such as building a manufacturing plant or warehouse.

CapEx can determine the financial health of a company. If a company can reinvest in itself through patents, machinery, equipment, etc., along with maintaining or increasing its dividend payments to shareholders, then the company is on solid financial footing.

Depreciation for CapEx items is advantageous for companies because it provides a balance to the investment by lowering the company’s net income.   

There is another reason why both types of expenses exist. OpEx is a better choice if a business wants to be more agile and protect capital. CapEx would be used if a business is aiming to invest for long-term profitability and competitiveness.

Understanding how these two expenses are classified and accounted for are essential for businesses to navigate the accounting requirements and tax code effectively.

Sources

https://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/capex.html

Accounting Considerations for Business Insurance Coverages

Business Insurance CoveragesWith more than eight million small businesses in America, and more than $776 billion in net premiums issued by the insurance industry in 2022 for commercial policies (according to the Insurance Information Institute), business insurance is big business. Along with protecting businesses from a myriad of claims, insurance expenses also have to be accounted for correctly.

When it comes to defining prepaid insurance, it’s essentially remittances that businesses (and individuals) make to an insurance company in advance. Normally, the usual time-frame for an insurance policy is 12 months. The time-frame is important when it comes to distinguishing between current and long-term asset classification.

If a prepaid expense, such as an insurance premium payment, is not utilized within 12 months of the remittance, it’s considered a long-term asset. Since it’s very uncommon for it to happen, it’s not seen in many financial statements, but is an important consideration to ensure that prepaid expenses are accounted for correctly.  

Important Accounting Factors

Since the coverage takes place in the future, but the payment is recorded in a preceding period, the prepaid insurance expense is considered a current asset on the balance sheet. Then, when the coverage is effective, the accounting consideration changes to the expense side of the business’ balance sheet.  

Here is an example of how businesses account for insurance expenses.

Company X pays an insurance premium of $3,000 on May 15 for the following 12 months starting June 1. The May 15 payment is recorded on the same date with a debit of $3,000 attributed to prepaid insurance along with a credit of $3,000 to cash. As of May 31, nothing has changed insurance-wise or accounting-wise for this policy, so the full $3,000 will be reported as prepaid insurance. However, once coverage is effective things change.

When June 30 rolls around, an adjusting entry will show a debit insurance expense for $250 (one-twelfth of the annual policy premium), and the same amount will see a credit to prepaid insurance. The June 30 debit balance for prepaid insurance will now be $2,750, leaving the remaining 11 months of insurance coverage that hasn’t yet elapsed – or eleven-twelfths of the $3,000 insurance premium cost.

This process repeats for the remaining 11 months. Depending on the business’ needs, coverage changes, policy changes, etc., the amounts may change but the process will likely remain the same.

Additional Factors

A related term, insurance payable, is another type of debt that is connected with an insurance expense. Listed on a company’s balance sheet, it represents a business’ outstanding premiums. This shows how much a company needs to pay the insurance company, and ideally by the end of the current period to remain current, avoid overdue fees, or have the policy canceled by the insurance carrier.

Along with giving businesses peace of mind, having the right mix of commercial insurance requires the right type of accounting considerations for the business’ internal and external accounting and tax reasons.

Sources

https://www.iii.org/fact-statistic/facts-statistics-commercial-lines

How to Develop a Credit Policy

How to Develop a Credit PolicyA credit policy explains how a company will manage lines of credit for client accounts and what procedures to follow for severely outstanding invoices. It helps a business promote a robust foundation for its working capital level.

Defining a Credit Policy

Unlike personal credit scores, business scores range from 0 to 100; the scores from the FICO Small Business Scoring Service range from 0 to 300. According to the U.S. Small Business Administration, a first step to establishing business credit is to sign up for a Dun & Bradstreet (DUNS) number for each business location.

There are three components to a company’s credit policy. First, develop an effective system of following up on past-due invoices. Second, define when, how much, and the terms of credit extended to customers. Third, establish how the business underwrites a client’s creditworthiness and put guidelines in place to determine when to increase or decrease lines of credit for clients.

Memorializing a Company’s Credit Policy for External and Internal Uses

The reason why it’s so important to have a credit policy in writing is because 6 in 10 workers in large American business workplaces have found it challenging to get information from their fellow co-workers, according to a report by YouGov and Panopto. This same report found that processes that are not documented result in employees wasting an average of 5.3 hours/week either looking for the right person or waiting for a response.

Internally, it enables employees to understand the policy inside and out, creating more efficient workers. Externally, it sets clear ground rules and reduces the likelihood of mismatched customer expectations.

Considerations Before Writing Out a Credit Policy

Depending on the interest rate environment, clients may have a hard time obtaining financing. If they are able to obtain financing in a high-interest rate environment, it will come with a higher cost for the customer. The business may need to have more stringent policies.

Terms of Sale May Not be One-Size-Fits-All

It is imperative to explain how payment terms work before the company engages with clients. Be it net 15, 30, or 60 days, etc., consider how payment timeframes may incentivize pre-payment or early payment discounts. From there, determine when and how the company takes action to deem when payment is “delinquent,” and when it’s considered uncollectable and finally written off and sold to a debt collector.

Depending on the size/revenue/etc. of the company writing the policy, it is not ideal to treat smaller companies the same as larger/more established companies. For example, giving a company a net 45 term versus a net 30 or net 15 has two available outcomes.

Larger companies may be able to pay faster, but if they are given more time to pay, it can negatively impact the receiving company’s cash flow. And while giving small companies similar terms can create more goodwill, it also can cause a company to take it for granted. This presents the potential to never receive payment for outstanding invoices if the small business faces bankruptcy. Similarly, depending on the type of business and/or sector it’s in, risk should be rated appropriately.

Determine Roles/Responsibilities

Ensure each department and person within each department has a defined role within the credit approval process. The sales department can help craft payment terms to reduce late payments and maximize sales. The credit department can handle reviewing to extend, lower, and increase credit limits. The accounts receivable (AR) department should follow up on late invoices, collect payments, and record incoming payments.    

While there’s no boilerplate form for a business’ credit policy, having a policy in place will help a business navigate its internal and external needs more effectively.

Sources

eBook: Valuing Workplace Knowledge

https://www.sba.gov/business-guide/plan-your-business/establish-business-credit

How to Calculate Operating Return on Assets

How to Calculate Operating Return on AssetsDuring Q3 of 2023, businesses in the United States made approximately $3.3 trillion, according to Statista. This is right behind the third quarter of 2022, when corporations in America made even more money. These figures are the net income of the respective periods, according to the National Income and Product Accounts (NIPA).

With profits reaching all-time highs since Q3 of 2012, understanding how businesses can analyze their profitability ratios through the Operating Return on Assets (OROA) ratio is another helpful tool for number crunchers.

Defining OROA

This calculation helps business owners and analysts determine how well a business is run. It shows the percentage, per dollar, that a business makes in operating income relative to assets involved in day-to-day operations. Unlike the regular return-on-assets (ROA) calculation, the Operating Return on Assets ratio takes a more selective consideration of assets. The primary consideration for the assets in OROA’s calculation is to only consider assets employed in a business’ traditional operations.

The calculation is as follows: 

OROA = Earnings Before Interest and Taxes (EBIT) / Average Total Assets

Another way to look at EBIT for the calculation is to look at the Income Statement’s Operating Income. For the average total assets, it’s taking a look at the business’ Balance Sheet and determining the two most recent yearly Total Assets for the company, that are used in its normal business activities.

Putting the OROA into practice, it’s calculated as follows:

OROA = $85,000 (Operating Income) / ($425,000 + $450,000) (Total Assets) / 2 =

  = $85,000 / 437,500

   = 0.1942 or 19.42 percent

This means that for every dollar of operating assets, the company has produced $0.1942 in operating income.

There are two important distinctions between OROA and the traditional ROA assets calculation. When it comes to income, OROA uses EBIT or Operating Income, but ROA uses net income as the numerator. With assets considered, OROA uses assets used for regular business operations, while ROA accounts for total assets in the calculation.

Interpreting Operating Return on Assets

One important way to use the result includes looking at a company’s OROA on a trended basis to determine if a business is declining, stagnating, or increasing its profitability.

Especially for investors, it’s important to contrast the OROA of the company at hand against rival businesses within the company’s same industry. When it comes to comparisons, the higher the OROA is, the better the result.

Another important consideration for investors is that OROA provides an accurate assessment of a business’ core operations. Since assets analyzed are for a business’ core profits or services, if a business reports profits from selling a division or it reports a one-time profit surge from investments, its core profitability is less likely to be skewed during investment analysis.

When used in conjunction with other accounting and financial metrics, businesses can continually measure and adjust their operations to increase efficiencies to increase their return on operating assets.

Defining Burn Rate, Gross Burn and Net Burn

What is Burn Rate, Defining Burn Rate, Gross Burn and Net BurnWhen it comes to any business, but especially for a start-up, it’s essential to determine how long a company can survive before it must declare bankruptcy and/or close its doors. The biggest metric, especially for a start-up, is to determine how much money a company has to keep its lights on.

The term “burn rate” is defined as how much money a company spends monthly to maintain its operations. It is essential for a company to know how long it can operate before it begins to generate income and hopefully becomes cash flow positive.

It is important to look at two differences between the two sub-meanings of this term: the first is “gross burn” and the other is “net burn.” When it comes to “gross burn,” we are talking about how much a business uses in monthly operating costs. The following formula shows a business how long they have in months to operate.

For example, if a business has $2.5 million available for overhead and it spends $200,000 in monthly overhead costs, it would last 12.5 months. Expressed as a formula:

Available financial resources ($2,500,000)/monthly overhead($200,000) = 12.5 (months)

This assumes the company makes no revenue, which will be accounted for in the next example. However, this is where “net burn” comes into consideration. Net burn looks at how much money a business loses every month, but the difference with this calculation is that it looks at if it can be lowered by any incoming revenue.

If a company spends $10,000 on rent/office space, $20,000 on IT expenses, and $25,000 on employee wages, the gross burn rate would be: $55,000. However, if the company is generating sales at $17,500 per month, for example, and the cost of goods sold (COGS) is $5,000, the following calculation would determine its “net burn rate:”

Net Burn Rate = [Monthly Revenue – Cost of Goods Sold (COGS)] – Gross Burn Rate

Net Burn Rate = ($17,500 – $5,000) – $55,000

Net Burn Rate = (12,500) – 55,000 = -$42,500 Gross Burn Rate

The difference between the net burn rate and the gross burn rate may seem obvious or intuitive, but depending on how much money the start-up has available, and factoring in how much the revenue brings in and offsets the COGS, it can make a stark difference for the business’ prospects.

Once a business has determined what its “gross burn rate” and/or “net burn rate” is, the next step is to look at how to reduce costs and/or increase revenue to keep working toward positive cash flow. 

Two considerations for the company include what the business can do and what it must do to make more revenue and increase profit margins. For example, companies could look at the cost-benefit analysis of incorporating AI to see if it would have an overall positive impact on labor costs. They also could look at how to create effective marketing campaigns that cost less (using backlinks instead of paid search engine marketing, for example).

Another consideration is that if the company has enough time and is able to re-strategize its model, this can have a material impact on the business receiving a cash injection from outside investors.  

Determining these timeframes and figures are one way a company can reduce costs and/or pivot to more profitable products and/or services. These two calculations can provide avenues to re-invigorate a business in hopes of providing a path to profitability.

Actions Lottery Winners Should Consider

What to do if you win a lotteryWe all have those days when we dream of striking it rich with a winning lottery ticket. Never having to work again while living a life of luxury. While your chance of finding a four-leaf clover is higher than winning the lottery, we can still dream, right? And while we are dreaming, let’s talk about the best ways to deal with landing such a large sum of cash. And since lottery winners have a limited time to claim their prize, it’s important to take prudent steps when managing the money.

How Much Do Winners Actually Take Home?

Let’s take a look at actual prize amounts from recent winnings. The October 2023 Powerball jackpot of $1.2 billion translated to a cash value of $551.7 million. Depending on what the winner decides – either taking the lump sum or opting for a multi-decade annuity – they have a serious decision to make.

It’s important to consider inflation factors if choosing the multi-decade annuity option. For example, when it comes to 30 payments taken over 29 years, the first consideration is to determine if there’s a 5 percent increase in the amount for each subsequent year. However, it’s important to keep inflation and the value of money going forward in mind.

For example, between March 2021 and March 2023, the average monthly inflation rate was 5 percent or higher, according to Statista Research Department. It peaked during June 2022 at 9.1 percent on a monthly basis. If the lump sum was taken before inflation increased during the post-COVID-19 reopening, or the annuity was increased by 5 percent, lottery winners without a plan to preserve and increase their earnings would have seen their money’s purchasing power decline.

Another thing to consider is how to legally navigate the tax code. For example, when it comes to federal taxes, 24 percent is automatically withheld. According to the 2024 Federal Tax Code, large winnings will put the winner in the 37 percent tax bracket. If the winner is single or married, the 37 percent bracket kicks in at $578,125 and $693,750, respectively. Additionally, winners also are required to determine compliance with state, county, city, etc. taxes. State taxes can vary greatly; looking at you: Pennsylvania at 3.07 percent, and New York at 10.9 percent.

When it comes to being generous through philanthropy, winners can work with their legal and financial professionals to determine how to offset taxes. This can take the form of direct donations, creating a donor advisor fund (DAF) to get the tax benefit immediately, especially if the lump sum is taken, but also if an annuity is taken. With 2023’s standard deduction threshold of $13,850 (single) and $27,700 (married couples), winners might consider how to make charitable donations part of a tax reduction plan.

Another question to ask is whether establishing a trust would be helpful when sorting out one’s distribution of assets. If a winner dies intestate (without a will), the state of that person’s residence will determine who gets your money – regardless of who you may have wanted to receive it.

Similarly, setting up a trust may be beneficial for both claiming the lottery winning anonymously, and it can help determine how to give money to family members. A trust can be set up for a family member or a pet’s care and can be conditional on releasing the funds when the individual reaches a certain age.

While these steps are not comprehensive, and each winner will have unique circumstances, there are many legal and financial considerations to think about immediately upon winning and before claiming a jackpot.

Sources

https://www.irs.gov/credits-and-deductions-for-individuals

https://www.statista.com/statistics/273418/unadjusted-monthly-inflation-rate-in-the-us/

Understanding How Variances Vary

how to calculate VariancesVariance analysis is found by determining the difference between what was budgeted and what actually occurred. Additionally, when variances are added together, we get a better picture of how well a company is measuring its performance against expected metrics. It’s also important to be mindful that each metric is measured to determine what the actual cost is versus the industry’s standard cost.

Whether it’s materials, labor, electricity, or another metric, if the actual cost is lower than the standard cost for the same quantity of materials, it would be a favorable price variance. However, if the number of materials was more than the standard quantity, it would be considered an unfavorable variance. Examining variance allows us to analyze the price and quantity of the variable being analyzed. Always keep in mind that unusual or significant variances should be investigated to see why such anomalies exist.

It’s important to distinguish between variances and the types of inputs. When it comes to materials, labor, and similar variable overhead, variances to be analyzed are for price and quantity/efficiency. When it comes to fixed overhead, analysis looks at variances in budget and volume.

One way to conduct variance analysis is through the Column Method. The following example illustrates this:

A business produces widgets. The following assumptions are made:

  • 6,000 widgets are produced in a month
  • Direct labor hours are used as the basis to allocate overhead costs to products
  • Denominator level of activity is 8,060 hours, resulting in $48,360 in fixed overhead expenses budgeted.

Other cost assumptions include:

Direct Costs

Labor: 2.6 hours/widget @ $14 per hour

Materials: 10 pieces/widget @ $1/widget

Overhead

Variable: 2.6 hours/widget @ $8/hour

Fixed: 1.3 hours /widget @ $12/hour

However, the business saw the following costs for the month’s production:

Variable overhead manufacturing costs: $34,000

Fixed overhead manufacturing costs: $50,000

Both of the following are Direct Costs:

Material: 50,000 items bought @ $0.96/widget

Labor: 8,000 hours totaling $128,000

Materials Variance

Real Quantity x Real Price = 50,000 pieces x $0.96 per widget = $48,000

Real Quantity x Industry Price = 50,000 pieces x $1 per widget = $50,000

Standard Quantity x Industry Price = 36,000 pieces x $1 per widget = $36,000

Price Variance = $50,000 – $48,000 = $2,000

Quantity Variance = $50,000 – $36,000 = $14,000

When we find the difference between these two amounts, there’s an unfavorable variance of $12,000. Additionally, it’s worth looking at why there were 50,000 pieces used versus the standardized 36,000 pieces. It could be due to defective materials, problematic machinery, etc.

Labor Variance

Real Hours x Real Rate = 8,000 hours x $16 per hour = $128,000

Real Hours x Industry Rate = 8,000 x $14 per hour = $112,000

Standard Hours x Industry Rate = 7,800 x $14 hour = $109,200

Rate Variance = $112,000 – $128,000 = -$16,000

Efficiency Variance = $109,200 – $112,000 = -$2,800

Based on this calculation, there’s a total unfavorable variance of -$18,800. Management should look at why labor costs are higher than the standard and why production took more supplies than the industry standard.

While this is not all-encompassing, it does show the importance of understanding the nuances of calculating variances and how it’s essential to understanding a business’ (in)efficiency.