Activity 6 : « Tables and chairs » model – Reading an output file

Length : around 10 minutes

The following file corresponds to the model developed using GAMS of the optimization of resources in a small or medium-sized company that produces tables and chairs : tablesAndChairs.zip
Download it
.  It corresponds to the following problem statement :

A company sells chairs and small tables which it produces using a stock of 16 wood units, 10 fabric units, and employs a worker for 40 hours of labour.

1 chair requires : 1 hour of labour, 1 wood unit, 1 fabric unit

1 table requires : 4 hours of labour, 1 wood unit.

A chair costs 15€, a table costs 30€. Determine the production of chairs and tables which makes it possible to maximize the company turnover.”

Once you have unzipped it, open GAMS and run the model, answer the following questions.

What is the result of the goal function ?

How many chairs will be made ?

How many tables will be made ?

What is the marginal value of the wood ?

What is the marginal value of labour ?

What is the maximum which the fabric value can reach ?

What is the optimum value reached by the labour variable ?

#################

The following file corresponds to the model developed using GAMS of the optimization of resources in a small or medium-sized company that produces tables and chairs : tablesAndChairs.zip
Download it
. Once you have unzipped it, open GAMS and run the model. It corresponds to the following problem statement :

A company sells chairs and small tables which it produces using a stock of 16 wood units, 10 fabric units, and employs a worker for 40 hours of labour.

1 chair requires : 1 hour of labour, 1 wood unit, 1 fabric unit

1 table requires : 4 hours of labour, 1 wood unit.

A chair costs 15€, a table costs 30€. Determine the production of chairs and tables which makes it possible to maximize the company turnover.”

Answer the questions : click on “Start Quiz”