Sari-Sari Store Profit Margin Calculator
Introduction to sari-sari store profit margins
A sari-sari store does not usually fail because of one dramatic mistake. Profit is more often squeezed away by small, familiar leaks: sachets that spoil in the heat, soft drinks that are sold on utang, bread that goes stale before noon, and weekly overhead that keeps ticking even on quiet days. This calculator focuses on those everyday pressures so you can see how they affect a barangay store's bottom line instead of relying on a generic retail margin sheet.
Use it to estimate revenue, wholesale cost, credit loss, and take-home profit over a period you choose. That makes it useful when you are deciding whether to raise the price of a high-turnover item, whether to keep refrigerated drinks on hand during a brownout-prone week, or whether a thin markup is still worth the shelf space once spoilage and unpaid credit are counted.
How to Use the sari-sari store inputs
Begin with the store-wide fields above the product list. Weekly overhead should include the expenses that keep a sari-sari store open whether or not the counter is busy: rent, electricity, ice, transport from the wholesaler, permit fees, and any other fixed cost that comes back every week. Credit default rate is the portion of sales sold on utang that you do not expect to collect. Planning horizon tells the calculator whether you want a one-week checkup or a longer view, such as a month of school days or a quarter before the holidays.
Then fill in one row for each item you want to test. Use the product name as a label only; the numbers are what matter. Enter wholesale price per unit, retail price per unit, units sold per week, spoilage percentage, and the share of sales that go out on credit. Empty rows are ignored, so you can analyze only the staples you care about. The page starts with three product rows already visible, and you can add more until you reach the limit.
- Enter a realistic weekly overhead figure and default rate.
- Add items such as coffee sachets, canned sardines, bread, soft drinks, rice repacks, noodles, or toiletries.
- Estimate weekly units sold before spoilage, then enter spoilage and credit share as percentages.
- Click Evaluate sari-sari margins to see the summary and the itemized table.
After you calculate, read the result from top to bottom. The summary line gives total revenue, total cost, credit losses, net profit before overhead, and take-home profit after overhead. The itemized table shows which products are carrying the store and which ones only look good until spoilage and utang are included. That is often where the best changes show up: cooling drinks more reliably, trimming credit on low-margin staples, or giving more shelf space to items that pay back in cash.
Formula for sari-sari store profit
The calculation follows a simple order once the store terms are separated. For each product, the calculator first reduces weekly units by the spoilage rate to get effective units for the planning period. Revenue is effective units multiplied by retail price. Cost is effective units multiplied by wholesale price. Credit loss is the share of revenue sold on credit multiplied by the default rate. Product profit is revenue minus cost minus credit loss. The calculator then subtracts weekly overhead for the number of weeks you entered to arrive at projected take-home profit.
In plain language, the formula asks a sari-sari question: after you account for stock that goes stale, customers who buy on utang, and the bills that keep the lights on, what is left in cash? A product can look strong on markup alone and still disappoint if it spoils quickly or if too many sales are extended on credit. The MathML block later on the page shows the exact item-by-item structure used here.
Example: coffee, sardines, soft drinks, and bread
Suppose a sari-sari store sells 180 instant coffee sachets a week at ₱8 after buying them at ₱6, with 2% spoilage and 10% credit share. Add 60 cans of sardines at ₱23 with ₱18 wholesale cost, 5% spoilage, and 30% credit share; 90 bottles of soft drinks at ₱22 with ₱16 wholesale cost, 8% spoilage, and 15% credit share; and 50 pieces of bread at ₱15 with ₱11 wholesale cost, 12% spoilage, and no credit. With weekly overhead of ₱1,200 and a 6% default rate, the calculator projects revenue of ₱20,815.20, product-level net profit before overhead of ₱5,048.56, overhead of ₱4,800.00, and take-home profit of ₱248.56 across four weeks.
That result tells a more honest story than markup alone. The store is busy, but the fixed weekly bill is almost swallowing the combined margin. If spoilage on the soft drinks drops to 4% and credit share falls to 5%, the same four-week scenario improves take-home profit by about ₱129.17. The calculator then makes it easy to export the rows as CSV and compare the effect of each change without guessing.
Limitations of the sari-sari profit model
This calculator is practical by design, not a full accounting system. It assumes wholesale and retail prices stay steady during the planning horizon, treats defaults as one average rate, and does not automatically include taxes, owner salary, theft, family consumption, or side services such as e-loading unless you build them into overhead or spoilage yourself. Use it as a planning aid, then compare the output with your notebook, ledger, or POS records so the assumptions stay close to what is actually happening at the counter.
Why sari-sari operators need a specialized calculator
A sari-sari store is not the same as a supermarket aisle. The business is built around sachets, small packs, short selling windows, and customers who may pay later because they already know you. That combination makes profit harder to read by eye. A rack of instant coffee or biscuits can look busy all day and still underperform if some stock softens in the heat or too much of the day's sales gets written down as utang. This calculator gives those small leaks a place in the numbers, so a family store can judge whether it is really earning or just staying busy.
Because the store serves neighbors, relatives, and commuters, the owner often has to balance generosity against survival. Offering credit can preserve goodwill, but the default rate still needs to be part of the math. The calculator combines your estimated credit share and default rate with each item's margin, so you can see how much of the displayed price is likely to make it back into the cash box. It also helps when you are deciding whether a ₱1 price change on a fast-moving sachet is enough to cover power, ice, or delivery costs without pushing regular customers away.
Defining the product inputs
Each row is built around the details that matter most in a sari-sari store. Product name is just your reminder of what the row stands for. Wholesale cost usually comes from a wholesaler, supermarket run, or delivery truck; retail price is what you actually charge per sachet, bottle, or pack; units sold per week is your best estimate of normal traffic; spoilage percentage covers heat damage, expiration, or unsold stock; and credit sales share captures how often you let the item go out on utang. Different goods behave differently: powdered mixes may last, while bread and chilled drinks can lose value quickly. The calculator carries those inputs across the weeks you choose, which is handy when you are planning for school openings, rainy weeks, or holiday demand.
Weekly overhead covers the fixed costs that do not disappear just because sales were light. Rent, electricity, ice, transport to wholesalers, and local permits belong here. The credit default rate is the share of credit sales that never come back in cash. If your store mostly serves salaried workers, the rate may be low; if you extend credit through long payday gaps, it should be higher. The closer this percentage is to your actual collection pattern, the more useful the profit estimate becomes.
Formula details and profit mechanics
For each item, the calculator first reduces weekly units by the spoilage fraction: effective units equal listed units times one minus spoilage. It then calculates revenue as effective units times retail price, and cost as effective units times wholesale price. Credit loss equals revenue times the credit share fraction times the default rate fraction. Net profit for that product is revenue minus cost minus credit loss. After the product profits are added together, the calculator subtracts weekly overhead multiplied by the number of weeks. The result is the amount left before you pay yourself a separate salary.
The math can be summarized with MathML:
where is weekly units, spoilage fraction, retail price, wholesale price, credit share, and default rate. Total profit then subtracts overhead. Tracking these components clarifies why raising prices by even ₱1 on high-volume sachets can offset spoilage, or why shifting more customers to prepaid cash protects the business.
Example: Barangay San Jose sari-sari
Imagine Aling Belen running a sari-sari store outside Antipolo. She sells 180 instant coffee sachets per week at ₱8 after buying them at ₱6, with 2% spoilage and 10% credit share. She also sells 60 canned sardines at ₱23 with ₱18 wholesale cost, 5% spoilage, and 30% credit share. Soft drinks move at 90 bottles a week for ₱22 each after a ₱16 wholesale cost, but they carry 8% spoilage and 15% credit share. Bread comes from a local bakery at ₱11 wholesale and sells for ₱15, with 50 pieces per week and 12% spoilage. With weekly overhead of ₱1,200 and a 6% default rate, the four-week calculation produces projected revenue of ₱20,815.20, product-level net profit before overhead of ₱5,048.56, overhead of ₱4,800.00, and take-home profit of ₱248.56.
That result tells a more honest story than markup alone. The store is busy, but the fixed weekly bill is almost swallowing the combined margin. If Aling Belen lowers soft-drink spoilage to 4% and trims credit share to 5%, the same four-week scenario improves take-home profit by about ₱129.17. The calculator then makes it easy to export the rows as CSV and compare the effect of each change without guessing.
Comparing markup strategies for sari-sari staples
| Item | Wholesale (₱) | Retail (₱) | Gross margin (%) | Notes |
|---|---|---|---|---|
| Instant coffee sachet | 6.00 | 8.00 | 25 | High turnover; low spoilage |
| Seasoning packet | 3.20 | 5.00 | 36 | Bundled with vegetables |
| Laundry soap sachet | 7.10 | 9.50 | 25 | Customers accept cash-only policy |
| Bottled soft drink | 16.00 | 22.00 | 27 | Needs cooler maintenance |
| Rice repack (1 kg) | 35.00 | 44.00 | 20 | Labor-intensive rebagging |
The table shows why a sari-sari owner should look past markup alone. Soft drinks can carry a decent gross margin and still disappoint if the cooler is unreliable. Laundry soap survives better because customers usually pay cash and treat it as a planned purchase. Rice repacking may look modest, but it can anchor foot traffic and bring extra basket items with it. When you compare the calculator’s profit result with these markup percentages, you can decide whether to push bundles, move a product away from direct sun, or negotiate a better supplier price.
Using sari-sari profit insights to strengthen the store
Once you identify the items that actually earn their keep, you can put the profit back into resilience: a backup battery for the refrigerator, sturdier shelves, pest control, or a simple ledger app on a phone. You can also compare what happens if you buy staples with another nearby store and share transport costs. The calculator lets you test those ideas before spending money, which is especially helpful when blackouts, rain, or festival traffic change demand from one week to the next.
During fiestas, payday weekends, or school openings, run a shorter scenario with higher weekly units so you know whether extra stock will really pay off. If your customers settle bills in batches, match the planning horizon to those cycles and watch how the profit line moves. The CSV export can serve as a running business journal for permit renewals or discussions with microfinance lenders, because it shows not just revenue but how much of it survives spoilage, credit, and overhead.
Limitations and prudent assumptions for sari-sari margins
The calculator simplifies a real sari-sari store in several ways. It assumes prices stay steady over the planning horizon, although supply disruptions or sugar price changes can force quick adjustments. If you also sell load, delivery, or other side services, include their costs in overhead manually. Credit losses are represented by one percentage, even though some customers pay partially or barter goods back. Inventory shrinkage from family consumption or small theft is not shown separately, so you may want to add a modest spoilage allowance when you know those losses happen. Taxes are also outside the model, so use your own bookkeeping or an accountant for compliance questions.
The result is also a business estimate, not a paycheck. If you want to count your own labor, add a separate owner-salary line before deciding what the store really earned. For broader planning, you can pair this calculator with other tools such as the diaspora remittance fee comparison calculator when you need to think about cash flow beyond the sari-sari shelf. Even with those limits, regular use of the calculator can help a neighborhood store make decisions with more discipline and less hunchwork.
Itemized Sari-Sari Performance
| Product | Revenue (₱) | Cost (₱) | Credit loss (₱) | Net profit (₱) |
|---|
Mini-Game: Margin Rush Checkout
This optional arcade mini-game turns the calculator into a quick decision drill for sari-sari margins. Each product card shows buy price, sell price, spoilage risk, and utang share. When a card reaches the counter zone, send it to the lane that protects profit best. It does not change the calculator result; it simply helps you feel how spoilage pressure and credit risk can beat raw markup.