LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Linear Programming(solver ?)

Hello, I am new to this group and hope you can help me. I have a
problem that I am trying to solve.
I am trying to use solver but not sure if I am setting up the model
correctly.

I have 4 workers Sam, Avery, Ben, and Steve and 4 different duties
(Engine, Trans, Alignment, & Brakes) that the can be performed. Each
person has a different average time(mins) to complete each task. I am
trying to develop the formula to optimize who should do what to get the
lowest amount of time.


Engine Transmission Alignment Brakes
Sam 45 34 23 45
Avery 48 30 36 37
Ben 30 48 40 41
Steve 38 34 30 31


Thoughts on the formula and contraints?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linear Programming via Excel Solver Squadron Excel Discussion (Misc queries) 1 December 5th 08 04:48 PM
Binary integer non-linear programming excel solver premium Gary[_3_] Excel Worksheet Functions 3 September 14th 08 07:58 AM
Binary integer non-linear programming excel solver Gary[_3_] Excel Discussion (Misc queries) 0 September 12th 08 07:38 PM
Binary integer non-linear programming excel solver Gary[_3_] Excel Worksheet Functions 0 September 12th 08 07:35 PM
Binary integer non-linear programming excel solver premium Gary[_3_] Excel Worksheet Functions 0 September 10th 08 06:46 PM


All times are GMT +1. The time now is 08:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"