Fit Gym began January with merchandise inventory of 78 crates of vitamins that cost a total of \(4,290. During the month, Fit Gym purchased and sold merchandise on account as follows

Jan. 5 Purchase 156 crates @ \) 64 each

13 Sale 180 crates @ \( 100 each

18 Purchase 114 crates @ \) 75 each

26 Sale 150 crates @ $ 116 each

Requirements

3. Prepare a perpetual inventory record, using the weighted-average inventory costing method, and determine the company’s cost of goods sold, ending merchandise inventory, and gross profit. (Round weighted-average cost per unit to the nearest cent and all other amounts to the nearest dollar.)

Short Answer

Expert verified

Cost of goods sold: $21,555

Ending Inventory: $1,278

Gross Profit: $13,845

Step by step solution

01

Step-by-Step Solution

Step 1: Perpetual inventory table under the weighted average method


Purchases
Cost of goods sold
Inventory on hand

Date

Qty

Unit cost

Total Cost

Qty

Unit cost

Total Cost

Qty

Unit Cost

Total Cost

Jan 1.

78

$55

$4,290

Jan 5.

156

$64

$9,984

234

$61

$14,274

Jan 13

180

$61

$10,980

54

$61

$3,294

Jan 18

114

$75

$8,550

168

$71

$11,928

Jan 26

150

$70.5

$10,575

18

$71

$1,278

Total

270

$18,534

330

$21,555

18

$71

$1,278

02

Computation of gross profit

TotalRevenue=Salevalueof13thJan+Salevalueof26thJan=180×$100+150×$116=$18,400+$17,400=$35,400

GrossProfit=Totalrevenue-Costofgoodssold=$35,400-$21,555=$13,845

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with Vaia!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Accounting for inventory using the perpetual inventory system—

FIFO, LIFO, and weighted-average, and comparing FIFO, LIFO, and weighted-average Steel Mill began August with 50 units of iron inventory that cost \(35 each. During August, the company completed the following inventory transactions:

Units Unit Cost Unit Sales Price

Aug. 3 Sale 45 \) 85

8 Purchase 90 $ 54

21 Sale 85 88

30 Purchase 15 58

Requirements

4. Determine the company’s cost of goods sold for August using FIFO, LIFO, and weighted-average inventory costing methods.

Fit Gym began January with merchandise inventory of 78 crates of vitamins that cost a total of \(4,290. During the month, Fit Gym purchased and sold merchandise on account as follows:

Jan. 5 Purchase 156 crates @ \) 64 each

13 Sale 180 crates @ \( 100 each

18 Purchase 114 crates @ \) 75 each

26 Sale 150 crates @ $ 116 each

Requirements

2. Prepare a perpetual inventory record, using the LIFO inventory costing method, and determine the company’s cost of goods sold, ending merchandise inventory, and gross profit.

Question:New York Pool Supplies’s merchandise inventory data for the year ended December 31, 2019, follow:

Net Sales Revenue\( 58,000

Cost of Goods Sold:

Beginning Merchandise Inventory\) 4,900

Net Cost of Purchases 32,500

Cost of Goods Available for Sale37,400

Less: Ending Merchandise Inventory 4,700

Cost of Goods Sold32,700

Gross Profit \( 25,300

Requirements

1. Assume that the ending merchandise inventory was accidentally overstated by\)1,800. What are the correct amounts for cost of goods sold and gross profit?

Some of M and C Electronics’s merchandise is gathering dust. It is now December 31, 2018, and the current replacement cost of the ending merchandise inventory is \(24,000 below the business’s cost of the goods, which was \)97,000. Before any adjustments at the end of the period, the company’s Cost of Goods Sold account has a balance of $380,000.

Requirements

4. Which accounting principle or concept is most relevant to this situation?

Futuristic Electronic Center began October with 65 units of merchandise inventory that cost \(82 each. During October, the store made the following purchases:

Oct. 3 25 units @ \) 90 each

12 30 units @ \( 90 each

18 35 units @ \) 96 each

Futuristic uses the periodic inventory system, and the physical count at October 31 indicates that 80 units of merchandise inventory are on hand.

Requirements

1. Determine the ending merchandise inventory and cost of goods sold amounts for the October financial statements using the FIFO, LIFO, and weighted-average inventory costing methods.

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.

Sign-up for free