Filetype Excel XLSX | Posted on 07 Jul 2022 | 3 years ago
Authentication
digital resources
245x Filetype XLSX File size 0.02 MB Source: novascotia.ca
Sheet 1: Introduction
| Cost of Production Tool - Wine Grapes | ||||||||||||
| This cost of production tool is designed to assist producers with calculating their annual cost of production for a new vineyard. | ||||||||||||
| The tool is divided into two sections: | ||||||||||||
| 1. Capital Costs - this section guides the user through the ownership cost calculations. Ownership costs are annualized using the capital recovery method. | ||||||||||||
| 3. Budget - this section guides the user through the cost of production calculations for a typical production year. | ||||||||||||
| The user can enter his/her values in the white shaded cells with blue font. The default values found in this tool are for illustrative purposes only. | ||||||||||||
| Although efforts have been made to ensure that this tool is free from errors, the user of this tool assumes full responsibility for any errors or omissions. | ||||||||||||
| For questions, assistance, or feedback with this tool, please contact: | ||||||||||||
| David Thibodeau | ||||||||||||
| Nova Scotia Department of Agriculture | ||||||||||||
| Economist | ||||||||||||
| 902-896-4882 | ||||||||||||
| david.thibodeau@novascotia.ca | ||||||||||||
| This section is used to estimate the ownership costs over the production years. | ||||||
| Step 1. Farm Size (acres): | 10.00 | |||||
| Step 2. Required Rate of Return on Investment (%): | 5.00% | (It is recommended that you use at least 5%) | ||||
| Step 3. Please list the capital items used for production , such as vineyard land, machinery, equipment, and other durable items. Estimates on market value, useful lifespan and salvage value are used to calculate the annual capital recovery costs. If you are uncertain about the lifespan of the capital, enter the number of productions years over which you would like to recover the capital investment. | ||||||
| Capital Item | Market Value | Cost / Acre | Remaining Lifespan Over Production Years (Years) | Salvage Value | Capital Recovery Factor | Capital Recovery Charge |
| Tractor | $15,000.00 | $1,500.00 | 11.00 | $0.00 | 0.1204 | $1,805.83 |
| Airblast Sprayer | $10,000.00 | $1,000.00 | 30.00 | $0.00 | 0.0651 | $650.51 |
| Herbicide Sprayer | $3,000.00 | $300.00 | 30.00 | $0.00 | 0.0651 | $195.15 |
| Backpack Sprayer | $200.00 | $20.00 | 30.00 | $0.00 | 0.0651 | $13.01 |
| Rotary Mower | $4,500.00 | $450.00 | 30.00 | $0.00 | 0.0651 | $292.73 |
| Fertilizer Spreader | $2,000.00 | $200.00 | 30.00 | $0.00 | 0.0651 | $130.10 |
| Hand Equipment | $500.00 | $50.00 | 30.00 | $0.00 | 0.0651 | $32.53 |
| Trailer | $2,500.00 | $250.00 | 30.00 | $0.00 | 0.0651 | $162.63 |
| Hedger | $10,000.00 | $1,000.00 | 30.00 | $0.00 | 0.0651 | $650.51 |
| Harvesting Equipment | $500.00 | $50.00 | 30.00 | $0.00 | 0.0651 | $32.53 |
| Pest Control (bird netting/waler/etc.) | $5,000.00 | $500.00 | 30.00 | $0.00 | 0.0651 | $325.26 |
| Buildings | $31,360.00 | $3,136.00 | 30.00 | $0.00 | 0.0651 | $2,040.01 |
| Established Vineyard Land (including vines, trellis, drainage tile) | $321,495.71 | $32,149.57 | 30.00 | $50,000.00 | 0.0651 | $20,161.19 |
| Other Capital Items: | ||||||
no reviews yet
Please Login to review.
