One to many mapping

SuhasDesai
SuhasDesai
in Modeling

Hi,

I have a requirement where i want to realign/ redistribute the Sales History from 1 SKU to many SKUs. Lets say, i have SKU A with 1000 units sales history. I now need to realign 400 and 300 units from SKU A to SKU B and SKU C, who have 500 and 200 units sales history of their own, respectively.

So after the redistribution, SKU A will have only 300 units left. SKU B will have 500 + 400 = 900 units and SKU C will have 200 + 300 = 500 units of sales history.

I currently have reporting module with SKU A, B, C along with thir Sales History numbers but no mechanism to realign.

Could you please help?

Thank you.

Answers

  • Dikshant
    Dikshant

    Do you just want manual adjustments, where users will add or remove the numbers? Or you want to track each transaction of that has been added or removed from each SKU? How are you visualizing it right now?

  • SuhasDesai
    SuhasDesai

    @Dikshant We want to first create mappings of SKU A to other SKUs like B or B & C (Single or multiple mappings). After that the user will enter how much forecast needs to be redirected to mapped SKUs.

  • maxthermes
    maxthermes

    I want to do a user-oriented study, but there are places I hang out.

    basketballlegends

Categories