Questions
FIFO Perpetual Inventory The beginning inventory of merchandise at Rhodes Co. and data on purchases and...

FIFO Perpetual Inventory

The beginning inventory of merchandise at Rhodes Co. and data on purchases and sales for a three-month period ending June 30 are as follows:

Date Transaction Number
of Units
Per Unit Total
Apr. 3 Inventory 42 $150 $6,300
8 Purchase 84 180 15,120
11 Sale 56 500 28,000
30 Sale 35 500 17,500
May 8 Purchase 70 200 14,000
10 Sale 42 500 21,000
19 Sale 21 500 10,500
28 Purchase 70 220 15,400
June 5 Sale 42 525 22,050
16 Sale 56 525 29,400
21 Purchase 126 240 30,240
28 Sale 63 525 33,075

Required:

1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated in Exhibit 3, using the first-in, first-out method. Under FIFO, if units are in inventory at two different costs, enter the units with the LOWER unit cost first in the Cost of Merchandise Sold Unit Cost column and in the Inventory Unit Cost column.

Rhodes Co.
Schedule of Cost of Merchandise Sold
FIFO Method
For the three-months ended June 30
Purchases Cost of Merchandise Sold Inventory
Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost
Apr. 3 $ $
Apr. 8 $ $
Apr. 11 $ $
Apr. 30
May 8
May 10
May 19
May 28
June 5
June 16
June 21
June 28
June 30 Balances $ $

2. Determine the total sales and the total cost of merchandise sold for the period. Journalize the entries in the sales and cost of merchandise sold accounts. Assume that all sales were on account. If an amount box does not require an entry, leave it blank.

Description Post. Ref. Debit Credit
Record sale
Record cost

3. Determine the gross profit from sales for the period.
$

4. Determine the ending inventory cost as of June 30.
$

5. Based upon the preceding data, would you expect the inventory using the last-in, first-out method to be higher or lower?

In: Accounting

FIFO Perpetual Inventory The beginning inventory at Dunne Co. and data on purchases and sales for...

FIFO Perpetual Inventory

The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows:

Date Transaction Number
of Units
Per Unit Total
Apr. 3 Inventory 72 $450 $32,400
8 Purchase 144 540 77,760
11 Sale 96 1,500 144,000
30 Sale 60 1,500 90,000
May 8 Purchase 120 600 72,000
10 Sale 72 1,500 108,000
19 Sale 36 1,500 54,000
28 Purchase 120 660 79,200
June 5 Sale 72 1,575 113,400
16 Sale 96 1,575 151,200
21 Purchase 216 720 155,520
28 Sale 108 1,575 170,100

Required:

1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated in Exhibit 3, using the first-in, first-out method. Under FIFO, if units are in inventory at two different costs, enter the units with the LOWER unit cost first in the Cost of Goods Sold Unit Cost column and in the Inventory Unit Cost column.

Dunne Co.
Schedule of Cost of Goods Sold
FIFO Method
For the Three Months Ended June 30
Purchases Cost of Goods Sold Inventory
Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost
Apr. 3 $ $
Apr. 8 $ $
Apr. 11 $ $
Apr. 30
May 8
May 10
May 19
May 28
June 5
June 16
June 21
June 28
June 30 Balances $ $

2. Determine the total sales and the total cost of goods sold for the period. Journalize the entries in the sales and cost of goods sold accounts. Assume that all sales were on account. If an amount box does not require an entry, leave it blank.

Record sale
Record cost

3. Determine the gross profit from sales for the period.
$

4. Determine the ending inventory cost as of June 30.
$

5. Based upon the preceding data, would you expect the ending inventory using the last-in, first-out method to be higher or lower?

In: Accounting

FIFO Perpetual Inventory The beginning inventory of merchandise at Dunne Co. and data on purchases and...

FIFO Perpetual Inventory

The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows:

Date Transaction Number
of Units
Per Unit Total
Apr. 3 Inventory 60 $300 $18,000
8 Purchase 120 360 43,200
11 Sale 80 1,000 80,000
30 Sale 50 1,000 50,000
May 8 Purchase 100 400 40,000
10 Sale 60 1,000 60,000
19 Sale 30 1,000 30,000
28 Purchase 100 440 44,000
June 5 Sale 60 1,050 63,000
16 Sale 80 1,050 84,000
21 Purchase 180 480 86,400
28 Sale 90 1,050 94,500

Required:

