Can I use Solver?

[talmrubin]

Hello Everyone.

I am currently working on a project for a class, the instructions and data set are below.

I know I can do this, albeit it manual, without using solver I am trying to use it. Can someone please provide some guidance if solver is the correct path forward or any other way.

I have already translated all transportation costs in a per unit value in the data below. I am also going to assume that demand is the same for all DC's atr 25,000 unit per month

https://www.dropbox.com/s/r4bn0hqdn4e7vui/TV Instructions.docx?dl=0 -- Instructions

https://www.dropbox.com/s/idixqz13qsjaj04/Modelv2.xlsx?dl=0 -- Data

 

[Worf]

Hello

Yes, the problem seems suitable for Solver. You need to build a worksheet formula model that has all the possibilities, and Solver will allocate resources to maximise profit or minimise cost.
Do you need help with the model?