All the formulas of Kapilands.
Moderator: moderators
-
Guest
-
Guest
Though I would reawaken this thread
I have had a small breakthrough and now have a format for any formula that works on sales prices
(e^(-16.4423226099 + 3.13196777589 * ln(x)))60/60 = time in hours for any given price
e^(5.24987382398 + 0.319284870704 * ln(x)) = price given a time in seconds
This was a copy from my own jewellery store and can
I have had a small breakthrough and now have a format for any formula that works on sales prices
(e^(-16.4423226099 + 3.13196777589 * ln(x)))60/60 = time in hours for any given price
e^(5.24987382398 + 0.319284870704 * ln(x)) = price given a time in seconds
This was a copy from my own jewellery store and can
-
Guest
I can only see one problem with that formula is that it only works for today as every single stats price generated seems to have its own base selling time from my experience.
So that if the average price for diamond rings @ 4500 caps is 3000 second per a ring when the average price is @6000 the base will be something like 3750 per a unit.
I'll have another go at calculated these formulas* after this weekend
* the 4 formulas we need are
- Price formula (I'll be sticking with (A/B)^3.2)
- Quality (its a 2 piece function from all the graphs I have generated)
- Supply % formula
- Base Price formula
So that if the average price for diamond rings @ 4500 caps is 3000 second per a ring when the average price is @6000 the base will be something like 3750 per a unit.
I'll have another go at calculated these formulas* after this weekend
* the 4 formulas we need are
- Price formula (I'll be sticking with (A/B)^3.2)
- Quality (its a 2 piece function from all the graphs I have generated)
- Supply % formula
- Base Price formula
-
Guest
Its a long way from perfect but its a far eaiser way to find perfect info with very little time wastage
I dont quite understand your base price idea, shoudent the time taken drop if the avg price rises? If your going were I think you are its a simple matter of taking my formula and / by the sample amount to get the taime taken per item.
Ill have a crack at working with (A/B)^3.2 see if I can make it work but in my exp it seems that S/D is a major factor on prices, I have seen AVG Price rise 4k but the price I had to sell at to clear my WH drop down 2k because Supply went up. As I said I just need info when each variable changes indipendantly. From there its a cake walk to get a formula togther.
H
I dont quite understand your base price idea, shoudent the time taken drop if the avg price rises? If your going were I think you are its a simple matter of taking my formula and / by the sample amount to get the taime taken per item.
Ill have a crack at working with (A/B)^3.2 see if I can make it work but in my exp it seems that S/D is a major factor on prices, I have seen AVG Price rise 4k but the price I had to sell at to clear my WH drop down 2k because Supply went up. As I said I just need info when each variable changes indipendantly. From there its a cake walk to get a formula togther.
H
-
Guest
The base idea is that if I were to sell diamond rings for 6000 when the stats price is 6000 it will take longer than if I were to sell them for 4500 when the stats price is 4500.
*Hope that somehow makes sense*
Also You may have noticed that regardless of the average price the same number of people find your products too expensive, the number for 50 find it inexpense tends to be the natural mid-point (I think its 6000 for diamond rings in Red, 3,600 for yellow 1,800 for green etc)
So I think the base selling time is a function of how many people find your goods expensive (there is a formula to work that out but I cant remember it) and the average selling price.
*Hope that somehow makes sense*
Also You may have noticed that regardless of the average price the same number of people find your products too expensive, the number for 50 find it inexpense tends to be the natural mid-point (I think its 6000 for diamond rings in Red, 3,600 for yellow 1,800 for green etc)
So I think the base selling time is a function of how many people find your goods expensive (there is a formula to work that out but I cant remember it) and the average selling price.