Create your dream company and become a tycoon!

Play Business Game!
Русский Українська Español Deutsch
Login Password Sign Up / Login Forgot your password? English
Search
virtonomica

List of forums -> Main forum of the online business game "Virtonomics" -> Pricing

Discussions on our virtual business game, your ideas and game mechanics

Topic:

Topic created : 26.03.2015, 23:59

Last time edited : 3.10.2016, 11:55

Wonson
Seven years with Virtonomics
Jubilee Ten Bronze Ten Bronze Ten For contribution to the development of Virtonomics The tender collider, IV-VI places The tender collider, II-III places The tender collider, II-III places World Cuisines, IV-Vi places
World Cuisines, IV-Vi places World Cuisines, IV-Vi places Shagreen, VII-XV places Shagreen, VII-XV places Shagreen, VII-XV places Shagreen, IV-VI, places Shagreen, II-III places Eight years with Virtonomics
The winner of the Industry Competition Winner of the Leaders Contest in the nomination Tender mania
Four years with Virtonomics
l:
Wondime
m:
Wondime
 
What price is best for my store?
There has been many debates on the subject. A well-known formula provided by VLLord some years ago:
[Formula X]
 
There has been worksheets based on this formula. Also, later a strange modified version has been suggested by some players (While previous formula seems to have some merits, the modified version seems to be based on some misconception):
[Formula Y]
 
What I noticed is that such formula do not take many other variables into consideration, for instance number of visitors, brand, intensity of competition, effect of district, ... The formula does not even provide a good guess to maximize the profit or sales volume or anything else, just a price that might work well. And with methods that allow analyzing the sales reports who needs to get into such details?
 
What I would like to propose as a better method is a dynamic elasticity test, that i have used for the last 3 months with excellent results. This method is based on usage of sales history to predict an optimum price to maximize profit. This method has nothing to do with any formula implemented in the game, just considers the dynamics of your store, restaurant, etc. Since it uses a dynamic study on the actual sales history, all variables mentioned earlier and those unknown to us are taken into consideration without even knowing how they affect our sales.
 

 
You can download my simple calculator.
 
How To Use?
Using the worksheet might seem a bit tricky at first glance, but it's really simple. All you need to do is to edit 5 variables in green: sales volume and sales price at two different days and your prime cost (purchase value), and press the button "Calculate point of maximum profit". please do not modify texts in black.
 
You can see the result for one of my stores in the above picture:
day 1, Price has been set to $130.00 and 19,230 pieces has been sold.
day 2: Price has been set to $260.00 and 8,412 pieces has been sold.
I purchased that specific product into my store for $65.00
You can see Ed (price elasticity of demand) is shown according to different economic theories, but you can ignore them to avoid confusion initially. The predictions appear at the bottom:
Proposed Sales Price: $403.00
Estimated Sales Volume: 4,987
 
Please be informed:
1. The worksheet is sensitive to the samples you enter, please be cautious when you test your enterprise with different prices and enter some realistic input. Chose two real distant points, somewhere between 2 to 10 times local sellers price would be fine.
 
2. Please do not go crazy with very high and very low suggestions by worksheet. As you already know the far ends of any economic model is invalid. Such result usually is a sign that prime cost is either too high or too low.
 
3. Please notice that the worksheet does not work according to unit elasticity of demand (Ed=-1), and it is not also recommended to be there, since there is always some prime costs. if you put the prime cost to zero, then the result will be the unit point of elasticity. We heartless capitalists always want to shift to the far inelastic end of the curve, isn't it so? To wink
 
4. You can use the calculated elasticity as a guide, and [arc] elasticity usually provides a better estimation to my experience. if the calculated Ed is lower than -1, it shows your customers are picky and you can't really opt for high prices. if the calculated elasticity is higher than -1 (i.e. -0.90) then your customers are willing to pay more for that product, and you can re-run the test with higher prices to get better results. and elasticity greater than 0 means that you have entered fake input.
 
5. To my experience the results are good, sometimes missed on stores, a few times it proposed real high prices that had no chance to work, but never missed for restaurants.
 
6. The results reflect the predictions for your retail enterprise at current state: current number of visitors, current level of competition, current quality of products sold, current brand, current city Av. salary, current district, etc. If there's a considerable change in one of these variables, i.e. there's new and serious competitor in town, you will need to run the test again.
 
Like always, this does not come with any guarantee. Hope it also works for you, and your suggestions, error reports, and new ideas are always welcome! I always considered this game to have some educational value, and if you correct my errors you have taught me something Heart
 
Edit: worksheet has been modified slightly:
Curves now cover the whole range of data to provide a better view.
Some notes have been added.
version 2.1   

  • Page:
  • 1
Message list:  

27.03.2015, 13:23

diska
Fourteen years with Virtonomics Beauty set King of the Fields Citronom Virtonomics Philanthropist 1st class Shagreen, VII-XV places Sponsor of the Contest for Tycoons The winner of the Breadwinner nomination of the Industry Competition
The winner of the Standard of Virtonomics nomination of the Industry Competition Planter
Holmes Pipe Dynamite Belgian chevron Jewelry Loupe Beauty set Perfume Dentist Sicilian olive
Italy Gold Italy Gold Shagreen, VII-XV places Six years with Virtonomics Fishing Pro Princely mansion Planter Landowner
Miner Helmet Award for helping other players
Fourteen years with Virtonomics Jewelry Loupe Beauty set King of the Fields King of the Fields Golden hook Golden hook Sponsor of the Contest for Tycoons
Magical bonsai MBA diploma
One year with Virtonomics
Fourteen years with Virtonomics Bronze bed-clothing Bronze underwear Estonian silver coin
l:
cnJDS
n:
Flaj Cokotlaj
m:
JDS
a:
Anna Ltd.
 
 
 

