Stock Allocation and Its Closure
1.0 Purpose
The main purpose of this process is to allocate the stock to a terminal and its closure once the loading is completed at that terminal
1.1 Who can perform this?
- Terminal Site Representative
- Supply Manager
- MRS Admin
1.2 Navigation Path
For Terminal Site Representative
Loading Tickets > Stock Allocation Request
For Supply Manager, MRS Admin
Stock > Stock Allocation Request
1.3 Different Applications Involved in Process
- Portal Web
- MON TAS
1.3 Generation of stock allocation request
Terminal site representatives can generate the stock allocation requests from the stock allocation requests module.
From stock allocation request module by clicking on the Add New button user navigates to the add stock allocation request page. From this page user need to provide the following details
- Terminal
- Product
- Supplier
- Quantity
- Request Date
- Attachments
By submitting the above details, system generates a stock allocation request. After stock allocation request generation terminal site representative can edit the stock allocation request details and the user can cancel the stock allocation request.
| Page/Screen | Add Stock Allocation Request |
| Application | Portal Web |
| Role | Terminal Site Representative |
| Page/Screen | Add Stock Allocation Request |
| Application | MON TAS |
| Role | Terminal Site Representative |
1.4 Approval of Stock Allocation Request
Once the stock allocation request generates then the supply manager need to confirm/decline the stock allocation request. Supply manager reviews the submitted request and if the details are appropriate then user will confirm the request otherwise supply manager will decline the request.
If supply manager confirms the stock allocation request then the requested quantity will be credited to the product owners terminal product available stock account. If supply manager declines the stock allocation request then that request will be closed at that moment.
While confirming the stock allocation request by supply manager, user need to provide the product price/liter, remarks and attachments.
| Page/Screen | Confirm/Decline Stock Allocation Request |
| Application | Portal Web |
| Role | Supply Manager |
1.5 Update of Terminal Product Stock and WAC
Once the supply manager confirms the stock allocation request then that much stock will be credited into the product owner’s terminal product available stock account and product owner’s product overall available stock account.
When the stock is credited into the system then the terminal product weighted average cost will be updated based on the credited stock and the price of the newly credited stock.
The weighted average cost will be calculated using the following formula
((current stock * current WAC) + (credit stock * new rate)) / (current stock + credit stock)
Ex: Current Stock is 500,000 Ltrs. Current WAC is 125.00 Naira. Newly approved stock allocation request quantity is 100,000 Ltrs with 132.00 Naira per liter.
Updated WAC = ((500,000 * 125) + (100000 * 132)) / (500000 + 100000) = 126.1667
| Page/Screen | Stock Transactions |
| Application | Portal Web |
| Role | Supply Manager |
1.6 Assign Loading Tickets to Stock Allocation Request
After completion of the loading at the terminal then supply manager need to assign those loading tickets to the stock allocation request.
While assigning the loading ticket to the stock allocation request system accepts the configured variance extra quantity or equal to the stock allocation request quantity only.
Variance mod setting value is configured under this setting
STOCK_ALLOCATION_REQUEST_ASSOCIATE_LTS_VARIANCE
Once loading tickets assigned to the stock allocation request, supply manager can close the request.
| Page/Screen | Assign LTs to Stock Allocation Request |
| Application | Portal Web |
| Role | Supply Manager |
1.7 Close Stock Allocation Request
Once the loading tickets assigned to the stock allocation request then the supply manager closes the stock allocation request. If any quantity is remains in the stock allocation request after assigning the loading tickets then there will be an option to revert the available quantity of the stock allocation request.
Supply manager can decide whether the remaining quantity required to revert or not. If user chooses as Yes then system debits that much quantity from the product owner’s terminal product available stock account and product owner’s product overall available stock account
The quantity which is debited that quantity we call it as lapsed quantity. This lapsed quantity details will be available in the PPMC Supply Report
If the lapsed quantity is more than the configured major lapsed quantity then the lapsed quantity in report will display in burgundy color. The value will be configured under this mod setting.
STOCK_ALLOCATION_MAJOR_LAPSED_QTY
If the lapsed quantity is more than the configured minor lapsed quantity then the lapsed quantity in report will display in yellow color. The value will be configured under this mod setting.
STOCK_ALLOCATION_MINOR_LAPSED_QTY
| Page/Screen | Close Stock Allocation Request |
| Application | Portal Web |
| Role | Supply Manager |