A Two-Variable Product Mix Model - Using Solver Tool

moe10134

Board Regular
Joined
Sep 8, 2005
Messages
162
Office Version
  1. 2019
Platform
  1. Windows
Hello everyone,

I need help answering this question in the Solver Tool. I'm not sure how to set up the table, define the constraints, and what formulas to use? Simple LP

During the next four months, a customer requires, respectively, 600, 800, 1,200, and 900 units of a commodity, and no backlogging is allowed (that is, the customer's requirements must be met on time). Production costs are $80, $100, $105, and $90 per unit during these months. The storage cost from one month to the next is $20 per unit (assessed on ending inventory). It is estimated that each unit on hand at the end of month 4 can be sold for $60. Assume there is no beginning inventory. Determine how to minimize the net cost incurred in meeting the demands for the next four months.

What is the optimized net cost?

Use SolverTable to see what happens to the decision variables and the total cost when the initial inventory varies from 0 to 1,000 in 100-unit increments. How much lower would the total cost be if the company started with 100 units in inventory, rather than none?

All your help is appreciated!

moe10134
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Forum statistics

Threads
1,212,927
Messages
6,110,726
Members
448,294
Latest member
jmjmjmjmjmjm

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
Back
Top