Friday, September 11, 2009

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.

No comments:

Post a Comment