Main Page

Welcome to the FEAT Online Wiki

This "wiki" is your step by step guide and user help manual, helping you get the most out of the Farm Economics Analysis Tool (FEAT) Online. You can open the wiki by selecting 'User Guide' up the top of the tool or by clicking 'Help' on the bottom left side which will bring you to the specific wiki page for the FEAT Online page you are on. This is the main page of the wiki, to get to a specific page use the table of contents and then click on the hyperlink for a heading for more information on a specific page.

Tip: We recommend having the FEAT Online website opened in a separate window while following along step by step in the wiki.

What is FEAT Online?

The FEAT Online website is a planning and decision-making tool used to assist cane farming enterprises. FEAT Online enables users to evaluate the economic impact from changing farm management practices. Other uses for FEAT Online include evaluating farm labour requirements, preparing cash flow budgets and quantifying the impact of “what if” scenarios.

Common Menu Items

Common menu items include:

Main Navigation Bar which will always contain the same menu items.
Contextual Navigation Bar which will display links relevant to the current page.
Wizard Buttons at the bottom of the page will have a logical back and next button.
The five Action buttons are Edit, Copy, Share, Archive and Delete.

For more information go to Common Menu Items.

Home Page

This is the home page for the tool which explains the purpose of the tool, has many links to get started and hosts the tutorial videos.

For more information go to Home Page.

Scenario List

This page lists all the scenarios developed by the user (and the regional scenarios) and enables users to edit, copy, archive, share and delete scenarios or compare the performance of two different scenarios. Users can either add a new scenario, continue working on a previously created scenario or modify a regional scenario.

For more information go to Scenario List.

Scenario Home

This page shows a flow diagram illustrating the process involved when developing a FEAT scenario.

For more information go to Scenario Home.

Scenario Assumptions

This page is used to calculate the cost of harvesting, cane price and net revenue. Users add in information for mill area, other assumptions and levies.

For more information go to Scenario Assumptions.

Cane Assumptions

This page is for entering cane growing area, yield and CCS for each crop class. Other Crops information for area should also be entered in, if applicable.

For more information go to Cane Assumptions.

Cane Growing Costs

This page is used to calculate cane growing costs per hectare, including the costs of machinery operations, fertiliser, pesticides and irrigation.

For more information please go to Cane Growing Costs.

Machinery Setup

When entering Cane Growing Costs, add machinery costs by clicking on the ‘Add Machinery Operation’ button and entering tractor and implement details. If tractor and implement details have already been entered then users will be able to select the tractor and implement from the drop down box and then enter the number of operations (or passes) undertaken. If tractor and implement details have not been entered then users will need to click on the ‘+’ button located on the right. See headings for Tractor Costs and Implement Costs below for step-by-step details on how to enter information.

Tractor Costs

Add Tractor Costs by clicking the ‘Add Machinery Operation’ button and then clicking on the ‘+’ button to the right of ‘Machinery’ and then the ‘+’ button on the right of ‘Choose Tractor’. Then enter:

A name for the tractor (e.g. JD 180HP).
Tractor horsepower PTO (e.g. 150HP PTO).
Based on tractor horsepower PTO, FEAT will calculate expected fuel use in litres/hour. This is maximum fuel use when the tractor is performing at maximum load (users change this figure if required).
An estimate of the tractor’s expected productive life in years (e.g. 20 years).
The number of hours per year the tractor is used (e.g. 500 hours/year).
Estimate the total amount spent on repairs and maintenance over the tractor’s productive life (e.g. $30,000 over the life). R&M should include spending on servicing (e.g. oil and filters), tyre replacements and other minor and major repairs (e.g. electrics, hydraulics, GPS) over the life of the tractor.

For example, a tractor might require servicing every 250 hours at a cost of $250 per service totalling $10,000 over the life of the tractor (approx. 10,000 hours). Tyres might be replaced twice over its life (e.g. $1,250 x 4 tyres x 2 sets = $10,000) plus $10,000 of repairs (total R&M = $30,000).

Implement Costs

Implement information can be entered once the Tractor information has been added. Add implement costs by entering:

