Fruit-Veg canning project report

Text Box: Disclaimer: This is just a model DPR prepared based on assumptions for reference purpose only. The project cost and financial projections may vary project to project as per technology selection, nature of civil work, price of raw materials etc.

PROJECT AT A GLANCE………………………………………………………….. 3

INTRODUCTION………………………………………………………………………… 4

  1. BACKGROUND………………………………………………………………. 5
  2. PROJECT BACKGROUND……………………………………………… 7
  3. ORGANIZATIONAL AND PROMOTERS DETAILS…………….. 8
  4. PROJECT DESCRIPTION & FLOW SHEET……………………… 9
  5. PROCUREMENT STRATEGY OF RAW MATERIAL & OTHER INPUTS……………………………………………………………. 12
  6. MARKETING STRATEGY……………………………………………… 12
  7. QUALITY CONTROL AND STANDARDS………………………… 13
  8. LAND DETAILS…………………………………………………………….. 13
  9. PROJECT COST………………………………………….. ERROR! BOOKMARK NOT DEFINED.
  10. FINANCIAL ANALYSIS………………………………….. ERROR! BOOKMARK NOT DEFINED.
  11. PROJECT IMPACT……………………………………………………….. 15

ANNEXURE

Project at a Glance

1.Name of the Unit: 
2.Constitution: 
3.Date of Incorporation: 
4.CIN: 
5.PAN: 
6.GST  
7.Registered Office: 
8.Factory Address: 
9.Name of Directors: 
10.Type of Unit: 
11.Nature of Project:Fruit and Vegetable Canning
12.Installed Capacity at 100% Capacity Utilization:500 ltr./hr.
13.Cost of the Project:Rs. 240.00 lakh
14.Promoter’s Contribution: 
15.Proposed Term Loan: 
16.Requirement of Cash Credit Limit: 
17.Proposed Employment:Direct Employment – 14 nos.
18.Power load required:200 KVA

Introduction

Fruits and vegetables have gained considerable commercial importance all over the World, contributing significantly to the economics of many countries. They are important supplement to the nutritional requirements in the human diet as they provide the essential minerals, vitamins and fiber required for maintaining health.

India is the second largest producer of fruits and vegetables in world after China. Country has made a substantial progress in horticulture production by adopting a new agricultural strategy and is self-sufficient to meet nutritional demand of burgeoning population. It accounts for about 11% and 16% of the world’s production of fruits1 and vegetables2 respectively. Despite such an achievement, huge quantity of produce is wasted due to inadequate facilities for preservation. As per the latest estimates, by Central Institute of Post-Harvest Engineering and Technology (CIPHET), Ludhiana, due to poor postharvest management practices around 18% fresh horticultural produce is wasted and hardly 1.5 to 2% of the perishable horticultural produce is processed in the country to value added products3. This wastage can be easily prevented by adopting various methods of preservations. At the same time, there is market glut during harvesting season and farmers are forced to sell their produce at throw away prices.

Therefore, food processing industries can help farmers to get sure income for their produce and avoid market glut. The food preservation and processing industry has now become a necessity rather than being a luxury. Hence, there is huge scope for processing of fruits and vegetables.

Fruits and vegetables are seasonal as well as perishable in nature. Canning of them are good bet for long term storage even up-to 5 years or beyond if hermitically sealed and can be made available to the consumers during off season. There is immense scope of market for certain popular and high value canned seasonal fruits and vegetables. Seasonal vegetable such as carrots, olive, okra, drum stick, bitter guard, green peas, cauliflower, cabbage, spinach, onion, peas, sweet potato, mushroom, French bean and others; fruits such as slices of date plum, pineapple, kiwi, plum, persimmon, jackfruit, apricots, nuts, peach, mango, strawberry, litchi etc. can be well preserved and made available at good prices during off season through proven canning technology. Therefore, small to medium scale integrated canning unit for fruits and vegetable can be established in potential clusters across India.

In Bihar, since last two decades, Horticulture has turned up as one of the significant agricultural enterprises, as it offers an extensive range of opportunities for small and marginal farmers to diversify their agriculture and allied sector. The increasing diversification provides opportunities for secondary sector development and earning remunerative returns to the farmers.

Assessing the State’s potential of capitalizing on the surplus production of horticulture crops and the potential of increasing the level of processing, value addition, employment generation, creating self- reliance and promote focused sector growth under secondary agriculture sector, Bihar Government has launched- Bihar Agri Investment Promotion Policy 2020 (BAIPP 2020). The policy identifies horticulture as an inimitable and essential sector and aims to create an ecosystem for developing and creating enterprises across processing and value addition activities.

This Scheme provides support for setting up food processing units in the state. This is aimed at addressing various constraints like infrastructure, technology, skills and marketing faced by the food processing sector in the state and to help them compete with industry standards at national and international level.

Considering the potential opportunity, this detail project report has been developed. The main objective of such initiative is to productively utilize the plentiful available resources of the local area and to enable uninterrupted supply of the products to market throughout the year.

1 https://www.statista.com/statistics/262266/global-production-of-fresh-fruit/

2 https://www.statista.com/statistics/264059/production-volume-of-vegetables-and-melons-worldwide-since- 1990/

