Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Accounting (https://www.askmehelpdesk.com/forumdisplay.php?f=19)
-   -   COGS formulas (https://www.askmehelpdesk.com/showthread.php?t=366483)

  • Jun 18, 2009, 01:47 PM
    teegee46
    COGS formulas
    What is the formula for calculating percentage of COGS and actual COGS
  • Aug 15, 2009, 03:34 AM
    bishara

    COGS = Cost of Goods Sold

    COGS is always measure to Net Sales

    upper Line

    Sales - COGS = GM

    COGS ÷ Sales = % of COGS To Sales

    COGS ÷ Invntory = To Actual COGS
  • Aug 15, 2009, 09:08 AM
    rehmanvohra
    Quote:

    Originally Posted by bishara View Post
    COGS = Cost of Goods Sold

    COGS is always measure to Net Sales

    upper Line

    Sales - COGS = GM

    COGS ÷ Sales = % of COGS To Sales

    COGS ÷ Invntory = To Actual COGS

    Interesting!! Can u explain the last item about actual cogs?
  • Aug 15, 2009, 07:39 PM
    morgaine300
    Quote:

    Originally Posted by rehmanvohra View Post
    Interesting!!! Can u explain the last item about actual cogs?

    Yeah, I'd like to know that too.

    teegee, I'm assuming by "actual COGS" you mean the dollar amount of it. That is the company's cost of everything they sold. The difference between cost and sales price is the gross profit (gross margin).

    How you might calculate will depend on the information that has been given to you. If you were using a perpetual inventory system, you wouldn't have to calculate it at all because that amount would already be in the COGS account.

    If you're using periodic system then its:
    Beginning Balance of Inventory
    + Net Purchases
    = Available for Sale
    - Ending Inventory
    = Cost of Goods Sold

    If, however, you have been given some random information for some specific problem, it would depend on the info you have been given and no one can answer that without having that info.

    If you want to know what percent something is of something else, you always divide the first by the second. Keep in mind that any "rate" is a percentage, so works the same way if they call it a rate.

    That is, if you want COGS as a percentage of sales, divide in that order: COGS/sales.

    If you want gross profit as a percentage of sales, divide in that order: GP/sales.

    If you want how many males are in your class out of the total, divide in that order: males/total students.

    This always works. If you remember how to do the math behind it, you can use it for any time, any topic, any subject, when you want to know what percentage something is.
  • Aug 15, 2009, 11:30 PM
    rehmanvohra
    As far as I can recollect, dividing cost of goods sold with inventory gives the inventory turnover and NOT the actual cost of goods sold. It is for this reason I requested Bishara for explanation.

  • All times are GMT -7. The time now is 11:11 PM.