Weekly Marketing Plan with Stock Control Excel Template

This comprehensive Excel template is specifically designed for marketing teams managing product inventory levels in alignment with weekly promotional campaigns. Combining the strategic goals of a Marketing Plan with the operational precision of Stock Control, this Weekly-oriented template enables businesses to synchronize promotional activities with real-time inventory data, preventing stockouts or overstock situations that can undermine campaign effectiveness. Whether you’re launching seasonal products, running flash sales, or managing retail partnerships, this template ensures your marketing efforts are always backed by accurate inventory intelligence.

Sheet Names

• Weekly_Plan_Summary – High-level dashboard showing key performance indicators (KPIs) and inventory health.
• Product_List – Master list of all products with static attributes.
• Weekly_Inventory_Log – Core worksheet for tracking daily stock movements over the week.
• Campaign_Timeline – Timeline of marketing activities linked to inventory needs.
• Forecast_vs_Actual – Comparative analysis between projected demand and actual sales volume.
• Alerts_and_Reports – Automated alerts for low stock, overstock, or mismatched campaign-inventory alignment.

Table Structures and Columns

Product_List (Static Reference Table)

Weekly_Inventory_Log

Campaign_Timeline

Key Formulas

• Ending_Stock (Weekly_Inventory_Log!G2): =F2 + C2 - D2 + E2 + F2 – Calculates ending inventory based on initial stock, sales, receipts, and adjustments.
• Stock_Duration (Weekly_Plan_Summary!D5): =IFERROR(Ending_Stock / AVERAGEIF(Product_List!$A:$A, Weekly_Inventory_Log!B2, Product_List!$F:$F), 0) – Estimates days of stock remaining based on historical weekly demand.
• Campaign_Inventoried (Alerts_and_Reports!B3): =IF(COUNTIFS(Weekly_Inventory_Log!H:H, "Yes", Weekly_Inventory_Log!B:B, Product_List!A2) > 0, "Yes", "No") – Flags if a product is actively promoted this week.
• Overstock_Alert (Alerts_and_Reports!C3): =IF(Ending_Stock > (Average_Weekly_Demand * 2), "OVERSTOCK", "")
• Stockout_Risk_Alert (Alerts_and_Reports!D3): =IF(Ending_Stock <= Reorder_Point, "STOCKOUT RISK", "")
• Total_Sales_Per_Campaign (Forecast_vs_Actual!C2): =SUMIFS(Weekly_Inventory_Log!D:D, Weekly_Inventory_Log!H:H, "Yes", Weekly_Inventory_Log!B:B, Product_List!A2)

Conditional Formatting

• Ending Stock below Reorder Point: Red fill in Weekly_Inventory_Log.
• Ending Stock exceeds 150% of average weekly demand: Yellow fill.
• Campaign_Active? = "Yes" and Ending_Stock is below projected units: Bold red text in both Campaign_Timeline and Weekly_Inventory_Log.
• Total_Sales_vs_Project comparison (Forecast_vs_Actual): Data bars for actual vs. projected sales.

User Instructions

1. Populate the Product_List sheet with all SKUs, including reorder points and average weekly demand based on historical data.
2. In the Campaign_Timeline, define each marketing initiative, including expected units to sell and dates.
3. Daily, update the Weekly_Inventory_Log with sales figures (from POS or e-commerce), received shipments, and any adjustments (damages, returns).
4. Use the dropdown in column H to mark if a product is part of a current campaign.
5. The dashboard sheet (Weekly_Plan_Summary) updates automatically. Review alerts daily for stockout risks or overstock warnings.
6. If an alert triggers, consult the Campaign_Timeline and adjust marketing spend or initiate restocking immediately.
7. Export weekly reports from the Alerts_and_Reports sheet to stakeholders before Friday EOD.

Example Rows

Product_List:

Recommended Charts and Dashboards

• Doughnut Chart: “Inventory Health by Category” – Visualizes % of products in stockout risk (red), optimal (green), or overstocked (yellow).
• Clustered Column Chart: “Projected vs. Actual Sales per Campaign” – Tracks campaign success and inventory accuracy.
• Line Chart: “Weekly Inventory Trends for Top 5 SKUs” – Shows daily fluctuations to detect anomalies or sudden spikes.
• KPI Tiles on Weekly_Plan_Summary: - Total Campaigns Active: [Value] - Products at Stockout Risk: [Count] - Units Sold This Week: [Total] - Inventory Coverage Days: [Avg. Days]

This Weekly Marketing Plan with Stock Control template bridges the gap between promotional ambition and logistical reality. By embedding inventory logic directly into campaign planning, marketers can confidently launch campaigns knowing their products are available — while operations teams gain real-time visibility into demand spikes driven by marketing activity. This synergy prevents lost sales, reduces warehousing costs, and maximizes ROI on every advertising dollar spent.