0% found this document useful (0 votes)
47 views15 pages

Engine Oil

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
47 views15 pages

Engine Oil

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 15

DATA INPUT SHEET

Preference for sponsoring agency of the project to Bank: (mark √ )


KVIC KVIB DIC RURAL √ URBAN
1.1 Name of the Applicant
AL IMRAN
1.2
MOHAMMAD JALALUDDIN MOLLA
2 Gender Male √ Female
3 Address of the Proposed location of Unit: Rural √ Urban
VILL - GUCHURIYA, PO - PITHAPUKUR , PS - KASHIPUR
Taluk/Block: BHANGAR - II
District: SOUH 24 PARGANAS Pin: 700135
State: West Bengal
Email: Mobile: 8444044408
4 Qualification
Academic Technical
12th Pass

5 Whether the applicant belongs to (mark √)


Ex- Hill
Gener
SC ST OBC PHC Service Minority Boarder
al

man Area

Manu-
Whether the Service
6 facturing
project (mark √) Unit
Unit
8 Name of the project / business activity proposed :

Manufacturing of Lubricants / Engine Oil / Mobil Etc

Legal Status:

Land 1000

BUILDING DETAILS
Particulars Area Rate/Sq.ft Amount in Rs.
0.00
0.00
Rented 0.00
0.00
0.00
0.00
TOTAL 0.00

MACHINERY DETAILS
Particulars Qty. Rate Amount in Rs.
1. Blending Kettle 2 4,65,000.00 9,30,000.00
2.Sintex high Strength plastic tank( 5000L) 2 75,000.00 1,50,000.00
3. Sintex High strength plastic tank (3000L) 2 42,000.00 84,000.00
4. Tank for Finished Blended Lubricant 2 1,25,250.00 2,50,500.00
5.Storage Tank 10 Kl. Capacity 4 35,000.00 1,40,000.00
6. Pipeline, valve & filter 2 1,05,535.00 2,11,070.00
7. Base oil transfer pumps 2 76,000.00 1,52,000.00
8. Tools, Equipment & other Accessories. 1 1,25,012.00 1,25,012.00
9. Filling Machine 500 ML – 5 Litre 1 1,55,000.00 1,55,000.00
10. 300 KG Weigh Fill Machine 2 36,500.00 73,000.00
11 Induction Sealing Machine 1 31,500.00 31,500.00
12. Semi-automatic Capping Machine 2 21,000.00 42,000.00

23,44,082.00
GST 18 % 4,21,934.76
27,66,016.76
d. Preliminary & Pre-operative Cost : 24,983.00

e. Furniture & Fixtures : 59,000.00

f. Contingency/Others/Miscellaneous : 1,50,000.00

Capital expenditure 30,00,000.00

Means of Financing
Own Contribution : 5%
Bank Finance : 95%
Margin Money (Govt. Subsidy) : 35%

YEARLY DETAILS OF SALES


Rate / Qantity Amount in Rs.
Particulars of Products
LTR Ltr
1. 2T Engine oil 300.00 30000 90,00,000.00
2. 4T Engine oil 325.00 15000 48,75,000.00
3. Engine oils (Petrol and Diesel engines) 275.00 5000 13,75,000.00
4. Gear oils 400.00 5000 20,00,000.00
5. Chain lubricants 275.00 5000 13,75,000.00
6. Industrials Oils 250.00 5000 12,50,000.00

Total 1,98,75,000.00
YEARLY RAW MATERIALS
Particulars Unit Rate/Unit Mtr Amount In Rs.
1. Additive
2. Base Oil components with high Ltr. 150.00 40000 60,00,000.00
concentration of metal organic Kg 165.00 10000 16,50,000.00
3. Viscosity Index Improver Kg 175.00 15000 26,25,000.00
4. Container 900ml 50.00 20000 10,00,000.00
5. Container 3.5L 95.00 10000 9,50,000.00
5. Container 5L 125.00 2000 2,50,000.00
5. Container 10L 250.00 1000 2,50,000.00

Total 1,27,25,000.00

