All the formulas of Kapilands.

Guest · Post by **Guest** » 20.04.2009, 12:28

Yes everyone seems to be up in arms about knolls post

Maybe he lost a fews nuts and bolts while posting on the bare forums of other economic simulation games

Guest · Post by **Guest** » 20.04.2009, 12:36

Nice find and well done to Knolls if hes ever wandering by the spreat sheet will be usefull to copy at some point.
Quite frankly im still trying to work out how he came to find the 'retail time formula'. To the best of my understanding hes somehow working on static variables to work out time but I cant fathom how and his spread sheet wont show his formulas. The variable MUST be able to change as its been a long time since this was posted and we are on different worlds. I belive that he has lumped the avgs togther and asumed they wont change because at the time they dident change enough to make a difference especialy to only 1 item but x that by 100k for gas and you have a massive problem. Sorry but no ciguar

Guest · Post by **Guest** » 20.04.2009, 12:47

Well, I found his linked costs spreadsheet very useful and I've actually udes it as the core of my own one, so I thought he deserved some credit

Anyway, I'm trying it out with apples building up stores in different countries / zones. Selling apples of different qualities would let me test all factors involved in the sale process except from player level (which is obviously fixed) and advertisements (which however I could try later).

This should give me an idea on how apples sell in different circumstances and possibly work out a basic factor for apples and related formula. I wonder if there is a direct relationship with the production rate.

Guest · Post by **Guest** » 20.04.2009, 12:52

Thats the idea

I would be interestd to know how kapitools got their data. bam can you send my your data? and have you mamaged to find a time were only one of the AVG factors changed? so we can compare

Guest · Post by **Guest** » 20.04.2009, 14:00

Here are the data on apples. I will try to find a product where D&S or AVG prices and quality are similar in the same zone.

Btw, is there a way to get a tabulated text without editing manually the text? I have spent the last 30 minutes to try to give a decent format to the table below and I can't say that it's my idea of quality time!

Code: Select all

--------------Demand----Supply--Price--Quality--Units----Employees-avg price-avg quality-Adverts-------Time------------------Seconds
Germany-------99258600--401273--6------0--------100------1---------5.4-------2.18--------0-------------3 h. 52 min. 57 sec---13977
France--------40805960--461955--6------0--------100------1---------8.25------3.7---------0-------------2 h. 46 min. 30 sec---9990
Saudi Arabia--40805960--461955--6------0--------100------1---------3.98------1-----------0-------------17 h. 23 min. 44 sec -62624
Congo---------27115140--2092----6------0--------100------1---------8.25------3.7---------0-------------116 h. 51 min. 33 sec-420693
Germany-------99258600--401273--6------4--------100------1---------5.4-------2.18--------0-------------1 h. 11 min. 53 sec---4313
France--------40805960--461955--6------4--------100------1---------8.25------3.7---------0-------------1 h. 27 min. 25 sec---5245
Saudi Arabia--40805960--461955--6------4--------100------1---------3.98------1-----------0-------------5 h. 24 min. 54 sec---19494
Congo---------27115140--2092----6------4--------100------1---------8.25------3.7---------0-------------31 h. 50 min. 24 sec--114624

Guest · Post by **Guest** » 20.04.2009, 14:44

Ok i was bored again and did the following: I tested selling time for wardrobes of different qualities (q24,q26,q29,q30 and q37) at different selling prices. Heres a plot of the results (its 3D plot so its a bit harder to read and/or show in a way one can see the plot)

I then approximated the data with a plot of form p(x)*q(y), where p gives us the dependance of selling time on quality and q(y) gives dependance of selling time on retail price. With this approximation (which gave me quite good dependance) i then calculated the hourly profits per worker with respect to both selling price and quality (of course considering that we bought the wardrobes at 2200+50q)

Again, this is a 3D plot so it isnt very clear but gives the basic idea.

However, the interesting thing i got from my calculations is the dependance of optimal price with respect to the quality of wardrobes. Here is its graph:

Which finally enables us to calculate the maximum profit (per employee per hour) in my shop (note that stats price was 3.703,79

Guest · Post by **Guest** » 20.04.2009, 15:43

That's brilliant.

It would be good to have the formulas to see how they compare in different markets and get at least an idea of how relevant are the environmental factors (e.g. avg price/q, supply/demand).

Guest · Post by **Guest** » 21.04.2009, 00:40

Message mostly to bam
Can you get the numbers for Q0,1,2,3,4,5,10 on apples and keep the price/country the same? I cant seem to get enough Qs one after the other for my stores. Thanks for that info already and ive pm-ed you with my email so you can send direct and save the mucking around formating for forum. Ill compare the data with greeds and see if there is a corolation in any way.

Greed: nice work with the 3D graphing very usefull for visual compason. can you publish the forumlas by all means. I have the work on a single Q but this has taken it a step further and put it across mulipule Qs. Its another step in completing a full price formula.
H

Guest · Post by **Guest** » 21.04.2009, 15:54

I did some more work with cubic approximations, the result for optimal price i got was this

from which anyone with elementary school knowledge of math should be able to draw the conclusion. (which is that wardrobes should be sold at about 3400+70q in stores if, of course, you buy them at 2200+50q. This stays true even if you produce wardrobes yourself, of course. Because if you sell at this price in stores, and sell any leftover wardrobes (or buy them at this price, as it is the lowest you can go considering other players who also buy wardrobes) you will earn maximum profit. )

Oh and yes, I can also copy+paste all the equations used ehehe but its not a very pretty sight. Thats why people use mathematical programs

Guest · Post by **Guest** » 24.04.2009, 11:25

SiberianTiger wrote:
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** » 24.04.2009, 13:05

Your formula a/b^c seems to be a good ansatz, unfortunately it doesnt take the quality into account.

Now if i wanted to do a best price dependance fit of form a/b^c (for wardrobes q25) I would get today (retail price/3485.79)^3.07869.
The price/quality in stats was 4184.29

Guest · Post by **Guest** » 24.04.2009, 14:36

greed can you help me pls witha formula
the best selling price for Leather jackets in stores

Guest · Post by **Guest** » 24.04.2009, 14:39

give me data and i can calculate it

Guest · Post by **Guest** » 24.04.2009, 15:30

what data you need?

Guest · Post by **Guest** » 24.04.2009, 15:36

prices and times needed to sell a full rack. make about 10 or so different prices/times. also tell me how much the jackets cost you. paste the data in this form {{price1,time1},{price2,time2},...,{price999,time999}}