Marketing Plan - Stock Control - Quarterly

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

< / td > < t d >< / t d > < / td >

Quarter	Product Name	Category	Opening Stock Purchases Received Sales Sold Closing Stock Reorder Level Status
Q2
Q3 < / td >	< / td >	< / td >	< / td >	< / t d > < / t d > < / t d> < t d >< / t d> < t d>< /

Quarterly Marketing Plan with Stock Control Excel Template

This comprehensive Excel template is specifically designed for marketing teams and supply chain managers who need to synchronize promotional campaigns with inventory levels on a quarterly basis. Combining the strategic goals of a Marketing Plan with the operational precision of Stock Control, this Quarterly-focused workbook enables businesses to avoid stockouts during high-demand campaign periods and prevent overstocking after promotions end. It integrates financial forecasting, inventory tracking, sales projections, and visual analytics into a single dynamic dashboard — ensuring that marketing initiatives are supported by real-time supply chain data.

Sheet Names

Dashboard – Central hub with KPIs and charts
Marketing_Campaigns – Quarterly campaign details and budgets
Inventory_Stock_Control – Real-time stock levels, reorder points, and supplier info
Sales_Projections – Forecasted sales by product and campaign period
Supplier_Orders – Historical and planned purchase orders
Analytics_Review – Post-quarter performance comparison and insights
Data_Tables – Lookup tables for product SKUs, categories, regions, and suppliers (hidden by default)

Table Structures & Column Definitions

Marketing_Campaigns Sheet:

< td>Start_Date<<< td>Budget_Spent<< td>Expected_Sales_Increase%< td>Channel< td>Status<

Column	Data Type	Description
Campaign_ID	Text (e.g., Q2_CAM_01)	Unique identifier for each campaign.
Campaign_Name	Text	Name of the marketing campaign (e.g., “Summer Flash Sale”).
Date	Start date of the campaign (Quarterly range: Jan-Mar, Apr-Jun, etc.).
End_Date	Date	End date of the campaign.
Budget_Planned	Currency ($)	Total allocated marketing budget.
Currency ($)	Actual spend tracked via linked expense logs.
Percentage	Predicted uplift in sales due to campaign.
List (Email, Social, TV, Influencer)	Primary promotional channel used.
List (Planned, Active, Completed, Canceled)	Current campaign status.

Inventory_Stock_Control Sheet:

< td>Product_Name< td>Category< td>Curr_Stock_Level<< td>Safety_Stock<< td>Demand_Predicted_QTR<< td>Reorder_Point<< td>Units_To_Order< td>Last_Reorder_Date<< td>Lead_Time_Days<< td>Supplier_ID< td>Status<

Column	Data Type	Description
SKU_ID	Text (e.g., PROD-1045)	Unique Stock Keeping Unit identifier.
Text	Name of the promoted product.
List (e.g., Electronics, Apparel, Beauty)	Product category for filtering.
Number	Current inventory units on hand.
Number	Minimum stock level before reordering triggered (auto-calculated).
Number	Predicted units needed during the current quarter, pulled from Sales_Projections.
Number	AUTO-CALCULATED: (Avg_Weekly_Demand × Lead_Time) + Safety_Stock.
Number	=MAX(0, Demand_Predicted_QTR - Curr_Stock_Level)
Date	Date of last purchase order.
Number	Average days from supplier order to delivery.
Text (linked to Supplier_Orders)	Ties inventory item to vendor.
List (In Stock, Low, Out of Stock, Overstocked)	Dynamically assigned via conditional formatting.

Formulas Required

In Inventory_Stock_Control!Reorder_Point:
=AVERAGEIFS(Sales_Projections!Units_Sold, Sales_Projections!SKU_ID, [@SKU_ID], Sales_Projections!Quarter, "Q2") * [@Lead_Time_Days] + [@Safety_Stock]
In Inventory_Stock_Control!Units_To_Order:
=MAX(0, [@[Demand_Predicted_QTR]] - [@[Curr_Stock_Level]])
In Dashboard!KPI_Sales_Uplift%:
=AVERAGEIF(Marketing_Campaigns!Status,"Completed",Marketing_Campaigns!Expected_Sales_Increase%)
In Dashboard!Stock_Accuracy%:
=1 - (COUNTIFS(Inventory_Stock_Control!Status,"Out of Stock") / COUNTA(Inventory_Stock_Control!SKU_ID))
In Marketing_Campaigns!Budget_Spent: Pulls data from linked expense tracker using SUMIFS based on Campaign_ID.

Conditional Formatting Rules

Inventory Status: Red if Curr_Stock_Level ≤ Reorder_Point, Yellow if between Reorder_Point and 1.5x Reorder_Point, Green if above 1.5x.
Budget Utilization: Red if Budget_Spent > 90% of Budget_Planned, Amber if between 70-89%, Green below 70%.
Product Demand vs Supply: Bold red font in Sales_Projections if Predicted Units > (Curr_Stock_Level * 1.2).

User Instructions

Enter Campaign Details: On the Marketing_Campaigns sheet, fill in your quarterly campaign schedule including start/end dates, budget, and expected uplift.
Update Inventory Levels: Weekly or bi-weekly, update Curr_Stock_Level in Inventory_Stock_Control based on warehouse data.
Sync Sales Forecasts: Populate Sales_Projections with historical trends and projected campaign impacts using the built-in forecasting tool.
Review Reorder Alerts: Check Units_To_Order column – if >0, generate purchase order via Supplier_Orders sheet.
Monitor Dashboard: The main Dashboard updates automatically. If “Stock Accuracy” drops below 85%, investigate mismatches between forecast and actual sales.
Post-Quarter Review: After quarter-end, use Analytics_Review to compare planned vs actuals and update templates for next quarter.

Example Rows

Marketing_Campaigns:

< td>37%< td>Social Media< td>8/31/2024< td>$6,200< td>$6,500*< td>25%< td>Email + Influencer

Q3_CAM_04	Halloween Glow-Up Bundle	10/1/2024	10/31/2024	$8,500	$7,950
Q3_CAM_05	Back-to-School Essentials Promo	8/1/2024

Inventory_Stock_Control:

< td>Beauty< td>42< td>60< td>150< td>138< td style="background-color:yellow;">78 << td>Bags & Luggage< td>250< td>100< td>450< td>346< td style="background-color:red;">200 << td>Toys< td>50< td>35< td>120 < td >106

*Over Budget — campaign exceeded budget but met sales target.
PROD-3082	Glow-Up Lipstick Set
PROD-9215	School Backpack XL
PROD-1877	Halloween LED Costume Light

Recommended Charts & Dashboards

Stacked Column Chart: Campaign Budget vs Spent by quarter, overlaid with Units Sold for each campaign.
Dual-Axis Line Chart: Inventory Stock Level (left) and Sales Volume (right) over time — reveals stockout patterns tied to campaign peaks.
Heatmap: Products ranked by Units_To_Order vs Category, highlighting which product lines need urgent restocking.
KPI Cards: Real-time display of: Stock Accuracy %, Campaign ROI (Sales Increase / Budget Spent), Inventory Turnover Rate (QoQ).
Slicer Filters: Add slicers for Quarter, Product Category, and Marketing Channel to enable dynamic filtering across all sheets.

This template transforms disconnected marketing and inventory systems into a synchronized quarterly engine. By aligning promotional timing with supply readiness, businesses maximize sales potential while minimizing waste — the ultimate goal of any data-driven Marketing Plan operating under strict Stock Control constraints in a dynamic Quarterly cycle.

⬇️ Download as Excel ✏️ Edit online as Excel

Create your own Excel template with our GoGPT AI prompt:

GoGPT