Home

Insert Report Title Here

Contents

1. Gross Margin Comparison Tool for Vegetables Manual 2011 Page 24 To PRINT your comparison select the Print button Printer Adobe F Change Printer Which Printer If your computer links to more than one gt chart printer VegTool will presume to use your default printer If you wish to change printers VegTool will detect your penew print E New Report Save Report X Close printers and ask you to select one fl x aril VegTool Manage your scenarios create edit copy or delete Ws Primary NSW industries GROSS MARGIN COMPARISON Z700 SOG VECE TAGES Manage Scenarios Compare Scenario Name of Scenario amp Crop Details Scenario Season Broccili High Tech Fert Program Winter Choo to five 5 sce Broccoli Traditional Fert Program Winter Field Lettuce High Fertiliser Summer Field Lettuce Low Fertiliser Summer IPM Lettuce Summerfi JARRADELE Spring E Tutorial 7 Conversion Calculator User Manual income Cost amp Gross Margin per Area Unit Check this box to total the Microsoft XPS Document Non IPM Lettuce Summerf i HP PSC 1500 series Onions High Tech Fert Program Winter Select Scenarios EPSON Stylus CX5500 Remove All Onions Traditional Fertiliser Program Winter Name of Scenario Adobe PDF Pumpkin Butternut Spring 1 Broccili High Tech Fe 5 4 Remove Pumpkin Butternut Spring s li Ti Fe Pumpkin Jarradale S
2. cccccsseeesessseeseenseescenseeeceasseesoesseeseoseeseossessoeneeeses 26 VegTool Gross Margin Comparison Tool for Vegetables User Manual 2011 Page ii 1 INTRODUCTION INCLUDING A QUICK GUIDE TO USING VEGTOOL VegTool is a simple tool for calculating and comparing Gross Margins A gross margin is the difference between what your crop sells for gross income and the operating costs Profit on the other hand depends on the dollar difference between gross income and all costs i e operating costs and overhead costs VegTool allows you to prepare and compare Gross Margins for your different crop options or different production situations for example varying the season might affect your yields and or prices exporting might cost more in transport but earn better prices The vegetable industry s nformation and Technology Advisory Group identified that growers needed a tool of this type because it can be very difficult to anticipate gross margins when selecting crops 1 1 VegTool can help your vegetable business Subtle changes in income or costs can have serious impacts on profit This makes predicting and comparing potential profitability of different crops difficult VegTool can help your business by allowing you to e Compare several production scenarios to see which ones are likely to generate sufficient gross margin returns to result in a profit e Decide which crops are likely to generate the most
3. Electricity Gas Packaging Freight Transport Other Operating costs Total Operating Costs Gross Margin per Harvest Unit 0 00 per Area Unit Gross Margin 0 00 Weeks from planting to final harvest TBA Continue gt Crop Back Required Please select a crop from the dropdown list If your crop isn t in the list click Add a Crog Vegetables Manual 2011 Page 5 To complete a Scenario enter operating costs for each of the ten cost categories Links take you to calculators that use different methods to determine your costs fl Tutorial 7 Conversion Calculator ser Manual ENTER OPERATING COSTS FINANCIAL SUMMARY ype o derive crop costs Crop and Scenario Description Details appear in the financial Type in estimated costs for Read some guidlines 5 summary based the Area Unit you selected OR or use a simple cost FA on the crop gt calcul nea i eine Carton of 14 kg information you 4 Area Unit Hectare Anticipated Yie c and Weighted Avcrage Price entered 1 200 00 Cartons of 14 kg per Area Unit 1 200 00 Cartons of 14 kg per Hectare 16 80 Tonnes per Hectare Weighted Average Price 12 00 per Carton of 14 kg Gross Income er Carton per Area Unit per Hectare Seed amp Plants Fertiliser Fuel Gross Income 12 00 14 400 00 14 400 00 Operating Costs per Carton per Area Unit per Hectare Chemicals mers Operating cost Fertiliser information will
4. Name of Scenario Pumpkin Butternut i per hectare Harvest Unit Carton of 14 kg area unit e g per L Area Unit Hectare i Anticipated Yield and Weighted Average Price bed in this case 1 200 00 Cartons of 14 kg per Area Unit Seed amp Plan s 10 ane SONS OF 14 Kg per Area Un you Can use a ae 1 200 00 Cartons of 14 kg per Hectare 16 80 Tonnes per Hectare Fertilis 462 00 simple calculator race Weighted Average Price 12 00 per Carton of 14 kg Gross Income per Carton per Area Unit per hectare Gross Income 12 00 14 400 00 14 400 00 Operating Costs per Carton per Area Unit Seed amp Plants 210 00 Fertiliser 462 00 Fuel 270 00 Chemicals 130 70 Water 360 00 Labour 3 334 00 3 384 00 Electricity Gas etc 150 00 150 00 Packaging 2 076 00 2 076 00 Freight Transport 1 260 00 1 260 00 Other Operating costs 1 235 00 1 235 00 Total Operating Costs 9 537 70 9 537 70 Gross Margin per Carton per Area Unit per Hectare Gross Margin 4 05 4 862 30 4 862 30 Gross Margin per ML Water 810 38 Weeks from planting to final harvest 18 Seed amp Plants Costs Done a Back Optional Please enter a number or click the button to the right to open the Seed amp Plants Cost Calculator pian Fuel 32rr00 Chemicals Clicking on the eez little blue arrow a will take you to a a cost calculator Packaging Freight Transport imeem 1 235 00 v gt E gt gt gt gt As data is entered
5. 12 880 00 11 043 68 1 836 32 Gross Margin Comparison Tool for Vegetables Manual 2011 Page 13 The image disappears below the task bar on the bottom of the screen ments Profit amp Loss to estimate your fuel costs Total Costs zost in If you have a small computer screen you may need to use a vertical scroll bar on the right hand side of the program to move up and down the screen in the program Click and drag the scroll bar up and down and to reveal the top or bottom of the screen get a warning when I click on the tutorial button _ Microsoft Office x d Opening C Users susan Documents WORK VegToolProduction VegTool Tutorial wmv You ey eee this Want pop up when you try to Open ME of Some files can contain viruses or otherwise be harmful to your the Tutorial Videos computer It is important to be certain that this file is from a trustworthy source Cl ick O K Would you like to open this file Gross Margin Comparison Tool for Vegetables Manual 2011 Page 14 3 DETAILED GUIDE TO USING VEGTOOL 3 1 The welcome screen looks like this Gross Margin Comparison Tool for Vegetables Q A Prima SUGI DINSOT ticulture Austra NSW ry HORTICULTURAL SERVICES tocee Industries Gross Margin Comparison Tool for Vegetables A tool for assessing the potential profitability of vegetable production IT IS THIS EASY Create Scenarios Enter crop details Type in your crop details inclu
6. Fuel j Chemicals appear in the Water yeot costs summary Electricity Gas etc f aa as you enter Freight Transport cost details Other Operating costs Total Operating Costs Gross Margin Gross Margin 0 00 Gross Margin per ML Water 0 00 Weeks from planting to final harvest 18 Water Labour Electricity Gas Packaging Freight Transport BOEORAee aa Other Operating Costs B Seed amp Plants Costs Back Optional Please enter a number or click the button tthe right to open the Seed amp Plants Cost Calculator WARNING Some operating cost fields do not hav amp a value Interpret results with caution Type the costs into the white boxes if you know them or click on these links to go to a simple calculator These make it easy to calculate or estimate the costs Select up to five Scenarios at a time to view and print for comparison Comparison Report 13 Sep 2011 Field Lettuce LowFertiliser Onions High Tech Fert Program Onions Traditional Fertiliser Pro Pumpkin Butternut 3 M pe Ha 4 5 ML pe Ha 1 Hectere 1 Hectere 1 Hectere 1 Hectere 1 Hecteare Carton of 14kg Carton of 14kg Bag of 20 kg Bag of 20 kg Carton of 14g 3 125 00 Cartons 2 500 00 Cartons 2 250 00 Bags 2 000 00 Bags 1 200 00 Cartons 3 125 00 Cartons Hectare 2 500 00 Cartons Hectere 2 250 00 Bags Hectere 2 000 00 Bags Hecdare 1 200 00 Cartons Hectere 43 75 Tonnes Hedare 35 00 Tonnes Hectare 45 00 Tonnes Hectere 40 00 Tonnes
7. 7 Conversion Calculator User Manual income Cost amp Gross Margin per Area Unit Crop Harvest Unit Area Unit Income Cost Gross Margin Broccoli Carton Hectare 12 830 00 11 043 68 1 836 32 Broccoli Carton Hectare 11 200 00 10 537 46 662 54 Field Lettuce Carton Hectare 37 500 00 8 077 16 29 422 34 Lettuce Carton Hectare 30 000 00 5 583 26 24 416 74 Field Lettuce Carton Hectare 26 950 00 7 452 99 19 497 01 Field Lettuce Carton Hectare 23 512 50 6 534 03 16 978 47 Onions Bag Hectare 27 000 00 18 525 10 8 474 90 Onions Bag Hectare 24 000 00 16 522 17 7 477 83 Pumpkin Bin Hectare 9 800 00 7 759 70 2 040 30 Pumpkin Bin Patch 98 000 00 77 597 00 20 403 00 Pumpkin Bin Patch 196 000 00 155 194 00 40 806 00 Pumpkin Bin Hectare 9 800 00 7 689 70 2 110 30 Pumpkin Bin Hectare 9 800 00 7 759 70 2 040 30 Pumpkin Bin Hectare 9 800 00 7 829 70 1 970 30 L Print Financial Summary O L Compare Scenarios gt Delete Scenario X Exit Application Version 1 1 On the Manage Scenarios screen select scenario and then click Compare Scenarios The next screen has several options including select preview print amp save comparisons Name your comparison of up to five scenarios Field Lettuce Low Fe Lettuce IPM Lettuce d Onions High Tech Fe Onions Onions Traditional Fe Onions Pumpkin Butternut Pumpkin Pumpkin Butternut P
8. Ph l Name of Scenario amp Crop Details scenarios but eep t e t INS added l e z Season Crop Harvest Unit Area Unit Income 0 Gross Margin Broccili High Tech Fert Program Winter Broccoli Carton Hectare 12 880 00 11 043 68 1 836 32 i li Traditional Fert Pr Wint Bi li Carto Hecti 11 200 00 10 537 46 662 54 capes aaa aie ala aaa aa 37 500 00 8 077 16 29 i F j Field Lettuce Low Fertiliser Summer Lettuce Carton Hectare 30 000 00 5 583 26 24 416 74 A In this version of VegTool you only get the option Se ias Carica 525 950 00 3745200 3104070 A Non IPM Lettuce Summer Autumn Field Lett Carton Hectare 23 512 50 6 534 03 16 978 47 Onions High Tech Fert Pri Wint ie B Hecti 27 000 00 18 525 10 8 474 90 to delete the crops seasons and harvest units Stella lee eee e ve added aft lick the Delete All SS ee you ve agded aller you click Ine Velete saniar a lee ieee eee ioe x 7 Pumpkin Jarradale 20 S Pumpki B Patch 196 000 00 155 194 00 40 806 00 Scenarios button and say Yes when asked to Water SSOML Pumpkin Jrradele Spring Pumpin Bn Heciare S880000 S768870 5211030 Water 60 ML Pumpkin Jarradale Spring Pumpkin Bin Hectare 9 800 00 7 759 70 2 040 30 s 5 Water 70 ML Pumpkin Jarradale Spring Pumpkin Bin Hectare 9 800 00 7 829 70 1 970 30 confirm that you wish to delete them Then you are given the option of whether or not you want to delete the crops seasons and harvest units you ve added sim
9. 2 3 Completing Installation with Setup Wizard 0 0 0 cece cccceccceeseeeeeeeeeeeeeeeeeeeeeeseeeeeesceeeesssaeaeeeeeeesssaaaneeeeees 10 2 4 The first time you OPEN VEQTOOL ccccseccccceseecceescecceueeeccesececeseeeeeueeecsaueeeceuseeeseecesseueeessageeesseeeessaneeeens 11 2 5 Adjusting screen Settings for your COMPUTEL ccccseccccccceeseceeeceeeeeeecseeeceeeseeeseeesseaueeeeesaeeeeeeesaaeeeeesaaaees 13 3 Detailed guide to sing VSO UV OON ieee scccc ccc cec aena aa aa E aaa a a SA 15 3 1 The welcome screen looks like this ccccssececceeececceeecceeeecseseccsaeeeseseeesaueeecsaueeessueeessaueeesseeeessaeeeeess 15 3 2 Create a new crop scenario and manage your existing Scenarios cccceecccceeececceeeeeceeeeeeceeeeseueeeesaees 15 339 Enter Crop DetallS eoram E ee ee te eS eee eer eee ee 16 34 Enter Operating COSIS a icscncssceeices deep oxndcesnddecdsecadenwicedeapsanddalcdeadicctacepdeeeiscudsecmnenaleianeadieed cocadeawiceddecmeenccene s 19 3 5 Using the calculators to determine your COSTS ccseecccecceeeeceeceeeeeeeeceeeeeceeecaeeeeeeeseuseeeeessaeeeeeessaeeeeeesaaees 20 3 6 Print Financial Summary and Compare Scenarios cccccccccecceeeeeeceeeeeeeeeeeeeeeeeeseeeeeeeeeeesseeeeeeeeeeeeseaas 22 3 7 Keep VegTool organised ccccccsssccccsseecceeeecsseecceseeccegeeeceaeeeeceeeesseuececsaseeeseeeessaueeessaseeeseeseessaeeesssass 25 4 How dol Your questions amp the ANSWEYPS
10. Choose up to five 5 scenarios to compare Your comparit on report can be saved for later use Click this box near the top middle section of the Compare Scenarios screen Q I grow four crops one after the other in my glasshouse I Enter a title for this comparison report Comparison Report 14 Sep 2011 want to see a total gross margin for the year for my Check this box to total the margins for all scenarios w glasshouse by adding all four Select Scenarios irom Posh ose Mai crops together Fran Name of Scenario Crop 3 n Income Cost 1 A A VegTool can calculate a total zl gross margin for up to five 2 scenarios You will have to 4 select an Area Unit that allows 5 you to put in the total area being used for each crop e g Selected Printer EPSON Stylus CX5500 Series Change Printer glasshouse patch or other Note If you are comparing scenarios on a per Area Unit or per Hectare basis a total is meaningless How do delete the new harvest unit or new season name or new crops that added to VegTool Q I added Warrigal Greens to the crop list but misspelt it and want to replace it with the correct spelling Doug Enter Crop Details E Tutorial T Conversion Calculator User Mar ENTER CROP DETAILS __ FINANCIAL SUMMARY from the dropdown ists Crop Warriggal Greeens Add a Crop Season Crop Wa
11. Non IPM Lettuce Summer Autumn Field Lettuce Carton Hectare 23 512 50 6 534 03 16 978 47 Onions High Tech Fert Program Winter Onions Bag Hectare 27 000 00 18 525 10 8 474 90 Bag Hectare 7 477 83 Onions Traditional Fertiliser Program Winter Onions 24 000 00 16 522 17 arton ectare 14 4 13 789 30 i Pumpkin Jarradale Spring Pumpkin Bin Hectare 9 300 00 7 759 70 2 040 30 9 Cl ick h ere to create a Pumpkin Jarradale 10 Spring Pumpkin Bin Patch 98 000 00 77 597 00 20 403 00 Pumpkin Jarradale 20 Spring Pumpkin Bin Patch 196 000 00 155 194 00 40 806 00 n ew cro p sce n a rl O Water 50 ML Pumpkin Jarradale Spring Pumpkin Bin Hectare 9 300 00 7 689 70 2 110 30 Water 60 ML Pumpkin Jarradale Spring Pumpkin Bin Hectare 9 300 00 7 759 70 2 040 30 Water 70 ML Pumpkin Jarradale Spring Pumpkin Bin Hectare 9 300 00 7 829 70 1 970 30 FY Create a New Scenario 53 Copy Scenario X Delete Scenario 9 Delete All Scenarios L Print Financial Su L Compare Scenarios I Back X Exit Application Main Menu Click on one of the above buttons to create new Scenarios work with or delete your existing Scenarios or Exit the program Version 1 1 e Each time you re open the e Click on a scenario in the list to select it Without selecting any scenarios you program you will see all your saved scenarios listed here Now you can edit co
12. a Scenario and see your Gross Margin 1 Select a crop and enter yields and prices for that crop 2 Enter the operating costs for this Scenario 9 Compare the gross margins for this Scenario against other Scenarios that you have prepared 4 Manage and edit your Scenarios Gross Margin Comparison Tool for Vegetables Manual 2011 Page 4 1 3 The quick guide to using VegTool The first working screen you see is for managing your files Here you choose to create new Scenarios manage your existing scenarios print a financial summary or compare scenarios ia n VegTool Manage your scenarios create edit copy or delete SE x Ws Primary industries GROSS MARGIN COMPARISON TOOL FOR VEGETABLES Manage Scenarios Ef Tutorial T Conversion Calculator User Manual Name of Scenario amp Crop Details income Cost amp Gross Margin per Area Unit Scenario Season Crop Harvest Unit Area Unit Income Cost Gross Margin Broccili High Tech Fert Program Winter Broccoli Carton Hectare 12 880 00 11 043 68 1 836 32 Broccoli Traditional Fert Program Winter Broccoli Carton Hectare 11 200 00 10 537 46 662 54 Field Lettuce High Fertiliser Summer Field Lettuce Carton Hectare 37 500 00 8 077 16 29 422 84 Field Lettuce Low Fertiliser Summer Lettuce Carton Hectare 30 000 00 5 583 26 24 416 74 IPM Lettuce Summer Autumn Field Lettuce Carton Hectare 26 950 00 7 452 99 19 497 01
13. a value Interpret results with caution Gross Margin Comparison Tool for Vegetables Manual 2011 FINANCIAL SUMMARY OPERATING COSTS PER HECTARE Scenario Pumpkin Butternut WARNING Some operating cost feids Go not have a value Water 369 FrereEneeiR VAs i Seed amp Plants 210 ertiser 462 Freight Transport 1 280 Page 22 Compare Scenarios ot Wi Primary NSW Industries Manage Scenarios Name of Scenario amp Crop Details Scenario Season Broccili High Tech Fert Program Winter Broccoli Traditional Fert Program Winter Field Lettuce High Fertiliser Summer Field Lettuce Low Fertiliser Summer IPM Lettuce Summer Autumn Non IPM Lettuce Onions High Tech Fert Program Winter Onions Traditional Fertiliser Program Winter mokin Ruttern pring rump tLe op Pumpkin Jarradale Spring Pumpkin Jarradale 10 Spring Pumpkin Jarradale 20 Spring Water 50 ML Pumpkin Jarradale Spring Water 60 ML Pumpkin Jarradale Spring Water 70 ML Pumpkin Jarradale Spring PY Create a New Scenario P Edit Scenario 33 Copy Scenario Delete All Scenarios 4a Back Main Menu Click on one of the above buttons to create new Scenarios work with or delete your existing Scenarios or Exit the program GROSS MARGIN COMPARISON TOOL FOR VEGETABLES Summer Autumn eel gj VegTool Manage your scenarios create edit copy or delete x ff Tutorial
14. the costs appear in the financial summary Gross Margin Comparison Tool for Vegetables Manual 2011 Page 19 3 5 Using the calculators to determine your costs VegTool contains TEN calculators each corresponding to an operating costs category Within each calculator there is a choice of two METHODS to derive your cost per Hectare or per Area Unit 2 Method 1 Use recent Profit and Loss tax statements or accounts This provides a quick method that estimates the cost per hectare for this scenario 2 oe Method 2 Calculate your costs based on current prices and your practices for each category This calculates a more accurate figure using details of current prices and your practices Note In some calculators Method 2 asks for costs on a per Hectare basis In others you enter costs per your Area Unit Simple Guidelines on each calculator will tell you about each method Labour Cost Calculator Ctrl P to Print cameron Elctaitor usera A Labour Cost Calculator a ae j law 4 4 Use accovn _ g records or tax statements Profit amp Loss to estimate your labour costs estimates your labour costs Enter your total costs for Owner Manager on farm Permanent Casual and Contract Labour Then allocate a rsd percentage of these costs to the scenario for each of these may be different Then enter the number of hectares that shared this allocated cost Use this value in your scenario
15. 0 00 per hectare based on average of historical costs current prices and your practices Use this value in your scenario Calculate costs per hectare based on EEE O lO al NOTE Your Area Unit for this Scenario is equivalent to 0 1000 Hectares lit takes 10 0000 of your Area Units to make up 1 Hectare i i ethod Calculate costs per hectare based on current prices i yo ctices If you grow your own seedlings itis Method 2 Calculate costs per hectare based on current prices and your practices suggested that a separate budget is developed which includes materials growing costs and nursery labour This cost is then entered in On site Nursery Costs for Method 1 or Cost of self grown seedlings per thousand plants for Method 2 Helpful Hints Use the Scroll Bar on the right to Scroll Use the Tab key or click in any white box to update your calculations T oe hoe a How do l keep my crop details if I exit before enter the costs Click Continue after entering crop details Then click Save without entering any cost details Your scenario will not include any costs but you can come back to it later You might name the scenario draft or no costs to avoid confusion How do l look at Gross Margins and costs per bunch rather than per hectare Select Edit for a saved scenario The Financial Summary will show the details of the scenario with three columns of costs and gross ma
16. 36 32 Broccoli Traditional Fert Program Winter Broccoli Carton Hectare 11 200 00 10 537 46 662 54 Field Lettuce High Fertiliser Summer Field Lettuce Carton Hectare 37 500 00 8 077 16 29 422 84 Field Lettuce Low Fertiliser Summer Lettuce Carton Hectare 30 000 00 5 583 26 24 416 74 IPM Lettuce Summer Autumn Field Lettuce Carton Hectare 26 950 00 7 452 99 19 497 01 Non IPM Lettuce Summer Autumn Field Lettuce Carton Hectare 23 512 50 6 534 03 16 978 47 Onions High Tech Fert Program Winter Onions Bag Hectare 27 000 00 18 525 10 3 474 90 Onions Traditional Fertiliser Program Winter Onions Bag Hectare 24 000 00 16 522 17 7 477 83 Pumpkin Buttern Drina Pum ump DUTIEMUT gt p i U Pumpkin Jarradale Spring Pumpkin i Hectare 9 800 00 7 759 70 2 040 30 Pumpkin Jarradale 10 Spring Pumpkin Bin Patch 98 000 00 77 597 00 20 403 00 Pumpkin Jarradale 20 Spring Pumpkin Bin Patch 196 000 00 155 194 00 40 806 00 Water 50 ML Pumpkin Jarradale Spring Pumpkin Bin Hectare 9 300 00 7 689 70 2 110 30 Water 60 ML Pumpkin Jarradale Spring Pumpkin Bin Hectare 9 800 00 7 759 70 2 040 30 Water 70 ML Pumpkin Jarradale Spring Pumpkin Bin Hectare 9 800 00 7 829 70 1 970 30 dP Create a New Scenario J Edit Scenario X Delete Scenario Paginii A Copy Scenario WDelete All Scenario d Compare Scenario 4 Back X Exit Application Main Menu Click on one of the above buttons to c
17. AL funded VegBIZ project VG0O8021 This project is funded by HAL with support from the vegetable industry R amp D levy matched by Australian Government funds It is being managed by Gerard Kelly of the NSW Department of Primary Industries It is expected that most vegetable industry members i e levy paying growers and service providers will log in to the secure area of the AUSVEG website www ausveg com au and will download the program from the Internet At present to navigate to the download area for VegTool you navigate to Technical Insights then to Business Improvement then to Gross Margin Tool However those who wish to receive the VegTool program on a CD ROM can place an order by contacting Gerard Kelly VegBIZ Project Leader NSW Department of Primary Industries Vegetable Industry Centre Dareton Office Phone 03 5019 8406 E mail gerard kelly industry nsw gov au Project Staff Gerard Kelly NSW Department of Primary Industries Dareton NSW Susan Watts NSW Department of Primary Industries Dareton NSW Programming Support Grant Hamence Grant Hamence Software Design Pty Ltd www ghsoftware com au Disclaimer While a great deal of care has been invested in the development of VegTool Horticulture Australia Ltd or Scholefield Robinson Horticultural Services Pty Ltd or NSW Department of Primary Industries cannot accept any responsibility for losses arising from the use of it or the information it c
18. Cancel METHOD 2 This method calculates a Cance more accurate figure using details of NOTE Your Area Unit for this Scenario is 1 000 Hectare current prices and your practices NOTE The figures you enter here are per Area Unit Fot assistance use the Conversion or Numeric Calculators to determine the correct figure Method 2 Calculate la bour costs based on time and rates of pay in your chosen unit of area There are three categories of labour costs Permanent Labour Calculate costs per Area Unit for each of these based on Permanent Labour Include total hours that are for on farm work Casual amp Contract Labour Costs need to be carefully calculated Firstly identify the total worker hours no of workers x no of hours spent on each activity for this scenario and the current rates of pay When entering details for Tractor Driving include all operations eg sowing planting harvesting etc Piece Rate Activities Costs are choose from drop down boxes per payment unit chosen from drop down boxes and the number of payment units in your chosen Area Unit eee O Use the Scroll Bar on the right to scroll l N down the page O Use the Tab key or click on any white box a de fe eee eee Use this value in your scenario Cancel NOTE The Yield per your Area Unit is 1 200 00 Cartons of 14 kg 16 60 Tonnes Gross Margin Comparison Tool for Vegetables Manual 2011 Page 20 Ex
19. Carton Hectare 11 200 00 10 537 46 662 54 Field Lettuce High Fertiliser Summer Field Lettuce Carton Hectare 37 500 00 8 077 16 29 422 34 2 g CO PY Sce n a ri OS th n Field Lettuce Low Fertiliser Summer Lettuce Carton Hectare 30 000 00 5 583 26 24 416 74 IPM Lettuce Field Lettuce Carton Hectare 26 950 00 7 452 99 19 497 01 E D IT the copy SO you Summer Autumn can easily compare Non IPM Lettuce Summer Autumn Field Lettuce Carton Hectare 23 512 50 6 534 03 16 978 47 Onions High Tech Fert Program Winter Onions Bag Hectare 27 000 00 18 525 10 3 474 90 Onions Traditional Fertiliser Program Winter Onions Bag Hectare 24 000 00 16 522 17 7 477 83 S g h tl y d iffe re nt Pumpkin Butternut Spring Pumpkin Carton Hectare 14 400 00 610 70 13 789 30 Pumpkin Jarradale Spring Pumpkin Bin Hectare 9 800 00 7 759 70 _ 2 040 30 scenarios Pumpkin Jarradale 10 Spring Pumpkin Bin Patch 938 000 00 77 597 00 20 403 00 Pumpkin Jarradale 20 Spring Pumpkin Bin Patch 196 000 00 155 194 00 40 806 00 Water 50 ML Pumpkin Jarradale Spring Pumpkin Bin Hectare 9 800 00 7 689 70 2 110 30 3 G ro u Si m j lar Water 60 ML Pumpkin Jarradale Spring Pumpkin Bin Hectare 9 300 00 7 759 70 2 040 30 p Water 70 ML Pumpkin Jarradale Spring Pumpkin Bin Hectare 9 800 00 7 829 70 1 970 30 scenarios into reports using the REPORTS capability under COMPARE SCENARIOS 4p Create a New Scenario P
20. Edit Scenario x Delete Scenario L Print Financial Summary A Copy Scenario Delete All Scenarios Compare Scenarios Gross Margin Comparison Tool for Vegetables Manual 2011 Page 25 4 HOW DOI YOUR QUESTIONS amp THE ANSWERS How do work out my costs per hectare Q I know our input costs per glasshouse but some Cost Calculators ask for costs or inputs per hectare Donna A VegTool will tell you how many of your area units e g greenhouses it takes to make up one hectare Multiply the cost per greenhouse by this value to work out the cost per hectare or plants per hectare as in the Seed amp Plants Cost Calculator Seed amp Plants Cost Calculator Ctrl P to Print E Conversion i E Calculator ie User Manual Guidelines Seed amp Plants Cost Calculator METRON 1 A pukei etal that Method 1 Use accounting records or tax statements Profit amp Loss to estimate your seed amp plant costs estimates your seed amp plant costs Enter your total costs for Seed Plants and w Total Costs No of hectares Total Cost in 2 On Site Nursery if applicable then allocated to sharing this allocate a percentage of these costs to this Scenario allocated cost the scenario being reviewed The hectares percentage values for each of these may be different Then enter the number of hectares hectares METHOD 2 This method calculates a more accurate figure using details of
21. Hecere 16 80 Tonnes Hectare 857 14 per Tonne 857 14 pe Tonne 600 00 per Tonne 600 00 per Tonne 857 14 pe Tonne S086 pe Kilogram 30 86 pe Kilogram 0 60 per Kilogram 0 60 pe Kilogram 30 86 pe Kilogram 12 00 per Carton 12 00 per Carton 12 00 perBsg 12 00 pe Bag 12 00 pe Carton S Area Unit S Area Unit Gross Income 27 000 00 24 000 00 Operating Costs Seed amp Plants 1 440 00 1 440 00 Fetlse 2 137 10 555 00 Fuel 52 50 52 50 Chemicals 1 575 00 1 575 00 270 00 270 00 4 808 00 4 808 00 15 00 15 00 787 50 700 00 3 000 00 2 666 67 4 440 00 444000 5 583 26 5 583 28 18 525 10 16 522 17 16 522 17 24 416 74 24 416 74 8 474 90 7 477 83 7477 83 8 138 91 1 883 31 1 661 74 Weeks from Planting i 8 00 4 00 22 00 to Final Harvest Total Gross Margin 83 581 61 Printed Tuesday 13 September 2011 04 41 PM WARNING Some oper sting cost fields do not have a value Interpret results with caution Gross Margin Comparison Tool for Vegetables Manual 2011 Page 6 2 OBTAINING amp INSTALLING VEGTOOL VegTool is available on CD or by downloading from the AUSVEG website www ausveg com au To order a CD contact the VegBIZ Project Leader see page ii of this manual for contact details 2 1 Downloading VegTool from the AUSVEG website To download the VegTool program log in to the secure area of the AUSVEG website www ausveg com au then navigate to Technical Insights then to Business Improvement then to Gross Margi
22. R Aa S Your harvest unit is the unit that Crop E You can add a new harvest unit you use when you talk about season EO EEA if yours does not appear on the your yields For example you Name of Scenario dropdown list might talk about your crop in Period from Planting to Final Harvest weeks Ei You will be asked to type the unit terms of tonnes or trays or Anticipated Water Required for this Crop ML Ha ee ue singular and plural e g cartons or boxes or punnets Harvest Unit bundle and bundles Report Unit Click on the down arrow to see Area Unit onc be a dropdown list of harvest units a Tonne Select whether you want your gross margins reported using Click on your harvest unit to ae S your harvest unit or in kilograms select it from the list i ae or tonnes 1 Prices Select an Area Unit Sas TER CROP DETAILS as n the bows Your area unit is the name you Crop Butternut w A give the area you grow your crop BEz ES E Click on the down arrow to see a dadeni bellies weeks i dro down list of area units Anticipated Water Required for this Crop ML Ha g Harvest Unit E Cre aa Hick ase a ee If your area unit does not appear viick on your area UNIT to Selec ETE on the list please select Other or it from the list Area Unit IEA kiogram Patch Tonne Anticipated Yields i Prices aie es Shadehouse eh Shadehouse Portion E per Carton 2nd grade or 2n Cy a oe IB per Carton ord grade or riki
23. Tool if don t want to interfere with Access 2003 If you already use Access 2003 or an older version of Access for existing databases then your computer may now try to use Access 2007 Runtime to open your old files The old files may not open properly This is simple to manage When you want to open an old file simply re establish the link between your old file and Access 2003 See page 29 for step by step instructions How do l open my old Access 2003 files now that have loaded the Access 2007 Runtime version B FarmWage mh aana asant Microsoft Office A 92 KB ZA MyDb md Open rosoft Office A 136 KB rosoft Excel W 23 KB MP staves olin Share Restore previous versions Send To gt Cut Copy Create Shortcut Delete Rename Properties Gross Margin Comparison Tool for Vegetables Manual 2011 Q We already use Access 2003 for our farm wages When I open the wages file it tries to open using Access 2007 Runtime and the files don t open properly What do do now Tanya A When you open your old file you simply need to re establish the link between the wages file and Access 2003 Follow these steps e Right click on your old file in Windows Explorer Select Open with from the dropdown list A list of programs will appear Select the appropriate version of Access to open your file Page 31
24. We ULIUICLICIL JUDUL Primary GOVERNMENT n d u st r es Horticulture Australia IORTICULTURAL SERVICES Gross Margin Comparison Tool for Vegetables MANUAL Prepared by Alison McGregor amp Lauren Thompson Scholefield Robinson Horticultural Services Pty Ltd Gerard Kelly amp Susan Watts NSW Department of Primary Industries Acknowledgements The VegTool program was developed by Scholefield Robinson Horticultural Services Pty Ltd as part of a project commissioned by Horticulture Australia Ltd HAL The project VG08004 was funded by HAL with support from the vegetable industry R amp D levy matched by Australian Government funds to address a priority identified in the VegVision 2020 Strategic Plan Provide vegetable producers with a grower friendly tool for comparing gross margins Vegetable industry members growers provided valuable guidance regarding its capabilities Project Staff Lauren Thompson scholefield Robinson Horticultural Services Adelaide Alison MacGregor Scholefield Robinson Mildura Steering Committee Members Jeff McSpedden Vegetable Grower and Chair Information and Technology Advisory Group Danny De leso Vegetable Grower and Member Information and Technology Advisory Group Programming Support Kent Dean Mildura IT Pty Ltd hittp mildurait net Links with the VegBIZ Project Following the release of Version 1 0 of VegTool responsibility for the program transferred to the H
25. a Se amp Cut pr y P New Totals al is Aya 43 Copy A J T i s g casae Spelling 4 i iew aste U AES i Fe tem pm More gt 2 Click the Options button F Format Painter N ni ae Delete Zor 5 Views Clipboard fa Font we Rich Tet Records Security Warning Certain content in the database has been disabled A Security Alert will appear Click enable this content Access has disabled potentially harmful content in this database If you trust the contents of this database and would like to enable it for this session Then click OK only dick Enable this content Warning It is not possible to determine that this content came from a source You should leave this content disabled unless the content provides critical functionality and you trust its source More information File Path C Users susan Documents WORK VegToolProduction VegTool accdb Open the Trust Center The full screen will appear Primary iaa Industries Gross Margin Comparison Tool for Vegetables A teol for asaeasing De petettal profitability of vegetable producten iT IS THIS EASY IMPORTANT NOTE f you already Ss wastes Print Financial Summary amp Compare Scenarios have Access 2007 You will need a to follow the steps on the following SEDES ae pages to enable macros and CAE TEE security settings and prevent this from happening every
26. ample using Method 1 Method 1 is quick and easy to use but may not truly reflect the costs for this crop or area unit The Total Cost in Accounts is entered and then a percentage of these total costs is allocated to this scenario Finally this is divided by the number of hectares that shared this allocated cost The calculator will use this to determine a labour cost per hectare In this case the area unit selected is 1 hectare You might know that labour on the whole property costs 25 000 and 50 of this labour is shared across 10 hectares of vegetable farm Labour ES Calculator METHOD 41 A quick method that estimates your labour costs Enter your total costs for Owner Manager on farm Permanent Casual and Contract Labour Then allocate a percentage of these costs to the scenario being reviewed The percentage values for each of these may be different Then enter the number of hectares that shared this allocated cost METHOD 2 This method calculates a more accurate figure using details of current prices and your practices Click on Use this value in your scenario to have this cost appear in your cost screen Example using Method 2 wie this Scenario Owner Managers Costs on farm 25 000 00 50 00 Permanent Casual and Contract Labour Costs Total cost per Hectare Total cost per Area Unit When you click Use this value in your scenario it appears in the Enter Operating Cost s
27. c 701KB of 2 40MB copied Download to C WegT egTool FullAccess2007 zip Transfer rate 73 0KB Sec C Close this dialog box when download completes Cancel Page 7 Extract files from the Zip file Right click the Zip file then select WinZip and Extract to folder C or Extract to In the example below the files have been extracted to the same folder in which the Zip file was saved You may choose to save the extracted files in another folder by selecting Extract to Keep track of the name and location of the folder C WegTool Download File Edt View Favorites Tools Heb O Bp seach PP Fors C WegTool Download Folders U Desktop L My Documents a O AdobeStodPhotos GA My Musk L My PageManager j My Pictures LI Nero Recode CI NerovVision O New Folder D Updater My Computer E Sh 3 Floppy A Local Oik C I Documents and Settings MSOCache CI Protes E O Program Files E RECYCLER bad Scanned Documents O System Volume Information D Tere O Terp i4 D VegTool Download O WINDOWS Name Sze Type Date Modified CMMI open och wozy 24109 2009 3 00PM Explore Scan with AVG Extract to 2 Frat to Folder C eg WeoTool fulAccess2007 Create Sef Extractor EE G E Mail VegToot fullAccess2007 2p Open Wih b Send To r cu Copy Creste Shortast Delete Rename Properties Following the example above the files will be extracted in
28. creen Note that you can still type in a figure over the top of it in the white box if you want to use a figure that is higher or lower than the figure calculated in the Method 1 calculator Note If you plant two crops per year for example on a 5 hectare vegetable farm then you have really shared the costs across 10 hectares H Conversion E Calculator w User Manual Calculated Cost per hectare Total Costs No of hectares allocated to sharing this allocated cost Total Cost in 10 00 hectares 21 290 00 hectares 50 00 of historical costs Cancel 1 250 00 Pel Diesen Use this value in your scenario NOTE Your Area Unit for this Scenario is 1 000 Hectare Method 2 provides a more accurate figure for this specific crop I the Labour Cost Calculator eee ee Total hours per Area Unit 87 00 hours 46 00 hours Casual Labour and Contract Labour Total hours per Area Unit Activity Tractor Driving all operations Field planting thinning weeding Irrigation Harvest Grading Sorting Packing on farm Shed forklift coolroom per hour e Bate Acinaiie per hour per hour per hour per hour per hour per hour per hour hours per activity and labour rates per hour can be used to calculate a Cost per Area Unit for Permanent Labour and Casual and Contracted Labour It can also calculate Cost per Area Unit fo
29. d for advanced users Page 10 2 4 The first time you open VegTool If you already have Microsoft Access 2007 installed on your computer You may find that after you have installed the program you open it up and the first page a eon does not fill the entire screen Industries 0 for Vegetables Click the white X in the red box top right of the VegTool first page screen Type n your crop etais cluding crop type yeild and ncome Type n operating costs i you knew them or ese the single cost calculators ecividual oF up to a maximam of 5 scenarios Cat be ore viewed and Compared on screen or printed cut Manage Scenarios Scenaros ore af saved for you to review ect or delete or comple eto groups os Reports X gt wee Dol wes orepeced by Scholetelt Roteaos Hortculers Services ss pari of a poeci Commersioned by Horticuture Austrake Lid HAL to addr priarty Mertifes n Me VegVisen 2029 Strategic Pan Provide vepetadle producers wih a grower Sierdly too for campering gross marges e MSW Depertrect of Armary amp dusires cannot sccept any G us he resuts of calculations from Mis model to make mponam decisions we reco nd that you get enaysi such ss your accountant or farm business coneetant Ci dti y dya User Manual wl Workbook BB How to use VegTool The VegTool Screen will disappear and you Cin a c will see a Security Warning a None ceme mimosa _ oampnseTeois Anobi y
30. ding crop type yield and income Enter operating costs Type in operating costs if you know them or use the simple cost calculators Print Financial Summary amp Compare Scenarios Individual or up to a maximum of 5 scenarios can be pre viewed and compared on screen or printed out Manage Scenarios Scenarios are all saved for you to review edit or delete or compile into groups as Reports This tool was prepared by Scholefield Robinson Horticultural Services as part of a project commissioned by Horticulture Australia Ltd HAL to address a priority identified in the VegVision 2020 Strategic Plan Provide vegetable produ a grower friendly tool for comparing gross margins The project VG08004 was funded by Horticulture Australia Ltd with support from the vegetable industry levy matched by Australian Government funds VG08021 VegBiz Vegetable Enterprise Decision Support Systems is a subsequent project also funded by Horticulture Australia Ltd with support from the vegetable industry levy matched by Australian Government funds This projeg is led by NSW Department of Primary industries and is extending VegTool to vegetable producers and the vegetable industry Disclaimer While a great deal of care has been invested in the development of this tool Horticulture Australia Ltd Scholefield Robinson Horticultural Services Pty Ltd or NSW Department of Primary Industries cannot accept any responsibility for loges arising from the use
31. e High Fertiliser Field Lettuce Low Fertiliser Onions High Tech Fert Program Onions Traditional Fertiliser Pro Field Lettuce Onions Onions Summer Winter W inter 3 ML per Ha 3 M pe Ha 45 ML pe Ha 45 ML perHs 1 Hectere 1 Hectere 1 Hectere 1 Hectare Carton of 14kg Carton of 14kg Bag of 20 kg Bag of 20 kg Carton of 14kg 3 125 00 Cartons 2 500 00 Cartons 2 250 00 Bags 2 000 00 Bags 1 200 00 Cartons 3 125 00 Cartons Hectare 2 500 00 Cartons Hectere 2 250 00 Bags Hectare 2 000 00 Bsags Hedare 1 200 00 Cartons Hectere 43 75 Tonnes Hedare 36 00 Tonnes Hectare 45 00 Tonnes Hectare 40 00 Tonnes Hecare 16 80 Tonnes Hectare 857 14 per Tonne 857 14 pe Tonne 600 00 per Tonne 600 00 per Tonne 857 14 per Tonne 0 86 pe Kilogram 0 86 pe Kilogram 0 60 per Kilogram 0 60 per Kilogram 0 86 pe Kilogram 12 00 per Carton 12 00 per Carton 12 00 per Bag 12 00 pe Bag 12 00 per Carton S Area Unit S Area Unit Gross Income 30 000 00 27 000 00 Operating Costs Seed amp Plants 1 440 00 Fetilse 2 137 10 Fuel 5250 Chemicals 1 575 00 270 00 Labour 4 808 00 Electricity Gas 15 00 Paeckaging 787 50 Freight Transport 3 000 00 iE 4 440 00 5 583 26 5 583 26 18 525 10 24 416 74 24 416 74 8 474 90 8 138 91 1 883 31 ML W ster to Final Harvest Total Gross Margin 83 581 61 Printed Tuesday 13 September 2011 04 41 PM WARNING Some ope sting cost fields do not have a value Interpret results with caution Easy steps to create
32. er Onions Bag Hectare 27 000 00 18 525 10 8 474 90 Onions Traditional Fertiliser Program Winter Onions Bag Hectare 24 000 00 16 522 17 7 477 83 Pumpkin Butternut Spring Pumpkin Carton Hectare 14 400 00 610 70 13 789 30 Pumpkin Jarradale Spring Pumpkin Bin Hectare 9 800 00 7 759 70 2 040 30 Pumpkin Jarradale 10 Spring Pumpkin Bin Patch 98 000 00 77 597 00 20 403 00 Pumpkin Jarradale 20 Spring Pumpkin Bin Patch 196 000 00 155 194 00 40 806 00 Water 50 ML Pumpkin Jarradale Spring Pumpkin Bin Hectare 9 800 00 7 689 70 2 110 30 Water 60 ML Pumpkin Jarradale Spring Pumpkin Bin Hectare 9 800 00 7 759 70 2 040 30 Cl ck Water 70 ML Pumpkin Jarradale Spring Pumpkin Bin Hectare 9 800 00 7 829 70 1 970 30 here to create a new crop scenario 49 Create a New Scenario X Delete Scenario Print Financial Summary Copy Scenario Delete All Scenarios Compare Scenarios Back X Exit Application Main Menu Click on one of the above buttons to create new Scenarios work with or delete your existing Scenarios or Exit the program Version 1 1 Each time you re open the Click on a scenario in the list to e Without selecting any scenarios you program you will see all your select it Now you can edit copy or can go straight to a screen that saved scenarios listed here delete unwanted scenarios or print allows you to compare groups of a financial summary scenarios Gros
33. ging Cost Calculator Method 1 Use accounting records or tax st Total Package Material Costs Contract Packing Costs off farm Total cost per hectare Total cost per Area Unit NOTE Your Area Unit for this Scenario is It takes 10 0000 of your Area Units t Method 2 Calculate costs based on curren What amount per Package Materials Area Unit is required to pack this crop ENTER OPERATING COSTS Type in estimated costs for Read some the Area Unit you selected OR guidlines or use a per Hectare gt simple calculator v v AEAEE 210 21 Fertiliser 414 00 Fuel 413 75 Chemicals Ec 205 36 Labour ElectricityiGas B Packaging Freight Transport 4 Other Operating costs 1 091 25 HGOoEOARReReaae n Gross Margin Comparison Tool for Vegetables Manual 2011 Other Operating Costs Calculator i Joa tax statements iPront amp TIR lorive the pror Examples of OTHER OPERATING COSTS that might pertain to Total Costin Total Accounts allocated t Scenar Levies 1 000 00 Agronomy Consultants Other Professional Services Other Contracted Services e g Cultivation Inspection Services Audit Fees Maintenance Machinery equipment irrigation including tyres batteries and fiters Machine Plant and Equipment Hire specifically for this crop Lease or Rent Paymerts specifically for this crop Total cost per hectare 0 00 pe Total c
34. kg Carton of 3 5 kg Carton 9114kg Caton p114 kg Canon of 14 K 920 00 Cartons 800 00 Cagons 3 12500 Cagons 2 500 00 Cartons 2156 00 Cartons 920 00 Cartons Hectae 800 00 Cagons Hectare 3 125 00 Cagons Hectare 2 500 00 Camons Hectare 2156 00 Canons Heca 7 82 Tonnes Hectare 680 TomesHectare 4375 TomesHecae 35 00 TommesiHectar 30 18 Tonnes Hectare 1647 05 per Tome 1 647 06 perTomme 857 14 per Tonne 357 14 per Tonne 892 6 per Tome 1 65 per Kilogram 1 65 perKlogam 0 86 perKilogrm 0 36 per Kilogrem 0 89 per Kilogram 14 00 per Caton 14 00 perCarton 12 00 per Carton 12 00 per Carton 12 50 per Caton Area Unit Area Unit 11 200 00 30 000 00 2 000 00 735 00 200 00 2 2344 31201 92837 36000 3 400 00 160 00 160 00 Electniohy Gas 15 00 Packaghg j 1 600 00 1 4312 00 4 31200 Freignt Tenspor 45545 2029 18 2 029 18 Omer Operating Costs i 1 400 00 Tote Costs O43 10 537 46 7452 99 7 45299 B Gross income Operatrg Costs Gross Margin Gross Margin f 66254 24 416 74 19 497 01 19 497 01 la ino vgt Gross Margin per 11042 8138 91 6499 00 ML Water Weeks from Planting 15 00 800 t Final Harvest 80 Tote Gross Margin 75 835 45 Pinted Wednesday 14 September 20110107PM WARNING Some operting cost fields donot have avale Intemet resus win caution lf the print preview is small on your screen click the maximise button in the top right corner and it will fill the whole screen Click the X to return to the tool
35. mde How do I choose which folder I should use Double Click setup to install the program Double Click VegTool for Access 2007 YES Is Microsoft Access 2007 installed on my computer Double Click Double click VegTool with Access 2007 Runtime setup to install the program I am not sure if have Microsoft Access 2007 Click on the Start button select Programs select Microsoft Office and if you can t see Microsoft Access 2007 listed then you do not have Access 2007 F di Microsoft Office Pa a as a kK ACTE Tire fLcecict nt to fal ry a x CT k ler at Cr TT i Maintenance PES 7 Fo Microsoft Office Access 2007 Start E Programs E O a xl Microsoft Office Excel 2007 UCTOSOTT Ke m 5 i ae N Microsoft Office Outlook 2007 m Microsoft Office Live Add in gt ia Aia s E Microsoft Office PowerPoint 2007 S i Microsoft Office Publisher 2007 w Microsoft Office Word 2007 You may need to log on as the Administrator before you can install software on your computer If your efforts to launch the Setup Wizard are blocked due to the fact you don t have permission as a User you will have to Log Off and then Log On as the Administrator using the proper password Then go to the folder where the Setup exe file is located and double click it to launch the Setup Wizard Once the software is installed Log Off from Administrator a
36. mpkin Bin Hectare 9 800 00 7 829 70 1 970 30 Pf Create a New Scenario Fi Edit Scenario X Delete Scenario Print Financial Summary 33 Copy Scenario WY Delete All Scenarios L Compare Scenarios Back X Exit Application Print the financial summary for the selected scenario Click this button to preview or print the current scenario s financial summary Version 1 1 Financial Summary Report Financial Summary Pie Chart FINANCIAL SUMMARY Crop and Scenario Description Crop Pumpkin Season Spring Name of Scenario Pumpkin Buttemut Harvest Unit Carton of 14 kg Area Unit Hectare Water ML Ha 6 Anticipated Yield and Weighted Average Price 1 200 00 Cartons of 14kg per Area Unit 1 200 00 Cartons of 14kg per Hectare 16 80 Tonnes per Hectare Weighted Average P rice 12 00 per Carton of 14 kg Gross Income er Carton per A nit wth cauton Gross Income Operating Costs Seed amp Plants i I 210 00 Fertiliser h j 462 00 Fuel I 0 00 Chemicals 130 70 130 70 Water 360 00 360 00 Labour i 3 384 00 3 384 00 Electricty Gas etc 150 00 150 00 Packaging 5 2 076 00 2 076 00 Freight T ransport 1 280 00 1 280 00 Other Operating costs i 0 00 0 00 i 8 052 70 8 052 70 Gross Margin er Cartor per Area Unit per Hectare Gross Margin Gross Margin per ML Water 1 057 88 Weeks from planting to final harvest 18 Packaging 2 076 WARNING Some operating cost fields do not have
37. must be typed into the Yield box and the Price box in at least Continue 3 one of the three rows so that Gross Income can be calculated Enter either a gross or net price This is how the Enter Crop Details screen looks once you have entered the crop details Enter Crop Details Eroro Foomersin _Elcatutior user tana ENTER CROP DETAILS FINANCIAL Tyge wards or umber 7 coo a E Season Spring sw Adda Name of Scenario Pumpkin Butternut Harvest Unit Carton of 14 kg Hame of Scenario Pumpkin Butternut Area Unit Hectare Period from Planting to Final Harvest weeks i Anticipated Yield and Weighted Average Price Anticipated Water Required for this Crop ML Ha g aes ae Hi ce me a Sais Harvest Unit Cartons we a araa per Hectare 12 00 per Carton Weighted Average Price paige cai 1 1 si atl Gross Income per Carton per Area Unit per Hectare Carto Hectare 2 cm Gross Income 12 00 14 400 00 514 400 00 Kilogram Seed amp Plants Fertiliser Fuel Chemicals Total Area hectares Water Labour Anticipated Yields per your Area Unit and Prices Electricity Gas Packaging nan ore Sronsres ist grade or 1st pick Freight T rt mm PE PL eae reight Transpor Cartons earning 312 00 ee Other Operating costs 2nd grade or 2nd pick Total Operating Costs 0 O Cartons Au Gross Margin per Carto per Area Unit ard grade or 3rd pick Gross Margin 30 00 Lo Cartons earning ra per Carton Weeks fr
38. n Tool SCS hS Using the sidebar navigate to the bottom of the page Read the Installation Instructions SCS hS 2 When this screen appears click Save Choose a folder on your computer where the Zip file will be saved For example you may wish to create a folder on your C drive named VegToo Download which involves 1 Click this button to create a New Folder 2 Type in VegTool Download where it says New Folder 3 Click on the VegToo Download folder to open it 4 Click Save to save the downloaded Zip file into this folder Gross Margin Comparison Tool for Vegetables Manual 2011 Under Related Downloads click on VegTool for full or runtime version of Access 2007 File Download Do you want to open or save this file g Name YegTool fullAccess2007 zip Type Winzip File 2 40MB From www srhs com au Always ask before opening this type of file i While files from the Intemet can be useful some files can potentially Q harm your computer If you do not trust the source do not open or save this file What s the risk RECYCLER ad Scanned Documents Desktop System Volume Information Fie name Veg ool fullccess2007 zip v My Network Save as type WinZip File v Cancel File name Veg ool fulAccess2007 zip My Network Save as type WinZip File Kot oo egTool fullAccess2007 zip from www srhs com au Estimated time left 24 se
39. nd then Log On again with your User name and password Gross Margin Comparison Tool for Vegetables Manual 2011 Page 9 2 3 Completing Installation with Setup Wizard Once you double click Setup exe a Setup Wizard will be launched Click Next When this screen appears click Next Entering a User Name and Organisation is optional When two Icons appear on the screen click Typical if you do not have a preference for where the program is installed t will be installed in a folder on your C drive Experienced users may wish to click Custom and specify a different location in which the program will be installed Then click Next and the installation will start From now on VegTool 1 1 will appear as an icon on your desktop Open the tool by double clicking this icon Gross Margin Comparison Tool for Vegetables Manual 2011 Welcome to the VegTool Setup Wizard Primar The Setup Wizard will install VegTool on your computer Click W NSW GONERNMENT custias Next to continue or Cancel to exit the Setup Wizard Version 1 1 VegToo Please enter your customer information Organization Hewlett Packard Choose Setup Type Choose the setup type that best suits your needs Typical Installs the most common program features Recommended for most users Custom Allows users to choose which program features will be installed and where they will be installed Recommende
40. of it or the information it contains Before using the results of calculations from this model to make important decisions we recommend that you get your calculations checked by a professional financial analyst suc as your accountant or farm business consultant User Manual Workbook How to use VegTool Click the CONTINUE button to enter the program 3 2 Create a new crop scenario and manage your existing scenarios Veglool Manage your scenarios create edit copy or delete o EX Q Ro Primary Af Tutorial F conversion Calculator User Manual industries GROSS MARGIN COMPARISON TOOL FOR VEGETABLES Manage Scenarios Name of Scenario amp Crop Details Income Cost amp Gross Margin per Area Unit Scenario Season Crop Harvest Unit Area Unit Income Cost Gross Margin Broccili High Tech Fert Program Winter Broccoli Carton Hectare 12 880 00 11 043 68 1 836 32 Broccoli Traditional Fert Program Winter Broccoli Carton Hectare 11 200 00 10 537 46 662 54 Field Lettuce High Fertiliser Summer Field Lettuce Carton Hectare 37 500 00 8 077 16 29 422 84 Field Lettuce Low Fertiliser Summer Lettuce Carton Hectare 30 000 00 5 583 26 24 416 74 IPM Lettuce Summer Autumn Field Lettuce Carton Hectare 26 950 00 7 452 99 19 497 01 Pun Bin Hectare 4 Non IPM Lettuce Summer Autumn Field Lettuce Carton Hectare 23 512 50 6 534 03 16 978 47 Onions High Tech Fert Program Wint
41. om planting to final harvest TBA 2nd grade or 2nd pick price per Carton At least one set of yield and price is required Numbers must be typed into the Yield box and the Price box in at least came one of the three rows s0 that Gross Income can be calculated Enter either a gross or net price The crop scenario name and your income and yield details will appear in the financial summary Next Click on the CONTINUE button to start adding operating cost information Gross Margin Comparison Tool for Vegetables Manual 2011 Page 18 3 4 Enter Operating Costs This is how the blank screen looks ready for you to enter your cost information Enter Operating Costs ff Tutorial 7 Conversion Calculator i User Manual ENTER OPERATING COSTS FINANCIAL SUMMARY Type numbers in the boxes or use a cost calculator to derive crop costs Crop and Scenario Description Crop Pumpkin Season Spring Name of Scenario Pumpkin Butternut Harvest Unit Carton of 14 kg Area Unit Hectare Anticipated Yield and Weighted Average Price 1 200 00 Cartons of 14 kg per Area Unit 1 200 00 Cartons of 14 kg per Hectare 16 30 Tonnes per Hectare Weighted Average Price 12 00 per Carton of 14 kg Gross Income per Carton per Area Unit per Hectare Gross Income 12 00 714 400 00 14 400 00 Operating Costs per Carton per Area Unit per Hectare Seed amp Plants 0 00 0 00 0 00 Fertiliser 0 00 0 00 0 00 Fuel 0 00 0 00 0 00 Chemical
42. omparison report can be saved for later use Enter a title for this comparison report Comparison Report 14 Sep 2011 Load a Saved Comparison Report Check this box to total the margins for all scenarios W Select Scenarios Income Cost amp Gross Margin per Hectare Remove All Name of Scenario Crop eason Income Cost Margin 1 Broccili High Tech Fert Program A Broccoli Winter 12 360 00 11 043 66 2 Broccoli Traditional Fert Program Broccoli Winter 11 200 00 10 537 46 3 Field Lettuce High Fertiliser ix Field Lettuce Summer 37 500 00 4 Field Lettuce Low Fertiliser m Lettuce Summer 530 000 00 5 IPM Lettuce im Field Lettuce Summer Autun 26 950 00 Selected Printer EPSON Stylus CX5500 Series Change Printer Preview HiPrint i New Report lal Save Report gt Close Now select Report and Preview to see summaries of up to five selected scenarios together on one screen as shown below If you gave your report a name the report name will appear on the preview and the printout Compare Scenarios as a Report Compare Scenarios as a Bar Chart Comparison Report 14 Sep 2011 Name of Scenario Broce High Tech Fert Program Broccoli Traditonal Fert Progra Fisid Lettuce High Fertiliser Asid Lettuce Low Fertlser Sccoll Wiener i Water Feauirement 6 ML per Ha COMPARE SCENARIOS PER HECTARE Your Area Unk 1 Hectare Compacacn Aapon 27 1 20 Your Hanest Unk Canon of 85
43. ontains Before using the results of calculations from the VegTool program to make important decisions we recommend that you get your calculations checked by a professional financial analyst such as your accountant or farm business consultant Photographs We gratefully acknowledge AUSVEG as the source of the photographs used on the cover of this manual and in the screens that appear when the VegTool program is being installed VegTool Gross Margin Comparison Tool for Vegetables User Manual 2011 Page Contents 1 introduction including a Quick Guide to USING VEGT OO ccseccceeeseeeeeneeeeeneeeeaeeenenseeeeneeeeeneeenanes 3 1 1 VegTool can help your vegetable business cccccseeecececeeeeeeeeceeeeeeeeeaeseeeeesaeeeeeeesseeeeeeseaseeeeessaeeeeeesaeeeeees 3 1 2 VegTool is the ideal farm budget tool for the vegetable industry ec ccceeeecececeeeeeeeeeeeeeeeeeseeeeeeeesaaeeeeeeeas 3 1 3 The QUICK GUIDE to USING VEC TOON iicieciceis anwteccnmcncenstacetin initan anir Enka Onni ETATEN KEENE NEEE 5 2 Obtaining amp installing VegTool sssannnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn nnn nn nnmnnn mnnn nnna 7 2 1 Downloading VegTool from the AUSVEG website cccccceceeececceeeeeeeeeeeeeeeeeseeeeeeceeeeesseeeseeeeeesssaeaeeeeeeess 7 2 2 Installing VegTool from a CD eecccccccseeeceeeceeeeeeeeeeeeeeeeeeeeeeeeeeseeeeeeeeseeeseeeeseueeceeessaeeeeesseaeeeeesageeeessaeeeees 9
44. op isn t in the list click Add a Crop Continue gt I Watch this space for hints and explanations as you move to each white box If you choose to create a new scenario this screen will not have any data start entering your crop details e If you selected an existing scenario to edit or review this screen will have all your existing data in it e Use the TAB key to move between white boxes e Click on down arrows at the right end of white boxes to see a dropdown list of options Then click on the option in the dropdown list that you wish to select Select a crop Enter Crop Details Se _ ian M Click on the down arrow to see a dropdown list Crop Season Bitter Gourd TREE Bitter Melon Click on your crop to select it The list includes crops that pay a Period from agai weeks ii from the list vegetable R amp D levy Use the scroll bar to move through the drop down list of crops from A to Z to find your crop Broccoflower Broccoli Brussels Sprouts Bunching Onions not hard Area Unit Burdock Butter Beans culinary fresh Harvest Unii Button Squash Cabbage Cape Gooseberry Report Unit Harvest Un Kilogram Tonne Total Area E mE Anticipated Yields per your Area Unit and Prices Gross Margin Comparison Tool for Vegetables Manual 2011 Your crop is not listed You can add to the list Page 16 Select a Harvest Unit Enter Crop Details ERO
45. ost per Area Unit 0 00 Your Area Unit for this Scenario is equivalent to 0 1000 Hectares tt takes 10 0000 of your Area Units to make up 1 Hectare Page 29 How do l know whether already have Microsoft Access loaded on my computer Q How do know what programs are loaded To check what Microsoft programs are installed 1 Click on the Start button 2 Thenselect Programs in Windows XP Or All Programs in Windows Vista and Windows 7 Then select Microsoft Office or Another category of Microsoft software This will reveal a list of Microsoft programs If you can t see Microsoft Access listed then it is not loaded on the computer Windows XP Windows Vista Windows 7 r Search amp Help and Support Run Log OFF wattss fi Vindows XP Professional 3 Ig Microsoft Office PowerPoint 2007 Network LabelPrint Connect To Ps Adobe Photoshop CS4 Control Panel Si LightScribe Control Panel Default Programs CyberLink DVD Suite Help and Support di Maintenance J MAXON di Microsoft Office di Microsoft Office Live Add in di Microsoft Office ys Activation Assistant for Microsoft O Fi Microsoft Office Access 2007 Microsoft Office Excel 2007 Microsoft Office Outlook 2007 Microsoft Office PowerPoint 2007 Microsoft Office Publisher 2007 Microsoft Office Word 2007 Gross Margin Comparison Tool for Vegetables Manual 2011 Page 30 How do l use Veg
46. ply click No to retain them J Edit Scenarij X Delete Scenario WY Delete All Scenarios Print Financial Summary 4PY Create a New Scenario 53 Copy Scena Compare Scenarios How do l separate my data for the home farm and our other farm Q We want to keep all the scenarios for the home block separate from our other recently purchased block How do we save the files separately Leigh amp Anne A The simplest way to keep the files completely separated is to keep two separate data files in two separate folders on your computer Give the folders unique names e g VegloolHome amp VegToolOther and move the data file you want to look at into the folder containing the program files You would have to be an experienced computer user to recognise which file is the data file and to swap them around in this manner Instead of moving two data files between these folders you could try copying all of the files from the folder you created during installation e g C VegTool 1 1 if you opted for the Typical installation to another folder and opening the program from the second folder by double clicking VegTool accdb Again this is for experienced computer users An easier way particularly if you are an inexperienced or moderately experienced computer user would be to put an H the letter H followed by a dash at the start of all Scenario names for the Home Farm and an O a
47. pring Remove Pumpkin Jarradale 10 Spring 3 Field Lettuce High Fe Remove Pumpkin Jarradale 20 Spring 4 Field Lettuce Low Fe aHa Water 50 ML Pumpkin Jarradale Spring 4 gt Water S60 ML Pumpkin Jarradale Spring eee Lettuce __ Back _ gt Continue Remove Water 70 ML Pumpkin Jarradale Spring Selected Printer x EPSON Stylus CX5500 Series Change Printer Report C ih Chat Preview dPrint i New Report la Save Report X Close dP Create a New Scenario P Edit Scenario ps Delete Scenario Print Financial Summary 53 Copy Scenario XfDelete All Scenarios Compare Scenarios Back X Exit Application Compare Scenarios Click the button to select and Compare Preview or Print scenarios Version 1 1 _ EEE a E eee a a E VegTool Manage a VegTool Manual ch a SCREEN CAPTURES Adobe Ilustrator CS fe Screen Captures Desktop lt te YC 1 10PM wae ol i VegTool Manage your scenarios create edit copy or delete p Keep your scenarios Was Primary eet Ff Tutorial i NSW industries organised GROSS MARGIN COMPARISON TOOL FOR VEGETABLES Manage Scenarios 1 i DELETE any Name of Scenario amp Crop Detais redundant scenarios Scenario Season Crop Harvest Unt Area Unit Income Cost Gross Margin Broccili High Tech Fert Program Winter Broccoli Carton Hectare 12 880 00 11 043 68 1 836 32 Broccoli Traditional Fert Program Winter Broccoli
48. profit e See the effect on your Gross Margins of small changes in yields or prices or costs e Prepare more detailed forecasts for your Scenarios by using one of the Cost Calculators pe Examples of the types of questions you might ask when using the tool r Will still have a positive Gross Margin if the price of temporary allocation water goes above 500 per megalitre What will happen to my Gross Margin if prices next season are reduced by 10 or if input costs increase by 10 Am I more likely to make a profit if grow crop A or crop B 1 2 VegTool is the ideal farm budget tool for the vegetable industry VegTool is very simple to use but gives you excellent information for making decisions You can oe Compare Scenarios s Print groups of Scenarios e Prepare a quick snapshot analysis e Prepare a comprehensive analysis if you want detail Gross Margin Comparison Tool for Vegetables Manual 2011 Page 3 e Manipulate inputs easily and instantly see the impact this has on your Gross Margin se Use all your preferred units of yield price and crop area You don t need to be thinking in tonnes or hectares For example you can create Scenarios using Trays per glasshouse span Bunches per bed x dollars per bunch Crates per patch Bins per section of pivot An example of Gross Margin comparisons created using VegTool Comparison Report 13 Sep 2011 Field Lettuc
49. py or delete unwanted scenarios or print a financial summary can go straight to a screen that allows you to compare groups of scenarios To create a Scenario you first enter the crop details Enter Crop Details A m E Tutorial 7 Conversion Calculator User Manual a j j Enter data into the white ENTER CROP DETAILS FINANCIAL SUMMARY boxes Type words or numbers in the boxes or select values from the dropdown lists Crop and Scenario Description cop an ronal Use dropdown lists to select Name of Scenario your crop season harvest unit and area unit e g bed patch pivot acre etc Period from Planting to Final Harvest weeks H Anticipated Water Required for this Crop ML Ha od SS Harvest Unit Harvest Unit Area Unit 0 0000 hectares Anticipated Yield and Weighted Average Price Yield 0 00 per Area Unit per Hectare Weighted Average Price 0 00 per So Details appear in the Report Unit Gross Income per Harvest Unit per Area Unit financial summary on the Area Unit ahi Gross income ee 50 00 EET right as you enter Tonne tt information on the left e Chemicals Watch the comments here oe a oe peal They offer hints or explanations as you move to each white box Gross Margin Comparison Tool for Anticipated Yields per your Area Unit and Prices ist grade or ist pick carino M 2nd grade or 2nd pick carino M carino M 3 t grade or 3rd pick A
50. r Piece Rate Activities using basis of payment and number of payment units per your chosen Area Unit Calculated Cost per Area Unit 2 175 00 1 200 00 Calculated Cost per Area Unit 0 00 0 00 0 00 30 00 0 00 When entering figures for permanent labour in a gross margin only include costs which are directly related to on farm work 30 00 0 00 0 00 Basis of Payment Number of Activity Description 9 per row or per bucket Payment Units Choose an activity from in your chosen EErEE me i the list or type in your own Payment Unit Area Unit ne id ze This example uses piece rates Zm 0 Ea ei for harvesting bins and for Packing 0 30 per Bag A x 1200 00 960 00 g a i packing per A x 0 00 B per e x 0 00 L FA an nmm Back Gross Margin Comparison Tool for Vegetables Manual 2011 Page 21 3 6 Print Financial Summary and Compare Scenarios Print Financial Summary m 5 ma gii VegTool Ma ur scenarios create edit copy or delete anm Q RO Primary ff Tutorial 7 Conversion Calculator User Manual NSW industries GROSS MARGIN COMPARISON TOOL FOR VEGETABLES Manage Scenarios Name of Scenario amp Crop Details Income Cost amp Gross Margin per Area Unit Scenario Season Crop Harvest Unit Area Unit Income Cost Gross Margin Broccili High Tech Fert Program Winter Broccoli Carton Hectare 12 830 00 11 043 63 1 8
51. reate new Scenarios work with or delete your existing Scenarios or Exit the program Version 1 1 On the Manage Scenarios screen select the scenario and then click Print Financial Summary This screen has options to preview or print your Financial Summary as a Report as or a Pie Chart a p p i i VegTool Manage our scenarios create edit copy or delete d i 7 1 ke E XK Q ai Department of E Tutorial F Conversion E Calculator User Manual Primary Industries GROSS MARGIN COMPARISON TOOL FOR VEGETABLES Manage Scenarios Financial Summa Name of Scenario amp Crop Details st amp Gross Margin per Area Unit Scenario FINANCIAL SUMMARY Oroa iene Broccili High Tech Fert Programi 3 68 1 836 32 Broccoli Traditional Fert Progra 7 46 662 54 Field Lettuce High Fertiliser 16 29 422 34 Field Lettuce Low Fertiliser 5 3 26 24 416 74 Pe tomes SON Stylus CX5500 Series ja Change Printer PATIN Non IPM Lettuce 4 03 16 978 47 Onions High Tech Fert Program 525 10 3 474 90 Onions Traditional Fertiliser Prog 7 477 83 Pumpkin ump DU U Pumpkin Butternut2 13 840 00 Pumpkin Jarradale 9 70 2 040 30 Pumpkin Jarradale 10 n z 97 00 20 403 00 Pumpkin Jarradale 20 g 194 00 40 806 00 Water 50 ML Pumpkin Jarradale OUUU ee N a 2 110 30 Water 60 ML Pumpkin Jarradale Sprin P Bi a 9 800 00 759 70 2 040 30 Water 70 ML Pumpkin Jarradale Spring Pu
52. rgins By changing your selection in the little box called Report Unit you can view your Gross Income Costs and Gross Margin per the harvest unit you selected or per kilogram or per tonne How do I add yield and price information for another grade or an additional harvest when there is only the option to enter yield and price details for three grades or picks My crop has more than three grades picks If you have more than three grades or harvests you could create two scenarios in the first scenario enter the yield and price details for the first three grades or picks then in the second scenario use the information from the first scenario total yield and weighted average price in the first row of yield and price information and add the information for the extra grades or harvests into the other two rows Gross Margin Comparison Tool for Vegetables Manual 2011 Page 26 How do make VegTool recognise my last costs They don t appear in the summary No information is recorded until you click enter or tab You might forget this on the last data entry last The summary will update itself once you Click enter or tab or save How do l calculate a Total Gross Margin for a set of scenarios Q Our farm has three distinct areas We have chosen crop options for each area Now we want an overview of our P ee potential annual profit by seeing the total gross margin i across all three areas Bob COMPARE SCENARIOS
53. rriggal Greeens Pee Tong Ho a J Add a Season Name of Scenario Q I was showing dad how you can add harvest Name of SeA Area Unit 0 0000 hectares units but now I want to delete most of them BE vs sen css co a eo a e A In this version of VegTool if you want to delete ol Wax our Kovan C E E the new crops seasons and harvest units you Sead amp Piris no s added you first have to click the Delete All a a inl 0 00 0 00 so Scenarios button and click Yes when asked to a Laie som mo confirm the deletion Note that this will also delete A ae a 0 00 3 all the scenarios you have saved Then you are eee A Toa Operating Costs T T T given the option to delete all of the other things a ey rere a E you ve added so you have a clean slate carino M EEN Crop amp Back Required Please select a crop from the dropdown list If your crop isn t in the list click Add a Crop Continue i Gross Margin Comparison Tool for Vegetables Manual 2011 Page 27 How do l get rid of all the saved scenarios but not lose the new crops new season names and new harvest units that added to VegTool Q want to Start a fresh version of Veg Tool but VegTool Manage your scenarios create edit copy or delete Ai cholefield Robinson want it to keep the crops season names and NSW le ain harvest units added Can get rid of the GROSS MARGIN COMPARISON TOOL FOR VEGETABLES k h hi
54. s aaa Cartons earning o per Carton How big is your crop area Harvest If you selected an area unit other Area Unit Bed ET than hectare or acre you will Calculate the size of your Area Unit Tonne Pa ee angr g Width ery 20 In this example the beds are width of the crop area This allows you to compare your yields and gross margins per OR Type in a value hectare Total Area hectares 1 75m wide and 124m long Gross Margin Comparison Tool for Vegetables Manual 2011 Page 17 Nominate the yields and prices j i Chemicals 0 00 0 00 0 00 Enter a yield and the price Total Area MG hectares Water 0 00 0 00 0 00 you expect a Labour 0 00 0 00 0 00 Anticipated Yields per your Area Unit and Prices Electricity Gas 0 00 0 00 0 00 1st grade or ist pick Packaging 0 00 0 00 0 00 A A Freight Transport 0 00 0 00 0 00 You have the option to divide 1200 R 512 00 Aaen chee lt r harvest in hr 2nd grade or 2nd pick Total Operating Costs 0 00 0 00 0 00 ia S ji t al i j E Cartons earning RM per Carton Gross Margin per Carton per Area Unit gra eS or up 0 ree 3rd grade or 3rd pick Gross Margin 0 00 0 00 different picks For example GA Cartons s earning per Carton Weeks from planting to final harvest TBA the earliest crop might achieve the best prices 2nd grade or 2nd pick price per Carton Back At least one set of yield and price is required Numbers
55. s from the vegetable industry levy matched by Australian Government funds This project is led y Ltd or NSW Department of Primary Industries cannot accept any responsibility for losses mmend that you get your calculations checked by a professional financial analyst such as A message box asking whether you trust the source of the program Che Opel Security Notice This standard security warning may appear when you A i TT download Access 2007 Runtime eaten Sey een es eee Your computer has merely recognised that you are importing oleate ald FOE a aca afte new software VegTool 1 1 and is warning you that it is new leave this content disabled unless the content provides software critical functionality and you trust its source File Path F base by AMS Database3tryagainextracted accor This file might contain unsafe content that could harm your computer Do you want to open this file or cancel the operation More information The opening screen is does not fill my your computer screen Click the maximize button circled to maximise the screen This may make it fit perfectly 7 Conversion E Calculator ie User Manual Still not fitting perfectly Exit from the program and re open it When you reopen the file your computer will have worked out how to set the screen and it should fill the screen Income Cost amp Gross Margin per Area Unit properly when you click on the maximise button Income Cost Gross Margin
56. s 0 00 0 00 0 00 Water 0 00 0 00 0 00 Labour 0 00 0 00 0 00 Electricity Gas etc 0 00 0 00 0 00 Packaging 0 00 0 00 0 00 Freight Transport 0 00 0 00 0 00 Other Operating costs 0 00 0 00 0 00 Total Operating Costs 0 00 0 00 0 00 Gross Margin per Carton per Area Unit per Hectare Gross Margin 0 00 0 00 0 00 Gross Margin per ML Water 0 00 Weeks from planting to final harvest 18 seed amp Plants Costs m Peas E Optional Please enter a number or click the button to the right to open the Seed amp Plants Cost Calculator i WARHING Some operating cost fields do not have a value Interpret results with caution Type in estimated costs for Read some guidlines the Area Unit you selected OR or use a simple cost perHectare calculator Seed amp Plants gm e Fertiliser Er Fuel Chemicals a E Water Labour Electricity Gas Hoon Packaging Freight Transport Other Operating Costs If you know your costs per area unit of crop per bed in this example then enter the values directly into the white boxes Enter Operating Costs ffl Tutorial 7 Conversion Calculator B User Manual ENTER OPERATING COSTS FINANCIAL SUMMARY Type numbers in the boxes or use a cost calculator to derive crop costs Crop and Scenario Description I s If you don t know Type in estimated costs for Read some guidlines aa baran the Area Unit you selected OR i what it costs per d H T pieda
57. s Margin Comparison Tool for Vegetables Manual 2011 Page 15 3 3 Enter Crop Details This is what the screen for entering crop details looks like le Enter Crop Details E Calculator User Manual The financial summary will fill up with data as you enter your crop details sai TER CROP DETAILS crop ___ NS Eee lt 6S Hame of Scenario l Harvest Unit LUES OOOO reat 0 0000 hectares Period from Planting to Final Harvest Ooo weeks fii Anticipated Yield and Weighted Average Price Yield 0 00 per Area Unit Anticipated Water Required for this Crop ML Ha l per Hectare E CO Report Unit acount E e Kilogram Tonne Harvest Unit Weighted Average Price 0 00 per Gross Income Gross Income 0 00 Operating cost information Sie will appear when you begin perating Costs per Harvest Unit n Seed amp Plants to enter cost details That s irr the next step after you Fuel Chemicals l l j Total Area JY hectares Water i i i click CONTINUE Labour Electricity Gas Packaging Freight Transport Other Operating costs Total Operating Costs Gross Margin per Harvest Unit per Area Unit Anticipated Yields per your Area Unit and Prices ist grade or ist pick caning 2nd grade or 2nd pick caning 3rd a or 3rd pick caning per Harvest Unit Gross Margin 0 00 Weeks from planting to final harvest TBA Crop ss Sm nr Please select a crop from the dropdown list J your cr
58. t the start of all Scenario names for the Other Farm Since the Scenarios are listed alphabetically this will keep them separated in the list that appears in the Main Menu How dol change the printer that my comparison is printing to See instructions for changing printers in Section 3 6 Compare Scenarios and Print Financial Summary Gross Margin Comparison Tool for Vegetables Manual 2011 Page 28 How do I make VegTool fill my screen instead of being a small box in the centre of the screen A Maximise the image screen using the maximise button on the top right corner of VegTool It will now fill the whole screen ZN rr x te 7 Conversion Calculator User Manual GETABLES Income Cost 43 750 00 7 897 16 35 000 00 5 403 26 9 000 00 7 750 28 6 300 00 5 665 67 Gross Margin income Cost amp Gross Margin per Area 35 852 84 29 596 74 1 249 72 634 33 How do l personalize the tool more It doesn t quite cover all aspects of my production A Many of the sheets in VegTool allow you to add your own details crop season harvest unit or you can select Other to cover any unique costs Note that the ability to Add a Season gives you the opportunity to use this space to add something other than the suggested season when creating Scenarios You may like to use this space for your own personalised description of your scenario Packa
59. time you open VegTool Gross Margin Comparison Tool for Vegetables Manual 2011 Page 11 To enable macros in Microsoft Access 2007 Click on the Office Button on the top left of your screen to see the dropdown list Then click on the Access Options button Recent Documents LSAPROJECTS veqgTool scedb 2 S PROJECTS WWegitoal scedb a S PROJECTS WegToal scedb 4 SA PROJECTS WiregToaal acedb 5 SAPROJECTS WregTadalaccdbh 6 SA PROJECTS WregTodlaccdbh T SAPROJECTS Weg tadlaccdb BSAPROJECTS Wregiodlaccdh SSA PROJECTS WwegmooLaccdh Publish Close Database OO M O O amp H Access Options W Exit Access a In the box that appears click on Trust Centre Popular pi i ae ay Re AANA nie Help keep your documents safe and your computer secure and healthy Current Database Then click on Trust Centre Settings Datasheet Protecting your privacy Object Designers Microsoft cares about your privacy For more information about how Microsoft Office Access helps to protect your privacy please see the privacy statements Proofin 9 Show the Microsoft Office Access privacy statement Advanced Microsoft Office Online privacy statement Customer Experience Improvement Program Customize Security amp more Learn more about protecting your privacy and security from Microsoft Office Online Resouteee Microsoft Windows Sec
60. to a new folder that has the same name as the Zip file which will be in the same folder as the Zip file WinZip VegToolForFullOrRuntimeVerOfAccess2007 zip File Actions View Jobs Options Help AA We wea vs wes New Open Favorites Extract Mail Encrypt View Install Wizard View Style aes em a Folders x cD VegToolForFullOrRuntineverd Files helected 0 files 0 bytes Installing VegTool after extracting files downloaded from the AUSVEG website Type Modified Size Patio Packed Folder 14 10 2009 3 32 PM setup exe Install Applic 1 12 2008 10 46 AM 495 472 60 200 550 autorun inf Setup Infor 22 04 2008 3 49 PM 59 12 5z Total 4 Files 3 636K6 Click on the folder containing the files that were extracted from the p Zip file see above examples One of the files will be named F Setup exe or there will be an icon with the word Setup under it Once you double click Setup exe or the above icon you will launch the Setup Wizard shown in 2 3 Gross Margin Comparison Tool for Vegetables Manual 2011 Page 8 2 2 Installing VegTool from a CD Insert the CD in your CD DVD drive The VegTool 1 1 CD contains two folders and the VegTool Manual Adobe p VegTool for Veg Tool with VegTool Access 2007 Access 2007 Runtime Manual pdf Gross Margin Comparison Tool for Vegetables Wi oman DO lun NSW industries VAI Veghiz Wegatalile Enterprise Decision Suppart eters isa projec fi
61. umpkin Pumpkin Jarradale Pumpkin Pumpkin Jarradale 10 Pumpkin Pumpkin Jarradale 20 Pumpkin Water 50 ML Pumpkin Pumpkin Water 60 ML Pumpkin Pumpkin Water 70 ML Pumpkin Pumpkin m D Broccili High Tech Fert Program Brom Broccoli Traditional Fert Program Field Lettuce High Fe Field Lettuce Field Lettuce User Manual COMPARE SCENARIOS Choose up to five 5 scenarios to compare Y Income Cost amp Gross Margin per Hectare Remove All Income Cost Margin Change Printer Preview GMPrint i New Report la Save Report X Close Load a saved Comparison Report Add or remove scenarios from this comparison Income Cost amp Gross Season Income 0 A drop down list of all your saved scenarios allows you to select the ones you want to appear in the comparison 29 422 34 ummer 24 416 74 Summer Autumn 19 497 01 Spring 2 040 30 Summer Autumn 16 978 47 Winter 8 474 90 Winter 7 477 83 recall the report later on Spring 4 362 30 Spring 13 789 30 Spring 2 040 30 Spring 20 403 00 Spring 40 806 00 Spring 2 110 30 Spring 2 040 30 Spring 1 970 30 Gross Margin Comparison Tool for Vegetables Manual 2011 Select up to five scenarios in one Report so you can quickly Page 23 F Compare Scenario User Manual COMPARE SCENARIOS hoose up to five 5 scenarios to compare Your c
62. urity Center Microsoft Trustworthy Computing Microsoft Office Access Trust Center eT The Trust Center contains security and privacy settings These settings help keep your computer z secure We recommend that you do not change these settings Trust Center Settings e In the Trust Centre click on Macro Settings to see your level of security for macros Trusted Publishers Trusted Locations Select Disable all macros except digitally signed m acros g e2309E UU able all macros not recommended potentially dangerous code can run Privacy Options Click OK Note If you select Disable all macros with notification then you can still use VegTool but every time you open VegTool you will get a security warning and you will need to re enable the macros before you can start Gross Margin Comparison Tool for Vegetables Manual 2011 Page 12 2 5 Adjusting screen settings for your computer Every computer has different security and screen settings When you first open VegTool what you see on the screen may vary depending on your computer settings You need to do this If you see the following When I click on it the CONTINUE button doesn t work This has occurred because your computer has a high security setting and is disabling macros See previous two pages ess a priority identified in the VegVision 2020 Strategic Plan Provide vegetable producers with fund

Download Pdf Manuals

Related Search

Related Contents

Rapport - Hugo`s  Ettan IPGphor 3 Bedienungsanleitung  Waters Inline Degasser AF User Manual  Styles of Exploration  Metadata Capture User Guide  SYBA SI-ENC50070  caution - Custom Service Hardware  Manual iCom Industrie Computer - Development  

Copyright © All rights reserved. Failed to retrieve file