Question

EBECEDE Company has the following inventory transactions for the month of February:

	Units	Unit Cost
Beginning, Feb. 1	10,000	40
Purchases, Feb. 10	10,000	43
Sold, Feb. 15	15,000
Purchases, Feb. 18	5,000	44
Sold, Feb. 25	2,000

The company uses the perpetual inventory system. Determine the cost of inventory on February 29 and cost of goods sold under:

Inventory Cost Flow	Ending Inventory	Cost of Goods Sold (COGS
First in, first out (FIFO)
Weighted Average
Last in, first out (LIFO)

Answer 1

Answer:

Inventory Cost Flow	Ending Inventory	Cost of Goods Sold (COGS)
First in, first out (FIFO)	349,000	701,000
Weighted Average	342,000	708,000
Last in, first out (LIFO)	332,000	718,000

Calculation:

Here we need to determine the cost of inventory on February 29 and cost of goods sold under the FIFO, LIFO and Weighted Average method. Here the company uses the  perpetual inventory system.

So using the FIFO method, the first balance of the inventory bought will be sold first. Even if there will be another purchases during the month the first purchase inventory will be sold. Here there is first two purchases on 1st and 10th, so when the sale is happend on 15th, the first set of inventory sold will be from 1st. The calculation is shown below:

Date	# of Units	Cost per Unit	Goods Purchased	# of Units	Cost per Unit	Goods Sold	# of Units	Cost per Unit	Inventory Balance
Feb-01	10,000	40	400,000				10,000	40	400,000
Feb-10	10,000	43	430,000				10,000	40	400,000
							10,000	43	430,000
									830,000
Feb-15				10,000	40	400,000	5,000	43	215,000
				5,000	43	215,000
Feb-18	5,000	44	220,000				5,000	43	215,000
							5,000	44	220,000
									435,000
Feb-25				2,000	43	86,000	3,000	43	129,000
							5,000	44	220,000
				17,000		701,000	8,000		349,000

So using the Weighted average method, we need to find the average of the inventory soon after a purchase happens. So here first we need to add up the 1st and 10th purchase and then add up the balance Then we need to divide it with the units. Like that we need to do the rest of the balances.

Cost per Unit = Inventory Balance / # of Units

Date	# of Units	Cost per Unit	Goods Purchased	# of Units	Cost per Unit	Goods Sold	# of Units	Cost per Unit	Inventory Balance
Feb-01	10000	40	400000				10000	40	400000
Feb-10	10000	43	430000				10000	40	400000
							10000	43	430000
							20000	41.5	830000
Feb-15				15000	41.5	622500	5000	41.5	207500
Feb-18	5000	44	220000				5000	41.5	207500
							5000	44	220000
							10000	42.75	427500
Feb-25				2000	42.75	85500	8000	42.75	342000
				17000		708000

So using the LIFO method, the last balance of the inventory bought will be sold first. Even if there will be first purchase balances in the month the last purchase inventory will be sold. Here there is first two purchases on 1st and 10th, so when the sale is happend on 15th, the sale will be of from 10th first. The calculation is shown below:

Date	# of Units	Cost per Unit	Goods Purchased	# of Units	Cost per Unit	Goods Sold	# of Units	Cost per Unit	Inventory Balance
Feb-01	10000	40	400000				10000	40	400000
Feb-10	10000	43	430000				10000	40	400000
							10000	43	430000
									830000
Feb-15				10000	43	430000	5000	40 ekkarill92 Next > < Previous Related Solutions AU Company has the following inventory transactions for the month of March: Units Unit Cost Beginning,... AU Company has the following inventory transactions for the month of March: Units Unit Cost Beginning, Mar. 1 10,000 15 Purchases, Mar. 10 20,000 18 Sold, Mar. 15 15,000 Purchases, Mar. 18 5,000 23 Sold, Mar. 25 6,000 The company uses the perpetual inventory system. Determine the cost of inventory on March 31 and cost of goods sold under: Inventory Cost Flow Ending Inventory Cost of Goods Sold First in, first out (FIFO) Moving Average Last in, first out (LIFO) A company has beginning inventory of 17 units at a cost of $17 each on February... A company has beginning inventory of 17 units at a cost of $17 each on February 1. On February 3, it purchases 27 units at $19 each. 21 units are sold on February 5. Using the FIFO periodic inventory method, what is the cost of the 21 units that are sold? Henry Company reported the following information for 2017: TRANSACTIONS UNITS UNIT COST Beginning Inventory – January... Henry Company reported the following information for 2017: TRANSACTIONS UNITS UNIT COST Beginning Inventory – January 1 6,000 $ 3.00 Purchases April 10 9,000 3.50 July 20 5,000 3.80 November 24 5,000 4.00 During 2017, Henry sold 12,000 units. The company uses a periodic inventory system. REQUIRED: What is the value of ending inventory and cost of goods sold for 2017 under the following assumptions: FIFO LIFO Weighted-Average Randal company has the following inventory transactions for the month of April: Purchases: Units Cost Sales:... Randal company has the following inventory transactions for the month of April: Purchases: Units Cost Sales: Units April 1 (beg. balance) 600 $6.00 April 3 500 4 1,500 $6.08 9 1,400 8 800 $6.40 11 600 13 1,200 $6.50 23 1,200 21 700 $6.60 27 900 29 500 $6.79 Instructions: 1) Assume Randal Company uses periodic inventory records. Determine the value of ending inventory using: a) FIFO b) LIFO c) Average-cost 2) Assume Randa lComapny uses perpetual inventory records. Determine... Potter Company has the following data​ available: Transaction Units Purchased Unit Cost Units Sold Beginning Inventory... Potter Company has the following data​ available: Transaction Units Purchased Unit Cost Units Sold Beginning Inventory 500 ​$10 March 1 Purchase 200 ​$12 April 25 Sale 350 June 10 Purchase 300 ​$14 July 20 Sale 250 October 30 Purchase 300 ​$15 December 15 Sale 400 If Potter Company uses a perpetual movingminus average inventory​ system, the cost of goods sold for the year is​ ________. ​ (Round average cost per unit to four decimal places and all other numbers to... The following are the transactions for the month of July. Units Unit Cost Unit Selling Price... The following are the transactions for the month of July. Units Unit Cost Unit Selling Price   July 1 Beginning Inventory 45 $ 10   July 13 Purchase 225 13   July 25 Sold ( 100 ) $ 15      July 31 Ending Inventory 170 Calculate cost of goods available for sale and ending inventory, then sales, cost of goods sold, and gross profit, under (a) FIFO, (b) LIFO, and (c) weighted average cost. Assume a periodic inventory system is used. (Round "Cost... The following are the transactions for the month of July. Units Unit Cost Unit Selling Price... The following are the transactions for the month of July. Units Unit Cost Unit Selling Price July 1 Beginning Inventory 53 $ 10 July 13 Purchase 265 13 July 25 Sold (100 ) $ 15 July 31 Ending Inventory 218 Calculate cost of goods available for sale and ending inventory, then sales, cost of goods sold, and gross profit, under FIFO. Assume a periodic inventory system is used. (Round "Cost per Unit" to 2 decimal places and your final answers... The following are the transactions for the month of July. Units Unit Cost Unit Selling Price... The following are the transactions for the month of July. Units Unit Cost Unit Selling Price July 1 Beginning Inventory 53 $ 10 July 13 Purchase 265 13 July 25 Sold (100 ) $ 15 July 31 Ending Inventory 218 Calculate cost of goods available for sale and ending inventory, then sales, cost of goods sold, and gross profit, under LIFO. Assume a periodic inventory system is used. (Round "Cost per Unit" to 2 decimal places and your final answers... The following are the transactions for the month of July. Units Unit Cost Unit Selling Price... The following are the transactions for the month of July. Units Unit Cost Unit Selling Price   July 1 Beginning Inventory 59 $ 10   July 13 Purchase 295 13   July 25 Sold ( 100 ) $ 15      July 31 Ending Inventory 254 Calculate cost of goods available for sale and ending inventory, then sales, cost of goods sold, and gross profit, under (a) FIFO, (b) LIFO, and (c) weighted average cost. Assume a periodic inventory system is used. (Round "Cost... The following are the transactions for the month of July. Units Unit Cost Unit Selling Price... The following are the transactions for the month of July. Units Unit Cost Unit Selling Price   July 1 Beginning Inventory 45 $ 10   July 13 Purchase 225 13   July 25 Sold ( 100 ) $ 15      July 31 Ending Inventory 170 Calculate cost of goods available for sale and ending inventory, then sales, cost of goods sold, and gross profit, under (a) FIFO, (b) LIFO, and (c) weighted average cost. Assume a periodic inventory system is used. (Round "Cost... ADVERTISEMENT Subjects Accounting Advanced Math Anatomy and Physiology Biology Chemistry Civil Engineering Computer Science Economics Electrical Engineering Finance History Math Mechanical Engineering Operations Management Physics Psychology Statistics and Probability Nursing Other ADVERTISEMENT Latest Questions For the following test items, define one error and propose a solution to the error. 1.... An empty parallel plate capacitor is connected between the terminals of a 10.7-V battery and charged... Let p0 = 1+x; p1 = 1+3x+x2; p2 = 2x+x2; p3 = 1+x+x2 2 R[x]. (a)... A: Provide a numerical example of how Earned Value Management may mislead us as to whether... Daryl wishes to save money to provide for his retirement. Beginning one month from now, he... L= {w belongs to {0,1}* | the number of 0's is a prime number} . Prove... What are Foyal's five management functions? Identify which organizational units accomplish these functions in your airport... ADVERTISEMENT About @ 2020 WizEdu