Excel allocation rule/formula

Job ID: 33630363

Budget: $10 – $30 USD

I have some problem with a specific allocation project that must take into account two different values when the resources (in this case balls) is allocated. Total problem description is written in the file.