Retail Business Planning Bonuses

Retail Sales Projection Templates

1. The “Big Picture” Annual Projection (Monthly View)

Best for: General business planning, requesting loans, and setting high-level targets. This model uses your previous year’s data as a baseline.

Month	Last Year Actuals ($)	Target Growth Rate (%)	Projected Sales ($)	Cost of Goods Sold (COGS) ($)	Projected Gross Profit ($)
January	$10,000	5%	$10,500	$5,250	$5,250
February	$11,000	5%	$11,550	$5,775	$5,775
March	$12,500	8%	$13,500	$6,750	$6,750
April	$12,000	5%	$12,600	$6,300	$6,300
May	$14,000	10%	$15,400	$7,700	$7,700
June	$15,000	10%	$16,500	$8,250	$8,250
…	…	…	…	…	…
TOTAL	$74,500	—	$80,050	$40,025	$40,025

Formulas to use:

• Projected Sales: Last Year Actuals * (1 + Target Growth Rate)
• Gross Profit: Projected Sales – COGS

2. The “Seasonality” Adjuster

Best for: Retailers with heavy peaks (e.g., Holiday shopping, Summer apparel, Back-to-School). This template separates “Base Sales” from “Seasonal Spikes.”

Quarter	Month	Base Baseline Sales ($)	Seasonal Index (Multiplier)	Marketing Spend ($)	Forecasted Revenue ($)
Q1	Jan	$20,000	0.8 (Slow)	$500	$16,000
	Feb	$20,000	0.9 (Slow)	$500	$18,000
	Mar	$20,000	1.1 (Pickup)	$1,000	$22,000
Q2	Apr	$20,000	1.0 (Avg)	$1,000	$20,000
	May	$20,000	1.2 (High)	$1,500	$24,000
	Jun	$20,000	1.3 (High)	$2,000	$26,000

How to use:

• Base Baseline: Your sales in an “average” month with no holidays or events.
• Seasonal Index: Use 1.0 for average. Use 1.5 for a month you expect to be 50% busier than usual. Use 0.8 for a slow month.
• Calculation: Base Sales * Seasonal Index = Forecasted Revenue

3. The Unit/Category Based Projection

Best for: Inventory planning. It calculates sales based on how many items you plan to sell rather than just revenue totals.

Product Category	Avg. Sale Price (ASP)	Est. Units Sold (Daily)	Days in Month	Total Units (Monthly)	Total Revenue ($)
Apparel (Tops)	$25.00	10	30	300	$7,500
Apparel (Bottoms)	$45.00	5	30	150	$6,750
Accessories	$12.00	20	30	600	$7,200
Footwear	$80.00	2	30	60	$4,800
Impulse Buys	$5.00	15	30	450	$2,250
TOTALS	—	—	—	1,560	$28,500

4. The Daily Retail Tracker (Micro-Forecast)

Best for: Staffing and cash flow. Retail is often about the “Day of the Week” (e.g., Saturdays are busy, Tuesdays are slow).

Week Ending: [Date]	Day	Weather/Event Notes	Hist. Sales (Same day last year)	Growth Goal	Projected Sales	Staff Needed
	Monday	Raining	$800	2%	$816	2
	Tuesday	—	$750	2%	$765	2
	Wednesday	Senior Discount Day	$1,100	5%	$1,155	3
	Thursday	—	$900	2%	$918	2
	Friday	Payday	$2,500	10%	$2,750	4
	Saturday	Market Day	$3,500	10%	$3,850	5
	Sunday	—	$2,000	5%	$2,100	3
	TOTAL		$11,550		$12,354

Key Definitions for Your Sheet

• COGS (Cost of Goods Sold): The direct cost of producing the goods sold (purchase price + shipping in).
• Gross Margin %: Use the formula: $\frac{\text{Revenue} – \text{COGS}}{\text{Revenue}}$. This tells you how much profit you keep per dollar.
• ASP (Average Selling Price): Total Revenue divided by Total Units Sold.
• Conversion Rate: (If you have a foot traffic counter) The percentage of people walking in who actually buy something.

Store Target Breakdown

1. The Daily Staff “Huddle” Sheet

Best for: Posting in the back room. It breaks the day’s goal down by employee, so everyone knows their “slice” of the pie.

