# Optimum production on Excel Solver

#### KylieR

##### New Member
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?

 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>

### Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

#### oldbrewer

##### Well-known Member
taking july demand of 30000 this is presumably based on historical data and might be anywhere between 27000 and 33000 ?

Replies
4
Views
328
Replies
5
Views
441
Replies
2
Views
214
Replies
0
Views
157
Replies
1
Views
288

1,130,205
Messages
5,640,837
Members
417,173
Latest member
Tuanphun

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back