Choosing the associated tractor from the drop down list, or click the plus icon to add a tractor.
The name of the implement (e.g. Offset discs 28 plate).
An estimate of how hard the tractor is typically working when the implement is being used as a percentage of full load. For example, rotary hoeing heavy ground may require the full power of a 180HP tractor so 100% should be entered, while boom spraying may only require a 120HP tractor to operate at half power so 50% should be entered.
Enter the number of hectares per year the implement is operated across. Offset discs might be used across 25ha of fallow paddocks twice so 50ha should be entered, while a sprayer with tracking legs might be used once in 25ha of plant cane and twice in ratoons (4 ratoons, 25ha each) so 225ha should be entered.
The expected productive life of the implement in years (e.g. 15 years).
An estimate of the total amount spent on repairs and maintenance over the implement’s productive life. For example, a grower might replace the discs of their Offsets (28 plate) three times ($100/disc x 28 discs x 3 sets = $8,400) and spend $100 each year on general maintenance over the 15-year life ($1,500) totalling $9,900.
The width of the implement’s pass or swath width. A 3-row stool splitter might have a 5.4 metre width of pass, which could be entered as 5.4m or 3 rows (if row width has been entered as 1.8m on the ‘Scenario Assumptions’ page).
The speed the implement is typically operated at down the drill (e.g. 7 km/hr).
An estimate of the implement’s field efficiency. Field efficiency is a ratio of the time spent actually using an implement relative to the total time spent in the tractor.

For example, when ripping most time is spent ripping in the paddock (90secs/row) plus some time spent turning at the end of each row (22 sec/row). Field efficiency in this scenario is 80%, which is calculated by dividing 90 secs by 112 secs (90 secs+22secs). Chemical application is likely to have lower field efficiency than tilling due to additional time spent refilling tanks. Users can evaluate the accuracy of field efficiency by cross-checking with the implied work rate (ha/hour – shown on the ‘Machinery’ page after clicking the submit button).

Machinery Setup

The Machinery Setup page can be accessed via the navigation pane on the left side of the page. This page can be used to edit existing information for tractors and implements or to add additional information to calculate machinery costs. Most of the Machinery Setup page should already be filled out before users get to it if users entered their machinery operation details along the way in the Cane Growing Costs page.

Contract Rate Calculator

The ‘Contract Rate Calculator’ is an additional calculator located in the navigation pane on the left side of the page. It enables users to calculate a contractor rate by factoring in depreciation and interest expenses for their tractors and implements, contract labour and profit margin – in addition to the Fuel, Oil, Repairs and Maintenance costs transferred from the Machinery Setup page. A contractor rate for each tractor and implement combination can be calculated by entering:

The average ‘Interest Rate’ paid on loans for new machinery (e.g. 7%) to factor in an opportunity cost.
The ‘Contract Labour Rate’ (e.g. $35/hr).
A suitable ‘Profit Margin (e.g. 10%).
Click on the ‘Submit’ button.
Click on the edit button for each tractor and implement that users want a contract rate calculated for.
The price paid for the tractor or implement.
An estimate of the salvage value of the tractor or implement, which is an estimate of how much the tractor or implement could be sold for at the end of its expected productive life (e.g. 15 years).
Click on the submit button and a contracting rate ($/ha) will be shown in the table in the farthest right column. This is the Total FORM, interest, labour and depreciation + profit figure.

Cane Summary

This page is a summary of gross margin information based on information entered on the Cane Assumptions, Cane Growing Costs and Scenario Assumptions pages. No entry of information is required on this page.

Gross margins are calculated by subtracting variable costs from gross income. Comparing the cane gross margins of two different farming systems is a useful way to examine the profitability of adopting new management practices, which helps to inform farm management decisions. However, farm managers also need to account for any changes in fixed costs that might occur from the adoption of new practices as well as any required capital expenditures on new equipment. If so, a comparison of operating return would be a more precise indicator of relative profitability, which would require completion of the Depreciation, Assets and Fixed Costs pages.

Other Crop Assumptions

This page enables users to calculate net revenue from growing crops other than cane on fallow blocks. Users have the choice to enter information specific to legumes, peanuts and/or various other fallow crops. Net revenue can be calculated by clicking ‘Add Crop’ and then entering the required information, as shown below.

