Retail Profit

Post useful calculations you have come up with. List the variables and formulas you have created.

Retail Profit

Postby mpantoja » Fri Mar 12, 2010 12:21 am

I am constantly buying products and reselling them. Usually I have a "what the market will bear" retail price in mind, but I have to quickly calculate how profitable it will be. This calculator takes the following inputs:

- Units (how many)
- Unit Cost
- Setup or Shipping (for any charges that are for the whole order rather than per unit)
- Sale Price (what the customer will pay per unit)

Results:

- Unit Profit
- Total Profit
- Margin (%)
- Markup (%)
- Total Sale Price

Now I can adjust the price and quickly see if the transaction is profitable enough to deal with. My invoicing system only uses a "markup" approach to calcuating retail price (lame, I know), so I can use the "Markup" result and the pricing matches my target.

Is it wrong to love writing calculations so much?

profit.xml.zip
(1.15 KiB) Downloaded 197 times
mpantoja
 
Posts: 3
Joined: Wed Mar 10, 2010 11:03 pm

Return to Swap calculations

Who is online

Users browsing this forum: No registered users and 2 guests

cron