Building a Custom Cost of Goods Spreadsheet

Every successful business owner needs a clear understanding of their Cost of Goods Sold (COGS) — and the right spreadsheet can make it easy to track and manage. In this hands-on class, we will provide you with a customizable pivot table and teach you how to build a functional spreadsheet that helps you calculate the true cost of your products or menu items.

We’ll walk through how to:

• List and organize ingredients, materials, and packaging costs
• Calculate unit and batch costs accurately
• Factor in labor and overhead expenses
• Use formulas to automatically update totals and profit margins
• Turn your spreadsheet into a pricing tool for your business decisions

By the end of this class, you’ll have a custom Cost of Goods spreadsheet that fits your unique business — whether you’re running a food business, product line, or service-based company.

Perfect for small business owners, makers, food entrepreneurs, and anyone ready to take control of their numbers and price with confidence.