Question

Use the information below to determine the number of units in ending inventory and the ending...

Use the information below to determine the number of units in ending inventory
and the ending inventory value using the perpetual inventory system for FIFO.
($)
Number Per
Date Transaction of units unit
Apr. 3 Inventory 30 800
8 Purchase 60 820
11 Sale 40 -
30 Sale 30 -
May 8 Purchase 60 850
10 Sale 20 -
19 Sale 15 -
28 Purchase 80 900
Part 2
There are 10 units in ending inventory compute the value of the ending inventory
using the periodic inventory method. Compute the answer using FIFO, LIFO and the average
cost methods. (round your answer to the nearest whole number)
Price Cost
Number Per Per
Date Transaction of units unit Purchase
Apr. 3 Inventory 2 10 20
8 Purchase 2 15 30
11 Purchase 3 20 60
30 Purchase 2 25 50
May 8 Purchase 3 25 75
10 Purchase 3 30 90
19 Purchase 3 30 90
28 Purchase 3 35 105
June 5 Purchase 3 40 120
16 Purchase 4 40 160
21 Purchase 4 45 180
28 Purchase 3 50 150

Use the information below to determine the number of units in ending inventory
and the ending inventory value using the perpetual inventory system for FIFO.

Homework Answers

Answer #1
Date Purchase Sale Balance
Quantity Amount Quantity Amount Quantity Amount
3-Apr 30 800
Balance 30 800
8-Apr 60 820 30 800
60 820
Balance 90 1620
11-Apr 30 800 50 683
10 137
Balance 50 683
30-Apr 30 410 20 273
Balance 20 273
8-May 60 850 20 273
60 850
Balance 80 1123
10-May 20 273 60 850
Balance 60 850
19-May 15 213 45 638
Balance 45 638
28-May 80 900 45 638
80 900
Balance 125 1538

Units of ending inventory using fifo - 125 units

Value of ending inventory using fifo - Rs 1538

(For part 2 information is not properly provided)

Know the answer?
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
Similar Questions
Use the information below to determine the number of units in ending inventory and the ending...
Use the information below to determine the number of units in ending inventory and the ending inventory value using the perpetual inventory system for FIFO. ($) Number Per Date Transaction of units unit Apr. 3 Inventory 30 800 8 Purchase 60 820 11 Sale 40 - 30 Sale 30 - May 8 Purchase 60 850 10 Sale 20 - 19 Sale 15 - 28 Purchase 80 900
FIFO Perpetual Inventory The beginning inventory at Dunne Co. and data on purchases and sales for...
FIFO Perpetual Inventory The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows: Date Transaction Number of Units Per Unit Total Apr. 3 Inventory 72 $300 $21,600 8 Purchase 144 360 51,840 11 Sale 96 1,000 96,000 30 Sale 60 1,000 60,000 May 8 Purchase 120 400 48,000 10 Sale 72 1,000 72,000 19 Sale 36 1,000 36,000 28 Purchase 120 440 52,800 June 5 Sale 72 1,050...
The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a...
The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows: Date Transaction Number of Units Per Unit Total Apr. 3 Inventory 60 $300 $18,000 8 Purchase 120 360 43,200 11 Sale 80 1,000 80,000 30 Sale 50 1,000 50,000 May 8 Purchase 100 400 40,000 10 Sale 60 1,000 60,000 19 Sale 30 1,000 30,000 28 Purchase 100 440 44,000 June 5 Sale 60 1,050 63,000...
Consider the following information for Maynor Company, which uses a perpetual inventory system:    Transaction Units...
Consider the following information for Maynor Company, which uses a perpetual inventory system:    Transaction Units Unit Cost Total Cost January 1 Beginning Inventory 20 $ 70 $ 1,400 March 28 Purchase 30 76 2,280 August 22 Purchase 40 80 3,200 October 14 Purchase 45 86 3,870 Goods Available for Sale 135 $ 10,750 The company sold 45 units on May 1 and 40 units on October 28. Required: Calculate the company's ending inventory and cost of goods sold using...
The following information pertains to Company A's Year 1 inventory activities: Date Transaction Number of Units...
The following information pertains to Company A's Year 1 inventory activities: Date Transaction Number of Units Purchase price per unit Sale price per unit January 1 Beginning balance 90 $40 April 11 Sale 50 $70 May 15 Purchase 160 $65 July 25 Sale 30 $75 For each of the following independent assumptions regarding Company A's inventory cost flow methods, click on the associated designated cell and enter the applicable dollar value of inventory that would be reported in Company A's...
Beginning inventory, purchases and sales data for T-shirts are as follows: Apr 3 Inventory 24 units...
Beginning inventory, purchases and sales data for T-shirts are as follows: Apr 3 Inventory 24 units @ $10      11 Purchase 26 units @ $12      14 Sale 36 units      21 Purchase 18 units @ $15      25 Sale 20 units Assuming the business maintains a perpetual inventory system, calculate the cost of merchandise sold on April 14th and April 25th, as well as ending inventory as of April 30th, using FIFO
Beginning inventory, purchases, and sales data for portable game players are as follows: Apr. 1 Inventory...
Beginning inventory, purchases, and sales data for portable game players are as follows: Apr. 1 Inventory 120 units at $26 10 Sale 90 units 15 Purchase 140 units at $28 20 Sale 110 units 24 Sale 40 units 30 Purchase 160 units at $30 The business maintains a perpetual inventory system, costing by the first-in, first-out method. a. Determine the cost of the merchandise sold for each sale and the inventory balance after each sale, presenting the data in the...
1. Beginning inventory, purchases and sales data for tennis rackets are as follows: Apr 3 Inventory...
1. Beginning inventory, purchases and sales data for tennis rackets are as follows: Apr 3 Inventory 12 units @ $25      11 Purchase 13 units @ $27      14 Sale 18 units      21 Purchase 9 units @ $30      25 Sale 10 units Assuming the business maintains a perpetual inventory system, calculate the cost of merchandise sold and ending inventory under Last-in, first-out: Group of answer choices cost of merchandise sold $771; ending inventory $150 cost of merchandise sold...
Evans Company had the following information for the year ending December 31: Beginning inventory: 210 Units...
Evans Company had the following information for the year ending December 31: Beginning inventory: 210 Units $45 Unit Cost Purchase April 6: 360 Units $43 Unit Cost Sale May 4: 260 Units    Purchase July 19: 480 units $42 unit cost Sale: September 9: 380 units Purchase: October 10: 100 units $39 unit cost Evans uses the perpetual inventory system and the FIFO method. Required: Using FIFO (a) Compute the cost of ending inventory. (b) Compute the cost of goods...
Date Transaction # of Units Unit Cost Total Cost 1/1 Beg Balance 150 $30 $4,500 1/24...
Date Transaction # of Units Unit Cost Total Cost 1/1 Beg Balance 150 $30 $4,500 1/24 Purchase 70 33 2,310 2/22 Sale (100) - - 3/7 Purchase 90 35 3,150 4/10 Purchase 140 36 5,040 6/11 Sale (100) - - 9/28 Purchase 50 38 1,900 12/4 Sale (100) - - What is the cost of goods sold under a FIFO periodic inventory system? $10,500 $9,610 $7,290 $6,150 What is the ending inventory under a LIFO periodic inventory system? $10,500 $9,610...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT