Excel spreadsheet/template for developing a retail price calculation

  • Thread starter Thread starter breeze
  • Start date Start date
B

breeze

Could someone recommend simple(keyword is *simple*) and convenient Excel
spreadsheet template for developing a retail price calculation (and profit)
for various products in small business?
Just taking input expenses of each item, i.e. purchase price, shipping &
handling, custom tax, turnover tax, plus add my extra charge.
Also, must be provided pair of additional(reserve) rows for some extra
taxes, if such are intended for some goods.
The purpose is correctly calculate self-cost, show retail price and my
profit.

thanks
 
Its looks similarly to my needs, but there is important amplifications:

There should be following columns:
item name; item price; then Q-ty; then Sum; next column is Custom tax -in
percent % (it differs for the different goods, or it can be zero/tax-free);
Next column is interim result; then we add VAT(Value Added Tax)18% to this
interim result(x 1.18) VAT is the same for all goods. So, this column is our
self-cost. The next column is our extra charge in %; and the last column is
our retail price(in EUR).

Some additional fields(cells) should be added below for the following input
value:

1. S&H: this fee should be added to all items proportionally (example: I buy
a lot of various items and pay shipping fee $100.00 for all this purchase,
so this $100.00 should be distributed proportionally among all items).
fixed fee(constant):
2.money transfer - $20.00 - fixed fee(constant):
3.customs formality - $10.00 (this can be zero if tax-free)

This 3 expenses should be added to all items(distributed proportionally
among all items)

4.currency rate USD/EUR. I pay purchase in USD, but sell in EUR, so there
should be a cell for currency rate.
****************************************************************************
**************************************************************
 
Using the example i posted, i think you have enough resources to give i
a shot. Go ahead and try, and reply back with any questions
 
Back
Top