3 Raj, D., Senapati, A.K. and Patel, N.L. 2016 Recent advances in post- harvest handling of Horticultural Crops. Commercial Horticulture, pp 371-389.

1.                        Background Definition

The term canning refers to a process which involves heating food stuff in hermetically sealed containers for a specific time at specific temperature to eliminate microbial pathogens that endanger public health and microorganisms as well as enzymes that deteriorate food during storage. It provides a shelf life typically ranging from one to five years, although under specific circumstances it can be much longer.

History of Canning

In 1809, A French confectioner and brewer, Nicolas Appert invented a process of sealing foods hermetically in containers and sterilizing them by heat. Appert is known as the father of canning who has been awarded by the French government for developing this new method of heat preservation of food and after whose name the process of canning is known as Appertization. He published his first book on canning entitled “The Art of Preserving Animal and Vegetable Substances for Many Years” which is the first known work on canning. In 1810, Peter Durand, another Englishman, obtained the first British patent on canning of foods in tin containers.

Global Scenario

Globally food processing is the largest sector considering the number of enterprises involved in the sector. Its significance and potential may be also ascribed to the scope for economic value addition offered in the sector. Worldwide, the market size of processed foods reached $5.9 trillion in 2019 and is estimated to grow up to $7.7 trillion by 2026.4 Global industry revenue is increasing, but economic slowdowns in key emerging markets have curbed growth in recent years due to this pandemic.

Recently, spreading health consciousness among consumers and the increasing vegetarian population drive the demand for the fruit – vegetable processing market. Fruit – vegetable processing market is growing at a growth rate of 7.95% in the forecast period of 2020 to 2026. Amid the COVID-19 crisis, rising consumer affordability and rapid urbanization resulted in lifestyle changes, following which the preference for processed food increased substantially.

Fig. 1 Global Processed Fruits and Vegetables Market

It is evident that there has been a gradual shift towards consumption of canned fruits and vegetables. The global market for canned fruit has already reached to US $ 10.5 Billion in the year 2019 and predicted

4 https://www.firstresearch.com/industry-research/Food-Manufacturing.html

that this market may further climbed a staggering figure of US $ 12.4 Billion by 2024, growing at CAGR of 3.33%.5 Similar trend has been seen for canned veggies, it is going to be one of the profitable sectors in the world with projection of a market of Global US$14.2 Billion by 2027 at a spectacular CAGR of 3.7% from 2020to 2027.6

Indian Scenario

The Indian fruit and vegetable processing industry experiences a conducive growth environment, owing to the abundant supply of raw materials and favorable government policies like Pradhan Mantri Kisan Sampada Yojana (PMKSY). The processing industry was valued at $ 204 million7 and exhibited retail sales at 12 % value growth and a 7% volume growth as compared to 2018. In FY 2019, ~8.31 Mn tons of fruits and vegetables were processed in India, which is expected to reach 16.39 Mn tons by 2024. The sector is growing year on year and the market is likely to prosper at 14.8% (CAGR 2020-2024). The surging adoption of flexitarian and vegan diets owing to the increasing health issues and demand for healthy products will boost the processed fruits and vegetables market growth.

Bihar

Bihar, fundamentally an agrarian economy, has a large agricultural and allied sector production base offering ample supply of raw material to be processed for human consumption. Its diverse climate ensures availability of all varieties of agriculture and horticulture produce. As per the statistics available with National Horticulture Board, Bihar is the largest producer of okra, second largest producer of cabbage, third largest producer of Potato, Brinjal and Cauliflower. Further, it has significant production of other vegetables like Onion, Tomato, Pointed gourd and cucumber. As with vegetables, Bihar is the largest producer of litchi, third largest producer of pineapple and fourth largest producer of mango in India. The state has a virtual monopoly in production of Litchi and Makhana in the country.

Despite these natural advantages, the level of processing and value addition is very low and there is scope to improve it to meet the increasing requirements of the state’s growing population, while at the same time offering a sustainable consumption market. Further, the rising income and changing lifestyle in the cities as well as in rural area is changing the consumption demand towards processed food. Therefore, the state offers a substantial opportunity for the food processing industry and is expected to play a leading role in the industrialization drive of this state.

5    https://www.researchandmarkets.com/reports/4845873/canned-fruits-global-market-trajectory-and

6 https://www.researchandmarkets.com/reports/5301721/canned-vegetables-global-market-trajectory-and

7 https://www.fssai.gov.in

2.       Project Background

The Fruit and vegetable processing unit of capacity 500 Ltr/hr has been proposed to start up at XYZ location. The main product is Canned Fruit and vegetable.

As fruits and vegetables are perishable in nature, processing aids in the preservation of it into a stable form that can be stored and distributed to distant markets during all months of the year. Processing also can change foods into new or more usable forms and make foods more attractive to prepare and in demand by consumers. The fruits and vegetables that will be used for processing not only help in reducing wastage during handling however it also helps in adding nutrition and consumable properties of them. There has been tremendous increase in consumption of packaged products due to changing lifestyles and consumption habits of people. The product is even gaining popularity in rural and smaller towns due to its convenience and easy to consume.

The goal of the canning process is to destroy any microorganisms in the food and prevent recontamination by microorganisms. Heat is the most common agent used to destroy microorganisms. Removal of oxygen can be used in conjunction with other methods to prevent the growth of oxygen requiring microorganisms. It preserves most of the nutrients in foods. Proteins, carbohydrates, and fats are unaffected, as are vitamins A, C, D, and B2. The retention of vitamin B1 depends on the amount of heat used during canning. Some vitamins and minerals may dissolve into the brine or syrup in a can during processing, but they retain their nutritive value if those liquids are consumed.

Current status of the unit:

  1. Items to be manufactured: Canned Fruits and Vegetables
  • Capacity of the plant: 500 Ltr/hr.
  • Source of power generation/electricity: Electricity form BSPHCL/SBPDCL, DG Set
  • Source of water supply: Own Borewell
  • Connectivity to road/railways: NH/SH details along with distance
  • Mode of transport: Pickup/Truck/Others
  • Market: Details of local market/other market
  • Employment Generation:14 nos.

i.         Marketing:

  • Waste disposal: ETP/STP

3.       Organizational and Promoters Details Organizational details

The M/s XYZ is a proprietorship/partnership/private company is associated with fruit trading for about 10 years. The unit was incorporated on…………………………………………………….. as private limited company under Company’s Act. The

authorized capital of the company is Rs. ….. lakh and the paid-up capital are Rs. ….. as on……………………………………………………………………………………………………………………….. The

details of the unit as per MCA website (only for private/public ltd. companies) are given below:

Company Master Data
CIN 
Company / LLP Name 
ROC Code 
Registration Number 
Company Category 
Company Sub-Category 
Class of Company 
Authorized Capital(Rs) 
Paid up Capital(Rs) 
Number of Members(Applicable in case of company without Share Capital) 
Date of Incorporation 
Registered Address 
Email Id 
Whether Listed or not 
Date of last AGM 
Date of Balance Sheet 
Company Status(for e-filing) 
 Directors/Signatory Details 
DIN/PANNameBegin dateEnd date
    
    
    

Promoters’ Background

The unit is a proprietorship/partnership/private limited company/ firm and the proprietor/partners/promoters of the firm has experience in trading of fruits and vegetables and is associated processors. He/They has/have identified fruit juice industry as a profitable business seeing its ever-increasing demand in the local market as well market in the neighboring districts and States. Brief profile of the proprietor/partners/promoters is given below:

Brief profile of promoters is given below:

a)       Mr. ABC

  • Mrs. XYZ

c)       Mr. DEF

Net-worth: The details of the net-worth of the unit is given below:

Particulars Rs. In lakh
Movable assetsA 
 B 
 C 
 Subtotal (A) 
Immovable assetsA 
 B 
 C 
 Subtotal (B) 
 Total 

The total net-worth is more than the proposed grant of the unit.

4.       Project Description & Flow Sheet:

Basically, fruit and vegetables are canned during the season when the raw material is available in plenty and canned products are sold during off season and fetch better returns to the grower as well as processor.

The basic canning process is analogous for both fruits and veggies having little variances in the sequence of the process steps used in the operations, and the cooking or blanching step for some fruits or vegetables. Typical canned products include beans (cut and whole), beets, carrots, corn, peas, spinach, tomatoes, apples, peaches, pineapple, pears, apricots, and cranberries. A commercial canning operation may employ the following general processes:

In these diagrams, attempt has been made to include all process steps that would be used for all products instead of giving for specific product.

Fig. 2. Flow Diagram for Canning of fruits and Vegetables

In the sequence of canning operations, the major difference is the blanching operation. Most of the fruits are not blanched prior to can filling whereas most of the vegetables undergo this step. Even in case of fruit, preliminary treatment steps viz. peeling, coring, halving and pitting occurs prior to any heating or cooking step but with veggies, these treatment steps often occur after the vegetable has been blanched. As vegetables have much acidity and contain more heat-resistant soil organisms they require rigorous processing than do fruits. Many vegetables also require extra cooking than fruits to develop their most desirable flavor and texture. The methods used in the cooking step vary widely among facilities. For both fruits and vegetables, peeling is done either by a mechanical peeler, steam peeling, or lye peeling. The choice depends upon the type of fruit or vegetable or the choice of the company.

Manufacturing Process

Canning a method of preservation in which a cooked or uncooked food is sealed in tin plated and lacquered steel cans. The sealed cans are sterilized by heat treatment under high pressure in retort. The temperature required for effective sterilization varies with the pH of the product and is generally higher than boiling point of water (100°C or 212°F).

In case of Fruit juice canning, Fruit pulp is prepared from selected varieties of fruits. Fully matured fruit are harvested and quickly transported to the fruit processing plant. The fruits are ripened in controlled ripening chambers or natural ripening in open yard. Fully ripened fruits are washed, pulped, deseeded, centrifuged, homogenized, thermally processed and filled hot to maintain sterility. The preparation process includes cutting, de-stoning, refining packing, processing and cooling. Similarly, fruits are also canned in slices, rings and cubes etc. along with sugar syrup of desired brix.