28.03.2015, 03:49

Libarbin
 
Very we! 
 

3.04.2015, 21:26.     Subject: it doesnt work

visusito
Three years with Virtonomics
 
doesnt work, the calculate button is an image with no link and B15-18 are no formula, only fields with numbers :S 
 

3.04.2015, 22:20

Wonson
Seven years with Virtonomics
Jubilee Ten Bronze Ten Bronze Ten For contribution to the development of Virtonomics The tender collider, IV-VI places The tender collider, II-III places The tender collider, II-III places World Cuisines, IV-Vi places
World Cuisines, IV-Vi places World Cuisines, IV-Vi places Shagreen, VII-XV places Shagreen, VII-XV places Shagreen, VII-XV places Shagreen, IV-VI, places Shagreen, II-III places Eight years with Virtonomics
The winner of the Industry Competition Winner of the Leaders Contest in the nomination Tender mania
Four years with Virtonomics
l:
Wondime
m:
Wondime
 
did you enable the macro?
B15-B18 does not contain formula, those cells will be filled by macro. 
 

3.04.2015, 23:22.     Subject: yes

visusito
Three years with Virtonomics
 
i enabled but appears the same Not so 
 

4.04.2015, 04:06.     Subject: worked

visusito
Three years with Virtonomics
 
finally i made it work! thank you very much! awesome job! 
 

8.04.2015, 04:10

ragetrade
Three years with Virtonomics
Four years with Virtonomics Winner of the Leaders Contest in the nomination Quality label Winner of the Leaders Contest in the nomination of Consumer Goods Winner of the Contest for Managers in the nomination Raw Material Base Winner of the Contest for Managers in the nomination The Standard of Virtonomics
l:
ZamZam
 
Amazing!
Looks like i wil be using this quite often from now on.
Thanks for sharing, not such a capitalist after allI roll! 
 

23.09.2016, 02:09

roastedmushroom
Winner of the Contest for Managers in the nomination "Knowledge is power!" Winner of the Contest for Managers in the nomination The Standard of Virtonomics
Winner of the Contest for Managers in the nomination Nation's Health Winner of the Contest for Managers in the nomination "Knowledge is power!" Winner of the Contest for Managers in the nomination Consumer Goods Winner of the Contest for Managers in the nomination The Standard of Virtonomics
 
Hi, if someone could upload the calculator again, I'd be really pleased.
 

Thanks! Well 
 

26.09.2016, 12:06

hitaishi
Thirteen years With Virtonomics Sweden retail leader Triple corporate chevron Production: elite World Cuisines, VII-XV places Shagreen, VII-XV places
Thirteen years With Virtonomics Shagreen, VII-XV places Tenderman Retail Elite
l:
Tantra International
m:
Hitaishi Ltd.
 
Yes i am looking for this file too, please upload it if you have it 
 

3.10.2016, 09:40

Wonson
Seven years with Virtonomics
Jubilee Ten Bronze Ten Bronze Ten For contribution to the development of Virtonomics The tender collider, IV-VI places The tender collider, II-III places The tender collider, II-III places World Cuisines, IV-Vi places
World Cuisines, IV-Vi places World Cuisines, IV-Vi places Shagreen, VII-XV places Shagreen, VII-XV places Shagreen, VII-XV places Shagreen, IV-VI, places Shagreen, II-III places Eight years with Virtonomics
The winner of the Industry Competition Winner of the Leaders Contest in the nomination Tender mania
Four years with Virtonomics
l:
Wondime
m:
Wondime
 
Pricing v2.1.
Sorry for delay. I wanted to improve the file but unfortunately no time.
 
Future programme: Proposing a new asset valuation system. I have downloaded some reading material, good at math but not educated in economics and there's a chance that I misinterpret the academic stuff. Anyone with education in that field is welcome to PM me and participate. We can create something together.
 
Cheers! 
IT'S JUST BUSINESS!
 

3.10.2016, 12:16

gamerz300
Masking mustache Panda Panda Mandarin duck Mandarin duck Honey Barrel Merit for the Uzbekistan of level I Seven years with Virtonomics
One year with Virtonomics
Seven years with Virtonomics
m:
Egg-Roll International
 
Tiny file hates me Tears I download the file and when I open it, it gives me the html of the download page in the xlsm instead 
 

3.10.2016, 12:35

Wonson
Seven years with Virtonomics
Jubilee Ten Bronze Ten Bronze Ten For contribution to the development of Virtonomics The tender collider, IV-VI places The tender collider, II-III places The tender collider, II-III places World Cuisines, IV-Vi places
World Cuisines, IV-Vi places World Cuisines, IV-Vi places Shagreen, VII-XV places Shagreen, VII-XV places Shagreen, VII-XV places Shagreen, IV-VI, places Shagreen, II-III places Eight years with Virtonomics
The winner of the Industry Competition Winner of the Leaders Contest in the nomination Tender mania
Four years with Virtonomics
l:
Wondime
m:
Wondime
 
hmm, it worked for me. Just click the link, not "save link as" or things like that. 
IT'S JUST BUSINESS!
 

4.10.2016, 19:47

gamerz300
Masking mustache Panda Panda Mandarin duck Mandarin duck Honey Barrel Merit for the Uzbekistan of level I Seven years with Virtonomics
One year with Virtonomics
Seven years with Virtonomics
m:
Egg-Roll International
 
I'm on my phone. Turns out the issue was because I clicked the link causing a weird endless loop... I have it now however by right clicking/save link on the main page Well
 
Sadly the program on my phone doesn't do macros... 
 

List of forums -> Main forum of the online business game "Virtonomics"-> Pricing

  • Page:
  • 1