Excel Template for Marketing Planning & Stock Control – Home Use

This comprehensive Excel template is thoughtfully designed for home-based entrepreneurs, small business owners, and hobbyists engaged in marketing planning while managing their inventory. It seamlessly integrates Marketing Planning, Stock Control, and practicality for Home Use. Whether you're a craft maker selling handmade goods online, a home-based baker promoting seasonal treats, or a digital product creator launching campaigns, this template empowers you to track inventory levels in real time while aligning your marketing strategies with stock availability.

Sheet Names and Purpose

1. Dashboard (Main View): A centralized overview featuring key performance indicators (KPIs), sales trends, low-stock alerts, and campaign progress.
2. Inventory Master List: Central table for managing all products—stock levels, cost prices, selling prices, categories.
3. Marketing Campaign Log: Tracks planned and executed marketing activities with goals, budgets, channels used (social media, email), results.
4. Sales & Orders Tracker: Records every sale or order made—date, product name, quantity sold, revenue generated.
5. Monthly Summary: Aggregates data from other sheets to provide monthly insights into stock turnover, marketing ROI, and profit margins.

Table Structures & Columns (with Data Types)

• Inventory Master List
  • Product ID (Text): Unique identifier (e.g., HMBK101).
  • Product Name (Text): Name of the item (e.g., "Homemade Lavender Soap").
  • Category (Text): Type of product—Bakery, Crafts, Digital, etc.
  • Current Stock Level (Number): Real-time count of units available.
  • Reorder Point (Number): Threshold at which a reorder is triggered (e.g., 10).
  • Cost Price per Unit (£ or $) (Currency): Purchase or production cost.
  • Selling Price per Unit (£ or $) (Currency): Retail price to customers.
  • Supplier Name (Text): Vendor of raw materials or components.
• Marketing Campaign Log
  • Campaign ID (Text): Unique code for each campaign (e.g., MARKET2024-01).
  • Start Date (Date): When the campaign begins.
  • End Date (Date): Target close date.
  • Campaign Name (Text): Short title (e.g., "Summer Sale 2024").
  • Marketing Channel (Text): Facebook, Instagram, Email, TikTok.
  • Budget (£ or $) (Currency): Planned spending.
  • Actual Spend (£ or $) (Currency): Real expenditure recorded.
  • Target Audience (Text): E.g., "Women aged 25–40, UK-based."
  • Goal (Text): e.g., "Increase sales by 30%."
  • Status (Dropdown: Planned, Active, Completed, Cancelled)
• Sales & Orders Tracker
  • Order ID (Text): Unique order reference.
  • Date Sold (Date)
  • Product Name (Text): Matches Inventory Master List.
  • Quantity Sold (Number)
  • Revenue Generated (£ or $) (Currency): = Quantity × Selling Price.
• Monthly Summary
  • Month/Year (Date)
  • Total Units Sold (Number)
  • Total Revenue (£ or $) (Currency)
  • Cost of Goods Sold (£ or $) (Currency): = Total units sold × Cost per unit.
  • Gross Profit (£ or $) (Currency): = Revenue – COGS.
  • Marketing ROI (%): =(Gross Profit / Actual Spend) * 100, if > 0.
  • Low Stock Alerts (Text): List of products below reorder point.
• Dashboard
  • KPI Cards: "Total Revenue This Month", "Products Below Reorder Level", "Active Campaigns", etc.
  • Interactive Charts: Embedded visuals for sales trends, campaign performance, stock levels.

Essential Formulas Used

• Inventory: Auto-Update Stock Level: =VLOOKUP([Product Name], Inventory_Master_List!$A$2:$I$100, 4, FALSE) - SUMIF(Sales_Tracker!C:C, [Product Name], Sales_Tracker!D:D) (Calculates current stock by subtracting sold units from initial stock.)
• Low Stock Alert: =IF(Inventory_Level <= Reorder_Point, "Reorder Now", "OK")
• Sales Revenue: =Quantity_Sold * Selling_Price
• Gross Profit: =Total_Revenue - (Units_Sold * Cost_Per_Unit)
• Marketing ROI: =IF(Actual_Spend > 0, (Gross_Profit / Actual_Spend) * 100, "No Spend")

Conditional Formatting Rules

• Low Stock Alert: Red fill with white text for any product where stock ≤ reorder point.
• Campaign Status: Color-coded: Blue for "Planned", Yellow for "Active", Green for "Completed".
• Sales Trends: Data bars in Dashboard to visually represent monthly revenue growth.
• Profit Margin: Green if > 40%, Orange if between 20–40%, Red if below 20%.

User Instructions

To use this template effectively:

1. Save a copy of the file to your computer or cloud storage (e.g., OneDrive).
2. Navigate to the Inventory Master List and enter your products with correct stock levels.
3. Add new campaigns in the Marketing Campaign Log, setting realistic goals and budgets.
4. After each sale, log it in the Sales & Orders Tracker.
5. The Dashboard auto-updates KPIs and alerts. Review monthly to identify best-selling items and underperforming campaigns.
6. When stock falls below the reorder point, place an order immediately.
7. Use the Monthly Summary tab for long-term planning—adjust marketing budgets based on ROI data.

Example Rows

Recommended Charts & Dashboards

• Sales Trend Chart: Line graph showing monthly revenue (Dashboard).
• Inventory Level Gauge: Circular progress bar for each product showing stock vs. reorder point.
• Campaign ROI Comparison Bar Chart: Compares return on investment across different campaigns.
• Top 5 Products by Sales: Horizontal bar chart in the Monthly Summary sheet.

This Excel template for Marketing Planning, Stock Control, and Home Use is designed to be intuitive, scalable, and insightful—helping you grow your small home business with confidence, clarity, and data-driven decisions.