€PM

Dairy Input SheetTeagasc e-PM

your essential tool for improving farm profit

V 3.0

9776 DAIRY INPUT SHEET:Layout 1 25/11/2008 11:03 Page 1

Number Value € / hd Number Total € Number Total € Number Value € / hd Use monthlystock table

New Born Dairy Calves

Dairy Cows

Suckler Cows

Stock Bulls

Rep Heifers 0-1 yrs

Rep Heifers 1-2 yrs

Rep Heifers 2+ yrs

Cattle 0-1 yrs

Cattle 1-2 yrs

Cattle 2+ yrs

Ewes

Rams

Stores /Hoggets

Lambs

Wool

Note:- Enter number of animals sold & purchased along with total value

Livestock Opening Sales Purchases Closing Average Number

Teagasc e-Profit Monitor Dairy Input Sheet

/ / 20

see notes

Yes No

(for main operator & family labour)

IE

PPSN required for new ePM clients only

Personal Details

Name

Teagasc Customer No.

Herd Identifier

PPSN

Address

Tel.

Year End Date

Production Type

Registered for VAT

If you are registered for VAT all income and expenses should not include VAT

Avg no. of unpaid labour hours per week

Labour Hour Charge €

Land Details Optional Enterprise BreakdownStock Dairy Repl. Cattle Sheep Tillage

Owned Land (Adj. Ha) ha ha

Leased Land (Adj. Ha) ha ha

Cost of Lease (Total €) €

Total (A) ha Total (B) ha

Grass Ha Cereals Ha

Maize Ha Beet Ha

Whole Crop Ha Potatoes Ha

Root Crop Forage Ha Forage Sold Ha

= Total (A) = Total (B)

Dairy Milking Platform Ha ha

Quota Details

Owned Quota lit

Leased Quota lit

Cost of Leased Quota (Total €)

Total Liquid Quota lit

include a value for this seasons crops not yet soldand a value for crops fed on the farmTillage Sales € Stock Bull Usage

Other Farm Income (Net) €

eg if bull is used for Replacements only put 100% under Repl. heading (Total must = 100%)

Dairy % Repl. % Cattle %

% % %

Milk Sales Direct Payments Livestock Tranfers

Litres Sold lit Single Farm Payment € Calves to 0-1 Dairy Repl.'s hd

Litres Calves /House lit REPS € Calves to 0-1 Cattle hd

Net Value Litres Sold Compensatory Allowance € Repl.'s to Dairy Cows hd

Fat % % Specific Dairy Premia € Cattle kept as Suckler Cows hd

Protein % % Specific Cattle Premia € Ewe Lambs Retained hd

SCC ,000 Specific Sheep Premia €

Setaside Ents. & Tillage Premia €

€

Number Value €/hd

€

9776 DAIRY INPUT SHEET:Layout 1 25/11/2008 11:03 Page 2

Balance SheetAssets Opening Net Invested Closing Opening Closing

Land Owned Adj. ha Value € /ha Total € Value € Adj. ha Value € /ha Total € Other Stock Value € Value €

Stock Feed (€)

Tillage Forage (€)

Fertiliser (€)

Owned Quota & Entitlement Value Net Invested Crops (€)

Units Value € /unit Total € Value € Units Value € /unit Total € Seed (€)

Milk Quota Spray (€)

SPS Entitlement

The asset value of the Single Payment Scheme entitlement should be entered here

Opening Net Invested Depreciation Closing

Value € + Value € - Value € = Value €

Buildings (€)

Machinery incl. Car (€)

House (& Other Property) (€)

Investments / Savings (€)

Pension (€)

Debtors (€)

Cash on Hand (€)

As for fixed costs

Liabilities Opening Closing

Bal. € Bal. €

Bank OD (€)

Owed to Merchants etc. (€)

Loans (Farm) (€)

Loans (Non Farm) (€)

Variable Costs Optional Enterprise BreakdownStock € Dairy € Repl. € Cattle € Sheep € Tillage €

Purchased Concentrate (€)

Home Grown Concentrate (€)

Purchased Forage (€)

Fertiliser (€) Fertiliser (€)

Lime (€) Lime (€)

Veterinary (€)

AI / Breeding (€)

Contractor (€) Contractor (€)

Seed and Spray (€) Seed and Spray (€)

Milk Recording & Parlour (€)

Silage Additive & Polythene (€)

Levies and Transport (€) Levies and Transport (€)

Straw (€)

Sundry Var. Costs (€) Sundry Var. Costs (€)

Fixed Costs Fixed Costs All € Stock € Tillage € All € Stock € Tillage €

Hired Labour Hired Labour (€) Depreciation Dep. Build. (€)

Machinery Mach. Running (€) Dep. Machinery (€)

Mach. Leases (€) Other Repairs and Maint. (€)

Interest Payments OD & Credit Int. (€) Insurance (€)

Loan Interest (€) Prof. Fees (€)

Car ESB and Phone Car (Farm) (€) Sundry Fixed Costs (€)

E.S.B. (Farm) (€)

Phone (Farm) (€)

Optional Fixed Cost Allocation Dairy € Repl. € Cattle € Sheep € Tillage €

Enter cost heading here

9776 DAIRY INPUT SHEET:Layout 1 25/11/2008 11:03 Page 3

Dairy Physical Data

Calving start date Total Calvings

Calving end date Number calved in 1st 6 weeks

Number calved in Feb/ March

Herd EBI (from latest available EBI report)

Dairy Cow Conc. Replacement Conc. Cattle Conc.

Avg Concentrate cost (€/ tonne)

Turnout Date to Grass by Day Housing Date (Cows in Fully)

Turnout Date to Grass Fully

Date of end of 1st grazing rotation

of which

Date Cut Total Ha Cut Milking Platform Ha Cut

1st Cut Silage

2nd Cut Silage

3rd Cut Silage

Teagasc e-Profit Monitor Dairy Input Sheet

Monthly Livestock Table

Start End End End End End End End End End End End End Total Average Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec (total/12)

Dairy Cows

Suckler Cows

Stock Bulls

Rep Heifers 0-1 yrs

Rep Heifers 1-2 yrs

Rep Heifers 2+ yrs

Cattle 0-1 yrs

Cattle 1-2 yrs

Cattle 2+ yrs

Total

Ewes

Rams

Stores /Hoggets

Lambs

Total

Use this Monthly Livestock Table to compute accurate Average Stock Numbers

Notes

Production Type

1. Creamery Calving start before Jan 30

2. Creamery Calving start after Jan 30

3. Liquid < 30% Autumn Calving

4. Liquid 30% - 60% Autumn Calving

5. Liquid > 60% Autumn Calving

• Shaded boxes are for Optional Enterprise Breakdown and do not have to be filled in Livestock Transfers are for animals that stay

on the farm and move from one enterprise to another eg dairy calf to beef etc.

• Teagasc guideline figures are available for opening and closing stock values.

• Use the Monthly Livestock Table to compute accurate Average Stock Numbers.

• Concentrate, Forage and AI / Breeding have to be allocated to each enterprise.

• tock Bull Usage % should indicate how much of the bull cost should be associated with each enterprise.

9776 DAIRY INPUT SHEET:Layout 1 25/11/2008 11:03 Page 4