Blank Salary Slip Format - Excel

Document Sample
Blank Salary Slip Format - Excel Powered By Docstoc
					                                      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

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:2550
posted:1/7/2011
language:English
pages:9
Description: Blank Salary Slip Format document sample