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?
[TABLE="width: 677"]
<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>[TR]
[TD="class: xl83, width: 157"]Input Data (Demand)[/TD]
[TD="class: xl82, width: 65, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl82, width: 73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl83, width: 309"]Input Data (Costs etc.)[/TD]
[TD="class: xl82, width: 73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[/TR]
[TR]
[TD="class: xl83"] [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl83"] [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[/TR]
[TR]
[TD="class: xl78, width: 157"]Month[/TD]
[TD="class: xl79, width: 65"]Demand[/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl63"]Item[/TD]
[TD="class: xl64"]Cost[/TD]
[/TR]
[TR]
[TD="class: xl80, width: 157"]January[/TD]
[TD="class: xl84"] 10,000 [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl65"]Materials cost/unit[/TD]
[TD="class: xl66, bgcolor: silver"] $ 40 [/TD]
[/TR]
[TR]
[TD="class: xl80, width: 157"]February[/TD]
[TD="class: xl84"] 11,000 [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl67"]Inventory holding cost/unit/month[/TD]
[TD="class: xl71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] , align: right"]3.0[/TD]
[/TR]
[TR]
[TD="class: xl80, width: 157"]March[/TD]
[TD="class: xl84"] 15,000 [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl67"]Marginal cost of stockout/unit/month[/TD]
[TD="class: xl68, bgcolor: silver"] [/TD]
[/TR]
[TR]
[TD="class: xl80, width: 157"]April[/TD]
[TD="class: xl84"] 18,000 [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl67"]Hiring and training cost/worker[/TD]
[TD="class: xl68, bgcolor: silver"] [/TD]
[/TR]
[TR]
[TD="class: xl80, width: 157"]May[/TD]
[TD="class: xl84"] 25,000 [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl67"]Layoff cost/worker[/TD]
[TD="class: xl68, bgcolor: silver"] [/TD]
[/TR]
[TR]
[TD="class: xl80, width: 157"]June[/TD]
[TD="class: xl84"] 26,000 [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl67"]Labor hours required/unit[/TD]
[TD="class: xl73, bgcolor: silver, align: right"]2.0000[/TD]
[/TR]
[TR]
[TD="class: xl81, width: 157"]July[/TD]
[TD="class: xl84"] 30,000 [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl67"]Regular time cost/hour[/TD]
[TD="class: xl72, bgcolor: silver, align: right"]15.0[/TD]
[/TR]
[TR]
[TD="class: xl81, width: 157"]August[/TD]
[TD="class: xl84"] 29,000 [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl67"]Over time cost/hour[/TD]
[TD="class: xl71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] , align: right"]22.0[/TD]
[/TR]
[TR]
[TD="class: xl81, width: 157"]September[/TD]
[TD="class: xl84"] 21,000 [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl69"]Marginal subcontracting cost/unit[/TD]
[TD="class: xl70, bgcolor: silver"] [/TD]
[/TR]
[TR]
[TD="class: xl81, width: 157"]October[/TD]
[TD="class: xl84"] 18,000 [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[/TR]
[TR]
[TD="class: xl81, width: 157"]November[/TD]
[TD="class: xl84"] 14,000 [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl74"]Initial Workforce size[/TD]
[TD="class: xl76, align: right"]250[/TD]
[/TR]
[TR]
[TD="class: xl81, width: 157"]December[/TD]
[TD="class: xl84"] 11,000 [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl75"]Maximum overtime per worker per month[/TD]
[TD="class: xl77, align: right"]20[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl74"]Starting inventory ('000s)[/TD]
[TD="class: xl76, align: right"]50[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl75"]Ending inventory ('000s)[/TD]
[TD="class: xl77, align: right"]50[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 677"]
<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>[TR]
[TD="class: xl83, width: 157"]Input Data (Demand)[/TD]
[TD="class: xl82, width: 65, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl82, width: 73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl83, width: 309"]Input Data (Costs etc.)[/TD]
[TD="class: xl82, width: 73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[/TR]
[TR]
[TD="class: xl83"] [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl83"] [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[/TR]
[TR]
[TD="class: xl78, width: 157"]Month[/TD]
[TD="class: xl79, width: 65"]Demand[/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl63"]Item[/TD]
[TD="class: xl64"]Cost[/TD]
[/TR]
[TR]
[TD="class: xl80, width: 157"]January[/TD]
[TD="class: xl84"] 10,000 [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl65"]Materials cost/unit[/TD]
[TD="class: xl66, bgcolor: silver"] $ 40 [/TD]
[/TR]
[TR]
[TD="class: xl80, width: 157"]February[/TD]
[TD="class: xl84"] 11,000 [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl67"]Inventory holding cost/unit/month[/TD]
[TD="class: xl71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] , align: right"]3.0[/TD]
[/TR]
[TR]
[TD="class: xl80, width: 157"]March[/TD]
[TD="class: xl84"] 15,000 [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl67"]Marginal cost of stockout/unit/month[/TD]
[TD="class: xl68, bgcolor: silver"] [/TD]
[/TR]
[TR]
[TD="class: xl80, width: 157"]April[/TD]
[TD="class: xl84"] 18,000 [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl67"]Hiring and training cost/worker[/TD]
[TD="class: xl68, bgcolor: silver"] [/TD]
[/TR]
[TR]
[TD="class: xl80, width: 157"]May[/TD]
[TD="class: xl84"] 25,000 [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl67"]Layoff cost/worker[/TD]
[TD="class: xl68, bgcolor: silver"] [/TD]
[/TR]
[TR]
[TD="class: xl80, width: 157"]June[/TD]
[TD="class: xl84"] 26,000 [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl67"]Labor hours required/unit[/TD]
[TD="class: xl73, bgcolor: silver, align: right"]2.0000[/TD]
[/TR]
[TR]
[TD="class: xl81, width: 157"]July[/TD]
[TD="class: xl84"] 30,000 [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl67"]Regular time cost/hour[/TD]
[TD="class: xl72, bgcolor: silver, align: right"]15.0[/TD]
[/TR]
[TR]
[TD="class: xl81, width: 157"]August[/TD]
[TD="class: xl84"] 29,000 [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl67"]Over time cost/hour[/TD]
[TD="class: xl71, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=99CCFF]#99CCFF[/URL] , align: right"]22.0[/TD]
[/TR]
[TR]
[TD="class: xl81, width: 157"]September[/TD]
[TD="class: xl84"] 21,000 [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl69"]Marginal subcontracting cost/unit[/TD]
[TD="class: xl70, bgcolor: silver"] [/TD]
[/TR]
[TR]
[TD="class: xl81, width: 157"]October[/TD]
[TD="class: xl84"] 18,000 [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[/TR]
[TR]
[TD="class: xl81, width: 157"]November[/TD]
[TD="class: xl84"] 14,000 [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl74"]Initial Workforce size[/TD]
[TD="class: xl76, align: right"]250[/TD]
[/TR]
[TR]
[TD="class: xl81, width: 157"]December[/TD]
[TD="class: xl84"] 11,000 [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl75"]Maximum overtime per worker per month[/TD]
[TD="class: xl77, align: right"]20[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl74"]Starting inventory ('000s)[/TD]
[TD="class: xl76, align: right"]50[/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl82, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] "] [/TD]
[TD="class: xl75"]Ending inventory ('000s)[/TD]
[TD="class: xl77, align: right"]50[/TD]
[/TR]
</tbody>[/TABLE]