Canning Business Cost and Profitability Analysis Worksheet - Ingredient, Jar, Equipment, Labor & Sales Cost Summary

Sep 3, 2026

Upload by Tawan

Canning business cost and profitability analysis worksheet for calculating per-batch and per-jar economics. It structures ingredient costs by amount purchased, estimated batches, and cost per batch; separates jar costs when jars are sold rather than reused; and adds durable supply and equipment ownership costs with original cost and expected batch life. It further estimates equipment operating costs, labor hours and optional labor cost, then consolidates totals into variable costs, total costs, breakeven price per jar, and sales revenue. Profitability analysis computes net returns and the minimum batches needed to recover initial durable supply and equipment costs.

LanguageEnglish

CategoryForms

FormatPDF

Pages10

Reading Time4 min

AccessFree to download

Specifications

Ingredient Costs

Jar Costs

Durable Supply & Equipment Ownership Costs

Equipment Operating Costs

Labor Hours

Cost Summary

Sales Revenue

Profitability Analysis

| SPECIFICATIONS | | | | | | | --- | --- | --- | --- | --- | --- | | Product Name: | | | | Jar Size: | | | Method: | | | | Jars / Batch: | | | | | | | | | | INGREDIENT COSTS | | | | | | | Ingredient | | Amt Purchased | Purchase Cost | Nbr Batches | Cost / Batch | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Total | | | | | | List ingredients, amount purchased, and cost of purchase. Estimate the number of batches you could make from the amount purchased. Divide the cost of purchase by the number of batches to obtain the cost per batch for each ingredient. Sum the cost per batch for each ingredient to obtain the total ingredient costs per batch. | | | | | | | | | | | | | | JAR COSTS | | | | | | | Item | | Amt Purchased | Purchase Cost | Nbr Batches | Cost / Batch | | | | | | | | | | | | | | | | | Total | | | | | | Fill in this table if the jars will be sold and not returned. List jar items (including jar size, lids, bands, and labels) along with the amount purchased and cost of purchase for each. Calculate the number of batches you could make with the amount purchased. Divide the cost of purchase by the number of batches to obtain the cost per batch. Sum the cost per batch for each item to obtain the total jar costs per batch. If you will reuse jars for multiple batches, leave this section blank and enter jar costs in the durable supply section below. | | | | | | | | | | | | | | DURABLE SUPPLY & EQUIPMENT OWNERSHIP COSTS | | | | | | | Item | | | Original Cost | Nbr Batches | Cost / Batch | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Total | | | | | | Durable supplies and equipment are tools that will be used for multiple batches before being replaced. List durable supply and equipment ownership costs that are incurred for the canning business. Enter the original cost (purchase price) and the number of batches you expect to produce (of all products) with the tool before replacing it. Divide the original cost by the number of batches to get the cost per batch. If you will (re)sell the item after using it, subtract the resale value from the original cost before dividing by the number of batches. If the tool would be owned with or without the canning business, no cost needs to be entered for the item here. Sum the cost per batch for each item to obtain the total supply costs per batch. | | | | | | | | | | | | | | EQUIPMENT OPERATING COSTS | | | | | | | --- | --- | --- | --- | --- | --- | | Item | | Operating Unit | Cost / Unit | Units / Batch | Cost / Batch | | | | | | | | | | | | | | | | | Total | | | | | | List the equipment items that have operating (power) costs. Enter the operating unit (the unit on which operating costs are assessed), the cost per operating unit, and the number of operating units used per batch. Multiply the cost per unit by the units per batch to obtain the cost per batch. Sum the cost per batch for each item to obtain the total equipment operating costs per batch. | | | | | | | | | | | | | | LABOR HOURS | | | | | | | Activity | | | | Hours / Batch | Cost / Batch | | | Preparation time | | | | | | | Processing time | | | | | | | Marketing time | | | | | | | Total | | | | | | Estimate labor hours per batch, broken down by preparation, processing, and marketing time. Sum the hours for each to get the total labor hours. If any labor is paid, list the labor costs and sum to obtain the total labor cost per batch. Otherwise, leave cost column blank. | | | | | | | | | | | | | | COST SUMMARY | | | | | | | Item | | | | | Total / Batch | | | Ingredient costs | | |

FAQs

How are ingredient costs and cost per batch calculated?

List each ingredient, the amount purchased, its purchase cost, and estimate how many batches can be made. Divide purchase cost by number of batches to get cost per batch, then sum across ingredients for total ingredient cost per batch.

When should the Jar Costs section be filled in?

Fill Jar Costs in when jars are sold and not returned. Include jar size, lids, bands, and labels, calculate batches from purchased amounts, compute cost per batch for each item, and sum to get total jar costs per batch.

How is breakeven price per jar determined in the cost summary?

Compute variable costs per batch as the sum of ingredient, jar, equipment-operating, and labor costs per batch. Compute total costs per batch as the sum of all five cost types, then divide costs per batch by the number of jars per batch to obtain the breakeven price per jar.

Sep 3, 2026

Upload by Tawan