Questions
The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period...

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 84 $525 $44,100
8 Purchase 168 630 105,840
11 Sale 112 1,750 196,000
30 Sale 70 1,750 122,500
May 8 Purchase 140 700 98,000
10 Sale 84 1,750 147,000
19 Sale 42 1,750 73,500
28 Purchase 140 770 107,800
June 5 Sale 84 1,840 154,560
16 Sale 112 1,840 206,080
21 Purchase 252 840 211,680
28 Sale 126 1,840 231,840

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 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 66 $300 $19,800
8 Purchase 132 360 47,520
11 Sale 88 1,000 88,000
30 Sale 55 1,000 55,000
May 8 Purchase 110 400 44,000
10 Sale 66 1,000 66,000
19 Sale 33 1,000 33,000
28 Purchase 110 440 48,400
June 5 Sale 66 1,050 69,300
16 Sale 88 1,050 92,400
21 Purchase 198 480 95,040
28 Sale 99 1,050 103,950

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 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 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

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

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

King Fisher Aviation has projected the following quarterly sales amounts for the coming year: Quarter 1...

King Fisher Aviation has projected the following quarterly sales amounts for the coming year:

Quarter 1 $750

Quarter 2 $820

Quarter 3 $790

Quarter 4 $950

Accounts Receivable at the beginning of the year are $350. King Fisher has a 30 day collection period. Calculate the cash collections in each of the four quarters by completing the following for each quarter.

Beginning receivables

Sales

Cash Collections

Ending Receivables

Rework the Ending Receivables calculation using 45 and 60 days.

This is what i have so far can you help me with the 30 day and also check me work thanks!!!

                                  -   -day collection period
Q1 Q2 Q3 Q4
Beginning receivables $        350.00
Sales            750.00            820.00            790.00             950.00
Cash collections
Ending receivables
                                 45
Beginning receivables
Sales
Cash collections            725.00            785.00            805.00             870.00
Ending receivables $        375.00 $        410.00 $        395.00 $         475.00
                                 60
Beginning receivables
Sales
Cash collections            600.00            773.33            810.00             843.33
Ending receivables $        500.00 $        546.67 $        526.67 $         633.33

In: Finance

King Fisher Aviation has projected the following quarterly sales amounts for the coming year: Quarter 1...

King Fisher Aviation has projected the following quarterly sales amounts for the coming year:

Quarter 1 $750

Quarter 2 $820

Quarter 3 $790

Quarter 4 $950

Accounts Receivable at the beginning of the year are $350. King Fisher has a 30 day collection period. Calculate the cash collections in each of the four quarters by completing the following for each quarter.

Beginning receivables

Sales

Cash Collections

Ending Receivables

Rework the Ending Receivables calculation using 45 and 60 days.

Fill in the values in the spreadsheet.

Input Area:

Beginning A/R $              350
a. Collection period                    30
b. Collection period                    45
c. Collection period                    60
Q1 Q2 Q3 Q4
Sales $              750 $             820 $              790 $               950
Output Area:
a.                                  30 -day collection period
Q1 Q2 Q3 Q4
Beginning receivables
Sales
Cash collections
Ending receivables
b.                                  45
Beginning receivables
Sales
Cash collections
Ending receivables
c.                                  60
Beginning receivables
Sales
Cash collections
Ending receivables

In: Finance