Linear programming using python or excel

0
votes

I have a question, here is the deal.

The company manufactures two-unit home air conditioners, which have a capacity of 350 units per month. The production cost of the air conditioner in Drive 1 is 30000 USD, and in Drive 2 it is 27000 USD. The price of the stored devices is 2800 USD for each started month. Assessment demand for the next three months is 400, 500 and 600 devices. Determined the optimal number of devices that should produce each drive in the next three months, with at least 50 devices being manufactured in each facility.

Now I came up with this

Can anyone help me to transfer this in python code or excel

Updated Have a look please updated!

What I need is someone to point me if I'm on a good track and to explain to me how to transfer this problem to Python using SciPy or some other libraries.

Thanks in advance and happy coding. And yeah I don't need this for school I just can't let it go now once I started doing it.

1
pythonexcelpython-3.7linear-programming
Have a look at cvxpy.org - BurningKarl
Sorry, this Python question. Edited, Thanks - Milos

1 Answers

0
votes

You are facing an instance of the capacitated lot-sizing problem over 3 time periods. Modelwise, you need more variables to model the production in each period t = 1,2,3., as well as auxiliary variables to capture the storage costs.

Please check out the PySCIPOpt Example code

https://github.com/SCIP-Interfaces/PySCIPOpt/blob/master/examples/finished/lotsizing_lazy.py

that should do what you want (to some extent). Unfortunately, the corresponding section of the SCIP Book hasn't been written, yet, but you should find enough tertiary literature on lot-sizing, if needed. The book may help you to understand some other concepts behind PySCIPOpt by browsing the parts that have already been written.