Forum Discussion
Random number equal to constant K
Hello!
My client has given me the aggregate monthly sales details as follows:
GST Sales Taxable: INR 15,180
GST Sales Exempted: INR 21,65,500
There is no day wise breakup. However, to enter to an accounting software, I have to breakup the numbers. For e.g. in August, If I show the sales for 31days,
It would (21,65,500) average to INR 72,186. I wanted the range to be between INR 48,000-75,000.
I have used rand() formula, but, there is an unequal distribution ranging from INR 9,500 to INR 90,000.
I have seen certain YouTube tutorials describing the use of solver. However, I could not use it optimally to arrive at my solution.
I would appreciate, if anyone, could assist me with the use of solver to complete my answer. I have attached the file for your reference.
Thank you in anticipation.
P.S. INR=Indian Rupees
Created a small model, based on your example. Using RAND() and a few extra parameters, it splits the monthly sales figure (entered at the top in F2) into daily sales. You'll note that the range of amounts is not really between 48000 and 75000 but it will not be as dramatic as you described.
You can play around with the "Lower" and "Range" parameters to get a split that you find acceptable.
2 Replies
Created a small model, based on your example. Using RAND() and a few extra parameters, it splits the monthly sales figure (entered at the top in F2) into daily sales. You'll note that the range of amounts is not really between 48000 and 75000 but it will not be as dramatic as you described.
You can play around with the "Lower" and "Range" parameters to get a split that you find acceptable.
- Thank you Mr. Riny. I really appreciate your timely response. Your formula is really helpful & I will adopt it in all my future workings.
