3. Prepare journal entries to record the transactions that occurred in January 2018, assuming that FIFO is used for inventory costing. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.)
a. Record sales on account --> Jan. 10
b. Record cost of sales on goods sold on account --> Jan. 10
c. Record purchase of goods on account --> Jan. 12
d. Record sales on account --> Jan. 17
e. Record cost of sales on goods sold on account --> Jan. 17
f. Record purchase of goods on account --> Jan. 26
Calculation of Closing Inventory | |||||||||
Under Weighted Average cost method | |||||||||
Beginning Inventory | Changes during month | Closing Inventory | |||||||
units | price per unit | total | units | Cost per unit | total | units | price per unit | total | |
Beginning | 500 | $ 5 | $ 2,500 | 500 | $ 5 | $ 2,500 | |||
Sale | 500 | $ 5 | $ 2,500 | -400 | $ 5 | $ (2,000) | 100 | $ 5 | $ 500 |
Purchase | 100 | $ 5 | $ 500 | 600 | $ 6 | $ 3,600 | 700 | $ 5.86 | $ 4,100 |
Sale | 700 | $ 5.86 | $ 4,100 | -300 | $ 5.86 | $ (1,757) | 400 | $ 5.86 | $ 2,343 |
Purchase | 400 | $ 5.86 | $ 2,343 | 160 | $ 8 | $ 1,280 | 560 | $ 6.47 | $ 3,623 |
Total | 560 | $ 6.47 | $ 3,623 | ||||||
Under FIFO method | |||||||||
Beginning Inventory | Changes during month | Closing Inventory | |||||||
units | price per unit | total | units | Cost per unit | total | units | price per unit | total | |
Beginning | 500 | $ 5 | $ 2,500 | 500 | $ 5 | $ 2,500 | |||
Sale | 500 | $ 5 | $ 2,500 | -400 | $ 5 | $ (2,000) | 100 | $ 5 | $ 500 |
Purchase | 100 | $ 5 | $ 500 | 600 | $ 6 | $ 3,600 | 100 | $ 5 | $ 500 |
600 | $ 6 | $ 3,600 | |||||||
Sale | 100 | $ 5 | $ 500 | -100 | $ 5 | $ (500) | |||
600 | $ 6 | $ 3,600 | -200 | $ 6 | $ (1,200) | 400 | $ 6 | $ 2,400 | |
Purchase | 400 | $ 6 | $ 2,400 | 160 | $ 8 | $ 1,280 | 400 | $ 6 | $ 2,400 |
160 | $ 8 | $ 1,280 | |||||||
Total | 560 | $ 3,680 | |||||||
Under Specific Identification method | |||||||||
Beginning Inventory | Changes during month | Closing Inventory | |||||||
units | price per unit | total | units | Cost per unit | total | units | price per unit | total | |
Beginning | 500 | $ 5 | $ 2,500 | 500 | $ 5 | $ 2,500 | |||
Sale | 500 | $ 5 | $ 2,500 | -400 | $ 5.00 | $ (2,000) | 100 | $ 5 | $ 500 |
Purchase | 100 | $ 5 | $ 500 | 600 | $ 6.00 | $ 3,600 | 100 | $ 5 | $ 500 |
600 | $ 6 | $ 3,600 | |||||||
Sale | 100 | $ 5 | $ 500 | 100 | $ 5 | $ 500 | |||
600 | $ 6 | $ 3,600 | -300 | $ 6.00 | $ (1,800) | 300 | $ 6 | $ 1,800 | |
Purchase | 100 | $ 5 | $ 500 | 160 | $ 8.00 | $ 1,280 | 100 | $ 5 | $ 500 |
300 | $ 6 | $ 1,800 | 300 | $ 6 | $ 1,800 | ||||
160 | $ 8 | $ 1,280 | |||||||
Total | 560 | $ 3,580 | |||||||
REGINA COMPANY | ||||||
Partial Statement of Earnings | ||||||
For the Month ended January 31, 2018 | ||||||
(a) | (b) | (c ) | ||||
Weighted Average Cost | FIFO | Specific Identification | ||||
Sales (Units sold(700)*$18) | $ 12,600 | $ 12,600 | $ 12,600 | |||
Closing Inventory | $ 3,623 | $ 3,680.00 | $ 3,580 | |||
Less: Purchases | $ 4,880 | $ 4,880.00 | $ 4,880 | |||
Less: opening Inventory | $ 2,500 | $ 2,500 | $ 2,500 | |||
Gross profit | $ 8,843 | $ 8,900.00 | $ 8,800.00 | |||
(2a) Highest Pretax earning is under FIFO method | ||||||
(2b) Lowest Tax expense would under Specific Identification Method, Because of the lowest pretax earnings | ||||||
(2c) Most favourable method for cash flow is FIFO method. Because it got highest cash flows |
3 | Journal Entries | |||||
Date | Particulars | Debit | Credit | |||
Jan-10 | Accounts Receivables A/c Dr. | $7,200.00 | ||||
To Sales A/c | $7,200.00 | |||||
Jan-10 | Cost of goods sold A/c Dr. | $2,000.00 | ||||
To Inventory A/c | $2,000.00 | |||||
Jan-12 | Purchases A/c Dr. | $3,600.00 | ||||
To Accounts Payable A/c | $3,600.00 | |||||
Jan-17 | Accounts Receivables A/c Dr. | $5,400.00 | ||||
To Sales A/c | $5,400.00 | |||||
Jan-17 | Cost of goods sold A/c Dr. | $1,700.00 | ||||
To Inventory A/c | $1,700.00 | |||||
Jan-26 | Purchases A/c Dr. | $1,280.00 | ||||
To Accounts Payable A/c | $1,280.00 |
3. Prepare journal entries to record the transactions that occurred in January 2018, assuming that FIFO...
At the end of January 2018, the records of Regina Company showed the following for a particular item that sold at $18 per unit. Assume that all sales and purchases are on account: Transactions Units Amount $2,500 Inventory, January 1, 2018 Sale, January 10 Purchase, January 12 Sale, January 17 Purchase, January 26 500 (400) 600 3,600 (300) 160 1,280 Required: 1. Assuming the use of a perpetual inventory system, prepare a summarized statement through gross profit on sales under...
Needs to be done on an excel with fifo, lifo, specific
identification, weighted average, journal entries, and cogs plus
ending inventory seperated and filled out.
3 Northgate Products Corp. sells gadgets and uses the perpetual inventory system. During the 4 month of January 2019, the number of gadgets purchased and sold was as follows: Purchased Sold Balance in inventory Date Units Unit cost Total $ Units Unit cost Total $ Total $ Units Unit cost 200 $2/ Jan. 1 3...
Required information Use the following information for the Exercises below. [The following information applies to the questions displayed below.) Laker Company reported the following January purchases and sales data for its only product. Units sold at Activities Units Acquired at Cost Retail Jan. 1 Beginning inventory 140 units @ $6.00 = $ 840 Jan. 10 Sales 100 units @ $15 Jan. 20 Purchase 60 units @ $5.00 = 300 Jan. 25 Sales se units @ $15 Jan. 30 Purchase 180...
Required information Use the following information for the Exercises below. [The following information applies to the questions displayed below.) Laker Company reported the following January purchases and sales data for its only product. Date Activities Jan. 1 Beginning inventory Jan. 10 Sales Jan. 20 Purchase Jan. 25 Sales Jan. 30 Purchase Totals Units Acquired at Cost Units sold at Retail 185 units @ $11.00 - $2,035 145 units @ $20.00 100 units @ $10.00 - 1,000 125 units @ $20.00...
Chapter 05 Homework A Saved Required information [The following information applies to the questions displayed below.) Part 1 of 2 Laker Company reported the following January purchases and sales data for its only product. Units sold at Retail points Units Acquired at Cost 200 units @ $12.50 = $2,500 Date Activities Jan. 1 Beginning inventory Jan. 10 Sales Jan. 20 Purchase Jan. 25 Sales Jan. 30 Purchase Totals 130 units @ $11.50 = 1,495 160 units @ $21.50 140 units...
Required information The following information applies to the questions displayed below.) Laker Company reported the following January purchases and sales data for its only product Date Activities Units Acquired at Cost Units sold at Retail Jan. 1 Beginning inventory 155 units $8.00 - $1,240 Jan. 10 Sales 115 units $17.00 Jan. 20 Purchase 90 units $7.00 - 630 Jan. 25 Sales 95 units $17.00 Jan. 30 Purchase 210 unitse $6.50- 1,365 Totals 455 units $3,235 210 units Required: The Company...
Required information The following information applies to the questions displayed below.) Laker Company reported the following January purchases and sales data for its only product. Date Activities Beginning Jan. 1 inventory Jan. 10 Sales Jan. 20 Purchase Jan. 25 Sales Jan. 30 Purchase Totals Units Acquired at Cost Units sold at Retail 220 units@ $14.50 = $ 3,190 170 units@ $23.50 170 units@ $13.50 = 2,295 200 units @ $23.50 370 units@ $13.00 = 4,810 760 units $10,295 370 units...
Required information The following information applies to the questions displayed below.] Laker Company reported the following January purchases and sales data for its only product. Units Acquired at Cost Units sold at Retail 140 units$6.840 Activities Jan. 1 Beginning inventory Jan. 10 Sales Jan. 20 Purchase Jan. 25 Sales an. 30 Purchase 100 units 15 60 units$5.00300 80 units 15 180 units $4.50-81e 380 units Totals $1,950 180 units Required The Company uses a periodic inventory system. For specific identification,...
FIFO, LIFO, WAV, and Specific Identification. The top portion
includes the units at cost and units sold.
Montoure Company uses a perpetual inventory system. It entered into the following calendar year purchases and sales transactions Units Sold at Retail Units Acquired at Cost 57e units $50 per unit 380 units 547 per unit 190 units@ $35 per unit Date Activities Jan. 1 Beginning inventory Feb. 1e Purchase Mar. 13 Purchase Mar. 15 Sales Aug. 21 Purchase Sept. 5 Purchase Sept....
MUS UNUS Homework Required information The following information applies to the questions displayed below) Laker Company reported the following January purchases and sales data for its only product Date 1 Activities Betinine nentory (8 0430:30 Units Aquired at Costunits sold 215 units $14.00 $3,010 165 unitse 100 units $13.aa- 2.10 199 units 355 Its $12.00 28 Purchase $23.03 Required: The Company uses a periodic inventory system. For specific identification, ending inventory consists of 375 units, where 355 are from the...