Page 1 of 1
Nifty Spreadsheet
Posted: Fri Oct 26, 2007 4:44 am
by Guest
I've got a spreadsheet I made for Kapilands to calculate profits that I am re-doing for this game -- I'm determined to say in the top 50 lol
Anyway, which would be a better method to calculate:
1) Production costs using the actual production costs of all required items; or
2) Production costs using the potential profit of all required items.
I used to do #1 and then separately figure the potential profit of the required components, but this loses its impact when there are multiple levels of production -- like with Tools in this game.
Am I making sense?
Thanks!
Posted: Fri Oct 26, 2007 4:50 am
by Guest
Option 2. You have to know which buildings/products are producing how much of your profit. There are alot of good guides for building such spreadsheets on the kapilands forums.
Posted: Fri Oct 26, 2007 12:58 pm
by Guest
I would envision that the spreadsheet would actually need to do both. Why? Each option is allowing you to show different levels of productivity.
The first option allows you to see what your profit is based upon the costs of each product needed to produce your end result. For example, if you are producing wood, you would need to include the following:
* The cost to produce/acquire the water,
* The costs to produce the wood which includes water.
The second option is showing you what your profit level is in selling one product compared what your profit level would be if you sold the sub-products individually.
For example, in Kapilands, there is the opportunity to produce cars. The second option wold allow you to determine if you make more profit selling the actual car or selling the sub-products which are needed to make the care (steel, tires, glass, plastic, etc.). In this case, option 2 would most likely show you that because of the price of steel and how much is needed to produce a car, it would be better off selling the sub-prodcts than actually producing the car.
Wow, this is a long post. But, I hope this is what you were looking for in a response.
Mark (aka Robin Hood)
Ruler of Sherwood Forest (and the outlawed Merry Men)
Posted: Sat Oct 27, 2007 12:01 am
by Guest