The Contracting Dashboard, which can be found under the Harvest Reports menu, replaces the Crop Position Actual report, and combines information from that report with the Marketing Plan.
By creating this dashboard, now you can:
Make better marketing decisions, increase revenue
Catch elevator payment errors
Simplify delivery planning and settlement
Know where the data is coming from with additional tooltips and hovers
The dashboard is split into three key sections, the initial list page, the detail page and the contracts/deliveries/settlements section.
Initial List Page:
The initial page gives a birds-eye view of the amount of each commodity that is available to market and sell, based on a combination of planned and harvested data. (If you have not completed a budget, then there won't be planned data, so the dashboard shows only harvested real time data from harvest tickets in the system).
Upon selecting a budget, the dashboard will use the budgeted crop price and populates the ‘Unsold Price to Make Budget”. With a budget selected, the breakeven price can be toggled between either the budgeted costs or the actual costs driven from the costs from actuals.
Remember to set the market price for each commodity, as the new dashboard will complete any futures or basis contracts to show a complete price, rather than just pulling the futures or basis price set in the contract.
The What If tool allows the creation of different marketing scenarios, entering the selling price and total amount to sell which will populate the revenue and pricing around the selected budget. This page will save created scenarios, or create a new contract by selecting ‘Create Contract’.
Detail Page:
The detail page can be accessed by selecting a commodity. This view breaks down where the sold units are, while seeing what is unsold, delivered and settled.
The bar graph gives a visual representation of contract commitment and progress across the crop year months.
Contracts/Deliveries/Settlements:
This section is new and improved for reporting needs. With its own set of filters, users are able to dive into specifics on their contracts, deliveries and settlements.
Access pertinent needed information using the three different tabs. Each tab offers slightly different information.
Contracts Tab- Contract information which includes
Contract name
Customer name
Type of contract
Price - marked to market price
Contract date
Next action date
Contract amount
Deliveries Tab- Delivery information which includes
Contract name
‘No Contract’ Row* (more detail below)
Customer Name
Expanded View includes
Delivery receipt number with delivery location, delivery date and amount delivered
Delivery location(s) on contract
Delivered percentage
Open amount- amount left to be delivered or overage if over delivered
Delivery month(s)
Type of contract
Contract date
*The deliveries tab includes a ‘No Contract” row which will include any deliveries the system cannot auto match to a contract. This tab also will show Field to Customer or Storage to Customer tickets that are not matched to a Delivery and if a Delivery Receipt is missing a matching F2C or S2C ticket.
Settlements Tab
Contract name
Customer name
Expanded view includes
Delivery receipt number with settled/unsettled and settled amount, price and revenue on that load
Delivery location
Settled percentage
Type
Settled amount
Price - settled price
Total revenue- actual true revenue
Report/Exporting Options
There are three different options to export reports from the contracting dashboard. At each of these, there is an option to export either PDF or to XLS.
Contract Creation Page Changes:
Next action date- the next action date can be entered if there is still a price to be set or other action that needs to be taken on the contract
Undefined delivery - undefined delivery allows you to enter a contract amount without specifying an exact delivery month
Flexible delivery dates- Flexible delivery dates will roll over any undelivered amount from current month to new month if the delivery is not made
With the new contract changes and options as well as the updates to the dashboard, the contract delivery reports and the uncontracted inventory report were retired from the system. This information can now be populated and reported on through the contracting dashboard.