Financials - Dhobhi Bhaiya

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 9

Initial Investment Fixed Cost (Monthly)

Particulars Amount (Rs.) Particulars Amount (Rs.)


Dryer Machine 189,500 Washing Machine 40,000
Furnitures 20,000 Rent 200,000
Ironing Table 60,000 Salary 800,000
Iron Box 112,500 Internet/ Mobile 15,000
Table Fan 50,000
Tube Light/ Electric Bulbs 10,000
Clips 15,000
Hangers 50,000
Laundry ropes 30,000
Drying Stands 50,000
Weighing Scale 9,000
Washing machine 1,000,000
Infrastructure 300,000
Electricals 50,000

Total 1,946,000 Total 1,055,000


Variable Cost (Monthly)
Particulars Amount (Rs.)
Electricity & Water 300,000
Marketing & Advertising 10,000
Transportation/ Logistics 10,000
Office Supplies 5,000
Repair Maintenance 25,000

Total 350,000
INCOME STATEMENT
REVENUE
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8
No. Of Customers 2,689 2,742 2,797 2,853 2,910 2,968 3,028 3,088
Average Per Customer (Avg MRP) 600 600 600 600 600 600 600 600

TOTAL REVENUE 1,613,100 1,645,362 1,678,269 1,711,835 1,746,071 1,780,993 1,816,613 1,852,945

COST OF GOODS SOLD


Raw Material 150,249 157,761 165,649 173,932 182,628 191,760 201,348 211,415
TOTAL COGS 150,249 157,761 165,649 173,932 182,628 191,760 201,348 211,415

GROSS PROFIT 1,462,851 1,487,601 1,512,620 1,537,903 1,563,443 1,589,233 1,615,265 1,641,530

SALES, GENERAL & ADMIN EXPENSES


Rent 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000
Salaries 800,000 800,000 800,000 800,000 800,000 800,000 800,000 800,000
Marketing & Advertising 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000
Transportation/ Logistics 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000
Machine Rent 30,000 30,000 30,000 40,000 40,000 40,000 40,000 40,000
Electricity, Water 300,000 300,000 300,000 300,000 300,000 300,000 300,000 300,000
Office Supplies 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000
Internet/ Mobile 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000
Repair Maintenance 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000

TOTAL SG&A EXPENSE 1,395,000 1,395,000 1,395,000 1,405,000 1,405,000 1,405,000 1,405,000 1,405,000

Profit 67,851 92,601 117,620 132,903 158,443 184,233 210,265 236,530

Breakeven calculation
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8
Setoff 67,851 92,601 117,620 132,903 158,443 184,233 210,265 236,530
Investment/ Capital recovered -1,946,000 -1,878,149 -1,785,548 -1,667,928 -1,535,025 -1,376,582 -1,192,349 -982,084
Carry forward -1,878,149 -1,785,548 -1,667,928 -1,535,025 -1,376,582 -1,192,349 -982,084 -745,554
Breakeven- 9 months 3 days
NT

Month 9 Month 10 Month 11 Month 12 Year Total Year 2 Total Year 3 Total
3,150 3,213 3,277 3,343 36,058 39,664 43,631
600 600 600 600 600 660 726

1,890,004 1,927,804 1,966,360 2,005,687 21,635,042 26,178,401 31,675,865

OLD
221,986 233,085 244,739 256,976 2,391,528 2,630,681 2,893,749
221,986 233,085 244,739 256,976 2,391,528 2,630,681 2,893,749

1,668,018 1,694,719 1,721,621 1,748,711 19,243,514 23,547,720 28,782,116

EXPENSES
200,000 200,000 200,000 200,000 2,400,000 2,640,000 2,904,000
800,000 800,000 800,000 800,000 9,600,000 10,560,000 11,616,000
10,000 10,000 10,000 10,000 120,000 132,000 145,200
10,000 10,000 10,000 10,000 120,000 132,000 145,200
40,000 40,000 40,000 40,000 450,000 NIL NIL
300,000 300,000 300,000 300,000 3,600,000 3,960,000 4,356,000
5,000 5,000 5,000 5,000 60,000 66,000 72,600
15,000 15,000 15,000 15,000 180,000 198,000 217,800
25,000 25,000 25,000 25,000 300,000 330,000 363,000

1,405,000 1,405,000 1,405,000 1,405,000 16,830,000 18,018,000 19,819,800

263,018 289,719 316,621 343,711 2,413,514 5,529,720 8,962,316

Month 9 Month 10
263,018 289,719
-745,554 -482,536
-482,536 -192,818
Target Customer Raw Materials
College Strength Target (1/8) No of visits Particulars
per month
SIMS 700 88 350 Detergents
SCMHRD + SIIB + SCIT 1000 125 500 Conditioner
SIU (Lavale) 4700 588 2350 Total
MIT 5300 400 1600
DY Patil 3000 276 1104
BIMM 720 90 360

Washing
SLS 1500 188 750
COEP 3800 475 1900
AIT 1280 160 640

Pune University 3600 300 1200

Ironing
Total 25600 2689 10754
Raw Materials Average Salary
At SIMS Total Particulars Number
₹ 3,840 ₹ 117,987 Supervisor 5
₹ 1,050 ₹ 32,262 Employees 45
₹ 4,890 ₹ 150,249 Total 50

Pricing
Particulars Without Drying With Drying DIY
Cycle of 4 kg ₹ 25/ Kg ₹ 30/ Kg ₹ 20/ Kg
Non cycle of 4 Kg ₹ 30/ Kg ₹ 35/ Kg ₹ 25/ Kg

Particulars With washing Without Washing DIY


Normal clothes ₹ 3/ piece ₹ 5/ piece ₹ 2.5/ piece
Bed Sheets/ Saree ₹ 5/ piece ₹ 8/ piece ₹ 4.5/ piece
Average Salary
Salary Total
25000 125000
15000 675000
800000

Rent
Number of outlets 10
Average Rent per outlet 20000

You might also like