# Thread: max profit and objective functions

1. ## max profit and objective functions

Okay, basically, what combination of these wooden tables would provide the greatest profit (see attached image)? I need an objective function and then some other functions with constraints to put into MS Excel I guess, it seems so easy but it's not clickin...any help is appreciated.

2. Originally Posted by strangiatotheme
Okay, basically, what combination of these wooden tables would provide the greatest profit (see attached image)? I need an objective function and then some other functions with constraints to put into MS Excel I guess, it seems so easy but it's not clickin...any help is appreciated.
Let P, Q, R and S denote the number of units of each model produced per
month.

Then the profit:

Pr=35*P+40*Q+20*R+50*S.

This is your objective to be maximised.

Constraints:

P>=0, Q>=0, R>=0, S>=0.

cutting constraint:

P+2*Q+2*R+3*S<=200

I will leave the assembly and painting constraints for you to fill in.

RonL

3. Hello, strangiatotheme!

Let w = number of model A
Let x = number of model B
Let y = number of model B (unpainted)
Let z = number of model C
. . w, x, y, z . .0

Read down the columns to get the inequalities:
. . . w + 2x + 2y + 3x . .200
. . 2w + 4x + 4y + 7z . .300
. . 4w + 4x + 0y + 5z . .150

Objective: .P .= .35w + 40x + 20y + 50z

4. Thanks a bunch, guys. Just had the report submitted so hopefully the essay part of this went well also...