Browse categories
Explore
Fiverr Pro
English
$
USD
I will build a custom product costing cogs in excel or google sheets
Excel automation and dashboards, professional websites, and custom web app
Hi, I'm Yogi, a freelancer from Indonesia. I build Excel solutions (formulas, dashboards, and data-entry systems), clean, fast websites, and custom web applications such as ERP, inventory, and interna...
About this Gig
Do you know exactly how much each of your products costs to make? A wrong cost means a wrong selling price and lost profit.
I build a custom product costing (COGS / HPP) spreadsheet that calculates your real cost per batch and per unit automatically, so you can set prices with confidence.
WHAT YOU GET
- Ingredient and material price master (update a price once, every recipe updates)
- Recipe costing with yield and waste
- Cost per batch, per unit and per pack
- Labor, packaging and overhead costs
- Profit margin and selling price calculator, with an optional VAT switch
- Duplicate the recipe tab to cost as many products as you like
- Clean layout with dropdowns and color-coded input cells
- Works in Excel or Google Sheets
BUILT WITH
VLOOKUP, INDEX/MATCH, IF and IMPORTRANGE (to sync prices across files), so the sheet stays accurate and easy to maintain.
PERFECT FOR
Food and beverage, bakery, crafts, cosmetics, apparel, small manufacturers and online sellers.
WHY ME
I spent 7 years as the IT lead of a food business and built its ERP, so I understand real costing workflows, not just formulas.
Send me your product list and I will tailor the sheet to your workflow.
Platform:
Excel
•
Google Sheets
•
Microsoft Office
Development technology:
Excel
•
VLOOKUP
My Portfolio
FAQ
Can I add more products myself?
Yes. Duplicate the recipe tab, replace the ingredients and quantities, and all formulas carry over automatically. You can cost as many products as you like.
What does "products filled in" mean in the packages?
It is the number of your products I enter for you at the start. You can add more yourself anytime, or order the Extra product entry add-on and I will do it.
Do you deliver Excel or Google Sheets?
Either one, one format per order. Tell me which you use. Price sync between files (IMPORTRANGE) works in Google Sheets only.
Can I use my own currency, units and cost items?
Yes. I set up your currency, units (kg, g, pcs) and cost items such as labor, packaging and overhead to match how your business works.
What do I need to send you?
Your product list, ingredients or materials with quantities per recipe, and current prices. Photos, notes or a simple file are fine. I will ask if anything is unclear.
Can I edit the sheet myself later?
Yes. Input cells are color coded and formulas are visible. Business and Pro System packages include a short guide, and a video tutorial is available.
Is my data kept private?
Yes. I only use your recipes and prices to build your sheet and I do not share them with anyone.
