Marketing Plan - Product Inventory - Weekly

Download and customize a free Marketing Plan Product Inventory Weekly Excel template. Perfect for business, legal, and personal use. Editable and ready to boost your productivity.

Week	Product ID	Product Name	Category	Stock Quantity Sales Target Sales Achieved Difference Marketing Channel Budget Allocated ($) Budget Spent ($) ROI (%) Status

Weekly Marketing Plan - Product Inventory Excel Template

This comprehensive Excel template is specifically designed for marketing teams requiring real-time visibility into product inventory levels alongside weekly campaign performance. As a Weekly Marketing Plan integrated with a detailed Product Inventory system, this template enables marketers to align promotional activities directly with stock availability—ensuring no campaign overcommits on out-of-stock items or underutilizes high-inventory SKUs. The structure supports granular weekly tracking, allowing teams to pivot strategies based on inventory trends and sales velocity.

Sheet Names

Weekly Inventory Tracker: Core data input sheet where weekly inventory counts, sales, and reorder alerts are logged.
Marketing Campaign Log: Tracks planned and executed marketing campaigns linked to specific products.
Sales & Inventory Analysis: Automated dashboard with charts and KPIs derived from the other sheets.
Product Master List: Static reference table containing product details (SKU, category, supplier, cost).
Reorder Alerts: Auto-generated summary of products below reorder threshold.

Table Structures and Columns

All tables use structured Excel Tables (Ctrl+T) for dynamic range expansion and formula referencing.

Weekly Inventory Tracker (Primary Table)

Week Ending	SKU	Product Name	Category	Prior Week Stock
Date (DD/MM/YYYY)	Text (e.g., PROD-001)	Text	Text (e.g., Electronics, Apparel)	Number	This Week Received
This Week Sold	This Week Stock On Hand	Reorder Flag?	Campaign ID Linked
Number (calculated)	Number (calculated)	Yes/No (formula-based)	Text or Link to Campaign Log

Marketing Campaign Log

Campaign ID	Campaign Name	Start Date	End Date
Text (e.g., CAM-2024-W17)	Text	Date (DD/MM/YYYY)	Date (DD/MM/YYYY)
Channel	Target Product(s)	Status
Text (Email, Social, PPC)	Text (comma-separated SKUs)	Dropdown: Planned / Active / Completed / Paused

Product Master List

SKU	Name	Category
Text (Primary Key)	Text	Text (Dropdown)
Cost Per Unit ($)	Safety Stock Level
Number	Number (e.g., 10 units)

Key Formulas Required

In This Week Stock On Hand: =Prior_Week_Stock + This_Week_Received - This_Week_Sold
In Reorder Flag?: =IF(This_Week_Stock_On_Hand < Product_Master!Safety_stock, "Yes", "No")
In Sales Velocity (Weekly): =This_Week_Sold / IF(Prior_Week_Stock>0, Prior_Week_Stock, 1) * 100 (as %)
In Reorder Alerts: =FILTER(Weekly_Tracker!A:E, Weekly_Tracker!G:G="Yes", "No alerts")
In Campaign ROI: =SUMIFS(Weekly_Tracker!D:D, Weekly_Tracker!I:I, "*"&Campaign_Log!A2&"*") / Campaign_Log!F:F (Sales Revenue / Budget)

Conditional Formatting Rules

Red Highlight: Cells in “This Week Stock On Hand” where value < Safety Stock Level.
Yellow Highlight: “Reorder Flag?” = Yes.
Green Fill: Campaign Status = "Active" in the Marketing Campaign Log.
Icon Sets: Applied to Sales Velocity column: 3 icons (down arrow, flat, up arrow) based on percentile (25th/75th).

User Instructions

How to Use This Template:

Update the Product Master List once with all SKUs, safety stock levels, and supplier details.
Each Monday, enter new data into the Weely Inventory Tracker: update “This Week Received” and “This Week Sold” for each SKU.
In the Marketing Campaign Log, link each campaign to one or more SKUs using their Product IDs (e.g., PROD-001,PROD-022).
Do not edit formulas in the “This Week Stock On Hand” or “Reorder Flag?” columns—they are automated.
Check the Reorder Alerts sheet weekly to identify items requiring restocking before next campaign launch.
The dashboard updates automatically. Review trends: if stock is high but sales are low, consider discount campaigns. If stock is low and velocity high, accelerate replenishment.

Example Rows

Weekly Inventory Tracker - Row Example:

This Week Received:
15/04/2024	PROD-105	Slim Fit T-Shirt Blue	Apparel	87
This Week Sold:

35, 62, 60, Yes, CAM-2024-W15
Interpretation: Only 60 units remain after selling 62. Safety stock is set to 75 → Reorder required. Campaign CAM-2024-W15 drove high sales but risked stockout.

Recommended Charts and Dashboards

The “Sales & Inventory Analysis” sheet includes:

Stacked Column Chart: Weekly inventory vs. weekly sales per category (color-coded by product type).
Line Chart: 4-week trend of average sales velocity across top 10 products.
Donut Chart: % of total inventory allocated to each marketing channel’s target products.
KPI Cards: Total SKUs in stock, Reorder Items Count, Campaign ROI Average, Inventory Turnover Rate (annualized).
Heatmap: Grid of SKUs vs. weeks with color intensity representing sales velocity—quickly spot hot and cold products.

This template bridges the critical gap between marketing execution and inventory reality. By using a Weekly Marketing Plan that dynamically responds to Product Inventory levels, teams eliminate wasted ad spend on unavailable goods and capitalize on stock surpluses through targeted promotions. The result: smarter decisions, fewer stockouts, increased ROI, and operational harmony between marketing and supply chain.

⬇️ Download as Excel ✏️ Edit online as Excel

Create your own Excel template with our GoGPT AI prompt:

GoGPT