LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 106
Default Can I use solver for this?

I am not sure the best way to solve my problem and am hoping someone can help.

I want to be able to determine approx how long each item takes to produce.
I have types of work new, renewal and mod - and then a complexity level.
I know that it took 6980 total hrs to produce all of these items.

Assumptions that i wanted to build in:
New items take twice as long as renewals and 4 times as long as mods.
Hard items take longer then medium items and medium take longer then easy.

Totals
NEW RENEWAL MOD
EASY 53 71 87
MEDIUM 18 19 24
HARD 29 24 29


Total Hrs 6980

Is this the type of problem solver can help with, or is there aneasier way?

 
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
Solver Tiffany Excel Discussion (Misc queries) 0 October 15th 06 06:21 AM
Interesting Solver problem (Solver encounters an error) MrShorty Excel Discussion (Misc queries) 3 December 22nd 05 10:52 PM
Solver Saxman Excel Discussion (Misc queries) 2 November 3rd 05 12:41 PM
solver [email protected] Excel Discussion (Misc queries) 0 May 20th 05 06:34 PM
Solver Jake Excel Discussion (Misc queries) 0 May 18th 05 10:20 PM


All times are GMT +1. The time now is 10:42 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"