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    
       
       
       

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

Small Business

AdvisorieS

The May Small Business Advisory is titled "Planning for a successful accountant" and is appropriate for many with the April 15 tax deadline having passed.

 

Did you work with your accountant? Or, did you just give them a bunch of papers and wait to receive a completed tax return?

 

Successfully working with an accountant requires a partnership. This month's Small Business Advisory gives suggestions of how to make this happen in 2024.

Small Business

News

Top Story

We see that many small business owners have too much of a focus on the "top line" of their income statement.

 

Increasing revenue is great, but it is not a cure all for any challenges your business is facing. And sometimes, incresing revenue can create a challenge.

Article of the Month

Who is your customer? Some small businesses have no focus. Their customer is whoever calls or walks in the door.

 

And some small businesses have determined which customers, in sufficient numbers, they should spend their efforts to attract.

 

The article of the month shares an old Southern rhyming couplet about business; "The bertter you niche, the more you get rich."


Book of the Month

Lean Startup by Eric Reis is our suggested book for May.

 

As the title suggests, the reader of the book would be someone that is starting their business. However, we see more value than just that.

 

Perhaps you have been in business for many years. We think this book could give insight to items, and methods, that a small business owner should think about with their business today.

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 May Small Business Advisory is titled "Planning for a successful accountant" and is appropriate for many with the April 15 tax deadline having passed.

 

Did you work with your accountant? Or, did you just give them a bunch of papers and wait to receive a completed tax return?

 

Successfully working with an accountant requires a partnership. This month's Small Business Advisory gives suggestions of how to make this happen in 2024.

Small Business

News

 

Top Story

We see that many small business owners have too much of a focus on the "top line" of their income statement.

 

Increasing revenue is great, but it is not a cure all for any challenges your business is facing. And sometimes, incresing revenue can create a challenge.


Article of the Month

Who is your customer? Some small businesses have no focus. Their customer is whoever calls or walks in the door.

 

And some small businesses have determined which customers, in sufficient numbers, they should spend their efforts to attract.

 

The article of the month shares an old Southern rhyming couplet about business; "The bertter you niche, the more you get rich."


Book of the Month

Lean Startup by Eric Reis is our suggested book for May.

 

As the title suggests, the reader of the book would be someone that is starting their business. However, we see more value than just that.

 

Perhaps you have been in business for many years. We think this book could give insight to items, and methods, that a small business owner should think about with their business today.