The purpose of the DPR is to provide a view of risk and inventory to the user.
- Exposure to the market – what is the impact on the user if the futures market starts to move? Are we long or short and by how much?
- Basis risk – what is the impact on the user if basis starts to move? Are we long or short and by how much?
- Quantity available for sale – considering what is on hand, what contracts are open, and what is stored for third parties, how much product is available to sell?
How Company Titled is calculated.
It is the sum of product on Hand and on Storage Quantity
How is cash exposure is calculated.- Company titled quantity
- Plus open purchases quantities* that are priced or HTA (for each contract sequence, the quantity that has not yet been received)
- Minus open sales quantities* that are priced or HTA (for each contract sequence, the quantity that has not yet been invoiced.)
- Plus/Minus futures quantity
- -The value of this field will be the number of active (not matched) futures contracts in the selected brokers/accounts, times the quantity of the futures market, converted to the UOM selected for the report. Longs are positive and shorts are negative; the total could be net positive or negative.
- -Each futures transaction has location and commodity, so only those transactions associated with the appropriate location and commodity would be included
- Company titled
- Plus open purchase quantities* that are priced or basis
- Minus open sales quantities* that are priced or basis
- Basis exposure minus Priced and Basis open* purchases
- Basis exposure minus Priced and Basis open* purchases
How is Avail For Spot Sale is calculated.
- Total quantity stored in house regardless of ownership....includes company titled and whatever is stored for customers like grain bank/open storage, Excludes in transits.
- To see the location wise details of each commodity please click on each commodity in the on header level
- According to that the location grid on bottom will show the detail breakup by location.
How is position details for each commodity is calculating
Select any commodity from top grid and click on position detail button or double click on the commodity line.
How in-House is calculated:
: = On hand + In Storage - the Qty against the Storage type " offsite"
How offsite is calculated:
Total Inventory received through scaling against the distribution type "offsite" for the selected commodity Owned by the user's company.
Check Risk Preferences to see if it is included in Company Titled.
Off site quantity will Add to in house only if Risk Preferences say to include Off-site in company titled
How Storage types values ( Open , Grain Bank , Warehouse . DP ... ) calculated
This sections will populate based on the configuration given in the storage type screen in Grain module
Total Inventory received through scaling against the distribution type "Grain bank" or Open , Grain Bank , Warehouse . DP or any other user entered type for the selected commodity owned by customers
How to calculate Total Non receipted
Sum of user defined storage such as open storage, grain bank, condo storage, plus any other type of third party storage, this is not receipted and is owned by the customer
How to calculate Collateral sales/ purchase
Displaying the total remaining qty from collateral screen against purchase and sales.
How to calculate Total Receipted
Total of collateral items Qty+ receipted storage types Qty (customer owned only)
How to calculate DP.
Inventory received against the storage type "DP" through scaling.
How to calculate Purchase basis deliveries .
This will display all the "Purchase contract" receipt type which were created from scale in and associated with distribution type "Contract".
The contract pricing type should be basis.
How to calculate sales basis deliveries .
This will display all scale outs associated with distribution type "Contract". The contract should have the pricing type "Basis"
How to calculate company titled stock
on hand + company owned storage type + DP + difference between purchase and sales collateral
How to calculate purchase priced.
Total of Open (not yet received) quantity on purchase contracts that have been fully priced.
How to calculate purchase basis.
Total of Open (not yet received) quantity on purchase contracts that have basis but no futures/fixation.
How to calculate purchase HTA.
Open (not yet received) quantity on HTA purchase contracts.
How to calculate sales Priced.
Open (not yet invoiced) quantity on sales contracts that have been fully priced.
How to calculate sales basis.
Open (not yet invoiced) quantity on basis sales contracts (have basis but not yet priced).