MT%20#4%20AggPlan%20-%20W-2012

# MT%20#4%20AggPlan%20-%20W-2012 - MIDTERM#4 EXCEL/SOLVER...

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

MIDTERM #4 EXCEL/SOLVER Input Data RT Production Cost (\$/unit)= \$600 OT Production Cost (\$/unit)= \$850 Inv. Holding Cost (\$/unit/qr)= \$40 Backordering Cost (\$/unit)= \$300 Hiring Cost (\$/worker)= \$1,000 Layoff Cost (\$/worker)= \$1,400 RT Payroll Cost (\$/worker/qr)= \$2,500 Mat'l and OH Cost (\$/unit)= \$100 Optimal Aggregate Plan Constraint LHS Production (units) Ending Ending Workforce Invent. WF RT OT Quarter Demand RT OT Inventory Backorder Size # Hired # Fired Balance Balance Capacity Capacity 0 50 0 140 =0 =0 <=0 <=0 1 700 975 0 325 0 195 55 0 0 0 0 -195 2 1300 975 0 0 0 195 0 0 0 0 0 -195 3 1100 975 0 0 125 195 0 0 0 0 0 -195 4 850 975 0 0 0 195 0 0 0 0 0 -195 3950 3900 0 325 125 780 55 0 Total Relevant Cost = \$2,445,500

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

View Full Document
Midterm # 4 LINGO MODEL: [_1] MIN= 2500 * W1 + 2500 * W2 + 2500 * W3 + 2500 * W4 + 100 * R1 + 100 * R2 + 100 * R3 + 100 * R4 + 850 * O1 + 850 * O2 + 850 * O3 + 850 * O4 + 40 * I1 + 40 * I2 + 40 * I3 + 40 * I4 + 300 * B1 + 300 * B2 + 300 * B3 + 1000 * H1 + 1000 * H2 + 1000 * H3 + 1000 * H4 + 1400 * F1 + 1400 * F2 + 1400 * F3 + 1400 * F4;
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 03/16/2012 for the course OPM 325 taught by Professor Ruodu during the Spring '12 term at Drexel.

### Page1 / 2

MT%20#4%20AggPlan%20-%20W-2012 - MIDTERM#4 EXCEL/SOLVER...

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

View Full Document
Ask a homework question - tutors are online