Everything I input into Solver is giving me a not feasible solution. How should I be setting up a linear regression to find optimal production with the following data? I'm also unsure of how to add a promotion, any tips?
<colgroup><col width="157" style="width: 118pt;"><col width="65" style="width: 49pt;"><col width="73" style="width: 55pt;"><col width="309" style="width: 232pt;"><col width="73" style="width: 55pt;"></colgroup><tbody>
</tbody>
| Input Data (Demand) | Input Data (Costs etc.) | |||
| Month | Demand | Item | Cost | |
| January | 10,000 | Materials cost/unit | $ 40 | |
| February | 11,000 | Inventory holding cost/unit/month | 3.0 | |
| March | 15,000 | Marginal cost of stockout/unit/month | ||
| April | 18,000 | Hiring and training cost/worker | ||
| May | 25,000 | Layoff cost/worker | ||
| June | 26,000 | Labor hours required/unit | 2.0000 | |
| July | 30,000 | Regular time cost/hour | 15.0 | |
| August | 29,000 | Over time cost/hour | 22.0 | |
| September | 21,000 | Marginal subcontracting cost/unit | ||
| October | 18,000 | |||
| November | 14,000 | Initial Workforce size | 250 | |
| December | 11,000 | Maximum overtime per worker per month | 20 | |
| Starting inventory ('000s) | 50 | |||
| Ending inventory ('000s) | 50 |
<colgroup><col width="157" style="width: 118pt;"><col width="65" style="width: 49pt;"><col width="73" style="width: 55pt;"><col width="309" style="width: 232pt;"><col width="73" style="width: 55pt;"></colgroup><tbody>
</tbody>
