How to Track Wreath Supply Inventory and Costs

You open your craft-room cabinet to start a new football wreath. There are three half-used ribbon rolls, a box of signs, a pile of mesh remnants, and enough floral picks to make a dozen projects—or perhaps only three. You do not really know until you start searching.

That is where tracking wreath supply inventory and costs becomes useful. You do not need to run a giant warehouse to benefit from knowing what materials you have, how much they cost, and when you should buy more.

This guide shows how to create a simple system for ribbon, deco mesh, wreath frames, signs, picks, sprays, ornaments, and other wreath supplies. We will also explain what happens when those materials become a finished wreath, why unused stock is different from money spent, and how to use a free Excel tracker.

Quick Answer: How Do You Track Wreath Supply Inventory?

Make a list of each supply, choose a consistent unit of measurement, record its beginning quantity and unit cost, add new purchases, and subtract the quantities used in wreaths. Then periodically count what is physically on your shelves and reconcile any differences. Use a separate record for finished wreaths, especially those that have not sold.

The basic inventory equation is: Beginning Quantity + Purchases ? Quantity Used + or ? Adjustments = Ending Quantity. A simple spreadsheet can do this math automatically.

Why Wreath Makers Should Track Their Supplies

It is easy to think of inventory as something only large stores need. But if you sell finished wreaths, the materials you purchase are business resources. Every roll of wired ribbon and every wreath sign represents cash you spent and may be able to use in a future sale.

A supply-tracking system can help you:

• Know what you actually own. Stop buying another roll of navy ribbon just because you cannot find the first one.
• Calculate more accurate material costs. A wreath that uses five yards of ribbon should be charged for those yards, not for the full retail value of a partially used roll.
• Reduce overbuying. Identify colors, sports themes, signs, and decorations that have sat unused.
• Prevent shortages. Notice when a popular frame or ribbon color is running low.
• Plan seasonal purchases. See how much of last football season’s inventory is still available before ordering for the next season.
• Improve financial reports. Distinguish supply purchases, materials used, unsold finished wreaths, and actual costs associated with sales.

The goal is not to spend every evening entering measurements. It is to develop a practical system that gives you reliable information when you need it.

Step 1: Decide Which Supplies to Track

Start with materials that become part of your finished products. They usually deserve the most attention because their quantities and prices affect the cost of each wreath.

Supply Category	Examples	Useful Tracking Unit
Ribbon	Wired ribbon, decorative ribbon, solids and prints	Yards or feet
Deco mesh	Mesh rolls, poly burlap mesh	Yards or feet
Signs	Metal sports signs, round signs, rectangular signs	Each
Wreath frames	Wire forms, grapevine frames, teardrop bases	Each
Picks and sprays	Floral stems, glitter picks, decorative sprays	Each or stem
Ornaments and attachments	Footballs, decorative accents, foam attachments	Each
Small materials	Chenille stems, glue sticks, wire, zip ties	Each, pack, or estimated allocation

For lower-cost materials such as a dab of glue or a short wire tie, a reasonable consistent method may be more practical than weighing or counting every use. If you purchase a bag of 100 zip ties and normally use 10 per wreath, you can estimate the cost of 10 ties from the bag’s per-tie cost. Record meaningful waste and damaged materials rather than pretending you used none.

Keep other business items in the appropriate separate records. A reusable glue gun, cutting machine, shelving unit, laptop, or printer is not the same thing as ribbon incorporated into a finished wreath. Shipping boxes and tape can also be tracked as packaging stock, but keep them separate from decorative materials so you do not count shipping expenses twice. Tax treatment for equipment and supplies can differ.

Step 2: Choose One Unit of Measurement for Each Item

Consistency is especially important when tracking rolls. If you enter the purchase of one 10-yard roll but subtract five yards when making a wreath, your spreadsheet will immediately become inaccurate because you are mixing units.

If you track ribbon by the yard, record both purchases and usage in yards. A new 10-yard roll adds 10 yards to stock. Cutting four yards for a wreath subtracts four yards, leaving six yards available. A second partial roll can simply be added to the remaining usable yardage for the same exact product.

