#Calc - Taken - Stats Problem. Many Probabilities, and many constraints.
61 messages · Page 1 of 1 (latest)
I completely forgot COSTS for each of the 14: they are here:
1 at the top, 14 all the way at the bottom. num in green as cost per unit they are willing to pay for (x) amount of demand seen in data.
per unit*
Hello,
This is very difficult to understand
What's the relationship between the two tables you sent
one is the values it costs to "Research and develop" a product with those characteristics or "ranks" the customer has requirements on
The first table seems to have 14 ranked objects
But why is the rank 14 more expensive ?
Is it more like "tier 1" to tier 14 ?
14 being the best?
the other table is the cost of production lines for manufacturing the said amount of units you will need, with the amount poer hour it can do and the pricepoint.
there are 14 of these places, thats why there is 14. difference in value is a coincedence.
as u can see, 11 has over 2million units of unmet demand
being definitely the largest source of income if you met their requirements
need to figure out which combination of ranks makes the most money based on price per unit * unmet demand , factoring in cost for RnD the said level of ranks you would need, factoring in the cost for a corresponding production line that would be feasible.
I still dont understand the problem
What are you seeking to minimize
And under what constraints
Explicitly
It's too out of context
Maybe for you its clear, but we have no idea what the context is
This is the cost for what ?
Arent the other 4 columns costs ?
Since you seem to have them ranked decreasingly
no random
also those are the costs per unit
for each of the 14 places
descending 1 to 14
that they would buy from the business who would produce the units
they are "customer hubs" analyizing the entirety of a city
analyzes the demand of the city as a whole?
but they all have only ONE reuqirement based on those 4 ranks
place 1 wants rank 1 res, 3 sensitivity, 1 power efficiency, and 1 temp. so they barely have any requirements, other than the product needs to have moderate investment in light sensitivity.
and developing rank 3 light sense costs 1.1 million dollars
according to the table
developing the 3 other qualities in the product would take roughly 171k + 171k + 440k
There arent 14 places then
There are 4 places we need to compare
and then we can supply the unmet demand they have at that price per unit. and that is revenue
4 lines of production
It is extremely
Confusing
Not because the problem is hard
But because you have not presented things from the start
of course. Well, I am going to get back to trying to find solution coding. Have good day, do not confuse yourself more.
Perhaps someody else will understand me better, I am a poor explainer
rewriting all this would be quite the headahce
After all it's your choice
I've been genuinely trying to understand
I know. And I dont think You can help me, given I have done a bad job explaining. Leave it here for someone else to read i suppose
Well if you cannot bother to clarify further
You cannot expect your readers to make more effort than you on your own problem
And if you somehow do, you could at least not get offended by some well-meaning, honest feedback
of course not, which is why i politely asked you to walk away. I appreciate the time you did take. I have spent 5 hours coding on this problem
luckily nobody was offended
Okay ...
That's exactly it: you are familiar with the problem but we are not
So some things which may be obvious by now for you, are not for those seeing the problem for the first time
just for you daddy, since you are so determined. I will spend the next 20 minutes rewriting everything.