To provide a closer insight into the actual processes that occur during a canning operation of fruit, vegetables and Juice Canning is presented in the generic process flow diagrams as follows. Figures 4 and 5 show optional operations, as dotted line steps, that are often used but are not used for all products.

Fig. 3 Generic process flow diagrams fruit Juice Canning

Fig. 4 Generic process flow diagrams fruit canning

Fig. 4 Generic process flow diagrams Vegetable canning

The canning of fruits and veggies is similar except that the filling materials in case of veggies is brine solution. The vegetables require thorough cleaning and slicing before passing through canning line.

Since vegetables are low in acid it does not require lacquered cans. The specific requirements for canning of fruits and vegetables are given in annexure.

5.       Procurement strategy of raw material & other inputs

Production of fruits and vegetables is being viewed as ‘Sunrise’ enterprise meaning thereby that potentials of major fruits and vegetables in large. Since last decade, Bihar has become India’s horticulture basket, as it produces various kinds of fruits and vegetables in large quantity. In fruit cultivation, it is the largest producer of litchi and the third largest producer of pineapple, as well as a major producer of mango, banana, and guava. Muzaffarpur and Vaishali districts lead in litchi and banana, while Darbhanga, Vaishali, East Champaran and West Champaran are ahead in mango production. Similarly, Rohtas and Bhojpur lead in guava production.

The major fruit producing districts in the state overlap with major vegetable producing ones. Highest area has been recorded under potato, followed by cauliflower.   The average productivity of Brinjal, okra, potato, onion and sweet potato is higher in Bihar compared to average productivity of Eastern region. District also produces vegetables in huge quantity, specially, Kole crops, Tomato, Carrot, Chili, which will be required for the unit in manufacturing of fruit-based products.

Normally prices of fruits and vegetables at the village level are much lower compared to that in the main wholesale market. This situation leads to farmers getting much less return on their produce. So, raw material which will be required for manufacturing will be procured directly from the farmers. During the season as they are readily available in fresh form hence procurement will not be a problem. Many small auction centers operated at village level that collect the fruits and veggies from the farmers and is further sold/ dispatched to other major market/ customers in the state and other state. In addition to this unit would also propose to sign contracts with the local farmers to ensure timely supply of the fruits and vegetables.

Backward Linkages:

The promoter has well established backward linkages for its proposed units and it is expected that the raw material can be procured from the local area. Raw materials are mainly fruits viz Mango/ Pineapple/ Litchi, and veggies viz beans, chillies, beets, carrots, corn, peas, spinach, tomatoes, potatoes and other tuber crops etc.

Other raw materials needed are sugar, citric acid, pectin, salt, spices, oil, etc. which are available easily. Packing and Packaging materials are to be procured in a scheduled manner from domestic suppliers and by import. The usual packing sizes of cans used are A-79 (5000 ml), A-10 (3000 ml), A 2½ (800 ml), A-1 Tall (425 ml) and 5.5-0z (170 ml).

Forward Linkages

Canned product has a great demand not only in the big cities but also in town as well as in the rural area. Recently, there are only few units who are manufacturing canned products are in small capacity and unable to fulfill the Market demand. So, there is need to tap this market and double the farmers income.

6.       Marketing strategy

The increasing urbanization and income offer huge scope for marketing of canned fruits and vegetables. Urban organized platforms such as departmental stores, malls, supermarkets can be attractive platforms to sell well packaged and branded dehydrated fruits and vegetables. Processors can also have tie-up with hotels, caterers and restaurants for supply.

Quality should be emphasized at each step right from the beginning to the marketing of the Product. Over the years, an image of high-quality products should be cultivated.

The effectiveness of distribution coverage and practice is of paramount importance in achieving the desired sales. Understanding of the distribution channels is crucial for the manufacturer to plan and implement an effective distribution strategy. Distribution network should be given extra emphasis. Market share could be gained by enhancing retailer, and distributor margins.

Promoters would appoint distributors in targeted towns of Bihar and surrounding states like West Bengal, Jharkhand, Uttar Pradesh and NE states. Contacts with retailers of similar kinds will be made and products would be sold in the market with help of them. The product made in this unit will be in the line with top range of products with better quality at the same time cost effective. Company would be sharing more profits with the distributors and retailers.

Company will also explore possibility of marketing their produce to retails shops like Big Bazar, Reliance Trends, Malls etc. It will also try to partnership with local and other hotels and restaurants with good offers to attract demand of its product. It is assumed that due high quality, cost effectiveness and aesthetic packaging, sale of products may not face much problems.

7.       Quality Control and Standards

The specifications of Fruit Products Order, 1955 and Prevention of Food Adulteration Act, 1954 Certification are mandatory. The canned fruit and vegetable should conform to the specifications laid down in F.P.O. 1955.8 The ISO 9000-2000, HACCP, ISO-14000 series and European norms series standards promise a framework which may guide the entrepreneurs towards fulfilment of a commitment of quality of products. ISO series standards are available with the Bureau of Indian Standards from their headquarters office.

Pollution Control

In terms of Air and Sound pollution, no major problem is associated with this project. For wastewater disposal, appropriate recycling system is managed so that water pollution will be controlled. However, entrepreneur should obtain NOC from concerned State Pollution Control Board.

