Hi,

I am trying to calculate a unit cost based on the following unit price structure, but would like to make the cost variable inputs so that I have the ability to change the costs at any given tier...Thanks in advance for your help!!!

Units: Price per unit each

0-1 units: $33.792
Next 49 Units: $33.178
Next 450 Units: $32.666
Next 500 units: $32.051
Next 400 units: $31.539

My units might vary from month to month, so that would also need to be a variable input. So for example if I have 50 units, my first unit would be at $33.792 and the next 49 at $33.178.

Any help would be greatly appreciated!!!