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

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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
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;
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

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 Right Arrow Icon
Ask a homework question - tutors are online