I need some help here guys and gals on trying to set up an Excel spreadsheet (formulas and such). It would be a pretty easy job I think.
To give run-down of what I need.
PersonS (me) and PersonA (a friend) are doing a little bit of wheeling and dealing and I need a spreadsheet to track our sales, and also our profit.
There are a few variables (hence the need for formulas), so I will spell out what is in each column
ColumnA : Item description (doesn't come into play for the formulae)
ColumnB : Item number (doesn't come into play for the formulae)
ColumnC : Final price for item
ColumnD : Listing Fee
ColumnE : Other fee
ColumnF : Postage Fee
ColumnG : PersonS (my) profit
ColumnH : PersonA (my friends) profit
Where it gets difficult (in my mind) is:
ColumnD and ColumnE are costs which I will incur in selling the item.
ColumnF is a cost which my friend will incur, and is not included in the final price (Column C), but which I will receive from the buyer. (i.e. You buy something from us, you pay me the amount in ColumnC and ColumnF, but my friend incurs that ColumnF figure at his end)
We are splitting the profits 50/50, but what I need to know is what formulae to use to insure that each share of the profit, takes into account the costs which each of us have incurred. So whilst we are sharing the profits equally, we are each going to have different costs involved.
Whilst I am calling ColumnG and ColumnH our "profit", it would possibly be better to describe as what each of us will have left over after all costs are incurred, or how much money I will have to send to my friend.
I hope I have explained this ok....if not ask me.
But I would appreciate it if an Excel wiz out there could help with some formulae for me.