Occasional Contributor
Occasional Contributor

Optimizer Exercises - Production Optimization


I have just done the Optimizer exercises Optimizer: Exercise Walkthrough created by @mark_godfrey , and have an error in the Production Optimization Exercises example. While its possible I messed with the base data, I'm getting exactly the same answer as a colleague. I compared my answer to Optimizer: Use Case Examples  at minute 10:20. The video shows no small allocations to lines of 1 or 2 SKUs.


The answer I get is different as seen in the "Optimizer: Exercise Walkthrough" video.

I have a demo coming up, so this is a 2 part question.

After running the optimization, I get an allocation of 1,3, or 4 products produced on 1 machine and the balance 2000+ produced on another machine?  I understand optimizer coming to that conclusion, but in reality i think it is an unlikely situation.


My 2 questions are:

1) Does anyone know how I got this solution? (Calcs & Pic Below).

2) How would one go about ensuring that there would be a "Minimum Viable Quantity" for a line to produce to avoid small allocations to lines? - would it be additional constraints? if so what would that look like.


Here are the pictures and formulas




C1 DEMAND: 'Production Solver: InputData'.Demand = 'Production Solver: Variables'.Production Qty
C2 PROD LINE QUANTITY: 'Production Solver: Variables'.'Production Hrs.' <= 'Production Solver: InputData'.Capacity Hrs
C3 PROD. QTY-HRS LINK: 'Production Solver: Variables'.Production Qty - 'Production Solver: Variables'.'Production Hrs.' * 'Production Solver: InputData'.'Run Rate (units/hr)' = 0



PRODUCTION COST: 'Production Solver: Variables'.Production Qty * 'Production Solver: InputData'.Cost Per Piece
LABOUR COST: 'Production Solver: InputData'.Cost Per Labor Hr * 'Production Solver: Variables'.'Production Hrs.'

TOTAL SKU COSTS: Production Cost + Labor Cost 




Any ideas would be most welcome, thanks in advance!