Solver Production Planning Issue

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Thanks for the feedback! The file is attached, thanks in advance

I was involved in a production problem three years ago. In the end the problem was solved by the OP who set up a filter with If statements.

https://www.excelforum.com/excel-for...orkaround.html

See post #13 for an explanation of how the filer works and post #15 for the finished solver model.

As to his comments

The only thing I need to figure out is how to encourage a machine to run as long as possible before shutting down

I think his model has that build in already as there is a penalty for stopping and restarting a kiln.

Alf

Checking the solver model in post #15 and there was something strange with it so I've uploaded another copy of the original to show how the cost penalty gets added.

As the size of this model is to big for the excel solver to handle you need to upload OpenSolver a freebie form the University of Auckland NZ if you wish to do a rerun of this model.

Alf