Production Optimization

AkshayRRaut
AkshayRRaut
in Modeling

hi

I am working on production optimization.I am getting error regarding C3 constraints.

 

I have attached screenshot of formulas.

 

Please guide me.

Tagged:

Answers

  • Misbah
    Misbah

    @AkshayRRaut 

     

    In your C3  write your equation in this manner

    A-B = 0

     

    Formula should like this 

    'Production Solver: Variables'.Production Qty - 'Production Solver: Variables'.'Production Hrs.' * 'Production Solver: InputData'.'Run Rate (units/hr)' = 0

     

    Your Formula 

    'Production Solver: Variables'.Production Qty =  'Production Solver: Variables'.'Production Hrs.' * 'Production Solver: InputData'.'Run Rate (units/hr)'

     

    That should solve your problem

    Let us know if it doesn't

     

    Misbah

     

     

     

     

  • AkshayRRaut
    AkshayRRaut

    hi

     

    I have applied the same formula but still error is there

  • Misbah
    Misbah

    @AkshayRRaut 

     

    Screenshot 20 - It shows you still have the same old formula. Can you please write it the way I had shown or are you saying even after changing the formula you still get the errror message?

     

    Thanks,

    Misbah

Categories