posted on February 27, 2005 01:16:13 PM new
OK, I'm revising my inventory to reflect the new fees. Procrastination, I know...
I know I've seen Excel formulas for calculating fees here, but since this board doesn't have a search function, I'll ask again.
I want to put in my cost for an item and have the sheet calculate what the fixed value price would have to be to break even after listing fee, final value fee, and Paypal fees. I'll figure boxes and shipping myself.
Anyone have a pointer or link?
--------------------------------------
Replay Media - The best source for board games, card games and miniatures on the web! http://www.replaymedia.com
posted on February 28, 2005 05:58:14 AM new
Replay, Not sure what your current spreadsheet looks like but you need to first establish columns for all your costs. Item Cost,Ebay Listing/FVF,Vendio Fee,Paypal,Postage,Sold For,Shipping Income($ paid to you for shipping). I use total monthly charges for ebay,paypal and vendio and use a average/item . Once you have all the columns just use the "sigma" (looks like a backward 3) in the tool bar to add each column individually horizontlly or vertically as needed to get sums(this automatically creates a formula). You will need to left click and hold then drag the number total,dropping the total at the open block just below or to the right of the last number being added. I have used my models for over 5 years for keeping records and for creating listings and would never live without them. Looking at my data for the last 6 months of 2004,I can easily see that I had a Vendio Store/eBay sell thru rate (total items sold at vendio store +eBay auction divided by total intems listed on eBay)of 43% and my profit was 52% of total sales revenue. If you need a tutorial on excel start with the help icon on any excel spread sheet. Good Luck
posted on February 28, 2005 02:34:46 PM new
I don't actually use a spreadsheet normally, but it seems like the way to go for this project.
I KNOW I've seen long formulas (with if/thens and such to calculate various FVF tiers) posted around before. I'm just not having any luck Googling them ;(
--------------------------------------
Replay Media - The best source for board games, card games and miniatures on the web! http://www.replaymedia.com
posted on March 1, 2005 06:59:15 AM new
Hey guys, I found what I was looking for over on the Powerseller board. Here's a quick repeat of the two messages I had in mind:
Auction, Fixed Price and Old Store Sales $25.01 - $1000.00:
=SUM((A1-25)*0.0275+1.31)
Store Sales (post Feb 18th) $25.00 and Under:
=SUM(A1*0.08)
Store Sales (post Feb 18th) $25.01 - $1000.00:
=SUM((A1-25)*0.05+2)
Use in one cell that already knows the breakpoints...
This is for the Store Fees
--------------------------------------
Replay Media - The best source for board games, card games and miniatures on the web! http://www.replaymedia.com
