Answer- 1)- Cost of ending inventory using FIFO method = $77340.
Explanation-
FIFO Method | ||||||||
Goods purchased | Cost of goods sold | Inventory balance | ||||||
Date | # of units | Cost per unit | # of units sold | Cost per unit | Cost of goods sold | # of units | Cost per unit | Inventory balance |
Jan-01 | 3200 | 17.6 | 56320 | |||||
Jan-23 | 4300 | 16.40 | 3200 | 17.6 | 56320 | |||
4300 | 16.40 | 70520 | ||||||
Feb-14 | 1400 | 16.70 | 3200 | 17.60 | 56320 | |||
4300 | 16.40 | 70520 | ||||||
1400 | 16.70 | 23380 | ||||||
Mar-17 | 2400 | 17.70 | 3200 | 17.60 | 56320 | |||
4300 | 16.40 | 70520 | ||||||
1400 | 16.70 | 23380 | ||||||
2400 | 17.70 | 42480 | ||||||
Apr-13 | 3200 | 17.60 | 56320 | 2300 | 17.70 | 40710 | ||
4300 | 16.40 | 70520 | ||||||
1400 | 16.70 | 23380 | ||||||
100 | 17.70 | 1770 | ||||||
May-05 | 5500 | 15.60 | 2300 | 17.70 | 40710 | |||
5500 | 15.60 | 85800 | ||||||
Jul-04 | 3700 | 16.80 | 2300 | 17.70 | 40710 | |||
5500 | 15.60 | 85800 | ||||||
3700 | 16.80 | 62160 | ||||||
Oct-31 | 2300 | 17.70 | 40710 | 2900 | 16.80 | 48720 | ||
5500 | 15.60 | 85800 | ||||||
800 | 16.80 | 13440 | ||||||
Nov-22 | 1800 | 15.90 | 2900 | 16.80 | 48720 | |||
1800 | 15.90 | 28620 | ||||||
Totals | 17600 | 291940 | 4700 | 77340 |
2)- Cost of good sold using LIFO method =$290820.
Explanation-
LIFO Method | ||||||||
Goods purchased | Cost of goods sold | Inventory balance | ||||||
Date | # of units | Cost per unit | # of units sold | Cost per unit | Cost of goods sold | # of units | Cost per unit | Inventory balance |
Jan-01 | 3200 | 17.6 | 56320 | |||||
Jan-23 | 4300 | 16.40 | 3200 | 17.6 | 56320 | |||
4300 | 16.40 | 70520 | ||||||
Feb-14 | 1400 | 16.70 | 3200 | 17.60 | 56320 | |||
4300 | 16.40 | 70520 | ||||||
1400 | 16.70 | 23380 | ||||||
Mar-17 | 2400 | 17.70 | 3200 | 17.60 | 56320 | |||
4300 | 16.40 | 70520 | ||||||
1400 | 16.70 | 23380 | ||||||
2400 | 17.70 | 42480 | ||||||
Apr-13 | 2400 | 17.70 | 42480 | 2300 | 17.60 | 40480 | ||
1400 | 16.70 | 23380 | ||||||
4300 | 16.40 | 70520 | ||||||
900 | 17.60 | 15840 | ||||||
May-05 | 5500 | 15.60 | 2300 | 17.60 | 40480 | |||
5500 | 15.60 | 85800 | ||||||
Jul-04 | 3700 | 16.80 | 2300 | 17.60 | 40480 | |||
5500 | 15.60 | 85800 | ||||||
3700 | 16.80 | 62160 | ||||||
Oct-31 | 3700 | 16.80 | 62160 | 2300 | 17.60 | 40480 | ||
4900 | 15.60 | 76440 | 600 | 15.60 | 9360 | |||
0 | ||||||||
Nov-22 | 1800 | 15.90 | 2300 | 17.60 | 40480 | |||
600 | 15.60 | 9360 | ||||||
1800 | 15.90 | 28620 | ||||||
Totals | 17600 | 290820 | 4700 | 78460 |
an.) i Data Table Units Unit Cost 3,200 17.60 4,300 16.40 1,400 16.70 17.70 Transaction Beginning...
Data Table Assume that a company uses a perpetual inventory. Additional information follows: E(Click the icon to view the information.) Unit Cost Transaction Units Requirement 1. Assuming FIFO inventory costing, determine the cost of ending inventory: 17.50 Beginning inventory 1/1 3,300 Purchases, January 23 16.50 4,200 Purchases, February 14 16.90 1,400 Requirement 2. Assuming LIFO inventory costing, determine cost of goods sold for the year: Purchases, March 17 2,000 17.90 Units Sold-April 13 at $21 9,700 Purchases, May 5 15.20...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows: Inventory Purchases Sales May 1 1,400 units at $21 May 10 700 units at $23 May 12 980 units May 20 630 units at $25 May 14 840 units May 31 420 units a. Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of merchandise sold for each sale and the inventory balance after...
Dec. 1 Beginning merchandise inventory 13 units @ $11 each 8 Sale 9 units @ $24 each 14 Purchase 17 units @ $15 each 21 Sale 14 units @ $24 each Assume that Upper J Upper L ToysJ L Toys store bought and sold a line of dolls during DecemberDecember as follows: LOADING... (Click the icon to view the transactions.) Upper J Upper L ToysJ L Toys uses the perpetual inventory system.Read the requirements. LOADING... Requirement 1. Compute the cost...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows: Inventory Purchases Sales May 1 3,700 units at $23 May 10 1,850 units at $25 May 12 2,590 units May 20 1,665 units at $27 May 14 2,220 units May 31 1,110 units a. Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of merchandise sold for each sale and the inventory balance after...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows: Inventory Purchases Sales May 1 2,800 units at $21 May 10 1,400 units at $23 May 12 1,960 units May 20 1 ,260 units at $25 May 14 1,680 units May 31 840 units a. Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of merchandise sold for each sale and the inventory balance...
Bridgeport Corp. reports the following for the month of June. Explanation Units Unit Cost Total Cost June 1 Inventory 12 Purchases 2,310 23 Purchases 1,358 30 Inventory 240 $ 580 Compute the cost of the ending inventory and the cost of goods sold under FIFO, LIFO, and average-cost. (For calculation purposes, round to 3 decimal places, e.g. 5.275. Round answers to decimal places, e.g. 125.) FIFO LIFO Average-cost The cost of the ending inventory The cost of goods sold Click...
Shellhammer Company's inventory records show the following data
for the month of September:
Units
Unit Cost
Inventory,
September 1
100
$3.34
Purchases:
September 8
450
3.50
September 18
350
3.70
A physical inventory on September 30 shows 200 units on hand.
Calculate the value of ending inventory and cost of goods sold if
the company uses LIFO inventory costing and a periodic inventory
system.
Ending inventory
$
Cost of goods sold
$
ZYX Pte Ltd had a beginning inventory of 600 units (unit cost $24) for a product for the month of May. Information relating to the purchases and sales for the month were as follows: Purchases Units Cost ($) May 3 400 30 May 10 200 34 May 19 600 40 Sales Units Sales Price ($) May 8 600 60 May 13 500 80 Required: **ONLY NEED TO ANSWER PART B Determine the cost of goods sold and cost of ending...
Bramble Company's inventory records show the following data for
the month of September:
Units
Unit Cost
Inventory,
September 1
100
$2.85
Purchases:
September 8
440
3.50
September 18
300
4.00
A physical inventory on September 30 shows 160 units on hand.
Calculate the value of ending inventory and cost of goods sold if
the company uses LIFO inventory costing and a periodic inventory
system.
Ending inventory
$enter a value of ending inventory in dollars
Cost of goods sold
$enter a...
Bridgeport Company's inventory records show the following data for the month of September: Units Unit Cost Inventory, September 1 90 $2.85 Purchases: September 8 460 $3.50 September 18 300 $3.90 A physical inventory on September 30 shows 160 units on hand. Calculate the value of ending inventory and cost of goods sold if the company uses LIFO inventory costing and a periodic inventory system. Ending inventory: $ enter a value of ending inventory in dollars Cost of goods sold: $...