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

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

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

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

View Full Document
Inputs Month 1 Month 2 Month 3 Month 4 Unit production costs
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

## This note was uploaded on 03/17/2010 for the course IOE 202 taught by Professor Marinaepelman during the Fall '09 term at University of Michigan-Dearborn.

### 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
Ask a homework question - tutors are online