Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

The beginning inventory at Midnight Supplies and data on purchases and sales for a three month period ending March 31 are as follows: Date Transaction

The beginning inventory at Midnight Supplies and data on purchases and sales for a three month period ending March 31 are as follows:

Date

TransactionNumber of UnitsPer UnitTotal
Jan.1Inventory7,500$ 75.00$ 562,500
10Purchase22,50085.001,912,500
28Sale11,250150.001,687,500
30Sale3,750150.00562,500
Feb.5Sale1,500150.00225,000
10Purchase54,00087.504,725,000
16Sale27,000160.004,320,000
28Sale25,500160.004,080,000
Mar.5Purchase45,00089.504,027,500
14Sale30,000160.004,800,000
25Purchase7,50090.00675,000
30Sale26,250160.004,200,000
Instructions
1.Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrated in

Exhibit 3

, using the first-in, first-out method.
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 and date your journal entry March 31. 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 as of March 31.
5.Based upon the preceding data, would you expect the ending inventory using the last-in, first-out method to be higher or lower?

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

1. Record the inventory, purchases, and cost of goods 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.

Date

Purchases

Cost of goods Sold

Inventory

Date

Quantity

Unit Cost

Total Cost

Quantity

Unit Cost

Total Cost

Quantity

Unit Cost

Total Cost

Jan. 1

10

10

28

28

30

Feb. 5

10

10

16

16

28

Mar. 5

5

14

14

25

25

30

30

31

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

PAGE 10

JOURNAL

ACCOUNTING EQUATION

DATE

DESCRIPTION

POST. REF.

DEBIT

CREDIT

ASSETS

LIABILITIES

EQUITY

1

2

3

4

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

4. Determine the ending inventory cost as of March 31.

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

Lower

or

Higher

?

Please answer with exaclty the same labels/terms and in the same locations of the format so that I can check my work. 

Step by Step Solution

3.37 Rating (150 Votes )

There are 3 Steps involved in it

Step: 1

blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Financial Accounting

Authors: Carl S. Warren, James M. Reeve, Jonathan Duchac

15th Edition

978-1337398169

More Books

Students explore these related Accounting questions