For an individual wreath sign, use each. For a floral stem, use each or stem. For mesh, yards or feet can work, provided you are consistent. If you buy rolls in different lengths, convert them into the same tracking unit before entering them.

Remember to track different colors, widths, and patterns separately when it matters for design or replenishment. Two rolls of ribbon are not interchangeable just because they are both red.

Step 3: Record the Actual Cost Per Unit

Your supply record should include a unit cost, not merely the total price printed on the receipt. Unit cost makes partial-roll calculations much easier.

Example: A Roll of Wired Ribbon

Suppose you buy a 10-yard roll of crimson wired ribbon for $8.50. Its cost is $0.85 per yard. If your wreath uses seven yards, that ribbon contributes $5.95 in materials cost.

If a roll of mesh costs $6.50 and contains 10 yards, its basic cost is $0.65 per yard. Using 10 yards adds $6.50 to the wreath. A metal sign costing $5.75 is simply $5.75 each.

Supply	Amount Used	Unit Cost	Cost in Wreath
Crimson ribbon	7 yards	$0.85	$5.95
Navy deco mesh	10 yards	$0.65	$6.50
Metal football sign	1 each	$5.75	$5.75
Grapevine frame	1 each	$4.20	$4.20
White floral picks	4 each	$1.40	$5.60
Football ornaments	2 each	$2.85	$5.70
Total material cost			$33.70

This is the material cost of the sample wreath, not the amount you should charge for it. It does not yet include your time, packing materials, selling fees, shipping, or general business overhead. For the next step, see our wreath pricing for profit guide.

What About Shipping Charges From Your Supplier?

If the cost of obtaining the materials includes inbound freight or another directly attributable purchasing cost, that may need to be included in an appropriate inventory cost calculation. For example, a $8.50 roll plus $1.50 of properly allocated inbound shipping would cost $10 for 10 yards, or $1 per yard. Use a consistent policy and keep the original invoices.

Important: Unit costs may change between purchases. The free beginner tracker lets you enter your current cost per tracking unit, but it does not automatically maintain a formal FIFO, weighted-average, or other tax inventory valuation method. A business with significant inventory should work with an accountant on the cost method used for financial statements and taxes.

Step 4: Use a Simple Inventory Balance Formula

Once you know the units, the quantity calculation is straightforward.

Beginning Quantity + New Purchases ? Quantity Used + or ? Adjustments = Ending Quantity

Imagine starting the month with 18 yards of red wired ribbon. You buy 12 more yards and use a total of 12 yards making wreaths. With no adjustments, the ending quantity is 18 yards.

At an illustrative cost of $0.85 per yard, those 18 remaining yards have an estimated stock value of $15.30.

You can use the same formula for signs, frames, picks, and ornaments. The key is to document all the movement: stock received, stock used, and corrections such as damage or discovered shortages.

Step 5: Record Purchases When New Supplies Arrive

For every meaningful inventory purchase, record its date, supplier, item name or SKU, quantity, price, and invoice number or receipt reference. Check the items when they arrive. A shipment may contain the wrong color, a damaged sign, or fewer pieces than the invoice lists.

Use an identifiable SKU or simple code. For example, RIB-RED-15 could identify a particular crimson ribbon in your personal supply system. You do not need a sophisticated retail barcode system; the point is to avoid accidentally combining two different items.

When a purchase includes several products and one shipping charge, decide how to allocate inbound freight appropriately, document the allocation, and avoid adding the same cost again somewhere else. Keep purchase records even if you also save the information in a spreadsheet.

Step 6: Record Supplies Used in Each Wreath

The real value of inventory tracking appears when you connect supplies to finished products. Give each wreath or customer order a simple identifier, such as W001, W002, or a corresponding order number.

As you create a wreath, write down the material quantities used:

• Ribbon: 7 yards
• Mesh: 10 yards
• Metal sign: 1
• Grapevine frame: 1
• Floral picks: 4
• Football ornaments: 2

You can record these as you cut and assemble, or immediately after completing the project while the quantities are fresh in your mind. Either way, try not to wait until the end of a busy month and estimate from memory.

