talmrubin

New Member
Joined
May 4, 2017
Messages
9
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
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Worf

Well-known Member
Joined
Oct 30, 2011
Messages
4,010
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,808
Messages
5,524,995
Members
409,615
Latest member
papaluigi94

This Week's Hot Topics

Top