Marketing Plan - Stock Control - Small Business

Download and customize a free Marketing Plan Stock Control Small Business Excel template. Perfect for business, legal, and personal use. Editable and ready to boost your productivity.

Product Name	SKU	Current Stock	Reorder Level	Last Restocked	Supplier	Status
< /t d > < t d >< /t d > < /t d > < t d >< /t d >

Small Business Marketing Plan & Stock Control Excel Template

This comprehensive Excel template is specifically designed for small businesses that need to simultaneously manage their inventory levels and align them with active marketing campaigns. Combining the strategic planning power of a Marketing Plan with the operational precision of a Stock Control system, this template enables business owners to avoid overstocking or stockouts while optimizing promotional spend. The Small Business-focused design simplifies complex data tracking into intuitive, color-coded interfaces requiring no advanced Excel knowledge — making it ideal for entrepreneurs, boutique retailers, e-commerce sellers, and local service providers managing limited resources.

Sheet Names

Dashboard
Marketing Campaigns
Inventory Stock
Sales & Revenue Tracker
Supplier Orders
Notes & Instructions

Column	Data Type	Description
Campaign ID	Text (e.g., MC-001)	Unique identifier for each campaign.
Campaign Name	Text	Name of the promotion (e.g., “Summer Sale 2024”).
Start Date	Date
End Date
Campaign Channel
Budget ($)
Actual Spend ($)
Target Audience
Promoted Products (IDs)
Status

Column	Data Type	Description
SKU ID	Text (e.g., P-101)	Unique product code.
Product Name	Text	Name of the item (e.g., “Organic Cotton T-Shirt”).
Category
Current Stock
Safety Stock Level
Avg. Weekly Sales
Demand Forecast (Next 2 Weeks)
Stock Alert
Last Restocked
Supplier ID
Campaign Link

Column	Data Type	Description
Date	Date	Date of sale.
SKU ID
Units Sold
Sales Price ($)
Total Revenue ($)
Campaign ID

Table Structures and Columns

Marketing Campaigns Sheet:
< td>When the campaign begins.< td>Date< td>When the campaign ends.< td>Text (Dropdown: Email, Social Media, Flyer, In-Store)< td>Promotion delivery method.< td>Number (Currency)< td>Total allocated budget.< td>Number (Currency)< td>Amount spent to date, manually updated or pulled from expenses.< td>Text< td>Description of intended customers (e.g., “Women 25–40, urban”).< td>Text (comma-separated: P-101,P-105)< td>Links to product SKUs in Inventory Stock sheet.< td>Text (Dropdown: Planned, Active, Completed, Canceled)< td>Current campaign phase.

Column Data Type Description

Campaign ID Text (e.g., MC-001) Unique identifier for each campaign.

Campaign Name Text Name of the promotion (e.g., “Summer Sale 2024”).

Start Date Date

End Date

Campaign Channel

Budget ($)

Actual Spend ($)

Target Audience

Promoted Products (IDs)

Status

Inventory Stock Sheet:
< td>Text (Dropdown: Apparel, Accessories, Gifts)< td>Product grouping for reporting.< td>Number< td>Units physically available.< td>Number< td>Minimum stock before reordering (e.g., 10 units).< td>Number< td>Average units sold per week, auto-calculated from Sales sheet.< td>Number< td>=Avg. Weekly Sales * 2 + (Campaign Impact %), uses formula below.< td>Text (Auto-generated)< td>Shows “LOW STOCK” or “IN STOCK” based on conditional formatting.< td>Date< td>Date of last inventory refill.< td>Text (e.g., S-002)< td>Links to Supplier Orders sheet.< td>Text (e.g., MC-001)< td>If promoted, links to Marketing Campaigns sheet.

Column Data Type Description

SKU ID Text (e.g., P-101) Unique product code.

Product Name Text Name of the item (e.g., “Organic Cotton T-Shirt”).

Category

Current Stock

Safety Stock Level

Avg. Weekly Sales

Demand Forecast (Next 2 Weeks)

Stock Alert

