Any tools or excel sheets that I can implement to track down the *actual* cost of all raw materials?

Industry Gameplay Center Science & Industry
1

I'm a non-English speaker, the following is from deepl translation, there may be some grammar or proper noun problems, I hope you can forgive me :)

I’ve been playing EVE for five years now, and a large portion of that time has been betting on industry. At first I bought raw materials directly from Jita and manufactured them in 4-4 space stations (sounds a bit stupid right?), then I tried to manufacture them using openly low-taxed space stations in HIGH-sec, which made me a little bit of money (not even enough for me to go to Luminaire and have a fun night out!) . And now that I’ve joined a null-sec alliance and am using my own buildings for manufacturing, it’s making me a decent profit. But there’s always been a question that’s plagued me, past and present: how can I figure out how much isk I’ve earned for each item I’ve manufactured?

Before I think about this I want to recount why. I have found several sources of raw material for my

  1. jita purchases sell orders directly.
  2. jita put up a buy order waiting for someone to sell it to me.
  3. There are familiar suppliers who will sell me large quantities of raw materials directly at a discount.

So I always have a warehouse full of materials waiting to be machined and assembled into finished products and sold for isk (for my parties at Luminaire).
But friends, as you know, raw material prices are changing, ship prices are changing. When I calculate my costs every time I get an order, I can only use the current price of the raw materials, but in reality, many times the price of the raw materials changes very dramatically, maybe when I buy the raw materials in my warehouse they are half the price of what they are on the market now, which means I’m going to make a huge profit! But what if the actual price of the raw materials in my warehouse is twice the current market price? Extremes are always rare, of course, but price fluctuations are very common, and I have absolutely no way of judging the cost of my raw materials, and that makes it impossible to judge the actual cost of each ship I build and my profit. I actually think EVE’s industry rarely loses isk, but not being able to figure out the actual profit is very frustrating to me.

I apologize for the rambling, and I hope you won’t find it long-winded. What I want to ask is: is there a tool, or some kind of table, that can be similar to a manufacturing company’s WMS system (but with simpler functionality), that performs an inbound operation every time a material is purchased, that records the unit price and quantity of the raw material that was inbound this time, and then finally calculates the actual value of all the raw materials that are currently in the warehouse. This way we can clearly know what our costs are.

Thank you for your patience. :wink:
Yours,
Renard

P.S. Feel free to order T3 ships or subsystems from me and I can make delivery at jita.If you order enough, the price can even be lower than jita buy 98%.

2

The issue is, how do you calculate the value of the warehouse ?

Let’s say I buy 1 plex at 0.1 isk, and I resell it t 5.0 isk.
Then I buy another one at 5.5 isk, a month later. What value do you give to the plex ? 0.1 ? 5.5 ? average ? median ?

Then should I also consider the value of plex from 1 year before, before CCP broke them in 500 ?

Other than that, you just need to save the new entries of EVE Swagger Interface (or corp part) in a DB.

3

Thank you very much for your reply.

PLEX isn’t really suitable as an example because it’s not a raw material, let’s use Tritanium as an example. Let’s assume that we have 0 Tritanium in our warehouse right now, and we purchased 100 of them at 4.38 isk (the current sell order price), so the unit price of Tritanium in our warehouse right now is 4.38. OK, then after three days we realize that the price of Tritanium is at its lowest point in the last 30 days, and so we replenish it at 3 isk. So we restocked 100 units at 3isk. OK, so what is the unit price of Tritanium in our warehouse now? Of course (4.38x100+3x100)/200=3.69.

When we calculate the PLEX transaction, we can modify this calculation slightly. For example, say I have no PLEX in my warehouse right now, and then I purchase 500 at 6M and 700 at 5M, the actual price per PLEX is now (6x500+5x700)/1200, and each PLEX is 5.416M isk. So now, someone asks me if I’m willing to sell the PLEX at 5.3M each, and we can clearly calculate that no, because then I will lose isk.

I’m not sure the translator will clarify what I mean. There are two systems here: warehouse, sales. The warehouse system just calculates the price of each raw material in the warehouse, whatever price you sell it at or consume it at doesn’t affect the price of the raw material in the warehouse, only purchasing new material does. And the sales system calculates the profit you make/sell from the prices given in the warehouse.

4

I took the first item I thought of, stop taking everything literally.
Focus on what is important, not on details that change nothing in the topic.