When a mistake ruins a ribbon cut or a mesh piece, record the waste as an appropriate adjustment or usage entry so the shelf quantity stays accurate. For fragile ornaments, also note damaged pieces separately to help identify recurring problems.

Step 7: Keep Unsold Finished Wreaths Separate From Loose Supplies

This is one of the most important distinctions in the entire system. Once ribbon and signs have been attached to a completed wreath, they are no longer loose materials on a shelf. But if the wreath has not sold, its costs do not simply disappear.

Think about two wreaths you made:

Wreath	Materials Used	Status	What to Track
W001 — football wreath	$33.70	Sold	Materials in the sold product
W002 — second football wreath	$25.80	Unsold	Costs tied to a finished wreath still on hand

In both cases, the materials leave your loose supply inventory. But the second wreath is still a product that belongs to the business. Track it as a finished wreath instead of treating those materials as though they belong to a sold product.

The example worksheet separates the materials recorded for a sold wreath from those in a finished wreath still waiting for a buyer. It provides a useful management view, not a complete tax-ready cost-of-goods-sold calculation. Real production costing may also include paid labor, other manufacturing costs, work in process, and adjustments required by your accounting method.

If you want to see how inventory and operating expenses affect the larger picture, visit the Pricing & Profit resource section for related financial guides.

Step 8: Count Your Actual Supplies and Correct Differences

A spreadsheet is only as accurate as the information entered. Once a month, or at another regular interval that fits your business, count the supplies you have and compare them with the balance shown in your tracker.

For ribbon and mesh, measure partial rolls or make a clearly identified estimate when exact measurement is impractical. For signs and frames, count each item. Check tucked-away boxes and supplies reserved for upcoming custom orders before declaring something missing.

If the sheet says you have 14 signs but you physically find only 13, investigate whether one was used without being logged, damaged, returned to a supplier, or put in a different bin. Once you find the reason, make a documented adjustment rather than quietly changing the starting amount.

Helpful habit: Label bins and shelves by supply type, color family, or SKU. The easier stock is to locate, the easier it becomes to count. Organized storage is not merely about creating an attractive craft room—it makes business records more dependable.

Step 9: Decide When to Reorder and When to Stop Buying

Your inventory records can also help you avoid two opposite problems: being unable to fulfill orders and having too much cash tied up in unused materials.

A reorder point is the quantity at which you decide to review or purchase more. A starting approach is to consider how many units you normally use during the supplier’s delivery time, plus a reasonable buffer for uncertainty.

For example, if you typically use four metal signs each week and your supplier usually takes two weeks to replenish stock, you might review your buffer when supply gets near eight signs plus whatever extra reserve is appropriate. The right threshold depends on actual demand, seasonality, supplier reliability, and your available cash.

Be especially cautious about stocking too far ahead for a specific team, color, or holiday theme. Buying a large amount at a discount does not guarantee that it will turn into sales. Keep an eye on slow-moving stock, seasonal leftovers, and designs you no longer make.

That is one reason a monthly purchasing budget and an inventory tracker work better together: the budget limits spending, while the tracker shows what you truly need.

Free Wreath Supply Inventory and Cost Tracker

To make this easier, we created a downloadable Excel workbook designed specifically for wreath makers. It includes realistic sample entries you can replace with your own supplies, plus formulas that do the basic math for you.

Download: Free Wreath Supply Inventory and Cost Tracker (Excel). Upload the included workbook to WordPress first, then replace the placeholder link in this article with the real Media Library URL.

What Is Included in the Worksheet?

• START HERE: A monthly overview of stock value, low-stock items, purchases, material usage, and finished wreaths.
• SUPPLY INVENTORY: Your master list of ribbon, mesh, signs, frames, and other supplies, with automatic ending quantities and restock notices.
• PURCHASES: Record new stock received and the amount paid.
• SUPPLY USAGE: Connect materials to a wreath or order ID and calculate a simple materials-used cost.
• FINISHED WREATHS: Track material costs in completed wreaths and whether the products have sold.

