Marketing Plan - Supply List - Home Use
Download and customize a free Marketing Plan Supply List Home Use Excel template. Perfect for business, legal, and personal use. Editable and ready to boost your productivity.
| Item Name | Quantity | Unit Price ($) | Total Price ($) | Purchased From | Date Purchased Status |
|---|---|---|---|---|---|
Home Use Marketing Plan Supply List Excel Template
This comprehensive Excel template is designed specifically for home use individuals or small household-based businesses who are creating a Marketing Plan. Unlike enterprise-level tools, this template simplifies the often overwhelming process of tracking marketing materials and expenditures through an intuitive, user-friendly Supply List. Whether you're selling handmade crafts on Etsy, offering freelance services from home, or promoting a local event like a bake sale or yard sale — this template gives you a clear structure to manage your physical and digital marketing supplies without needing advanced business software.
Sheet Names
The template contains three main sheets:
- Supply List: The core tracking sheet for all marketing materials purchased or used.
- Marketing Plan Summary: A dashboard overview of your spending, goals, and ROI estimates.
- Instructions & Tips: Step-by-step guidance for new users with examples and best practices.
Table Structures & Column Details
The Supply List sheet contains the following structured table:
| Column | Data Type | Description |
|---|---|---|
| Date Purchased | Date (DD/MM/YYYY) | When the item was bought. |
| Item Name | Text | Name of marketing material (e.g., “Flyers - 100 pcs”). |
| Category | Text (Dropdown) | |
| Quantity | Number | Units purchased or used. |
| Unit Cost ($) | Currency | Cost per unit in USD or local currency. |
| Vendor/Source | Text | Where it was bought (e.g., “Staples”, “Canva Pro”, “Etsy Shop”). |
| Status | Text (Dropdown) | < td>Ordered, Received, Used, Expired.|
| Marketing Goal | < td>Text (Dropdown)< td>Increase Brand Awareness, Drive Online Sales, Generate Leads, Event Promotion.||
| Notes | < td>Text< td>Any additional comments (e.g., “Used for weekend farmers market”).
Formulas Required
- Total Cost ($): =D2*E2 (copied down the column) — automatically calculates total expense per item.
- Total Budget Spent (in Marketing Plan Summary): =SUM('Supply List'!F:F) — sums all expenses to show total marketing spend.
- Average Cost Per Item: =AVERAGEIF('Supply List'!F:F,">0") — calculates average expenditure per item, excluding blanks.
- Cost by Category: =SUMIFS('Supply List'!F:F,'Supply List'!C:C,"Printed Materials") — used in the Summary sheet to break down spending by marketing category.
- Items Used vs. Remaining: =COUNTIF('Supply List'!G:G,"Used") / COUNTA('Supply List'!G:G) — shows percentage of supplies utilized, helping track efficiency.
Conditional Formatting
- Red Highlight: Any row where Total Cost exceeds $50 and Status is "Ordered" (to flag over-budget pending purchases).
- Yellow Highlight: Items marked as "Expired" — helps avoid wasted spending on outdated materials.
- Green Highlight: Rows with Status = “Used” and Marketing Goal = “Drive Online Sales” — shows which supplies directly contributed to revenue goals.
- Bold Font: All entries under "Digital Ads" category — visually separates digital from physical expenses.
Instructions for the User
Step 1: Open the “Instructions & Tips” sheet. Read it fully before inputting data.
Step 2: In the “Supply List,” begin by recording every purchase related to your marketing — even small ones like $2 sticky notes for a sign-up board.
Step 3: Use the dropdowns for Category and Status to ensure consistency. This enables accurate filtering and reporting later.
Step 4: After each marketing campaign (e.g., “Spring Etsy Sale”), update the Status column. Did you use all flyers? Were any left over?
Step 5: Check the “Marketing Plan Summary” weekly. It shows your total spend and which categories are most expensive — helping you adjust future budgets.
Step 6: Save a copy each month as “MarketingPlan_March2024.xlsx.” This creates an archive for year-over-year comparison.
Example Rows
| Date Purchased | Item Name | Category | Quantity | Unit Cost ($) | Total Cost ($) | Vendor/Source |
|---|---|---|---|---|---|---|
| 03/01/2024 | Flyers - 150 pcs | Printed Materials | 150 | $0.12 | $18.00 | Snapfish.com |
| 03/15/2024 | Etsy Shop Banner Design | Digital Ads | 1 | $15.99 | < td>$15.99Fiverr (JaneDoeDesign) | |
| 03/20/2024 | Stickers - 50 pcs for gifts | Packaging | < td>50< td>$0.18 < td>$9.00 < th>CrafterSupply.com||||
| 03/28/2024 | Facebook Ad Boost - Local Audience | Digital Ads | < td>1 campaign < td>$35.00 < td>$35.00 < th>Meta Ads Manager
Recommended Charts & Dashboards
The Marketing Plan Summary sheet includes two automatically generated charts:
- Pie Chart: “Marketing Budget Allocation by Category” — Shows how your spending is distributed (e.g., 40% digital ads, 30% printed materials). Helps visualize where your money goes.
- Bar Chart: “Monthly Spend Trend” — If you save monthly copies, this chart plots total cost per month to reveal seasonal patterns or overspending periods.
A small KPI box displays:
- Total Spent: $77.99 (example)
- Items Used: 85%
- Average Cost Per Item: $12.99
- ROI Estimate*: “Estimated 3x return if leads increased by 15%” (user input field)
Why This Template Works for Home Use Marketing
This template bridges the gap between professional marketing strategy and home-based entrepreneurship. It doesn’t assume you have a team or budget — it meets you where you are: using household funds to grow your side hustle. The Supply List keeps things simple, visual, and actionable. By linking each purchase to a specific Marketing Goal (e.g., “Generate Leads”), you’re no longer just buying supplies — you’re strategically investing in growth.
With this Excel template, your home-based marketing becomes measurable, trackable, and repeatable — turning casual efforts into a sustainable business practice.
⬇️ Download as Excel✏️ Edit online as ExcelCreate your own Excel template with our GoGPT AI prompt:
GoGPT