{"id":19410,"date":"2026-05-27T23:34:37","date_gmt":"2026-05-27T16:34:37","guid":{"rendered":"https:\/\/beup.space\/product\/wine-production-cost-calculator\/"},"modified":"2026-05-28T19:59:28","modified_gmt":"2026-05-28T12:59:28","slug":"wine-production-cost-calculator","status":"publish","type":"product","link":"https:\/\/beup.space\/en\/product\/wine-production-cost-calculator\/","title":{"rendered":"Wine Production Cost Calculator \u2014 Per-Bottle COGS"},"content":{"rendered":"
\n
\ud83c\udf77 NEW \u00b7 LIVE DASHBOARD<\/div>\n

Open the Live Dashboard \u2014 View KPIs on the Web<\/h3>\n

Same workbook data, presented as KPIs for cost per bottle \u00b7 cost structure \u00b7 margin by price and channel. VI\/EN toggle, mobile-ready, no install.<\/p>\n

Open BEUP Canvas Live Demo \u2192<\/a>\n<\/div>\n

Wine Production Cost Calculator<\/strong> \u2014 Excel + Google Sheets with 9 linked sheets that lets boutique\/small-batch wineries, craft producers and F&B consultants know the true cost per bottle (750 mL)<\/strong> after every cost and shrinkage.<\/p>\n

Models wine economics correctly: barrels allocate by uses (new vs neutral oak), shrinkage in multiple stages (angel's share, racking, spillage), margin analysis across 5 price points \u00d7 4 sales channels. VI (\u20ab\/L, Dalat winery sample data) + EN ($\/gal) editions.<\/p>\n

\n
\n9 Linked Sheets<\/strong><\/summary>\n
    \n
  • \ud83c\udf77 Cover<\/strong> \u2014 table of contents + quick-start guide<\/li>\n
  • \ud83d\udcd6 Instructions<\/strong> \u2014 step-by-step usage + color conventions for input vs formula cells<\/li>\n
  • \u2699\ufe0f Settings<\/strong> \u2014 grape varietal \/ wine type \/ barrel type dropdowns + yield (L\/ton) and liter-to-bottle constants<\/li>\n
  • \ud83c\udf47 Grape & Materials<\/strong> \u2014 enter grape, labor, barrels & aging, additives, bottling, lab, and facility costs<\/li>\n
  • \ud83e\uddee Cost Calculator<\/strong> \u2014 auto-sums 7 cost groups \u2192 cost per bottle after shrinkage<\/li>\n
  • \ud83d\udcb0 Margin Analysis<\/strong> \u2014 5 retail price points \u00d7 4 sales channels, gross margin %<\/li>\n
  • \ud83d\udcca Dashboard<\/strong> \u2014 unit economics KPIs + cost\/margin charts<\/li>\n
  • \u2753 FAQ<\/strong> \u2014 6 common questions (no-barrel production, allocation, shrinkage, multi-vintage)<\/li>\n
  • \ud83d\uddd2\ufe0f Version Log<\/strong> \u2014 release notes<\/li>\n<\/ul>\n<\/details>\n
    \nWhy Get COGS Right?<\/strong><\/summary>\n

    Self-made Excel is prone to errors: calculating oak barrels once instead of allocating according to the number of uses, forgetting to deduct 7-10% shrinkage \u2192 lower virtual cost than actual, pricing based on intuition and losing on wholesale channels. This tool modeling the true nature of the wine industry<\/strong>: allocating barrels based on the number of uses (new oak vs neutral), deducting shrinkage in many stages (evaporation, sediment, spillage).<\/p>\n<\/details>\n

    \nBuilt For<\/strong><\/summary>\n
      \n
    • \ud83c\udf77 Small \/ boutique wineries<\/strong> \u2014 Dalat, Ninh Thuan\u2026 needing the true cost before setting prices<\/li>\n
    • \ud83c\udffa Craft \/ homemade producers<\/strong> \u2014 moving from gut-feel to structured COGS<\/li>\n
    • \ud83d\udcca F&B consultants \/ beverage-industry accountants<\/strong> \u2014 a standard cost model to advise clients<\/li>\n
    • \ud83d\ude80 Wine-business planners<\/strong> \u2014 projecting COGS & gross margin for a business plan<\/li>\n<\/ul>\n<\/details>\n
      \nWhat's Built In<\/strong><\/summary>\n
        \n
      • \u2705 Auto-summed 7 COGS groups into cost per bottle<\/li>\n
      • \u2705 5-price \u00d7 4-channel margin analysis in one sheet<\/li>\n
      • \u2705 Barrel allocation by uses + adjustable shrinkage<\/li>\n
      • \u2705 Formulas wrapped in IFERROR \u2014 empty template never throws #DIV\/0!<\/li>\n
      • \u2705 Centralized Settings with dropdowns for grape varietal \/ wine type \/ barrel type<\/li>\n<\/ul>\n<\/details>\n
        \nCompatibility<\/strong><\/summary>\n
          \n
        • \u2705 Microsoft Excel 2016+ (Windows\/Mac)<\/li>\n
        • \u2705 Google Sheets (live link, multi-user)<\/li>\n
        • \u2705 Fully offline-ready \u2014 no subscription, no server<\/li>\n<\/ul>\n<\/details>\n
          \nWhat's Included<\/strong><\/summary>\n
            \n
          • \ud83d\udcc4 4 .xlsx files: Sample (pre-filled) + Template (blank), both VI & EN<\/li>\n
          • \ud83c\uddfb\ud83c\uddf3 Vietnamese edition: \u20ab currency, L\/ton units, Dalat winery sample numbers<\/li>\n
          • \ud83c\uddec\ud83c\udde7 English edition: $ currency, gallon units<\/li>\n
          • \ud83d\udcca Live companion dashboard on BEUP Canvas<\/li>\n
          • \ud83d\udd04 Free updates + email support<\/li>\n<\/ul>\n<\/details>","protected":false},"excerpt":{"rendered":"

            Excel + Google Sheets wine production cost calculator: 9 linked sheets, automatic 7-group COGS, barrel-use allocation, shrinkage adjustment, 5-price \u00d7 4-channel margin analysis. VI (\u20ab\/L) + EN ($\/gal) editions. Download & use offline.<\/p>","protected":false},"featured_media":19427,"comment_status":"open","ping_status":"closed","template":"","meta":{"_product_image_gallery_en":"19422,19423,19424,19425,19426","_thumbnail_id_en":"19428"},"product_brand":[],"product_cat":[63],"product_tag":[347,343,346,344,349,348,345],"topics":[],"integrations":[],"class_list":{"0":"post-19410","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-excel-sheets","7":"product_tag-bien-loi-nhuan-ruou-vang","8":"product_tag-chi-phi-san-xuat-ruou-vang","9":"product_tag-excel-ruou-vang","10":"product_tag-gia-von-ruou-vang","11":"product_tag-google-sheets-ruou-vang","12":"product_tag-quan-ly-chi-phi-winery","13":"product_tag-tinh-gia-thanh-moi-chai","14":"pa_industry-f-and-b","15":"pa_industry-manufacturing","16":"pa_ngon-ngu-en","17":"pa_ngon-ngu-vi","18":"pa_ngon-ngu-bundle","20":"first","21":"instock","22":"taxable","23":"shipping-taxable","24":"purchasable","25":"product-type-variable"},"yoast_head":"\nWine Production Cost Calculator \u2014 Per-Bottle COGS - BEUP<\/title>\n<meta name=\"description\" content=\"Excel + Google Sheets t\u00ednh gi\u00e1 th\u00e0nh m\u1ed7i chai r\u01b0\u1ee3u vang: 9 sheet, COGS t\u1ef1 \u0111\u1ed9ng, ph\u00e2n b\u1ed5 th\u00f9ng s\u1ed3i, tr\u1eeb hao h\u1ee5t, ph\u00e2n t\u00edch bi\u00ean 5 gi\u00e1 \u00d7 4 k\u00eanh. VND\/L\u00edt. 499k.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/beup.space\/en\/product\/wine-production-cost-calculator\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Wine Production Cost Calculator \u2014 Per-Bottle COGS - BEUP\" \/>\n<meta property=\"og:description\" content=\"Excel + Google Sheets t\u00ednh gi\u00e1 th\u00e0nh m\u1ed7i chai r\u01b0\u1ee3u vang: 9 sheet, COGS t\u1ef1 \u0111\u1ed9ng, ph\u00e2n b\u1ed5 th\u00f9ng s\u1ed3i, tr\u1eeb hao h\u1ee5t, ph\u00e2n t\u00edch bi\u00ean 5 gi\u00e1 \u00d7 4 k\u00eanh. VND\/L\u00edt. 499k.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/beup.space\/en\/product\/wine-production-cost-calculator\/\" \/>\n<meta property=\"og:site_name\" content=\"BEUP\" \/>\n<meta property=\"article:modified_time\" content=\"2026-05-28T12:59:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/beup.space\/wp-content\/uploads\/2026\/05\/canvas-dashboard-4-scaled.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1710\" \/>\n\t<meta property=\"og:image:height\" content=\"2560\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/beup.space\\\/product\\\/wine-production-cost-calculator\\\/\",\"url\":\"https:\\\/\\\/beup.space\\\/product\\\/wine-production-cost-calculator\\\/\",\"name\":\"Wine Production Cost Calculator \u2014 Per-Bottle COGS - BEUP\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/beup.space\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/beup.space\\\/product\\\/wine-production-cost-calculator\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/beup.space\\\/product\\\/wine-production-cost-calculator\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/beup.space\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/canvas-dashboard-4-scaled.png\",\"datePublished\":\"2026-05-27T16:34:37+00:00\",\"dateModified\":\"2026-05-28T12:59:28+00:00\",\"description\":\"Excel + Google Sheets t\u00ednh gi\u00e1 th\u00e0nh m\u1ed7i chai r\u01b0\u1ee3u vang: 9 sheet, COGS t\u1ef1 \u0111\u1ed9ng, ph\u00e2n b\u1ed5 th\u00f9ng s\u1ed3i, tr\u1eeb hao h\u1ee5t, ph\u00e2n t\u00edch bi\u00ean 5 gi\u00e1 \u00d7 4 k\u00eanh. VND\\\/L\u00edt. 499k.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/beup.space\\\/product\\\/wine-production-cost-calculator\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/beup.space\\\/product\\\/wine-production-cost-calculator\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/beup.space\\\/product\\\/wine-production-cost-calculator\\\/#primaryimage\",\"url\":\"https:\\\/\\\/beup.space\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/canvas-dashboard-4-scaled.png\",\"contentUrl\":\"https:\\\/\\\/beup.space\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/canvas-dashboard-4-scaled.png\",\"width\":1710,\"height\":2560,\"caption\":\"Wine Production Cost Calculator \u2014 BEUP Canvas live dashboard (VI)\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/beup.space\\\/product\\\/wine-production-cost-calculator\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/beup.space\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"S\u1ea3n ph\u1ea9m\",\"item\":\"https:\\\/\\\/beup.space\\\/shop\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"C\u00f4ng C\u1ee5 T\u00ednh Chi Ph\u00ed S\u1ea3n Xu\u1ea5t & Gi\u00e1 V\u1ed1n R\u01b0\u1ee3u Vang (COGS)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/beup.space\\\/#website\",\"url\":\"https:\\\/\\\/beup.space\\\/\",\"name\":\"BEUP\",\"description\":\"Just X\u00e2y d\u1ef1ng n\u1ec1n t\u1ea3ng th\u01b0\u01a1ng m\u1ea1i \u0111i\u1ec7n t\u1eed b\u00e1n s\u1ea3n ph\u1ea9m s\u1ed1 (Notion templates, content packs) k\u1ebft h\u1ee3p v\u1edbi gi\u1edbi thi\u1ec7u d\u1ecbch v\u1ee5 t\u01b0 v\u1ea5nWordPress site\",\"publisher\":{\"@id\":\"https:\\\/\\\/beup.space\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/beup.space\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/beup.space\\\/#organization\",\"name\":\"BEUP\",\"url\":\"https:\\\/\\\/beup.space\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/beup.space\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/beup.space\\\/wp-content\\\/uploads\\\/2025\\\/12\\\/logo-final-1536x530-1.png\",\"contentUrl\":\"https:\\\/\\\/beup.space\\\/wp-content\\\/uploads\\\/2025\\\/12\\\/logo-final-1536x530-1.png\",\"width\":1536,\"height\":530,\"caption\":\"BEUP\"},\"image\":{\"@id\":\"https:\\\/\\\/beup.space\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Wine Production Cost Calculator \u2014 Per-Bottle COGS - BEUP","description":"Excel + Google Sheets t\u00ednh gi\u00e1 th\u00e0nh m\u1ed7i chai r\u01b0\u1ee3u vang: 9 sheet, COGS t\u1ef1 \u0111\u1ed9ng, ph\u00e2n b\u1ed5 th\u00f9ng s\u1ed3i, tr\u1eeb hao h\u1ee5t, ph\u00e2n t\u00edch bi\u00ean 5 gi\u00e1 \u00d7 4 k\u00eanh. VND\/L\u00edt. 499k.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/beup.space\/en\/product\/wine-production-cost-calculator\/","og_locale":"en_US","og_type":"article","og_title":"Wine Production Cost Calculator \u2014 Per-Bottle COGS - BEUP","og_description":"Excel + Google Sheets t\u00ednh gi\u00e1 th\u00e0nh m\u1ed7i chai r\u01b0\u1ee3u vang: 9 sheet, COGS t\u1ef1 \u0111\u1ed9ng, ph\u00e2n b\u1ed5 th\u00f9ng s\u1ed3i, tr\u1eeb hao h\u1ee5t, ph\u00e2n t\u00edch bi\u00ean 5 gi\u00e1 \u00d7 4 k\u00eanh. VND\/L\u00edt. 499k.","og_url":"https:\/\/beup.space\/en\/product\/wine-production-cost-calculator\/","og_site_name":"BEUP","article_modified_time":"2026-05-28T12:59:28+00:00","og_image":[{"width":1710,"height":2560,"url":"https:\/\/beup.space\/wp-content\/uploads\/2026\/05\/canvas-dashboard-4-scaled.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/beup.space\/product\/wine-production-cost-calculator\/","url":"https:\/\/beup.space\/product\/wine-production-cost-calculator\/","name":"Wine Production Cost Calculator \u2014 Per-Bottle COGS - BEUP","isPartOf":{"@id":"https:\/\/beup.space\/#website"},"primaryImageOfPage":{"@id":"https:\/\/beup.space\/product\/wine-production-cost-calculator\/#primaryimage"},"image":{"@id":"https:\/\/beup.space\/product\/wine-production-cost-calculator\/#primaryimage"},"thumbnailUrl":"https:\/\/beup.space\/wp-content\/uploads\/2026\/05\/canvas-dashboard-4-scaled.png","datePublished":"2026-05-27T16:34:37+00:00","dateModified":"2026-05-28T12:59:28+00:00","description":"Excel + Google Sheets t\u00ednh gi\u00e1 th\u00e0nh m\u1ed7i chai r\u01b0\u1ee3u vang: 9 sheet, COGS t\u1ef1 \u0111\u1ed9ng, ph\u00e2n b\u1ed5 th\u00f9ng s\u1ed3i, tr\u1eeb hao h\u1ee5t, ph\u00e2n t\u00edch bi\u00ean 5 gi\u00e1 \u00d7 4 k\u00eanh. VND\/L\u00edt. 499k.","breadcrumb":{"@id":"https:\/\/beup.space\/product\/wine-production-cost-calculator\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/beup.space\/product\/wine-production-cost-calculator\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beup.space\/product\/wine-production-cost-calculator\/#primaryimage","url":"https:\/\/beup.space\/wp-content\/uploads\/2026\/05\/canvas-dashboard-4-scaled.png","contentUrl":"https:\/\/beup.space\/wp-content\/uploads\/2026\/05\/canvas-dashboard-4-scaled.png","width":1710,"height":2560,"caption":"Wine Production Cost Calculator \u2014 BEUP Canvas live dashboard (VI)"},{"@type":"BreadcrumbList","@id":"https:\/\/beup.space\/product\/wine-production-cost-calculator\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/beup.space\/"},{"@type":"ListItem","position":2,"name":"S\u1ea3n ph\u1ea9m","item":"https:\/\/beup.space\/shop\/"},{"@type":"ListItem","position":3,"name":"C\u00f4ng C\u1ee5 T\u00ednh Chi Ph\u00ed S\u1ea3n Xu\u1ea5t & Gi\u00e1 V\u1ed1n R\u01b0\u1ee3u Vang (COGS)"}]},{"@type":"WebSite","@id":"https:\/\/beup.space\/#website","url":"https:\/\/beup.space\/","name":"BEUP","description":"Building a digital product e-commerce platform (Notion templates, content packs) with consulting services \u2014 WordPress site","publisher":{"@id":"https:\/\/beup.space\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/beup.space\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/beup.space\/#organization","name":"BEUP","url":"https:\/\/beup.space\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/beup.space\/#\/schema\/logo\/image\/","url":"https:\/\/beup.space\/wp-content\/uploads\/2025\/12\/logo-final-1536x530-1.png","contentUrl":"https:\/\/beup.space\/wp-content\/uploads\/2025\/12\/logo-final-1536x530-1.png","width":1536,"height":530,"caption":"BEUP"},"image":{"@id":"https:\/\/beup.space\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/beup.space\/en\/wp-json\/wp\/v2\/product\/19410","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/beup.space\/en\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/beup.space\/en\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/beup.space\/en\/wp-json\/wp\/v2\/comments?post=19410"}],"version-history":[{"count":2,"href":"https:\/\/beup.space\/en\/wp-json\/wp\/v2\/product\/19410\/revisions"}],"predecessor-version":[{"id":19433,"href":"https:\/\/beup.space\/en\/wp-json\/wp\/v2\/product\/19410\/revisions\/19433"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/beup.space\/en\/wp-json\/wp\/v2\/media\/19427"}],"wp:attachment":[{"href":"https:\/\/beup.space\/en\/wp-json\/wp\/v2\/media?parent=19410"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/beup.space\/en\/wp-json\/wp\/v2\/product_brand?post=19410"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/beup.space\/en\/wp-json\/wp\/v2\/product_cat?post=19410"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/beup.space\/en\/wp-json\/wp\/v2\/product_tag?post=19410"},{"taxonomy":"beup_topic","embeddable":true,"href":"https:\/\/beup.space\/en\/wp-json\/wp\/v2\/topics?post=19410"},{"taxonomy":"beup_integration","embeddable":true,"href":"https:\/\/beup.space\/en\/wp-json\/wp\/v2\/integrations?post=19410"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}