Last Restocked

Supplier ID

Campaign Link

Sales & Revenue Tracker Sheet:
< td>Text (e.g., P-101)< td>Product sold, linked to Inventory Stock.< td>Number< td>Quantity sold in this transaction.< td>Currency< td>Selling price per unit.< td>Currency (Formula: =Units Sold * Sales Price)< td>Auto-calculated.< td>Text (Optional)< td>If sold during a campaign, link to Marketing Campaigns sheet.

Column Data Type Description

Date Date Date of sale.

SKU ID

Units Sold

Sales Price ($)

Total Revenue ($)

Campaign ID

Essential Formulas

In Inventory Stock!F2: =IFERROR(AVERAGEIFS('Sales & Revenue Tracker'!C:C,'Sales & Revenue Tracker'!B:B,[@[SKU ID]], 'Sales & Revenue Tracker'!A:A,">="&TODAY()-14),0) — calculates average weekly sales over last 2 weeks.

In Inventory Stock!G2: =E2*2 + IF(ISBLANK([@[Campaign Link]]),0, VLOOKUP([@[Campaign Link]], Marketing Campaigns!A:J, 9, FALSE)*0.3) — forecasts demand by doubling weekly average and adding 30% uplift if promoted (adjustable multiplier).

In Marketing Campaigns!G2: =SUMIFS('Sales & Revenue Tracker'!E:E,'Sales & Revenue Tracker'!F:F,A2) — sums total revenue generated by each campaign.

In Dashboard!: A dynamic summary using SUMIF and COUNTIFS to show total spend, active campaigns, low-stock items, and ROI (Revenue / Budget).

Conditional Formatting Rules

Inventory Stock!E:E: If Current Stock ≤ Safety Stock Level → Red fill with white text.

Marketing Campaigns!H:H: If Actual Spend > Budget → Orange fill.

Sales & Revenue Tracker!F:F: If Total Revenue > $100 → Green highlight.

User Instructions

Begin by entering your product SKUs and baseline stock levels in the Inventory Stock sheet.

Set safety stock levels based on historical sales — typically 1.5x your weekly average sales.

Create marketing campaigns in the Marketing Campaigns sheet, linking them to specific products using SKU IDs.

Record every sale in the Sales & Revenue Tracker sheet daily. Include campaign ID if applicable.

Update actual spend in Marketing Campaigns as expenses occur (e.g., ads, flyers).

Check the Dashboard weekly for “Low Stock” alerts and underperforming campaigns.

Reorder inventory only when stock falls below safety levels and a campaign is active — avoid overstocking post-campaign.

Example Rows
Inventory Stock:
| SKU ID | Product Name | Current Stock | Safety Stock | Avg. Weekly Sales | Demand Forecast | Stock Alert | |--------|---------------------|---------------|--------------|-------------------|------------------|--| | P-101 | Organic T-Shirt | 8 | 10 | 25 | 55 | LOW STOCK | Marketing Campaigns:
| Campaign ID | Campaign Name | Start Date | End Date | Channel | Budget ($) | |-------------|--------------------|--------------|--------------|---------------|--| | MC-001 | Summer Flash Sale | 2024-06-15 | 2024-06-30 | Social Media | $850 |
Recommended Charts & Dashboards

Bar Chart: “Campaign ROI by Channel” — compares revenue generated vs. budget spent across channels.

Pie Chart: “Inventory Distribution by Category” — shows % of stock in Apparel vs. Accessories, etc.

Line Chart: “Stock Levels Over Time” — tracks inventory trends during marketing periods to visualize impact.

KPI Summary on Dashboard: Total Active Campaigns | Low Stock Items | Total Revenue This Month | Budget Utilization %

This template transforms chaotic small business operations into a streamlined, data-driven system. By merging Marketing Plan strategy with real-time Stock Control, you eliminate guesswork — ensuring your next promotion never leaves you without stock… or drowning in unsold inventory.
⬇️ Download as Excel ✏️ Edit online as Excel

Create your own Excel template with our GoGPT AI prompt:
GoGPT