Optimum production on Excel Solver

KylieR

New Member
Joined
Sep 27, 2018
Messages
2
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.)
MonthDemand ItemCost
January 10,000 Materials cost/unit $ 40
February 11,000 Inventory holding cost/unit/month3.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/unit2.0000
July 30,000 Regular time cost/hour15.0
August 29,000 Over time cost/hour22.0
September 21,000 Marginal subcontracting cost/unit
October 18,000
November 14,000 Initial Workforce size250
December 11,000 Maximum overtime per worker per month20
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
Joined
Apr 11, 2010
Messages
11,004
taking july demand of 30000 this is presumably based on historical data and might be anywhere between 27000 and 33000 ?
 

Watch MrExcel Video

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top