All the formulas of Kapilands.
Moderator: moderators
-
Guest
-
Guest
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
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
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.
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
-
Guest
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!
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
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

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

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
Same problem around here. At this moment I know that to handle a model for the sales, I should have the following variables: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
- 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
-
Guest
-
Guest
