Question

In: Accounting

Compute the April cost of goods sold using moving average method, and LIFO method. Units Unit...

Compute the April cost of goods sold using moving average method, and LIFO method.

Units

Unit Cost

Total Cost

April 1 inventory

300

$35

$10,500

April 15 purchase

400

$40

$16,000

April 16 sales

205

April 23 purchase

200

$45

$9,000

April 24 sales

305

Solutions

Expert Solution

Answer:

Using the Moving Average Method:

Date Particulars Units Unit Cost Average Unit Cost Amount
April 1 Opening Inventory 300 35 35 10500
April 15 Purchase 400 40 16000
April 16 Sales 205 37.86 7761.30
April 23 Purchase 200 45 9000
April 24 Sales 305 39.91 12172.55
April Closing Inventory 390 39.91 15564.90

Cost of Goods sold using Moving Average method are as follows:

Particulars Amount
Opening Inventory 10500
Add: Purchase 25000
Less: Closing Inventory 15564.90
Cost of Goods Sold 19935.10

Using LIFO Method:

Date Particulars Units Unit Cost Amount Working
April 1 Opening Inventory 300 35 10500
April 15 Purchase 400 40 16000
April 16 Sales 205 40 8200 205*40
April 23 Purchase 200 45 9000
April 24 Sales 305 13200 (200*45)+(105*40)
April Closing Inventory 390 14100 (90*40)+(300*35)

Cost of Goods sold using LIFO method are as follows:

Particulars Amount
Opening Inventory 10500
Add: Purchase 25000
Less: Closing Inventory 14100
Cost of Goods Sold 21400

Related Solutions

Calculate the cost of goods sold and the cost of ending inventory using the FIFO, LIFO, and average cost methods.
Inventory Costing Methods: Periodic Inventory Systems. (Appendix 6B)Tyler Company has the following information related to purchases and sales of one of its inventory items.DateDescriptionUnits Purchased at CostUnits Sold at RetailSept. 1Beginning inventory20 units @ $510Purchase30 units @ $820Sales40 units @ $1525Purchase25 units at $10Assume that the company uses the periodic inventory system.Required:Calculate the cost of goods sold and the cost of ending inventory using the FIFO, LIFO, and average cost methods. (Note: Use four decimal places for per-unit calculations and...
Given the following​ data, calculate the cost of goods sold using the LIFO costing method assuming...
Given the following​ data, calculate the cost of goods sold using the LIFO costing method assuming that periodic inventory records are kept in dollars. Date Item Unit ​1/1 Beginning inventory 5 units at​ $22 per unit ​3/18 Purchase of inventory 11 units at​ $24 per unit ​6/20 Purchase of inventory 9 units at​ $27 per unit ​9/27 Purchase of inventory 28 units at​ $28 per unit ​11/27 Purchase of inventory 28 units at​ $29 per unit ​12/31 Ending inventory 18...
Calvin Clients Limited reported the inventory and cost of goods sold using the LIFO valuation method...
Calvin Clients Limited reported the inventory and cost of goods sold using the LIFO valuation method (perpetual) . The following table shows the details of purchases and sales for the year 2010. Assume that in each month the purchases happen at the start of the month and sales happened at the end of the month. Month Units purchased Units sold Coat per unit Price per unit January 50 0 100 150 March 100 25 110 150 May 0 60 n/a...
Calculate the cost of goods sold and the cost of the ending inventory using the LIFO...
Calculate the cost of goods sold and the cost of the ending inventory using the LIFO periodic cost flow assumption. Sales 97 units at $ 18 per unit Beginning inventory 88 units at $ 6 per unit Purchases 58 units at $ 10 per unit Calculate the cost of goods sold using the LIFO periodic cost flow assumption. Units x Cost per Unit = Total Cost Units from beginning inventory x = Units from purchase x = Cost of Goods...
Compute ending inventory and cost of goods sold for the current year under FIFO, LIFO, and average cost inventory costing methods.
Penn Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1:Required Compute ending inventory and cost of goods sold for the current year under FIFO, LIFO, and average cost inventory costing methods.
Calculating the Value of Ending Inventory and Cost of Goods Sold: Perpetual Method Total Units Unit...
Calculating the Value of Ending Inventory and Cost of Goods Sold: Perpetual Method Total Units Unit Cost Total Cost Beginning inventory on hand 1-Jan 60,000 $2.00 $120,000 Purchases during month 5-Jan 103,600 $2.00 $207,200 20-Jan 293,900 $2.10 $617,190 Sales of inventory 25-Jan 383,900 Beginning inventory at 1-Feb 73,600 Purchases during month 8-Feb 282,200 $2.20 $620,840 23-Feb 153,500 $2.60 $399,100 Sales of inventory 27-Feb 407,600 Ending Inventory 101,700 LIFO Jan Feb Cost of goods sold Cost of goods sold Ending inventory...
Calculating the Value of Ending Inventory and Cost of Goods Sold: Perpetual Method Total Units Unit...
Calculating the Value of Ending Inventory and Cost of Goods Sold: Perpetual Method Total Units Unit Cost Total Cost Beginning inventory on hand 1-Jan 60,000 $2.00 $120,000 Purchases during month 5-Jan 103,600 $2.00 $207,200 20-Jan 293,900 $2.10 $617,190 Sales of inventory 25-Jan 383,900 Beginning inventory at 1-Feb 73,600 Purchases during month 8-Feb 282,200 $2.20 $620,840 23-Feb 153,500 $2.60 $399,100 Sales of inventory 27-Feb 407,600 Ending Inventory 101,700 FIFO Jan Feb Cost of goods sold Cost of goods sold Ending inventory...
Calculating the Value of Ending Inventory and Cost of Goods Sold: Perpetual Method Total Units Unit...
Calculating the Value of Ending Inventory and Cost of Goods Sold: Perpetual Method Total Units Unit Cost Total Cost Beginning inventory on hand 1-Jan 60,000 $2.00 $120,000 Purchases during month 5-Jan 103,600 $2.00 $207,200 20-Jan 293,900 $2.10 $617,190 Sales of inventory 25-Jan 383,900 Beginning inventory at 1-Feb 73,600 Purchases during month 8-Feb 282,200 $2.20 $620,840 23-Feb 153,500 $2.60 $399,100 Sales of inventory 27-Feb 407,600 Ending Inventory 101,700 LIFO Jan Feb Cost of goods sold Cost of goods sold Ending inventory...
eriodic Inventory Using FIFO, LIFO, and Weighted Average Cost Method. The units of an item available...
eriodic Inventory Using FIFO, LIFO, and Weighted Average Cost Method. The units of an item available for sale during the year were as follows: Jan. 1 Inventory 10 units at $39 $390 Aug. 13 Purchase 17 units at $40 680 Nov. 30 Purchase 13 units at $41 533 Available for sale 40 units $1,603 There are 16 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a)...
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Method. The units of an item available...
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Method. The units of an item available for sale during the year were as follows: Jan. 1 Inventory 14 units at $27 $378 Aug. 13 Purchase 19 units at $30 570 Nov. 30 Purchase 11 units at $32 352 Available for sale 44 units $1,300 There are 17 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT