Page History

The purpose of the DPR report is to provide a view of risk and inventory to the user.

• Exposure to the market – what 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 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?

...

This first screen is a summary of company titled inventory, risk (cash) exposure, basis exposure, and quantity available for sale.  Each column is a different commodity.  This data is extracted and summarized from details so we will focus on those details and create the Live DPR summary last.  

Commodity

          :  As each commodity is a row in the report, this selection will determine how many columns will appear. 

UOM

          : UOM of the commodity. This will be overwritten with the default UOM from the risk management company preference.

Company Titled: Titled 

       For For each commodity, this is the quantity of inventory owned by the user.

on       Formula: On hand + company Company owned storage type + DP + difference Difference between purchase and sales Sales collateral + sales Sales basis delivery.

In-House

includes      Includes company titled and whatever is stored for customers like grain bank/open storage, Excludes . It excludes in transits.

      Formula : On Hand + On Storage + DP + On hold

Price Risk

      Company titled (inhouseIn- House) - purchase basis belivery Purchase Basis Delivery + Collateral Sales + Futures + delta Delta options + open purchases quantities * that are priced or HTA -open sales quantities* that are priced or HTA 

Basis Risk

      Company titled +open purchase quantities* that are priced or basis - open sales quantities* that are priced or basis

Available for spot sales

      Basis exposure Risk - Priced and Basis open * Contract purchases.

 When we select the commodity on the Live DPR grid . and it should be displayed the location wise details in the bottom location grid.

Position include Drop down

...

      This will show Licensed and Non licensed type .  To configure the licensed and non licensed storages follow the below steps/

Open the company location from common info module and set "Licenced location " as checked. for any one location .

...