Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Finance & Accounting (https://www.askmehelpdesk.com/forumdisplay.php?f=411)
-   -   Retail Inventory method (https://www.askmehelpdesk.com/showthread.php?t=219714)

  • May 25, 2008, 01:32 PM
    titans2008
    Retail Inventory method
    I need help with retail inventory method: I do not know how to figure out goods available for sale at retail, or any other bits of information... Here is the question/equation

    Athletic Shirts: (selling price 1.6 times the cost)
    beginning inventory at cost: 48000
    sales for the 1st 6 months 249600
    purchases at cost 144000

    Athletic coats ( selling price is double their cost)
    beginning inventory at cost: 35000
    sales for the 1st 6 months 207000
    purchases at cost 92500

    Help is appreciated!
  • May 25, 2008, 06:58 PM
    morgaine300
    First, you need to know this "formula":

    Beginning inventory
    +Purchases
    =Available for Sale
    -COGS
    =Ending Inventory (estimated in this case)

    Keep in mind that this inventory at cost also has a retail price. Like COGS and Sales are actually the same inventory, one at cost and one at retail. So this "formula" works whether using cost or retail.

    And how you get the retail value is to multiply by the 1.6.

    Easiest way is setting up two columns with all numbers side-by-side, one column for cost and one column for sales. Then you are finding the missing numbers using the above info.

    Give it a try. You're welcome to post your answers, or any part of an answer, and someone can check it.
  • May 26, 2008, 08:54 AM
    titans2008
    Does that mean everything is multiplied by 1.6 in order to get the retail cost for say, beginning inventory, net sales, etc?
  • May 26, 2008, 09:11 AM
    titans2008
    1 Attachment(s)
    Attached is what I have so far. Please let me know if I am on the right track ,and what is needed from this point on?
  • May 26, 2008, 02:55 PM
    morgaine300
    Actually, I just made this more difficult than it needed to be. I was going by how the usual problem presents the info and wasn't thinking about the fact that they already gave you the 1.6. Normally they give the retail value of the inventory and purchases, and then make you figure out the 1.6. So really, you don't even need to make the 2 columns (although it might help understand the concept.) Sorry 'bout that.

    The problem with what you did is that the 249,600 is already the retail value. That was given as "sales." Sales is going to be retail. Many times retail numbers are given, and you're working back and forth using the proportion of one to the other. Since sales is retail, you need to work backwards to get cost (i.e. divide). That's why you really don't even need that right-hand column for this set-up.
  • May 26, 2008, 07:06 PM
    titans2008
    1 Attachment(s)
    I have reattached the spreadsheet. I think I'm getting closer. Check it out and let me know, if you don't mind.
  • May 27, 2008, 09:25 AM
    titans2008
    1 Attachment(s)
    I believe I am now finished... Can someone please check this for me?
  • May 27, 2008, 08:57 PM
    morgaine300
    1 Attachment(s)
    It ended up being easier to write on your spreadsheet. It was difficult to make reference to certain areas here, so I colored-coded some stuff and then made comments out to the side in reference to the colored area. At the bottom I set it up how I do them.

  • All times are GMT -7. The time now is 01:15 AM.