Microsoft solver

Hi Graeme

Thanks for getting in touch. I confess ABC costing was a new phrase to me; however searching around the internet I can ind a few examples of people using it in conjunction with Solver. The following link had quite a good worked example, starting from page 14:

http://journals.cluteonline.com/index.php/AJBE/article/viewFile/4083/4137

Essentially if you can assemble your data into constraints (defined limits for costs, resources available, time to elapse etc.) you should be able to build a model in Solver that resolves to an answer. Working out what your constraints are and making them explicit to Excel is usually the hardest bit.

Have a go, and if you get stuck do come back to us and we'll give you a hand.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector