Description:
The attached excel gives details about bids, bids can be of 2 types:
The above is captured in field Bid Medium
Bid Medium decides which value to be used for the following computation
- Direct (Bid Qty*Bid Direct Price)
- Indirect (Bid Qty*Bid Indirect price)
Bids for the same Bid Item No. would be generated over a period, if the current bid have been set a higher price than the previous bid the Price Increase or Deviation Flag is set as 1.
Additionally, Bids can have step pricing i.e. Same Bid can have 2 different prices based on Qty (Row 6&7 in Excel).
Another computation is Deviation Amount-
(Bid Indirect Price(Current) - Bid Indirect Price(Previous))*Qty(Current)
For Step Pricing-
(Avg. Bid Indirect Price(Current) - Avg. Bid Indirect Price(Previous))*Qty(Current)
Whereas if the Bid Medium is Direct then for aforesaid computations we should use Bid Direct Price.
Problems faced:
- To Identify the Previous Bid
- To identify Step Pricing
- To switch between Direct/Indirect Price
Kindly help me out with this, Thanks in advance.
Additional Details:
Key- Concatenation of (Bid Item No., Bid Cust. No., Bid Medium, Bid Cust.)
Message was edited by: Shannoy Paul
