Velvir Bio Products — Cost System v6

📦 Bottles, Stickers, Boxes & Labour

ENTER ONCE · FLOWS EVERYWHERE

Bottle & Container Costs (₹)

100ml bottle

250ml bottle

500ml bottle

1L bottle plain

1L cap bottle

5L can

35L can

50L can

🎨 Designed / Branded Bottles (₹)

Used by Formulated products (Bio-20, Flower-20, etc.). Match the size name exactly to a pack size (e.g. 1L, 250ml, 500ml).

Variant name / label	Pack size	Cost (₹)

Stickers (₹/piece)

100ml

250ml

500ml

35/50L

Cotton Box (₹) & Packing Tape

100ml box

250ml box

500ml box

1L box

5L box

50L box/drum

Packing tape/unit

Packing Labour — ₹500/day, capacity by bottle size

Daily wage (₹)

100ml bottles/day

250ml bottles/day

500ml bottles/day

1L bottles/day

5L cans/day

35L cans/day

50L drums/day

Batch Variable Costs

EB per 100L batch (₹)

200L=₹4,000 auto

Lab consumables/100L (₹)

QC testing per batch (₹)

Water per 100L batch (₹)

Batch wastage/rejection %

Adds to cost automatically

Live Packing Cost Preview (per unit)

Pack Size	Bottle	Sticker	Box	Tape	Labour	TOTAL/unit

🔧 Equipment Maintenance

₹ PER BATCH

Gaskets, seals, bearings — replacement cost ÷ cycle life = ₹ per batch

Item	Cost (₹)	Lasts (cycles)	₹/batch
Total maintenance/batch			₹0.00

🧪 Media / Chemical Costing Set up once → link to product tab → cost flows automatically

🧴 Chemical Price List

ENTER ONCE · ALL FORMULAS USE THIS

GST defaults to 18%. Transport defaults to ₹20. All numbers fully visible — scroll right if needed.

Chemical Name	Pack (g)	Rate (₹)	GST %	Transport (₹)	Godown (₹)	Total Cost (₹)	₹ per gram

📋 Media Formulas

GRAMS PER LITRE

Product Formula

Batch Size (L)

Media Cost / Litre

₹0.00

Chemical	g/Litre	For Batch	₹/gram	Batch Cost	₹/Litre
Total Media Cost				₹0.00	₹0.00/L

📊 End Cost by Pack Size — All Costs Included

COMPLETE REPORT

Media + EB + Lab + Maintenance + Shared pool + Packing → end cost + margin per pack size

Formula

—

Media/L

₹0

EB+Maint/L

₹0

Lab+QC/L

₹0

Shared/L

₹0

Base Cost/L (before packing)

₹0

Size	Litres	Media	EB+Maint	Lab+QC	Shared	Bottle	Sticker	Box+Tape	Labour	END COST	Sell	Profit	Margin%

🏭 Mfg Salaries

MONTHLY

Name/Role	₹/month
Total	₹0

🔬 Lab Salaries

MONTHLY

Name/Role	₹/month
Total	₹0

🧪 Research / Isolation

MONTHLY

Shared across ALL products including kits

Item	₹/month
Total	₹0

🏢 Fixed Overheads

MONTHLY

Factory Rent (₹)

Electricity Bill (₹)

Water / Utilities (₹)

Transport / Logistics (₹)

Admin / Miscellaneous (₹)

⚙ Equipment Depreciation

ANNUAL ÷ 12

Equipment	Value (₹)	Life (yrs)	₹/month
Total/month			₹0

Total Monthly Pool

₹0

Active Products

Microbial+Formulated L/mo

0 L

Kit Liquid L/mo

0 L

Total Expected L/Month

0 L

Pool Cost / Litre

₹0

Includes kit liquid components in overhead spread.

Liquid Microbial Products Link media formula → raw material cost fills automatically

Formulated / Hormonal Products Bio-20, Flower-20 — designed bottles

Trading / Resale Products Direct supply or bulk buy + repack

📋 Velvir Bio Products — Price List Report

Cost/L · 1L end cost · 5L end cost · 35L end cost · Margin

#	Product	Type	L/mo	1L Cost	1L Sell	5L Cost	5L Sell	35L Cost	35L Sell	50L Cost	Margin%
Click Refresh to generate report.

Summary Click row to open product

#	Product	Type	L/mo	1L Cost	1L Sell	Profit	Margin%	Status
Open Summary tab to see all products.

🎯 Sales Planner — Cost Impact Simulator

Set expected monthly sales per product. Higher volume → shared cost/L drops → manufacturing cost falls. Kit & trading sales count too.

Shared Pool₹0/mo

Mfg Litres0 L

Kit+Trading0 L

Total Litres0 L

Shared /L₹0.00

Edit expected sales → cost updates live →

#	Product	Type	Expected L/mo edit to plan	Safe Mfg/1L at this volume	5L Cost	35L Cost	Sell (1L)	Margin%	Monthly Rev
Click Refresh Planner to load.

💡 How this works: Shared costs (salaries, overheads, depreciation) divide across all selling litres — liquid mfg + kits + trading. Sell more → shared pool divides over more litres → manufacturing cost per litre drops. Use this to model scenarios and set competitive offer prices.

💲 Pricing Flow — Manufacturing to Ex-Factory

Safe Manufacturing Cost → set your ex-factory price per pack size

🎯 Lead Sources

Cost-per-lead (CPL) by acquisition channel. Used to plan telecaller lead budgets.

Total blended CPL (avg): ₹0.00

📞 Telecallers

Each telecaller's total cost = salary + lead budget + shared campaign pool share. CPL = total cost ÷ leads/month.

📱 Digital Campaigns

Online lead-gen spend. Feeds the shared marketing pool split across active telecallers.

Total digital spend / month: ₹0.00

🏕 Physical Campaigns

Events, stalls & field activities. Feeds the shared marketing pool split across active telecallers.

Total physical spend: ₹0.00

👥 Customer Database

Save customers — auto-fill invoice form when selected

Name	Phone	State	GSTIN	Actions
No customers saved yet.

📈 Sales Reports

Monthly sales analysis — items sold, customers, revenue

Month

Year

Click "Generate Report" to see sales data.

🧾 New Invoice

Create GST Tax Invoice with CGST + SGST breakdown

YOUR COMPANY

Configure in Bill Settings →

INVOICE DETAILS

Invoice No.

Date

Due Date

Place of Supply

BILL TO (CUSTOMER)

Customer Name *

Phone

GSTIN

Address

LINE ITEMS

#	Item / Description	HSN/SAC	Litres	Unit	Cost/Litre (₹)	Disc%	Taxable Amt (₹)	GST%	CGST (₹)	SGST (₹)	Total (₹)

TAX SUMMARY

GST %	Taxable Amt	CGST	SGST	Total Tax

Notes / Terms

Sub Total	₹0.00
Discount	-₹0.00
CGST	₹0.00
SGST	₹0.00
Round Off	₹0.00
TOTAL	₹0

Amount in Words

Zero Rupees Only

📋 Invoice List

All saved invoices — click to view or reprint

#	Invoice No	Date	Customer	Amount	Actions
No invoices saved yet.

⚙ Bill Settings

Your company details printed on every invoice

ACTIVE COMPANY:

Switch company to load/save separate settings & invoice numbers