The longer a person is out of school, the easier it is to forget how to use percents and other basic business math formulas. Computer programs, cash registers and automated point-of-sale systems can easily complete the percentage calculations; however there will be moments when retailers will need to process the numbers manually.
There are three parts to a percentage problem: rate, base and percentage amount. The rate is the percent, the base is the total and the percentage amount is a fraction of the amount.
Calculating Percentage Amount
To find the percentage amount, change the rate to a decimal and multiply by the base.
Percentage Amount = Rate x Base
Example #1:Find 25% of $150Percentage Amount = .25 x 150Percentage Amount = $37.50Example #2:If your weekly salary is taxed 30%, how much is deducted if you make $295 a week?Percentage Amount = .30 x 295Percentage Amount = $88.50
Calculating Rate
To find the rate, divide the base into the percentage amount. Because our rate is a percent, move the decimal two places to the right and add a percent sign.
Rate = Percentage Amount ÷ Base
Example #1:15 is what percent of 75Rate = 15 ÷ 75Rate = .20Rate = 20%Example #2:
If you received a shipment from a vendor consisting of 250 widgets, but 65 were broken during transport, what percent are damaged?Rate = 65 ÷ 250Rate = .26 or 26%
Calculating Base
To find the base, divide the rate into the percentage amount. Again, because rate is a percent, move the decimal two places to the right and add a percent sign.
Base = Percentage Amount ÷ Rate
Example #1:$150 is 45% of what amount?Base = 150 ÷ 45%Base = $333.33Example #2:On Christmas Eve, your store sells a total of $2500. It was 85% of the total sales for the year. What are your store's sales?Base = 2500 ÷ 85%Base = $2941.17
Calculating Percentage Increase/Decrease
To find the percent up or down, first find the difference between the two amounts. Then divide that number by the first of the two amounts. Finally, convert the fraction to a percent by moving the decimal two places to the right and adding a percent sign.
% Increase/Decrease = Difference Between Two Figures ÷ Previous Figure % Increase/Decrease = (This Year - Last Year) ÷ Last Year% Increase/Decrease = (Planned $ - Actual $) ÷ Planned $
Example #1:If Easter sales were $5200 this year and last year they were only $3400, what was the percent increase?% Increase = 5200 - 3400 ÷ 3400% Increase = 52.9%Example #2:If your store's sales for February were planned at $22,500 and actual sales were $18,000, what was the percent reduction?% Decrease = 22500 - 18000 ÷ 22500% Decrease = .20 or 20%
Quick Ratio
Quick Ratio = Current Assets - Inventory ÷ Current Liabilities
Definition: A measurement of how well a business can meet its short-term financial obligations without selling any inventory.
The purpose of this calculation is to show how easily a company could be liquidated, and therefore help financial institutions decide upon how credit worthy the company is.
A ratio greater than 1:1 is good and indicates the business can pay their current liabilities without being dependent on the sale of inventory.
Current Assets - Inventories ÷ Total Current Liabilities
Also Known As: Quick Ratio, Liquid Ratio
Examples: After examining our low acid-test ratio, our store is considering how we can liquidate some inventory to generate cash.
Reductions
Reductions = Markdowns + Employee Discounts + Customer Discounts + Stock Shortages
Sales per Square Foot
Sales per Square Foot = Total Net Sales ÷ Square Feet of Selling Space
Your shop has customers steadily coming through the doors, employees are busy and there is the frequent 'cha-ching' of the cash register, but how well is your business really doing?
One simple way to know if business is good, is to compare this year's same-store sales data to last year's revenue. What if your store has been open less than a year?
It is critical for the success of your business to constantly work towards improving not only the efficiency of employees, but the productivity of the store's selling space and inventory as well. This can be achieved by using various retail math formulas and calculations based on sales.
Performance of Selling Space
Sales per Square Foot
The sales per square foot data is most commonly used for planning inventory purchases. It can also roughly calculate return on investment and it is used to determine rent on a retail location. When measuring sales per square foot, keep in mind that selling space does not include the stock room or any area where products are not displayed.
Total Net Sales ÷ Square Feet of Selling Space = Sales per Square Foot of Selling Space
Sales per Linear Foot of Shelf Space
A retail store with wall units and other shelf space may want to use sales per linear foot of shelf space to determine a product or product category's allotment of space.
Total Net Sales ÷ Linear Feet of Shelving = Sales per Linear Foot
Sales by Department or Product Category
Retailers selling various categories of products will find the sales by department tool useful in comparing product categories within a store. For example, a woman's clothing store can see how the sales of the lingerie department compared with the rest of the store's sales.
Category's Total Net Sales ÷ Store's Total Net Sales = Category's % of Total Store Sales
Measuring Productivity of Staff
Sales per Transaction
Also known as sales per customer, the sales per transaction number tells a retailer what is the average transaction in dollars. A store dependant on its sales clerks to make a sale will use this formula in measuring the productivity of staff.
Gross Sales ÷ Number of Transactions = Sales per Transaction
Sales per Employee
When factoring sales per employee, retailers need to take into consideration whether the store has full time or part time workers. Convert the hours worked by part-time employees during the period to an equivalent number of full-time workers. This form of measuring productivity is an excellent tool in determining the amount of sales a business needs to bring in when increasing staffing levels.
Net Sales ÷ Number of Employees = Sales per Employee
These are just a few of the ways to measure a retail store's performance. As retailers track these numbers month after month and year after year, it becomes easier to understand where the sales are generated, by which employees and how the store's merchandising can maximize sales growth.
Sell-Through Rate
Sell-Through % = Units Sold ÷ Units Received
Definition: A calculation, commonly represented as a percentage, comparing the amount of inventory a retailer receives from a manufacturer or supplier against what is actually sold to the consumer.
Manufacturers often create promotions or special advertising in an effort to increase the sell-through rate of its products at the retail level.
Also Known As: STR, Sell through Analysis
Alternate Spellings: Sell-Thru
Examples: Despite the television ad campaign touting all of the benefits of Acme's widgets, our store had a dismal 2% sell-through rate.
Friday, September 11, 2009
Open to Buy
OTB (retail) = Planned Sales + Planned Markdowns + Planned End of Month Inventory - Planned Beginning of Month Inventory
Good inventory control is critical to ensuring an adequate level of stock is on hand for the amount of sales being generated. Having too much inventory (or the wrong type) during certain periods can slow your cash flow and reduce profits with too many markdowns. On the other hand, if you under buy and miss sales opportunities then you are not making your potential profit. A retailer can be sure to stock the right amount of the right products at the right time by using an Open-To-Buy (OTB) plan.
Open-To-Buy can be calculated in either units or dollars. OTB is essentially the difference between how much inventory is needed and how much is actually available. This includes inventory on hand, in transit and any outstanding orders.
In order to take advantage of special buys or to add new products, some of the OTB dollars should be held back. This also allows the retailer to react to fast-selling items and quickly restock shelves.
Consider maintaining an OTB plan for your business as a whole, but also plan for each category of merchandise you stock. The plan can be maintained on paper, in a spreadsheet or by purchasing one of the several retail software packages available that contain Open-To-Buy programs.
The Open-To-Buy Formula
Planned Sales+ Planned Markdowns+ Planned End of Month Inventory- Planned Beginning of Month Inventory----------------------------------------= Open-To-Buy (retail)
For example, a retailer has an inventory level of $150,000 on July 1st and planned $152,000 End of Month inventory for July 31st. The planned sales for the store are $48,000 with $750 in planned markdowns. Therefore, the retailer has $50,750 Open-To-Buy at retail.
Note: Multiply that number by the initial markup to reach the OTB at cost. If our markup is 40%, then our Open-To-Buy at cost is $20,300.
Before placing your Open-to-Buy plan into operation, ask yourself if each number is realistic. Does it make sense for the way you do business? Keep in mind that many of the figures on your inventory plan are only guidelines. A good rule of thumb is if your actual ending inventory is within five percent of your plan, you are doing very well.
OTB (retail) = Planned Sales + Planned Markdowns + Planned End of Month Inventory - Planned Beginning of Month Inventory
Good inventory control is critical to ensuring an adequate level of stock is on hand for the amount of sales being generated. Having too much inventory (or the wrong type) during certain periods can slow your cash flow and reduce profits with too many markdowns. On the other hand, if you under buy and miss sales opportunities then you are not making your potential profit. A retailer can be sure to stock the right amount of the right products at the right time by using an Open-To-Buy (OTB) plan.
Open-To-Buy can be calculated in either units or dollars. OTB is essentially the difference between how much inventory is needed and how much is actually available. This includes inventory on hand, in transit and any outstanding orders.
In order to take advantage of special buys or to add new products, some of the OTB dollars should be held back. This also allows the retailer to react to fast-selling items and quickly restock shelves.
Consider maintaining an OTB plan for your business as a whole, but also plan for each category of merchandise you stock. The plan can be maintained on paper, in a spreadsheet or by purchasing one of the several retail software packages available that contain Open-To-Buy programs.
The Open-To-Buy Formula
Planned Sales+ Planned Markdowns+ Planned End of Month Inventory- Planned Beginning of Month Inventory----------------------------------------= Open-To-Buy (retail)
For example, a retailer has an inventory level of $150,000 on July 1st and planned $152,000 End of Month inventory for July 31st. The planned sales for the store are $48,000 with $750 in planned markdowns. Therefore, the retailer has $50,750 Open-To-Buy at retail.
Note: Multiply that number by the initial markup to reach the OTB at cost. If our markup is 40%, then our Open-To-Buy at cost is $20,300.
Before placing your Open-to-Buy plan into operation, ask yourself if each number is realistic. Does it make sense for the way you do business? Keep in mind that many of the figures on your inventory plan are only guidelines. A good rule of thumb is if your actual ending inventory is within five percent of your plan, you are doing very well.
Friday, September 4, 2009
Formulas & Definitions.
Break-Even Analysis
Break-Even ($) = Fixed Costs ÷ Gross Margin Percentage
Definition:
The point in business where the sales equal the expenses. There is no profit and no loss.
Formula:Break-Even Point ($) = Fixed Costs ÷ Gross Margin Percentage
Also Known As: Breakeven Analysis
Examples: Our retail store buys widgets for $15 each, marks them up and sells them for $30. Our monthly expenses (fixed costs) are $10,000. This means our breakeven point would be $20,000 or 667 units. $10,000 ÷ (15/30) = $20,000 $20,000 ÷ $30 = 667
Contribution Margin
Contribution Margin = Total Sales - Variable Costs
Definition:
The difference between total sales revenue and total variable costs. The term is can be applied to a product or product lines and is generally expressed as a percentage.
In retail, the Gross Margin Percent is recognized as the Contribution Margin Percent. The contribution margin information can be used to add or remove products and product lines or to make informed pricing decisions.
Also Known As: CM
Examples: After subtracting our total variable costs from our sales, we found our annual contribution margin was 42%. In other words, for each dollar of sales, 42 cents was left to contribute toward direct costs and profit.
Cost of Goods Sold
COGS = Beginning Inventory + Purchases - Ending Inventory
Definition: The price paid for the product, plus any additional costs necessary to get the merchandise into inventory and ready for sale, including shipping and handling.
Also Known As: COGS, cost of sales
Examples: The formula for calculating Cost of Goods Sold is Beginning Inventory + Purchases - Ending Inventory. The cost of goods sold is subtracted from sales to determine the gross profit on an income statement.
Gross Margin
Gross Margin = Total Sales - Cost of Goods
Definition: The difference between what an item cost and for what it sells.
Also Known As: Gross Percentage of Profit, Margin
Examples: Total Sales - Cost of Goods Sold = Gross Margin
Gross Margin Return on Investment
GMROI = Gross Margin $ ÷ Average Inventory Cost
Initial Markup
Initial Markup % = (Expenses + Reductions + Profit) ÷ (Net Sales + Reductions)
Inventory Turnover (Stock Turn)
Turnover = Net Sales ÷ Average Retail Stock
Maintained Markup
MM $ = (Original Retail - Reductions) - Cost of Goods SoldMM % = Maintained Markup $ ÷ Net Sales Amount
Margin %
Margin % = (Retail Price - Cost) ÷ Retail Price
Definition: The amount of gross profit made when an item is sold.
Examples: A widget bought for $2, which sells for $3, has a margin of 33.3%. Margin % = ($ Retail - $ Cost) divided by $ Retail
Markup
Markup $ = Retail Price - CostMarkup % = Markup Amount ÷ Retail Price
Definition: A percentage added to the cost to get the retail selling price.
Also Known As: markon, markup
Examples: A widget bought for $5 and sells for $10 has a mark-up of 100%. (Add $5 to the $5 cost to get the price.) A widget bought for $2, which sells for $3, has a mark-up of 50%, (Add $1 to the $2 cost to get the price.)
Net Sales Net Sales = Gross Sales - Returns and Allowances
Break-Even ($) = Fixed Costs ÷ Gross Margin Percentage
Definition:
The point in business where the sales equal the expenses. There is no profit and no loss.
Formula:Break-Even Point ($) = Fixed Costs ÷ Gross Margin Percentage
Also Known As: Breakeven Analysis
Examples: Our retail store buys widgets for $15 each, marks them up and sells them for $30. Our monthly expenses (fixed costs) are $10,000. This means our breakeven point would be $20,000 or 667 units. $10,000 ÷ (15/30) = $20,000 $20,000 ÷ $30 = 667
Contribution Margin
Contribution Margin = Total Sales - Variable Costs
Definition:
The difference between total sales revenue and total variable costs. The term is can be applied to a product or product lines and is generally expressed as a percentage.
In retail, the Gross Margin Percent is recognized as the Contribution Margin Percent. The contribution margin information can be used to add or remove products and product lines or to make informed pricing decisions.
Also Known As: CM
Examples: After subtracting our total variable costs from our sales, we found our annual contribution margin was 42%. In other words, for each dollar of sales, 42 cents was left to contribute toward direct costs and profit.
Cost of Goods Sold
COGS = Beginning Inventory + Purchases - Ending Inventory
Definition: The price paid for the product, plus any additional costs necessary to get the merchandise into inventory and ready for sale, including shipping and handling.
Also Known As: COGS, cost of sales
Examples: The formula for calculating Cost of Goods Sold is Beginning Inventory + Purchases - Ending Inventory. The cost of goods sold is subtracted from sales to determine the gross profit on an income statement.
Gross Margin
Gross Margin = Total Sales - Cost of Goods
Definition: The difference between what an item cost and for what it sells.
Also Known As: Gross Percentage of Profit, Margin
Examples: Total Sales - Cost of Goods Sold = Gross Margin
Gross Margin Return on Investment
GMROI = Gross Margin $ ÷ Average Inventory Cost
Initial Markup
Initial Markup % = (Expenses + Reductions + Profit) ÷ (Net Sales + Reductions)
Inventory Turnover (Stock Turn)
Turnover = Net Sales ÷ Average Retail Stock
Maintained Markup
MM $ = (Original Retail - Reductions) - Cost of Goods SoldMM % = Maintained Markup $ ÷ Net Sales Amount
Margin %
Margin % = (Retail Price - Cost) ÷ Retail Price
Definition: The amount of gross profit made when an item is sold.
Examples: A widget bought for $2, which sells for $3, has a margin of 33.3%. Margin % = ($ Retail - $ Cost) divided by $ Retail
Markup
Markup $ = Retail Price - CostMarkup % = Markup Amount ÷ Retail Price
Definition: A percentage added to the cost to get the retail selling price.
Also Known As: markon, markup
Examples: A widget bought for $5 and sells for $10 has a mark-up of 100%. (Add $5 to the $5 cost to get the price.) A widget bought for $2, which sells for $3, has a mark-up of 50%, (Add $1 to the $2 cost to get the price.)
Net Sales Net Sales = Gross Sales - Returns and Allowances
Subscribe to:
Posts (Atom)
