Scribd
Upload
6 views6 pages

Optimization Models for Paint and Furniture

fnwgn gwgnkgngnang ggaggg ggg ggnsggnsg weihwoighwogwogwoggwogwogw gwengwneogn wognwognwognewgwoignw oignwong ongwognwongwongopw ignwngngngnwpg

Uploaded by

Michael
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
6 views6 pages

Optimization Models for Paint and Furniture

fnwgn gwgnkgngnang ggaggg ggg ggnsggnsg weihwoighwogwogwoggwogwogw gwengwneogn wognwognwognewgwoignw oignwong ongwognwongwongopw ignwngngngnwpg

Uploaded by

Michael
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd

Paint Problem

Paint 1
produced
Raw material 1
Raw material 2

Paint 1
produced
2
1
2

Resource
s
available

Resources
used
4
1
1

6 <=
8 <=

6
8

Price per
tonne of paint 3,000.00 2,000.00 14,000.00

Please notice the use of named ranges to make the model more

NOTICE that the demand constraints are MISSING in this mo

s to make the model more readable.

s are MISSING in this model modification.

Furniture Problem
UnitsProduced (DesisionVariables)

#desks

#tables

Resources
used

#chairs

Lumber

24

Skilled
labour

1.5

20

1.5

0.5

Unskilled
labour
Demand
for tables
Price
per unit

1
60.00

30.00

0
20.00

280

FurnitureReso

Resources
available
<=

48

<=

20

<=

<=

FurnitureResourcesAvailable

FurnitureResourcesUsed

WorkshopsProblem
Time Demand

Product1
Product2

Price
Labour
per unit
Demand Workshop1 Workshop2 Workshop3
108.00
10
5
9
7
84.00
8
10
2
5
Cost of labour/hour
5.00

Optimisation Model
Time used
Number of
units to
produce
Product1
Product2

Notice the use of mixed references


here

4
2

Workshop1 Workshop2 Workshop3


20
36
28
20
4
10
Totals
40
40
38
Available (<=)
40
40
40

Profit
per unit
58.00
44.00

Profit
Earned
232.00
88.00
320.00

You might also like