Enter the Crop Number / Sequence. This is useful for multiple crops. If more than one crop is grown on the same section of land within the one-year period (one after the other), use a different Crop Number / Sequence for each subsequent crop (e.g. 1,2,3). If more than one crop is grown on different sections of land at the same time, use the same Crop Number / Sequence (e.g. 1,1,1) but note that the sum of these areas must not exceed the total area. If only one crop is grown, use any Crop Number / Sequence (e.g. 1)
Choose Crop Type (Legume, Peanuts or Other Crops)
Enter the area planted with the other crop (e.g. 25 hectares). Important Note: The area cannot be greater than the allocated area. If the same Crop Number / Sequence has been entered multiple times then the combined area cannot be greater.
Enter Yield (Harvest weight) (t/ha or units/ha). This is the field weight prior to drying or grading. Units/ha can be used for crops where the standard measurement is not in tons/ha (e.g. cartons/ha). If units/ha is chosen, ensure this is used consistently throughout the scenario. If the crop is used for green manure then 0 should be entered. Do not leave any field blank.
Enter any costs that are associated with the crop prior to grading and drying in Harvest Weight Costs (Field Transport / Handling / Drying) ($/t or $/unit). This includes transport to the driers or pack-house, drying costs, etc.
Enter Yield (Paid weight) (t/ha or units/ha). This is the final weight on which payment is made, and is never higher than Harvest weight. If units/ha were used previously, maintain consistency.
Enter Paid weight costs (Transport / Handling / Drying) ($/t or $/unit) either directly or with assistance from the Calculate button. These are costs associated with the product that is paid for, including transport of the clean and dry product to market, inspection charges, etc. If the calculator is used to determine transport costs to multiple destinations, ensure the quantities in the Proportion (%) column add up to 100%. Click on Use Value to return to Add/Edit page.
Enter the Market Price ($/t or $/unit) either directly, or via the calculator. Maintain consistency with the units chosen in previous fields (e.g. tons, cartons, pieces, bins, kgs). The calculator can be used to help work out the average price when there are multiple grades paid at differing rates. Ensure the % of crop totals 100%. Click on Use Value to return to Add/Edit Crop page. If known, it is possible just to enter a number directly without using the calculator.
Enter the levies as a percentage of the market price, if applicable. For example, 2% of market price. If there are no levies, enter 0.

Once all Required fields are filled, click on Submit at the bottom of the pop-up.

To change any value, click on the blue edit button to bring up the Add/Edit Crop page again.

Other Crops Growing Costs

This page is used to calculate the variable costs per hectare from growing crops other than cane on fallow blocks. Once you have entered information for one growing cost page, click the next tab to navigate to the next crop entry if you have multiple crops.

Please see headings in the Cane Growing Costs section above for step-by-step details on how to enter information for Land Preparation, Planting, Fertiliser, Weed/Insect/Disease Control and Irrigation. Step-by-step details for entering information for Machinery Operations are available in the Machinery Setup section.

Desiccation costs can be also included in the weed control section. Please make sure you name it as “Desiccation costs” and/or add further details in the name. By placing desiccation in these sections please be aware that you may have machinery operations which are for the application of chemicals and machinery operations for desiccation.

Add harvesting costs by first clicking on the ‘Add Harvest Cost’ button and entering a name or description (e.g. soy harvest contractor A). Then select whether the harvesting is done by your Own Tractor or a Contractor. If Own Tractor then choose the tractor and implement combination and input the number of operations. If Contractor then input the cost ($/unit) and the Cost Rate Units (either $/ha or $/yield unit). Then input any additional labour (hr/ha) and the Additional Casual Labour Cost ($/hr). Note that any costs occurring after harvest, such as drying and grading costs, transport to silo and/or market, etc. are captured in Other Crop Assumptions depending on whether they apply to the Harvest weight (i.e. wet and dirty) or the Paid weight (i.e. clean and dry).

Other Crop Summary

This page is a summary of Gross Margin information (from growing crops other than cane on fallow blocks) based on information entered on the Other Crop Assumptions, Other Crop Growing Costs and Scenario Assumptions pages. No entry of information is required on this page.

Comparing the gross margins of different fallow crops is informative and helps users to make fallow crops choices that enhance whole-of-farm profitability. If growers are evaluating the profitability of growing fallow crops they have not grown before then they would need to consider any changes in fixed costs that might occur and/or any required capital expenditures on new equipment. If so, a comparison of operating return would be a more precise indicator of relative profitability, which would require completion of the Assets, Depreciation and Fixed Costs pages.

Depreciation

Users have two options on how to include Depreciation:

