BOOK US

With over 25 years of frontline experience Tom Shay is America's leading small business management expert. He's a "Must Have" for your next event.

Planned markdown calculator

Too many small businesses use a very simple plan in determining the margins of their merchandise. They simply look at the cost and then apply a multiplier factor to the cost to determine the selling price.

As the merchandise ages, they begin to randomly take markdowns in an effort to get rid of the merchandise. If the buyer were to calculate the maintained gross margin when all of the merchandise has been sold, they would likely be surprised at what their margin was. The surprise may be how high of a margin they maintained as well as it could be a surprise as to how low it was; but either way, in most cases they are surprised.

This calculator is created to resolve that. Sophisticated buyers do not settle for looking at their initial margin; they have a plan as to when, with how many on hand, and by how much to mark merchandise down. This is exactly how this calculator works. It allows you to plan for four markdowns over the season of an item. By determining how long the merchandise will be sold at full price, you will then decide when, how many, and by how much the merchandise will be discounted.

Proceed with this calculation for up to four periods, and this calculator will tell you what your maintained margin will be for the entire season of the product. This is a much better way than just guessing as you go through the season, and it is likely that you will end the season with less of the inventory on hand, and with fewer markdowns.

Planned markdown calculator from Profits Plus
       
Yellow indicates squares where info is entered      
       
Inventory Purchase Amount    
Inventory Balance Remaining @ End of Period 1    
Inventory Balance Remaining @ End of Period 2    
Inventory Balance Remaining @ End of Period 3    
Inventory Balance Remaining @ End of Period 4    
       
       
Inventory Sold During Period 1    
Inventory Sold During Period 2    
Inventory Sold During Period 3    
Inventory Sold During Period 4    
       
       
Gross Margin % (original)    
       
       
Discount (% of Retail) Offered in Period 1    
Discount (% of Retail) Offered in Period 2    
Discount (% of Retail) Offered in Period 3    
Discount (% of Retail) Offered in Period 4    
       
       
Gross Margin % (Net of Discount) in Period 1    
Gross Margin % (Net of Discount) in Period 2    
Gross Margin % (Net of Discount) in Period 3    
Gross Margin % (Net of Discount) in Period 4    
       
       
Sales in Period 1 (before discount)    
Sales in Period 2 (before discount)    
Sales in Period 3 (before discount)    
Sales in Period 4 (before discount)    
TOTAL Sales    
       
Sales in Period 1 (net of discount)    
Sales in Period 2 (net of discount)    
Sales in Period 3 (net of discount)    
Sales in Period 4 (net of discount)    
TOTAL Sales    
       
Amount of Discount in Period 1    
Amount of Discount in Period 2    
Amount of Discount in Period 3    
Amount of Discount in Period 4    
TOTAL Amount of Discount    
       
Gross Margin Dollars in Period 1    
Gross Margin Dollars in Period 2    
Gross Margin Dollars in Period 3    
Gross Margin Dollars in Period 4    
TOTAL Gross Margin Dollars    
       
TOTAL Gross Margin % (based on retail)    
TOTAL Discount % (based on retail)    
       
       
Check total for period 1    
Check total for period 2    
Check total for period 3    
Check total for period 4    
       
       
       

PROFITS PLUS, FOUNDER OF...

 

©1998-2026 Profits Plus Solutions, Inc.
Tom Shay
PO Box 128
Dardanelle, AR 72834
(727)823-7205

MAY 2026
Have the Small Business Advisories and News sent to your inbox. Subscribe HERE

Small Business

AdvisoriES


"It's all fun and games", is the title of the May Small Business Advisory. Too many employees think the business owner is simply renting their time. Showing up is sufficient.

 

This month's advisory shares a series of engaging activities that remind, and reward, employees that making the sale is what creates their pay check.

Small Business

NewS

Top Story

Meeting with the accountant in February before the tax return is due. I am not sure how this became a tradition. There is nothing you can do to change the numbers for 2025.

 

Why not meet in May, instead? One-third of the year would be completed, and a May meeting would allow for a discussion about what can and should be changed for the last eight months of 2026.

Article of the Month

The article of the month for May is titled, "No more tears". The discussion focuses on inventory which is a great investment in your business. But, only if you know how to manage the "open to buy" and will monitor the inventory turn rate.


Book of the Month

Mindset by Carol S. Dweck, PhD. As one who has found over the years that many of the problems in a small business occur because of the mindset of the owner of the business, this book is a must read.

All this plus the Internet Tool for Your Business and a staff incentive idea for your business.
x
BOOK US

With over 25 years of frontline experience Tom Shay is America's leading Small Business Management Expert. He's a "Must Have" for your next event.

Small Business

Advisories

The April Small Business Advisory quotes research performed by a faculty member at Purdue. The question was asked of 20,000 people, "What do you want in an experience with a business?".

 

The advisory shares the top five answers, for which the majority require the skills that only a human can have. It is not artificual intelligence or software that deals with customer service management.

Small Business

News

 

Top Story

It has been many years since we received an email from Ron of Arrow Floor Covering. Yet we still read it time and again as there are words of wisdom in his message.

 

Would the next generation want to work in your small business?


Article of the Month

Owning a small business has a lot of similarities to owning a small business. Not so much because of the hours you spent with the business, but because of the commitment you are making to yourself, your employees and your customers.

 

The April Article of the Month is titled, "With this ring, I thee wed".


Book of the Month

Everything in the April edition of Small Business News has a tie to the connection of you and your employees to your business. The same is true with this month's book suggestion which is, "Hit Refresh" by Satya Nadella, chairman and CEO of Microsoft.

 

All this plus the Internet Tool for Your Business and a staff incentive idea for your business.