Excel Solver with three categories

[ziay]

Hello,

First time user with an excel problem.

I think Excel has a solver built in as well as VB, I was looking for guidance on how to use it to solve a best fit situation.

I have three variables.

Equipment sent to customer (primary: inventory)

Cost per equipment sent (primary: budget)

Schedule of sending equipment to customer (primary: schedule)

I want to see how the change in one or two variables will effect the other.

for example:
the cost of equipment goes up, when will the budget run out now.
the customer is moved to next month, how does it effect the budget and inventory for this month.
the equipment is different, with lower inventory levels and higher cost, how many customers can i fit in my schedule before one of the others run out.

Its a complex solution. Any ideas are welcome . Thank you,
yz

[shg]

Welcome to the forum.

Post an example workbook, and explain in context.