Use trit if you want, but not at “current price” because it makes it wrong if the prices change later, and it makes the consistency of your example with reality required for no reason.

You missed my point about selling them too. You literally did not answer my SINGLE question, instead derailed on irrelevant details.
Also use ×, no * , for multiplication, to avoid italic.

5

You can drive yourself insane trying to work out profit and loss etc in game, at least I found that. I would suggest trying a more relaxed approach. This may not be optimal but at least you will know if you are making some money

1: you decide to build x amount of one or more things

2: you use something like ravvworks, eve cookbook or isk per hour to work out the approximate cost of the materials, put em in a spreadsheet

3 you work out the cost of manufacture in the stations/structure you use, divide by the number of items you have

4: you now have the build cost, price per unit of the thing/s you are looking to build

5: take em to market to sell

So for example, using Isk Per Hour , I want to make 100 x Damage Control I, you enter in the details, runs, ME, location you are building and price paid and any other info you need, and it says how much you with make (or lose) in this case its 48.72% profit. It’s a rough outline, but its fine, if you try to work it out to the last isk you will get frustrated

image
image758×404 33.9 KB

1 Like
6

That won’t work because it follows the market prices but not YOUR purchases prices.

He wants something like that

image
image1246×128 17.5 KB

7

in my example, if you double click the cost per item price, you can enter your own number, so you can alter it to be the prices you paid.

Or give him access (tell him where you got) your sheet :slight_smile:

8

The problem is that he wants that information. Not how to use it.

You are proposing how to use it. That’s got nothing to do with his question.

9

hmmm… I don’t know how it should be interpreted, One of the pleasures of playing manufacturing in EVE is to maximize profits as much as possible. It’s funny isn’t it? While others are calculating via cookbook how much they can make on this one and at what price they should bid, you can tell by the average price in your warehouse that the cost of raw materials in your warehouse is lower than in the market, so we can get the order at a lower price (and believe me in the null-sec alliance they really do use bidding for purchases). Or we can quickly find a material at a lower price by comparing the market price to the warehouse price, and can quickly purchase that material to bring down the warehouse price and fill the warehouse. Or sometimes we can find that a material is at its highest point in a period of time, and selling it is even more profitable than making a ship out of it (it’s rare, but I’ve seen it happen).

Let’s say I buy 1 plex at 0.1 isk, and I resell it t 5.0 isk.
Then I buy another one at 5.5 isk, a month later. What value do you give to the plex ? 0.1 ? 5.5 ? average ? median ?

Suppose we have no PLEX in the warehouse, then the price of the first PLEX is 0.1 isk. when you sell, the warehouse is emptied. A month later, you buy another PLEX for 5.5 isk, so of course the value of that plex is 5.5. Since the first plex is out of the warehouse, I don’t really care about the price at the time of exit, I only care about the average price in the warehouse after entry. Then we can know that for our next sale, the plex should not be worth less than 5.5.

Then should I also consider the value of plex from 1 year before, before CCP broke them in 500 ?

If you have other plexes in your repository, then naturally you should consider their prices, but I set an initial price to save time——after I’ve found the right tool——such as the current market price.

Other than that, you just need to save the new entries of EVE Swagger Interface (or corp part) in a DB.

I also use contracts to make purchases from acquaintances, usually at janice98%. This part can not be available from get_characters_character_id_wallet_transactions … Thank you very much for the suggestion though, getting the wallet record this would solve a part of problems.

P.S. I’m really not very familiar with markdown syntax and I can’t believe I forgot this rule.

10

wow thank you very much for your advice! If you are sourcing raw materials from 0, then you are doing exactly the right thing, so that the price of raw materials is very certain (sell or buy price!) , and the ship selling price is also certain (of course if something has a long manufacturing cycle and you sell it through the market then the selling price may change). I think the only difference between my situation and the one you describe is that I don’t acquire materials when I’ve decided I want to build ships, but rather I have a mountain of materials in my warehouse waiting to be built, and I don’t know what I should be building in order to maximize my profit.

11

I guess in that case you need to assign a value, in ISK to those materials so you can enter that in ISK per hoour (or other app of choice) to determine P&L at market price.

I know you can work out the “average” price in some like excel over different quantities and prices, but that is where i glaze over and lose interest and is pretty much why i am in the process of backing out of manufacturing

12

But that’s exactly what he’s asking,

To which I tried to make him understand, that he needs to work with limited time window to avoid many artifacts, like data usage changing, CCP making items produce more or less for the same cost.