eCSFR Markets - Day 1374
•
by BaskB
Evening,
As I mentioned previously I love business and especially in eRep.
So here's something I've been working on the past few weeks, still needs alot of tweaking and playing and eventually I can get it to do alot more.
Clickable Image version
Key to the above
Type - Company and Quality Type
Produced - Units produced per worker including current bonuses
Unit Sell - Current market sell price per unit
Total Value - Produced items multiplied by unit price
Tax - Need not say anything here....
Total - Total Value minus Tax
Wages - Current Highest price wage offer on market
Workers[/b} - Number of workers in the company obviously using 5 in the current case
Income- Total of Sales minus wages (doesnt take into account Raw mats needed if any)
Min Sell Value- The minumum unit value you need to sell at to break even, Finished goods one needs work as the tax throws things a little.
Resources needed- Number of resources required for all workers to produce the max amount in the company
Cost @ market- If you were to buy Raws from the market this is the value
Cost own- This column uses the min sell price your Q5 Raw Mat companies can produce the raws at, for those that like to profit more
Total at market- Income minus resources at market price
Gold Value - Gold Value of the above SKK amount on current market rate
Total using own- Income minus the Cost own column, for those that are using there own produced Raws.
Gold - Gold Value of the above SKK amount on current market rate.
Analysis
From the above its clear to see that unlike alot of nations Food companies are our most profitable resource with Q5 Food being worth almost 2.5x in Gold value than Q5 Weapons!
Is easy to see that the bonuses certainly cause a difference, I mean Q3 Food is worth even more than Q4 Weps!
Raws as is clearly visible isnt worth hiring any staff unless you run Q5 ones or are prepared to run at a loss (or pay low wages). But I figure most of us know this anyway.
Again all the above spreadsheet info doesnt cater for the fact that you could produce your own Raws & Goods and increase your profit further, which is something I'm going to try and add into the design.
I'm also hoping that with enough interest I might actually start graphing the data to see if any trends etc occur.
Usually most of these P&L things I've seen previously go on about ROI% which of course is a valid concern, but personally running this longer term, I prefer cold hard SKK
😉
Again none of this caters for market saturation which has a major impact on prices, for example in the past few weeks Q5 Weps have come down in value by about 20%...
I might even start looking into the export markets in later articles, but of course we need to look after our own first
🙂
BaskB
Facebook
Twitter
Discord
Comments
Very useful table for newbies, thx, vote
whoa
thumb up
v + s, will do a shout, too
From the above its clear to see that unlike alot of nations Food companies are our most profitable resource with Q5 Food being worth almost 2.5x in Gold value than Q5 Weapons!
No one buys q5 food that is valued at more than 5x q1 food. Just because the price is listed thta high, doesn't mean it's selling that high. It will sell at 0.64*5, or 3.2skk. Anyone buying it at 4.2 is getting ripped off.
Valid point Frank, but even at 3.2 SKK per unit it will still drive a profit of 1.7 Gold so higher than Q5 Weps still 🙂
However as I also show, Q1 unless your just selling what you produce yourself is a losing situation at the current market price.
But I do take your point and is something I'll look at adding into the sheet a simple x5 formula etc.
it is really weird that Q5 food is so expensive in federation
Not enough folks produce it and not enough people buy it. When I was producing Q5 food, it wouldn't sell, even though it was at a lower relative price than Qs1-4.
Q5 tanks sell. Everyone wants them. The only way to get people buying q5 is to advertise it's price, shout it, because no one even looks down at the q5.
Plato makes divide stuff by Q and then everybody look just on Q1 and not look at all stuff, not count it for same price... so I think this is a reason.