1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated in Exhibit 3, using the first-in, first-out method. Under FIFO, if units are in inventory at two different costs, enter the units with the LOWER unit cost first in the Cost of Merchandise Sold Unit Cost column and in the Inventory Unit Cost column.

Dunne Co.
Schedule of Cost of Merchandise Sold
FIFO Method
For the three-months ended June 30
Purchases Cost of Merchandise Sold Inventory
Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost
Apr. 3 $ $
Apr. 8 $ $
Apr. 11 $ $
Apr. 30
May 8
May 10
May 19
May 28
June 5
June 16
June 21
June 28
June 30 Balances $ $

2. Determine the total sales and the total cost of merchandise sold for the period. Journalize the entries in the sales and cost of merchandise sold accounts. Assume that all sales were on account.

Record sale
Record cost

3. Determine the gross profit from sales for the period.
$

4. Determine the ending inventory cost as of June 30.
$

5. Based upon the preceding data, would you expect the inventory using the last-in, first-out method to be higher or lower?

In: Accounting

FIFO Perpetual Inventory The beginning inventory at Dunne Co. and data on purchases and sales for...

FIFO Perpetual Inventory The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows: Date Transaction Number of Units Per Unit Total Apr. 3 Inventory 42 $525 $22,050 8 Purchase 84 630 52,920 11 Sale 56 1,750 98,000 30 Sale 35 1,750 61,250 May 8 Purchase 70 700 49,000 10 Sale 42 1,750 73,500 19 Sale 21 1,750 36,750 28 Purchase 70 770 53,900 June 5 Sale 42 1,840 77,280 16 Sale 56 1,840 103,040 21 Purchase 126 840 105,840 28 Sale 63 1,840 115,920 Required: 1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated in Exhibit 3, using the first-in, first-out method. Under FIFO, if units are in inventory at two different costs, enter the units with the LOWER unit cost first in the Cost of Goods Sold Unit Cost column and in the Inventory Unit Cost column. Dunne Co. Schedule of Cost of Goods Sold FIFO Method For the Three Months Ended June 30 Purchases Cost of Goods Sold Inventory Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Apr. 3 $ $ Apr. 8 $ $ Apr. 11 $ $ Apr. 30 May 8 May 10 May 19 May 28 June 5 June 16 June 21 June 28 June 30 Balances $ $ 2. Determine the total sales and the total cost of goods sold for the period. Journalize the entries in the sales and cost of goods sold accounts. Assume that all sales were on account. Record sale Record cost 3. Determine the gross profit from sales for the period. $ 4. Determine the ending inventory cost as of June 30. $ 5. Based upon the preceding data, would you expect the ending inventory using the last-in, first-out method to be higher or lower

In: Accounting

PLEASE ONLY USE THE TABLES AND FORMAT THAT I PROVIDED FIFO Perpetual Inventory The beginning inventory...

PLEASE ONLY USE THE TABLES AND FORMAT THAT I PROVIDED

FIFO Perpetual Inventory

The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows:

Date Transaction Number
of Units
Per Unit Total
Apr. 3 Inventory 54 $525 $28,350
8 Purchase 108 630 68,040
11 Sale 72 1,750 126,000
30 Sale 45 1,750 78,750
May 8 Purchase 90 700 63,000
10 Sale 54 1,750 94,500
19 Sale 27 1,750 47,250
28 Purchase 90 770 69,300
June 5 Sale 54 1,840 99,360
16 Sale 72 1,840 132,480
21 Purchase 162 840 136,080
28 Sale 81 1,840 149,040

Required:

1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated in Exhibit 3, using the first-in, first-out method. Under FIFO, if units are in inventory at two different costs, enter the units with the LOWER unit cost first in the Cost of Merchandise Sold Unit Cost column and in the Inventory Unit Cost column.

Dunne Co.
Schedule of Cost of Merchandise Sold
FIFO Method
For the three months ended May 31, 2016
Purchases Cost of Merchandise Sold Inventory
Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost
Apr. 3 $ $
Apr. 8 $ $
Apr. 11 $ $
Apr. 30
May 8
May 10
May 19
May 28
June 5
June 16
June 21
June 28
June 30 Balances $ $

2. Determine the total sales and the total cost of merchandise sold for the period. Journalize the entries in the sales and cost of merchandise sold accounts. Assume that all sales were on account.

Record sale
Record cost

3. Determine the gross profit from sales for the period.
$

