Question

I need 2 excel sheets with FIFO AND LIFO for these dates and a journal. PLEASE...

I need 2 excel sheets with FIFO AND LIFO for these dates and a journal. PLEASE example as well and thank you!

0 0
Add a comment Improve this question Transcribed image text
Answer #1

FIFO Date Units Balance Transactio 3-Apr Inventory 8 Purchase Per unit Cost 25 75 120030000 30000 124093000 123000 11 Sale 25Remaining units 28 Purchase 20 (40-20) 80 25200 1260100800 126000 5-Jun Sale 20 20 40 60 (20+80-40) 25 35 (60-25) 35 70 (35+3LIFO Date Units Balance Per unit Cost 25 75 Transactio 3-Apr Inventory 8 Purchase 120030000 30000 124093000 123000 11 Sale 40124800 (20 from opening,80 from 28 purchase) 28 Purchase 5-Jun Sale 80 1260 100800 Remaining units Remaining units Remaining

Add a comment
Know the answer?
Add Answer to:
I need 2 excel sheets with FIFO AND LIFO for these dates and a journal. PLEASE...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Needs to be done on an excel with fifo, lifo, specific identification, weighted average, journal entries,...

    Needs to be done on an excel with fifo, lifo, specific identification, weighted average, journal entries, and cogs plus ending inventory seperated and filled out. 3 Northgate Products Corp. sells gadgets and uses the perpetual inventory system. During the 4 month of January 2019, the number of gadgets purchased and sold was as follows: Purchased Sold Balance in inventory Date Units Unit cost Total $ Units Unit cost Total $ Total $ Units Unit cost 200 $2/ Jan. 1 3...

  • I also need the ending inventory and costs of goods sold for periodic LIFO and periodic...

    I also need the ending inventory and costs of goods sold for periodic LIFO and periodic weighted average - Thank you! в D E F G H I J K L M N O P Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO and Weighted Average Cost methods. Make use of Excel capabilities by using as many formulas and functions as possible. Better Bottles, Inc. uses a periodic inventory system and has the following...

  • I need the answers ASAP 8. ---Perpetual LIFO and Periodic FIFO. Matlock Corporation sells item A...

    I need the answers ASAP 8. ---Perpetual LIFO and Periodic FIFO. Matlock Corporation sells item A as part of its product line. Information as to balances on hand, purchases, and sales of item A are given in the following table for the first six months of 2020. Quantities Unit Price Date Purchased Sold Balance of Purchase January 11 400 $4.65 January 24 1,300 1,700 $4.90 February 8 300 1,400 March 16 560 840 June 11 600 1,440 $5.10 Instructions (a)...

  • Please the instructor said we need to submit this in excel please . Someone did it...

    Please the instructor said we need to submit this in excel please . Someone did it it for me without excel and told me to put it in excel but I can’t figure it out please I need this in Excel and all the calculation need to use excel formulas please. I attached what has been done but I need it Excel please using excel formulas to do the calculations. Thank you so much According to the National Center for...

  • Please refer to the exact accounting titles.....I need to make an exact accounting journal please do...

    Please refer to the exact accounting titles.....I need to make an exact accounting journal please do not add your own words to accounting titles....they are confusing. Also, complete entire journal entry Thank you.

  • There are four methods for inventory costing: LIFO, FIFO, weighted average and specific identification. What are...

    There are four methods for inventory costing: LIFO, FIFO, weighted average and specific identification. What are the differences between each method? How does each method affect the balance sheet and the income statement? What do I mean when I say that inventory costing methods are not related to the physical flow of inventory? Please give an example.

  • need help with findinf perpetural method for both LIFO and FIFO CALCULATOR Exercise 8-10 (Part Level Submission...

    need help with findinf perpetural method for both LIFO and FIFO CALCULATOR Exercise 8-10 (Part Level Submission) Inventory information for Part 311 of Flounder Corp. discloses the following information for the month of June. June 1 Balance 299 units @ $11 June 10 Sold 197 units@ $27 Purchased 798 units $14 11 15 Sold 503 units $29 20 Purchased 502 units@$15 27 Sold 305 units@ $31 (a) Your answer is correct. Assuming that the periodic inventory method is used, compute...

  • I need FIFO, LIFO, Weighted Average, Specific Id Required information [The following information applies to the...

    I need FIFO, LIFO, Weighted Average, Specific Id Required information [The following information applies to the questions displayed below.) Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March Units Sold at Retail Units acquired at Cost 110 units @ $51.20 per unit 230 units @ $56.20 per unit 270 units @ $86.20 per unit Date Activities Mar. 1 Beginning inventory Mar. 5 Purchase Mar 9 Sales Mar. 18 Purchase Mar. 25...

  • Please help. I could not compute FIFO and LIFO Question 3 View Polldes Show Attempt History...

    Please help. I could not compute FIFO and LIFO Question 3 View Polldes Show Attempt History Current Attempt in Progress Carla Vista Causes a periodic inventory system. Its records show the following for the month of May, in which 70 units were sold Date Explanation Units 32 Unit Cost $8 May 1 Inventory Total Cost $256 216 Purchase 24 Purchase Total $862 ✓ Your answer is correct Calculate the weighted average unit cost. (Round answer to decimal places 5125) Weighted...

  • METHOD PERPETUAL P8.4 (LO 3) Excel (Compute FIFO, LIFO, and Average-Cost) Hull Company's record of trans-...

    METHOD PERPETUAL P8.4 (LO 3) Excel (Compute FIFO, LIFO, and Average-Cost) Hull Company's record of trans- actions concerning part X for the month of April was as follows. Purchases Sales April 1 (balance on hand) 100 @ $5.00 April 5 300 4 400 @ 5.10 12 200 11 300 @ 5.30 27 800 18 200 @ 5.35 28 150 26 600 @ 5.60 30 200 @ 5.80 Instructions a. Compute the inventory at April 30 on each of the following...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT