Page History
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?
Position Report.
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:
For each commodity, this is the quantity of inventory owned by the user.
on hand + company owned storage type + DP + difference between purchase and sales collateral+sales basis delivery
In-House
includes company titled and whatever is stored for customers like grain bank/open storage, Excludes in transits.
On Hand + On Storage + DP+ On hold
Price Risk
Company titled(inhouse)- purchase basis belivery + Collateral Sales+Futures + 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 - Priced and Basis open* 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
...
Daily Position Inquiry will show all the inventory related transaction such as how much Inventory received against Company owned and customer owned and what is the total of this day.
We have mainly 3 section in the daily position inquiry.
- Grain Inventory
- Storage Liability
- Company Ownership
This screens allows you to filter by Beginning Date, End Date, Commodity and Item
Grain Inventory
This will give the Daily balances for Grain Brought In, Grain Shipped Out and any Adjustments
- Beginning Inv. - This is the first row in the Grain Inventory grid. This should be the Inventory (In House, which includes Delayed Pricing) as of the Beginning Date -1 Day
We are showing the net Inventory Receipts for the given day.
For instance :
a. Open Ticket management
b. Create a load in ticket against the distributions type Grain Bank (Grain Bank is customer type)
c. Distribute the same.
d. Now the Storage liability section will show a sub section Grain bank and in that IN column will show the Load in qty against the grain bank.
The same will be reflected in the Grain inventory "Inv In"
Another Instance :
- Open Ticket management
- Create a load out ticket against the distributions type Grain Bank( Grain Bank is customer type)
- Distribute the same.
- Now the Storage liability section Grain bank OUT column will show the Load out qty against the grain bank.
The same will be reflected in the Grain inventory "Inv OUT"
3. Grain Inventory Adjustment
a. Open inventory adjustment from inventory module
b.Enter the adjustment for the same item.
c This number should be reflected in the Adjustment column in Grain inventory.
4. Balance inventory
Inv in- Inv out +/- Adjustment. = Balance inventory
Grain inventory IN = Sum of Storage Liability IN + Company ownership IN + DP
Grain inventory OUT = sum of Storage Liability OUT + company ownership OUT
Storage Liability
When ever user create a Customer owned Load in or Load out it will reflect in this section
For instance
5. Open Ticket management and Create a load in ticket against the distributions type Open storage ( open storage is customer type) and distribute the same . now the Storage liability section will show a new subsection called open storage and Open storage In column will show the Load out qty against the grain bank.
The same will be reflected in the Grain inventory "Inv OUT"
Company Ownership
Company Owned Section – Unpaid
first row is the beginning balance for the Month. This should be the Open Vouchers and any DP Grain as of the End of the Prior Month
When we do the distribution against load in for the distribution type 'spot sales' , 'contract ', it will create an IR and it will create a voucher also. hence this company ownership section will show the UNPAID In qty .
When the vocuher is paid the proportionte quantity has been calcuated . we are showing Vouchers that have been paid for the given day in UNPAID OUT column.
** If the Voucher is created and paid in the same day, it should still show in both the IN and the OUT columns.
we are showing the Unpaid Balance for the given day . That means Unpaid IN- Unpaid Out
Company Owned Section – Paid
Here we are showing the difference between the Inventory balance for the day and the Unpaid Balance for the day. This number CAN go negative
Total Company Owned
This will be the Unpaid Balance + the Paid Balance
When User click on the date link it will lead to the second tab and will show all the break up details of IN and OUT and adjustment nnd voucher numbers also .
When we load the Position report with licensed strorage it will load all the commodities which has got licensed location . and while select the same commodity it will load only the licensed location in the location grid.
Same was Non lincesed also will be performed. such as it will load commodities which has got only non lincesed locations.
Vendor Customer Position check box
After the check vendor/customer position is ticked then the next 2 drop down will be enabled.
Select the check box
enter the type as purchase
Enter the type as sales
When we select the type as purchase then the heading should change to Vendor position inquiry
When we select the type as sales then the heading should change to Customer position inquiry.
In customer positoin inquiry the DPR grid should show the commodity name, UOM and the inhouse qty.
For Eg:
Create a scale in qty against Grain bank type which ins customer owned for eg: 50 Bu
Create a scale in against the DP which is company owned. for eg: 280 bu
Create a scale in against the on hold for eg: 120 bu
Open Customer position inquiry and check the in house qty
The DPR should show the inhouse qty as
Qty received against the customer owned storage type ( Grain bank) and on hold
in the above eg: 120+50= 170