We have a sliding scale overhead rate based on the following table. I have
created a function which takes its place. However, now I need to back into
the overhead from the subtotal. I could use €œSolver€� and solve for subtotal,
but have over 800 lines. Is there code I could write and employ the solver
add-in or something like that? I would appreciate any help I can get. Thanks

COSTS ESTIMATE $45,000.00
OVERHEAD 3,525.00
SUBTOTAL 48,525.00


RATE RANGE SUBTOTAL MAX/RNG
0.1 0 2499 250.00 250
0.09 2500 9999 675.00 675
0.08 10000 24999 1200.00 1200
0.07 25000 49999 1400.00 1750