Question

In: Accounting

The beginning inventory was 320 units at a cost of $10 per unit. Goods available for...

The beginning inventory was 320 units at a cost of $10 per unit. Goods available for sale during the year were 1,360 units at a total cost of $15,060. In May, 620 units were purchased at a total cost of $6,820. The only other purchase transaction occurred during October. Ending inventory was 580 units.

Required:

a. Calculate the number of units purchased in October and the cost per unit purchased in October.

b-1. Assume the periodic inventory system is used. Calculate cost of goods sold and ending inventory using FIFO method. (Enter all values as a positive value.)

Periodic FIFO Cost of Goods Available for Sale Cost of Goods Sold Inventory Balance
# of units Cost per unit Cost of Goods Available for Sale # of units sold Cost per unit Cost of Goods Sold # of units in ending inventory Cost per unit Ending Inventory
Beg. Inventory 320 $10 $3,200
Purchases:
May 620 11 6,820
October 420 12 5,040
Total 1,360 $15,060 0 $0 0 $0

b-2. Assume the periodic inventory system is used. Calculate cost of goods sold and ending inventory using LIFO method. (Enter all values as a positive value.)

Periodic LIFO Cost of Goods Available for Sale Cost of Goods Sold Inventory Balance
# of units Cost per unit Cost of Goods Available for Sale # of units sold Cost per unit Cost of Goods Sold # of units in ending inventory Cost per unit Ending Inventory
Beg. Inventory $0
Purchases:
May 0
October 0
Total 0 $0 0 $0 0 $0

Solutions

Expert Solution

A. UNITS PURCHASED IN OCTOBER IS 420 AT THE RATE OF $12 PER UNIT.

B-1 FIFO - FIRST IN FIRST OUT.

Periodic FIFO Cost of Goods Available for Sale Cost of Goods Sold Inventory Balance
# of units Cost per unit Cost of Goods Available for Sale # of units sold Cost per unit Cost of Goods Sold # of units in ending inventory Cost per unit Ending Inventory
Beg. Inventory 320 $10 $3,200 320 $10 3200 0 0 0
Purchases:
May 620 11 6,820 460(780-320) 11 5060 160 11 1760
October 420 12 5,040 420 12 5040
Total 1,360 $15,060 780 $8260 580 $6800

ending inventory = beginning inventory + Purchased -sold

580 = 320 + 1040-sold

sold = 780

b-2. Assume the periodic inventory system is used. Calculate cost of goods sold and ending inventory using LIFO method. (Enter all values as a positive value.) LAST IN FIRST OUT

Periodic LIFO Cost of Goods Available for Sale Cost of Goods Sold Inventory Balance
# of units Cost per unit Cost of Goods Available for Sale # of units sold Cost per unit Cost of Goods Sold # of units in ending inventory Cost per unit Ending Inventory
Beg. Inventory 320 $10 $3,200 0 0 0 320 10 3200
Purchases:
May 620 11 6,820 360(780-420) 11 3960 260(620-360) 11 2860
October 420 12 5,040 420 12 5040 0 0 0
Total 1,360 $15,060 780 $9000 580 $6060

Related Solutions

Beginning Inventory # of units Cost per unit Total Beginning Inventory 15 $10 $150 Jan 1....
Beginning Inventory # of units Cost per unit Total Beginning Inventory 15 $10 $150 Jan 1. Purchase 15 $11 $165 Jan 10. Purchase 15 $12 $180 Total 45 1. During January, AA sold 20 units at $30 per unit. Under FIFO, how much is the Gross Profit? $365 $380 $390 $395 2. During January, AA sold 20 units at $30 per unit Under the Weighted Average Method, how much is the Gross Profit?. $365 $380 $395 $400 3. During January,...
Botter Company had a beginning inventory of 200 units at a cost of $13 per unit...
Botter Company had a beginning inventory of 200 units at a cost of $13 per unit on August 1. During the month, the following purchases and sales were made. Purchases Sales August 4 250 units at $14 August 7 150 units August 15 350 units at $15 August 11 100 units August 28 200 units at $16 August 17 300 units August 24 200 units Botter uses a periodic inventory system. Instructions Determine ending inventory and cost of goods sold...
Elston Company had a beginning inventory of 200 units at a cost of rm12 per unit...
Elston Company had a beginning inventory of 200 units at a cost of rm12 per unit on August 1. During the month, the following purchases and sales were made.             Purchases                                           ______________Sales     ________            August 4     250 units at RM13/unit                   August      7          150 units @ RM20 August 15   350 units at RM15/unit                   August      11        100 units @ RM20 August 28   200 units at RM14/unit                   August      17        250 units @ RM25                                                                           August      24        260 units @...
Ella Company had 160 units in beginning inventory at a total cost of $320. The company...
Ella Company had 160 units in beginning inventory at a total cost of $320. The company purchased 400 units at a total cost of $1,500. At the end of the year, Ella had 120 units in ending inventory Beginning 160 units ($2.00) $ 320 Purchases 500 units ($3.00) 1,500 Cost of goods available for sale $1,820 A physical count of ending inventory on June 30 reveals that there are 100 units on hand. REQUIREMENTS: Calculate the cost of ending inventory...
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...
Cost of goods available for sale consists of the: Select one: a. cost of beginning inventory...
Cost of goods available for sale consists of the: Select one: a. cost of beginning inventory and the cost of ending inventory. b. difference between the cost of goods purchased and the cost of sales during the year. c. cost of beginning inventory and the cost of goods purchased during the year. d. cost of ending inventory and the cost of goods purchased during the year.
Relationship between Inventory and COGS: Beginning Inventory + Purchases = Goods Available for Sale. Goods Available...
Relationship between Inventory and COGS: Beginning Inventory + Purchases = Goods Available for Sale. Goods Available for Sale = COGS + Ending Inventory 1. Which method yields higher net income? (Hint: Higher Ending Inventory means lower COGS. Lower COGS (COGS is an expense account) = Higher Net Income) 2. Which method would a business choose under the income statement approach? 3. Which method would a business choose under the Balance Sheet approach?
The following units are available for sale during the year: January 1 Beginning Inventory 10 units...
The following units are available for sale during the year: January 1 Beginning Inventory 10 units at $18 each April 3 Purchase 30 units at $20 each August 31 Purchase 28 units at $25 each September 29 Purchase 17 units at $30 each December 31 Ending Inventory 21 units Determine ending inventory cost by (a) FIFO method, (b) LIFO method, and (c) average cost method.
Periodic inventory by three methods; cost of goods sold The units of an item available for...
Periodic inventory by three methods; cost of goods sold The units of an item available for sale during the year were as follows: Jan. 1 Inventory 50 units at $98 Mar. 10 Purchase 70 units at $110 Aug. 30 Purchase 10 units at $118 Dec. 12 Purchase 70 units at $120 There are 80 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the ending inventory cost and the cost of...
Periodic inventory by three methods; cost of goods sold The units of an item available for...
Periodic inventory by three methods; cost of goods sold The units of an item available for sale during the year were as follows: Jan. 1 Inventory 40 units at $124 Mar. 10 Purchase 50 units at $136 Aug. 30 Purchase 20 units at $142 Dec. 12 Purchase 90 units at $144 There are 60 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the ending inventory cost and the cost of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT