Question: Periodic inventory by three methods The beginning inventory at Midnight Supplies and data on purchases and sales for a three - month period ending March

Periodic inventory by three methods
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 9,000 $60.00 $540,000
Jan. 10 Purchase 21,00070.001,470,000
Jan. 28 Sale 10,250140.001,435,000
Jan. 30 Sale 5,750140.00805,000
Feb. 5 Sale 3,500140.00490,000
Feb. 10 Purchase 39,50075.002,962,500
Feb. 16 Sale 15,000150.002,250,000
Feb. 28 Sale 10,000150.001,500,000
Mar. 5 Purchase 25,00082.002,050,000
Mar. 14 Sale 30,000150.004,500,000
Mar. 25 Purchase 10,00088.40884,000
Mar. 30 Sale 19,000150.002,850,000
1. 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.
Inventory, March 31 fill in the blank 1 of 2$
Cost of goods sold fill in the blank 2 of 2$
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.
Inventory, March 31 fill in the blank 1 of 2$
Cost of goods sold fill in the blank 2 of 2$
3. Determine the inventory on March 31 and the cost of goods sold for the three-month period, using the weighted average cost method and the periodic inventory system. Round the weighted average unit cost to the nearest cent.
Inventory, March 31 fill in the blank 1 of 2$
Cost of goods sold fill in the blank 2 of 2$
4. Compare the gross profit and the March 31 inventories, using the following column headings. For those boxes in which you must enter subtracted or negative numbers use a minus sign.
Line Item Description FIFO LIFO Weighted Average
Sales $fill in the blank 7
$fill in the blank 8
$fill in the blank 9
Cost of goods sold fill in the blank 10
fill in the blank 11
fill in the blank 12
Gross profit $fill in the blank 13
$fill in the blank 14
$fill in the blank 15
Inventory, March 31

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!