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 Problem Solver

I posted a week or so ago and have been successful based on the response I
got. I have a new but similar question that i am trying to solve for with
another layer of complexity:
I Know that it took 6980 hrs to produce the volume below.

ND take twice as long as R and R takes twice as long as M to do. (4T, 2T, T)
I also know that:
based on Coll Complex 1 takes less time then 2 and 2 takes less time then 3
and 3 takes less time then 4.
I also know that:
ND1 1 takes less time then ND 2 which takes less time then 3
same with R items and M items

based on the volume of each type, how long does each type take? can solver
do this?

ND - 1 ND - 2 ND - 3
Coll Complex 1 18 9 9
Coll Complex 2 9 5 5
Coll Complex 3 9 5 5
Coll Complex 4 15 7 7

RD 1 RD 2 RD 3
Coll Complex 1 30 15 15
Coll Complex 2 5 3 3
Coll Complex 3 10 5 5
Coll Complex 4 12 6 6

M 1 M 2 M 3
Coll Complex 1 37 19 19
Coll Complex 2 7 3 3
Coll Complex 3 12 6 6
Coll Complex 4 15 7 7


 
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 problem Alexey[_2_] Excel Worksheet Functions 4 March 21st 08 09:05 AM
problem with solver Ana Excel Discussion (Misc queries) 0 August 10th 06 05:23 PM
Interesting Solver problem (Solver encounters an error) MrShorty Excel Discussion (Misc queries) 3 December 22nd 05 10:52 PM
solver problem Peter Bennell Excel Worksheet Functions 1 September 20th 05 09:07 PM
IF problem using Solver [email protected] Excel Worksheet Functions 5 July 7th 05 02:11 PM


All times are GMT +1. The time now is 05:36 PM.

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"