Farmers Market Vendor

The Farmers Market Vendor tracks Products and Pricing - item, category, unit price, unit cost, margin per unit, units sold, revenue, cost of goods, and gross profit for every item. Change a price and the margin and totals update.; Daily Sales Log - date, item, quantity, unit price, unit cost, amount, cost of goods, and market for every sale. Unit price and unit cost are pulled from sheet 1 by formula.; Expenses - market fees, transport and fuel, materials and supplies, packaging, marketing, utilities, and other costs, with a monthly cost for each.; Monthly P and L - revenue, cost of goods, market fees, transport and fuel, materials, packaging, marketing, utilities and other expenses by month, Jan-Dec, with net profit and margin. Revenue and cost of goods are formulas from the Sales Log.; Dashboard - total revenue, units sold, transactions, average sale value, gross profit and margin, expenses, net profit and margin, best and weakest products, revenue by product, costs by category, and units by product..

The included example shows: 12 products; 494 units sold in 39 transactions; total revenue 2,297.00.

Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.