The numbers already in the file are fictional examples, not typical prices or industry benchmarks. Begin by saving a working copy. Replace the examples with your own supply records, and use the same unit and SKU across each tab.

The cost lookup is based on the unit cost entered in your inventory master. If your costs change, update the source cost as appropriate and remember that the beginner workbook does not preserve historic purchase-cost layers automatically. Keep your original receipts and more detailed records where needed.

How to Maintain Your Inventory Without Making It a Full-Time Job

You do not need to count your craft room every single day. Build three short routines.

Every Time You Receive an Order of Supplies

Check what arrived, record the quantity purchased, and store the items in clearly labeled locations. Put receipts or digital invoices where you can find them again.

Every Time You Complete a Wreath

Record the major materials consumed and the wreath’s unique ID. Mark the finished wreath as sold or unsold, and note any damaged or discarded material. Update the record promptly when a wreath sells.

Once a Month

Count your most important stock, review unusually high purchases, compare your records with physical supplies, check the reorder alerts, and save a month-end copy. If you are using the included one-month sample workbook, carry closing quantities into a new period and clear that month’s purchase and usage logs only after saving your previous records.

Common Wreath Inventory Mistakes to Avoid

• Counting rolls and yards as if they are the same thing: Convert purchases and usage into a consistent unit.
• Forgetting partial rolls: A half-used roll can still provide valuable material for another wreath.
• Recording purchases but never recording usage: Your stock balance will rise even though materials are going into products.
• Ignoring unsold finished wreaths: Materials already assembled into a wreath should not also appear as loose supply stock.
• Valuing every supply at its retail selling price: Inventory cost and potential sales revenue are different concepts.
• Counting a supplier freight charge twice: Document whether inbound shipping is already included in unit costs.
• Ignoring scrap and damaged stock: Wasted materials still explain why quantities changed.
• Buying only because something is on clearance: A good discount is not useful if the material sits unused for years.
• Assuming spreadsheet totals are tax deductions: Financial management and tax inventory methods are related, but not interchangeable.

Does a Wreath Maker Have to Keep Inventory for Tax Purposes?

U.S. tax rules are more nuanced than a simple yes-or-no answer. The IRS allows some qualifying small business taxpayers to use certain alternative methods for accounting for inventory, including methods treating qualifying inventory as nonincidental materials and supplies or conforming to their financial accounting records. The rules depend on eligibility and accounting choices.

For example, under one permissible method, goods treated as nonincidental materials and supplies are generally taken into account when used or consumed, and special rules apply to when goods are provided to customers. A wreath seller should not automatically assume that every purchase of ribbon, mesh, or finished merchandise is deductible immediately just because it was paid for.

For authoritative details, read the IRS Tax Guide for Small Business (Publication 334) and the IRS Schedule C instructions. Have a tax professional help choose and apply a consistent method, particularly if you have considerable unsold supplies, work in process, or finished products.

Bottom line: Even if you qualify for simplified tax treatment, maintaining a useful stock record can still help you make better purchasing and pricing decisions.

Final Thoughts: Good Inventory Records Help You Protect Profit

A wreath business can accumulate hundreds or thousands of dollars of ribbon, mesh, signs, ornaments, and frames without the owner knowing exactly what is available. Tracking your supplies does not have to be complicated, but it should be consistent.

Start with the most valuable or frequently used materials. Record their quantities, measure partial rolls in consistent units, track what each wreath consumes, and separate unsold finished products from loose supplies. Review purchasing and stock counts regularly instead of waiting until a big order or busy craft-show season exposes a shortage.

Once you know what is on your shelves and what your wreaths actually cost in materials, it becomes much easier to price wisely, manage spending, and see where your business can improve. For more business education, visit the Wreath Maker Resource Center or our guide to starting a wreath making business.

Frequently Asked Questions About Wreath Supply Inventory And Costs

Educational note: Prices and examples are fictional and are for business planning, not tax advice. This beginner worksheet does not calculate all manufacturing costs, historic inventory valuation layers, formal cost of goods sold, or tax deductions. Maintain original purchase documents and use the accounting method appropriate for your business.