Can it possible to achieve Costing for A Item with different cost method ?

Summary:

We have a requirement to get below scenario

for Item A we need standard cost and average cost to be used for different inventory org , Can it be possible if we use item cost profile and attach 2 different profile to same item with different inventory org ?

Or here we need to use different cost Org -one for average and one for standard??Please suggest

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):