{"product_id":"soap-business-cost-calculator","title":"Soap Making Business Planner Spreadsheet","description":"\u003cp\u003eThis soap business planner answers the question every soap maker eventually asks: what does one bar really cost in materials? It links your batches to the oils, lye, fragrance and wrappers that went into them, then divides by the bars that came out of the mold, with the bookkeeping kept in the same workbook.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eBatches and what went into them\u003c\/h2\u003e\u003cp\u003eMost soap templates keep the recipe and the order form apart, so the cost per bar still ends up on paper. Here the two are joined, and the sheet works as a soap cost calculator and batch tracker at once.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e120 batches, each with its price, date and status\u003c\/li\u003e\n\u003cli\u003e300 component lines, each tagged to a batch from a dropdown\u003c\/li\u003e\n\u003cli\u003eFive batch states, from Planned to Sold out\u003c\/li\u003e\n\u003cli\u003eCost per batch summed from its components, then cost per bar calculated\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eIn the worked example, a bar of oatmeal and honey comes to 0.69 in materials.\u003c\/p\u003e\u003ch2\u003eMargin per batch\u003c\/h2\u003e\u003cp\u003eEach batch is compared with the price you charge. The margin shows red under 40% and green over 60%, so a rise in the price of a fragrance oil appears as a color change before it reaches the bank account. An if it all sells figure, bars made times price less what they cost, is shown per batch and totaled, which makes the sheet a simple profit calculator for every recipe.\u003c\/p\u003e\u003ch2\u003eOne honest note about cost\u003c\/h2\u003e\u003cp\u003eThe cost here is materials only. It does not include your time, and the tab says so. A 90% materials margin is not a 90% business, so treat this number as a guide to which batches are worth making rather than your full profit.\u003c\/p\u003e\u003ch2\u003eThe whole ledger behind it\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eIncome and Expenses:\u003c\/strong\u003e both registers for the business\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eInventory:\u003c\/strong\u003e soap inventory and stock on hand\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eMonthly, Quarterly and Profit and Loss:\u003c\/strong\u003e the totals by period\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBalances and Dashboard:\u003c\/strong\u003e the overall picture\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eStart Here and Setup:\u003c\/strong\u003e setup in a few minutes\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you copy, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eTwo Excel files: a worked example with eight real batches from planned to sold out, costed down to the wrapper, and a blank copy\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready as soon as payment clears. The planner is for personal and business use on your own devices, so please do not share or resell the files. Questions? Reach us through our contact page.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDo I need Excel, or can I use Google Sheets?\u003c\/h3\u003e\u003cp\u003eEither. The download has Excel files for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to copy the Google Sheets versions with a free Google account.\u003c\/p\u003e\u003ch3\u003eHow does it calculate cost per bar?\u003c\/h3\u003e\u003cp\u003eEvery component line is tagged to a batch. The sheet sums the components for each batch and divides by the number of bars made.\u003c\/p\u003e\u003ch3\u003eDoes the cost include my time?\u003c\/h3\u003e\u003cp\u003eNo. The cost is materials only, and the tab says so. Your time is not part of the figure.\u003c\/p\u003e\u003ch3\u003eCan I see where each batch stands?\u003c\/h3\u003e\u003cp\u003eEach batch has one of five states, running from Planned to Sold out, so you can see where every batch stands.\u003c\/p\u003e\u003ch3\u003eIs there bookkeeping as well?\u003c\/h3\u003e\u003cp\u003eYes. There are income and expense registers, inventory, monthly and quarterly totals, a profit and loss and a dashboard.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597866532958,"sku":"OPX-120","price":27.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/soap-business-cost-calculator-01.jpg?v=1790832612","url":"https:\/\/opxviashop.com\/products\/soap-business-cost-calculator","provider":"OPXVIA","version":"1.0","type":"link"}