PART ONE:
a. using the weighted average perpetual inventory method.
b. using the LIFO perpetual inventory method.
c. using the FIFO perpetual inventory method.
March beginning inventory is 5 units at $6 per unit.
March 3: 15 units were purchased at $7 per unit.
March 11: 10 units were purchased at $9 per unit.
March 15: 20 units were sold at $15 per unit.
March 18: 35 units were purchased at $10 per unit.
March 31: 30 units were sold at $20 per unit.
PART TWO :
1) compute the cost of goods sold on March 15 and March 31 for a, b, c.
2) compute the ending inventory for a, b, c.
3) make the journal entries necessary for March 15 and March 31 for a. b. c.
CALCULATE JOURNAL ENTRIES FROM ABOVE INFORMATION:
JOURNAL ENTRIES:
Answer 1 & 2. | |||||||||
Weighted Average | |||||||||
Date | Purchases | Cost of Goods Sold | Balance | ||||||
Unit | Cost | Total | Unit | Cost | Total | Unit | Cost | Total | |
1-Mar | 5.00 | 6.00 | 30.00 | ||||||
3-Mar | 15.00 | 7.00 | 105.00 | 5.00 | 6.00 | 30.00 | |||
15.00 | 7.00 | 105.00 | |||||||
20.00 | 6.75 | 135.00 | |||||||
11-Mar | 10.00 | 9.00 | 90.00 | 20.00 | 6.75 | 135.00 | |||
10.00 | 9.00 | 90.00 | |||||||
30.00 | 7.50 | 225.00 | |||||||
15-Mar | 20.00 | 7.50 | 150.00 | 10.00 | 7.50 | 75.00 | |||
18-Mar | 35.00 | 10.00 | 350.00 | 10.00 | 7.50 | 75.00 | |||
35.00 | 10.00 | 350.00 | |||||||
45.00 | 9.44 | 425.00 | |||||||
31-Mar | 30.00 | 9.44 | 283.33 | 15.00 | 9.44 | 141.67 | |||
Total | 60.00 | 545.00 | 50.00 | 433.33 | |||||
LIFO | |||||||||
Date | Purchases | Cost of Goods Sold | Balance | ||||||
Unit | Cost | Total | Unit | Cost | Total | Unit | Cost | Total | |
1-Mar | 5.00 | 6.00 | 30.00 | ||||||
3-Mar | 15.00 | 7.00 | 105.00 | 5.00 | 6.00 | 30.00 | |||
15.00 | 7.00 | 105.00 | |||||||
20.00 | 135.00 | ||||||||
11-Mar | 10.00 | 9.00 | 90.00 | 5.00 | 6.00 | 30.00 | |||
15.00 | 7.00 | 105.00 | |||||||
10.00 | 9.00 | 90.00 | |||||||
30.00 | 7.50 | 225.00 | |||||||
15-Mar | 10.00 | 9.00 | 90.00 | 5.00 | 6.00 | 30.00 | |||
10.00 | 7.00 | 70.00 | 5.00 | 7.00 | 35.00 | ||||
20.00 | 160.00 | 10.00 | 65.00 | ||||||
18-Mar | 35.00 | 10.00 | 350.00 | 5.00 | 6.00 | 30.00 | |||
5.00 | 7.00 | 35.00 | |||||||
35.00 | 10.00 | 350.00 | |||||||
45.00 | 9.22 | 415.00 | |||||||
31-Mar | 30.00 | 10.00 | 300.00 | 5.00 | 6.00 | 30.00 | |||
5.00 | 7.00 | 35.00 | |||||||
5.00 | 10.00 | 50.00 | |||||||
15.00 | 115.00 | ||||||||
Total | 60.00 | 545.00 | 50.00 | 460.00 | |||||
FIFO | |||||||||
Date | Purchases | Cost of Goods Sold | Balance | ||||||
Unit | Cost | Total | Unit | Cost | Total | Unit | Cost | Total | |
1-Mar | 5.00 | 6.00 | 30.00 | ||||||
3-Mar | 15.00 | 7.00 | 105.00 | 5.00 | 6.00 | 30.00 | |||
15.00 | 7.00 | 105.00 | |||||||
20.00 | 135.00 | ||||||||
11-Mar | 10.00 | 9.00 | 90.00 | 5.00 | 6.00 | 30.00 | |||
15.00 | 7.00 | 105.00 | |||||||
10.00 | 9.00 | 90.00 | |||||||
30.00 | 7.50 | 225.00 | |||||||
15-Mar | 5.00 | 6.00 | 30.00 | 10.00 | 9.00 | 90.00 | |||
15.00 | 7.00 | 105.00 | |||||||
20.00 | 135.00 | ||||||||
18-Mar | 35.00 | 10.00 | 350.00 | 10.00 | 9.00 | 90.00 | |||
35.00 | 10.00 | 350.00 | |||||||
45.00 | 9.78 | 440.00 | |||||||
31-Mar | 10.00 | 9.00 | 90.00 | 15.00 | 10.00 | 150.00 | |||
20.00 | 10.00 | 200.00 | |||||||
30.00 | 290.00 | ||||||||
Total | 60.00 | 545.00 | 50.00 | 425.00 |
Answer 3. | |||
Journal Entry | |||
Weighted Average Method | |||
Date | Particulars | Dr. Amt. | Cr. Amt. |
3-Mar | Inventory | 105.00 | |
Accounts Payable / Cash | 105.00 | ||
(To record the purcahse of inventory) | |||
11-Mar | Inventory | 90.00 | |
Accounts Payable / Cash | 90.00 | ||
(To record the purcahse of inventory) | |||
15-Mar | Accounts Receivable / Cash | 300.00 | |
Sales | 300.00 | ||
(To record the sales) | |||
Cost of Goods Sold | 150.00 | ||
Inevntory | 150.00 | ||
(To record the Cost of Goods Sold) | |||
18-Mar | Inventory | 350.00 | |
Accounts Payable / Cash | 350.00 | ||
(To record the purcahse of inventory) | |||
31-Mar | Accounts Receivable / Cash | 600.00 | |
Sales | 600.00 | ||
(To record the sales) | |||
Cost of Goods Sold | 283.33 | ||
Inevntory | 283.33 | ||
(To record the Cost of Goods Sold) | |||
Journal Entry | |||
LIFO | |||
Date | Particulars | Dr. Amt. | Cr. Amt. |
3-Mar | Inventory | 105.00 | |
Accounts Payable / Cash | 105.00 | ||
(To record the purcahse of inventory) | |||
11-Mar | Inventory | 90.00 | |
Accounts Payable / Cash | 90.00 | ||
(To record the purcahse of inventory) | |||
15-Mar | Accounts Receivable / Cash | 300.00 | |
Sales | 300.00 | ||
(To record the sales) | |||
Cost of Goods Sold | 160.00 | ||
Inevntory | 160.00 | ||
(To record the Cost of Goods Sold) | |||
18-Mar | Inventory | 350.00 | |
Accounts Payable / Cash | 350.00 | ||
(To record the purcahse of inventory) | |||
31-Mar | Accounts Receivable / Cash | 600.00 | |
Sales | 600.00 | ||
(To record the sales) | |||
Cost of Goods Sold | 300.00 | ||
Inevntory | 300.00 | ||
(To record the Cost of Goods Sold) | |||
Journal Entry | |||
FIFO | |||
Date | Particulars | Dr. Amt. | Cr. Amt. |
3-Mar | Inventory | 105.00 | |
Accounts Payable / Cash | 105.00 | ||
(To record the purcahse of inventory) | |||
11-Mar | Inventory | 90.00 | |
Accounts Payable / Cash | 90.00 | ||
(To record the purcahse of inventory) | |||
15-Mar | Accounts Receivable / Cash | 300.00 | |
Sales | 300.00 | ||
(To record the sales) | |||
Cost of Goods Sold | 135.00 | ||
Inevntory | 135.00 | ||
(To record the Cost of Goods Sold) | |||
18-Mar | Inventory | 350.00 | |
Accounts Payable / Cash | 350.00 | ||
(To record the purcahse of inventory) | |||
31-Mar | Accounts Receivable / Cash | 600.00 | |
Sales | 600.00 | ||
(To record the sales) | |||
Cost of Goods Sold | 290.00 | ||
Inevntory | 290.00 | ||
(To record the Cost of Goods Sold) |
PART ONE: a. using the weighted average perpetual inventory method. b. using the LIFO perpetual inventory...
Given the following information, determine the journal entries: a. using the weighted average perpetual inventory method. b. using the LIFO perpetual inventory method. c. using the FIFO perpetual inventory method. March beginning inventory is 5 units at $6 per unit. March 3: 15 units were purchased at $7 per unit. March 11: 10 units were purchased at $9 per unit. March 15: 20 units were sold at $15 per unit. March 18: 35 units were purchased at $10 per...
Compute the cost assigned to ending inventory using (a) FIFO, (b) LIFO, (c) weighted average, and (d) specific identification. For specific identification, units sold consist of 600 units from beginning inventory, 380 from the February 10 purchase, 120 from the March 13 purchase, 130 from the August 21 purchase, and 205 from the September 5 purchase. (Round your average cost per unit to 2 decimal places.) Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases...
Please fix Perpetual FIFO and Perpetual LIFO. and do the Weighted Average and Specific Id. Required information [The following information applies to the questions displayed below.] Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March. Units Sold at Retail Units Acquired at Cost 250 units @ $54.00 per unit 300 units @ $59.00 per unit 410 units@ $89.00 per unit Date Activities Mar. 1 Beginning inventory Mar. 5 Purchase Mar. 9...
29A Accounting for inventory using the perpetual inventory system/FIFO, LIFO, and weighted average, and comparing FIFO, LIFO, and weighted-average Iron Man began August with 65 units of iron inventory that cost $30 each. During August, the company completed the following inventory transactions: Units Unit Cost Unit Sale Price $ 81 Aug. 3 8 85 $50 Sale Purchase Sale Purchase 75 45 Requirements 1. Prepare a perpetual inventory record for the merchandise inventory using the FIFO inventory costing method. 2. Prepare...
P6-29A Accounting for inventory using the perpetual inventory system FIFO, LIFO, and weighted-average, and comparing FIFO, LIFO, and weighted-average Learning Objectives 2, 3 5. FIFO GP $5,235 Steel Mill began August with 50 units of iron inventory that cost $35 each. During August, the company completed the following inventory transactions: Units Unit Cost Unit Sales Price Aug. 3 Sale 45 $85 8 Purchase 90 $54 21 Sale 85 88 30 Purchase 15 58 Requirements 1. Prepare a perpetual inventory record...
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 15 units at $28 $420 Aug. 7 Purchase 18 units at $31 558 Dec. 11 Purchase 14 units at $33 462 47 units $1,440 There are 20 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a) the first-in, first-out...
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 10 units at $29 $290 Aug. 7 Purchase 19 units at $31 589 Dec. 11 Purchase 10 units at $32 320 39 units $1,199 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) the first-in, first-out...
periodic inventory using FIFO, LIFO, and weighted average cost methods Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: 12 units at $35 $420 Jan. 1 Inventory 540 Purchase 15 units at $36 Aug. 7 380 Purchase 10 units at $38 Dec. 11 $1,340 37 units There are 20 units of the item in the physical inventory at December 31. The periodic inventory system is...
Compute the cost assigned to ending inventory using (a) FIFO, (b) LIFO, (c) weighted average, and (d) specific identification. Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March. Date Activities Units Acquired at Cost Units Sold at Retail Mar. 1 Beginning inventory 210 units @ $53.20 per unit Mar. 5 Purchase 280 units @ $58.20 per unit Mar. 9 Sales 370 units @ $88.20 per unit Mar. 18 Purchase 140 units...
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 10 units at $35 $350 Aug. 13 Purchase 18 units at $36 648 Nov. 30 Purchase 13 units at $38 494 Available for sale 41 units $1,492 There are 20 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using (a)...