Monday, October 31, 2011

October monthly financial report

EDIT: Yes october, I just forgot to change the month in the header and I'm too lazy to fix it.
Notes:

I said I was going to revise the spreadsheet this month, but I didn't. Maybe next time.

Increase in net worth is more than the profits I listed. This is largely due to isk from incursions, which I spent some time on at the beginning of the month.

Obelisk margins (in red) are pretty miserable right now, and haven't improved since the last sale. A 5% margin (minus tax, which is in the overhead section instead of the manufacturing section) is a profit of less than 30 million, which is just pointless. I'm holding obelisk production for the immediate future and putting the liquidity into things that make actual profits. It will probably only been a couple of weeks, knowing the market.

Despite having issues with production wait times and moving to a new system, I actually sold more ships than I expected to this month, though profits dropped a lot. I have a bunch of ships finishing in the next few days, and jump-capable capital prices are looking really good right now, so I expect next month to be a good month.

Instead of continuing to copy my supercarrier BPO, I'm putting them into research so that I'll be able to sell them sooner when prices start coming back up. This means that I won't be seeing any copying profits from them in the immediate future, once the final copy has sold.

4 comments:

  1. Hi,

    Some feedback: Why didn't you post your cost of sale for individual items in Run 18? That could show you profitable and less profitable items.

    Secondly, you are calculating contribution margin wrong. It's (Turnover - Cost of sales)/Turnover and not (Turnover - Cost of sales)/Cost of sales that you are using currently. With the new formula you will see that your margins aren't that great especially when you are manufacturing items yourself and selling to the end client (I suppose)

    Kind regards,

    Lu0uX

    ReplyDelete
  2. Well, I'm not very good at spreadsheets.

    -I don't know what cost of sale is or why run 18 is special. I do have a separate tool that I use to identify which ships have are most profitable, though since I don't have a significant component bottleneck it rarely affects which ships I produce.

    -I don't know what those terms mean either. 'Margin' here is the simple difference between outlay and sale price, calculated as sale price/outlay-1; so, outlay*(1+margin)=sale price. 30% profit is pretty good by my reconing.

    ReplyDelete
  3. Is there a reason that you aren't using eve meep or something more integrated?

    ReplyDelete
  4. Since evemon derped over corporate API keys I am using meep to track industry jobs, but as far as I can tell it doesn't do anything else that I would find useful. I'm not aware of any tools that would be able to replace my spreadsheets.

    ReplyDelete