Question

Splish Brothers Inc. uses a perpetual inventory system. Data for product E2-D2 include the following purchases.

Date Number of Units Unit Price
May 7 105 $7
July 28 63 18
On June 1, Splish Brothers sold 55 units, and on August 27, 84 more units. Prepare the perpetual inventory schedule for the above transactions using moving average cost.

Answer 1

Splish Brothers Inc.

Perpetual Inventory Schedule using moving average costs:

Date Description Number Average Cost Total Cost Cost

of Units Balance

May 7 Purchase 105 $7 $735 $735

June 1 Sales (55) $7 385 350

July 28 Purchase 63 $18 1,134 1,484

August 27 Sales (84) $13.1327 1,103 381

Step-by-step explanation:

a) Data and Calculations:

Date Number of Units Unit Price Total Costs

May 7 Purchase 105 $7 $735

June 1 Sales (55) $7 385

July 28 Purchase 63 $18 1,134

August 27 Sales (84) $13.1327 1,103

Cost of goods sold = $1,488 ($385 + $1,103)

Ending inventory = $381