Date: [Insert Date]	Store Goal: $5,000
Staff Name	Shift Hours	Indiv. Sales Goal ($)	Actual Sales ($)	+/- Variance	Notes (Wins/Issues)
Sarah (Opener)	9am – 3pm	$1,500	$1,600	+$100	Sold 2 high-ticket items
Mike (Mid)	11am – 5pm	$2,000	$1,800	-$200	Low foot traffic 1-2pm
Jessica (Closer)	3pm – 9pm	$1,500	$1,650	+$150	Great upsells at register
TOTAL	—	$5,000	$5,050	+$50	Goal Hit!

Manager Tip: Don’t just split the goal evenly by hour. Assign higher goals to staff working peak hours (usually 12pm–2pm and 5pm–7pm).

2. The “Math to the Goal” (KPI Breakdown)

Best for: Coaching. This shows staff how to hit the number. It focuses on UPT (Units Per Transaction) and ATV (Average Transaction Value) rather than just a scary big dollar sign.

Metric	Store Target	Why it matters	How to achieve it today
Sales Goal	$2,500	Revenue to keep lights on.	—
Transaction Count	50	# of paying customers.	Greet every person within 10 seconds.
ATV (Avg Transaction)	$50.00	Average spend per customer.	“Show them the $60 item, not the $30 item first.”
UPT (Units Per Trans)	1.5	Items per bag.	“Does that shirt need a matching belt?”

The Calculation Checker:

• $50.00 (ATV) x 50 (Transactions) = $2,500 (Sales Goal)

3. The Monthly “Pacing” Tracker

Best for: The Store Manager’s clipboard. It tells you if you are ahead or behind schedule for the month so you don’t panic on the 28th.

Date	Day	Daily Goal ($)	Actual Sales ($)	Variance ($)	Month-to-Date (MTD) Variance	Status
Oct 1	Mon	$1,000	$900	-$100	-$100	⚠️ Behind
Oct 2	Tue	$1,000	$1,100	+$100	$0	✅ On Track
Oct 3	Wed	$1,200	$1,400	+$200	+$200	🔥 Ahead
Oct 4	Thu	$1,200	…	…	…
…	…	…	…	…	…
TOTAL		$30,000

Formula for “MTD Variance”: Previous Day’s MTD Variance + Today’s Variance.

If the number is negative, you need to add that amount to the remaining days’ goals to catch up.

4. Department/Category Targets

Best for: Larger boutiques or stores with distinct sections (e.g., a bike shop that sells Bikes vs. Service vs. Accessories).

Department	% of Mix (Hist.)	Today’s Goal ($)	Actual ($)	% to Goal
Apparel	40%	$2,000	$1,800	90%
Accessories	20%	$1,000	$1,200	120%
Footwear	30%	$1,500	$1,500	100%
Impulse/Register	10%	$500	$400	80%
TOTAL	100%	$5,000	$4,900	98%

How to calculate the targets (Formulas)

If you are wondering how to come up with the numbers to put in these sheets, use this “Reverse Engineering” method:

1. Start with the Monthly Goal: (e.g., $30,000)
2. Divide by Operating Days: (e.g., 30 days = $1,000/day average)
3. Weight by Day of Week: (Average doesn’t work for retail).
   • Monday – Wednesday: Weight at 80% of average ($800)
   • Thursday: Weight at 100% of average ($1,000)
   • Friday – Saturday: Weight at 130% of average ($1,300)
   • Sunday: Weight at 110% of average ($1,100)

OTB Calculator

Before you use the template, you must understand the math.

$$OTB \text{ (at retail)} = \text{Planned EOM Inventory} + \text{Planned Sales} + \text{Planned Markdowns} – \text{Planned BOM Inventory}$$

• EOM: End of Month
• BOM: Beginning of Month

1. The 6-Month Open-to-Buy Plan

Best for: Planning a season (e.g., Spring/Summer or Fall/Winter). This is typically done at the Retail Price (the price tag value), not the cost price.