4. Determine the ending inventory cost as of June 30.
$

5. Based upon the preceding data, would you expect the inventory using the last-in, first-out method to be higher or lower?

In: Accounting

FIFO Perpetual Inventory The beginning inventory at Dunne Co. and data on purchases and sales for...

FIFO Perpetual Inventory

The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows:

Date Transaction Number
of Units
Per Unit Total
Apr. 3 Inventory 48 $525 $25,200
8 Purchase 96 630 60,480
11 Sale 64 1,750 112,000
30 Sale 40 1,750 70,000
May 8 Purchase 80 700 56,000
10 Sale 48 1,750 84,000
19 Sale 24 1,750 42,000
28 Purchase 80 770 61,600
June 5 Sale 48 1,840 88,320
16 Sale 64 1,840 117,760
21 Purchase 144 840 120,960
28 Sale 72 1,840 132,480

Required:

1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated in Exhibit 3, using the first-in, first-out method. Under FIFO, if units are in inventory at two different costs, enter the units with the LOWER unit cost first in the Cost of Goods Sold Unit Cost column and in the Inventory Unit Cost column.

Dunne Co.
Schedule of Cost of Goods Sold
FIFO Method
For the Three Months Ended June 30
Purchases Cost of Goods Sold Inventory
Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost
Apr. 3 $ $
Apr. 8 $ $
Apr. 11 $ $
Apr. 30
May 8
May 10
May 19
May 28
June 5
June 16
June 21
June 28
June 30 Balances $ $

2. Determine the total sales and the total cost of goods sold for the period. Journalize the entries in the sales and cost of goods sold accounts. Assume that all sales were on account.

Record sale
Record cost

3. Determine the gross profit from sales for the period.
$

4. Determine the ending inventory cost as of June 30.
$

5. Based upon the preceding data, would you expect the ending inventory using the last-in, first-out method to be higher or lower?

In: Accounting

The beginning inventory of merchandise at Rhodes Co. and data on purchases and sales for a...

The beginning inventory of merchandise at Rhodes Co. and data on purchases and sales for a three-month period ending June 30 are as follows:

Date Transaction Number
of Units
Per Unit Total
Apr. 3 Inventory 90 $600 $54,000
8 Purchase 180 720 129,600
11 Sale 120 2,000 240,000
30 Sale 75 2,000 150,000
May 8 Purchase 150 800 120,000
10 Sale 90 2,000 180,000
19 Sale 45 2,000 90,000
28 Purchase 150 880 132,000
June 5 Sale 90 2,100 189,000
16 Sale 120 2,100 252,000
21 Purchase 270 960 259,200
28 Sale 135 2,100 283,500

Required:

1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated in Exhibit 3, using the first-in, first-out method. Under FIFO, if units are in inventory at two different costs, enter the units with the LOWER unit cost first in the Cost of Merchandise Sold Unit Cost column and in the Inventory Unit Cost column.

Rhodes Co.
Schedule of Cost of Merchandise Sold
FIFO Method
For the three-months ended June 30
Purchases Cost of Merchandise Sold Inventory
Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost
Apr. 3 $ $
Apr. 8 $ $
Apr. 11 $ $
Apr. 30
May 8
May 10
May 19
May 28
June 5
June 16
June 21
June 28
June 30 Balances $ $

2. Determine the total sales and the total cost of merchandise sold for the period. Journalize the entries in the sales and cost of merchandise sold accounts. Assume that all sales were on account. If an amount box does not require an entry, leave it blank.

Description Post. Ref. Debit Credit
Record sale
Record cost

3. Determine the gross profit from sales for the period.
$

4. Determine the ending inventory cost as of June 30.
$

5. Based upon the preceding data, would you expect the inventory using the last-in, first-out method to be higher or lower?

In: Accounting

IFO Perpetual Inventory The beginning inventory at Dunne Co. and data on purchases and sales for...

IFO Perpetual Inventory

The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows:

Date Transaction Number
of Units
Per Unit Total
Apr. 3 Inventory 42 $300 $12,600
8 Purchase 84 360 30,240
11 Sale 56 1,000 56,000
30 Sale 35 1,000 35,000
May 8 Purchase 70 400 28,000
10 Sale 42 1,000 42,000
19 Sale 21 1,000 21,000
28 Purchase 70 440 30,800
June 5 Sale 42 1,050 44,100
16 Sale 56 1,050 58,800
21 Purchase 126 480 60,480
28 Sale 63 1,050 66,150

