Change Forum... Civil Aviation Travel, Polls & Prefs Tech/Ops Aviation Hobby Aviation Photography Photography Feedback Trip Reports Military Av & Space Non-Aviation Site Related LIVE Chat My Starred Topics | Profile | New Topic | Forum Index | Help | Search
 MS Excel Wiz? Need Help
 Aviatsiya From , joined Dec 1969, posts, RR: Posted Sat Apr 12 2003 08:28:48 UTC (13 years 1 month 3 weeks 2 days 1 hour ago) and read 1664 times:

 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. Cheers
 B747-437B From , joined Dec 1969, posts, RR: Reply 1, posted Sat Apr 12 2003 08:50:27 UTC (13 years 1 month 3 weeks 2 days ago) and read 1659 times:

 Column G : =((C1-(D1+E1))/2)+D1+E1 Column H : =((C1-(D1+E1))/2)+F1
 GotAirbus From Singapore, joined May 2001, 851 posts, RR: 1 Reply 2, posted Sat Apr 12 2003 08:56:08 UTC (13 years 1 month 3 weeks 2 days ago) and read 1651 times:

 Formulas go like this example: If you want cell A1 to display the totals of R2 and R5, put this equation in cell A1: =R2+R5 If you know arithmetic and algebra, you can use brackets "( )" to seperate equations (just like what he did above). (gotAirbus?)
 (gotAIRBUS?) - (Got Commonality?) - (Have A Nice Flight!)
 ADG From , joined Dec 1969, posts, RR: Reply 3, posted Sat Apr 12 2003 09:06:24 UTC (13 years 1 month 3 weeks 2 days ago) and read 1645 times:

 G3 =C3-SUM(D3:F3) = Profit H3 =G3/2+SUM(D3:E3) = 1/2 Profit + Partner 1 costs I3 =G3/2+F3 = 1/2 Profit + Partner 2 costs ADG (did I win?)
 Aviatsiya From , joined Dec 1969, posts, RR: Reply 4, posted Sat Apr 12 2003 09:35:45 UTC (13 years 1 month 3 weeks 2 days ago) and read 1632 times:

 I just rang a mate who is an accountant, and I gave him some example figures, and Sean's formula comes up with the exact amount. Sorry Bron, but he wins the price in this instance. Sean, just let me know when are down this way and I'll shout ya a few beers. Thanks guys
 Aviatsiya From , joined Dec 1969, posts, RR: Reply 5, posted Sat Apr 12 2003 09:46:42 UTC (13 years 1 month 3 weeks 1 day 23 hours ago) and read 1600 times:

 Bron, the only problem with your formula is that the postage that I am getting paid by the buyer is to go to my partner. I don't get a share of that. There is something in your formula which splits the postage 50/50, when it should be 100% for him 0% for me. I think it is the G3 column where you have factored postage into the profit, when it is a ccst which the customer pays for.
 FlyBoeing From United States of America, joined May 2000, 866 posts, RR: 1 Reply 6, posted Sat Apr 12 2003 14:24:39 UTC (13 years 1 month 3 weeks 1 day 19 hours ago) and read 1559 times:

 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 I would estimate that you would go Total Revenue - Total Costs = Total Profits (C+F)-(D +E+F) which is basically (C-(D+E))/2 for you and (C-(D+E))/2 for your partner, plus F to cover postage. That is, if your partner is honest, he tells you what F is and you add it to both revenue and costs. He pays 100% of it and you add that to the total costs and reimburse him. Make sure you get receipts. Hopefully you share the D+E costs equitably. Happy E-Baying!
 ADG From , joined Dec 1969, posts, RR: Reply 7, posted Sun Apr 13 2003 01:02:14 UTC (13 years 1 month 3 weeks 1 day 8 hours ago) and read 1527 times:

 No idea Scotty ... if mine is wrong then you should make a note never to put me in charge of your money   ADG
 Top Of Page Change Forum... Civil Aviation Travel, Polls & Prefs Tech/Ops Aviation Hobby Aviation Photography Photography Feedback Trip Reports Military Av & Space Non-Aviation Site Related LIVE Chat Forum Index

This topic is archived and can not be replied to any more.

Printer friendly format

 Similar topics: More similar topics...
Need Help With MS Outlook 2k posted Fri Jun 21 2002 03:35:12 by Airlinelover
Need Help With Bill In Model Legislature. posted Wed Jan 17 2007 03:59:04 by ZOTAN
Desperately Need Help A.net!?! posted Wed Jan 3 2007 04:42:18 by Boeinglover24
Need Help With Bearshare posted Thu Dec 28 2006 04:39:50 by TrijetFan1
Question On MS Excel posted Tue Dec 26 2006 18:21:28 by Matt D
I Need Help With A Debt, Part 2 posted Fri Dec 15 2006 15:05:59 by HPLASOps
I Need Help With A Debt posted Tue Nov 28 2006 06:05:58 by HPLASOps
Native Spanish Speakers: I Need Help posted Sun Nov 19 2006 05:48:43 by Tsaord