Notices

Applications and Utilities Talk about apps and utilities for Windows Mobile and PPC

Reply
 
LinkBack Thread Tools
Old 01-26-04, 10:03 PM   #1 (permalink)
Aximsite Prospect
 
Join Date: Jul 2003
Location: Eureka, MO
Posts: 8
Device: Blackberry 7520
Carrier: Nextel
Thanked 0 Times in 0 Posts
Question Profit Margin Calculator

Does anyone know of a profit margin calculator that will help a poor salesman like myself?
Something that will take a product's cost add a specific margin and give you your selling price?
I would appreciate knowing of any available software for my Axim X5.
tedbarklage is offline   Reply With Quote
Sponsor Ads
Old 01-26-04, 10:16 PM   #2 (permalink)
AximsiteKiwiFruit Legend
 
MrKlaatu's Avatar
Addicted Member
 
Join Date: May 2003
Location: Valhalla
Posts: 15,160
Thanked 1 Time in 1 Post

Awards Showcase
Aximsite Active Silver Member Aximsite Silver Contributors Silver Poster 
Total Awards: 3

I just send a list of my products prices to Dewey, Cheatem & Howe (DCH), a CPA firm I found in my yahoo! Bulk Mail Folder.

They send me back a suggested selling price plus a s**t-load of documentation that keeps my firm's accounting department so flummoxed that they never bother me anymore.

I have no more paperwork hassels and I don't have to calculate any more numbers anymore!.........I HATE numbers!!! They make my head hurt and my eyes bleed.

All this for only 10 easy payments of $43.57! (per year)
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by MrKlaatu; 01-26-04 at 10:20 PM.
MrKlaatu is offline   Reply With Quote
Old 01-27-04, 12:18 AM   #3 (permalink)
Aximsite Administrator
 
deftech's Avatar
Addicted Member
 
Join Date: Feb 2003
Location: Arkansas
Posts: 5,635
Thanked 3 Times in 2 Posts

Awards Showcase
Moderator Medal Admin Medal Bronze Poster 
Total Awards: 3

Upon someone's request several months ago, I made a simple app to do this. It was written in eVB for PPC2002, so if you are a WM2003 user you'd need the eVB Runtime from Microsoft's website.

Click Here for Calculator
__________________
Jordan M. Wigley
Aximsite.com
Email: jordan AT aximsite.com


.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Come join the friendly community at
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
deftech is offline   Reply With Quote
Old 01-27-04, 02:56 AM   #4 (permalink)
Aximsite Minor League
 
Join Date: Jul 2003
Location: England
Posts: 136
Thanked 0 Times in 0 Posts
Re: Profit Margin Calculator

Quote:
Originally posted by tedbarklage
Does anyone know of a profit margin calculator that will help a poor salesman like myself?
Something that will take a product's cost add a specific margin and give you your selling price?
I would appreciate knowing of any available software for my Axim X5.
A simple Excel spreadsheet will do that:
In A1 put the cost.
In A2 put the margin (say 1.20 for 20%)
in A3 put =a1*a2
deaddred is offline   Reply With Quote
Old 01-27-04, 04:37 AM   #5 (permalink)
Aximsite Administrator
 
deftech's Avatar
Addicted Member
 
Join Date: Feb 2003
Location: Arkansas
Posts: 5,635
Thanked 3 Times in 2 Posts

Awards Showcase
Moderator Medal Admin Medal Bronze Poster 
Total Awards: 3

Yep. It's a very simple calculation, and could easily be done in Excel.

As I said, this was just an app that someone was wanting to simplify it a little more. I plan to eventually expand on the app to include more features, but I just don't have time to do much with it at the moment. It's being ported to .NET right now, but that's about the only update I've done to it.
__________________
Jordan M. Wigley
Aximsite.com
Email: jordan AT aximsite.com


.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Come join the friendly community at
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
deftech is offline   Reply With Quote
Old 01-27-04, 04:45 AM   #6 (permalink)
Aximsite Minor League
 
Join Date: Jul 2003
Location: England
Posts: 136
Thanked 0 Times in 0 Posts
Quote:
Originally posted by deftech
Yep. It's a very simple calculation, and could easily be done in Excel.

