# 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 shown in Problem 7-1A. Instructions 1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual Inventory record similar to the one illustrated in Exhibit 5, using the weighted average cost method. 2. Determine the total sales, the total cost of merchandise sold, and the gross profit from sales for the period. 3. Determine the ending inventory cost as of March 31.

### Accounting

27th Edition
WARREN + 5 others
Publisher: Cengage Learning,
ISBN: 9781337272094

### Accounting

27th Edition
WARREN + 5 others
Publisher: Cengage Learning,
ISBN: 9781337272094

#### Solutions

Chapter
Section
Chapter 7, Problem 7.3APR
Textbook Problem

## Weighted average cost method with perpetual inventoryThe beginning inventory for Midnight Supplies and data on purchases and sales for a three-month period are shown in Problem 7-1A.Instructions 1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual Inventory record similar to the one illustrated in Exhibit 5, using the weighted average cost method. 2. Determine the total sales, the total cost of merchandise sold, and the gross profit from sales for the period. 3. Determine the ending inventory cost as of March 31.

Expert Solution

(1)

To determine

Perpetual Inventory System:

Perpetual Inventory System refers to the inventory system that maintains the detailed records of every inventory transactions related to purchases, and sales on a continuous basis. It shows the exact on-hand-inventory at any point of time.

Weighted-average cost method:

Under weighted average cost method, the company calculates a new average cost after every purchase is made. It is determined by dividing the cost of goods available for sale by the units on hand.

To record: inventory, purchase and cost of merchandise sold data in perpetual inventory record.

### Explanation of Solution

Figure (1)

Working notes:

Calculate the weighted average unit cost as follows: (Jan 10)

 Weighted average method Quantity Unit cost Total cost of inventory in hand Â 7,500 units $75$562,500 Â 22,500 units $85$1,912,500 Â 30,000 units Â $2,475,000 Â Table (1) WeightedÂ averageÂ unitÂ costÂ =Â TotalÂ costÂ ofÂ inventoryÂ inÂ handTotalÂ quantity=$2,475,00030,000=$82.50 (1) Calculate the weighted average unit cost as follows: (Feb 10)  Weighted average method Quantity Unit cost Total cost of inventory in hand Â 13,500 units$82.50 $1,113,750 Â 54,000 units$87.50 $4,725,000 Â 67,500 units Â$5,838,750 Â

Table (2)

WeightedÂ averageÂ unitÂ costÂ =Â TotalÂ costÂ ofÂ inventoryÂ inÂ handTotalÂ quantity=$5,838,75067,500=$86

Expert Solution

(2)

To determine

To calculate: the sales and cost of merchandise sold accounts and gross profit.

Expert Solution

(3)

To determine

To calculate: Ending inventory cost for the period.

### Want to see the full answer?

Check out a sample textbook solution.See solution

### Want to see this answer and more?

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

See solution