Waste and Effluent Disposal

Rejected fruits and veggies and peelings and cuttings are sent to farms to be used as animal feed or as a farm manure processing. In case of effluent disposal, it should be treated with recycling facility or dumped in such a way that these does not cause environmental hazard in the vicinity of the site. However, the water effluent in this industry is generated during cleaning, washing, pre-treatment, blanching of raw materials is advisable to test the water discharge as per specifications laid down by the Bureau of Indian Standards.

Energy Conservation

Proper care and management should be taken in order to use appropriate amount of fuel and electricity. There should be no leakage of steam from pipeline.

8.                        Land Details Land Details

In order to set up a modern biscuit manufacturing unit of the proposed capacity, a land size of approx. 18 to 20 Decimal would be ideal however this may vary with increase in capacity.

The land proposed for the unit Details of the proposed land is given below:

Sale deed dated 18.10.2016 in the name of M/s XYZ with sale value Rs. 0.00/-

Khata no.Plot no.AreaBoundary
    
    
Total19 decimals 

8 http://www.dcmsme.gov.in/old/publications/pmryprof/food/ch2.pdf

The total land area is …… decimal and is in the name of the of the proprietor/firm/company. The proposed land of the unit is an industrial land as per CLU dated …… Character of the land. The cost of the land is Rs. ……. lakh/ the proposed land is a leased land for a period of…………………………………………………………………………………………………. years.

(In case of leased land the minimum lease duration should be 30 years)

CAPACITY, UTILIZATION, PRODUCTION & OUTPUT

COMPUTATION OF PRODUCTION OF CANNED F&V Items to be Manufactured: Canned F&V
Machine capacity per hour100Kg
Total working Hours8 
Machine capacity Per Day800Kg
Working days in a month25Days
Working days per annum300 
Wastage Considered2% 
Raw material requirement240000Kg
Final Output per annum after wastage235200Kg
Final Product to be packed in 1 kg Can  
Number of Cans per annum2352001 Kg Can
Production of Canned F&V
ProductionCapacityKG
1st year50%1,17,600
2nd year55%1,29,360
3rd year60%1,41,120
4th year65%1,52,880
5th year70%1,64,640
Raw Material Cost YearCapacity UtilizationRate (per Kg)Amount (Rs. in lacs)
1st year50%90.00108.00
2nd year55%95.00125.40
3rd year60%100.00144.00
4th year65%105.00163.80
5th year70%110.00184.80
COMPUTATION OF SALE
Particulars1st year2nd year3rd year4th year5th year
Op Stock3,9204,3124,7045,096
Production1,17,6001,29,3601,41,1201,52,8801,64,640
Less: Closing Stock3,9204,3124,7045,0965,488
Net Sale1,13,6801,28,9681,40,7281,52,4881,64,248
Sale price per can140.00147.00154.00162.00170.00
Sales (in Lacs)159.15189.58216.72247.03279.22

TOTAL COST OF PROJECT

COST OF PROJECT(in Lacs)
PARTICULARSAmount
Land & BuildingOwned/ Rented
Plant & Machinery28.50
Miscellaneous Assets1.20
Working capital9.44
Total39.14

*The make and specification of P&M may vary project to project based on the quotations from different suppliers.

MEANS OF FINANCE

MEANS OF FINANCE
PARTICULARSAMOUNT
Own Contribution14.30
Term Loan @ 55%16.34
Working Capital (Bank Finance)8.50
Total39.14

TERM LOAN

Term loan of Rs. 16.34 Lakh is required for project cost of Rs. 39.14 Lakh

TERM LOAN REPAYMENT & INTEREST SCHEDULE

REPAYMENT SCHEDULE OF TERM LOAN
      Interest11.00%
YearParticularsAmountAdditionTotalInterestRepaymentClosing Balance
1stOpening Balance      
 1st month16.3416.3416.34
 2nd month16.3416.340.1516.34
 3rd month16.3416.340.1516.34
 4th month16.3416.340.15 16.34
 5th month16.3416.340.15 16.34
 6th month16.3416.340.15 16.34
 7th month16.3416.340.150.3016.03
 8th month16.0316.030.150.3015.73
 9th month15.7315.730.140.3015.43
 10th month15.4315.430.140.3015.13
 11th month15.1315.130.140.3014.82
 12th month14.8214.820.140.3014.52
     1.611.82 
2ndOpening Balance      
 1st month14.5214.520.130.3014.22
 2nd month14.2214.220.130.3013.92
 3rd month13.9213.920.130.3013.61
 4th month13.6113.610.120.3013.31
 5th month13.3113.310.120.3013.01
 6th month13.0113.010.120.3012.71
 7th month12.7112.710.120.3012.40
 8th month12.4012.400.110.3012.10
 9th month12.1012.100.110.3011.80
 10th month11.8011.800.110.3011.50
 11th month11.5011.500.110.3011.19
 12th month11.1911.190.100.3010.89
     1.413.63 
