Inventory & Pricing Calculator Spreadsheet for Small Business (Google Sheets & Excel)

Description

Price your products right and always know what's in stock. Enter your materials, labor and fees, and this spreadsheet gives you a suggested price, your real profit per item and your stock levels.

Made for handmade sellers and small product shops. Works in Google Sheets and Microsoft Excel. Instant download.

WHAT IT DOES

✔ Materials: pack price and pack size become cost per unit automatically
✔ Recipes: list what goes into each product and get the material cost per item
✔ Pricing: materials + labor (from your hourly rate) + packaging = total cost
✔ Suggested price from your target profit margin, after selling fees
✔ Real profit and margin at your own price
✔ Stock Log: log what you make and sell. Stock levels update automatically
✔ Low stock alerts for products and supplies
✔ Dashboard: revenue, estimated profit and items sold by month, best sellers, stock value and a restock list
✔ Up to 60 products and 80 materials

HOW IT WORKS

1. Add your materials and supplies
2. Build a recipe for each product
3. Set labor and margin to get your price
4. Log what you make and sell

WHAT YOU GET

• 1 spreadsheet file (.xlsx) with Start Here, Dashboard, Products, Materials, Recipes and Stock Log tabs
• A full example (a small candle shop) to show how it works
• Step-by-step instructions inside the file, including how to open it in Google Sheets

YOU'LL NEED

• A free Google account (Google Sheets) or Microsoft Excel
• Apple Numbers is not supported.

PLEASE NOTE

• This is a digital product. No physical item will be shipped.
• Due to the nature of digital files, returns are not accepted. If you have any trouble, contact me through the Contact page and I'll help.
• Fees and profit are estimates to help you price, not tax or accounting advice.
• For use in your own business. Please don't resell the file.

After payment, your download link appears right away on the order confirmation page and in your email.

Made by Yellowick 💛