| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Arialla
Caldari
   |
Posted - 2007.03.13 05:21:00 -
[1]
Not sure if I am posting this in the right forum but the supposed "Manufacturing" forum seems to be all about POS.
I am not an accountant but it seems like some kind of accountancy software is essential to running a successful manufacturing business.
1. Journal - keep track of all transactions (purchases, sales, hauling, taxes, manufacturing)
2. Stock - keep track of all stock and location of stock (minerals, manufactured products, BPOs/BPCs, other products)
3. Financial reports
4. Projects
Projects is the EVE related one. Some features to make it shine:
- Specify goods to manufacture and materials required (available from BPO)
- Specify manufacturing location
- Specify required materials cost
- Specify hauling costs
- Specify other expenses (taxes, facility rental, etc)
- Specify amount of runs
- Specify minimum profit margin
- Specify projected sell price
- Report manufacturing times
- Report manufacturing costs
- Report minimum sell price
- Report minimum profit amount
- Report profit margin on projected sell price
- Report profit amount on projected sell price
I have set something like this up in a spreadsheet but I am now running into a few limitations. For instance buying Tritanium in small batches with different costs, I would have to manually work out an average and feed it into the spreadsheet. Also keeping track of prices I bought materials for, if the price is low I might buy in bulk and keep in stock for future manufacturing, or I spot someone selling some cheap and I buy it. How do I keep track of it all though? And when I do estimations for a manufacturing project I would ideally love to be able to calculate the project cost using current stock and compare it with purchasing materials from the market.
The EVE wallet is also starting to bug me as I would like to keep my manufacturing business separate from my other ventures, mission running, trading, etc. I initially thought I could do it on separate accounts but I find myself running short on the amount of buy/sell orders I can put up.
Has anyone set this up on a real world accounting package and is it viable? Are there custom EVE utilities to do the above? I've looked at EVEMeep but it cannot give you material totals for multiple BPOs and I don't think you can factor in things like hauling or keep a record of different manufacturing projects, unless I am missing something.
NOTE: I know the post might seem a bit disjointed, half a spec for what I need and half a spec for what I've done already. Just curious what other people are using before I re-invent the wheel.
Your favorite ARE* and BI&,
Arialla
* Agent Runner Extraordinaire
& Budding Industrialist |
Robacz
Essence Trade
Essence Enterprises
|
Posted - 2007.03.13 08:57:00 -
[2]
I am using this spreadsheet for manufacturing, it has most features you asked for.
Any kind of serious accounting is impossible without wallet/assets exports, unless you want to spend your life with reading numbers in Eve and typing them into some another app. 
_________
Buying/Selling: Implants & Hardwirings
Producing/BPCs: Mining Barges, T2 Components
T2 Distribution: 8 regions covered |
Juwi Kotch
Gallente
VIRTUAL LIFE VANGUARD
Galactic-Federation
|
Posted - 2007.03.13 10:06:00 -
[3]
You might take a look on eve-meep. You'll find a thread about that on the first page of the outpost forum.
Juwi Kotch
JOIN NOW, KLICK SIG! |
Arialla
Caldari
|
Posted - 2007.03.13 22:27:00 -
[4]
 Originally by: Robacz
