Setting up variable formulas for to determine profit margin

**killahcheese** · 01-04-2013, 02:23 PM

Hi guys,

I'm relatively new to Excel and would appreciate any possible help I can get.

Looking into starting to import some things from China, but I want to analyze the costs an gains.
The things I've done with my excel so far is to calculate the original item price, market price to be sold, total sales revenue generated per category, price multiples per item sold, price flucuation with the RMB.

I'm looking to add further, shipping costs to distributor, tax & duties, additional costs for shipping to end users, additional costs to use services like ebay/amazon.

Is it better to add these expenses to each item on my excel when assessing the multiple? Or is it better to slap these into a bulk category after assessing my overall potential revenue? The problem is here is that a good portion of my items have different tax rates.

Hope this makes sense,

**dogberry** · 01-04-2013, 02:35 PM

Hi

In any excel worksheet it is always best to keep it atomic by that I mean as little information as possible so keep them all seperate that will allow you to assess cost of say just shipping on its own that way you can ring round for other quotes and see if you can get it cheaper bundled as one lot where would you stand in two years time when you may not even remember what it consisted of.

Chris

**killahcheese** · 01-04-2013, 03:04 PM

Thanks for the response Chris,

Would you say then that I should keep seperate sheets within my excel file for Margins, Shipping costs, Tax, and Service fees for selling?

So assuming I am taking a cell from Sheet 1, lets say A1 which is my potential revenue, and I am going to deduct the shipping from that in Sheet 2, and then tax in Sheet 3 from Sheet 2?