Option 1: Enter the depreciation rate (e.g. 10%) then enter the total value of all depreciating assets into the Assets page by (a) clicking ‘Add Asset’ and (b) selecting ‘Plant and Machinery’ then (c) entering a name and the total value of all depreciating assets (e.g. $350,000).

OR

Option 2: Complete the Depreciation Schedule with information about every tractor, implement and other types of depreciating assets (e.g. vehicles, pumps and equipment) by entering:

The name of the depreciating asset (e.g. John Deere 7830 Tractor);
Value at beginning of year (e.g. $100,000);
Number of years of use remaining (e.g. 10 years);
Residual salvage value (e.g. $30,000), which is an estimate of how much the depreciating asset could be sold for at the end of the ‘Number of years of use remaining’.

Users can only choose one of the above-mentioned options otherwise depreciation costs will be included twice – and therefore double counted.

Why include depreciation?

Depreciation is regarded as a fixed cost. Unlike other fixed costs there is no cash flow for depreciation. So why include it when calculating profit? At some point assets will wear out and need to be replaced. Including depreciation ensures that profit is sufficient to cover their eventual replacement.

Annual Depreciation (Depreciation Schedule)

Annual depreciation is calculated in FEAT according to the formula:

Annual depreciation = (Value at beginning of year – Residual salvage value)/(Number of years of use remaining)

Value at end of year = value at beginning of year – annual depreciation

The average of the opening value of all items (a) and the closing value (b) is transferred to the Assets page and displayed in the assets table.

Assets

This page is used to calculate total farm assets. Add assets by entering:

An estimated value of your land including the value of all fixed improvements (i.e. dams, buildings, etc.).
If you have entered machinery values (etc.) into the full Depreciation Schedule (using option 2), the value of plant and machinery will be shown here. If not, then please enter an estimated current value of all plant and machinery.
Enter the value of any livestock, if applicable.
Estimate the value of any inventory (i.e. fertiliser).
Enter additional assets as required.

Fixed Costs

This page is used to sum all of the fixed costs, including the cost of insurance, land rates, accounting fees, and building and vehicle repairs and maintenance, and more.

‘Fixed Yearly Labour’ should also be added here and users should check the amount of ‘Total Casual Labour’ costs below the table for guidance and to ensure no double counting (machinery or irrigation labour costs may have already been included). A step-by-step guide to entering Fixed Costs and Water costs is below.

Fixed Costs

Add each of the fixed costs by clicking on the ‘Add Fixed Cost’ button and:

Selecting the type of fixed cost you are adding (e.g. Insurance);
Entering the name of the fixed cost (e.g. Farm property insurance);
Entering the annual cost (e.g. $10,000/year).

Water Costs

Add water costs by entering:

Water costs if paid on a per hectare basis ($/hectare). For example, Burdekin Delta users would enter their water costs here but subtract the portion paid by the miller (e.g. $82/ha), while BRIA users would enter $0 and enter their water costs in the following entry cells;
The total water allocation for the farm if water is paid on a per megalitre basis (e.g. 800 megalitres = 8 ML X 100 hectares);
Part A and C water costs if water is paid on a per megalitre basis. For example, Burdekin BRIA (or BHWSS) users would enter their fixed part A and C water costs here (e.g. $3.5 + $39 = $42.5/ML), while Delta users would enter $0;
Part B and D water costs if water is paid on a per megalitre basis. For example, Burdekin BRIA (or BHWSS) users would enter their variable part B and D water costs here (e.g. $0.5 + $29.5 = $30/ML), while Delta users would enter $0.
Press the submit button and it will show the total of fixed water costs below.

Other Income

This page is used to enter additional income that users may receive. For example, farmers may obtain other income from undertaking contract work, hiring out equipment or leasing land. Add other income by clicking on the ‘Add Other Income’ button and:

Entering a name for the other income;
Entering a description of the other income (optional);
Entering the total annual income from this source.
Clicking on the ‘Submit’ button.

Profit

This page shows a breakdown of Area, Total Income, Total Variable Costs and Total Gross Margin for cane and any other crops entered into the scenario. Furthermore, Fixed Costs are subtracted and Other Income added to the Total Gross Margin in order to calculate the Farm Operating Return. The Return on Investment (%) is also calculated by dividing Total Assets (from Assets page) by the Operating Return.

Farm Operating Return

Farm operating return, calculated as gross income less total costs (excluding interest and tax), is a good measure of profitability to compare two farming systems with different fixed costs and capital expenditure.

i.e. comparing one farming system with irrigation to another farming system without irrigation).

Return on Investment

Return on Investment (ROI) measures how effectively farm assets are working to generate profit and calculated as Operating Return divided by Total Assets. ROI is a useful measure to compare two farming systems with different assets.

i.e. comparing one farming system with old machinery to another farming system with new machinery.

When evaluating management practice changes, it is important to evaluate cash flow implications and determine whether the business has sufficient cash flow to cover the changes. Completing a Cash Flow budget in FEAT will provide a forecast of any deficits and surpluses in cash throughout the year so that a plan can be enacted to ensure bills and loan repayments are paid on time.

Farm Performance Indicators

This page provides users with a range of Farm Performance Indicators for the selected FEAT scenario. Users do not need to enter any information into this page. Each Farm Performance Indicator is listed below together with a short definition.

Key Indicators

Total Farming Area (ha): identifying whole of farm area. This may include land that is used to grow other crops in rotation with the sugarcane enterprise.
Tonnes Harvested: Total tonnes of cane harvested across the whole farm.
Sugar Price ($/t): Average sugar price received per tonne of sugar.
Total Income/Revenue ($): income derived from both sugarcane and other crops. The calculated figure is directly influenced by crop prices, yields and crop quality (e.g. CCS for sugarcane). This does not take into account production costs and therefore does not measure profit.
Total Variable Costs ($): costs associated with growing cane and other crops that are directly related to the level of output from the business (eg. harvesting, chemicals, fertilizer, fuel, oil repairs, contractors etc). The amount spent is under the control of the manager and can be changed quickly in the short term. A high figure may indicate that the business needs to review its farming system practices or it may have a high proportion of contracted operations, leased land or casual labour.
Total Cane Gross Margin ($): the difference between total income and total variable costs for the sugarcane enterprise. Cane gross margin is the sugarcane enterprise’s contribution to fixed costs and profits after the variable costs have been paid. This figure is important for maximising whole of farm profit in the short run as fixed costs are difficult to change.
Total Other Crop Gross Margin ($): the difference between total income and total variable costs for the other crops enterprise. Other crop gross margin is the other crop enterprise’s contribution to fixed costs and profits after the variable costs have been paid. This figure is important for maximising whole of farm profit in the short run as fixed costs are difficult to change.
Farm Operating Return ($): calculated by subtracting fixed costs from the whole of farm gross margin and adding miscellaneous income.
Return On Investment - whole enterprise (%): measures the economic return achieved relative to the value of all the farm’s resources. The figure indicates whole of farm profitability, however it does not include financing costs or taxes.
Casual Labour Hours (hrs/yr): calculated by summing both machinery and irrigation labour hours across the whole farm. Casual Labour Hours are important when comparing two scenarios with different management practices that influence labour requirements (different row spacing or irrigation systems), particularly when variable labour has not been allocated costs (e.g. $35/hr).
Casual Labour Cost ($/yr): calculated by summing both machinery and irrigation labour costs across the whole farm. This will be zero if users have not added a casual labour cost into the ‘Machinery’ page and the ‘Cane Growing Costs’ and ‘Other Crop Growing Costs’ pages (within the irrigation sections). Casual Labour Costs are important when comparing two scenarios with different management practices that influence labour requirements (different row spacing or irrigation systems) if variable labour has been allocated costs (e.g. $35/hr).
Permanent (Fixed) Labour Costs ($): transferred from the ‘Fixed Costs’ page. Vital when comparing the performance of two different farming systems.

Physical

Total farming area (ha): already defined above.
Cane harvested area (ha): area of sugarcane harvested.
Cane yield (t/ha): average tonnes of sugarcane per hectare for all crop classes.
Farm average CCS (relative): average relative sugar concentration for the entire sugarcane crop.
Tonnes sugar per hectare: determined by the yield and CCS levels of the sugarcane crop and indicates the amount of sugar produced per hectare. Provides an overall indication of the enterprise production output.
Rotational crops area (ha): area of crops grown in rotation with a sugarcane crop production system (eg. Legumes).

Resources

