Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Accounting (https://www.askmehelpdesk.com/forumdisplay.php?f=19)
-   -   HELP! Finding Less Inventory Cost (https://www.askmehelpdesk.com/showthread.php?t=21055)

  • Feb 18, 2006, 11:11 AM
    jyn23
    HELP! Finding Less Inventory Cost
    Prepare income statements for July under the absorption costing concept.

    Sales 450000
    Manufacturing Costs:
    direct materials 241800
    direct labor 62400
    variable manufacturing cost 35100
    fixed manufacturing cost 34320
    selling and admin. Expenses:
    variable 18000
    fixed 12600

    I cannot figure the less inventory amount. On the spreadsheet it gives a hint: cost of goods manufactured /units produced and cost of goods manufactured per unit x units in ending inventory.

    The cost of goods manufactured is 373620. HELP PLEASE!! :confused:
  • Feb 18, 2006, 01:17 PM
    CaptainForest
    direct materials 241800
    direct labor 62400
    variable manufacturing cost 35100
    fixed manufacturing cost 34320

    Add those together, you get total cost of good manufactured which is $373,620

    Divide that by the number of units you produced and you have your price/unit
  • Feb 18, 2006, 01:34 PM
    jyn23
    Quote:

    Originally Posted by CaptainForest
    direct materials 241800
    direct labor 62400
    variable manufacturing cost 35100
    fixed manufacturing cost 34320

    Add those together, you get total cost of good manufactured which is $373,620

    Divide that by the number of units you produced and you have your price/unit

    I know how to do that but I don't know how to come up with the less inventory amount. The book states there was 39000 tshirts produced and 36000 of those were sold. So wouldn't that leave the ending inventory 3000 units?

    So I took the 373620 and divided it by 39000 which gave me 9.58 per unit so I took that amount and times it by the ending inventory of 3000 and it gave me 28740. When I input that amount on personal trainer as the "ending inventory" it says its wrong!! What am I missing?? THANK YOU
  • Feb 18, 2006, 03:05 PM
    CaptainForest
    What was the beginning inventory?
  • Feb 18, 2006, 03:08 PM
    jyn23
    This is all the book states:

    During the first month of operations ended July 31 2006, Sound Off Shirt Company produced 39000 T-Shirts, of which 36000 were sold. Operating data for the month are summarized as follows: (( which is the list I gave in the first posting).

    So all I know as far as inventory is what is in bold above! Does this help? I'm getting soooo frustrated! Thank you!!
  • Feb 18, 2006, 03:15 PM
    CaptainForest
    I agree with you.

    I think it should be 9.58 x 3000 = 28,740

    http://www.valuebasedmanagement.net/...n_costing.html

    Perhaps it is a mistake with the program.
  • Feb 18, 2006, 03:21 PM
    jyn23
    I Hate The Personal Trainer Program However I'm Stuck With It For The Next Few Weeks! Thank You So Much For All Your Help And Quick Replies!
  • Feb 18, 2006, 03:31 PM
    CaptainForest
    Quote:

    Originally Posted by jyn23
    I Hate The Personal Trainer Program However I'm Stuck With It For The Next Few Weeks! Thank You So Much For All Your Help And Quick Replies!

    Are you using some kind of program to make the first letter's capitalized in each word?

    Anyway, your welcome.

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