DAILY WAGES
No. of Wages Per Month Amount in Rs.
Particulars
Worker Total Month 12
1. Skilled Labour 40 7200.00 34,56,000.00
2.Semi Skilled Worker 2 4500.00 1,08,000.00
3.Un Skilled Labor 6 3600.00 21,600.00
Total 48 35,85,600.00

SALARY DETAILS
No. of Wages Per Month Amount in Rs.
Particulars
Staff Total Month 12
1. Accountant-cum- Super Visior 1 self 0.00
2. Marketing Manager 1 8000.00 96000.00
3. Production Manager 1 9000.00 108000.00

Total 3 2,04,000.00

WORKING CAPITAL ESTIMATE


Element of Working Capital No. of Days
Stock of Raw Materials 10

Stock in process 7

Finished goods 6

Receivable by 6

POWER ESTIMATE
Power Requirement 10 KW

Repair and Maintanance Rs. 24000.00

Power and Fuel Rs. 72000.00

Other Overhead Expenses Rs. 120000.00

Telephone Expenses Rs. 3600.00

Stationery & Postage Rs. 6000.00

Advertisement & Publicity Rs. 10000.00

Building Rent Rs.

Other Miscelleneous Expenditure Rs. 25000.00

Rate of Interest 10.00%

Depreciation
On Building 5.00%
On Machinery 10.00%
INTRODUCTION

ABOUT THE PROMOTER


PROJECT AT A GLANCE - TOP SHEET

1 Name of the Entreprenuer AL IMRAN

2 Constitution (legal Status) Individual :

3 Father's/Spouce's Name MOHAMMAD JALALUDDIN MOLLA

4 Unit Address : VILL - GUCHURIYA, PO - PITHAPUKUR , PS - KASHIPUR

Taluk/Block: BHANGAR - II
District : SOUH 24 PARGANAS
Pin: 700135 State: West Bengal
E-Mail :
Mobile 8444044408
5 Product and By Product

6 Cost of Project : Rs. 50,00,000.00


Name of the project /
business activity proposed : Manufacturing of Lubricants / Engine Oil / Mobil Etc
7 Means of Finance
Bank Loan Rs. 47,50,000.00
KVIC Margin Money Rs. 17,50,000.00
Own Capital Rs. 2,50,000.00

8 Debt Service % 2.19 2.41 2.64 2.87 3.11


Coverage Ratio

9 Pay Back Period : 5 Years

10 Project : 2 Months
Implementation
Period

11 Break Even Point : 43.12%

12 Employment : 51

13 Power Requirement : 10 KW

14 Major Raw materials : 1. Base Oil ,2. Additive components with high concentration of metal organic comp

15 Estimated Annual : Rs. 1,59,00,000.00


Sales Turnover

PMEGP Project Report Page 6


DETAILED PROJECT REPORT
1 INTRODUCTION :

2 ABOUT THE PROMOTER :

3 COST OF PROJECT
A. Fixed Capital Investment
a. Land : 1000 Own

b. Workshed Area Sq.ft Rate in Rs. Amt. In Rs.


0.00

0.00

C. Machinery Qty. Rate Amount in Rs.


1. Blending Kettle 2 4,65,000.00 9,30,000.00
2.Sintex high Strength plastic tank( 5000L) 2 75,000.00 1,50,000.00
3. Sintex High strength plastic tank (3000L) 2 42,000.00 84,000.00
4. Tank for Finished Blended Lubricant 2 1,25,250.00 2,50,500.00
5.Storage Tank 10 Kl. Capacity 4 35,000.00 1,40,000.00
6. Pipeline, valve & filter 2 1,05,535.00 2,11,070.00
7. Base oil transfer pumps 2 76,000.00 1,52,000.00
Total 27,66,016.76

PMEGP Project Report Page 7


d. Preliminary & Pre-operative Cost : Rs. 24983.00

e. Furniture & Fixtures : Rs. 59000.00

f. Contingency/Others/Miscellaneous : Rs. 150000.00

Capital Expenditure : Rs. 30,00,000.00

Working Capital Rs. 20,00,000.00

Total Cost Project : Rs. 50,00,000.00

3 Means of Financing :
Own Contribution 5% Rs. 2,50,000.00

