All the formulas of Kapilands.
Moderator: moderators
-
Guest
All the formulas of Kapilands.
Just started this new post to put some order in this information (new formulas will be added - still missing the calculations for the time it takes to sell on stores)
1. Production cost per unit
Formula: Unit Cost = Product Cost Factor x Area Cost Factor
1. Production cost per unit
Formula: Unit Cost = Product Cost Factor x Area Cost Factor
Last edited by Guest on 17.04.2009, 17:36, edited 5 times in total.
-
Guest
Re: All the formulas of Kapilands.
[quote="SiberianTiger"][list=1]
[*]Production cost per unit[/list][/b]
Formula: Unit Cost = Product Cost Factor x Area Cost Factor
[*]Production cost per unit[/list][/b]
Formula: Unit Cost = Product Cost Factor x Area Cost Factor
-
Guest
Re: All the formulas of Kapilands.
[quote="sergiurocks506"][quote="SiberianTiger"][list=1]
[*]Production cost per unit[/list][/b]
Formula: Unit Cost = Product Cost Factor x Area Cost Factor
[*]Production cost per unit[/list][/b]
Formula: Unit Cost = Product Cost Factor x Area Cost Factor
-
Guest
Re: All the formulas of Kapilands.
Nice formulas there, although gas is spelt "gas" not "gaz". 
Last edited by Guest on 19.04.2009, 10:18, edited 1 time in total.
-
Guest
Re: All the formulas of Kapilands.
tiger, a great list of useful fomulas!
I'm a mathematician and I enjoy all these numbers
I'm a mathematician and I enjoy all these numbers
-
Guest
-
Guest
Well, first of all I needed to figure out what were the variables, as Area Factor, Products Cost and so on. After that using Excel and its high capabilities of calculation (using solver) both accounts (one in R1 and other on R2) and Kapitools I have done thousands of tries and errors. The formulas 3 and 4 were find on this forum. I would appreciate that if anyone around here find out some error that post it.
-
Guest
I have done some work on store pricing using excell but found that its far to variable with external S&D factors as well as avg price I'm very interested to know if you have found a link between these or just worked on trial/error for data, I have to redo each price every 2 days to stay anywere near current and as of yet no forumla has surfaced.
H
H
-
Guest
Same problem around here. At this moment I know that to handle a model for the sales, I should have the following variables:Horizon Holdings wrote:I have done some work on store pricing using excell but found that its far to variable with external S&D factors as well as avg price I'm very interested to know if you have found a link between these or just worked on trial/error for data, I have to redo each price every 2 days to stay anywere near current and as of yet no forumla has surfaced.![]()
H
- Average price in Country of my Sales Stores
- Average quality in Country of my Sales Stores
- Total Supply in Country of my Sales Stores
- My supply to the market in Country of my Sales Stores
- Demand on the market in Country of my Sales Stores
- Total Employess on my Sales Store
- Quality of my products to be sold
- Area in m
-
Guest
[quote="SiberianTiger"] At this moment I know that to handle a model for the sales, I should have the following variables:
- Average price in Country of my Sales Stores
- Average quality in Country of my Sales Stores
- Total Supply in Country of my Sales Stores
- My supply to the market in Country of my Sales Stores
- Demand on the market in Country of my Sales Stores
- Total Employess on my Sales Store
- Quality of my products to be sold
- Area in m
-
Guest
What Greed and Tiger both said is right to some extent. Greed I think that we need to go into full depth or we cant apply it universally. We need to figure out the way the price mech works not just the optimal price for any one Q.
We first need the data for at least 5 different Qs pref Q0 Q1 Q2 Q5 and Q10 for several products ranging across different store types to cross-check if they all work the same over a period of time with the price and Q the same to see the effect of AVG price/Q
Fortunately due to the static nature of store size we can allow many different people to provide their own data based on a store size of 20m2 so if they filled in the folowing:
AVG Q at time of sale:
AVG Price at t.o.s:
S/D at tos:
Your Q:
Your Price:
Time Ratio(time/amount/(store size/20):
Your lvl:
If we can hold Q+Price and one of the AVGs steady we can work out a relationship and from there finding a pattern is the easy part. We also want to find a formula to work out, given the AVG Price/Q and your Q, the optimal price for profit per minute (factoring for cost price) as well as being able to see how much X product will sell for within y hours ect ect.
To get this 2 approaches are needed. We need a less detailed list of changes to pricing over time to see the AVGs effect and also a highly detailed look at the differences between prices and time (x will sell in 10c in 1h, sells for 20c in 2h20m, sells for 30c....) and join this with the first to achieve a 'working' formula that can actually be used by the whole of kapilands. If we can get this down I would be an incredible addition to kapitools. Or we could just bribe the developers to give us the formula
Tell me what you think
Nice work on the rest of the formulas Tiger BTW
H
We first need the data for at least 5 different Qs pref Q0 Q1 Q2 Q5 and Q10 for several products ranging across different store types to cross-check if they all work the same over a period of time with the price and Q the same to see the effect of AVG price/Q
Fortunately due to the static nature of store size we can allow many different people to provide their own data based on a store size of 20m2 so if they filled in the folowing:
AVG Q at time of sale:
AVG Price at t.o.s:
S/D at tos:
Your Q:
Your Price:
Time Ratio(time/amount/(store size/20):
Your lvl:
If we can hold Q+Price and one of the AVGs steady we can work out a relationship and from there finding a pattern is the easy part. We also want to find a formula to work out, given the AVG Price/Q and your Q, the optimal price for profit per minute (factoring for cost price) as well as being able to see how much X product will sell for within y hours ect ect.
To get this 2 approaches are needed. We need a less detailed list of changes to pricing over time to see the AVGs effect and also a highly detailed look at the differences between prices and time (x will sell in 10c in 1h, sells for 20c in 2h20m, sells for 30c....) and join this with the first to achieve a 'working' formula that can actually be used by the whole of kapilands. If we can get this down I would be an incredible addition to kapitools. Or we could just bribe the developers to give us the formula
Tell me what you think
Nice work on the rest of the formulas Tiger BTW
H
Last edited by Guest on 19.04.2009, 08:38, edited 1 time in total.
-
Guest
-
Guest
Thanks gold, post ammended
If the change is measured in minutes (additional to 24h) we can get away with it as the difference will be tiny but if its above 15 mins or so we will have to take it into acount. Do you know if the change corralates to production changes in any way? It would be eaiser if we can work off a know variable.
My first timing: 19/04/09(Gold Necklaces)
AVG Q: 12.55
AVG Price: 8863
S/D: 25,228
Your Q: 12
Your Price: 8000
Time Ratio(34h58m/200/(500/20)=0.007
Your lvl: Large Scale Manufacturer
Note im working off minutes then devided the answer by 60.
H
If the change is measured in minutes (additional to 24h) we can get away with it as the difference will be tiny but if its above 15 mins or so we will have to take it into acount. Do you know if the change corralates to production changes in any way? It would be eaiser if we can work off a know variable.
My first timing: 19/04/09(Gold Necklaces)
AVG Q: 12.55
AVG Price: 8863
S/D: 25,228
Your Q: 12
Your Price: 8000
Time Ratio(34h58m/200/(500/20)=0.007
Your lvl: Large Scale Manufacturer
Note im working off minutes then devided the answer by 60.
H
-
Guest
I think this applies to what is being discussed here. Very high-level, but it could help.
http://www.forum.kapilands.com/viewtopic.php?t=17903
http://www.forum.kapilands.com/viewtopic.php?t=17903
-
Guest
Tks, but doesn't work, I have tried with severall diferent products and never got close values (On that post I have an example with wardrobes).bamse wrote:I think this applies to what is being discussed here. Very high-level, but it could help.
http://www.forum.kapilands.com/viewtopic.php?t=17903