3rdOpening Balance      
 1st month10.8910.890.100.3010.59
 2nd month10.5910.590.100.3010.29
 3rd month10.2910.290.090.309.98
 4th month9.989.980.090.309.68
 5th month9.689.680.090.309.38
 6th month9.389.380.090.309.08
 7th month9.089.080.080.308.77
 8th month8.778.770.080.308.47
 9th month8.478.470.080.308.17
 10th month8.178.170.070.307.87
 11th month7.877.870.070.307.56
 12th month7.567.560.070.307.26
     1.013.63 
4thOpening Balance 1st month  7.26  –   0.07  0.30  6.96
    7.26   
 2nd month6.966.960.060.306.66
 3rd month6.666.660.060.306.35
 4th month6.356.350.060.306.05
 5th month6.056.050.060.305.75
 6th month5.755.750.050.305.44
 7th month5.445.440.050.305.14
 8th month5.145.140.050.304.84
 9th month4.844.840.040.304.54
 10th month4.544.540.040.304.23
 11th month4.234.230.040.303.93
 12th month3.933.930.040.303.63
     0.623.63 
5thOpening Balance      
 1st month3.633.630.030.303.33
 2nd month3.333.330.030.303.02
 3rd month3.023.020.030.302.72
 4th month2.722.720.020.302.42
 5th month2.422.420.020.302.12
 6th month2.122.120.020.301.81
 7th month1.811.810.020.301.51
 8th month1.511.510.010.301.21
 9th month1.211.210.010.300.91
 10th month0.910.910.010.300.60
 11th month0.60 0.010.300.30
    12th month    0.30    –0.60   0.30    0.00    0.30    –
    0.223.63 
DOOR TO DOOR60MONTHS    
MORATORIUM      
PERIOD6MONTHS    
REPAYMENT PERIOD54MONTHS    

WORKING CAPITAL CALCULATIONS

COMPUTATION OF CLOSING STOCK & WORKING CAPITAL                                                                                                               (in Lacs)
PARTICULARS1st year2nd year3rd year4th year5th year
Finished Goods
 4.855.576.297.107.95
  Raw Material
 3.604.184.805.466.16
Closing Stock8.459.7511.0912.5614.11
COMPUTATION OF WORKING CAPITAL REQUIREMENT
TRADITIONAL METHOD(in Lacs)
Particulars Finished Goods & Raw MaterialAmount 8.45Own MarginBank Finance 
Less: Creditors2.52   
Paid stock5.9310%0.5990%5.33
Sundry Debtors3.7110%0.3790%3.34
 9.640.968.68
MPBF 8.68
WORKING CAPITAL LIMIT DEMAND (from Bank)8.50
Working Capital Margin0.94

SALARY & WAGES

BREAK UP OF LABOUR CHARGES
ParticularsWages Rs. per MonthNo of Employees Total Salary
  Plant Operator  15,000   1  15,000
Supervisor20,000 120,000
Skilled (in thousand rupees)12,000 448,000
Unskilled (in thousand rupees)8,500 434,000
Total salary per month   1,17,000
Total annual labour charges(in lacs)  14.04
BREAK UP OF STAFF SALARY CHARGES
ParticularsSalary                No of Rs. per Month      Employees Total Salary
Administrative Staff6,000424,000
Manager20,000120,000
Accountant15,000115,000
Total salary per month  59,000
Total annual Staff charges(in lacs) 7.08

4.12 POWER REQUIREMENT

Utility Charges (per month)
ParticularsValueDescription
Power connection required16KWH
consumption per day128units
Consumption per month3,200units
Rate per Unit10Rs.
power Bill per month32,000Rs.

DEPRECIATION CALCULATION

COMPUTATION OF DEPRECIATION (in Lacs)
DescriptionPlant & MachineryMiss. AssetsTOTAL
Rate of Depreciation15.00%10.00% 
Opening Balance
Addition28.501.2029.70
Total28.501.2029.70
Less: Depreciation4.280.124.40
WDV at end of Year24.231.0825.31
Additions During the Year
Total24.231.0825.31
Less: Depreciation3.630.113.74
WDV at end of Year20.590.9721.56
Additions during the Year
Total20.590.9721.56
Less: Depreciation3.090.103.19
WDV at end of Year17.500.8718.38
Additions during the Year
Total17.500.8718.38
Less: Depreciation2.630.092.71
WDV at end of Year14.880.7915.66
Additions during the Year
Total14.880.7915.66
Less: Depreciation2.230.082.31
WDV at end of Year12.650.7113.35

REPAIR & MAINTENANCE: Repair & Maintenance is 2.0% of Gross Sale.

PROJECTIONS OF PROFITABILITY ANALYSIS

PROJECTED PROFITABILITY STATEMENT   (in Lacs)
PARTICULARS1st year2nd year3rd year 4th year5th year
Capacity Utilization %50%55%60%65%70%
  SALES    
Gross Sale    
Canned Mushroom159.15189.58216.72247.03279.22
Total159.15189.58216.72247.03279.22
COST OF SALES    
Raw Material Consumed108.00125.40144.00163.80184.80
Electricity Expenses3.844.425.085.846.42
Depreciation4.403.743.192.712.31
Wages & labour14.0415.4416.9918.3519.82
Repair & maintenance3.183.794.334.945.58
Packaging11.9414.2215.1717.2919.55
Cost of Production145.39167.01188.76212.93238.48
Add: Opening Stock /WIP4.855.576.297.10
Less: Closing Stock /WIP4.855.576.297.107.95
Cost of Sales140.55166.29188.03212.13237.63
GROSS PROFIT18.6023.2928.6934.9041.59
 11.69%12.29%13.24%14.13%14.90%