Bank Finance : 95%


Term Loan Rs. 28,50,000.00
Working Capital Rs. 19,00,000.00
Total Rs. 47,50,000.00

Margin Money (Govt. Subsidy) From KVIC 35% Rs. 17,50,000.00

Margin Money Subsidy received From KVIC will be kept in term deposit as per norms of
PMEGP in the name of Beneficiary for three years in the financing branch.

3 STATEMENT SHOWING THE REPAYMENT OF TERM LOAN & WORKING CAPITAL :


TERM LOAN

Interest @
Year Opening Balance Installment Closing Balance 10.00%
2023-24 28,50,000.00 4,62,464.00 23,87,536.00 2,64,185.00
2024-25 23,87,536.00 5,10,890.00 18,76,646.00 2,15,759.00
2025-26 18,76,646.00 5,64,387.00 13,12,259.00 1,62,262.00
2026-27 13,12,259.00 6,23,486.00 6,88,773.00 1,03,163.00
2027-28 6,88,773.00 6,88,873.00 0.00 38,276.00
Total 28,50,000.00

WORKING CAPITAL

Year Opening Balance Installment Closing Balance Interest @


10.00%
2023-24 19,00,000.00 0.00 19,00,000.00 1,90,000.00
2024-25 19,00,000.00 0.00 19,00,000.00 1,90,000.00
2025-26 19,00,000.00 0.00 19,00,000.00 1,90,000.00
2026-27 19,00,000.00 0.00 19,00,000.00 1,90,000.00
2027-28 19,00,000.00 0.00 19,00,000.00 1,90,000.00

PMEGP Project Report Page 8


3 STATEMENT SHOWING THE DEPRECIATION ON FIXED ASSETS:
WORKSHED (OWN INVESTMENT) @ 5.00%
Particulars 1st Year 2nd Year 3rd Year 4th Year 5th Year
Opening Balance 0 0 0 0 0
Depreciation 0 0 0 0 0
Closing Balance 0 0 0 0 0
MACHINERY @ 10.00%
Opening Balance 30,00,000.00 27,00,000.00 24,30,000.00 21,87,000.00 19,68,300.00
Depreciation 3,00,000.00 2,70,000.00 2,43,000.00 2,18,700.00 1,96,830.00
Closing Balance 27,00,000.00 24,30,000.00 21,87,000.00 19,68,300.00 17,71,470.00
TOTAL DEPRECIATION
Workshed 0.00 0.00 0.00 0.00 0.00
Machinery 3,00,000.00 2,70,000.00 2,43,000.00 2,18,700.00 1,96,830.00
Total 3,00,000.00 2,70,000.00 2,43,000.00 2,18,700.00 1,96,830.00

4 Schedule of Sales Realization :


4 Details of Sales
Rate/ No. of Amount in Rs.
Particulars of Product
Pair/Unit Pair/Unit
1. 2T Engine oil 300 30000 90,00,000.00
2. 4T Engine oil 325 15000 48,75,000.00
3. Engine oils (Petrol and Diesel engines) 275 5000 13,75,000.00
4. Gear oils 400 5000 20,00,000.00
0
1,98,75,000.00

4 Capacity Utilization of Sales


Particulars 1st Year 2nd Year 3rd Year 4th Year 5th Year

Capacity Utilization 80% 85% 90% 95% 100%

Sales / Receipts 1,59,00,000.00 1,68,93,750.00 1,78,87,500.00 1,88,81,250.00 1,98,75,000.00

5 Rawmaterials :
Particulars Unit Rate/unit Reqd.Unit Amount in Rs.
1. Base Oil 150.00 40000 60,00,000.00
2. Additive components with high concentration of metal organic
165.00components 10000
based on the esta 16,50,000.00
3. Viscosity Index Improver 175.00 15000 26,25,000.00
4. Container 900ml 50.00 20000 10,00,000.00
5. Container 3.5L 95.00 10000 9,50,000.00
5. Container 5L 125.00 2000 2,50,000.00
5. Container 10L 250.00 1000 2,50,000.00

