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!!!
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!!!