Metric	Formula / Source	Feb	Mar	Apr	May	Jun	Jul
1. Planned Sales	(From Sales Projection)	$20,000	$22,000	$25,000	$28,000	$30,000	$25,000
2. Planned Markdowns	(Discounts/Promos)	$2,000	$1,000	$1,500	$2,000	$3,000	$5,000
3. Planned EOM Inv.	(Target Stock Level)	$60,000	$65,000	$70,000	$65,000	$55,000	$45,000
4. Total Needs	(Sum of Rows 1+2+3)	$82,000	$88,000	$96,500	$95,000	$88,000	$75,000
5. BOM Inventory	(Last Month’s EOM)	$55,000	$60,000	$65,000	$70,000	$65,000	$55,000
6. OPEN TO BUY ($)	(Row 4 minus Row 5)	$27,000	$28,000	$31,500	$25,000	$23,000	$20,000
7. On Order	(Already purchased)	$10,000	$15,000	$5,000	$0	$0	$0
8. OTB BALANCE	(Row 6 minus Row 7)	$17,000	$13,000	$26,500	$25,000	$23,000	$20,000

Critical Note: The BOM Inventory for March is always the same number as the EOM Inventory for February.

2. How to convert OTB to “Cost” (What you actually pay)

The sheet above is at “Retail Value” (what the customer pays). To know what checks to write to your vendors, you must apply your Initial Markup (IMU).

Formula:

$$OTB \text{ (at Cost)} = OTB \text{ (Retail)} \times (1 – \text{IMU}\%)$$

Example:

• OTB at Retail: $17,000
• Initial Markup: 50% (0.50)
• Calculation: $17,000 * (1 – 0.50) = $8,500$
• Action: You have a budget of $8,500 to spend on wholesale orders for February delivery.

3. In-Season OTB Adjustment

Best for: Mid-month checks. Plans never go perfectly. If sales are slower than expected, your OTB must shrink, or you will be overstocked.

Metric	Plan ($)	Actual / Forecast ($)	Difference	Effect on OTB
Sales	$50,000	$40,000	-$10,000	📉 Decreases OTB
Markdowns	$5,000	$2,000	-$3,000	📉 Decreases OTB
Receipts	$20,000	$25,000	+$5,000	📉 Decreases OTB
BOM Inv.	$100,000	$105,000	+$5,000	📉 Decreases OTB

Logic Check:

• If you oversold your plan (Sales were higher than expected), you have generated more OTB cash to buy more stock to refill.
• If you undersold your plan, your OTB decreases because that inventory is still sitting there.

Common Mistakes to Avoid

1. Ignoring Transit Times: If you need the goods to be sold in February, the OTB “spend” usually happens in December/January (depending on vendor lead time).
2. Spending 100% of the OTB: Always leave 10–15% of your OTB “Open” (unspent) for chasing trends or emergency restocks. This is called “Open-to-Chase.”
3. Confusing Cost vs. Retail: Never send a Purchase Order for $10,000 if your OTB says $10,000 at retail. You will blow your budget by double.

Inventory Turn Tracker

The Inventory Turn (or Inventory Turnover) is a key retail performance indicator. It measures how quickly you sell and replace your stock over a period. A high turnover is generally good, as it means your inventory isn’t sitting on shelves for long, but it needs to be balanced against the risk of stockouts.

The two main formulas for calculating Inventory Turnover are:

1. Based on Cost:
2. Based on Retail:

We will use the COGS method (1) as it is the industry standard and removes the distortion of fluctuating markups/markdowns.

1. Inventory Turn Tracker (Quarterly View)

Best for: Monitoring performance across major selling seasons and identifying trends.

Metric	Q1 (Jan-Mar)	Q2 (Apr-Jun)	Q3 (Jul-Sep)	Q4 (Oct-Dec)
A. COGS	$150,000	$175,000	$180,000	$220,000
B. Beginning Inventory (BOM Cost)	$50,000	$55,000	$60,000	$70,000
C. Ending Inventory (EOM Cost)	$55,000	$60,000	$70,000	$65,000
D. Average Inventory (Cost)	$52,500	$57,500	$65,000	$67,500
E. INVENTORY TURN (Times)	2.86	3.04	2.77	3.26
F. Days of Supply (Days)	127	120	130	112

Export to Sheets

Formulas Used:

• Average Inventory (D):
  • (Example Q1: )
• Inventory Turn (E):
  • (Example Q1: )
• Days of Supply (F): (365 for Annual, 90 for Quarterly)
  • Using 365 Days: days. This means your stock lasts 127 days before it’s completely sold and replaced.

2. Category-Level Inventory Turn

Best for: Identifying which products are performing well versus those that are becoming “dead stock.” You should calculate this turn for each major product category.

