/*! This file is auto-generated */ .wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none} Q4P. Hull Company’s record of trans... [FREE SOLUTION] | 91Ó°ÊÓ

91Ó°ÊÓ

Hull Company’s record of transactions concerning part X for the month of April was as follows.

Purchases Sales

April 1 (balance on hand) 100 @ $5.00 April 5 300

4 400 @ 5.10 12 200

11 300 @ 5.30 27 800

18 200 @ 5.35 28 150

26 600 @ 5.60

30 200 @ 5.80

Instructions

(a) Compute the inventory at April 30 on each of the following bases. Assume that perpetual inventory records are kept inunits only. Carry unit costs to the nearest cent.

(1) First-in, first-out (FIFO).

(2) Last-in, first-out (LIFO).

(3) Average cost.

(b) If the perpetual inventory record is kept in dollars, and costs are computed at the time of each withdrawal, what amountwould be shown as ending inventory in (1), (2), and (3) above? (Carry average unit costs to four decimal places.)

Short Answer

Expert verified

Ending inventory under the periodic system:

FIFO $2000

LIFO $1175

Average cost $1890

Ending inventory under the perpetual system:

FIFO $2000

LIFO $1915

Average cost $1977.3

Step by step solution

01

Valuation of ending inventory

As the inventory records are kept in units only, the FIFO, LIFO, and Average cost would be computed based on the periodic system.

Endinginventory(Units)=Openingstock+TotalPurchases-TotalSales=100+(400+300+200+600+200)-(300+200+800+150)=100+1700-1450=350

1) Inventory valuation under FIFO

Date

Units

Units Cost

Total Cost

April 30

200

$5.80

$1160

April 26

150

$5.60

$840

350

$2000

2) Inventory valuation under LIFO

Date

Units

Units Cost

Total Cost

April 1

100

$5

$500

April 4

250

$5.10

$1275

350

$1775

3) Inventory valuation under Weighted Average method

Averagecostofinventory=ValueofOpeningstock+ValueofallpurchasesTotalavailablegoods=(100×$5)+(400×$5.10+300×$5.30+200×$5.35+600×$5.60+200×$5.80)(100+400+300+200+600+200)=$500+$92201800=$5.4

Costofendinginventory=Averagecostofinventory×No.ofendinginventory=$5.4×350=$1,890

02

Valuation of ending inventory by the perpetual method

1) Inventory valuation under FIFO

Date

Purchase

Cost of goods sold

Balance

Units

Cost

Balance

Units

Cost

Balance

Units

Cost

Balance

April 1

100

$5

$500

100

$5

$500

April 4

400

$5.10

$2040

100

$5

$500

400

$5.10

$2040

April 5

100

$5

$500

200

$5.10

$1020

200

$5.10

$1020

April 11

300

$5.30

$1590

200

$5.10

$1020

300

$5.30

$1590

April 12

200

$5.10

$1020

300

$5.30

$1590

April 18

200

$5.35

$1070

300

$5.30

$1590

200

$5.35

$1070

April 26

600

$5.60

$3360

300

$5.30

$1590

200

$5.35

$1070

600

$5.60

$3360

April 27

300

$5.30

$1590

200

$5.35

$1070

300

$5.60

$1680

300

$5.60

$1680

April 28

150

$5.60

$840

150

$5.60

$840

April 30

200

$5.80

$1160

150

$5.60

$840

200

$5.80

$1160

Total

1450

$7720

350

$2000

Ending Inventory under FIFO is $2000.

2) Inventory valuation under LIFO

Date

Purchase

Cost of goods sold

Balance

Units

Cost

Balance

Units

Cost

Balance

Units

Cost

Balance

April 1

100

$5

$500

100

$5

$500

April 4

400

$5.10

$2040

100

$5

$500

400

$5.10

$2040

April 5

300

$5.10

$1530

100

5

$500

100

$5.10

$510

April 11

300

$5.30

$1590

100

$5

$500

100

$5.10

$510

300

$5.30

$1590

April 12

200

$5.30

$1060

100

$5

$500

100

$5.10

$510

100

$5.30

$530

April 18

200

$5.35

$1070

100

$5

$500

100

$5.10

$510

100

$5.30

$530

200

$5.35

$1070

April 26

600

$5.60

$3360

100

$5

$500

100

$5.10

$510

100

$5.30

$530

200

$5.35

$1070

600

$5.60

$3360

April 27

600

$5.60

$3360

100

$5

$500

200

$5.35

$1070

100

$5.10

$510

100

$5.30

$530

April 28

100

$5.30

$530

100

$5

$500

50

$5.10

$255

50

$5.10

$255

April 30

200

$5.80

$1160

100

$5

$500

50

$5.10

$255

200

$5.80

$1160

Total

1450

$7805

350

$1915

Ending inventory under FIFO is $1915

3) Inventory valuation under weighted average method.

Date

Purchase

Cost of goods sold

Balance

Units

Cost

Balance

Units

Cost

Balance

Units

Cost

Balance

April 1

100

$5

$500

100

$5

$500

April 4

400

$5.10

$2040

100

$5

$500

400

$5.10

$2040

Total

500

$5.08

$2540

April 5

300

$5.08

$1524

200

$5.08

$1016

April 11

300

$5.30

$1590

200

$5.08

$1016

300

$5.30

$1590

Total

500

$5.212

$2606

April 12

200

$5.212

$1042.4

300

$5.212

$1563.6

April 18

200

$5.35

$1070

300

$5.212

$1563.6

200

$5.35

$1070

Total

500

$5.2672

$2633.6

April 26

600

$5.60

$3360

500

$5.2672

$2633.6

600

$5.60

$3360

Total

1100

$5.4487

$5993.6

April 27

800

$5.4487

$4358.96

300

$5.4487

$1634.61

April 28

150

$5.4487

$817.305

150

$5.4487

$817.305

April 30

200

$5.80

$1160

150

$5.4487

$817.30

200

$5.80

$1160

Total

1450

$7742.665

350

$5.6494

$1977.3

Ending inventory under the average method is $1977.3.

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 91Ó°ÊÓ!

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

The following is a record of Pervis Ellison Company’s transactions for Boston Teapots for the month of May 2017.

May 1 Balance 400 units @ \(20 May 10 Sale 300 units @ \)38

12 Purchase 600 units @ \(25 20 Sale 540 units @ \)38

28 Purchase 400 units @ $30

Instructions

(a) Assuming that perpetual inventories are not maintained and that a physical count at the end of the month shows 560units on hand, what is the cost of the ending inventory using (1) FIFO and (2) LIFO?

(b) Assuming that perpetual records are maintained and they tie into the general ledger, calculate the ending inventory using (1) FIFO and (2) LIFO.

The board of directors of Ichiro Corporation is considering whether or not it should instruct the accounting department to shift from a first-in, first out (FIFO) basis of pricing inventories to a last-in, first-out (LIFO) basis. The following information is available.

Sales 21,000 units @ \(50

Inventory, January 1 6,000 units @ 20

Purchases 6,000 units @ 22

10,000 units @ 25

7,000 units @ 30

Inventory, December 31 8,000 units @ ?

Operating expenses \)200,000

Instructions

Prepare a condensed income statement for the year on both bases for comparative purposes.

Dimitri Company, a manufacturer of small tools, provided the following information from its accounting records for the year ended December 31, 2017.

Inventory at December 31, 2017 (based on physical count of goods in Dimitri’s plant, at cost, on December 31, 2017) \(1,520,000

Accounts payable at December 31, 2017 1,200,000

Net sales (sales less sales returns) 8,150,000

Additional information is as follows.

1. Included in the physical count were tools billed to a customer f.o.b. shipping point on December 31, 2017. These tools had a cost of \)31,000 and were billed at \(40,000. The shipment was on Dimitri’s loading dock waiting to be picked up by the common carrier.

2. Goods were in transit from a vendor to Dimitri on December 31, 2017. The invoice cost was \)76,000, and the goods were shipped f.o.b. shipping point on December 29, 2017.

3. Work in process inventory costing \(30,000 was sent to an outside processor for plating on December 30, 2017.

4. Tools returned by customers and held pending inspection in the returned goods area on December 31, 2017, were not included in the physical count. On January 8, 2018, the tools costing \)32,000 were inspected and returned to inventory. Credit memos totaling \(47,000 were issued to the customers on the same date.

5. Tools shipped to a customer f.o.b. destination on December 26, 2017, were in transit at December 31, 2017, and had a cost of \)26,000. Upon notification of receipt by the customer on January 2, 2018, Dimitri issued a sales invoice for \(42,000.

6. Goods, with an invoice cost of \)27,000, received from a vendor at 5:00 p.m. on December 31, 2017, were recorded on a receiving report dated January 2, 2018. The goods were not included in the physical count, but the invoice was included in accounts payable at December 31, 2017.

7. Goods received from a vendor on December 26, 2017, were included in the physical count. However, the related \(56,000 vendor invoice was not included in accounts payable at December 31, 2017, because the accounts payable copy of the receiving report was lost.

8. On January 3, 2018, a monthly freight bill in the amount of \)8,000 was received. The bill specifically related to merchandise purchased in December 2017, one-half of which was still in the inventory at December 31, 2017. The freight charges were not included in either the inventory or in accounts payable at December 31, 2017.

Instructions

Using the format shown below, prepare a schedule of adjustments as of December 31, 2017, to the initial amounts per Dimitri’s accounting records. Show separately the effect, if any, of each of the eight transactions on the December 31, 2017, amounts. If the transactions would have no effect on the initial amount shown, enter NONE.

Accounts Net

Inventory Payable Sales

Initial amounts \(1,520,000 \)1,200,000 \(8,150,000

´¡»åÂá³Ü²õ³Ù³¾±ð²Ô³Ù²õ—i²Ô³¦°ù±ð²¹²õ±ð

(decrease)

1

2

3

4

5

6

7

8

Total adjustments

Adjusted amounts \) \( \)

Shawnee Corp., a household appliances dealer, purchases its inventories from various suppliers. Shawnee has consistently stated its inventories at FIFO cost.

Instructions

Shawnee is considering alternate methods of accounting for the cash discounts it takes when paying its suppliers promptly.From a theoretical standpoint, discuss the acceptability of each of the following methods.

(a) Financial income when payments are made.

(b) Reduction of cost of goods sold for the period when payments are made.

(c) Direct reduction of the purchase cost.

Ehlo Company is a multiproduct firm. Presented below is information concerning one of its products, the Hawkeye.

Date Transaction Quantity Price/Cost

1/1 Beginning inventory 1,000 $12

2/4 Purchase 2,000 18

2/20 Sale 2,500 30

4/2 Purchase 3,000 23

11/4 Sale 2,200 33

Instructions

Compute cost of goods sold, assuming Ehlo uses:

(a) Periodic system, FIFO cost flow. (d) Perpetual system, LIFO cost flow.

(b) Perpetual system, FIFO cost flow. (e) Periodic system, weighted-average

cost flow.

(c) Periodic system, LIFO cost flow. (f) Perpetual system, moving-average

cost flow.

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.