Lecture 2 Spreadsheet - $5.00 $8.00 $4.00 $7.00 Demand(lbs...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Inputs Month 1 Month 2 Month 3 Month 4 Unit production costs $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 0 0 0 0 lbs stored/sold 0 0 0 0 lbs donated 0 0 0 0 Objective function Net cost to be minimized Constraints Month 1 Month 2 Month 3 Month 4 Lbs available from orders/storage = = = = Lbs delivered/stored/donated Ordering Capacity constraints and Nonnegativity constraints specified within Solver
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Inputs Month 1 Month 2 Month 3 Month 4 Unit production costs
Background image of page 2
This is the end of the preview. Sign up to access the rest of the 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

{[ snackBarMessage ]}

Page1 / 2

Lecture 2 Spreadsheet - $5.00 $8.00 $4.00 $7.00 Demand(lbs...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online