Formula

 BBS: Inland Empire Archive
Date: 06-30-92 (08:36)             Number: 1767
From: MARTY DUPLISSEY              Refer#: NONE
  To: JIM TANNER                    Recvd: NO  
Subj: Formula                        Conf: (2) Quik_Bas

Blabbering as if I knew what I was talking about!

In a msg of <29 Jun 92>, Jim Tanner mumbled incoherently to All:

 JT> I'm tinkering with a database program where I need to figure a
 JT> "markup" on an item then show what the item will sell for at retail.
 JT> Here's an example:

 JT> Cost ...... $1.50
 JT> MarkUp .... 30%
 JT> Price ..... $...

Well to figure simple markup use the following.


price# = cost# + (cost# * margin#)
where margin is expresed by a decimal ie .30 in your example

now to figure GPM , Which is the way I do it every day.

price# = cost# / ( 1 - margin#)
again using margin as a decimal.

If you want a description of the difference send netmail as it
can get long winded and is off topic.

MARTY

--- GoldED 2.40
 * Origin: World Link BBS. Longview, TX. OS/2 (903) 643-7607 (1:398/1)