Question:The beginning inventory at Midnight Supplies and data on
purchases and sales for a three month...
Question
The beginning inventory at Midnight Supplies and data on
purchases and sales for a three month...
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
Number of Units
Per Unit
Total
Jan.
1
Inventory
2,600
$54.00
$140,400
10
Purchase
7,000
62.00
434,000
28
Sale
3,850
108.00
415,800
30
Sale
1,300
108.00
140,400
Feb.
5
Sale
500
108.00
54,000
10
Purchase
17,500
64.00
1,120,000
16
Sale
8,700
113.00
983,100
28
Sale
8,600
113.00
971,800
Mar.
5
Purchase
14,000
65.60
918,400
14
Sale
10,100
113.00
1,141,300
25
Purchase
3,300
66.00
217,800
30
Sale
7,750
113.00
875,750
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?
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
Number of Units
Per Unit
Total
Jan.
1
Inventory
2,600
$54.00
$140,400
10
Purchase
7,000
62.00
434,000
28
Sale
3,850
108.00
415,800
30
Sale
1,300
108.00
140,400
Feb.
5
Sale
500
108.00
54,000
10
Purchase
17,500
64.00
1,120,000
16
Sale
8,700
113.00
983,100
28
Sale
8,600
113.00
971,800
Mar.
5
Purchase
14,000
65.60
918,400
14
Sale...
The beginning inventory for Midnight Supplies and data on
purchases and sales for a three month period are as follows:DateTransactionNumber of UnitsPer UnitTotalJan.1Inventory7,500$ 75.00$ 562,50010Purchase22,50085.001,912,50028Sale11,250150.001,687,50030Sale3,750150.00562,500Feb.5Sale1,500150.00225,00010Purchase54,00087.504,725,00016Sale27,000160.004,320,00028Sale25,500160.004,080,000Mar.5Purchase45,00089.504,027,50014Sale30,000160.004,800,00025Purchase7,50090.00675,00030Sale26,250160.004,200,000Instructions1.Determine the inventory on March 31 and the cost of goods sold
for the three-month period, using the first-in, first-out method
and the periodic inventory system.2.Determine the inventory on March 31 and the cost of goods sold
for the three-month period, using the last-in, first-out method and
the periodic inventory system.3.Determine the inventory on March 31...
he beginning inventory at Midnight Supplies and data on
purchases and sales for a three month period ending March 31 are as
follows:
Date
Transaction
Number of Units
Per Unit
Total
Jan.
1
Inventory
7,500
$ 75.00
$ 562,500
10
Purchase
22,500
85.00
1,912,500
28
Sale
11,250
150.00
1,687,500
30
Sale
3,750
150.00
562,500
Feb.
5
Sale
1,500
150.00
225,000
10
Purchase
54,000
87.50
4,725,000
16
Sale
27,000
160.00
4,320,000
28
Sale
25,500
160.00
4,080,000
Mar.
5
Purchase
45,000
89.50...
LIFO Perpetual Inventory
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
Number
of Units
Per Unit
Total
Jan. 1
Inventory
7,500
$75.00
$562,500
10
Purchase
22,500
85.00
1,912,500
28
Sale
11,250
150.00
1,687,500
30
Sale
3,750
150.00
562,500
Feb. 5
Sale
1,500
150.00
225,000
10
Purchase
54,000
87.50
4,725,000
16
Sale
27,000
160.00
4,320,000
28
Sale
25,500
160.00
4,080,000
Mar. 5
Purchase
45,000
89.50...
The beginning inventory at Funky Party Supplies and data on
purchases and sales for a three-month period ending March 31, 2016,
are as follows:
Date
Transaction
Number of Units
Per Unit
Total
Jan.
1
Inventory
2,700
$50.00
$135,000
10
Purchase
7,300
58.00
423,400
28
Sale
4,050
100.00
405,000
30
Sale
1,200
100.00
120,000
Feb.
5
Sale
500
100.00
50,000
10
Purchase
17,000
60.00
1,020,000
16
Sale
9,200
105.00
966,000
28
Sale
8,000
105.00
840,000
Mar.
5
Purchase
14,300
61.60
880,880...
Weighted Average Cost Method with Perpetual Inventory
The beginning inventory for Midnight Supplies and data on
purchases and sales for a three-month period are as follows:
Date
Transaction
Number
of Units
Per Unit
Total
Jan. 1
Inventory
7,200
$74.00
$532,800
10
Purchase
21,600
84.00
1,814,400
28
Sale
10,800
148.00
1,598,400
30
Sale
3,600
148.00
532,800
Feb. 5
Sale
1,440
148.00
213,120
10
Purchase
51,840
86.50
4,484,160
16
Sale
25,920
158.00
4,095,360
28
Sale
24,480
158.00
3,867,840
Mar. 5
Purchase
43,200...
Weighted Average Cost Method with Perpetual Inventory
The beginning inventory for Midnight Supplies and data on
purchases and sales for a three-month period are as follows:
Date
Transaction
Number
of Units
Per Unit
Total
Jan. 1
Inventory
7,700
$79.00
$608,300
10
Purchase
23,100
89.00
2,055,900
28
Sale
11,550
158.00
1,824,900
30
Sale
3,850
158.00
608,300
Feb. 5
Sale
1,540
158.00
243,320
10
Purchase
55,440
91.50
5,072,760
16
Sale
27,720
168.00
4,656,960
28
Sale
26,180
168.00
4,398,240
Mar. 5
Purchase
46,200...
Weighted Average Cost Method with Perpetual Inventory
The beginning inventory for Midnight Supplies and data on
purchases and sales for a three-month period are as follows:
Date
Transaction
Number
of Units
Per Unit
Total
Jan. 1
Inventory
7,300
$77.00
$562,100
10
Purchase
21,900
87.00
1,905,300
28
Sale
10,950
154.00
1,686,300
30
Sale
3,650
154.00
562,100
Feb. 5
Sale
1,460
154.00
224,840
10
Purchase
52,560
89.50
4,704,120
16
Sale
26,280
164.00
4,309,920
28
Sale
24,820
164.00
4,070,480
Mar. 5
Purchase
43,800...
Weighted Average Cost Method with Perpetual Inventory
The beginning inventory for Midnight Supplies and data on
purchases and sales for a three-month period are as follows:
Date
Transaction
Number
of Units
Per Unit
Total
Jan. 1
Inventory
7,600
$71.00
$539,600
10
Purchase
22,800
81.00
1,846,800
28
Sale
11,400
142.00
1,618,800
30
Sale
3,800
142.00
539,600
Feb. 5
Sale
1,520
142.00
215,840
10
Purchase
54,720
83.50
4,569,120
16
Sale
27,360
152.00
4,158,720
28
Sale
25,840
152.00
3,927,680
Mar. 5
Purchase
45,600...
Weighted Average Cost Method with Perpetual Inventory The beginning inventory for Midnight Supplies and data on purchases and sales for a three-month period are as follows: Date Transaction Total Number of Units 7,400 22,200 Jan. 1 Inventory $532,800 Per Unit $72.00 82.00 144.00 1,820,400 10 28 Purchase Sale 11,100 1,598,400 3,700 144.00 532,800 30 Feb. 5 Sale Sale 1,480 144.00 213,120 10 Purchase 53,280 84.50 16 28 Sale Sale Mar. 5 Purchase 26,640 25,160 44,400 29,600 7,400 25,900 154.00 154.00...