LP_ModelsExplained1

LP_ModelsExplained1 - WorkshopsProblem Time Demand...

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

View Full Document Right Arrow Icon
Paint Problem 2 4 Raw material 1 1 1 6 <= 6 Raw material 2 2 1 8 <= 8 £3,000.00 £2,000.00 £14,000.00 Please notice the use of named ranges to make the model more readable. Paint 1 produced Paint 1 produced Resources used Resource s available Price per tonne of paint
Background image of page 1

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

View Full DocumentRight Arrow Icon
Furniture Problem #desks #tables #chairs 2 0 8 Lumber 8 6 1 24<= 48 4 2 1.5 20<= 20 2 1.5 0.5 8<= 8 1 0<= 5 £60.00 £30.00 £20.00 280 Resources used Resources available Skilled labour Unskilled labour Demand for tables Price per unit FurnitureResourcesAvailable FurnitureResourcesUsed UnitsProduced (DesisionVariables)
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: WorkshopsProblem Time Demand Workshop1 Workshop2 Workshop3 Product1 £108.00 10 5 9 7 £58.00 Product2 £84.00 8 10 2 5 £44.00 Cost of labour/hour £5.00 Optimisation Model Time used Workshop1 Workshop2 Workshop3 Product1 4 20 36 28 £232.00 Product2 2 20 4 10 £88.00 Totals 40 40 38 £320.00 Available (<=) 40 40 40 Price per unit Labour Demand Profit per unit Number of units to produce Profit Earned Notice the use of mixed references here...
View Full Document

This note was uploaded on 10/24/2011 for the course ECONOMICS 30112 taught by Professor Ahfdka during the Spring '11 term at Coventry.

Page1 / 3

LP_ModelsExplained1 - WorkshopsProblem Time Demand...

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

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