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