Category	Annual COGS	Avg. Inventory (Cost)	Inventory Turn	Interpretation	Target Turn
Fast Fashion	$25,000	$3,500	7.14	Excellent! Requires high replenishment.	6.0+
Core Basics (Jeans, Tees)	$40,000	$6,000	6.67	Very good staple stock.	5.0 – 6.0
Seasonal Outerwear	$15,000	$5,000	3.00	Acceptable for higher-price items.	2.5 – 3.5
Accessories/Jewelry	$10,000	$8,000	1.25	Too Slow! Stock is aging/too deep.	2.0 – 3.0

3. Target Inventory Turn Benchmark

The ideal turnover rate is highly dependent on your retail niche. Use these benchmarks as a general guide:

Retail Type	Ideal Inventory Turn (Times per Year)	Reason
Grocery/Perishables	12.0 – 50.0+	High-volume, short shelf life.
Fast Fashion	6.0 – 10.0	Quick trends, needs fast liquidation.
High-End Apparel/Boutique	3.0 – 5.0	Higher price point, customers expect uniqueness.
Furniture/Jewelry	1.0 – 3.0	Large investment, slow-moving assets.

Key Action Items based on the Tracker

• Turn is Too High (e.g., 10+): You are likely experiencing stockouts and losing sales. Solution: Increase your safety stock or improve your ordering lead times.
• Turn is Too Low (e.g., 1.5): You have too much cash tied up in old merchandise. Solution: Increase markdowns, return stock to vendors, or reduce future OTB for that category.

Category Planning Guide

The Category Planning Guide (often called Category Management) is a structured process retailers use to manage product groups as strategic business units. It involves treating a category (e.g., “Men’s Casual Shirts,” “Dairy Products”) as its own mini-business with its own P&L (Profit and Loss) and goals.

Here is a step-by-step template and guide for effective category planning.

Phase 1: Analysis & Assessment (The “Where Are We Now?”)

The goal is to understand the current health of the category and the overall market.

Step	Focus Area	Key Data Points & Questions	Output
1. Market Assessment	The Customer & Competition	What are the market size and growth trends? What is our market share? Who are the top 3 competitors, and what are they doing? What are the key consumer needs for this category?	SWOT Analysis (Strengths, Weaknesses, Opportunities, Threats) for the Category.
2. Internal Performance	Sales & Inventory	What is the Category’s current Sales, Gross Margin, and Inventory Turn? Which SKUs are the top 20% (A-Items)? Which are the bottom 20% (C-Items)? Are we carrying too much or too little risk?	A-B-C Analysis and Health Metrics Dashboard.
3. Financial Audit	Profitability	How does the category’s profit margin compare to the store average? Are markdowns (MDs) too high? Are vendor rebates or allowances being utilized?	Profitability by SKU and Vendor Ranking.

Phase 2: Strategy Development (The “Where Do We Want to Go?”)

Based on the assessment, you define the category’s role and set the goals.

Define Category Role

Every category should serve one primary strategic purpose:

Category Role	Primary Goal	Inventory & Pricing Strategy
1. Traffic Builder	Drive customer visits and cross-shopping.	Highly price-sensitive (often low margin). Must be in stock (e.g., Milk, Bread, Basic Socks).
2. Profit Generator	Maximize margins and overall profit.	Higher margin, premium products. Fewer markdowns (e.g., Specialized Electronics, Premium Coffee).
3.Excitement/Seasonal	Create interest and drive impulse buys.	Newness is key, very limited shelf life. (e.g., Seasonal apparel, Holiday decorations).
4.Maintenance/Defense	Offer convenience, maintain customer loyalty.	Necessary but not primary drivers. (e.g., Batteries, Shoelaces).

Set Key Objectives

Set S.M.A.R.T goals (Specific, Measurable, Achievable, Relevant, Time-bound).

• Example 1 (Traffic Builder): Increase customer store visits by 5% in Q3 by improving in-stock position of the top 10 items.
• Example 2 (Profit Generator): Increase Gross Margin from 40% to 43% over the next 6 months by negotiating a 5% vendor allowance increase.

Phase 3: Tactics & Implementation (The “How Will We Get There?”)

This phase involves specific actions across the 4 P’s (or 5 P’s of Retail).

Product Assortment

Tactic	Action
Assortment Plan	Remove all C-items (low-selling, low-margin). Add 3 new high-margin premium SKUs (A-items).
Sourcing	Find a secondary vendor for a critical Traffic Builder item to reduce Max Lead Time risk.

