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>