Required:

1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated in Exhibit 3, using the first-in, first-out method. Under FIFO, if units are in inventory at two different costs, enter the units with the LOWER unit cost first in the Cost of Goods Sold Unit Cost column and in the Inventory Unit Cost column.

Dunne Co.
Schedule of Cost of Goods Sold
FIFO Method
For the Three Months Ended June 30
Purchases Cost of Goods Sold Inventory
Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost
Apr. 3 $ $
Apr. 8 $ $
Apr. 11 $ $
Apr. 30
May 8
May 10
May 19
May 28
June 5
June 16
June 21
June 28
June 30 Balances $ $

2. Determine the total sales and the total cost of goods sold for the period. Journalize the entries in the sales and cost of goods sold accounts. Assume that all sales were on account.

Record sale
Record cost

3. Determine the gross profit from sales for the period.
$

4. Determine the ending inventory cost as of June 30.
$

5. Based upon the preceding data, would you expect the ending inventory using the last-in, first-out method to be higher or lower?

In: Accounting

FIFO Perpetual Inventory The beginning inventory at Dunne Co. and data on purchases and sales for...

FIFO Perpetual Inventory

The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows:

Date Transaction Number
of Units
Per Unit Total
Apr. 3 Inventory 90 $300 $27,000
8 Purchase 180 360 64,800
11 Sale 120 1,000 120,000
30 Sale 75 1,000 75,000
May 8 Purchase 150 400 60,000
10 Sale 90 1,000 90,000
19 Sale 45 1,000 45,000
28 Purchase 150 440 66,000
June 5 Sale 90 1,050 94,500
16 Sale 120 1,050 126,000
21 Purchase 270 480 129,600
28 Sale 135 1,050 141,750

Required:

1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated in Exhibit 3, using the first-in, first-out method. Under FIFO, if units are in inventory at two different costs, enter the units with the LOWER unit cost first in the Cost of Goods Sold Unit Cost column and in the Inventory Unit Cost column.

Dunne Co.
Schedule of Cost of Goods Sold
FIFO Method
For the Three Months Ended June 30
Purchases Cost of Goods Sold Inventory
Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost
Apr. 3 $ $
Apr. 8 $ $
Apr. 11 $ $
Apr. 30
May 8
May 10
May 19
May 28
June 5
June 16
June 21
June 28
June 30 Balances $ $

2. Determine the total sales and the total cost of goods sold for the period. Journalize the entries in the sales and cost of goods sold accounts. Assume that all sales were on account.

Record sale
Record cost

3. Determine the gross profit from sales for the period.
$

4. Determine the ending inventory cost as of June 30.
$

5. Based upon the preceding data, would you expect the ending inventory using the last-in, first-out method to be higher or lower?

In: Accounting

FIFO Perpetual Inventory The beginning inventory at Dunne Co. and data on purchases and sales for...

FIFO Perpetual Inventory The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows: Date Transaction Number of Units Per Unit Total Apr. 3 Inventory 54 $225 $12,150 8 Purchase 108 270 29,160 11 Sale 72 750 54,000 30 Sale 45 750 33,750 May 8 Purchase 90 300 27,000 10 Sale 54 750 40,500 19 Sale 27 750 20,250 28 Purchase 90 330 29,700 June 5 Sale 54 790 42,660 16 Sale 72 790 56,880 21 Purchase 162 360 58,320 28 Sale 81 790 63,990 Required: 1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated in Exhibit 3, using the first-in, first-out method. Under FIFO, if units are in inventory at two different costs, enter the units with the LOWER unit cost first in the Cost of Goods Sold Unit Cost column and in the Inventory Unit Cost column. Dunne Co. Schedule of Cost of Goods Sold FIFO Method For the Three Months Ended June 30 Purchases Cost of Goods Sold Inventory Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Apr. 3 $ $ Apr. 8 $ $ Apr. 11 $ $ Apr. 30 May 8 May 10 May 19 May 28 June 5 June 16 June 21 June 28 June 30 Balances $ $ 2. Determine the total sales and the total cost of goods sold for the period. Journalize the entries in the sales and cost of goods sold accounts. Assume that all sales were on account. Record sale Record cost 3. Determine the gross profit from sales for the period. $ 4. Determine the ending inventory cost as of June 30. $ 5. Based upon the preceding data, would you expect the ending inventory using the last-in, first-out method to be higher or lower?

In: Accounting