Salary to Staff7.088.3510.1912.0313.71
Interest on Term Loan1.611.411.010.620.22
Interest on working Capital0.940.940.940.940.94
Rent3.603.964.364.795.27
selling & adm exp3.183.794.334.945.58
TOTAL16.4018.4620.8323.3125.72
NET PROFIT2.204.847.8611.5915.88
 1.38%2.55%3.62%4.69%5.69%
Taxation0.701.602.89
PROFIT (After Tax)2.204.847.169.9912.99

BREAK EVEN POINT ANALYSIS

BREAK EVEN POINT ANALYSIS     
YearIIIIIIIVV
      
Net Sales & Other Income159.15189.58216.72247.03279.22
Less: Op. WIP Goods4.855.576.297.10
Add: Cl. WIP Goods4.855.576.297.107.95
      
Total Sales164.00190.30217.45247.84280.07
      
Variable & Semi Variable Exp.   
Raw Material Consumed108.00125.40144.00163.80184.8 0
Electricity Exp/Coal Consumption at 85%3.263.754.324.965.46
Wages & Salary at 60%12.6714.2816.3118.2220.12
Selling & administrative expenses 80%2.553.033.473.954.47
Interest on working Capital0.9350.9350.9350.9350.935
Repair & maintenance3.183.794.334.945.58
Packaging11.9414.2215.1717.2919.55
Total Variable & Semi Variable Exp142.54165.41188.53214.11240.9 1
Contribution21.4624.8928.9133.7339.16
      
Fixed & Semi Fixed Expenses   
Electricity Exp/Coal Consumption at 15%0.580.660.760.880.96
Wages & Salary at 40%8.459.5210.8712.1513.41
Interest on Term Loan1.611.411.010.620.22
Depreciation4.403.743.192.712.31
Selling & administrative Expenses 20%0.640.760.870.991.12
Rent3.603.964.364.795.27
Total Fixed Expenses19.2620.0621.0622.1323.29
      
Capacity Utilization50%55%60%65%70%
OPERATING PROFIT2.204.847.8611.5915.88
BREAK EVEN POINT45%44%44%43%42%
BREAK EVEN SALES147.18153.33158.37162.65166.54

PROJECTED BALANCE SHEET

PROJECTED BALANCE SHEET   (in Lacs)
PARTICULARS1st year2nd year3rd year4th year5th year
Liabilities     
Capital     
opening balance 14.5016.3418.5021.49
Add: Own Capital4.30    
Add: Retained Profit2.204.847.169.9912.99
Less: Drawings2.003.005.007.009.00
Subsidy/grant10.00    
Closing Balance14.5016.3418.5021.4925.47
Term Loan14.5210.897.263.63
Working Capital Limit8.508.508.508.508.50
Sundry Creditors2.522.933.363.824.31
Provisions & Other Liab0.400.500.600.720.86
TOTAL:40.4439.1538.2238.1639.15
Assets     
Fixed Assets (Gross)29.7029.7029.7029.7029.70
Gross Dep.4.408.1411.3214.0416.35
Net Fixed Assets25.3121.5618.3815.6613.35
Current Assets     
Sundry Debtors3.714.425.065.766.52
Stock in Hand8.459.7511.0912.5614.11
Cash and Bank2.973.423.694.175.17
TOTAL:40.4439.1538.2238.1639.15

CASH FLOW STATEMENT

PROJECTED CASH FLOW STATEMENT   (in Lacs)
PARTICULARS1st year2nd year3rd year4th year5th year
SOURCES OF FUND     
Own Margin4.30    
Net Profit2.204.847.8611.5915.88
Depreciation & Exp. W/off4.403.743.192.712.31
Increase in Cash Credit8.50
Increase In Term Loan16.34
Increase in Creditors2.520.410.430.460.49
Increase in Provisions & other lib0.400.100.100.120.14
Subsidy/grant10.00    
TOTAL:48.659.0811.5814.8918.82
APPLICATION OF FUND     
Increase in Fixed Assets29.70    
Increase in Stock8.451.301.341.471.55
Increase in Debtors3.710.710.630.710.75
Repayment of Term Loan1.823.633.633.633.63
  Drawings  2.00  3.00  5.00  7.00  9.00
Taxation0.701.602.89
TOTAL :45.688.6411.3014.4117.82
  Opening Cash & Bank Balance Add : Surplus Closing Cash & Bank Balance  – 2.97 2.97  2.97 0.44 3.42  3.42 0.27 3.69  3.69 0.48 4.17  4.17 1.00 5.17

DEBT SERVICE COVERAGE RATIO

CALCULATION OF D.S.C.R
PARTICULARS1styear2ndyear3rdyear4th year5th year
      
  CASH ACCRUALS  6.60  8.58  10.35  12.70  15.30
