Search results

Hi Faseeh, You rock man!! The solution you gave is perfect!!! I could incorporate it to my actual datasheet successfully! :-) Thanks a ton for helping me out! Regards, Gaurav

Hi Faseeh, No worries!! Rather, thank you for taking it that far... I am testing it using my actual data that has got like 5-6 companies and 50 products.. Will get back to you shortly.. Actually, my actual data is in the form of the table. So entering the data manually in the matrix would be...

Hi Faseeh, We can be black and white in this case.. Even if the price difference is as little as 0.0001, we will assume, sales will go to the one offerring lower price. I agree with you that practically this will not influence any customer to buy a lower price product, but for the model I am...

Hi SirJB7, That was one of a formula...For a while, I thought my screen has got corrupt.. :-) Hi Faseeh, gewbruldvu@hotmail.com is not my id. What happened? I went through the solution. It is working perfectly fine but only when the Selling prices are different. May be I am not able to...

Thank you so much Faseeh! I am going through the solution. Apparently it seems you have still considered the aggregate demand. As I corrected in my last to last post - The demand is at product level (and not company-product level). So the demand for P1 is actually 50. That means all the...

Hi Faseeh, Wondefull! I went through the solution and it is exactly what I was looking for. Moreover, I could edit the excel you shared as per the demand mentioned in my previous post and the solution seems to work perfect!! https://docs.google.com/open?id=0B-9U8UiqGA_GQm5nY3BzZnh0eXM But...

Hi Faseeh! Quick one- Actually demand is as follows: P1- 50 P2- 39 P3- 12 P4- 14 P5- 61 P6- 35 As I had mapped against each pair of (company,product); it got interpreted as individual demand. So please just refer to the demand as above and do not take the aggregate. I hope that...

Hi Faseeh ! Surely. If possible, you can also drop me an email at mech.gaurav@gmail.com for a quickest reply. Thanks. Gaurav

Hi Faseeh! Thanks for the welcome and going through the problem . You can download the excel layout from below:- https://docs.google.com/file/d/0B-9U8UiqGA_GNFdlS1kybTVoT1U/edit?pli=1 I need the output that simply shows how much sales would happen for each product in each company. I have...

Hi All, I am desperately looking a way to solve this in excel: There are 3 companies in the market. C1,C2,C3. Each company has multiple products. Some products are unique and some are sold by other companies also. Sample portfolio: C1 - P1,P2,P3 ; C2- P1,P2,P5 ; C3- P1, P6,P4. The companies...