dairy financials- business plan by abdul gafoor

9

Click here to load reader

Upload: abdul-gafoor

Post on 18-May-2015

551 views

Category:

Business


4 download

TRANSCRIPT

Page 1: Dairy Financials- Business Plan by Abdul Gafoor

A

S.no

1

2

3

4

S.no

1

1 Sq.ft

2 Sq.ft

3 Sq.ft

4 Sq.ft

5 Sq.ft

1 Sq.ftDevelopment of catchments area,

open area for animals with brick

flooring.

Cost of construction B

Amount (Rs)

50000.00

330000.00

220000.00

15000.00

15000.00

74000.0027

22000.00

15000.00

15000.00

15

10

1

1

AG Dairy Project financial analysis

Cost of animals

Amount in RsUnit priceNosParticulars

Crossbred cows ( Yielding about 4000

MURRAH Buffaloes (Yielding about

2200 liters/lactation)

TEASER BULL - Cattle

TEASER BULL - buffalo

TOATL COST OF ANIMALS 580000.00

22000.00

875

150

60000.00

150000.00

472750.00

27000.00

400

180

131250.00

22500.00

32000.00

400

80.00

150.00

Price /Sq.feet

(Rs)Total Area

150.00

Particulars

Earthwork, Levelling,Drainage

system,Iron Grills Etc

Cattle sheds: 35 Sq feet /Lactating

animals

Storage room (150 Sq .Ft)

Calf & Hiefer Houses(20 Calves @

20 Sq.ft /Calf)

150.00

150.00

Labour Hutments ( I hut ( 12 x 15')

= 180 Sq.ft.

Dry & Green Fodder house (400

Sq.ft)

Development of site

BUILDINGS

OPEN AREA

50.00 3000

730.00TOTAL COST OF

CONSTRUCTION (Rs)5005.00

Page 2: Dairy Financials- Business Plan by Abdul Gafoor

C

S.no

1

2

3

4

5

6

7

D

S.no

1

2

3

E

S.no

1

2

3

4

5

6

Price / unit

Milking Machine 1

Cost of Plant & Machinery

S S Milk cans

QuantityParticulars

Centrifuge Machine

Mechanical Chaff Cutter

1

1

5000.00

15000.00

65000.00

12000.0010

101050.00

2

1

TOTAL COST OF PLANT & MACHINERY (Rs)

S S MILK Pails

Quality Control Equipment (SETS)

2

1800.00

1000.00

1250.00Wheel Burrows

Miscellaneous fixed assets

Particulars

Furniture & Fixtures

Electrical components

Amount ( Rs)

15000.00

10000.00

Gobar gas plant 10000.00

35000.00TOTAL COST ON Misc .FIXED ASSETS ( Rs)

Priliminary & pre operativr expenses

Total (Rs)Expevted Before

production

Already Incurred

(Rs)Particulars

3000.00

25000.00

15000.00

1000.00

2000.00

2000.00

15000.00

3000.00

5000.00

Legal Expenses

Travel & transport 20000.00

2000.00

1000.00

2000.00

48000.0035000.0013000.00TOTAL

Stationay & Printing

Survey for animal sourcing

Market Survey

Salaries during implementation

Page 3: Dairy Financials- Business Plan by Abdul Gafoor

F

S.no

1

2

3

4

5

6

1

2

S.no

1

2

3

4

5

6

7

8

Provisions for Contengencies

ParticularsConsidered Firm

(Rs)

Considered non-

Firm(Rs)

Land

Building & sheds 422750.00

Machinery & Equipment 101050.00

Animal 520000.00

Misc. Fixed Assets 35000.00

Preliminary Expenses 48000.00

1078800.00

48000.00

Provisions for contingencies (Rs) 1126800.00 54420.00

1078800.00

480.00

53940.00

TOTAL CAPITAL COST

Firm Items @ 1 % of Rs

Non - Firm Items @ 5 % of Rs

48000.00

Cost of the project - Overall

Particulars Amount ( Rs)

MARGIN MONEY FOR WORKING CAPITAL 44582.00

Cost of Animals

TECHNICAL CONSULTANCY FEE

580000.00

TOTAL COST ON Misc .FIXED ASSETS ( Rs) 1360802.00

TOTAL COST OF CONSTRUCTION (Rs)

TOTAL COST OF PLANT & MACHINERY (Rs)

PROVISIONS FOR CONTIGENCIES

472750.00

101050.00

54420.00

TOTAL COST ON Misc .FIXED ASSETS ( Rs)

PRILIMINARY & PRE OPERATIVE EXPENSES

35000.00

48000.00

FEEDING REQUIREMENTS A

25000.00

Page 4: Dairy Financials- Business Plan by Abdul Gafoor

S.No Year - I Year - II Year - III Year- IV Year -V

1 15857.14 15857.14 15857.14 15857.14 15857.14

2 7405.71 7405.71 7405.71 7405.71 7405.71

3 1332.57 1332.57 1332.57 1332.57 1332.57

4 888.57 888.57 888.57 888.57 888.57

5 2221.71 2221.71 2221.71 2221.71

6 1481.14 1481.14 1481.14 1481.14

7

8

9

10 1481.14 1481.14 1481.14 1481.14 1481.14

26965.14 30668.00 30668.00 30668.00 30668.00

B

S.No Year - I Year - II Year - III Year- IV Year -V

1 27750.00 27750.00 27750.00 27750.00 27750.00

2 18500.00 18500.00 18500.00 18500.00 18500.00

3 3196.00 3196.00 3196.00 3196.00 3196.00

4 2131.00 2131.00 2131.00 2131.00 2131.00

5 5994.00 5994.00 5994.00 5994.00

6 3996.00 3996.00 3996.00 3996.00

7 7992.00 7992.00 7992.00

8 5328.00 5328.00 5328.00

9 6660.00 6660.00

10 3700.00 3700.00 3700.00 3700.00 3700.00

55277.00 65267.00 78587.00 85247.00 85247.00

Diet /day

25kg /Cow/Day

25kg /Cow/Day

Particulars

Adult Cows

Adult Buffaloes

GREEN FODDER ( January 2006 - April 2006)

6kg/Calf/ Day

6kg/Calf/ Day

10kg/Calf/ Day

10kg/Calf/ Day

14kg / Heifers / Day

14kg / Heifers / Day

18kg / Heifers / Day

18kg / Bull / Day

Calves below 1 year (Cow)

Calves below 1 year (Buf)

Calves 1- 2 years ( cows)

Calves 1- 2 years ( Buff)

Heifers 2 -3 (Cows)

Heifers 2 -3 (Buff )

Buffalo heifers in lactation

Service Bulls

Diet /day

COST OF GREEN FODDER (Rs)

GREEN FODDER ( April 2006 - September 2006)

Particulars

25kg /Cow/Day

Adult Buffaloes 25kg /Cow/Day

Calves below 1 year (Cow) 8kg/Calf/ Day

Adult Cows

Calves below 1 year (Buf) 8kg/Calf/ Day

Calves 1- 2 years ( cows) 15kg/Calf/ Day

Calves 1- 2 years ( Buff) 15kg/Calf/ Day

Heifers 2 -3 (Cows) 20kg / Heifers / Day

Heifers 2 -3 (Buff ) 20kg / Heifers / Day

Buffalo heifers in lactation 25kg / Heifers / Day

Service Bulls 25kg / Bull / Day

COST OF GREEN FODDER (Rs)

Page 5: Dairy Financials- Business Plan by Abdul Gafoor

C

S.No Year - I Year - II Year - III Year- IV Year -V

1 11892.86 11892.86 11892.86 11892.86 11892.86

2 5554.29 5554.29 5554.29 5554.29 5554.29

3 999.43 999.43 999.43 999.43 999.43

4 666.43 666.43 666.43 666.43 666.43

5 1666.29 1666.29 1666.29 1666.29

6 1110.86 1110.86 1110.86 1110.86

7

8

9

10 1110.86 1110.86 1110.86 1110.86 1110.86

20223.86 23001.00 23001.00 23001.00 23001.00

D

S.No Year - I Year - II Year - III Year- IV Year -V

1 15428.57 15428.57 15428.57 15428.57 15428.57

2 10285.71 10285.71 10285.71 10285.71 10285.71

3 1666.29 1666.29 1666.29 1666.29 1666.29

4 1110.86 1110.86 1110.86 1110.86 1110.86

5 3332.57 3332.57 3332.57 3332.57

6 2221.71 2221.71 2221.71 2221.71

7 4443.43 4443.43 4443.43

8 2962.29 2962.29 2962.29

9 3702.86 3702.86

10 2057.14 2057.14 2057.14 2057.14 2057.14

GREEN FODDER ( October 2006 - December 2006)

Diet /day

Adult Cows 25kg /Cow/Day

Adult Buffaloes 25kg /Cow/Day

Particulars

Calves below 1 year (Cow) 6kg/Calf/ Day

Calves below 1 year (Buf) 6kg/Calf/ Day

Calves 1- 2 years ( cows) 10kg/Calf/ Day

Calves 1- 2 years ( Buff) 10kg/Calf/ Day

Heifers 2 -3 (Cows) 14kg / Heifers / Day

Heifers 2 -3 (Buff ) 14kg / Heifers / Day

COST OF GREEN FODDER (Rs)

Buffalo heifers in lactation 18kg / Heifers / Day

Service Bulls 18kg / Bull / Day

DRY FODDER ( January 2006 - April 2006)

Particulars Diet /day

Adult Cows 5kg /Cow/Day

Adult Buffaloes 5kg /Cow/Day

Calves below 1 year (Cow) 1.5kg/Calf/ Day

Calves below 1 year (Buf) 1.5kg/Calf/ Day

Calves 1- 2 years ( cows) 3kg/Calf/ Day

Calves 1- 2 years ( Buff) 3kg/Calf/ Day

Heifers 2 -3 (Cows) 4kg / Heifers / Day

Heifers 2 -3 (Buff ) 4kg / Heifers / Day

Buffalo heifers in lactation 5kg / Heifers / Day

Service Bulls 5kg / Heifers / Day

Page 6: Dairy Financials- Business Plan by Abdul Gafoor

30548.57 36102.86 43508.57 47211.43 47211.43

E

S.No Year - I Year - II Year - III Year- IV Year -V

1 22200.00 22200.00 22200.00 22200.00 22200.00

2 14800.00 14800.00 14800.00 14800.00 14800.00

3 1998.00 1998.00 1998.00 1998.00 1998.00

4 1332.00 1332.00 1332.00 1332.00 1332.00

5 3996.00 3996.00 3996.00 3996.00

6 2664.00 2664.00 2664.00 2664.00

7 5994.00 5994.00 5994.00

8 3996.00 3996.00 3996.00

9 5328.00 5328.00

10 2960.00 2960.00 2960.00 2960.00 2960.00

43290.00 49950.00 59940.00 65268.00 65268.00

F

S.No Year - I Year - II Year - III Year- IV Year -V

1 11571.43 11571.43 11571.43 11571.43 11571.43

2 7714.29 7714.29 7714.29 7714.29 7714.29

3 1249.71 1249.71 1249.71 1249.71 1249.71

4 833.14 833.14 833.14 833.14 833.14

5 2499.43 2499.43 2499.43 2499.43

6 1666.29 1666.29 1666.29 1666.29

7 3332.57 3332.57 3332.57

8 2221.71 2221.71 2221.71

9 2777.14 2777.14

10 1542.86 1542.86 1542.86 1542.86 1542.86

COST OF DRY FODDER (Rs)

DRY FODDER ( April 2006 - September 2006)

Particulars Diet /day

Adult Cows 4kg /Cow/Day

Adult Buffaloes 4kg /Cow/Day

Calves below 1 year (Cow) 1kg/Calf/ Day

Calves below 1 year (Buf) 1kg/Calf/ Day

Calves 1- 2 years ( cows) 2kg/Calf/ Day

Calves 1- 2 years ( Buff) 2kg/Calf/ Day

Heifers 2 -3 (Cows) 3kg / Heifers / Day

Heifers 2 -3 (Buff ) 3kg / Heifers / Day

Buffalo heifers in lactation 4kg / Heifers / Day

Service Bulls 4kg / Heifers / Day

COST OF DRY FODDER (Rs)

DRY FODDER ( October 2006 - December 2006)

Particulars Diet /day

Adult Cows 25kg /Cow/Day

Adult Buffaloes 25kg /Cow/Day

Calves below 1 year (Cow) 6kg/Calf/ Day

Calves below 1 year (Buf) 6kg/Calf/ Day

Calves 1- 2 years ( cows) 10kg/Calf/ Day

Calves 1- 2 years ( Buff) 10kg/Calf/ Day

Heifers 2 -3 (Cows) 14kg / Heifers / Day

Heifers 2 -3 (Buff ) 14kg / Heifers / Day

Buffalo heifers in lactation 18kg / Heifers / Day

Service Bulls 18kg / Bull / Day

Page 7: Dairy Financials- Business Plan by Abdul Gafoor

22911.43 27077.14 32631.43 35408.57 35408.57

S.No Year - I Year - II Year - III Year- IV Year -V

1 104700.00 104700.00 104700.00 104700.00 104700.00

2 64260.00 64260.00 64260.00 64260.00 64260.00

3 10442.00 10442.00 10442.00 10442.00 10442.00

4 6962.00 6962.00 6962.00 6962.00 6962.00

5 0.00 19710.00 19710.00 19710.00 19710.00

6 0.00 13140.00 13140.00 13140.00 13140.00

7 0.00 0.00 21762.00 21762.00 21762.00

8 0.00 14508.00 14508.00 14508.00

9 0.00 0.00 18468.00 18468.00

10 12852.00 12852.00 12852.00 12852.00 12852.00

199216.00 232066.00 268336.00 286804.00 286804.00

G

S.No Year - I Year - II Year - III Year- IV Year -V

1 142350.00 142350.00 142350.00 142350.00 142350.00

2 94900.00 94900.00 94900.00 94900.00 94900.00

3 25623.00 25623.00 25623.00 25623.00 25623.00

4 17082.00 17082.00 17082.00 17082.00 17082.00

5 38434.00 38434.00 38434.00 38434.00

6 25623.00 25623.00 25623.00 25623.00

7 64057.00 64057.00 64057.00

COST OF DRY FODDER (Rs)

CONCENTRATES ( January - December 2006)

Particulars Diet /day

Adult Cows

Adult Buffaloes

Calves below 1 year (Cow)

Heifers 2 -3 (Cows)

Calves below 1 year (Buf)

Calves 1- 2 years ( cows)

Service Bulls

COST OF TOTAL FODDER (Rs)

TOTAL FODDER COST (GREEN + DRY ) ( January -December 2006)

Heifers 2 -3 (Buff )

Buffalo heifers in lactation

Calves 1- 2 years ( Buff)

Particulars Diet /day

Adult Cows 7kg /Cow/Day

Adult Buffaloes 7kg /Cow/Day

Calves below 1 year (Cow) 0.5kg/Calf/ Day

Calves below 1 year (Buf) 0.5kg/Calf/ Day

Calves 1- 2 years ( cows) 1.5kg/Calf/ Day

Calves 1- 2 years ( Buff) 1.5kg/Calf/ Day

Heifers 2 -3 (Cows) 4kg / Heifers / Day

Page 8: Dairy Financials- Business Plan by Abdul Gafoor

8 42705.00 42705.00 42705.00

9 6.00 6.00 6.00 6.00 6.00

10 4745.00 4745.00 4745.00 4745.00 4745.00

10 7117.00 7117.00 7117.00 7117.00 7117.00

291823.00 355880.00 462642.00 462642.00 462642.00

H

S.No Year - I Year - II Year - III Year- IV Year -V

1 142350.00 142350.00 142350.00 142350.00 142350.00

2 94900.00 94900.00 94900.00 94900.00 94900.00

237250.00 237250.00 237250.00 237250.00 237250.00

S.No Year - I Year - II Year - III Year- IV Year -V

491039.00 587946.00 730978.00 749446.00 749446.00

G

S.No

1

2

3

4

5

6

7

8

9

Amount (Rs)

CONSUMABLES STORES ( January - December-2006 2006)

Rate (Rs)

Hydrogen Peroxide

Pott. Permenganate

Particulars Quantity

Washing powder

Heifers 2 -3 (Buff ) 4kg / Heifers / Day

Buffalo heifers in lactation 5kg / Heifers / Day

Service Bulls 2kg / Bull / Day

COST CONCENTRATES (Rs)

Service Bulls ( Buffaloes) 2kg / Bull / Day

STARTER RATION ( January - December 2006)

Particulars Diet /day

Cattle Calves 7kg /Cow/Day

Buffaloes Calves 7kg /Cow/Day

COST OF STARTER RATION

TOTAL FEEDING COST ( January - December 2006)

Particulars Diet /day

Page 9: Dairy Financials- Business Plan by Abdul Gafoor

10

0.00 0.00 0.00 0.00 0.00TOTAL CONSUMABLE STORES (Rs)