The beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period ending March 31 are as follows: Date Jan. Feb. Mar. Transaction Number of Units 9,000 21,000 10,250 5,750 3,500 39,500 15,000 10,000 25,000 30,000 10,000 19,000 1 Inventory 10 Purchase 28 30 Sale Sale 5 Sale 10 16 28 5 Purchase 14 Sale Purchase Purchase Sale Sale 25 30 Sale Per Unit $60.00 70.00 140.00 140.00 140.00 75.00 150.00 150.00 82.00 150.00 88.40 150.00 Total $540,000 1,470,000 1,435,000 805.000 490,000 2,982,500 2,250,000 1,500,000 2,050,000 4,500,000 884,000 2,850,000 Required: 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 summary entries for the sales and corresponding cost of goods sold for the period. Assume that all sales were on account and date your journal entry March 31. 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?

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Topic Video
Question
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
Date
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
Quantity
21,000
39,500
25,000
10,000
Purchases
Unit Cost
$70.00
$75.00
$82.00
$88.40
Total Cost
$1,470,000
$2,962,500
$2,050,000
$884,000
Quantity
S
S
S
S
S
S
S
S
S
S
Cost of goods Sold
Unit Cost
$
$
||$
$
$
||$
$
$
S
||$
$
Total Cost
Quantity
S
$
$
$
S
$
S
$
S
S
$
S
$
$
$
$
$
Inventory
Unit Cost
S
s
S
S
s
s
S
S
S
s
S
S
S
S
S
S
S
S
Total Cost
Transcribed Image Text: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 Date 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 Quantity 21,000 39,500 25,000 10,000 Purchases Unit Cost $70.00 $75.00 $82.00 $88.40 Total Cost $1,470,000 $2,962,500 $2,050,000 $884,000 Quantity S S S S S S S S S S Cost of goods Sold Unit Cost $ $ ||$ $ $ ||$ $ $ S ||$ $ Total Cost Quantity S $ $ $ S $ S $ S S $ S $ $ $ $ $ Inventory Unit Cost S s S S s s S S S s S S S S S S S S Total Cost
The beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period ending March 31 are as follows:
Date
Jan.
Feb.
Mar.
Transaction Number of Units
9,000
21,000
10,250
5,750
3,500
1 Inventory
10
Purchase
28
Sale
30 Sale
5
Sale
10
16
28
5 Purchase
14
25
30
Purchase
Sale
Sale
Sale
Purchase
Sale
39,500
15,000
10,000
25,000
30,000
10,000
19,000
Per Unit
$60.00
70.00
140.00
140.00
140.00
75.00
150.00
150.00
82.00
150.00
88.40
150.00
Total
$540,000
1,470,000
1,435,000
805,000
490,000
2,962,500
2,250,000
1,500,000
2,050,000
4,500,000
884,000
2,850,000
Required:
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 summary entries for the sales and corresponding cost of
goods sold for the period. Assume that all sales were on account and date your journal entry March 31.
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?
Transcribed Image Text:The beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period ending March 31 are as follows: Date Jan. Feb. Mar. Transaction Number of Units 9,000 21,000 10,250 5,750 3,500 1 Inventory 10 Purchase 28 Sale 30 Sale 5 Sale 10 16 28 5 Purchase 14 25 30 Purchase Sale Sale Sale Purchase Sale 39,500 15,000 10,000 25,000 30,000 10,000 19,000 Per Unit $60.00 70.00 140.00 140.00 140.00 75.00 150.00 150.00 82.00 150.00 88.40 150.00 Total $540,000 1,470,000 1,435,000 805,000 490,000 2,962,500 2,250,000 1,500,000 2,050,000 4,500,000 884,000 2,850,000 Required: 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 summary entries for the sales and corresponding cost of goods sold for the period. Assume that all sales were on account and date your journal entry March 31. 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?
Expert Solution
steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Accounting for Merchandise Inventory
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education