Total 1,27,25,000.00
5 Wages :
No. of Wages Amount in Rs.
Particulars
Worker Per Month (Per Annum)
1. Skilled Labour 40 7,200.00 34,56,000.00
2.Semi Skilled Worker 2 4,500.00 1,08,000.00

Total 42 35,64,000.00

5 Repairs and Maintenance : Rs. 24000.00


5 Power and Fuel : Rs. 72000.00
5 Other Overhead Expenses : Rs. 120000.00

PMEGP Project Report Page 9


6 Administrative Expenses :
6 Salary
1. Accountant-cum- Super Visior 1 self 0.00
2. Marketing Manager 1 8000.00 96,000.00
3. Production Manager 1 9000.00 1,08,000.00

Total 3 2,04,000.00

6 Telephone Expenses 3600.00

6 Stationery & Postage 6000.00

7 Advertisement & Publicity 10000.00

7 Workshed Rent

7 Other Miscellaneous Expenses 25000.00


Total 248600.00
7 Capacity Utilization of Manufacturing & Administrative Expenses :
Particulars 1st Year 2nd Year 3rd Year 4th Year 5th Year
Capacity Utilization 80% 85% 90% 95% 100%
Manufacturing Expenses
Rawmaterials 1,01,80,000.00 1,08,16,250.00 1,14,52,500.00 1,20,88,750.00 1,27,25,000.00
Wages 28,51,200.00 30,29,400.00 32,07,600.00 33,85,800.00 35,64,000.00
Repairs & Maintenance 19,200.00 20,400.00 21,600.00 22,800.00 24,000.00
Power & Fuel 57,600.00 61,200.00 64,800.00 68,400.00 72,000.00
Other Overhead Expenses 96,000.00 1,02,000.00 1,08,000.00 1,14,000.00 1,20,000.00
Administrative Expenses
Salary 2,04,000.00 2,14,200.00 2,24,910.00 2,36,155.50 2,47,963.28
Postage Telephone Expenses 2,880.00 3,060.00 3,240.00 3,420.00 3,600.00
Stationery & Postage 4,800.00 5,100.00 5,400.00 5,700.00 6,000.00
Advertisement & Publicity 8,000.00 8,500.00 9,000.00 9,500.00 10,000.00
Workshed Rent 0.00 0.00 0.00 0.00 0.00
Other Miscellaneous Expenses 20,000.00 21,250.00 22,500.00 23,750.00 25,000.00
Total: 1,34,43,680.00 1,42,81,360.00 1,51,19,550.00 1,59,58,275.50 1,67,97,563.28
8 Assessment of Working Capital :
Particulars Amount in Rs.
Sale 1,98,75,000.00

Manufacturing Expenses
Raw Material 1,27,25,000.00
Wages 35,64,000.00
Repair & Maintenance 24,000.00
Power & Fuel 72,000.00
Other Overhead Expenses 1,20,000.00

Production Cost 1,65,05,000.00


Administrative Cost 2,48,600.00
Manufacturing Cost 1,67,53,600.00

PMEGP Project Report Page 10


Working Capital Estimate :
Element of Working Capital No of Days Basis Amount in Rs.
Stock of Raw Materials 10 Material Cost 7,88,390.00

Stock in process 7 Production Cost 4,74,450.00

Finished goods 6 Manufacturing Cost 4,68,580.00

Receivable by 6 Manufacturing Cost 2,68,580.00

Total Working Capital Requirement Per Cycle 20,00,000.00


