A complex Pricing Scenario.

Here's an interesting Pricing Scenario

There are six items in a Sales order X,Y,Z in one group and A,B,C in another group. Groups are divided by the routes.
X,Y,Z belong to one route Z0001 and
A,B,C belong to another route Z0002

Now Price is is calculated not by the quantity but by the weight of each material.

The logic is

If the total weight of all the materials in a group is less than equal to 100gm, the price would be 10000 Rs.
If the total weight of all the materials in a group is more than 100gm then sum of the material weight should be multiplied by a fix price 150 to get the price i.e. if X+Y+Z= 200 then 200*150= 30000 Rs.

Same Logic applies for the another group of materials.

The story does not end here. When both the group prices are calculated system should sum both the group prices and give this as the final price of the Sales order.

Please do not tell me that use a routine. I'll appreciate if you can explain the routine logic in detail.

Transportation- Case Study (Real Time Scenario)

When selecting a mode of Transportation, we must account for cycle, safety and in-transit inventory costs that result from using each mode. Modes with high transportation cost can be justified if they result in significantly lower inventory costs.
In SAP SD Transportation Module do we have an option to measure the transportation costs involved amongst many transportation modes available.

Here is an example

Transp Agent Total Cost during Transportation(Transportation + Inventory )
FA Rails 186900$ annual
Golden Agent 154320$ annual
Blue Star 176820$ annual

The issue here is can the SAP system choose the lowest total cost model offered by various Forwarding Agents.

Please post your questions/doubts(www.sapexplore.com)

Dudes...you can post your questions here and Ill reply very shortly.
Your doubt/s may need detail explanation so drop in your email id also.

Now post your doubts at www.sapexplore.com