I am using this spreadsheet for manufacturing, it has most features you asked for.
Any kind of serious accounting is impossible without wallet/assets exports, unless you want to spend your life with reading numbers in Eve and typing them into some another app.
Interesting spreadsheet. I played around with it a bit. Fairly complicated though. There are a lot of stuff around mining which I have absolutely no interest in. It also does not seem to keep track of your purchases of minerals. You have a station stock page but it assumes 1 price for all the minerals. It is essential for me to see the total amount of money I will spend to manufacture a product so I can project accurate profits.
Buying ore and refining it instead of buying minerals is something I might have to look at down the line some time. For now I am trying to keep it simple.
Also, typing numbers in is not that bad. You are limited by your buy/sell order limit unless you fly around to try and get bargains. Which I don't. I prefer to mission run while system wide buy orders take care of collecting minerals for me. Sure, my profit is not maximized but instead of spending hours flying everywhere collecting minerals for an extra 5% profit I am raking in a lot more than that through missioning.
I don't have the skills for a Freighter yet so it really is not worth my time to go shopping around.
From a pure Manufacturing viewpoint though, I am only interested in the following:
- Cost of materials (where they come from (mining, refining, market, etc) is irrelevant)
- Expenses (hauling, taxes, factory rental)
- Sell Price / Profit
Mining should be run as a separate division / cost centre.
Your favorite ARE* and BI&,
Arialla
* Agent Runner Extraordinaire
& Budding Industrialist |
Robacz
Essence Trade
Essence Enterprises
|
Posted - 2007.03.14 11:20:00 -
[5]
Originally by: Arialla
Interesting spreadsheet. I played around with it a bit. Fairly complicated though. There are a lot of stuff around mining which I have absolutely no interest in. It also does not seem to keep track of your purchases of minerals. You have a station stock page but it assumes 1 price for all the minerals. It is essential for me to see the total amount of money I will spend to manufacture a product so I can project accurate profits.
Well it has Factory planner sheet which will tell you total costs, but only with one mineral price as you said. What you want is quite complicated, imo its better just to set some price slightly aboce market, use it for calculations and then buy minerals for lower or equal price. You won't know exact numbers, but it will never be worse than your calculation...
_________
Buying/Selling: Implants & Hardwirings
Producing/BPCs: Mining Barges, T2 Components
T2 Distribution: 8 regions covered |
Domosan
Caldari
Galactech Industries Ltd.
|
Posted - 2007.03.20 00:04:00 -
[6]
I'm chuckling at my desk at work (I'm a CPA - in the US that's a certified public accountant - equivalent to a chartered accountant in Europe).
My only suggestion if you really want to accumulate this level of detail is learn cost accounting by going back to college/University and then set up a cost accounting system to include, but not limited to, a general ledger, job costing, purchase orders, payroll (to mock pay yourself for admin & mining), inventory, fixed assets and depreciation, and sales and accounts receivable. And to get really scarry - if you want to break it down, also purchse the consolidation module. If you have $400,000 USD, a system like MAS 200 should work very well, and if you do a very large volume of transactions, mayble hyperion sitting on top of an oracle db (i'm laughing if you have the 2-5 million USD to pony up for this). Don't forget, you will need to develop an overhead costing model to apply your G&A costs that relate back to the mfg process to inventory/cost of sales - most people develop the model using ms excel.
Kind Regards
|
Shar Tegral
|
Posted - 2007.03.20 00:25:00 -
[7]
In other words, You might be missing the point of Eve. Fun.
You can maximize your efficient exit from Eve by over analyzing your processes. (Trust me I did the in depth accounting thing, no fun.)
The Eve-Online forums may not have invented whining, but they sure have perfected it.
Arknox > shar with bad hair day >>> solution = suicide and spawn fresh clone :D |
Jade Grimpkin
Trader's Academy
Daikoku Trade Syndicate
|
Posted - 2007.03.20 11:42:00 -
[8]
Edited by: Jade Grimpkin on 20/03/2007 11:39:25
My spreadsheet has how much the minerals cost, a percentage to pay couriers and what it costs to make the starship. Then you know how much the starship costs. If you sell it for anything reasonable above that you make a profit. Hooray for profit.
Trading is done with no organisation whatsoever apart from sometimes hauling space weapons or starships to the home of a nice friendly agent.
The nice thing about trading in galactic weaponry and manufacturing spaceships is you can make it as much or as little work as you like, both ways to make some nice spare cash.
|
Kazzac Elentria
|
Posted - 2007.03.20 14:15:00 -
[9]
It's possible with some exporting and customization and labeling to make peach tree accounting work for you in a single manufacturing instance. IE your the only worker in the hub.
With this you can track min purchases over regions, get average pricing, reasonably predict future costs, etc...
And at the same time, setup customer accounts, etc...
It's a trade off though... there are times where playing EVE feels like a second job. |
Klasanov
|
Posted - 2007.03.22 06:13:00 -
[10]
How do you export wallets?
I've been looking for an effective way to track my income/expenses for my character. But constantly using the in-game notepad from the journal given isn't working so well.
|
Kazzac Elentria
|
Posted - 2007.03.22 13:25:00 -
[11]
Originally by: Klasanov
How do you export wallets?
I've been looking for an effective way to track my income/expenses for my character. But constantly using the in-game notepad from the journal given isn't working so well.
I have to manually type them into excel and them import them into quickbooks |
Hexxx
Minmatar
|
Posted - 2007.03.22 20:56:00 -
[12]
Originally by: Klasanov
How do you export wallets?
Damn good question. =P
My best guess is to capture your journal entries using some sort of traffic proxy application that intercepts your packet traffic before it hits the application, filtering by IP and whatever key markers indicate that paticular information.
Anyone crazy enough to try something like that? 
Hexxx LLP - Business Consulting Services - IPO's, Business Plans, Share/Stock Pricing, and general Consulting.
|
Shar Tegral
|
Posted - 2007.03.22 21:10:00 -
[13]
Originally by: Hexxx
Anyone crazy enough to try something like that?
I'm not even crazy enough to dare mention it... even quote it!!
The Eve-Online forums may not have invented whining, but they sure have perfected it.
Arknox > shar with bad hair day >>> solution = suicide and spawn fresh clone :D |
Hexxx
Minmatar
|
Posted - 2007.03.22 21:41:00 -
[14]
Originally by: Shar Tegral
Originally by: Hexxx
Anyone crazy enough to try something like that?
I'm not even crazy enough to dare mention it... even quote it!!
That's just crazy!!! 
Hexxx LLP - Business Consulting Services - IPO's, Business Plans, Share/Stock Pricing, and general Consulting.
|
Angelina Starchild
|
Posted - 2007.03.23 11:09:00 -
[15]
A good way of overcomming the whole varying mineral price thing is to use contractors to supply you with the minerals at a set fee.
It's both easy to obtain and easy to put into your calculations in order.
Of course, even suppliers mineral price will change over time, but setting it into weekly or monthly prices might be something to strive for.
Other pointers when trying to do some serious accounting is to get other people to do as much for you as possible, with set Fee's/pricing/rewards.
It may not be the most cost efficient, but in the end, you might otherwise be spending alot more time in your excel sheets than in-game. That time is money too, so it might break it even if you can afford to pay alittle more.
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |