Question

In: Accounting

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

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

Date

Transaction

Number of Units

Per Unit

Total

Apr. 3 Inventory 25 $1,200 $30,000
8 Purchase 75 1,240 93,000
11 Sale 40 2,000 80,000
30 Sale 30 2,000 60,000
May 8 Purchase 60 1,260 75,600
10 Sale 50 2,000 100,000
19 Sale 20 2,000 40,000
28 Purchase 80 1,260 100,800
June 5 Sale 40 2,250 90,000
16 Sale 25 2,250 56,250
21 Purchase 35 1,264 44,240
28 Sale 44 2,250 99,000
Instructions
1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated in

Exhibit 4

, using the first-in, first-out method.
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, and date your journal entry June 30. Refer to the Chart of Accounts for exact wording of account titles.
3. Determine the gross profit from sales for the period.
4. Determine the ending inventory cost on June 30, 2016.
5. Based upon the preceding data, would you expect the inventory using the last-in, first-out method

The method of inventory costing based on the assumption that the cost of merchandise sold is the cost of the most recent purchases.

to be higher or lower?

none

X

FIFO

1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual inventory record similar to the one illustrated in

Exhibit 4

, using the first-in, first-out method.

Date Purchases Cost of Merchandise Sold Inventory
2016 Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost
Apr. 3
8
8
11
11
30
May 8
8
10
10
19
28
28
Jun. 5
5
16
21
21
28
28
30 Balances

Points:

Feedback

Check My Work

none

X

Chart of Accounts

CHART OF ACCOUNTS
Dunne Co.
General Ledger
ASSETS
110 Cash
111 Petty Cash
120 Accounts Receivable
131 Notes Receivable
132 Interest Receivable
141 Merchandise Inventory
145 Office Supplies
146 Store Supplies
151 Prepaid Insurance
181 Land
191 Office Equipment
192 Accumulated Depreciation-Office Equipment
193 Store Equipment
194 Accumulated Depreciation-Store Equipment
LIABILITIES
210 Accounts Payable
221 Notes Payable
222 Interest Payable
231 Salaries Payable
241 Sales Tax Payable
EQUITY
310 Owner, Capital
311 Owner, Drawing
312 Income Summary
REVENUE
410 Sales
610 Interest Revenue
EXPENSES
510 Cost of Merchandise Sold
515 Credit Card Expense
516 Cash Short and Over
520 Salaries Expense
531 Advertising Expense
532 Delivery Expense
533 Insurance Expense
534 Office Supplies Expense
535 Rent Expense
536 Repairs Expense
537 Selling Expenses
538 Store Supplies Expense
561 Depreciation Expense-Office Equipment
562 Depreciation Expense-Store Equipment
590 Miscellaneous Expense
710 Interest Expense

none

X

Journal

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, and date your journal entry June 30. Refer to the Chart of Accounts for exact wording of account titles.

PAGE 1

JOURNAL

DATE DESCRIPTION POST. REF. DEBIT CREDIT

1

2

3

4

Solution

DATE DESCRIPTION POST. REF. DEBIT CREDIT

1

2

3

4

Points:

Feedback

Check My Work

none

X

Final Questions

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

Points:

Feedback

Check My Work

Explanation

4. Determine the ending inventory cost on June 30, 2016.

Points:

Feedback

Check My Work

Explanation

5. Based upon the preceding data, would you expect the inventory using the last-in, first-out method

The method of inventory costing based on the assumption that the cost of merchandise sold is the cost of the most recent purchases.

to be higher or lower?

Higher

Lower

Solutions

Expert Solution

Due to time constrain could provide this much only


Related Solutions

The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a...
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 84 $375 $31,500 8 Purchase 168 450 75,600 11 Sale 113 1,250 141,250 30 Sale 71 1,250 88,750 May 8 Purchase 140 500 70,000 10 Sale 84 1,250 105,000 19 Sale 42 1,250 52,500 28 Purchase 140 550 77,000 June 5 Sale 84 1,315 110,460...
The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a...
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 25 $1,200 $30,000 8 Purchase 75 1,240 93,000 11 Sale 40 2,000 80,000 30 Sale 30 2,000 60,000 May 8 Purchase 60 1,260 75,600 10 Sale 50 2,000 100,000 19 Sale 20 2,000 40,000 28 Purchase 80 1,260 100,800 June 5 Sale 40 2,250 90,000...
The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a...
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 72 $225 $16,200 8 Purchase 144 270 38,880 11 Sale 96 750 72,000 30 Sale 60 750 45,000 May 8 Purchase 120 300 36,000 10 Sale 72 750 54,000 19 Sale 36 750 27,000 28 Purchase 120 330 39,600 June 5 Sale 72 790 56,880...
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...
LIFO Perpetual Inventory The beginning inventory of merchandise at Dunne Co. and data on purchases and...
LIFO 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 48 $600 $28,800 8 Purchase 96 720 69,120 11 Sale 64 2,000 128,000 30 Sale 40 2,000 80,000 May 8 Purchase 80 800 64,000 10 Sale 48 2,000 96,000 19 Sale 24 2,000 48,000 28 Purchase 80 880 70,400 June 5 Sale...
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 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...
LIFO Perpetual Inventory The beginning inventory of merchandise at Dunne Co. and data on purchases and...
LIFO 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 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...
LIFO Perpetual Inventory The beginning inventory of merchandise at Dunne Co. and data on purchases and...
LIFO 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    84,    $225,    $18,900 8    Purchase 168, 270, 45,360 11 Sale 113,    750, 84,750 30 Sale 71,    750,    53,250 May 8    Purchase 140,    300,    42,000 10 Sale    84,...
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 25 $1,200 $30,000 8 Purchase 75 1,240 93,000 11 Sale 40 2,000 80,000 30 Sale 30 2,000 60,000 May 8 Purchase 60 1,260 75,600 10 Sale 50 2,000 100,000 19 Sale 20 2,000 40,000 28 Purchase 80 1,260 100,800 June 5 Sale...
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, 2016, are as follows: Date Transaction Number of Units Per Unit Total Apr. 3 Inventory 25 $1,200 $30,000 8 Purchase 75 1,240 93,000 11 Sale 40 2,000 80,000 30 Sale 30 2,000 60,000 May 8 Purchase 60 1,260 75,600 10 Sale 50 2,000 100,000 19 Sale 20 2,000 40,000 28 Purchase 80 1,260 100,800 June 5...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT