How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask unvrs Your Own Question

unvrs
unvrs, Master's Degree
Category: Business and Finance Homework
Satisfied Customers: 348
Experience:  CFA Level 2 Candidate
63322937
Type Your Business and Finance Homework Question Here...
unvrs is online now
A new question is answered every 9 seconds

Cost of Ending Inventory (100pts)During April, Leary Company

Resolved Question:

Cost of Ending Inventory (100pts) During April, Leary Company sold 1000 units of Product Q. Its beginning inventory and purchases during the month are shown below. (Assume the periodic inventory system is used.) April 1 Beginning inventory 200 units @ $1 April 5 Purchases 200 units @ $2 April 10 Purchases 200 units @ $3 April 15 Purchases 200 units @ $4 April 20 Purchase 200 units @ $5 April 25 Purchase 200 units @ $6 Compute the cost of the ending inventory under each of three methods: (a) average-cost, (b) LIFO, and (c) FIFO. Explain how you calculated each answer.
Submitted: 2 years ago.
Category: Business and Finance Homework
Expert:  unvrs replied 2 years ago.

unvrs :

Hi Welcome to Just Answer.
The ending inventory contains 200 units.
Since the purchase price increases throughout the month, the ending inventory cost would be different when we use different ways in computing the cost.
Average Cost Method:
The price can be computed using a weighted average method. So, the price is $3.5 per unit. The ending inventory cost is $3.5 (200) = $700

FIFO:
Units purchased first would be used first. So, at the end of the month, the 200 units that were purchased at $6 are left in inventory. Then under the FIFO method, the ending inventory cost is $6*200 = $1200.

LIFO:
Contrary to FIFO, units purchased last would be used first. When computing the ending inventory, the 200 units that were purchased at $1 would be used. The ending inventory cost is $1*200 = $200.


unvrs :

Please let me know if you have any questions.

Customer:

may i get the calculation, so i can understand

unvrs :

There is not much calculation involved in this problem. Please see the answers in bold for the calculations.
Average Cost Method:
The price can be computed using a weighted average method.
[200(1)+200(2)+200(3)+200(4)+200(5)+200(6)] / 1200 = $3.5
So, the price is $3.5 per unit. Since there are 200 units in the ending inventory, the ending inventory cost is $3.5(200) = $700

FIFO:
Units purchased first would be used first. So, at the end of the month, the 200 units that were purchased at $6 are left in inventory. Then under the FIFO method, the ending inventory cost is $6*200 = $1200.

LIFO:
Contrary to FIFO, units purchased last would be used first. When computing the ending inventory, the 200 units that were purchased at $1 would be used. The ending inventory cost is $1*200 = $200.

unvrs :

Do you have any questions?

Customer:

i am still trying to figure out how it came out to 3.5

unvrs :

Multiply the unit price by the quantity

unvrs :

then add them up

unvrs :

and then divide the sum by the total units

unvrs :

[200(1)+200(2)+200(3)+200(4)+200(5)+200(6)] / 1200 = $3.5

Customer:

oh got it

Customer:

thank you

Customer:

accounting is not my strongest

unvrs :

I'm glad that you got it. Since the quantities for each purchase are the same, you could simply do 1+2+3+4+5+6 and then divide it by 6, but the right way to do it would be to multiply each by the quantity because if the question changes, then you would know how to approach it :-)

unvrs :

Anyway, do you have any question related to this problem?

unvrs :

And as always, thanks for accepting my answer in advance.

Customer:

well would it be ok for me to leave it open for few hours

unvrs :

I think so.
You can "accept" it when you are ready.
Have a good day.

unvrs, Master's Degree
Satisfied Customers: 348
Experience: CFA Level 2 Candidate
unvrs and 3 other Business and Finance Homework Specialists are ready to help you

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
< Last | Next >
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
  • He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here. Diane Dallas, TX
 
 
 

Meet The Experts:

 
 
 
  • linda_us

    Master's Degree

    Satisfied Customers:

    805
    A tutor for Business, Finance, Accounts and other related topics.
< Last | Next >
  • http://ww2.justanswer.com/uploads/LI/lindaus/2012-6-10_04811_IMG20120609164157.64x64.jpg linda_us's Avatar

    linda_us

    Master's Degree

    Satisfied Customers:

    805
    A tutor for Business, Finance, Accounts and other related topics.
  • http://ww2.justanswer.com/uploads/JawaadAhmed/2009-6-27_12137_SIs_SHadi.jpg F. Naz's Avatar

    F. Naz

    Bachelor's Degree

    Satisfied Customers:

    355
    Have completed B.COM and CA Finalist
  • http://ww2.justanswer.com/uploads/JK/jkcpa/2011-1-16_182614_jkcpa.64x64.jpg Bizhelp's Avatar

    Bizhelp

    Accountant

    Satisfied Customers:

    257
    BA degree and Certified Public Accountant
  • http://ww2.justanswer.com/uploads/ED/educatortech/2012-6-7_1256_williams4.64x64.jpg Mr. Gregory White's Avatar

    Mr. Gregory White

    Master's Degree

    Satisfied Customers:

    197
    M.A., M.S. Education / Educational Administration
  • http://ww2.justanswer.com/uploads/FL/FLAandNYLawyer/2012-1-27_14349_3Fotolia25855429M.64x64.jpg FiveStarLaw's Avatar

    FiveStarLaw

    Lawyer, Accountant & Researcher

    Satisfied Customers:

    161
    25 years of experience helping people like you.
  • http://ww2.justanswer.com/uploads/BF/bfc77usa/2011-5-11_42346_face.64x64.jpg Alex's Avatar

    Alex

    Bachelor's Degree

    Satisfied Customers:

    144
    BS in Business Administration with honors. Able to assist in many business related courses.
  • http://ww2.justanswer.com/uploads/BR/brittanyshock1/2012-6-16_174743_JAphoto.64x64.jpg Brittany's Avatar

    Brittany

    Professional

    Satisfied Customers:

    28
    AA/Accounting BS/Business
 
 
 

Related Business and Finance Homework Questions