Today's Agent Skill: Product and Service Profitability Analyzer
What It Does
Most small business owners know their revenue but don't know which products or services are actually profitable once labor, materials, and overhead are factored in. A product line that looks like a winner on gross revenue might be draining resources when true costs are accounted for. An AI agent can take your revenue and cost data and produce a clear profitability ranking in minutes, without requiring any spreadsheet expertise.
How It Works
The skill accepts a list of your products or services, their selling prices, and their associated costs (materials, labor time, overhead allocation), then calculates gross margin, contribution margin, and a profitability rank for each item. It surfaces the two or three items to double down on and the one or two that may be costing more than they earn.
How to Deploy It
Drop the SKILL.md into your agent's skills folder and trigger it with "analyze my product profitability." Works with Claude Code, Gemini CLI, Cursor, and Windsurf. For a live dashboard, export to Google Sheets or connect your point-of-sale data using Shopify Analytics (shopify.com), Square Analytics (squareup.com), or QuickBooks Online's Profit and Loss by product class.
SKILL.md — Ready to Deploy
## Description
Calculates and ranks the profitability of a small business's products or services by computing gross margin, contribution margin, and net margin from user-provided revenue and cost data, then identifies top performers and underperformers with plain-language recommendations.
## Trigger
User types "analyze my product profitability", "which products make me the most money", or "rank my services by margin."
## Input
- products: A list of products or services, each with:
- name: Product or service name
- price: Selling price per unit or per job
- material_cost: Cost of materials or COGS per unit (enter 0 if none)
- labor_hours: Hours of labor required per unit or job
- hourly_labor_rate: Fully loaded hourly cost of labor including wages, payroll taxes, and benefits estimate
- units_sold_per_month: Average monthly volume
- monthly_overhead: Total fixed monthly overhead to allocate (rent, utilities, insurance, software) — optional
- overhead_allocation_method: revenue-weighted or unit-weighted (default: revenue-weighted)
## Steps
1. For each product, calculate:
a. Gross Profit = price - material_cost - (labor_hours x hourly_labor_rate)
b. Gross Margin %Copy the full SKILL.md and drop it into your agent's skills directory to activate this skill.