9 Financial Analysis
9 Projected Profit & Loss Account :
Particulars 1st Year 2nd Year 3rd Year 4th Year 5th Year
Sales / Receipts 1,59,00,000.00 1,68,93,750.00 1,78,87,500.00 1,88,81,250.00 1,98,75,000.00
Total Sales 1,59,00,000.00 1,68,93,750.00 1,78,87,500.00 1,88,81,250.00 1,98,75,000.00
Manufacturing Expenses
Rawmaterials 1,01,80,000.00 1,08,16,250.00 1,14,52,500.00 1,20,88,750.00 1,27,25,000.00
Wages 28,51,200.00 30,29,400.00 32,07,600.00 33,85,800.00 35,64,000.00
Repairs & Maintenance 19,200.00 20,400.00 21,600.00 22,800.00 24,000.00
Power & Fuel 57,600.00 61,200.00 64,800.00 68,400.00 72,000.00
Other Overhead Expenses 96,000.00 1,02,000.00 1,08,000.00 1,14,000.00 1,20,000.00
Depreciation 3,00,000.00 2,70,000.00 2,43,000.00 2,18,700.00 1,96,830.00
Production Cost 1,35,04,000.00 1,42,99,250.00 1,50,97,500.00 1,58,98,450.00 1,67,01,830.00
Administrative Expenses
Salary 2,04,000.00 2,14,200.00 2,24,910.00 2,36,156.00 2,47,964.00
Postage Telephone Expenses 2,880.00 3,024.00 3,060.00 3,240.00 3,420.00
Stationery & Postage 4,800.00 5,040.00 5,100.00 5,400.00 5,700.00
Advertisement & Publicity 8,000.00 8,400.00 8,500.00 9,000.00 9,500.00
Workshed Rent 0.00 0.00 0.00 0.00 0.00
Other Miscellaneous Expenses 18,000.00 20,000.00 21,250.00 22,500.00 23,750.00
Administrative Cost 2,37,680.00 2,50,664.00 2,62,820.00 2,76,296.00 2,90,334.00
Interest on Bank credit @ 10%
Term Loan 2,64,185.00 2,15,759.00 1,62,262.00 1,03,163.00 38,276.00
Working Capital Loan 1,90,000.00 1,90,000.00 1,90,000.00 1,90,000.00 1,90,000.00
Cost of Sale 1,41,95,865.00 1,49,55,673.00 1,57,12,582.00 1,64,67,909.00 1,72,20,440.00
Net Profit Before Tax 17,04,135.00 19,38,077.00 21,74,918.00 24,13,341.00 26,54,560.00
Less Tax 0.00 0.00 0.00 0.00 0.00
Net Profit 17,04,135.00 19,38,077.00 21,74,918.00 24,13,341.00 26,54,560.00

9 CALCULATION OF DEBT SERVICE CREDIT RATIO (D.S.C.R) :


Particulars 1st Year 2nd Year 3rd Year 4th Year 5th Year
Net Profit 17,04,135.00 19,38,077.00 21,74,918.00 24,13,341.00 26,54,560.00
Add :
Depreciation 3,00,000.00 2,70,000.00 2,43,000.00 2,18,700.00 1,96,830.00
TOTAL - A 20,04,135.00 22,08,077.00 24,17,918.00 26,32,041.00 28,51,390.00
Payments :
On Term Loan :
Interest 2,64,185.00 2,15,759.00 1,62,262.00 1,03,163.00 38,276.00
Installment 4,62,464.00 5,10,890.00 5,64,387.00 6,23,486.00 6,88,873.00
On Working Capital
Interest 1,90,000.00 1,90,000.00 1,90,000.00 1,90,000.00 1,90,000.00
TOTAL - B 9,16,649.00 9,16,649.00 9,16,649.00 9,16,649.00 9,17,149.00
D.S.C.R = A/B
2.19 2.41 2.64 2.87 3.11
Average D.S.C.R

PMEGP Project Report Page 11


9 PROJECTED BALANCE SHEET :
Particulars 1st Year 2nd Year 3rd Year 4th Year 5th Year
LIABILITIES :
Promoters Capital 2,50,000.00 2,50,000.00 2,50,000.00 2,50,000.00 2,50,000.00
Profit 19,38,077.00 21,74,918.00 24,13,341.00 26,54,560.00 26,54,560.00
Term Loan 23,87,536.00 18,76,646.00 13,12,259.00 6,88,773.00 0.00
Working Capital Loan 19,00,000.00 19,00,000.00 19,00,000.00 19,00,000.00 19,00,000.00
Current Liabilities 0.00 0.00 0.00 0.00 0.00
Sundry Creditors 0.00 0.00 0.00 0.00 0.00
64,75,613.00 62,01,564.00 58,75,600.00 54,93,333.00 48,04,560.00
ASSETS :
Gross Fixed Assets : 29,75,016.76 26,75,016.76 23,75,016.76 21,05,016.76 18,62,016.76
Less : Depreciation 3,00,000.00 3,00,000.00 2,70,000.00 2,43,000.00 2,18,700.00
Net Fixed Assets 26,75,016.76 23,75,016.76 21,05,016.76 18,62,016.76 16,43,316.76
Preliminary & Pre-Op. Expenses 18,737.25 14,052.94 10,539.70 7,904.78 5,928.58
Current Assets 19,00,000.00 19,00,000.00 19,00,000.00 19,00,000.00 19,00,000.00
Cash in Bank/Hand 19,00,596.24 19,26,547.24 18,70,583.24 17,31,316.24 15,58,184.62
Total 64,75,613.00 62,01,564.00 58,75,600.00 54,93,333.00 51,01,501.38

