How to use Planly Price It Right

Your template lives in your own Google Drive, so the first step is making your personal copy.

1. Open the PDF from your Etsy purchase (Etsy → You → Purchases and reviews → Download files).
2. Click the “Make my copy” button. If you're asked, sign in to your Google account.
3. Google shows a “Copy document” screen. Click the blue “Make a copy” button.
4. Your copy opens. Rename it if you like (click the title in the top-left), e.g. “My Shop Pricing”.

SETUP has three short steps. Everything you enter here is used across the other tabs.

1. STEP 1: under CURRENCY, enter your currency symbol ($, €, £…). It appears next to every price in the template.
2. STEP 2: under SALES TAX PERCENTAGE, enter the rate you charge (for example 8%). Enter 0% if you don't collect sales tax.
3. STEP 3: check the UNITS list. It comes with common units like sheet, bar, unit, ml, g, bag, oz, roll and cup.
4. Add any unit you buy supplies in that isn't listed (yard, skein, lb…) in the next empty row.

MATERIAL LIST & INVENTORY is your supply library. Enter each material once and you can pick it in every product you price.

1. In the MATERIALS column, type the name of each supply (e.g. “Soy wax”, “8 oz jar”, “Cotton wick”). Add an INTERNAL SKU if you use one.
2. Under PRICE, enter what you paid for the pack, and under # OF UNITS how many units it contained.
3. Choose the UNIT from the dropdown (these come from SETUP). UNIT PRICE calculates itself: price divided by number of units.
4. Enter your current INVENTORY (how many units you have), the date in LAST CHECKED, and a MIN. INVENTORY you never want to drop below.
5. Use NOTES for supplier names, links or colors.

The top of MATERIALS turns your list into a quick stock check, so you know what to reorder before you run out.

1. STATUS fills in for each material: In stock, Reorder soon (within 1.5 times your minimum), Time to reorder (at or below your minimum) or Out of Stock.
2. The counters at the top show how many materials are IN STOCK, REORDER SOON, TIME TO REORDER and OUT OF STOCK.
3. INVENTORY VALUE shows what all your supplies on hand are worth, with charts beside it.
4. When you restock or use up supplies, update the INVENTORY number and LAST CHECKED date.

PRICE CALCULATOR prices one product at a time. Start with the basics at the top left.

1. Type the PRODUCT NAME and its SKU.
2. Under HOW MANY PRODUCT DO YOU CREATE WITH 1 BATCH?, enter how many items one batch makes (enter 1 if you make them one at a time).
3. Under HOW DO YOU WANT TO DEFINE THE PRICE?, pick a method: Based on ideal final price, ideal initial net price, ideal net price, ideal profit or ideal profit margin.
4. In SETUP PRICE OPTION, fill in the matching field, for example IDEAL PROFIT MARGIN if you chose “Based on ideal profit margin”.
5. Enter a DISCOUNT percentage if you plan to offer one (or leave it at 0). SALES TAX comes from SETUP automatically.

Planly Price It Right · Price calculator

The four cost tables below the price breakdown add up to your PRODUCT COST: what it really costs you to make one item.

1. RAW MATERIALS COSTS: pick each material from the MATERIALS dropdown and enter the QTY used. UNITS and UNIT PRICE fill in from your material list.
2. LABOR COSTS: name each OPERATION (e.g. “Pouring”, “Packaging”), enter the TIME, choose minutes or hours under UNIT TIME, and enter your HOURLY RATE.
3. EQUIPMENT COSTS: list tools you reuse (molds, a heat gun…), their UNIT COST, and under AMORTIZATION how many uses you want to spread that cost over.
4. OTHER COSTS: anything else, like labels, boxes or shipping supplies: the ITEM, # OF ITEM and UNIT COST.
5. In each table, tick PER UNIT? if the amount you entered is for one product. Leave it unticked if it's for the whole batch. The template divides it by your batch size.

Once your costs are in, the top of the tab shows your price. You never type here. It's all calculated.

1. SELLING PRICE is the final price your customer pays, including sales tax. NET PRICE is what you receive before tax.
2. REAL PROFIT shows how much of the net price you keep after product costs.
3. PRICE BREAKDOWN lists MATERIALS, LABOR, EQUIPMENTS, OTHER, PRODUCT COST, PROFIT, INITIAL NET PRICE, DISCOUNT, NET PRICE, SALES TAX and FINAL PRICE.
4. Not happy with the result? Change your pricing method or the value in SETUP PRICE OPTION and watch the breakdown update.

OTHER PERSPECTIVE QUESTIONS at the bottom of the tab help you test ideas before you change your price.

1. QUESTION 1: enter a net price under IF I WANT TO SELL (NET PRICE) MY PRODUCT to see what your profit and profit margin would be.
2. QUESTION 2: enter a profit goal under IF I WANT TO MAKE to see how many units you need to sell, with and without your discount.
3. QUESTION 3: enter an amount under IF I REDUCE MY PRODUCTION COST BY to see your new profit and margin.
4. QUESTION 4: enter a margin under IF I CHANGE MY PROFIT MARGIN TO to see the net price it would take.

PRICE CALCULATOR holds one product at a time, so save each finished price to PRICE LIST before you start the next one.

1. Open PRICE LIST. The first row always shows the product currently on PRICE CALCULATOR, with today's DATE.
2. Select that row from the PRODUCT column to FINAL PRICE (B9 to Q9) and copy it.
3. Click the next empty row below, right-click and choose Paste special → Values only. This saves the numbers so they don't change.
4. Fill in QTY SOLD as you sell, and TOTAL PROFIT shows what that product has earned you. Add NOTES for anything worth remembering.
5. Go back to PRICE CALCULATOR, clear the product details and cost rows, and price your next product.

Planly Price It Right · Price list