excel - Excel simplex LP solver MOQ
问题描述
I am trying to optimize the purchase orders using Excel simplex LP solver.
The problem is when I need to decide among suppliers based on the MOQs.
If the quantity to order is large, I can choose any supplier. However, if the necessary order size is small, I must choose among suppliers who accept small batches.
I need to create a decision on the amount to order that is 0 or >= MOQ.
Here is an example file: https://drive.google.com/file/d/1DnxsRe1vhsDxRL-G8jHdCBMGkO-qqfwV/view?usp=sharing
解决方案
推荐阅读
- spring-boot - 当多个 Junit 测试一起运行时,@EnableCaching 会被忽略
- reactjs - 无法从本地存储中获取数据并在同一页面上显示该数据
- java - 尝试启动摆动计时器时出现空指针异常错误?
- node.js - `books.find()` 缓冲在 10000 毫秒后超时,heroku 节点 js
- laravel - laravel 中微服务架构的 API 网关
- api - 为什么我点击的时候第二屏的图片和标题总是一样的?
- javascript - 如何在组件之间传输图像和数据 | 反应
- javascript - MongoDB 不推送/增加字段
- python - 如何在输出文本控制台上正确显示非拉丁字符?
- php - 有没有办法让 Twig Extra Bundle 允许手动缓存重置?