As I said, this was just an app that someone was wanting to simplify it a little more. I plan to eventually expand on the app to include more features, but I just don't have time to do much with it at the moment. It's being ported to .NET right now, but that's about the only update I've done to it.
Personally I prefer to empower people by teaching them how to do it for themselves rather than rely on third party applications. So many people haven't got a clue about spreadsheets and how simple and amazingly useful they can be.
deaddred is offline   Reply With Quote
Old 01-27-04, 09:30 AM   #7 (permalink)
Aximsite Prospect
 
Join Date: Jul 2003
Location: Eureka, MO
Posts: 8
Device: Blackberry 7520
Carrier: Nextel
Thanked 0 Times in 0 Posts
The suggested spreadsheet is a markup, not a profit margin calculator. If I have a cost of $100 dollars and I sell an item for $133.33. I have a profit of $33.33. This profit stated as a profit percentage of my selling price is a 25% Profit Margin.
I had a Palm app that would allow you to put in any two of the three elements (Cost, Profit Margin, Sell Price) and it would calculate the third. It is not as simple as you may think. I know Excell!
tedbarklage is offline   Reply With Quote
Old 01-27-04, 09:48 AM   #8 (permalink)
Aximsite Prospect
 
Join Date: Jul 2003
Location: Eureka, MO
Posts: 8
Device: Blackberry 7520
Carrier: Nextel
Thanked 0 Times in 0 Posts
I purchased the calculator software that Jordan suggested above. It is exactly what I was looking for. Thanks Jordan!
tedbarklage is offline   Reply With Quote
Old 01-27-04, 11:01 AM   #9 (permalink)
bigdave240
Guest
 
Posts: n/a
Re: Re: Profit Margin Calculator

Quote:
Originally posted by deaddred
A simple Excel spreadsheet will do that:
In A1 put the cost.
In A2 put the margin (say 1.20 for 20%)
in A3 put =a1*a2
Actually that is not correct. The calculation is cost/profit margin ( 20%margin=.8) that would give you a price of $125. The proof of that is to take 20% of 125 and you would still have your $100 cost left. If you do it your way you get $120. Take 20% away($24) and now you are short.

Last edited by bigdave240; 01-27-04 at 11:07 AM.
  Reply With Quote
Old 01-27-04, 11:55 AM   #10 (permalink)
Aximsite Minor League
 
Join Date: Jul 2003
Location: England
Posts: 136
Thanked 0 Times in 0 Posts
Re: Re: Re: Profit Margin Calculator

Quote:
Originally posted by bigdave240
Actually that is not correct. The calculation is cost/profit margin ( 20%margin=.8) that would give you a price of $125. The proof of that is to take 20% of 125 and you would still have your $100 cost left. If you do it your way you get $120. Take 20% away($24) and now you are short.
I was basing it on the original project design specification:
"Something that will take a product's cost add a specific margin and give you your selling price?"

Garbage in, garbage out :-)
deaddred is offline   Reply With Quote
Old 01-27-04, 01:10 PM   #11 (permalink)
AximsiteKiwiFruit Legend
 
MrKlaatu's Avatar
Addicted Member
 
Join Date: May 2003
Location: Valhalla
Posts: 15,160
Thanked 1 Time in 1 Post

Awards Showcase
Aximsite Active Silver Member Aximsite Silver Contributors Silver Poster 
Total Awards: 3

I've always approached numbers from this perspective:

A good Accountant can make any set of numbers say whatever he wants them to say.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
MrKlaatu is offline   Reply With Quote
Old 01-27-04, 02:41 PM   #12 (permalink)
Aximsite Prospect
 
Join Date: Jul 2003
Location: Eureka, MO
Posts: 8
Device: Blackberry 7520
Carrier: Nextel
Thanked 0 Times in 0 Posts
BigDave240 must not be in sales!!!
You would know that Gross Profit is stated as a percent of selling price not cost of goods.
tedbarklage is offline   Reply With Quote
Reply

Sponsor Ads

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -5. The time now is 03:48 PM.
Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0
Copyright © 2003-09 LeckMedia, LLC