9 CASH FLOW STATEMENT :


Particulars 1st Year 2nd Year 3rd Year 4th Year 5th Year
Net Profit 17,04,135.00 19,38,077.00 21,74,918.00 24,13,341.00 26,54,560.00
Add : Depreciation 3,00,000.00 2,70,000.00 2,43,000.00 2,18,700.00 1,96,830.00
Term Loan 28,50,000.00 23,87,536.00 18,76,646.00 13,12,259.00 6,88,773.00
Working Capital Loan 19,00,000.00 19,00,000.00 19,00,000.00 19,00,000.00 19,00,000.00
Promoters Capital 2,50,000.00 0.00 0.00 0.00 0.00
Total 70,04,135.00 64,95,613.00 61,94,564.00 58,44,300.00 54,40,163.00

Total Fixed Capital Invested 30,00,000.00 0.00 0.00 0.00 0.00

Repayment of Term Loan 4,62,464.00 5,10,890.00 5,64,387.00 6,23,486.00 6,88,873.00


Repayment of WC Loan 0.00 0.00 0.00 0.00 0.00
Current Assets 19,00,000.00 19,00,000.00 19,00,000.00 19,00,000.00 19,00,000.00
Total 23,62,464.00 24,10,890.00 24,64,387.00 25,23,486.00 25,88,873.00

Opening Balance 0.00 46,41,671.00 87,26,394.00 1,24,56,571.00 1,57,77,385.00


Surplus 46,41,671.00 40,84,723.00 37,30,177.00 33,20,814.00 28,51,290.00
Closing Balance 46,41,671.00 87,26,394.00 1,24,56,571.00 1,57,77,385.00 1,86,28,675.00

10 BREAK EVEN POINT AND RATIO ANALYSIS :


Particulars 1st Year 2nd Year 3rd Year 4th Year 5th Year
Fixed Cost 8,01,865.00 7,36,423.00 6,68,082.00 5,98,159.00 5,25,440.00
Variable Cost 1,36,94,000.00 1,44,89,250.00 1,52,87,500.00 1,60,88,450.00 1,68,91,830.00
Total Cost 1,44,95,865.00 1,52,25,673.00 1,59,55,582.00 1,66,86,609.00 1,74,17,270.00

Sales 1,59,00,000.00 1,68,93,750.00 1,78,87,500.00 1,88,81,250.00 1,98,75,000.00

Contribution (Sales-VC) 22,06,000.00 24,04,500.00 26,00,000.00 27,92,800.00 29,83,170.00

B.E.P in % 36.35% 43.12% 25.70% 21.42% 17.61%

Break Even Sales in Rs. 57,79,535 51,74,026 45,96,276 40,43,966 35,00,679

Break Even Units 19,265 17,247 15,321 13,480 11,669

Current Ratio 0.80 2.07 2.07 2.07 2.07

PMEGP Project Report Page 12


Net Profit Ratio 10.72% 11.47% 12.16% 12.78% 13.36%

PMEGP Project Report Page 13


This Project Report has been prepared based on the data furnished by the entrepreneur whose details are given in
the application.
Place : SOUTH 24 PARGANAS
Date:
Prepared by :
Full Name : AL IMRAN

Signature of the Beneficiary

PMEGP Project Report Page 14


PMEGP Project Report Page 15

You might also like