Pricing & Promotion

Tactic	Action
Everyday Pricing	Review competitive prices on all Traffic Builder items weekly. Match or beat the lowest price.
Promotion Plan	Schedule 3 dedicated promotions in Q4, focused only on clearing old Seasonal/Excitement stock.

Placement (Merchandising)

Tactic	Action
Planogram	Give 20% more shelf space to the high-turn Core Basics to reduce restocking labor and prevent stockouts.
Cross-Merch	Place accessories from this category near the register (impulse buys) or near a high-traffic category.

People (Staff Training)

Tactic	Action
Training	Run a training session on the features and benefits of the 3 new premium Profit Generator items.
Incentives	Tie a small bonus/commission to the sale of slow-moving items to help liquidate old stock.

Phase 4: Review & Adjustment

The final phase closes the loop, measuring results against the goals set in Phase 2.

Task	Frequency	Focus
Weekly Review	Every Monday	Monitor sales, stockouts, and markdown tracking against the daily targets.
Monthly Review	End of Month	Analyze Gross Margin, Inventory Turn, and Vendor Performance. Adjust OTB.
Annual/Seasonal Review	End of Season	Comprehensive review of the entire plan to inform the next year’s strategy. Did the Category Role strategy work?

 

BONUS: Safety Stock Calculator

The Safety Stock Calculator is essential for optimizing your inventory and directly reducing those costly stockouts or overstock situations we discussed.

The most practical and common formula for retail businesses that don’t have complex statistical software is the Max/Min Formula, as it accounts for both the variability in customer demand and the variability in supplier lead time.

The Max/Min Safety Stock Formula

$$\text{Safety Stock} = (\text{Max Daily Usage} \times \text{Max Lead Time}) – (\text{Avg Daily Usage} \times \text{Avg Lead Time})$$

1. Safety Stock Calculator Template

Use this template for a single SKU (Stock Keeping Unit) or a Product Family/Category that has similar sales velocity and lead times.

Metric	Data Input (Units/Days)	Example Input	Source / How to Calculate
A. Max Daily Usage (Units)	Maximum Daily Sales	100 units	Look at your highest sales day for this item in the last 3-6 months.
B. Avg Daily Usage (Units)	Average Daily Sales	70 units	Total sales in period $\div$ Total days in period.
C. Max Lead Time (Days)	Longest Delivery Time	12 days	The longest time it took to receive this item after you placed an order.
D. Avg Lead Time (Days)	Average Delivery Time	8 days	Sum of all lead times $\div$ Number of orders in the last 3-6 months.
E. Max Lead Time Demand	$A \times C$	1,200 units	(100 units/day $\times$ 12 days)
F. Avg Lead Time Demand	$B \times D$	560 units	(70 units/day $\times$ 8 days)
G. SAFETY STOCK (Units)	$E – F$	640 units	The buffer inventory you must keep on hand.

Result Interpretation: Based on the example, you should maintain a buffer of 640 units of this product. If your stock drops near that number, you are running a high risk of a stockout before the next order arrives.

2. The Reorder Point (ROP) Calculator

Safety stock is useless if you don’t know when to place the order. The Reorder Point (ROP) tells you the exact inventory level that triggers a new Purchase Order.

$$\text{Reorder Point} = \text{Avg Lead Time Demand} + \text{Safety Stock}$$

Metric	Calculation / Formula	Example (from above)
A. Average Lead Time Demand	F from the Safety Stock table	560 units
B. Safety Stock	G from the Safety Stock table	640 units
C. REORDER POINT (ROP)	$A + B$	1,200 units

Action: When your inventory for this item drops to 1,200 units, you must place a new order. The time it takes for that order to arrive (8 days average) is the time you expect to sell 560 units, and you have a 640-unit buffer in case of a sales surge or delivery delay.

3. Strategic Use & Trade-Offs

Factor	Effect on Safety Stock (SS)	Action
Higher Service Level Goal	⬆️ SS (More Inventory)	For your most profitable A-tier items.
Unreliable Supplier	⬆️ SS (Higher Max Lead Time)	For items sourced from new or overseas vendors.
Consistent Demand	⬇️ SS (Max/Avg Daily Usage Closer)	For core basics and evergreen items.
High Holding Costs	⬇️ SS (Less Inventory)	For expensive, bulky, or perishable items.

This calculator provides a solid, data-driven approach to setting your inventory thresholds.