Get documents about "Blank Salary Slip Format - Excel
Description
Blank Salary Slip Format document sample
Document Sample
UC COOPERATIVE EXTENSION
SAMPLE COSTS TO ESTABLISH A VINEYARD AND PRODUCE WINE GRAPES
SAN JOAQUIN VALLEY - NORTH
The sample costs to establish and vineyard and produce Chardonnay wine grapes in the Sacramento and
San Joaquin counties are presented in this study. All sample costs presented are considered typical for this region.
The worksheets are organized as follows:
ESTABLISHMENT This sheet summarizes the costs to establish a new vineyard. You
can modify the costs on this worksheet to more accurately reflect your
own operation.
COSTS PER ACRE - USER INPUT This sheet shows production costs. You can alter the costs shown,
add additional operations, and modify the timing of operations to more
accurately reflect your own enterprise.
COSTS PER ACRE - OUTPUT This sheet summarizes costs from the user input sheet in a printer-friendly
format. Numbers on this sheet are calculated from the previous sheet and
cannot be altered directly.
MONTHLY COSTS - OUTPUT This sheet breaks down the costs per acre on a month-by-month basis.
Numbers on this sheet are calculated from the input sheet and cannot be
altered directly.
RANGING ANALYSIS This worksheet shows costs and returns per acre at varying yields. You can
change the default harvest costs, yields, and prices in the Input Table at the
top of the sheet. Note that changes made on this sheet will not be reflected
in the Costs Per Acre sheets.
Please note that throughout this workbook, numbers in yellow shading can be changed directly by the user,
while numbers in blue shading result from formulas and cannot be changed directly.
For more information about the study and how costs were derived, please consult the PDF file "Sample Costs to
Establish a Vineyard and Produce Wine Grapes - San Joaquin Valley - North" available at:
http://coststudies.ucdavis.edu/uploads/cost_return_articles/grapewinelodi2005.pdf
UC COOPERATIVE EXTENSION
SAMPLE COSTS PER ACRE TO ESTABLISH A VINEYARD
SAN JOAQUIN VALLEY - NORTH
The costs below are considered typical. If you choose to change them to reflect your own enterprise,
total costs in blue shading will automatically be recalculated. If you wish to add additional operations, click
in a cell labeled "Additional operation", type the name of the new operation, and enter costs in the
appropriate columns.
Cost Per Acre
Year 1st 2nd 3rd
Tons Per Acre 3.0
Planting Costs:
Vineyard Removal - Custom 350
Land Prep: Slip Plow 2X - Custom 600
Land Prep: Disc 4X - Custom 140
Land Prep: Fumigate - Custom 1,200
Land Prep: Cultivate 1X ( Disc + Cultipacker ) - Custom 35
Land Prep: Apply Herbicide & Incorporate (Treflan) 33
Land Prep: Float/Triplane 2X - Custom 40
Mark, Layout, Stake Vineyard (stakes included in trellis costs) 45
Dig Hole, Plant, Wrap Vines 228 21
Vines: 622 Per Acre (2% Replant in 2nd Year) 1,773 37
Additional Operation
Additional Operation
TOTAL PLANTING COSTS 4,444 58 0
Other Costs:
Install Trellis: Custom 2,808
Install Drip System: Custom 1,200
TOTAL OTHER SYSTEM COSTS 4,008 0 0
Cultural Costs:
Prune: Hand 106 153
Irrigate 67 96 126
Fertilize: (5-0-12) 31 31 31
Train: Green Tie (Sucker, Tie & Train) 3X 649 343
Weed: Winter Strip Spray (Yr 1 & 2, Goal, Prowl, Roundup. Yr 3, Surflan, Goal, Roundup) 79 79 119
Weed: Hand 123 123
Weed: Disc (3X Year 1, 5X Year 2-3) 37 62 62
Weed: Summer Strip Spray (Roundup) 25 25
Insect: Leafhoppers (Provado) 65
Shoot Positioning/ Thin 153
Disease: Mildew 5X (Dusting Sulfur) 45
Disease: Mildew 1X (Rally) 52
Disease: Mildew (Flint) 65
Trim Vines: (mechanical) 11
Pickup Truck Use 26 26 27
ATV Use 16 16 16
Additional Operation
Additional Operation
Additional Operation
TOTAL CULTURAL COSTS 379 1,213 1,293
Harvest Costs:
Pick Fruit: Custom (machine harvest) 275
Haul to Winery 45
TOTAL HARVEST COSTS 0 0 320
Assessments:
Lodi - Woodbridge Winegrape Commission & CDFS Sharpshooter 9
TOTAL ASSESMENT COSTS 0 0 9
Interest On Operating Capital 338 32 41
calculated using interest rate of: 7.65%
TOTAL OPERATING COSTS/ACRE 9,169 1,303 1,654
Cash Overhead Costs:
Office Expense 125 125 125
Liability Insurance 4 4 4
Sanitation Fees 10 10 10
Manager Salary 351 351 351
Property Taxes 161 161 161
Property Insurance 5 5 6
Investment Repairs 21 21 21
TOTAL CASH OVERHEAD COSTS 677 677 678
TOTAL CASH COSTS/ACRE 9,846 1,980 2,332
INCOME/ACRE FROM PRODUCTION 0 0 1,350
calculated using price/ton of: 450
NET CASH COSTS/ACRE FOR THE YEAR 9,846 1,980 982
PROFIT/ACRE ABOVE CASH COSTS 0 0 0
ACCUMULATED NET CASH COSTS/ACRE 9,846 11,826 12,809
Non-Cash Overhead Costs (Capital Recovery):
Captial Recovery Cost:
Shop Building 30 30 30
Fuel Tanks 1 1 1
Shop Tools 6 6 6
Irrigation System (well & pump) 46 46 46
Land 925 925 925
Equipment 29 27 57
TOTAL NON-CASH OVERHEAD COST/ACRE 1,037 1,035 1,065
TOTAL COST/ACRE FOR THE YEAR 10,883 3,015 3,397
INCOME/ACRE FROM PRODUCTION 0 0 1,350
TOTAL NET COST/ACRE FOR THE YEAR 10,883 3,015 2,047
NET PROFIT/ACRE ABOVE TOTAL COST 0 0 0
TOTAL ACCUMULATED NET COST/ACRE 10,883 13,898 15,946
UC COOPERATIVE EXTENSION
COSTS PER ACRE TO PRODUCE WINE GRAPES
SAN JOAQUIN VALLEY - NORTH
The costs below are considered typical. If you choose to change them to reflect your own enterprise, The calendar below shows how many times each operation is performed in each
total costs in blue shading on this sheet and monthly costs on the next sheet will automatically be month in a typical, well-managed vineyard. For irrigation, it shows the number of
recalculated. If you wish to add additional operations, click in a cell labeled "Additional operation", acre-inches of water applied. For dusting sulphur, it shows the number of pounds
type the name of the new operation, and enter the costs in the appropriate columns. of sulfur applied. If you choose to change these numbers to reflect your own enterprise,
Warning: Blue shaded cells are protected and cannot be changed. the monthly costs on the next sheet will automatically be recalculated.
Cash and Labor Costs per Acre Total
Labor Fuel, Lube Material Custom/ Annual
Operation Cost & Repairs Cost Rent Cost JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
Cultural:
Weed: Winter Strip Spray (Surflan, Goal, Roundup) 12 3 103 0 118 1
Prune: Hand 278 0 0 0 278 1
Prune: Chop/Shred Prunings 5 4 0 0 9 1
Weed: Disc 4X 29 20 0 0 49 1 1 1 1
Prune: Winter Tie 81 0 12 0 93 1
Prune: Trunk Sucker 51 0 0 0 51 1
Disease: Mildew 5X (Sulfur Dust) 25 7 14 0 46 15 45 15
Irrigate: 46 0 80 0 126 1.5 1.5 3.0 3.5 3.5 1.5 1.5
Prune: Shoot Removal/Shoot Position 153 0 0 0 153 1
Fertilize: through drip 2X (5-0-12) 0 0 37 0 37 1 1
Prune: Leaf Removal 153 0 0 0 153 1
Prune: Trim Vines (mechanical) 12 10 0 0 22 1 1
Disease: Mildew (Rally), Insect: Lafhopper (Provado) 18 14 52 0 84 1
Weed: Summer Strip Spray - (Roundup) 12 3 10 0 25 1
Disease: Mildew (Flint). Insect: Mites (Omite) 18 14 91 0 123 1
Pickup Truck Use 15 12 0 0 27 1 1 1 1 1 1 1 1 1 1 1 1
ATV Use 15 1 0 0 16 1 1 1 1 1 1 1 1 1 1 1 1
Additional operation 0 0 0 0 0 1
Additional operation 0 0 0 0 0
TOTAL CULTURAL COSTS 923 88 399 0 1,410
Harvest:
Machine Harvest 0 0 0 275 275 1
Haul to Winery 0 0 0 98 98 1
TOTAL HARVEST COSTS 0 0 0 373 373
Assessment:
Crop Assessments 0 0 20 0 20 1
TOTAL ASSESMENT COSTS 0 0 20 0 20
Interest on operating capital Interest rate= 7.65% 50
TOTAL OPERATING COSTS/ACRE 923 88 419 373 1,803
CASH OVERHEAD:
Office Expense 125 1 1 1 1 1 1 1 1 1 1 1 1
Liability Insurance 4 1
Sanitation Fees 10 1 1 1 1 1 1 1 1 1 1 1 1
Manager Salary 351 1 1 1 1 1 1 1 1 1 1 1 1
Property Taxes 226 1 1
Property Insurance 50 1 1
Investment Repairs 278 1 1 1 1 1 1 1 1 1 1 1 1
TOTAL CASH OVERHEAD COSTS 1,044
TOTAL CASH COSTS/ACRE 2,847
ANNUAL INVESTMENT COSTS TO PRODUCE WINE GRAPES
INSTRUCTIONS: Fill in the yellow shaded areas in the INPUT TABLE to change
default values for the total number of producing acres that use these investments and for the
interest rate. The purchase price, years of life, and salvage value can also be changed.
INPUT TABLE
No. of Total Farm Producing Acres 200
No. Established Acres 60
Interest Rate 6.01%
Capital Capital
Yrs Salvage Recovery Capital Recovery
Description Price Life Value Factor Recovery Per Acre
INVESTMENT
Buildings 2,400 sq ft 80,000 30 0.07 5,818 29
Fuel Tanks: 2-500 Gal 3,500 25 1,295 0.08 250 1
Irrigation System (well, pump, 60 acres) 35,000 25 0.08 2,741 46
Land (200 acres) 3,000,000 25 3,000,000 0.08 180,300 902
Tools-Shop/Field 12,000 15 1,133 0.10 1,188 6
Vineyard Establishment 771,120 22 0.08 64,094 1,068
Equipment 91,563 11 23,981 0.13 10,015 50
TOTAL INVESTMENT 3,993,183 3,026,409 264,405 2,102
UC COOPERATIVE EXTENSION
COSTS PER ACRE TO PRODUCE WINE GRAPES
SAN JOAQUIN VALLEY - NORTH
Cash and Labor Costs per Acre Total
Labor Fuel, Lube Material Custom/ Annual
Operation Cost & Repairs Cost Rent Cost
Cultural:
Weed: Winter Strip Spray (Surflan, Goal, Roundup) 12 3 103 0 118
Prune: Hand 278 0 0 0 278
Prune: Chop/Shred Prunings 5 4 0 0 9
Weed: Disc 4X 29 20 0 0 49
Prune: Winter Tie 81 0 12 0 93
Prune: Trunk Sucker 51 0 0 0 51
Disease: Mildew 5X (Sulfur Dust) 25 7 14 0 46
Irrigate: 46 0 80 0 126
Prune: Shoot Removal/Shoot Position 153 0 0 0 153
Fertilize: through drip 2X (5-0-12) 0 0 37 0 37
Prune: Leaf Removal 153 0 0 0 153
Prune: Trim Vines (mechanical) 12 10 0 0 22
Disease: Mildew (Rally), Insect: Lafhopper (Provado) 18 14 52 0 84
Weed: Summer Strip Spray - (Roundup) 12 3 10 0 25
Disease: Mildew (Flint). Insect: Mites (Omite) 18 14 91 0 123
Pickup Truck Use 15 12 0 0 27
ATV Use 15 1 0 0 16
Additional operation 0 0 0 0 0
Additional operation 0 0 0 0 0
TOTAL CULTURAL COSTS 923 88 399 0 1,410
Harvest:
Machine Harvest 0 0 0 275 275
Haul to Winery 0 0 0 98 98
TOTAL HARVEST COSTS 0 0 0 373 373
Assessment:
Crop Assessments 0 0 20 0 20
TOTAL ASSESMENT COSTS 0 0 20 0 20
Interest on operating capital Interest rate= 7.65% 50
TOTAL OPERATING COSTS/ACRE 923 88 419 373 1,853
CASH OVERHEAD:
Office Expense 125
Liability Insurance 4
Sanitation Fees 10
Manager Salary 351
Property Taxes 226
Property Insurance 50
Investment Repairs 278
TOTAL CASH OVERHEAD COSTS 1,044
TOTAL CASH COSTS/ACRE 2,847
NON-CASH OVERHEAD:
Buildings 2,400 sq ft 29
Fuel Tanks: 2-500 Gal 1
Irrigation System (well, pump, 60 acres) 46
Land (200 acres) 902
Tools-Shop/Field 6
Vineyard Establishment 1,068
Equipment 50
TOTAL NON-CASH OVERHEAD COSTS 2,102
TOTAL COSTS/ACRE 4,949
UC COOPERATIVE EXTENSION
MONTHLY CASH COSTS PER ACRE TO PRODUCE WINE GRAPES
SAN JOAQUIN VALLEY - NORTH
Beginning JAN JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL
Ending DEC 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005 2005
Cultural:
Weed: Winter Strip Spray (Surflan, Goal, Roundup) 118 0 0 0 0 0 0 0 0 0 0 0 118
Prune: Hand 0 278 0 0 0 0 0 0 0 0 0 0 278
Prune: Chop/Shred Prunings 0 0 9 0 0 0 0 0 0 0 0 0 9
Weed: Disc 4X 0 0 12 12 0 12 0 0 0 12 0 0 49
Prune: Winter Tie 0 0 93 0 0 0 0 0 0 0 0 0 93
Prune: Trunk Sucker 0 0 0 51 0 0 0 0 0 0 0 0 51
Disease: Mildew 5X (Sulfur Dust) 0 0 0 9 28 9 0 0 0 0 0 0 46
Irrigate: 0 0 0 12 12 24 28 28 12 12 0 0 126
Prune: Shoot Removal/Shoot Position 0 0 0 0 153 0 0 0 0 0 0 0 153
Fertilize: through drip 2X (5-0-12) 0 0 0 0 19 0 0 0 0 19 0 0 37
Prune: Leaf Removal 0 0 0 0 0 153 0 0 0 0 0 0 153
Prune: Trim Vines (mechanical) 0 0 0 0 0 11 0 0 11 0 0 0 22
Disease: Mildew (Rally), Insect: Lafhopper (Provado) 0 0 0 0 0 84 0 0 0 0 0 0 84
Weed: Summer Strip Spray - (Roundup) 0 0 0 0 0 25 0 0 0 0 0 0 25
Disease: Mildew (Flint). Insect: Mites (Omite) 0 0 0 0 0 0 123 0 0 0 0 0 123
Pickup Truck Use 2 2 2 2 2 2 2 2 2 2 2 2 27
ATV Use 1 1 1 1 1 1 1 1 1 1 1 1 16
Additional operation 0 0 0 0 0 0 0 0 0 0 0 0 0
Additional operation 0 0 0 0 0 0 0 0 0 0 0 0 0
TOTAL CULTURAL COSTS 122 282 118 88 214 322 154 31 26 46 4 4 1,410
Harvest:
Machine Harvest 0 0 0 0 0 0 0 0 275 0 0 0 275
Haul to Winery 0 0 0 0 0 0 0 0 98 0 0 0 98
TOTAL HARVEST COSTS 0 0 0 0 0 0 0 0 373 0 0 0 373
Assessment:
Crop Assessments 0 0 0 0 0 0 0 0 20 0 0 0 20
TOTAL ASSESMENT COSTS 0 0 0 0 0 0 0 0 20 0 0 0 20
Interest on Operating Capital 1 3 3 4 5 7 8 8 11 0 0 0 50
TOTAL OPERATING COSTS/ACRE 122 284 121 92 220 329 162 40 430 46 4 4 1,853
OVERHEAD:
Office Expense 10 10 10 10 10 10 10 10 10 10 10 10 125
Liability Insurance 0 0 4 0 0 0 0 0 0 0 0 0 4
Sanitation Fees 1 1 1 1 1 1 1 1 1 1 1 1 10
Manager Salary 29 29 29 29 29 29 29 29 29 29 29 29 351
Property Taxes 0 0 0 113 0 0 0 0 0 0 0 113 226
Property Insurance 25 0 0 0 0 25 0 0 0 0 0 0 50
Investment Repairs 23 23 23 23 23 23 23 23 23 23 23 23 278
TOTAL CASH OVERHEAD COSTS 89 64 68 177 64 89 64 64 64 64 64 177 1,044
TOTAL CASH COSTS/ACRE 211 348 189 268 283 418 226 103 494 109 67 180 2,897
UC COOPERATIVE EXTENSION
RANGING ANALYSIS
SAN JOAQUIN VALLEY - NORTH
COSTS PER ACRE AT VARYING YIELDS TO PRODUCE WINE GRAPES
YIELD (Ton/acre)
5.00 5.50 6.00 6.50 7.00 7.50 8.00
OPERATING COSTS/ACRE:
Cultural Costs 1,410 1,410 1,410 1,410 1,410 1,410 1,410
Harvest Costs:
Machine Harvest 275 275 275 275 275 275 275
Haul to Winery 75 83 90 98 106 113 121
Assessment Cost 14 16 17 19 20 21 23
Interest on operating capital 50 50 50 50 51 51 51
TOTAL OPERATING COSTS/ACRE 1,825 1,834 1,843 1,852 1,861 1,870 1,879
Total Operating Costs/Ton 365 333 307 285 266 249 235
CASH OVERHEAD COSTS/ACRE 1,044 1,044 1,044 1,044 1,044 1,044 1,044
TOTAL CASH COSTS/ACRE 2,869 2,878 2,887 2,896 2,905 2,914 2,923
Total Cash Costs/Ton 574 523 481 446 415 389 365
NON-CASH OVERHEAD COSTS/ACRE 2,102 2,102 2,102 2,102 2,102 2,102 2,102
TOTAL COSTS/ACRE 4,971 4,980 4,989 4,998 5,007 5,016 5,025
Total Costs/Ton 994 905 831 769 715 669 628
NET RETURNS PER ACRE ABOVE OPERATING COSTS
PRICE YIELD (Ton/acre)
$/Ton 5.00 5.50 6.00 6.50 7.00 7.50 8.00
350 -75 91 257 423 589 755 921
400 175 366 557 748 939 1,130 1,321
450 425 641 857 1,073 1,289 1,505 1,721
500 675 916 1,157 1,398 1,639 1,880 2,121
550 925 1,191 1,457 1,723 1,989 2,255 2,521
600 1,175 1,466 1,757 2,048 2,339 2,630 2,921
650 1,425 1,741 2,057 2,373 2,689 3,005 3,321
NET RETURNS PER ACRE ABOVE CASH COSTS
PRICE YIELD (Ton/acre)
$/Ton 5.00 5.50 6.00 6.50 7.00 7.50 8.00
350 -1,119 -953 -787 -621 -455 -289 -123
400 -869 -678 -487 -296 -105 86 277
450 -619 -403 -187 29 245 461 677
500 -369 -128 113 354 595 836 1,077
550 -119 147 413 679 945 1,211 1,477
600 131 422 713 1,004 1,295 1,586 1,877
650 381 697 1,013 1,329 1,645 1,961 2,277
NET RETURNS PER ACRE ABOVE TOTAL COSTS
PRICE YIELD (Ton/acre)
$/Ton 5.00 5.50 6.00 6.50 7.00 7.50 8.00
350 -3,221 -3,055 -2,889 -2,723 -2,557 -2,391 -2,225
400 -2,971 -2,780 -2,589 -2,398 -2,207 -2,016 -1,825
450 -2,721 -2,505 -2,289 -2,073 -1,857 -1,641 -1,425
500 -2,471 -2,230 -1,989 -1,748 -1,507 -1,266 -1,025
550 -2,221 -1,955 -1,689 -1,423 -1,157 -891 -625
600 -1,971 -1,680 -1,389 -1,098 -807 -516 -225
650 -1,721 -1,405 -1,089 -773 -457 -141 175
Related docs
Other docs by wbb39366
Blank Poster Presentation Template Symposium on Recent and Emerging Advances in Chemical
Views: 150 | Downloads: 0