Interest on Term Loan1.611.411.010.620.22
Total8.209.9911.3613.3215.51
      
REPAYMENT     
Instalment of Term Loan1.823.633.633.633.63
Interest on Term Loan1.611.411.010.620.22
      
Total3.425.044.644.253.85
      
DEBT SERVICE COVERAGE RATIO2.401.982.453.144.03
AVERAGE D.S.C.R.2.80

9.       Project impact

As discussed earlier, the project will have various positive impacts such as:

Infrastructure for value addition: This unit would aim to integrate and streamline existing value chains in the region by creating centralized infrastructure for value addition and preservation. The unit will thus provide benefits on cost, quality and convenience for sustainable growth in the market driven economy. The unit has been envisaged in a way that it would ensure better returns to all players in each level of value chains ranging from procurement, storage, processing, packaging to distribution of food commodities through vertical integration of functions and horizontal linkages of destinations.

Reduction of Wastages: The infrastructure created at the unit along with the integration of backward and forward linkages would lead to more efficient supply chains and reduction of wastages. This would provide higher value realization to all players in the supply chain including the farmers.

Creation of employment: The project shall generate employments. It is estimated that the it would generate direct employment of about 14 workers and indirect employment of another 30 workers. Most of the manpower requirement will be met from the local area.

Return to farmers: The unit will be benefiting farmers in the region by increasing the returns for farmers by decreasing wastages and increasing demand of the agricultural produce

Annexure

Annexure 1: Specific requirement for canning of fruits9

FruitsPreparationSyrup Strength (oB)ExhaustProcessing time                    at 100oC A2½ can) minutesType            of can
ApricotUse whole or halves, peel by dipping in boiling lye solution (2% NaOH) for 30 seconds to 1 minute, dip in cold water, cut two halves, remove pit, keep immersed in 2%salt solution until filled in can.40 + 0.1 % citric acidExhaust can at 82- 100oC for 6-10 minutes or until temperature in can center reaches 79oC.20-25Plain
PeachUse whole fruit, peel by dipping in boiling lye solution (2% (NaOH) for 30 seconds to 1-minute dip in cold water, cut two halves, remove pit, keep immersed in 2% salt solution until filled in can.40-do-25Plain
BananaPeel, cut in to slices 12mm thick30-do-25plain
GrapesDip fruit in hot water at 93oC- 96oC for 3-5 minutes, remove skin. Dip the peeled whole fruit in 2% hot lye, wash and separate the segments, fill segments in can.60Exhaust can at 82- 87oC for 25-30 minutes or until temperature at center of can reaches 79oC.30-40Plain
GuavaPeel, cut into pieces, remove seeds and keep in 2% brine to prevent browning and fill in can.40-do-20plain
LitchiPeel by hand, remove pits.40+0.5%                     citric acid-do-25plain
PineapplePeel, core and slice fruit, punch circular rings (5.6-8.8 cm diameter)40-do-25plain
PearPeel by hand, cut longitudinally into two halves, core and keep in     2%       brine  to       prevent browning until filled in cans.40+0.1%citric acid-do-20-25plain
Jack fruitCut fruit into pieces, remove bulbs, separate seed from bulbs, use whole, halves or quarters.50 + 0.5-0.75% citric acid-do-20-25plain
LoquatCut into halves40-do-25plain
MangoPeel, cut into slice, dip in 2% salt solution until filled in can.40+0.3%citric acid-do-25plain
PapayaPeel, cut into slices, discard seed45+ 0.5% citric acid-do-25plain

9 http://ecoursesonline.iasri.res.in/mod/page/view.php?id=17069

Annexure 2: Specific requirement for canning of Vegetables10

VegetablePreparationBrine strength (%)ExhaustProcessing (A2½ can) at 121oC (0.7 kg/cm2 steam pressure)Type of can
AsparagusWash, grade, cut lengthwise into pieces of desired size, blanch for 2-3 min.2.25%Exhaust can at                  90- 100oC for                    7- 10         minutes, (79oC in can center)24Plain /Sulphur resistant
BeansUse tender, stringless beans,    slice               2.5cm length, blanch and fill in can.2.25-do-40Plain/ Sulphur resistant
CabbageShred cabbage, blanch in 1% citric acid boiling solution for 5-6 min, cool in 2% brine                      prevents discolouration fill in cans2.0-do-40Plain
Cauliflower-do-2-do-20Plain
CarrotWash, scrape and blanch for 5-10 minutes in boiling water2-do-25Plain
MushroomUse tight buttons, blanch for 4-5 minutes, immerse in 2% salt solution, fill in cans.2.0+ 0.3 % citric acid+ 1% sugar-do-25Plain
PeasShell, grade, boil for 3-5 min2+2.5% sugar-do-45Sulphur resistant
PotatoPeel, keep in 2% brine, blanch in boiling water for 2-3 min, keep    in     2.5% CaCl2 for 1 hour, wash and fill in cans.2-do-45Plain
OkraTender whole, blanch in boiling water for 1-2 minutes, cool in brine solution of 1-2% for 10 minutes, fill in can.2      or        in tomato sauce-do-35Plain

10 http://ecoursesonline.iasri.res.in/mod/page/view.php?id=17069