All the formulas of Kapilands.

Here is enough space for all players to ask questions about the game.

Moderator: moderators

Guest

All the formulas of Kapilands.

Post by Guest »

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
Last edited by Guest on 17.04.2009, 17:36, edited 5 times in total.
Guest

Re: All the formulas of Kapilands.

Post by Guest »

[quote="SiberianTiger"][list=1]
[*]Production cost per unit[/list][/b]

Formula: Unit Cost = Product Cost Factor x Area Cost Factor
Guest

Re: All the formulas of Kapilands.

Post by Guest »

[quote="sergiurocks506"][quote="SiberianTiger"][list=1]
[*]Production cost per unit[/list][/b]

Formula: Unit Cost = Product Cost Factor x Area Cost Factor
Guest

Re: All the formulas of Kapilands.

Post by Guest »

Nice formulas there, although gas is spelt "gas" not "gaz". :P
Last edited by Guest on 19.04.2009, 10:18, edited 1 time in total.
Guest

Re: All the formulas of Kapilands.

Post by Guest »

tiger, a great list of useful fomulas!
I'm a mathematician and I enjoy all these numbers :)
Guest

Post by Guest »

I removed the finally unneccessary postings after I adapted a special posting. So please go back to these numbers again. :)

@ SiberianTiger:
It would be interesting how you managed to figure those numbers out. ;)
Try and error? Observation? :D
Guest

Post by 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

Post by 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
Guest

Post by Guest »

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
Same problem around here. 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

Post by 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

Post by 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 :D
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

Post by Guest »

Also the level influences the speed of sales in the stores. :)
The higher your level the slower your sales.

Yet this has a very small influence on the sales and I do not have got any numbers for it.
Guest

Post by 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
Guest

Post by 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
Guest

Post by Guest »

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
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).
Post Reply