MANUAL - Ausveg
Contents
1. Total Costs 63 570 00 10 171 20 64 070 00 10 251 20 63 070 00 10 091 20 15 670 00 2 076 00 41 520 00 52 80 234 00 4 680 00 pA e 23 030 00 a Gross Margin 3 654 80 2 930 00 468 80 4 770 00 763 20 330 00 14 Weeks 10 Weeks Printed Monday 14 September 2009 02 21 PM Pla arest 16 Weeks 14 Weeks 14 Weeks Easy steps to create 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 3 Compare the gross margins for this Scenario against other Scenarios that you have prepared 4 Manage and modify your Scenarios Gross Margin Comparison Tool for Vegetables Manual 2009 Page 4 1 1 The quick guide to using VegTool The first working page you see is for managing your files Here you choose to create new Scenarios or manage your existing ones or view comparisons Fz Manage your scenarios create modify or delete veg Tool GROSS MARGIN COMPARISON TOOL FOR VEGETABLES Manage your scenarios create modify or delete Scenario Name amp Crop Details Scenario Season Brisbane Austumn Summer Crop Sweet Corn Harvest Unit Income Cost amp Gross Margin per Area Unit Area Unit Income Cost Gross Margin Brisbane Feb Summer Sweet Corn Carton Brisbane markets december Sweet Corn Carton n for Bushfoods Austra Summer WWarragal Greens Bunch Si C lic k he re to create a new processing Summer2. 0 25 1 500 00 7 Cartons earning per Carton desires oa ie oe You have the option to divide andl grade or 2nd pick Other operating costs 067 4 000 00 i BEE catons camino 13 00 rer Carton Total Operating Costs 10 50 63 570 00 your harvest into up to three ares wate eta eras ee 3rd grade or 3rd pick bross Bargin per Carton per Area Unit grades or up to three different picks For example the earliest crop might achieve the best prices chs 23 030 00 1000 e joys eaming per Carton Gosia O CC Weeks to grow amp harvest crop 16 4st grade or 1st pick number of Cartons per your Area Unit Optional Numbers must be typed into ihe Yield box and the Price box in at least one of the three rows so that Gross Income can be calculated This ts how the Enter Crop Details page looks once you have entered the crop details Enter crop and income details ENTER CROP DETAILS Type words or numbers in the boxes or select values from the dropdown lists Bris Dec best prices Period from Planting to Final Harvest weeks Carton weight aE Report Unit Carton i Le Area Unit Kilogram Calculate the size of your Area Unit C Tonne width m Length Ti FINANCIAL SUMMARY Crop and Scenario Description Crop Sweet Corn Season Summer Scenario Hame Bris Dec best prices Harvest Unit Cartons Area Unit Patch 6 2500 hectares Anticipated Yield and Weighted Average Price 6 000 00 Cartons fof 18 kg per Area Unit
3. Bris Dec best prices SUMMer OO lt a Remove 1 z 56 600 00 63 570 00 25 030 3 Brisbane feb market oO 5 2 930 4 5 Sweet Corn Summer 67 000 00 64 070 00 2 93 4 Remove Brisbane march markets Sweet Com SUMIMer 55 300 00 63 070 00 T4 770 00 2 Remove worst CASE processing Sweet Corn SUMMEF 16 000 00 15 670 00 330 00 Remove ill Selected Printer E eprint ig New Report lal Save Report ALLA Now select Preview to see summaries of your five selected scenarios together on one page as shown below If you gave your report a name the name will appear on the preview and the printout A Preview om jie Compare Scenarios Scenano Name Crop Season Your 4rea Unit Your Harvest Unit Yield Gross Income Operating Costs Seeds amp Plarts Fertiliser Fuel Chemicals Water Labour Energy Packagng Freight Other Total Costs Gross Margin Planting to Harvest BrisE arly Dec worse prices Bris Dec best prices Brisbane feb market Brisbane march markets worst case processing Sweet Com Spring 1 Patch 6 25 Hectares Carton of 18 kg 6 000 000 Cartons 960 000 Cartons Hectare 17 280 Tonnes Hectare 562 96 per Tonne 0 56 per Kilogram 10 13 per Carton Area Unit 60 800 00 3 000 00 2 156 00 1 850 00 1 564 00 9 000 00 33 000 00 1 500 00 1 500 00 6 000 00 4 000 00 63 570 00 2 7 70 00 480 00 344 96 296 00 250 24
4. Total Operating Costs 0 67 4 000 00 640 00 Gross Margin per Carton per Area Unit per Hectare Gross Margin 13 77 z 600 00 13 216 00 Weeks to grow amp harvest crop 16 Other Costs o gt BER Optional Please enter a number or click the button to the right to open the Other Costs Calculator ial ae Chemicals Water Labour Electricity gas etc Packaging Freight Transport a ae gt C gt er gt ie pem a a gt ear gt gt 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 Casts ENTER OPERATING COSTS Type numbers inthe boxes or fill out worksheets to denve crop costs FINANCIAL SUMMARY Crop and Scenario Description Crop Bok Choy 1 Type in estimated costs per Bed which Read some season Winter If you don t know is your chosen Area Unit for this OR guidlines or usea A Seana aii j scenario gt simple worksheet arn re OSRE A what It costs per i ii Area Unit 1 Bed 0 0217 Hectares area unit e g per 4 Rh _Anticipated Yield _ i i 900 00 Bunches of 0 3 kg 270 00 kg bed in this case EAE 35 00 41 474 65 Bunches of 0 3 kg per Hectare YOu Can use a l B 12 442 40 Kilograms per Hectare i Fertiliser 16 00 Weighted Average Price 0 61 per Bunch of 0 3 kg simp Gross Income per Bunch per Area Unit per Hectare worksheet Fuel 12 00 Gross Inco
5. accounts per Patch gt simple worksheet covering h duration of crop sh nF Miscellaneous labour costs shared by Seed amp Plants Levies shared by Fertiliser 2 156 00 Commissions shared by tom 1 850 00 Agronomy consultants and other shared by eum 1 564 00 professional services Maintenance machinery equipment shared by CECH 10 000 00 irrigation Machine plant shared by ta 33 000 00 and equipment hire TICally tv 3 S00 Electricity gas ete shared by Packaging shared by Other Optional Name Polystyrene Box Freight Transport q Other operating costs T Punnet rea Unit is 6 000 00 Carto e is 960 00 Cartons of 18 BHR eSeeeeage shared by shared by 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 How do I get printouts of the Worksheets I ve filled in to derive my operating costs A VegTool 1 0 does not have the capability of printing the individual worksheets However you can copy what you can see on your computer screen to a Word document or other type of document such as an Excel worksheet or a new e mail message by doing a screen dump Using a Word document as an example first open a new blank Word document then go back to the VegTool worksheet you wish to copy and get the
6. 1 440 00 5 280 00 240 00 240 00 960 00 640 00 10 171 20 443 20 16 Weeks Sveet Com Summer 1 Patch 6 25 Hectares Carton of 18 kg 6 000 000 Catons 960 000 Catons Hectare 17 280 TonnesHectare 801 85 per Tome 0 80 per Kilogram 14 43 per Carton Area Unit 66 600 00 3 000 00 2 156 00 1 850 00 1 564 00 9 000 00 33 000 00 1 500 00 1 500 00 6 000 00 4 000 00 63 570 00 23 030 00 es eee H ectare 13 856 00 480 00 344 96 296 00 250 24 1 440 00 5 280 00 240 00 240 00 960 00 640 00 10 171 20 3 654 80 16 Weeks Sweet Com Summer 1 Patch 6 25 Hectares Carton of 18 kg 6 000 000 Cartons 960 000 Cartons Hectare 17 280 Tonnes Hectare 620 37 per Tonne 0 62 per Kilogram 11 17 per Carton WArea Unit 67 000 00 3 000 00 2 156 00 1 850 00 1 564 00 10 000 00 33 000 00 1 500 00 1 500 00 6 000 00 3 500 00 64 070 00 2 930 00 SS At Hectare 10 720 00 420 00 344 96 296 00 250 24 1 600 00 5 280 00 240 00 240 00 960 00 560 00 10 251 20 465 50 13 Weeks Sveet Com Summer 1 Patch 6 25 Hectares Carton of 18 kg 6 000 000 Cartons 960 000 Cartons Hectare 17 280 TonnesHectare 539 81 per Tonne 0 54 per Kilogram 9 72 per Carton WArea Unit 58 300 00 3 000 00 2 156 00 1 850 00 1 564 00 9 000 00 33 000 00 1 500 00 1 500 00 6 000 00 3 500 00 63 070 00 4 770 00 480 00 344 96 295 00 250 24 1 440 00 5 2
7. Summer Summer Your 4rea Unit 1 Patch 1 Patch 1 Patch 1 Patch 1 Bed 6 25 Hectares 6 25 Hectares 6 25 Hectares 6 25 Hectares 0 05 Hectares Your Harvest Unit Carton of 18 kg Carton of 18 kg Carton of 18 kg Tonne Bunch of 0 15 kg Yield 6 000 000 Cartons 6 000 000 Catons 6 000 000 Cartons 100 000 Tonnes 2 700 000 Bunches 960 000 CartonsHectare 960 000 CattonsHectare 960 000 CartonsHectare 16 000 TonnessHectare 54 000 000 Bunches Hectare 17 280 TonnesHegqare 17 280 TonnesHegqare 17 280 Tonnes Hectare 16 000 TonnesHecare 8 100 TonnesHecare Average Price 301 85 per Tonne 620 37 per Tomme 539 81 per Tonne 160 00 per Tonne 5 703 70 per Tonne 0 80 per Kilogram 0 62 per Kilogram 0 54 per Kilogram 0 16 per Kilogram 5 70 per Kilogram 14 43 per Carton 11 17 per Carton 9 72 per Carton 0 86 per Bunch Area Unit Aarea Unit iH ectare Area Unit Area Unit Area Unit Gross Income 56 600 00 67 000 00 10 720 00 58 300 00 16 000 00 2 310 00 Operating Costs Seeds amp Plarts 3 000 00 480 00 3 000 00 480 00 3 000 00 480 00 1 200 00 192 00 270 00 5 400 00 Fertiliser 2 156 00 344 96 2 156 00 344 96 2 156 00 344 96 1 500 00 240 00 40 00 800 00 Fuel 1 850 00 296 00 1 850 00 296 00 1 850 00 295 00 520 00 83 20 28 00 560 00 Chemicals 1 564 00 250 24 1 564 00 250 24 1 564 00 250 24 1 000 00 160 00 34 00 680 00 Water 9 000 00 1 440 00 10 000 00 1 600 00 9 000 00 1 440 00 7 500 00 4 200 00 150 00 3 000 00 Labour 33 000 00 5 280 00 33 000 00 5 280 00 33 00
8. The list includes crops that pay a IE Ce from the list vegetable R amp D levy Peponi ini J y Broad Beans culinary tresh W AUI Your crop is not listed You can Use the scroll bar to move ani i Api add to the list through the drop down list of Brussels Sprouts _ crops from A to Z to find your Bunching Onions not hard Burdock scl Butter Beans culinary fresh Butternut hectares Anticipated Yields and Prices for this Crop 4st grade or ist pick Gross Margin Comparison Tool for Vegetables Manual 2009 Page 16 Select a Harvest Unit Enter crop and income details ENTER CROP DETAILS Type words or numbers in the boxes or select values from the dropdown lists You can add a new harvest unit Your harvest unit is the unit that if yours does not appear on the you use when you talk about Scenario Name dropdown list lt a oo en Period from Planting to Final Harvest aan weeks You will he asked to type the unit eae E ye Harvest unit N E CEEE name as singular and plural e g y S ERRET bundle and bundles cartons or boxes or punnets Unt Area Unit Click on the down arrow to see ageing a dropdown list of harvest units Select whether you want your gross margins reported using Click on your harvest unit to your harvest unit or in kilograms select it from the list or tonnes Select an Area Unit ENTER CROP DETAILS Type words or numbers in the boxas or gelegt values tra
9. YegTool fullAccess2007 zip Transfer rate 73 0KB Sec C Close this dialog box when download completes Page 9 Extract files from the Zip file Right click the Zip file then select 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 Weglool Download Fle Ect Wew Favorbes Took Help t es t F Search gt Folders EEE bg Addai ic CWegTood Dowanoad Folders Maa ae Type Data i bi j Ue Desktop el 24 09 2009 3 00 PM LL My Documerts Bale D O AdobeSteckPhotes San with AVG ES My Musk CPeExtract to My PagaManagr Extract to folder Cien po My Pictures create Se hectare OB E Mad VeqToott E G Nerovision Onan Wih G Mew Folder D Updater Send To W My Computer cut a AD a4 Floppy A Coy a Local Cesk Cr 2 Documents and Settings Creste Shortout O MSOoCache Delete C Procted Renee o Program Files Properties C RECYOLER Gad ened Documents C Syste Volume Infonmation a Tero G TeerpEl4 C VegTool Downoad WINDA Click I Agree when the following screen appears Following the example above the files will be extracted into a new folder that has the same name as the Zip file which will be in the F P VAJ REZ ae
10. ad same folder as the Zip file Sy _THE ARCHIVE UTILITY FOR WINDOWS THANE YOU FOR TRYING WINZIP This i a fully Functional unregistered version for evaluation use only You can order the registered version online by phone or by mail Immediate online delivery is available from way winzip com understand that may use Winzip only for evaluation purposes subject to the terms of the Evaluation License and that any other use requires paument of the registration fee Dave Using Wire ip 36 Total Archives Opened r9 21 day evaluation period has expired Gross Margin Comparison Tool for Vegetables Manual 2009 Page 10 2 3 Installing VegTool from a CD or a folder on your hard drive Installing VegTool after extracting files downloaded from the AUSVEG website Installing from a CD You may need to log on as the Administrator before you can install software on your computer 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 Click on the folder containing the files that were extracted HB from the Zip file see above instructions and examples One of the files will be named Setup exe or there will be an icon with the word Setup under tt Once you double click Setup exe or the above icon you will launch
11. per Tonne Summer 1 Bed 0 05 Hectares Bunch of 0 15 kg 2 700 000 Bunches 4 000 000 BunchessHectare 8 100 TonnesHectare 5 703 70 per Tonne 0 16 per Kilogram 5 70 per Kilogram 0 86 per Bunch 0 80 per Kilogram 14 43 per Carton 0 62 per Kilogram 11 17 per Carton 0 54 per Kilogram 9 72 per Carton Area Unit 2 310 00 Hectare 46 200 00 Area Unit 58 300 00 Area Unit 86 600 00 Hectare 13 856 00 Area Unit 67 000 00 H ectare 10 720 00 VArea Unit Gross Income 16 000 00 Operating Costs Seeds amp Plarts 3 000 00 Fertiliser 2 156 00 Fuel 1 850 00 Chemicals 1 564 00 Water 9 000 00 Labour 33 000 00 Energy 4 500 00 Packagng 4 500 00 Freight 6 000 00 Other 4 000 00 270 00 40 00 23 00 34 00 150 00 500 00 14 00 540 00 250 00 250 00 480 00 344 96 296 00 250 24 1 600 00 5 280 00 240 00 240 00 960 00 560 00 480 00 344 96 296 00 250 24 1 440 00 480 00 344 96 296 00 250 24 1 440 00 5 280 00 240 00 240 00 960 00 640 00 3 000 00 2 156 00 1 850 00 1 564 00 10 000 00 33 000 00 1 500 00 1 500 00 6 000 00 3 500 00 3 000 00 2 156 00 1 850 00 1 564 00 9 000 00 33 000 00 1 500 00 1 500 00 6 000 00 3 500 00 1 200 00 1 500 00 520 00 1 000 00 7 500 00 5 280 00 2 000 00 240 00 150 00 240 00 0 00 960 00 800 00 560 00 4 000 00 5 400 00 800 00 560 00 680 00 3 000 00 10 000 00 280 00 10 800 00 5 000 00 5 000 00
12. this example Labour 2 Calculator provides a basic estimate of amns bond to estimate the Method 1 Use accounti g records or tax statements Profit amp Loss to estimate your labour costs the cost for th iS scena rio by scenario include j N A Total cost in Humber of hectares dividing the total la bour cost for METHOD 1 Use recent Profit amp annual accounts that shared this cost Loss tax statements or quarterly accounts and estimate the portion of labour costs that would be spent on growing a similar crop on the unit of area you have chosen your farm by the area in hectares and then making a further calculation to get the labour cost for the area you have chosen for this scenario i e the cost per your Area d Manager Annual Humber of hectares Proportion of Cost per your U n it that shared this cost manager s time Area Unit Total wages and contractor s charges shared by hectares Total cost per Hectare 0 00 per hectare based on average of historical costs Total cost per Area Unit 0 00 Use this value in your scenario Cancel Your Area Unit for this scenario is equivalent to 6 2500 hectares It takes 0 1600 of your Area Units to make up 1 hectare O Method 2 Calculate la our costs based on time and rates of pay in your chosen unit of area METHOD 2 Calculate costs based on the time that will need to be spent on each activity and current rates of pay it is optional whether you incl
13. 0 00 0 00 i Packaging 0 00 0 00 0 00 earning ees Freight Transport 0 00 0 00 0 00 Other operating costs 0 00 0 00 0 00 earning Total Operating Costs 3rd grade or 3rd pick Gross Margin per Harvest Unit per Area Unit per Hectare earning De Gross Margin 0 00 0 00 0 00 Weeks to grow amp harvest crop TBA eT I Required Please select a crdp from the dropdown list If your crop isn t in the list click Add a Crop Cp Watch this space for hints and explanations as you move to each white box to enter cost details That s the next step after you click CONTINUE Anticipated Yields per your Area Unit and Prices 1st grade or 1st pick 2nd grade or 2nd pick TIPS e If you choose to create a new scenario this page will not have any data start entering your crop details e If you selected an existing scenario to edit or review this page 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 and income details ENTER CROP DETAILS ype wards or numbers in the boxas or select walues fram the dropdown list Crop ea Crop Click on the down arrow to see a LB Adel a Crop dropdown list Sees Angled Lutta t Click on your crop to select it
14. 0 00 5 280 00 2 000 00 320 00 500 00 10 000 00 Energy 1 500 00 240 00 1 500 00 240 00 1 500 00 240 00 150 00 24 00 14 00 280 00 Packaging 1 500 00 240 00 1 500 00 240 00 1 500 00 240 00 0 00 0 00 540 00 10 800 00 Freight 6 000 00 960 00 6 000 00 960 00 6 000 00 960 00 600 00 423 00 250 00 5 000 00 Other 4 000 00 640 00 3 500 00 560 00 3 500 00 560 00 1 000 00 160 00 250 00 5 000 00 Total Costs 63 570 00 10 171 20 64 070 00 10 251 20 63 070 00 10 091 20 15 670 00 2 507 20 2 076 00 41 520 00 23 030 00 3 654 60 IMa M 2 930 00 468 50 4 770 00 763 20 330 00 52 80 234 00 4 680 00 16 Weeks 14 Weeks 14 Weeks 14 Weeks 10 Weeks Printed Monday 14 September 2009 02 21 PM Gross Margin Comparison Tool for Vegetables Manual 2009 Page 6 1 2 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 Veg Tool 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 Se Decide which crops are likely to generate the most profit Se See the effect on your Gross Margins of small changes in yields or prices or costs se Prepare more detailed forecasts for your Scenarios by using optional worksheets to calculate costs Examples of the types of questions you m
15. 4 8098 to get your Username and Password 2 1 Do I need Access 2007 Runtime One of the VegTool packages includes a free imited capability version of Microsoft Access 2007 called Access 2007 Runtime which can be downloaded or obtained on CD together with the VegTool program The file that is downloaded in this case is relatively large approximately 60 MB Access 2007 Runtime allows VegTool to run on any computer having Windows XP Service Pack 2 Windows Vista or Windows 7 as the operating system Choose this option if you do not have the full version of Microsoft Access 2007 already installed on your computer Click here for more Microsoft information about Access 2007 Runtime IMPORTANT You do not need to download the VegTool package with Access 2007 Runtime if you already have the full version of Microsoft Access 2007 installed on your computer 1 I don t know if I already have See the screen images on Page 27 of this Manual and follow the Access installed on my prompts to find out if you have Microsoft Access installed and if it is computer Access 2007 or Access 2003 or an even earlier version 2 have the full version of Download the VegTool program from the website without Access Access 2007 already installed 2007 Runtime on my computer If you are installing the VegTool program from a CD you will have the same two options Select the folder that has the VegTool program without Access 2007 Runtime 3 Id
16. 60 00 640 00 10 174 20 per Hectare 3 604 30 Next Click on the CONTINUE button to start adding cost information Gross Margin Comparison Tool for Vegetables Manual 2009 Page 18 3 4 Step 2 Enter Operating Costs This is how the blank page looks ready for you to enter your cost information Enter Operating Costs ENTER OPERATING COSTS Type numbers inthe boxes or fill out worksheets ta denwe crop costs FINANCIAL SUMMARY Crop and Scenario Description Crop Sweet Corn Season Summer Scenario Hame bris best prices no cost data Harvest Unit Carton tof 15 kg Area Unit Patch 6 2500 hectares Anticipated Yield and Weighted Average Price 6 000 00 Cartons fof 18 kgj per Area Unit 960 00 Cartons tof 16 kg per Hectare 17 28 Tonnes per Hectare Weighted Average Price 14 43 per Carton ot 18 kg Gross Income per Carton 167 Ares i per Hectare Type in estimated costs for Read same the Area Unt you selected OR guidlines or use a per Patch gt simple worksheet Seed amp Plants Fertiliser Fuel Gross Income 14 45 06 600 00 15 856 00 Operating Costs per Carton ner Area Unit per Hectare seed amp Plants 0 00 Fertilizer 0 00 0 00 0 00 Fuel 0 00 0 00 0 00 Chemicals 0 00 0 00 0 00 Water 0 00 0 00 0 00 Labour 0 00 0 00 0 00 Electricity gaz 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 67 4 000 00 640 00
17. 80 00 240 00 240 00 960 00 560 00 10 091 20 763 20 14 Weeks Printed Friday 18 September 2009 06 40 PM If 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 Gross Margin Comparison Tool for Vegetables Manual 2009 Sweet Com Summer 1 Patch 6 25 Hectares Tonne 100 000 16 000 16 000 160 00 0 16 Area Unit 16 000 00 4 200 00 4 500 00 520 00 4 000 00 7 500 00 2 000 00 150 00 0 00 800 00 4 000 00 15 670 00 330 00 Tonnes Tonnes Hectare TonnesHectare per Tonne per Kilogram 192 00 240 00 83 20 160 00 1 200 00 320 00 24 00 0 00 128 00 160 00 2 507 20 52 60 16 Weeks Page 23 WI SEW ST Senne Fp ATTACH HE oot to Singapore _ Beetroot Autumn ot to domestic market x Beetroot AUTUMN aporebunch lines Bok Choy Winte To PRINT your comparison select the Print button Which Printer If your computer links to more than one 9 Printer printer VegTool will presume to use your default printer If you wish to change printers VegTool will detect your printers and ask you to select one COMPARE SCENARIOS Choose up to five 3 scenarios to print or gsawlani Nome gnd ogia Select Printer Compare Report Ha Select Printer Scenarios pci HP LaserJet 3300 Series PCL amp t Report Ta Kyocera FS CSO1EN C Selert a ae e i sar
18. 960 00 Cartons fof 18 kg per Hectare 17 268 Tonnes per Hectare i4 435 per Carton Season The crop scenario name and your income and yield details will appear in the Summary Scenario Hame Harvest Unit Weighted Average Price Grozs Income per Carton 3 14 43 36 600 00 per Carton per Area Unit per Hectare 13 856 00 per Hectare Gross Income Operating Costs OR Type in a value Total Area hectares Anticipated Yields per your Area Unit and Prices 1st grade or 1st pick eee Cartons 2nd grade or 2nd pick 3200 ela eles 3rd grade or 3rd pick 1000 arom a Back earning 20 00 aT tal earning F1 3 00 fate ae Ta ta earning SRD per Carton Seed amp Plants Fertilizer Fuel Chemicals Water Labour Electricity gas etc Packaging Freight Transport Other operating costs Total Operating Costs Gross Margin Gross Margin Weeks ta grow amp harvest crop 16 41st grade or 1st pick number of Cartons per your Area Unit Optional Numbers must be typed into the Yield box and the Price box in at least one of the three rows so that Gross Income can be calculated 0 50 0 36 031 0 26 1 50 5 50 0 25 0 25 1 00 0 67 Fi0 60 per Carton 3 04 3 000 00 2 156 00 1 850 00 1 564 00 9 000 00 33 000 00 1 500 00 1 500 00 6 000 00 4 000 00 63 570 00 per Area Unit 23 030 00 480 00 344 96 296 00 250 24 1 440 00 5 280 00 240 00 240 00 9
19. Cartons fof 18 kg 108 000 00 kg entered 960 00 Cartons fot 15 kg per Hectare 17 26 Tonnes per Hectare Weighted Average Price FiI013 per Carton fof 18 kg the 4rea Unit yo ed per Patch gt Seed amp Plants Fertiliser Gross Income per Carton ger Area Unt per Hectare Fuel Gross Income 10 13 9 726 00 Operating Costs per Carton per Area Unit per Hectare Seed amp Plants Operating cost Fertilizer Fuel information will Chemicals Water appear in the Labour Electricity gas etc costs summary Fackaging as you enter cost Freight Transport Other operating costs deta ils Total Operating Costs Gross Margin per Carton per Area Unit per Hectare Gross Margin 10 13 60 800 00 9 725 00 Weeks to grow amp harvest crop 16 Seed amp Plant Costs is s iere Optional Please enter a number or click the butt to the right to open the Seed amp Plant Cost Calculator al ae Chemicals Water Labour Electricity gas etc Packaging Freight Transport BRR eee e Other operating costs Type the costs into the white boxes if you know them or click on these links to go to worksheets The worksheets make it easy to calculate or estimate the costs Select up to five Scenarios at a time to view and print for comparison Compare Scenarios Brisbane markets Brisbane Feb for Bushfoods Australia Inc Crop Sweet Com Sweet Com Sweet Com Sweet Com Warragal Greens Season december harvest Summer Summer
20. HAL to address nm Provide vegetable producers with a grower friendly tool for comparing gross margins view modify or delete or compile into groups as Reports istralia Ltd with support from the vegetable industry levy matched by Australian Government 2 A message box asking whether you trust the source of the program Security Notice D A potential security concern has been identified Warning It is not possible to determine that this content came from a trustworthy source You should leave this content disabled unless the content provides critical functionality and you trust its source File Path F base by AMS Database3tyagainextracted accdr This fle might contain unsafe content that could harm your computer Do you want to open this file or cancel the operation More information 3 The opening screen is not fitted to your computer screen come Cost amp Gross Margin per Area Unit 1e Cost Gross Margin 00 508 00 126 00 00 508 00 8 00 nn eccer mn mnn Gross Margin Comparison Tool for Vegetables Manual 2009 In which case this is what you do This has occurred because your computer has a high security setting and is disabling macros See page 30 for instructions on enabling macros Click Open This standard security warning may appear when you download Access 2007 Runtime Your computer has merely recognised that you are importing new software VegTool 1 0 and
21. Select Scenarios Income Cost amp Gross Margin per Area Unit Scenario Name Crop Season Income Cost Margin 1 Brisbane Feb z Sweet Corn Summet 67 000 00 64 070 00 2 930 00 2 Ri 2 Brisbane markets z Swe december har 86 600 00 43 570 00 23 030 00 4R 3 processing ha Sweet Corn Summer 16 006 00 15 670 06 330 00 eR Fj ar Ej aF IV Show Total Margin Selected Printer Change Printer 3 Preview Sprint iJ New Report Save Report X Delete Report How do I delete the new harvest unit or new season name or new crops that I added to VegTool Q I added Warrigal Greens to the _Enteretop andincome aetais crop list but misspelt itand want EAMEAAi ld niin ia to replace it with the correct i Crop Add a Crop spelling Doug Season hia BPC Turnip aainal ras Upland Cress ER Q I was showing dad how you Seer ste sbean anny can add harvest units but now vasal mmp re want to delete most of them Lisa eesin ra e lone VEGETABLES f 1 1 Oper A In this version of VegTool if you want to delete the new crops Fui Aaii aona Oea Naes Mardea Ara seasons and harvest units you Anticipated Yields per your Area Unit and Prices itr Pech 6 50000 363 570 23 300 added you first have to click the Delete All Scenarios button and click Yes when asked to confirm the deletion Note that this will also delete all the scenarios you have saved Then you are given the option to delete all of
22. Sweet Corn Tonne crop scenario PP Create a New Scenario 4Copy Scenario Compare Scenarios Click the button to select and Compare Preview or Print scenarios e Each time you re open the e program you will see all your saved scenarios listed here compare several from the list and delete unwanted scenarios To create a Scenario you first enter the crop details Modify Scenario CS Compare Scenarios Click on a scenario in the listto selectit Now you can duplicate or modify it or 63 070 00 4 770 00 Patch 67 000 00 64 070 00 2 930 00 Patch 86 600 00 63 570 00 23 030 00 Bed 2 310 00 2 076 00 234 00 Patch 16 000 00 15 670 00 330 00 Delete Scenario User Manual X Exit Application Delete All Scenarios Without selecting any scenarios you can go straight to the page that allows you to compare and print groups of scenarios Enter crop and income details ENTER CROP DETAILS Type words or numbers in the boxes or select values from the dropdown lists PP acid Crop pf Season ea weeks Report Unit Harvest Unit Kilogram Tonne Enter data into the white boxes Season e Use dropdown lists to select your area unit e g bed patch pivot acre etc and your type of crop Scenario Hame Period from Planting to Final Harvest Harvest Unit Area Unit Details appear in the summary on the right as you enter data on the left T
23. UIC L UUL HORTICULTURAL SERVICES Know how for Horticulture VegTool Gross Margin Comparison Tool for Vegetables MANUAL Version 1 0 Prepared by Alison MacGregor amp Lauren Thompson 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 http mildurait net Links with the VegBIZ Project Now that Version 1 0 of the VegTool program has been released responsibility for it has been transferred to the HAL funded VegBIZ project VGO08021 This project is being managed by Gerard Kelly of the NSW Department of Industry amp Invest
24. You might name the scenario draft or no costs to avoid confusion How do look at Gross Margins and costs per bunch rather than per hectare Select Modify for a saved scenario The Financial Summary will show the details of the scenario with three columns of costs and gross margins 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 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 2009 Page 25 How do use VegTool 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 prop
25. argin Comparison Tool for Vegetables RT ey RE HORTICULTURAL SERVICES Gross Margin Comparison Tool for Vegetables 4 tool for assessing the potential profitability of vegetable production IT IS THIS EASY Create Scenarios Click the CONTINUE button to enter the program Enter crop details Enter operating costs Crop details include crop type yield and income Type costs in if you know them or calculate them using simple worksheets Compare amp Print Scenarios Manage Scenarios Scenarios are all saved for you to review modify 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 Yeg ision 2020 Strategic Plan Provide vegetable producers with a grower friendly tool for comparing gross margins The project G08004 was funded by Horticulture Australia Ltd with support from the vegetable industry levy matched by Australian Government funds Disclaimer hile a great deal of care has been invested in the development of this tool Horticulture Australia Ltd or Scholefield Robinson Horticultural Services Pty Ltd cannot accept any responsibility for losses arising from the use 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 c
26. cess 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 4l Recent Documents 1 SAPROJECTS 2 SAPROJECTS 3 SAPROJECTS 4 SAPROJECTS 5 SAPROJECTS p BSAPROJECTS T SAPROJECTS amp SAPROJECTS 9 SAPROJECTS wegloolaccdb Aweg loalaccdb WegToolaccdb AWwegToolLaccdb WwegloolLaccdb Awegloolaccdb WegToolaccdb WwegloolLaccdb weglooLaccdb ie Publish Close Database Access Options ea Fal Popular e Help keep your documents safe and your computer secure and healthy Current Database Datasheet Protecting your privacy Microsoft cares about your privacy For more information about how Microsoft Office Access helps to protect your privacy please see the privacy statements Object Designers Proofing i Show the Microsoft Office Access privacy statement Microsoft Office Online privacy statement Customer Experience Improvement Program Advanced Customize Add ins Security amp more Learn more about protecting your privacy and security from Microsoft Office Online Microsoft Trustworthy Computing Resources Microsoft Trustworthy Computin Microsoft Office Access Trust Center The Trust Center contains security and privacy settings These settings help keep your computer secure Ye recommend that you do not change these settings OK Cancel A Gross Margin Co
27. curity Agent fan Trend Micro Worry Free Business Security x Microsoft Office Excel 2007 I Microsoft Office Outlook 2007 a Microsoft Office PowerPoint 2007 iE Microsoft Office Publisher 2007 w Microsoft Office Word 2007 l Server Management SE 2 eo Windows Catalog EA windows Update a es ae Sh fos IF Worry Free Remote Manager Agent Idon t know whether already have Pre x 4 Documents gt gt Settings gt Access loaded on my computer Search gt Ip and Support He E Runa Page 27 How do I change the printer that my comparison is printing to See instructions for changing printers in Section 3 6 How do I 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 area for something other than season when creating Scenarios Enter Operating Costs ENTER OPERATING COSTS l Examples of OTHER OPERATING COSTS that might pertain to Select packaging What amount per ples of OTHER OPERATING COSTS ght pe types from the Area Unit is required dropdown lists to pack this crop Other Read some Total cost in the Area Unit you selected OR guidlines or use a
28. de Operating Costs also known ss variable costs wher On site nusery Shared by hectares 5 0 00 hectare calculating a Gross Margin not include any Ov Total cost per hectare 0 00 per hectare bazed on average of historical costs toSt SDN Total cost per Area Unit e this value i i ainera sedi P 30 00 Use this value in your scenario Cancel Your Area Unit for this Scenario is equivalent to 0 35000 Hectares The labour involved in sowing it takes 3 3333 of your Area Units to make up 1 Hectare Method 2 Calculate costs per hectare based on current prices and recommended practices cost of growing them including Density per hectare hel Cost of seed per kg applied at kg per hectare 0 00 appar 35 a cost in this i Cost of purchased seedlings per thousand applied at plants per hectare 0 00 worksheet Cost of seediing grown E perthousand applied at plants per hectare 50 00 yi Click here to return to the Enter Operating Costs Total cost per hectare 0 00 page without using this S worksheet Total cost per Area Unit 0 00 Use this value in your scenario _ Cancel The Yield per your Area Unit iz 25 000 00 kg The Yield per Hectare is 63 533 35 kg 63 35 Tonnes How do Il keep my crop details if 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
29. duction including a Quick Guide to USING VEQTOO cccccceeeeneeeeneeeeeeeeeeeeeneeeeeeeeeneeenneeees 4 1 1 The quick guide to USING VEQTOOL ccccssesccccceseeeecccseuecececeuueeeeeseaeceeseueueeeesseaseeeseauaeeesessaeeeeeessaeeeeeeaas 5 1 2 VegTool can help your vegetable business cccccsssseccccceeeeceecceeeeeeecseeeeceeeseeeeeesseaeeeessaaeeeeessaeeseeeeaas T 1 3 VegTool is the ideal farm budget tool for the vegetable industry cccsececeseseeeeeeeeeeceeeeeeseeeeeesaeeeesaaeees ri 2 Obtaining amp installing VegTool and getting Started cccceeeeeeeeeeeseeeeeeeeeeneeseeeeeeeeeeneesneeeeeeenenes 8 2 1 Do I need Access 2007 RUNTIME cc ccccceeccceceeeceeeeeceeceeeceeceeeceeseseeeseceeseueceeseaeceseueeeeseueeeeseaeeeessaeeeesaaes 8 2 2 Downloading VegTool from the AUSVEG WeDSItE ceececcccceccceeeeeeeeeeseeeeeeeeeeeeeseeeeseeeeeeeesseaaeeeeeessaeeees 9 2 3 Installing VegTool from a CD or a folder On your Nard drive ccccccseseecceceeeeeeeeceeeeeeeeeeeeeeeeeesaaeeeeeesaaees 11 2 4 The first time you OPEN VEGTOOL cccccccsseccceeececceeseecseececsueeeeceueeecseueeecsaueeessaseeeseuseessaueeessaseeeesseneeesss 13 3 Detailed g id t using VegTOol sssi a A A a 15 3 1 The welcome page looks like this cccccccsseccceececeeeeeaeeeeeeeeeceececeueessueeeaaeeesaeceseeessaeessueeesaeeesaueeeeseeeesaes 15 3 2 Create anew crop scenario and
30. ed report Select argin per Area Unit po TEE Eli ost Margin rere 4 jeer 0 00 S187 50 H Remove hiy Report 2 Beetroc 6 00 126 00 Remove SEIGOPOTE CONS 5 peste 2 00 92 00 Remove 4 Beetroc 2 Continue 6 00 f3 00 4 Remove 5 Singaodre maT ime Poon Cry MEI Fonu poo 90 11 50 sa Remove Show Total Margin Selected Printer a Change Printer Preview Print Eg Mew Report save Report PH Delete Report Close 3 Keep VegTool organised p Keep your scenarios organised CIOICL U UT i iture HORTICULTURAL SERVICES 1 DELETE any redundant scenarios GROSS MARGIN COMPARISON TOOL FOR VEGETABLES Manage your scenarios create modify or delete 2 COPY scenarios then Scenario Name amp Crop Details income Cost amp Gross Margin per Area Unit Scenario Season Crop Harvest Unt Area Unit Income Cost Gross Margin MO DIFY th e CoO py SO Beetroot earlier seasoi Summer Beetroot Bunch Bed 634 00 508 00 126 00 yo u can eas i ly com pa re Beetroot to domestic m Autumn Beetroot Bunch Bed 500 00 508 00 8 00 Beetroot to Singapore Autumn Beetroot Bunch Bed 600 00 568 00 32 00 S lig htly different Cosmetic industry lines Autumn Angled Luffa Bucket Bed 667 50 480 00 187 50 A Singapore bunch lines Winter Bok Choy Bunch 1550 00 667 90 117 90 scenarios 3 Group similar scenarios into reports using the REPORTS capability under COMPARE Create a New Scenario P Modi
31. eeuu this comparison 5 Report Hame M Flere Remove Show Total Margin Selected Printer Change Printer Wi Close Scenario Mame Crop Season Income 1 Bris Dec best prices Sweet Corm Summer pee 600 00 2 Bris Early Dec worse prices Sweet Corn Spring 60 800 00 Select up to five scenarios in one Report so you can quickly recall the same five later on 3 AOO Bede behind house ble yVarragong Summer bris best prices no cos Sweet Cort Summer 666800 A drop down list of all your saved scenarios allows Brisbane feb market Sweet Corn Summer 2930 you to select the ones you want to appear in the Brisbane march mark Sweet Cory SUMIMEF 4770 com arison RWOrst CASE processi Sweg Summer 330 p i Preview Print 19 New Report pl Save Report PS Delete Repi Gross Margin Comparison Tool for Vegetables Manual 2009 Page 22 Compare Scenarios COMPARE SCENARIOS Choose up to five 5 scenanos to pont or preview Name and save your report for later use Compare Report Hame Scenarios Tor l Report Title Report Sub title Opiarg C Select Compare Scenarios auick Preview saved report Select Scenarios Income Cost amp Gross Margin per Area Unit Income Cost Margin F60 800 00 F63 570 00 2 7 70 00 Report Name Season Spring scenario Mame Bris Early Dec worse prices Crop Sweet Corn i Swegt Corn Remove
32. erly 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 I 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 potential annual profit by seeing the total gross margin across all three areas Bob Q I grow four crops one after the other in my glasshouse want to see a total gross margin for the year for my glasshouse by adding all four crops together Fran A VegTool can calculate a total gross margin for up to five scenarios Y ou will have to select an Area Unit that allows you to put in the total area being used for each crop e g glasshouse patch or other Note If you are comparing scenarios on a per Area Unit or per Hectare basis a total is meaningless Click this box near the bottom right corner of the Compare Scenarios page narios RE SCENARIOS scenarios to print or preview Name and save your Report Name S Report Title Report Sub title Optia Compare Scenarios Quick Preview sort
33. fy Scenario C Compare Scenarios J Delete Scenario X Exit Application S C E NA R lo S Copy Scenario XPDelete All Scenarios Compare Scenarios Click the button to select and Compare Preview or Print scenarios Release Candidate 1 54 Gross Margin Comparison Tool for Vegetables Manual 2009 Page 24 4 HOW DO I YOUR QUESTIONS amp THE ANSWERS How do l work out my costs per hectare Q I know our input costs per glasshouse but some worksheets ask for costs or inputs per hectare Donna A VegTool will tell you how many of your area units e g glasshouses it takes to make up one hectare Multiply the cost per glasshouse by this value to work out the cost per hectare or plants per hectare in this worksheet k Seed amp Plant Cost Calculator Guidelines lf you grow your own seedlings Method 1 Use accounting records or tax statements Profit amp Loss to estimate your seed and plant We rerommenri thal you costs Gevelop a separate budget for F 7 j the nursery i then Sete the Total cost in annual Number of hectares Calculated cost nursery cost in total if you use accounts that shared this cost per hectare Method 7 or per thousand a n ae Seed costa shared by hectares 50 00 hectare plants UE YOU ISS Wethod a into this worksheet to determine AEE Plant costs shared by hectares S 0 00 hectare Note It is important to onhy Contracted nursery costs shared by hectares 0 00 hectare inclu
34. gin Beds behind house blc Summer Warragul Greens Bunch Bed 2 190 00 2 076 00 114 00 bris best prices no cos Summer Sweet Corn Carton Bris Dec best prices Summer Sweet Corn Carton Patch 36 600 00 63 570 00 23 030 00 Bris Early Dec worse Spring Sweet Corn Carton Patch 60 800 00 63 570 00 2 770 00 Brisbane feb market Summer Sweet Corn Carton Patch 67 000 00 64 070 00 2 930 00 Brisbane march mark Summer Sweet Corn Carton Patch 58 300 00 63 070 00 4 770 00 worst case processi Summer Sweet Corn Tonne Patch 16 000 00 15 670 00 330 00 aP Create a New Scenario JP Modify Scenariq A compare Scenarios N X Delete Scenario iUser Manual On the Ma nage yo ur 4Copy Scenario Delete All Scenarios gt lt Exit Application scenarios pa g Se le ct Compare Scenarios The next screen has several options including preparing previewing printing amp saving comparisons Name your comrae senarios comparison PONAS i Choose up to tive fi scenanos t3 pim ar preview Name and sawe your report tor later use of up to five scenarios Compare Scenarios OR ief Report mie Report Sub tile Ophond acts Compare Scenaiios Quck Previa Return to a red raport previous Repert Nane Sclect Secnarios Income Cost Gross Margin pet Area Unit Scenario Mane Season Incone Cost Magir comparison 7 y Ca Add or remove saved as a A scenarios from a z 1 2 report
35. hecked by a professional financial analyst such as your accountant or farm business consuttant 3 2 Create a new crop scenario and manage your existing scenarios C Manage your scenarios create modify or delete Veg Tool LeU OUT HORTICULTURAL SERVICES GROSS MARGIN COMPARISON TOOL FOR VEGETABLES Manage your scenarios create modify or delete Scenario Name amp Crop Details t Income Cost amp Gross Margin per Area Unit Scenario Season Crop Harvest Unt Area Unit Income Cost Gross Margin Beds behind house blc Summer Warragul Greens Bunch Bed 2 190 00 2 076 00 114 00 Bris Dec best prices Summer Sweet Corn Carton Patch 96 600 00 63 570 00 23 030 00 Bris Early Dec worse p Spring Sweet Corn Carton Patch 60 300 00 63 570 00 2 770 00 Brisbane feb market Summer Sweet Corn Carton Patch 67 000 00 64 070 00 2 930 00 Brisbane march mark Summer Sweet Corn Carton Patch 58 300 00 63 070 00 4 770 00 Click here worst case processi Summer Sweet Corn Tonne Patch 16 000 00 15 670 00 330 00 to create a new crop scenaro A iodity scenario C Compare Scenarios XX Delete Scenario iUser Manual Ss 3Copy Scenario Delete All Scenarios gt Exit Application Create Scenario Click the button to create a new scenario O i H AT H H P H e Each time you re open the s Click on a scenario in the list to e Without selecting any scenarios you program you will see all your saved scenarios listed
36. here select it Now you can duplicate or modify it or compare several from the list and delete unwanted scenarios can go straight to the page that allows you to compare and print groups of scenarios Gross Margin Comparison Tool for Vegetables Manual 2009 Page 15 3 3 Step 1 Enter Crop Details This is what the page for entering crop details looks like Enter crop and income details eee ENTER CROP DETAILS FINANCIAL SUMMARY Typ ype words or numbers in the boxes or select walues from the dropdown lists Crop and Scenario Description The financial summary will fill up with data as you enter your crop details e a I Crop PB cid a Crop Se acta seacon Period from Planting to Final Harvest ma weeks Harvest Unit E E Season Scenario Hame Harvest Unit Area Unit 0 0000 hectares Anticipated Yield and Weighted Average Price Yield 0 00 per Area Unit per Hectare Report Unit l l A Te Harvest Unit Weighted Average Price 0 00 per rea Un tc CU Kilogram Gross Income per Harvest Unit per Area Unit per Hectare l Tonne Gross Income 0 00 0 00 0 00 O pe ra ting cost info rmatio n Operating Costs per Harvest Unit per Area Unit per Hectare will appear when you begin Seed amp Plants Fertiliser 0 00 0 00 0 00 Fuel 0 00 0 00 0 00 Total Area hectares Chemicals 0 00 0 00 0 00 Wiater 0 00 0 00 0 00 Labour 0 00 0 00 0 00 Electricity gas etc 0 00
37. ight ask when using the tool 2 Will still have a positive Gross Margin if the price of temporary allocation water goes r 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 3 VegTool is the ideal farm budget tool for the vegetable industry Veg Tool is very simple to use but gives you excellent information for making decisions You can e 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 e Crates per patch Bins per section of pivot Compare Scenarios s Print groups of Scenarios e Prepare a quick snapshot analysis e Prepare a comprehensive analysis if you want detail e Manipulate inputs easily and instantly see the impact this has on your Gross Margin Gross Margin Comparison Tool for Vegetables Manual 2009 Page 7 2 OBTAINING amp INSTALLING VEGTOOL AND GETTING STARTED Veg Tool 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 To download the VegTool program you must log in to the Grower Portal Contact AUSVEG phone 03 954
38. is warning you that it is new software Click the circled maximize button to maximise the screen This may make tt fit perfectly 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 properly when you click on the maximise button Page 13 4 The image disappears below the task bar on the bottom of the screen ords or tax statements Profit amp Loss to estimate your fuel costs Total cost in accounts covering duration of crop a m Ceuta e that should rerheads ared this cost hectares hectare 0 00 per hectare based on average of historical costs pep eroeoo oe l If you have a small computer screen you may need a to use a vertical scroll bar on the right hand side of the program to move up and down the page in the of fuel based on price per litre hours of machinery use in this crop and for each activity prog ram a se ae ee Click and drag the scroll bar up and down and to reveal the top or bottom of the page of machinery use in Litres per Fuel Type Calculated Cost of chosen Area Unit Hour each Activity nous sooo ws x sooo trs x sooo trs x sooo tows x sooo hours x w 50 00 Manag ta Documenti Micro G fy E lt me PE 16 44 Gross Margin Comparison Tool for Vegetables Manual 2009 Page 14 3 DETAILED GUIDE TO USING VEGTOOL 3 1 The welcome page looks like this Gross M
39. m the dropdown list Your area unit is the name you Scenario Hame give the area you grow your crop Period from Planting to Final Harvest B iweeks on Harvest Unit Bunch weight so R Uni Click on the down arrow to see a pales MEE a L dropdown list of area units AreaUnit___Dec O oan Calculate the si RECM a Tonne If your area unit does not appear Click on your area unit to select Vict I eee on the list please select Other or it from the list Greenhouse Span Patch OR Type in a vee hectares Anticipated Yii ae Sedan rop E e a A 2adehouse ena coadehouse Portion B per Bunch 2nd grade or ne sR Gother BB per Bunch ard grade or 3h a Bunches earning fF per Bunch Choose your Area Unit no Eaz Required Please select an area unit from the dropoc How big is your crop area Harvest If you selected an area unit other Area Unit Kilogram ald ae ies a Calculate the size of your Area Unit Tonne need to define the length an S l Width 175R 1247 In this example the beds are width of the crop area This viat BEEE 124 175m wide i 124m long allows you to compare your yields and gross margins per OR Type in a value hectare eee 0 0217 Wiesel Gross Margin Comparison Tool for Vegetables Manual 2009 Page 17 Nominate the yields and prices Enter a yield and the price you Anticipated Yields per your Area Unit and Prices Water pae Fry expect 1st grade or 1st pick Electricity gas etc
40. manage your existing Scenarios ccccccceeseeeeeeeceeeeeeeeeseeeeeeesaaeeeees 15 33 Slepi a a 96 08 Bc 2 cee See ee ee ere eee 16 3 4 Step 2 Enter Operating Cost cccccccccccccessscceeceesecceeceeseceeeceeseceeeeeeeeceeeeeeneceeeseegeceseeaeaeceseseeagaeeeeesaenes 19 3 5 Using worksheets to Calculate your COSHS ccccccceeeceeceeececeeeceeceeceseeeeeeeaeeeeeseueeeesesecessueeeseeeessaseneeeeas 20 3 6 Comparing ANd printing scenarios cccccccssseccccceeeeceecceeeeceeecseuseeeecseueceeeesuaeeeessueaeceeessaaeeeeessaaeeseeseaaagss 22 Sf Keep VEC TOG organised aecccadcrcnatacenecascnntucaptdsiebieede wiedetiaGectieadecmanastbsebsetsendestedebeleecineieesedebioeest comitctemeecdestode 24 4 Howdol Your questions amp the answers scccceesssessseeeseeeeneeeeeeesseeeeeeeesseeeseeeesseeeseoeesseees 25 5 Security settings ON your COMPUTED cccccceesseesseeeeeeceeeneeeeeeeeeeeeesneeeeeeseeoonssseeeeeseooeasseeeesessaoones 30 5 1 To enable macros IN ACCESS 2007 2 0 ccccceeccccceecceceeeceeceeececceeececeueeeceeeceeseaeceesuecesssueeeeseuecessuseeessaeeeeessaees 30 VegTool Gross Margin Comparison Tool for Vegetables User Manual 2009 Page lil 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
41. me 550 00 25 345 62 Operating Costs per Bunch per Area Unit per Hectare Seed amp Plants oO 1 612 90 Fertilizer ki Fuel Chemicals Water Labour Electricity gas etc Packaging Freight Tranzport Other operating casts Total Operating Casts Sue 15 00 water 150 00 Clicking on the Labour little blue arrow i Electri ity 3 et 12 00 will take you to a ectricity gas ote METERS worksheet for aema 40 00 calculating costs Freight Transport 42 00 Other operating costs 5 00 0 HERR eRe per Bunch Back Labour Costs iis oe Ee Sptional Please enter a number or click the button to the right to open the Labour Costs Calculator As data is entered the costs appear in the financial summary Gross Margin Comparison Tool for Vegetables Manual 2009 Page 19 3 5 Using worksheets to calculate your costs VegTool contains TEN worksheets one for each category of operating costs Each worksheet offers TWO METHODS to derive your cost per Area Unit e Method 1 Use recent Profit and Loss tax statements or accounts s Method 2 Calculate your costs based on the individual costs that make up the total cost for the category Note In some worksheets Method 2 asks for costs on a per Hectare basis In others you enter costs per your Area Unit Simple Guidelines on each worksheet will tell you about each method Labour Cost Calculats Guidelines Method 1 in
42. ment formerly NSW DPI It is expected that most vegetable industry members i e levy paying growers and service providers who have been given login codes for the Grower Portal on the AUSVEG website www ausveg com au will download the program via the Internet Contact AUSVEG phone 03 9544 8098 to establish or if you have forgotten your Username and Password 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 Industry amp Investment Vegetable Industry Centre Dareton Office Phone 03 5019 8406 E mail gerard kelly industry nsw gov 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 cannot accept any responsibility for losses arising from the use of it or the information it contains 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 2009 Page ii Contents 1 Intro
43. mparison Tool for Vegetables Manual 2009 In the box that appears click on Trust Centre Then click on Trust Centre Settings Page 30 a 2 T x1 In the Trust Centre Tist Cente Z click on Macro Trusted Publishers ad Satine Settings to see your Fogespacros in documents notin a trusted location level of security for Disable all macros without notificatian macros Disable all macros with notification Trusted Locations asennnes eneeesennsesemesssnnnssnnsss suneesesnsenemessunnsassunes sunstoentesssemedtsnsssserismssenessnnssuns suasenassnense s i Message Da Enable all macros not recommended potentially dangerous code can run gt elect Disable all nN macros except rivacy Options au n digitally signed macros 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 geta security warning You will need to re enable the o macros before you a o Cancel A Saran can Start Gross Margin Comparison Tool for Vegetables Manual 2009 Page 31
44. ngapore Autumn Beetroot Bunch Bed 600 00 9565 00 52 00 Cosmetic industry lines Autumn Angled Lutta Bucket Bed 667 50 450 00 187 50 Singapore b r z 550 00 oo 117 90 550 given the option of whether or not you Wa nt to delete sbi Create a New Scenario J Modity Scenario icompare Scenarios 3 Dete Scenario XC Exit Application the crops seasons and harvest units you ve added _ 362py Soenario_ berete Al Scenarios Simply click No to retain them Compare Scenarios Click the button to select and Compare Preview or Print scenarios Release Candidate 1 54 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 VegToolHome 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 0 if you opted for the Typical installa
45. o not have Access 2007 Download the VegTool program from the website with Access 2007 installed on my computer Runtime If you download VegTool from the website Access 2007 Runtime may take time to download because it is a large file Once it is installed on your computer there is no further downloading and Veg Tool will be installed quickly If you are installing the VegTool program from a CD select the folder that has the VegTool program packaged with Access 2007 Runtime 4 have Access 2003 or an If you already use Access 2003 or an older version of Access to earlier version of Access run existing databases then your computer may now try to use installed on my computer Access 2007 Runtime to open your old database files They may not open properly This is simple to manage When you need to open an old Access file simply re establish the link between your old file and Access 2003 Right click on your file in Windows Explorer and select Open with from the dropdown list A list of programs will appear Select Access 2003 to open your file Gross Margin Comparison Tool for Vegetables Manual 2009 Page 8 2 2 Downloading VegTool from the AUSVEG website Choose which Zip file to download from the AUSVEG website Select VegTool for Access2007 zip if you already have the full version of Access 2007 on your computer Select VegTool withAccess2007Runtime zip if you do not have the full version of Access 2007 Thi
46. o y Cancel m Your Area Unit for this scenario is equivalent to 6 2500 hectares t takes 0 1600 of your Area Units to make up 1 hectare Example using Method 2 Method 2 provides a more accurate estimate for this specific crop Employees Paid Hourly How many hours will be spent on the crop in your This example uses piece rates for harvesting bunches and for thinning and also allocates a high proportion of the q chosen Area Unit 21 00 per hour aor hour manager s time ITs Labour costs are T higher than those S k calculated using a Method 1 Basis of Activity Description e g per row or per bucket Choose an activity from the ist or type in your man Payment Unit Harvesting f 0 30 per Bunch Weeding E 50 00 per Bed 100 00 per Bed The Yield per your Area Unit is 6 000 00 Cartons of 18 kg 106 00 Tonnes The Yield per Hectare is 960 00 Cartons of 18 kg 17 28 Tonnes Click on Use this value in your scenario to have this cost appear in your cost page Page 21 Gross Margin Comparison Tool for Vegetables Manual 2009 3 6 Comparing and printing scenarios C Manage your scenarios create modify or delete Veg Tool UIC OUT HORTICULTURAL SERVICES GROSS MARGIN COMPARISON TOOL FOR VEGETABLES Manage your scenarios create modify or delete Scenario Name amp Crop Details Income Cost amp Gross Margin per Area Unit Scenario Season Crop Harvest Unit Area Unit Income Cost Gross Mar
47. 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 Information 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 An example of Gross Margin comparisons created using VegTool Compare Scenarios Scenario Hame Brisbane markets Brisbane Feb for Bushfoods Australia Inc Crop Syveet Com Sveet Com Sweet Com Sweet Com VVarragal Greens Season Your Area Unit Your Harvest Unit Yield Average Price december harvest 1 Patch 6 25 Hectares Carton of 18 kg 6 000 000 Cartons 960 000 CartonsyHectare 17 280 TonnessHectare 801 85 per Tonne Summer 1 Patch 6 25 Hectares Carton of 18 kg 6 000 000 Catons 960 000 Catons Hectare 17 280 TonnessHectare 620 37 per Torne Summer 1 Patch 6 25 Hectares Carton of 18 kg 6 000 000 Cartons 960 000 Cartons Hectare 17 280 TonnessHectare 539 81 per Tonne Summer 1 Patch 6 25 Hectares Tonne 100 000 Tonnes 16 000 Tonnes Hectare 16 000 TonnessHectare 160 00
48. otal Area teen hectares Anticipated Yields per your Area Unit and Prices Watch the comments here They offer hints or explanations as you move to each white box 1st grade or 1st pick earning 2nd grade or 2nd pick earning a d grade or 3rd pick carina M Gross Margin Comparison Tool for Vegetables Manual 2009 FINANCIAL SUMMARY Crop and Scenario Description Crop Season Scenario Name Harvest Unit Area Unit Anticipated Yield and Weighted Average Price Yield 0 00 0 00 per Hectare 0 00 Kilograms per Hectare 0 00 per per Harvest Unit 0 00 per Harvest Unit Weighted Average Price Gross Income per Area Unit 0 00 per Area Unit per Hectare 0 00 per Hectare Gross Income Operating Costs Seed amp Plants Fertiliser Fuel Chemicals Wiater Labour Electricity gas etc Packaging Freight Transport Other operating costs Total Operating Costs Page 5 To complete a Scenario type in the costs Links can take you to worksheets that make it easy to estimate your costs Enter Operating Costs ENTER OPERATING COSTS Type numbers in the boxes or fill out worksheets to deriwe crop casts FINANCIAL SUMMARY Crop and Scenario Description Details appear In Crop Sweet Com the fina ncial Season december harvest summa ry based Scenario Harbe Brisbane spring 2 Harvest Unit Carton of 18 kg on the crop Area Unit Patch 6 25 Hectares Anticipated Yield information you 6 000 00
49. re the program is installed It 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 0 will appear as an icon on your desktop Open the tool by double clicking this icon ie Vee lool 1 0 Setup 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 val be installed Recommended for advanced users VegTool 1 0 is Start IMPORTANT NOTE If you already have Access 2007 see page 30 for instructions on enabling macros and security settings Gross Margin Comparison Tool for Vegetables Manual 2009 Page 12 2 4 The first time you open VegTool Every computer has different security and screen settings When you first open VegTool what you see on the screen may vary slightly depending on your computer settings You may see one of the following 1 The CONTINUE button doesn t work ool for Vegetables ible production 3p details include crop type yield and income 3 costs in if you know them or calculate them using simple worksheets ultural Services as part of a project commissioned by Horticulture Australia Ltd
50. rop or area unit You might know that labour on the whole property costs 35 000 per year and that this is shared across 10 hectares of vegetable farm The worksheet will use this to calculate a labour cost for the Area Unit 153 30 per bed in this scenario Labour Cost Calculator Guidelines Simple ways to estimate the cost of labour in a crop seanaria imelude METHOD 1 Use recent Profit amp Loss tax statements or quarterly accounts and estimate the portion of labour gosts that would be spent on growing a similar crop on the unit of area you have chosen BP a Mela le n ami When you click Use this value in your scenario it appears in your cost summary page 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 worksheet Note If you plant two crops per year for example ona 5 hectare vegetable farm then you have really shared the costs across 10 hectares Labour Cost Calculator Method 1 Use accounting records or tax statements Profit amp Loss to estimate your labour costs Total cost in ano pease Humber of hectares that shared this cost Total wages and contractor s charges 35 000 00 shared by 10 00 hectares Total cost per Hectare 3 500 00 per hectare bas erage of historical costs ee Total cost per Area Unit 21 875 00 Q 3 Use this value in your scenari
51. s will install R2 hesg VegTool with Access 2007 Runtime 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 VegT ool Download which involves l Click this button to create a New Folder Type in VegTool Download where it says New Folder Click on the VegToo l Download folder to open it Click Save to save the downloaded Zip file into this folder Gross Margin Comparison Tool for Vegetables Manual 2009 File Download Do you want to open or cave this file Name VegTool Full4ccess2007 2ip Type Winzip File 2 40MB From wew srhs com au Ce TE Always ask before opening this type of file While files from the Intemet can be useful some files can potentially harm your computer IF you do not tust the source do mot open or save this file What s the nsk RECYCLER bal Scanned Documents System Volume Information Temp CO TempEl4 My Documents Fie name Veg ool fulccess2007 zip Save as type WinZip File L VegT ool Download D File name Veg ool fulAccess2007 zip MyNetwok Saveastype WinZip File 29 of Veglool fullAccess200 zip from egTool FullAccess2007 zip from www srhs com au Sse oiee pn g oa om mma o omolo oo oog Estimated time left 24 sec 701KB of 2 40MB copied Download to C WegT
52. the Setup Wizard shown below Insert the CD in your CD DVD drive Windows Explorer will open so you can view the two folders on the CD Click on the folder that matches your current software situation either VegTool for Access 2007 or VegTool with Access 2007 Runtime This will open the folder Then double click on the Setup exe file or the Setup icon 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 and then Log On again with your User name and password i VepTool 1 0 Setup Q Welcome to the VegTool 1 0 i CCN Setup Wizard leie Robinson The Setup Wizard will install YVegTool 1 0 on your computer Click Next to continue or Cancel bo exit the Setup Wizard VegToo Gross Margin Conparaon Too for Vegetables Hortiqutiure Australia Lid HAL Project No WGOBOD4 September 2009 ig VegTool 1 0 Setup Customer Information Please enter your customer information User Name Organization coat C_tet gt J Gross Margin Comparison Tool for Vegetables Manual 2009 Page 11 When two icons appear on the screen click Typical if you do not have a preference for whe
53. the other things you ve added so you have a clean Slate ist grade or ist pick Create a New Scenario Z Modify Scenario Cl Compare Scenarios XK Delete Scenario iUser Manual 4Copy Scenario Delete All Scenarios X Exit Application Main Menu Click on one of the above buttons to create more Scenarios work with or delete your existing Scenarios or Exit the program Gross Margin Comparison Tool for Vegetables Manual 2009 Page 26 How do 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 VegTool butil want it to keep the crops season names and harvest units added Can get rid of the scenarios but keep the things added Phil Scenario Name amp Crop Detalls i Season A In this version of VegTool you only get the option to delete the crops seasons and harvest units you ve added after you click the Delete All Scenarios button and say Yes when asked to confirm that you wish to delete them Then you are GROSS MARGIN COMPARISON TOOL FOR VEGETABLES Manage your scenarios create modify or delete Income Cost amp Gross Margin per Area Unit Crop Harvest Unit Area Unit Income Cost Gross Margin Beetroot earlier seasoi Summer Beetroot Bunch Bed 634 00 508 00 126 00 Beetroot to domestic m Autumn Beetroot Bunch Bed 500 00 505 00 8 00 Beetroot to Si
54. tion to another folder and opening the program from the second folder by double clicking VegT ool 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 at 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 do I know whether I already have Microsoft Access loaded on my computer Q How do Know what programs are loaded My daughter set the computer up for me just use it Danny A Follow the progression of menu bars shown to check what Microsoft programs are installed 1 Click on the Start button 2 Then select Programs 3 Then select Microsoft Office or Another category of Microsoft software 4 This will reveal a list of Microsoft programs If you can t see Microsoft Access listed then it is not loaded on the computer Gross Margin Comparison Tool for Vegetables Manual 2009 5 aa IF Accessories IF Administrative Tools GH Microsoft Office an Startup A Acrobat com 2 Adobe Reader 9 a Internet Explorer ka Outlook Express Remote Assistance CutePDF fan Google Earth fan Google Earth Plugin fam Trend Micro Client Server Se
55. ude or don t include a portion of the manager s salary in operating costs spent on operational work optional Shared by hectares 0 00 Method 2 allows you to work Manager s salary tends mot to be inched as an operating norges mgnaragoes Smvens PaldHowy n narea uta ne ToPin you areaunt OUt Costs in more detail based aoe Tractor spraying etc hours per hour 0 00 on th e cost of eac h S pe C ifi C Click here to return to the Weeding hours per hour 0 00 in put This Labour Cost SAS p ae Irrigation hours per hour 0 00 exam p le USES h ours pe r worksheet Harvest hours per hour 0 00 activity and labour rates per Shed forklift coolroom hours per hour 0 00 ho ur Other hours per hour 0 00 Ee a P ERE kan OF You can include activities that ivity D ipti e g bucket Pp nt Units n i eri a kana inyourchosen Aveeunt_ are charged at piece rates in he list or type in your g Payment Unit Area Unit Method 2 of the Labour Cost per 0 00 E a Calculator per 0 00 Total cost per hectare 0 00 Total cost per Area Unit 0 00 Use this value in your scenario Cancel The Yield per your Area Unit is 6 000 00 Cartons of 18 kg 108 00 Tonnes The Yield per Hectare is 960 00 Cartons of 18 kg 17 28 Tonnes Gross Margin Comparison Tool for Vegetables Manual 2009 Page 20 Example using Method 1 Method 1 is quick and easy to use but may not truly reflect the costs for this c
56. view of it on your screen that you wish to copy to the Word document then while holding down the Shift key press the key labelled PrtScn short for print screen then go back to the Word document and while holding down the Ctrl key press the V key This pastes the image you captured on your computer screen into the Word document Gross Margin Comparison Tool for Vegetables Manual 2009 Page 28 How do l open my old Access 2003 files now that have loaded the Access 2007 Runtime version B FarmWage 4b _ 00 2000 LEAD Microsoft Office A 12 KB Q We already use Access 2003 for 7h MyDb md Open trasoft Office A 136 KB our farm wages When open the BH staves ay bosott Excel W 73KB wages file it tries to open using Open With Access 2007 Runtime and the files Share don t open properly What do do now Tanya RESET E PIENA EJEISTOTE A When you open your old file you simply need to re establish the link Send To l between the wages file and Access Cut 2003 Follow these steps Copy Right click on your old file in Create Shortcut Windows Explorer Delete s Select Open with from the Rename dropdown list A list of programs will appear Properties e Select the appropriate version of Access to open your file Gross Margin Comparison Tool for Vegetables Manual 2009 Page 29 5 SECURITY SETTINGS ON YOUR COMPUTER 5 1 To enable macros in Ac
Download Pdf Manuals
Related Search