Solver Question - Optimization

analystNJ_17

New Member
Joined
Jan 21, 2015
Messages
1
Hi Everyone,

I can't seem to figure this out. We use four different box sizes - XSmall, Small, Med, Large. I want to figure out how many of each carton we will use in 2015 based on the number of units we're shipping.

Each box size can hold the following # of units.

X-Small: 4 Units
Small: 6 Units
Medium: 10 Units
Large: 15 Units

How can I determine how many X-Small, Small, Medium, & Large boxes to use? I think solver would be the best way but I can't seem to figure out how to get it to work - it seems to just assign all the units to one size.

Thank you!!!
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Forum statistics

Threads
1,216,028
Messages
6,128,395
Members
449,446
Latest member
CodeCybear

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