# max profit and objective functions

• Sep 28th 2006, 03:06 AM
strangiatotheme
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.
• Sep 28th 2006, 03:38 AM
CaptainBlack
Quote:

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
• Sep 28th 2006, 03:45 AM
Soroban
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

• Sep 28th 2006, 06:23 AM
strangiatotheme
Thanks a bunch, guys. Just had the report submitted so hopefully the essay part of this went well also...