I have a simple LP problem where in I need to check how many Units of Big Products and Small Products can I make in order to maximize my profits keeping constraints in mind.
Objective : Units to Make for Big and Small Products
Inputs: 1. Manpower for Big is 6 Hours and for Small it is 9 hours
2. Raw Materials is 1 Bag for Big and 1 Bag for Small
3. Other Components is 15 units for Big and 10 units for Small
4. Unit Profit for Big is $182 and $139 for Big & Small Respectively
Constraints: 6 hours of Big Manpower + 9 hours of Small Manpower <=7000
1 Bag of Raw materials for Big + 1 bag of raw materials for Small <=1000
15 units of other components of Big + 10 units of other components of Small <=14000
My Approach: I created two Lists - Products (Big, Small) and Input List (Manpower, Raw Materials, Other Components)
a) Created an Input module with 2 line items: Input data - Dimensions of both the lists & Unit Profit - Dimension of Products
b) Created Variable Module (Dimension both the lists) - One Line item - Totals; the optimizer publishes the data in this module
c) Created Objective Module( Dimension both the lists) - Input Module.Unit Profit* Variable Module.Totals
d) Created Constrains Module with 3 line items (Dimensions both the lists) - Manpower, Raw Materials & Other Components.
Manpower - Input Module .Input Data * Variable Module .Totals <= 7000 - Boolean Formatted
Raw Materials- Input Module.Input Data * Variable Module.Totals <= 1000 - Boolean Formatted
Other Components -Input Module.Input Data * Variable Module.Totals <= 14000- Boolean Formatted
When I run the optimizer I don't get the desired results - The optimized results are 800 & 200 Units of Big and Small Respectively but Anaplan Optimizer provides way lesser amount than it (66 & 100 respectively). Any thoughts on this?
Solved! Go to Solution.
I only created 1 list, i.e Products.
Below are the screen shots of the 4 modules i created.
The prefix indicates whether they are Variable, Assumption (Input), Constraint or Objective.
Below is a screen shot of the optimizer action:
The results are as you expected, i.e. 800 Big Product, and 200 Small Product as shown in the first screen shot.