Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 $71.00 $511,200
10 Purchase 21,600 81.00 1,749,600
28 Sale 10,800 142.00 1,533,600
30 Sale 3,600 142.00 511,200
Feb. 5 Sale 1,440 142.00 204,480
10 Purchase 51,840 83.50 4,328,640
16 Sale 25,920 152.00 3,939,840
28 Sale 24,480 152.00 3,720,960
Mar. 5 Purchase 43,200 85.50 3,693,600
14 Sale 28,800 152.00 4,377,600
25 Purchase 7,200 86.00 619,200
30 Sale 25,200 152.00 3,830,400

Required:

1. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrated in Exhibit 5, using the weighted average cost method. Round unit cost to two decimal places, if necessary. Round all total cost amounts to the nearest dollar.

Midnight Supplies Schedule of Cost of Goods Sold Weighted Average Cost Method For the Three Months Ended March 31
Purchases Cost of Goods Sold Inventory
Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost
Jan. 1 $ $
Jan. 10 $ $
Jan. 28 $ $
Jan. 30
Feb. 5
Feb. 10
Feb. 16
Feb. 28
Mar. 5
Mar. 14
Mar. 25
Mar. 30
Mar. 31 Balances $ $

2. Determine the total sales, the total cost of goods sold, and the gross profit from sales for the period.

Total sales $
Total cost of goods sold $
Gross profit $

3. Determine the ending inventory cost as of March 31. $

Periodic inventory by three methods

The beginning inventory for Midnight Supplies and data on purchases and sales for a three-month period are shown below:

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 4,027,500
14 Sale 30,000 160.00 4,800,000
25 Purchase 7,500 90.00 675,000
30 Sale 26,250 160.00 4,200,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 $
Cost of goods sold $

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 $
Cost of goods sold $

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 $
Cost of goods sold $

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.

FIFO LIFO Weighted Average
Sales $ $ $
Cost of goods sold
Gross profit $ $ $
Inventory, March 31 $ $ $

Step by Step Solution

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

Step: 3

blur-text-image

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

Introductory Accounting Finance And Auditing For Lawyers

Authors: Lawrence Cunningham

7th Edition

1634604105, 9781634604109

More Books

Students also viewed these Accounting questions

Question

Eliminate street slang.

Answered: 1 week ago

Question

What is the cycle of intimate partner abuse?

Answered: 1 week ago