Question
In: Accounting
The inventory records for Tiny Tim Creations Inc. indicate the following activity for the month of...
The inventory records for Tiny Tim Creations Inc. indicate the following activity for the month of January:
January 1 balance,
1000 units @ $7.20 each
Purchases:
January 10: 600 units @ $7.25 each
January 16: 800 units @ $7.30 each
January 23: 600 units @ $7.35 each
Sales:
January 5: 400 units
January 14: 700 units
January 20: 500 units
January 26: 700 units
1. January 31st ending inventory using unit LIFO in a perpetual inventory system is:
A) $4,960
B) $5,060
C) $5,080
D) $5,140
Solutions
Expert Solution
The right option is " B) $5,060 ".
Ending inventory using unit LIFO in a perpetual inventory system:
| Opening inventory | Purchases | Sales | Ending inventory | |||||||||
| Date | units | Cost per unit | Total cost | units | Cost per unit | Total cost | units | Cost per unit | Total cost | units | Cost per unit | Total cost |
| January 1 | 1,000 units | $7.20 | $7,200 | - | - | - | - | - | - | 1,000 units | $7.20 | $7,200 |
| January 5 | 1,000 units | $7.20 | $7,200 | - | - | - | 400 units | $7.20 | $2,880 | 600 units | $7.20 | $4,320 |
| january 10 | 600 units | $7.20 | $4,320 | 600 units | $7.25 | $4,350 | - | - | - | 600 units | $7.20 | $4,320 |
| 600 units | $7.25 | $4,350 | ||||||||||
| "january 14 | 600 units | $7.20 | $4,320 | - | - | - | 600 units | $7.25 | $4,350 | 500 units | $7.20 | $3,600 |
| 600 units | $7.25 | $4,350 | 100 units | $7.20 | $720 | |||||||
| january 16 | 500 units | $7.20 | $3,600 | 800 units | $7.30 | $5,840 | - | - | - | 500 units | $7.20 | $3,600 |
| 800 units | $7.30 | $5,840 | ||||||||||
| "january 20 | 500 units | $7.20 | $3,600 | - | - | - | 500 units | $7.30 | $3,650 | 500 units | $7.20 | $3,600 |
| 800 units | $7.30 | $5,840 | 300 units | $7.30 | $2,190 | |||||||
| January 23 | 500 units | $7.20 | $3,600 | 600 units | $7.35 | $4,410 | - | - | - | 500 units | $7.20 | $3,600 |
| 300 units | $7.30 | $2,190 | 300 units | $7.30 | $2,190 | |||||||
| 600 units | $7.35 | $4,410 | ||||||||||
| January 23 | 500 units | $7.20 | $3,600 | - | - | - | 600 units | $7.35 | $4,410 | 500 units | $7.20 | $3,600 |
| 300 units | $7.30 | $2,190 | 100 units | $7.30 | $730 | 200 units | $7.30 | $1,460 | ||||
| 600 units | $7.35 | $4,410 | ||||||||||
Total cost of ending inventory = ( 500 units @ $7.20 ) + ( 200 units @ $7.30 ) = $5,060
ekkarill92 answered 1 year agoRelated Solutions
Alternative Inventory Methods Park Company's perpetual inventory records indicate the following transactions in the month of...
Alternative Inventory Methods
Park Company's perpetual inventory records indicate the
following transactions in the month of June:
Units Cost/Unit
Inventory, June 1 200 $3.20
Purchases:
June 3 200 3.50
June 17 250 3.60
June 24 300 3.65
Sales:
June 6 300
June 21 200
June 27 150
Required:
1. Compute the cost of goods sold for June and the inventory at
the end of June using each of the following cost flow assumptions:
If required, round your answers to the...
Alternative Inventory Methods Park Company's perpetual inventory records indicate the following transactions in the month of...
Alternative Inventory Methods Park Company's perpetual inventory
records indicate the following transactions in the month of June:
Units Cost/Unit Inventory, June 1 200 $3.20 Purchases: June 3 200
3.50 June 17 250 3.60 June 24 300 3.65 Sales: June 6 300 June 21
200 June 27 150 Required: 1. Compute the cost of goods sold for
June and the inventory at the end of June using each of the
following cost flow assumptions: If required, round your answers to
the...
Park Company's perpetual inventory records indicate the following transactions in the month of June:
Alternative Inventory MethodsPark Company's perpetual inventory records indicate the
following transactions in the month of June:UnitsCost/UnitInventory, June 1200$3.20Purchases: June 32003.50 June 172503.60 June 243003.65Sales: June 6300 June 21200 June 27150Required:1.Compute the cost of goods sold for June and the inventory at
the end of June using each of the following cost flow assumptions:
If required, round your answers to the nearest dollar.FIFOCost of Goods Sold$ fill in the blank 1Ending Inventory$ fill in the blank 2LIFO (Round your intermediate calculations and final answers to
the nearest cent.)Cost of...
A company's inventory records indicate the following data for the month of April: April 1 Beginning...
A company's inventory records indicate the following data for
the month of April:
April 1
Beginning
350 units at $18 each
April 5
Purchase
290 units at $20 each
April 9
Sale
500 units at $55 each
April 14
Purchase
250 units at $22 each
April 20
Sale
200 units at $55 each
April 30
Purchase
240 units at $25 each
The company uses the perpetual inventory system What would be
the cost of the ending inventory under the following...
The following information was collected from the inventory records of a company for the month of...
The following information was collected from the inventory
records of a company for the month of March, 2010. During March the
company sold 90 units of its product at $25 per unit.
Date
Units
Unit Cost
Total Cost
Beginning inventory
March 1
15
$10.00
$150
Purchase
March 5
35
$12.00
$420
Purchase
March 10
70
$14.00
$980
Purchase
March 17
25
$15.00
$375
Determine cost of goods sold under LIFO for the
month of March.
answer choices: 1285, 640, 1130,...
Case D. Stewart Company reports the following inventory records for November: INVENTORY Date Activity #...
Case D. Stewart Company reports the following inventory records
for November:
INVENTORY
Date
Activity
# of Units
Cost/Unit
November 1
Beginning balance
125
$
16
November 4
Purchase
330
17
November 7
Sale (@ $57 per unit)
210
November 13
Purchase
510
19
November 22
Sale (@ $57 per unit)
505
Selling, administrative, and depreciation expenses for the month
were $15,500. Stewart’s tax rate is 30
percent.
1. Calculate the cost of ending inventory and
the cost of goods...
The periodic inventory records of Flexon Prosthetics indicate the following at October 31: Oct.1 Beginning inventory...
The periodic inventory records of Flexon Prosthetics indicate
the following at October 31:
Oct.1
Beginning inventory
9 units @ $60
8
Purchase
4 units @ 60
15
Purchase
10 units @ 70
26
Purchase
3 units @ 80
At October 31 Flexon counts 8 units of inventory on hand.
Requirements:
Compute ending inventory and cost of goods sold, using each of
the following methods:
1. Average cost (round average unit cost to the nearest
cent)
3. FIFO
4. LIFO
The following information is taken from the inventory records of the CNB Company for the month...
The following information is taken from the inventory records of
the CNB Company for the month of September:
Beginning inventory, 9/1/2021
6,300
units @ $11.00
Purchases:
9/7
4,200
units @ $11.60
9/25
10,500
units @ $12.20
Sales:
9/10
5,000
units
9/29
6,000
units
10,000 units were on hand at the end of
September.
Required:
1. Assuming that CNB uses a periodic inventory
system and employs the average cost method, determine cost of goods
sold for September and September's ending inventory....
The following information is taken from the inventory records of the CNB Company for the month...
The following information is taken from the inventory records of
the CNB Company for the month of September:
Beginning inventory, 9/1/2021
7,000
units @ $10.00
Purchases:
9/7
3,000
units @ $11.00
9/25
10,000
units @ $11.50
Sales:
9/10
4,000
units
9/29
5,000
units
11,000 units were on hand at the end of
September.
Required:
1. Assuming that CNB uses a periodic inventory
system and employs the average cost method, determine cost of goods
sold for September and September's ending inventory....
Hess Company's inventory records show the following data for the month of September: &
Hess Company's inventory records show the following data
for the month of September:
Units
Unit Cost
Inventory, September
1
100
$3.00
Purchases: September
8
450
3.50
September
18
300
3.70
A physical inventory on September 30 shows 150 units on
hand.
a. Calculate the value of ending
inventory and cost of goods sold if the company uses
FIFO inventory costing
and a periodic inventory system.
b. Calculate the value of ending
inventory and cost of goods sold if...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- All else being equal, if a nation decided to intervene in free trade anyways, which of...
- Consider the following rates of return: Year / Large Company Stocks / US Treasury Bill 1...
- if I have results gram positive and Acid fast negative rod shape bacili you thing it's...
- 1)What are constellations, how many are there? 2) What and where is the zodiac? 2)Describe latitude,...
- “If a person owns 80% of the shares in a company then they can make any...
- 5. Anyone who has ever owned a car will recognize the following situations. Suggest what might...
- in order for IT to be successful in business, the organization must plan how to use...
ADVERTISEMENT