Land and fixed improvements ($/ha): estimated market value of the whole farm expressed on a per hectare basis. The calculation includes land and fixed improvements (eg. sheds, water mains and dams) and influences the return on investment calculation.
Machinery Investment ($/ha): a guide to whether the whole of farm business is over or under capitalized. Includes all machinery and equipment used to run the farming business. This measure should only be compared with values for farms of the same type and size. This figure can also influence the return on investment calculation.
Sugarcane tractor operations (hrs/ha - plant, ratoons & bare fallow): provides an indication of the farming system efficiency by calculating the amount of time spent undertaking tractor operations in the plant, ratoon and bare fallow areas of a sugarcane crop.
Whole farm casual labour efficiency (labour hrs/ha): measures the effectiveness of the manager to use labour resources to operate the business. Businesses must have similar characteristics to allow for a comparison. For example, mixed enterprises will generally have a higher labour input per hectare because of the labour required to grow another crop.
Sugarcane irrigation casual labour (hrs/ha): measures the effectiveness of the manager to use labour resources to irrigate the sugarcane crop. The calculated figure may be influenced by irrigation practices, irrigation system, environmental conditions or the availability of water.
Sugarcane irrigation efficiency (tonnes/ML applied): tonnes of cane per ML irrigation water applied. This PI will be most meaningful when comparing farms in a geographic location with similar soil types and receiving a similar amount of rainfall (both annual total and distribution).

Profitability

Total sugarcane farm income, net of levies and bonuses ($/ha and $/tonne): income derived by the sugarcane enterprise relative to its size in hectares and tonnes. Already defined above.
Cane variable costs ($/ha and $/tonne): costs associated with growing cane that are directly related to the level of output from the business (e.g. harvesting, chemicals, fertiliser, fuel, oil repairs, contractors, etc.). The amount spent is under the control of the manager and can be changed quickly in the short term. A high figure may indicate that the business needs to review its farming system practices or it may have a high proportion of contracted operations, leased land or casual labour.
Cane gross margin ($/ha and $/tonne): already defined above.
Cane operating return ($/ha and $/tonne - if 100% cane only): calculated by subtracting the whole of farm fixed costs from the cane enterprise gross margin. This figure is not applicable to mixed enterprises as fixed costs may not be solely attributed to the sugarcane enterprise.
Whole of farm gross margin ($/ha): the summation of gross margins for all cropping enterprises.
Whole of farm operating return ($/ha): As defined above but on a per hectare basis.

Cost Ratios

Fixed costs ($/ha): whole of farm fixed cost expressed on a per hectare basis. The expectation would be that the greater the size of the farm the lower the fixed costs per hectare.
Total fixed costs/Total farm income: indicates what proportion of total farm income went towards the payment of whole of farm fixed costs. Lower figures may be attributed to economies of scale, a more efficient farming system which requires less machinery or a high income. This figure will be influenced by price fluctuations, therefore it is difficult to benchmark over time.
Total cane variable costs/Total cane income: indicates the proportion of total sugarcane enterprise income that went towards the payment of sugarcane variable costs. A high figure may indicate that the business needs to review its farming system practices or it may have a high proportion of contracted operations, leased land or casual labour. This figure will be influenced by price fluctuations, therefore it is difficult to benchmark over time.
Average growing expenses plant cane ($/ha): the average land preparation, planting, fertilizer, weed control, insect control, disease control and irrigation costs for growing a crop of plant cane. The average includes spring plant, autumn plant and plough-out replant. The calculation only considers the crop class on the farm i.e. if there is no autumn crop it is not part of the average.
Average growing expenses ratoon cane ($/ha): the average cultivation, fertilizer, weed control, insect control, disease control and irrigation costs for growing a crop of ratoon cane. The average includes all ratoon crop classes.
Average land preparation costs for plant cane ($/ha): the cost of land preparation prior to planting sugarcane. A high figure may indicate excessive tillage before planting or contracted tillage operations causing higher variable costs.
Sugarcane fertiliser and soil ameliorants cost ($/ha): the average cost of fertiliser and soil ameliorants (e.g. lime, gypsum) for plant, ratoon and fallow areas.

Cane Sensitivity

This page provides a cane sensitivity analysis table, which shows the cane average gross margin at different sugar prices and CCS values. Given uncertainty around the price growers will receive for their sugar and their season average CCS, sensitivity analysis is useful to explore the impact to profitability (gross margin) if the sugar price and CCS vary from what is expected.

Users can generate a cane sensitivity analysis by:

Entering the starting sugar price, which should be the lowest sugar price growers might expect to receive (e.g. $340/tonne);
Entering the incremental change in sugar price, which is the dollar change per column moving to the right of the table. For example, if a user enters $20 then the sugar price in each column to the right will increase by $20 each column (e.g. $340, $360, $380, etc.);
Entering the starting CCS value, which should be the lowest season average CCS growers expect (e.g. 12);
Entering the incremental change in CCS, which is the CCS change per row in the table moving downwards. For example, if a user enters 0.4 then the CCS in each row moving downwards will increase by 0.4 each row (e.g. 12, 12.4, 12.8, etc.);
Clicking the ‘Submit’ button.

After entering those four values and pressing submit, users can then examine the cane sensitivity table to determine the average gross margin at different combinations of sugar price and CCS.

For example, the worst case would be the gross margin that corresponds to the lowest sugar price and CCS combination (top-left value), while the best case would be the gross margin that corresponds to the highest sugar price and CCS (bottom-right value).

Other Crop Sensitivity

This page contains provides a sensitivity analysis table for each of the other crops entered by the user. After choosing the particular ‘Other Crop’ that users want to examine, the sensitivity table will show the average gross margin at different combinations of market prices and yield. Given the similarities, please see the step-by-step details for Cane Sensitivity above for instructions on how to enter the starting price/yield and incremental changes.

Cash Flow

This page enables users to download a Cash Flow Worksheet. When downloaded, the worksheet is pre-filled with specific information from the FEAT scenario such as revenues and expenses.

To download the Worksheet, users need to click on the ‘Download Worksheet’ button and save the file to a familiar folder on their computer.

To complete the Cash Flow Worksheet, users need to open the file and:

Enable editing of the sheet.
Enter the Delivery Advances of sugar ($/t) for the corresponding month (e.g. $285 in July, $0 in August and September, $10 in October, etc.). This total needs to add up to be the same as the Sugar price;
Enter the percent of cane crop delivered (and paid) in each month over the harvest season;
Allocate percentages of ‘Other Crops’ and ‘Other Income’ (if applicable) to the corresponding months over the financial year. For example, if 100% of ‘Other Crop’ income is received in March then enter 100 in March and leave zero in the other months. This will allocate all of the Other Crop income to March;
Allocate percentages of ‘Variable Costs’ and ‘Fixed Costs’ to the corresponding months over the financial year. For example, if approximately 25% of fertiliser costs are paid in August, September, October and November then enter 25 into each of these months and leave the other months zero;
Enter total Investment Sales and Purchases into the total column (B) and allocate percentages of Sales and Purchases to the corresponding months over the financial year;
Enter money coming into the business, via ‘New Borrowings’, ‘Contribution from Owners’ and ‘Interest Earned’ (under Finance heading), in each month over the financial year.
Enter money going out of the business, via ‘Loan Repayments’ and ‘Drawings’ (under Finance heading), in each month over the financial year.
The next section will show all outgoing (expenses) and incoming (income) for the corresponding month over the financial year.
Add in last year’s final balance if applicable.
Navigate to the sheets ‘Cash Flow (Yr 2)’ and ‘Cash Flow (Yr 3)’ if you wish to fill out those years.
Navigate to ‘Cash Flow Summary’ to see a summary for each year.

Optimum Ratoons

This page calculates the optimum number of ratoons grown in a crop cycle that maximises profitability. The optimum number of ratoons is identified by the ratoon that produces the highest average gross margin per hectare over the crop cycle.

Calculate the optimum number of ratoons by selecting the cane planting time (early, late or plough-out replant) to be used for the calculation from the drop-down list. Please note that you can only select these options if you have a crop entry for them from the Cane Assumptions page. The optimum ratoons table also includes additional ratoons that have not been entered by the user (e.g. 5th to 10th ratoons). The yield and CCS values for these additional ratoons should be edited by the user by entering estimates that reflect their particular situation.

The optimum number of ratoons will be shown below the table (on the left) in the light blue shaded area once the planting time has been chosen.

More Information

If users require any further information not outlined above, please send us an email by following the instructions on the Contact Us page – accessed by clicking on ‘Contact Us’ at the very top of the FEAT Online page.