This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: $5.00 $8.00 $4.00 $7.00 Demand (lbs) 50 65 100 70 Monthly ordering capacity lbs) 80 Unit storage cost per month $2.00 (per lb) Unit resale price at the end of Month 4 $6.00 (per lb) Changing cells (variables) Month 1 Month 2 Month 3 Month 4 lbs ordered lbs stored/sold Objective function Net cost to be minimized Constraints Month 1 Month 2 Month 3 Month 4 Lbs available from orders/storage >= >= >= >= Lbs delivered/stored Ordering Capacity constraints and Nonnegativity constraints specified within Solver...
View Full Document
- Fall '09
- Harshad number, Ring, lbs, Objective function Net