Type Product Base Cost TikTok Email Google MKT

Individual MPC (Within City) 450 400 500

Individual MPC (Outside City) 450
Individual Mobile Phone Cover 450
Bundle Lipstick 450
Individual Dresses 1800
Individual Waterproof Matress 840
Individual Individual bedsheet 1350
Bundle T-Shirts 400
Individual Chopper Blender 500
Individual Iron 800
Jewellery
Individual Washing/ Fridge /AC 53000 25
Individual Mobile Phone 45000 500 500

Services Food / Salon Deals 500

Mehndi Application 1000

Selling on others websites / portals

JIT - Just In Time T-Shirts 400
Fullfillment By -XYZ
Lipstick 450
Dropshipping (Aggregator / Marketplace)
T-Shirts 400
17.5
Focused Service (FAD) 5000
Non Focused Multiple Products
Fb MKT Cost Avg MKT Log : insurance Log : cash handling Storage Log: return Logistics

400 700 200

700 300
500 150
250 500 300
250 250
450 299
450 299
250 200

300 400
2000
1500 1500 6500
500 1500 300

750
500 300

MKT
Profit
Admin

0 0

0 0

250 0
12 10
Salaries Taxes Discount on Bank Transfer Online Payment Charges

43.125
Admin Cost Tax Return Cost Profit Selling Price Store 1 Store 2 Store 3

300 25 50 1725 1500 1800 1700

300 25 75 1850 1300 1400 1000
150 25 24 1299
300 25 50 1875 999 1400 1600
100 25 50 2475
120 20 30 1759 1800 1700 1750
120 20 210 2449
100 25 150 1125 1399 1199 999
500
50 50 100 1700

1000 2000 1000 66525

50 50 1500 49900

200 0 300 1750 1399 1599 1899

100 200 2100

200 0 100 700

25 0 25 500

25 0 100 775
5 7 51.5
7000 18000
Avg Store Est Orders Est Return Profit On Orders Profit On return Total Gross Profit

1666.667 100 10 4500 2250 6750

1233.333 100 10 6750
100 10 2160 2250 4410
1333 0
0 0
1750

1199 50 5 7500

1632.333
Cost of Returns Net Profit

26181.25 -19431.25

-3590 -39.88888889

85000 45000
Salary 200000 Expenses Orders Basket value
Internet 4000 Jan 252000 20 1399
Cleaning 5000 Feb 252000 50 1399
Electricity 30000 Mar 252000 100 1399
Tea / Water 5000 Apr 252000 200 1399
Travel 5000 May 252000 150 1399
Hosting 3000 Jun 252000 150 1399
Packing 40000 Jul 262000 150 1499
292000 Aug 262000 200 1499
Sep 262000 200 1499
Oct 262000 200 1499
Nov 262000 250 1499
Dec 262000 250 1499
Jan 275000 250 1599
Feb 275000 250 1599
Mar 275000 350 1599
Apr 275000 350 1599
May 275000 350 1599
Jun 275000 350 1599
Jul 300000 500 1599
Aug 300000 500 1599
Sep 300000 500 1599
Oct 300000 750 1599
Nov 300000 750 1599
Dec 400000 1000 1599
400000 1000 400
Revenue Loss Value
27980 -224020
69950 -182050
139900 -112100
279800 27800
209850 -42150
209850 -42150
224850 -37150
299800 37800
299800 37800
299800 37800
374750 112750
374750 112750
399750 124750
399750 124750
559650 284650
559650 284650
559650 284650
559650 284650
799500 499500
799500 499500
799500 499500
1199250 899250
1199250 899250
1599000 1199000
 Number of Employees Labour Capital Vehicles On Demand Subscription Profit Admin (Website + CS) Tax

Corporate 5 2000000 5 100 1000 4000000 0.2

Package 1 Package 2 OnDemand
1500
Expenses Per Day

Fuel Cost 300 9000

Rider Salary 750 22500
Bike wear and tear 100 3000
Telephony 100 3000
Marketing 300 9000
Admin 500 15000
2050 61500

Revenue Orders / Hour Hours Total daily orders average order val deliver + tip total revenue
Day 1 1 14 14 500 100 8400
2 14 28 500 100 16800
3 14 42 500 100 25200
3 14 42 500 100 25200
4 14 56 500 100 33600
4 14 56 500 100 33600
5 14 70 500 100 42000
5 14 70 500 100 42000
6 14 84 500 100 50400
6 14 84 500 100 50400
Day 20 7 14 70 500 100 42000
Purchasing Cost Discount Expenses Gross Margin
7000 0 2050
14000 0 2050
21000 0 2050
21000 0 2050
28000 0 2050
28000 0 2050
35000 0 2050
35000 0 2050
42000 0 2050
42000 0 2050
35000 175 2050
 9678535
FB/Insta Cost 2,608,140.47 2730 955.3628 9678600
Google 227501.64 481 472.9764 9678665
TikTok 500000 210 2380.952 9678730
9678795
9678860
9678925
9678990
9679055
9679120
9679185
9679250
9679315
9679380
9679445
9679510
9679575