jagomart
digital resources
picture1_Cost Sheet Format In Excel 42179 | Machinery Costing Calculator (ahdb)


 227x       Filetype XLSX       File size 0.05 MB       Source: projectblue.blob.core.windows.net


File: Cost Sheet Format In Excel 42179 | Machinery Costing Calculator (ahdb)
sheet 1 hectare machinery costing calculatormachinery costs calculation per hectare note edit blue cells only pound purchase price enter the cost of purchase 126 000 selling price after number of ...

icon picture XLSX Filetype Excel XLSX | Posted on 15 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Hectare
Machinery costing calculator:
Machinery costs calculation (per hectare)
Note: Edit blue cells only*













£





Purchase price

Enter the cost of purchase 126,000
Selling price after Number of years you will keep before replacing 8 Years Projected resale value 34,000
Hectares worked annually

Hectares covered annually 1,200





Fixed costs



Average value per year owned

80,000
Interest purchase or you would receive on the funds if you did not spend it 2 % rate 1,600
Annual depreciation

11,500
Insurance Cost of insuring the macheinery as a % of purchase price (0.5-3%) 2 % of purchase price 2,520
Building/storage cost Cost of storing the macheinery while not in use (under cover or not) (0-3% of purchase cost) 1 % of purchase price 1,260





Total annual fixed cost

16,880





Fixed cost per hectare

14.07





Operating costs



Ha covered/worked number of Ha that can be worked/covered in an hour 4 Per Hr

Labour cost Labour cost per hour for macheinery opporation 14 £/Hr

Labour per Ha

£3.50
Fuel price (click for price data) Average price of fuel 0.53 £/L

Fuel consumption (click for typical figures, see page 12) litres of fuel used. For general figures use the link. 20.00 L/Ha

Cost of fuel per Ha

£10.60
Spares and repairs Cost as a % of purchased price - for budget purposes. Refere to 'Repair costs' tab. 2 % of purchase price £2.10





Total cost per Ha

£30.27





Contractors/machinery ring charge per Ha

Price that would have to be paid to contractor/machinery ring per ha £76.00
(Click for typical contractor charges)








Annual savings by using contractor and not purchasing

-£54,880
-£ would suggest you may be better purchasing








*Note: Blue cells pre-populated for illustrative purposes only





















































































































































































Sheet 2: Hour
Machinery costing calculator:
Machinery costs calculation (per hour)
Note: Edit blue cells only*













£





Purchase price

Enter the cost of purchase 92,751
Selling price after Number of years you will keep before replacing 7 Years Projected resale value 40,000
Hours worked annually

Hectares covered annually 700





Fixed costs



Average value per year owned

66,376
Interest purchase or you would receive on the funds if you did not spend it 2 % rate 1,328
Actual annual depreciation

7,536
Insurance Cost of insuring the macheinery as a % of purchase price (0.5-3%) 2 % of purchase price 1,855
Building /storage cost Cost of storing the macheinery while not in use (under cover or not) (0-3% of purchase cost) 1 % of purchase price 928





Total annual fixed cost

11,646





Fixed cost per hour

17





Operating costs



Ha covered/worked per hour number of Ha that can be worked/covered in an hour 4 Per Hr

Fuel price (click for price data) Consumption of fuel litres per ha for the macheinery opporation. 14 £/Hr

Fuel consumption (click for typical figures, see page 12) Average price of fuel 0.6 £/Lt

Cost of fuel per hour

34
Spares and repairs Cost as a % of purchased price - see tab 'Repair Costs' for relivent % 1 % of purchase price 1
Labour cost per hour

Labour cost per hour for machinery opporation 14





Total cost per hour

66





Contractors/machinery ring charge per hour

Price that would have to be paid to contractor/machinery ring per hour 45
(Click for typical contractor charges)








Annual savings by using contractor and not purchasing

£14,393
-£ would suggest you may be better purchasing








*Note: Blue cells pre-populated for illustrative purposes only







































































































































































































































Sheet 3: Workrate
Machinery costing calculator:
Workrate (compare between to machines)
Note: Edit blue cells only*













Model Model

A B
Input


Implement width (m) 4 30
If not appliying anything set to zero. Capacity (kg or L) 800 2000
Forward speed (km/Hr) 6 12
If not appliying anything set to zero. Application rate 180 250
If not leaving the field to re-fill, set to zero Transport time, one way (min) 5 5
If not re-filling set to zero Filling time (min) 10 10
Gap between spot rate output and actual time spent in field completing task. Field efficiency (%) 65 75








Output


Area covered per load (ha) 4.44 5.00
Filling rate (kg/min or L/min) 80.00 200.00
Spot work rate (Ha/Hr) 2.40 36.00
Total time per load (min) 190.94 31.11
Overall work rate (Ha/Hr) 1.40 9.64
Overall efficiency (%) 58.19 26.79




Components


Application time per load (min) 170.94 11.11
Application time (%) 89.53 35.71
Filling time per load (min) 10.00 10.00
Filling time (%) 5.24 32.14
Transport time per load (min) 10.00 10.00
Transport time (%) 5.24 32.14




*Note: Blue cells pre-populated for illustrative purposes only

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet hectare machinery costing calculatormachinery costs calculation per note edit blue cells only pound purchase price enter the cost of selling after number years you will keep before replacing projected resale value hectares worked annually covered fixed average year owned interest or would receive on funds if did not spend it rate annual depreciation insurance insuring macheinery as a buildingstorage storing while in use under cover total operating ha coveredworked that can be workedcovered an hour hr labour for opporation fuel click data l consumption typical figures see page litres used general link lha spares and repairs purchased budget purposes refere to repair tab contractorsmachinery ring charge have paid contractormachinery contractor charges savings by using purchasing suggest may better prepopulated illustrative hours actual building storage lt relivent workrate calculatorworkrate compare between machines model b input implement width m appliying anything set zero capaci...

no reviews yet
Please Login to review.