Filetype Excel XLSX | Posted on 14 Aug 2022 | 3 years ago
Authentication
digital resources
249x Filetype XLSX File size 0.12 MB Source: rvpadmin.cce.cornell.edu
Sheet 1: Farm Info
| Cornell Cooperative Extension Fruit Farm Business Summary | 2014 | |||||
| Grower Template with Worksheets for Analyzing Your Farm Business INSTRUCTIONS | ||||||
| Farm ID | Enter your farm data in the colored cells | |||||
| Year > | 2014 | Recommended procedure: | ||||
| 1. Enter information in order of sheets (tabs) | ||||||
| Date of Analysis | 02-Jan-15 | in the workbook (Some sheets extend to line 127) | ||||
| 2. Review data sheets for errors | ||||||
| Farm Name: | No. | 3. Tabs beginning with R- are Reports | ||||
| Farm No, | > > > > > > > > > > > > > > > | C000ex | 4. The Orange tabs at the end of this workbook are | |||
| Legal Entity > | individual proprietership | for the transfer of farm data into the Cornell database. | ||||
| Contact person: | Frt Acres: | 5. Before printing out reports make sure that | ||||
| Street | 0.00 | Cash Flow balances. | ||||
| Town | 6. If you have any questions about this template please | |||||
| State | contact: Alison DeMarree at: amd15@cornell.edu | |||||
| Zip Code | or your regional extension specialist. | |||||
| Type of Year | calendar | (fiscal or calendar) | ||||
| Acctg Method | cash | (cash or accrual) | N O T E S: | |||
| Year Begins: | January 1, 2014 | < mm/dd/yy | To be included in the Cornell Fruit Farm Business | |||
| Telephone | Summary a farm must meet the following criteria: | |||||
| 1. Cash flow must balance within 1.0% | ||||||
| Yr. Begins | 2. Fruit should be a major source of income (65% | |||||
| Other Entities: | Jan. 1 | or more of total income) OR IF the grower can separate | ||||
| Jan. 1 | fruit from other enterprises (inc, exp., value of equip., etc.) | |||||
| Jan. 1 | the farm may be divided into two entities; whole farm | |||||
| and then fruit farm. Run the whole farm first to balance | ||||||
| email: | cash flow balances, then run a separate fruit farm analysis. | |||||
| ENUMERATORS NOTES: | ||||||
| fax number | Yet to do: | |||||
| CELL PHONE NUMBER: | ||||||
| version: amd080507 | Comparisons Desired | Y or N | ||||
| 1 | Fresh Pome Fruits | |||||
| 2 | Process Pome Fruits | |||||
| 3 | Tart Cherries | |||||
| 4 | Sweet Cherries | |||||
| 5 | Process Peaches | |||||
| 6 | Fresh Peaches/Nectarines | |||||
| 7 | Berries in General | |||||
| 8 | Strawberries | |||||
| 9 | Blueberries | |||||
| 10 | Brambles | |||||
| 11 | Cranberries | |||||
| 12 | Direct Marketed | |||||
| 13 | Wholesale Marketed | |||||
| 14 | Farms with Storages | |||||
| 15 | Farms with Packing lines | |||||
| 16 | Agri-tourism | |||||
| Bearing Acreage | Beginning | Removed | Added | Ending | % | Non-Bearing Acreage | Beginning | Removed | Added | Ending | W O R K S H E E T | |||
| Fresh Apples | 0.00 | Fresh Apples | 0.00 | Fruit | acres | ubnits | ||||||||
| Peeler Apples | 0.00 | Peeler Apples | 0.00 | 1 | ||||||||||
| Cider / Juice Apples | 0.00 | Cider / Juice Apples | 0.00 | 2 | ||||||||||
| Total Apples | 0.00 | 0.00 | 0.00 | 0.00 | #DIV/0! | Total Apples | 0.00 | 0.00 | 0.00 | 0.00 | 3 | |||
| Tart Cherries | 0.00 | #DIV/0! | Tart Cherries | 0.00 | 4 | |||||||||
| Sweet Cherries: fresh | 0.00 | #DIV/0! | Sweet Cherries: fresh | 0.00 | 5 | |||||||||
| Sweet Cherries: process | 0.00 | #DIV/0! | Sweet Cherries: process | 0.00 | 0.0 | 0.0 | ||||||||
| Pears: fresh | 0.00 | #DIV/0! | Pears: fresh | 0.00 | 0.0 | |||||||||
| Pears: process | 0.00 | #DIV/0! | Pears: process | 0.00 | ||||||||||
| Fresh Peaches | 0.00 | #DIV/0! | Fresh Peaches | 0.00 | ||||||||||
| Process Peaches | 0.00 | #DIV/0! | Process Peaches | 0.00 | ||||||||||
| Plums / Prunes: Fresh | 0.00 | #DIV/0! | Plums / Prunes: Fresh | 0.00 | ||||||||||
| Process Prunes | 0.00 | #DIV/0! | Process Prunes | 0.00 | ||||||||||
| Apricots | 0.00 | #DIV/0! | Apricots | 0.00 | ||||||||||
| Other tree fruit/nuts | 0.00 | #DIV/0! | Other tree fruit/nuts | 0.00 | ||||||||||
| Grapes: juice | 0.00 | #DIV/0! | Grapes: juice | 0.00 | ||||||||||
| Grapes: wine | 0.00 | #DIV/0! | Grapes: wine | 0.00 | ||||||||||
| Grapes: table | 0.00 | #DIV/0! | Grapes: table | 0.00 | ||||||||||
| Strawberries: fresh | 0.00 | #DIV/0! | Strawberries: fresh | 0.00 | ||||||||||
| Strawberries: process | 0.00 | #DIV/0! | Strawberries: process | 0.00 | ||||||||||
| Cranberries | 0.00 | #DIV/0! | Cranberries | 0.00 | ||||||||||
| Blueberries: fresh | 0.00 | #DIV/0! | Blueberries: fresh | 0.00 | ||||||||||
| Blueberries: process | 0.00 | #DIV/0! | Blueberries: process | 0.00 | ||||||||||
| Brambles: fresh | 0.00 | #DIV/0! | Brambles: fresh | 0.00 | ||||||||||
| Brambles: process | 0.00 | #DIV/0! | Brambles: process | 0.00 | ||||||||||
| Ribes: fresh | 0.00 | #DIV/0! | Ribes: fresh | 0.00 | ||||||||||
| Ribes: process | 0.00 | #DIV/0! | Ribes: process | 0.00 | ||||||||||
| Other berries: fresh | 0.00 | #DIV/0! | Other berries: fresh | 0.00 | ||||||||||
| Other berries: process | 0.00 | #DIV/0! | Other berries: process | 0.00 | ||||||||||
| Other Crops: Pumpkins | 0.00 | Other perennial crops: | 0.00 | |||||||||||
| Corn | 0.00 | tree nursery | 0.00 | |||||||||||
| Soybeans | 0.00 | 0.00 | ||||||||||||
| Onions | 0.00 | Open Land: | 0.00 | |||||||||||
| Cabbage | 0.00 | 0.00 | ||||||||||||
| Snap Beans | 0.00 | 0.00 | ||||||||||||
| Oats,Buckwheat,Rye | 0.00 | 0.00 | ||||||||||||
| Peas | 0.00 | 0.00 | ||||||||||||
| Clover hay + seed | 0.00 | Total Planted | 0.00 | 0.00 | 0.00 | 0.00 | ||||||||
| Total Other Crops | 0.00 | 0.00 | 0.00 | 0.00 | Tillable Open Land | >>>>>>>>>> | 0.00 | |||||||
| Total Cropped | 0.00 | 0.00 | 0.00 | 0.00 | Woodland | 0.00 | ||||||||
| Rented acres | Nontillable land | 0.00 | ||||||||||||
| included above: | Total bearing fruit acres: | 0.00 | ||||||||||||
| Total owned acres: | Non-bearing fruit acres | 0.00 | ||||||||||||
| Other Crop Acres: | 0.00 | Total fruit acres: | 0.00 | |||||||||||
| Available tillable acres: | 0.00 | < Check. | Total of other crop acres: | 0.00 | ||||||||||
| All taxable acres: | 0.00 | Total acres cropped: | 0.00 | |||||||||||
| Growers Own Fruit | This Years | Stored Apples | Net | lbs of fruit | ||||||||||
| Production | production | beginning | ending | Sales | Production per bearing acre | produced | ||||||||
| Fresh Apples: bu. | 0 | Fresh Apples | #DIV/0! | bu./acre | 0 | |||||||||
| Peeler Apples: bu | 0 | Peeler Apples | #DIV/0! | bu./acre | 0 | |||||||||
| Cider/Juice Apples: bu | 0 | Cider / Juice Apples | #DIV/0! | bu./acre | 0 | |||||||||
| Total Apples | 0 | 0 | 0 | 0 | Total Apples | #DIV/0! | bu./acre | 0 | 0 | |||||
| Tart Cherries: lbs. | Tart Cherries | #DIV/0! | tons/A. | 0 | ||||||||||
| Sw Cherries: fresh lbs. | Sw Cherries: fresh lbs. | #DIV/0! | tons/acre | 0 | ||||||||||
| Swt Cherries: Proc. lbs. | Swt Cherries: Proc. lbs. | #DIV/0! | tons/acre | 0 | ||||||||||
| Pears: fresh bushel | 0 | 0 | 0 | Pears: fresh | #DIV/0! | bu/acre | 0 | 60 lbs/bu | ||||||
| Pears: lbs. | Pears: process | #DIV/0! | bu./acre | 0 | ||||||||||
| Fresh Peaches: bu. | Fresh Peaches | #DIV/0! | bu. / acre | 0 | 48lbs/bu. | |||||||||
| Process Peaches: lbs. | Process Peaches | #DIV/0! | tons/acre | 0 | 55 lbs | |||||||||
| Frsh Plums/Prunes: bu. | Plums / Prunes: Fresh | #DIV/0! | bu./acre | 0 | 56 lb. Bu. | |||||||||
| Process Prunes: lbs. | Process Prunes | #DIV/0! | tons/acre | 0 | ||||||||||
| Apricots: lbs. | Apricots | #DIV/0! | bu./acre | 0 | 50 lb bu. | |||||||||
| Other tree fruits/nuts lbs | 0 | 0 | 0 | Other tree fruits/nuts lbs | #DIV/0! | lbs/acre | 0 | 16 - 18 | dollars/bu. | |||||
| Grapes: juice tons | Grapes: juice tons | #DIV/0! | tons/acre | 0 | ||||||||||
| Grapes: wine tons | Grapes: wine tons | #DIV/0! | tons/acre | 0 | ||||||||||
| Grapes: fresh tons | Grapes: fresh tons | #DIV/0! | tons/acre | 0 | ||||||||||
| Strawberries: qts | Strawberries: fresh | #DIV/0! | qts./acre | 0 | 1.5 lbs/qt. | |||||||||
| Strawberries: lbs | Strawberries: lbs | #DIV/0! | lbs. / acre | 0 | ||||||||||
| Cranberries: tons | Cranberries: tons | #DIV/0! | tons/acre | 0 | ||||||||||
| Blueberries: pts. | Blueberries: fresh | #DIV/0! | pints/acre | 0 | lbs/pt? | |||||||||
| Blueberries: lbs. | Blueberries: lbs. | #DIV/0! | lbs. / acre | 0 | ||||||||||
| Brambles: pts. | Brambles: fresh | #DIV/0! | pints/acre | 0 | 0.5 lbs/pt? | |||||||||
| Brambles: lbs. | Brambles: lbs. | #DIV/0! | lbs. / acre | 0 | ||||||||||
| Ribes: pints | Ribes: fresh | #DIV/0! | lbs./acre | 0 | 0.5 lbs/pt? | |||||||||
| Ribes: lbs. | Ribes: lbs. | #DIV/0! | lbs. / acre | 0 | ||||||||||
| Other berries: fresh lbs. | Other berries: fresh | #DIV/0! | lbs. / acre | 0 | ||||||||||
| Other berries: proc. lbs | Other berries: process | #DIV/0! | lbs. / acre | 0 | ||||||||||
| Other Crops: Pumpkins | Other Crops: Pumpkins | #DIV/0! | tons / acre | 0 | ||||||||||
| Corn | 0 | Corn | #DIV/0! | bu. / acre | 0 | |||||||||
| Soybeans | 0 | Soybeans | #DIV/0! | bu. / acre | 0 | |||||||||
| Onions | 0 | Onions | #DIV/0! | bu. / acre | 0 | |||||||||
| Cabbage | 0 | Cabbage | #DIV/0! | tons / acre | 0 | |||||||||
| Snap Beans | Snap beans | #DIV/0! | tons / acre | 0 | ||||||||||
| Oats,Buckwheat,Rye | 0 | Oats,Buckwheat,Rye | #DIV/0! | bu. / acre | 0 | |||||||||
| Peas | 0 | Peas | #DIV/0! | tons / acre | 0 | |||||||||
| Clover hay + seed | 0 | Clover hay + seed | #DIV/0! | tons / acre | 0 | 0 | < Pome lbs | |||||||
| 0 | < Stone lbs | |||||||||||||
| total lbs. | 0 | < Berry lbs | ||||||||||||
| produced > | 0 | 0 | < check | |||||||||||
| L A B O R W O R K S H E E T | 2014 | year | ||||||||||||||
| Note: Annual information may be entered on any line, monthly breakdown NOT required. | ||||||||||||||||
| A. Hired Labor > | PR | Fulltime | Parttime | |||||||||||||
| Month | wk | Total | Yr. Round | hrs. | Yr. Round | hrs. | Seasonal | hrs. | Harvest | hrs. | check | Notes | ||||
| January | 4 | 0 | Please break down labor into a minimum of | |||||||||||||
| February | 4 | 0 | TWO categories: Year Round & Harvest | |||||||||||||
| March | 5 | 0 | Operator's labor should NOT be included in | |||||||||||||
| April | 4 | 0 | Section A. - Please break out into section B. | |||||||||||||
| May | 4 | 0 | ||||||||||||||
| June | 5 | 0 | ||||||||||||||
| July | 4 | 0 | ||||||||||||||
| August | 5 | 0 | ||||||||||||||
| September | 4 | 0 | H-2A harvest labor | |||||||||||||
| October | 4 | 0 | Winter Trim | |||||||||||||
| November | 5 | 0 | #DIV/0! | 0.00 | ||||||||||||
| December | 4 | 0 | ||||||||||||||
| Total Gross Labor | 52 | $0 | $0 | 0 | $0 | 0 | $0 | 0 | $0 | 0 | 0 | |||||
| Hired Labor + Opr Labor > | $0 | Chk> | #DIV/0! | Chk> | #DIV/0! | Chk> | #DIV/0! | Chk> | #DIV/0! | < Total Labor hired hours reported | 0.00 | |||||
| Total hired labor hrs calc: | 0.0 | 0.0 | < difference | |||||||||||||
| Fiscal Year Labor Total> | Worker's Comp Ins > | #DIV/0! | < rate | |||||||||||||
| Total Domestic Labor $ reported on 943 form > | State Unemployment | $0 | T & I | |||||||||||||
| Total H-2A Labor > > > > > > > > | Federal Unemployment | |||||||||||||||
| Notes | Total Labor > | $0 | Actual Soc. Sec. | $0 | < check | Soc Sec on Total Gross Labor | ||||||||||
| $0 | Soc Sec on Total Domestic Labor | |||||||||||||||
| B. Operators' | Amount | Value of | mos. | yrs. of | C. Custom Labor / Contractor | Amount | weeks | hrs/week | hrs/man | |||||||
| Draw / Salary & Benefits | age | Drawn | Opr. L & M | worked | education | Seasonal work: avg rate / hr > | $12.00 | Typical hours per week for fruit farm | 50.00 | 45.00 | 2,250.00 | |||||
| Draw #1 Operator | 12.00 | Contract dormant pruning > | No. of Operators based on hours | #DIV/0! | ||||||||||||
| Draw #2 Operator | Contractor and/or Crew Ldr> | |||||||||||||||
| Draw #3 Operator | Other custom seasonal work > | |||||||||||||||
| Draw #4 Operator | Harvest Work: avg rate / hr> | $12.00 | ||||||||||||||
| Soc. Sec. | Crew Leader &/or Contractor > | |||||||||||||||
| Taxes | Quality Control > | |||||||||||||||
| Health & Life insurance | Custom harvest hired > | |||||||||||||||
| Profit Sharing | Totals | $0 | ||||||||||||||
| Retirement | ||||||||||||||||
| Other | Unpaid Family Labor | # of mos. | ||||||||||||||
| Other | recordkeeping by spouse? | |||||||||||||||
| Non-farm debt repayment | ||||||||||||||||
| Totals | 0 | 0 | 12.00 | 0.0 | ||||||||||||
| Totals | 0.00 | |||||||||||||||
| Ck all > | 0 | Total hired man equivalents > | 0.00 | |||||||||||||
no reviews yet
Please Login to review.
