Question:Super Mart, a regional convenience store chain, maintains milk inventory by the gallon.

The first month’s milk purchases and sales at its Freeport, Florida, location follow:

Nov. 2 Purchased 11 gallons @ \(2.15 each

6 Purchased 2 gallons @ \)2.80 each

8 Sold 6 gallons of milk to a customer

13 Purchased 3 gallons @ $2.85 each

14 Sold 4 gallons of milk to a customer

Requirements

3. Determine the amount that would be reported in ending merchandise inventoryon November 15 using the weighted-average inventory costing method. Round allamounts to the nearest cent.

Short Answer

Expert verified

The ending inventory on Nov.15 amounts to $14.58

Step by step solution

01

Step-by-Step-SolutionStep1: Perpetual Inventory weighted average Method

The Perpetual Inventory method is a system of maintaining inventory records continuously after every purchase and sale. The weighted average is a method of allocating costs based on the average cost of all inventory throughout a period.

So perpetual inventory under the weighted average method maintains the continuous record of inventory based on the average cost of every purchase or sale.

02

Calculation of ending inventory

Date

Purchase/opening

Sales

Balance

Units

Cost per unit

Amount

Units

Cost per unit

Amount

Units

Cost per unit

Amount

Nov 2

11

$2.15

$23.65

11

$2.15

$23.65

6

2

$2.80

$5.6

13

$2.25

$29.25

8

6

$2.25

$13.5

7

$2.25

$15.75

13

3

$2.85

$8.55

10

$2.43

$24.3

14

4

$2.43

$9.72

6

$2.43

$14.58

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

What account is debited when recording the adjusting entry to write down merchandise inventory under the LCM rule?

Assume that AB Tire Store completed the following perpetual inventory transactions for a line of tires:

May 1 Beginning merchandise inventory 16 tires @ \( 65 each

11 Purchase 10 tires @ \) 78 each

23 Sale 12 tires @ \( 88 each

26 Purchase 14 tires @ \) 80 each

29 Sale 18 tires @ $ 88 each

Requirements

3. Compute cost of goods sold and gross profit using the weighted-average inventory costing method. (Round weighted-average cost per unit to the nearest cent and all other amounts to the nearest dollar.)

Question:Boston Cycles started October with 12 bicycles that cost \(42 each. On October 16, Boston bought 40 bicycles at \)68 each. On October 31, Boston sold 34 bicycles for$100 each.

Preparing a perpetual inventory record and journal entries—LIFO

Requirements

2. Journalize the October 16 purchase of merchandise inventory on the account and theOctober 31 sale of merchandise inventory on the account.

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.)

Question:Golf Unlimited carries an inventory of putters and other golf clubs. The sales price of each putter is \(119. Company records indicate the following for a particular line ofGolf Unlimited’s putters:

Date Item Quantity Unit Cost

Nov. 1 Balance 24 \) 53

6 Sale 20

8 Purchase 30 70

17 Sale 30

30 Sale 2

Requirements

2. Journalize Golf Unlimited’s inventory transactions using the FIFO inventory costingmethod. (Assume purchases and sales are made on account.)

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