Warning: foreach() argument must be of type array|object, bool given in /var/www/html/web/app/themes/studypress-core-theme/template-parts/header/mobile-offcanvas.php on line 20

Shania Twain Company was formed on December 1, 2016. The following information is available from Twain’s inventory records for Product BAP.

Units Unit Cost

January 1, 2017 (beginning inventory) 600 $ 8.00

Purchases:

January 5, 2017 1,200 9.00

January 25, 2017 1,300 10.00

February 16, 2017 800 11.00

March 26, 2017 600 12.00

A physical inventory on March 31, 2017, shows 1,600 units on hand.

Instructions

Prepare schedules to compute the ending inventory at March 31, 2017, under each of the following inventory methods.

(a) FIFO (b) LIFO. (c) Weighted-average (round unit costs to two decimal places).

Short Answer

Expert verified

The value of ending inventory under FIFO, LIFO, and the Average cost method are $18,000, $13,800, and $15,856, respectively.

Step by step solution

01

Value of ending inventory under FIFO

Under FIFO, the earliest inventories are issued first. So the latest inventories remain in the closing inventory list.

Based on this, the schedule for ending inventory of 1,600 units based on FIFO would be as follow –

Date

Units

Cost per unit

Amount

March 26, 2017

600

$12

$7200

Feb 16, 2017

800

$11

$8800

Jan 25, 2007

200

$10

$2000

Total

1,600

$18,000

So the value of ending inventory under FIFO is $18,000.

02

Value of ending inventory under LIFO

Under LIFO, the latest inventories are issued first. So the earliest inventories remain in the ending inventory list.

Based on this, the schedule for ending inventory of 1,600 units based on LIFO would be as follow –

Date

Units

Cost per unit

Amount

Beginning

600

$8

$4800

Jan 5, 2007

1000

$9

$9000

Total

1,600

$13,800

So the value of ending inventory under LIFO is $13,800.

03

Value of ending inventory under the weighted average

Under the weighted average method, the cost of ending inventory is computed based on the average cost for all inventory.

Averagecost=TotalInventoryvalueTotalunits=$44,6004,500=$9.91

Valueofendinginventory=Averagecost×EndingInventory(units)=$9.91×1,600=$15,856

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

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

Adjustments—increase

(decrease)

1

2

3

4

5

6

7

8

Total adjustments

Adjusted amounts \) \( \)

As compared with the FIFO method of costing inventories, does the LIFO method result in a larger or smaller net income in a period of rising prices? What is the comparative effect on net income in a period of falling prices?

Question:Johnny Football Shop began operations on January 2, 2017. The following stock record card for footballs was taken from the records at the end of the year.

Units Unit Invoice Gross Invoice

Date Voucher Terms Received Cost Amount

1/15 10624 Net 30 50 \(20 \)1,000

3/15 11437 1/5, net 30 65 16 1,040

6/20 21332 1/10, net 30 90 15 1,350

9/12 27644 1/10, net 30 84 12 1,008

11/24 31269 1/10, net 30 76 11 836

Totals 365 $5,234

A physical inventory on December 31, 2017, reveals that 100 footballs were in stock. The bookkeeper informs you that all thediscounts were taken. Assume that Johnny Football Shop uses the invoice price less discount for recording purchases.

Instructions

(a) Compute the December 31, 2017, inventory using the FIFO method.

(b) Compute the 2017 cost of goods sold using the LIFO method.

(c) What method would you recommend to the owner to minimize income taxes in 2017, using the inventory informationfor footballs as a guide?

The management of Tritt Company has asked its accounting department to describe the effect upon the company’s financial position and its income statements of accounting for inventorieson the LIFO rather than the FIFO basis during 2017 and 2018. The accounting department is to assume that the change to LIFO wouldhave been effective on January 1, 2017, and that the initial LIFO base would have been the inventory value on December 31, 2016. Thefollowing are the company’s financial statements and other data for the years 2017 and 2018 when the FIFO method was employed.

Financial Position as of

12/31/16 12/31/17 12/31/18

Cash \( 90,000 \)130,000 \(154,000

Accounts receivable 80,000 100,000 120,000

Inventory 120,000 140,000 176,000

Other assets 160,000 170,000 200,000

Total assets \)450,000 \(540,000 \)650,000

Accounts payable \( 40,000 \) 60,000 \( 80,000

Other liabilities 70,000 80,000 110,000

Common stock 200,000 200,000 200,000

Retained earnings 140,000 200,000 260,000

Total liabilities and equity \)450,000 \(540,000 \)650,000

Income for Years Ended

12/31/17 12/31/18

Sales revenue \(900,000 \)1,350,000

Less: Cost of goods sold 505,000 756,000

Other expenses 205,000 304,000

710,000 1,060,000

Income before income taxes 190,000 290,000

Income taxes (40%) 76,000 116,000

Net income \(114,000 \) 174,000

Other data:

1. Inventory on hand at December 31, 2016, consisted of 40,000 units valued at \(3.00 each.

2. Sales (all units sold at the same price in a given year):

2017—150,000 units @ \)6.00 each 2018—180,000 units @ \(7.50 each

3. Purchases (all units purchased at the same price in given year):

2017—150,000 units @ \)3.50 each 2018—180,000 units @ $4.40 each

4. Income taxes at the effective rate of 40% are paid on December 31 each year.

Instructions

Name the account(s) presented in the financial statements that would have different amounts for 2018 if LIFO rather than FIFOhad been used, and state the new amount for each account that is named. Show computations.

Question:Tori Amos Corporation began operations on December 1, 2016. The only inventory transaction in 2016 was the purchase of inventory on December 10, 2016, at a cost of \(20 per unit. None of this inventory was sold in 2016. Relevant information is as follows.

Ending inventory units

December 31, 2016 100

December 31, 2017, by purchase date

December 2, 2017 100

July 20, 2017 50 150

During the year, the following purchases and sales were made.

Purchases Sales

March 15 300 units at \)24 April 10 200

July 20 300 units at 25 August 20 300

September 4 200 units at 28 November 18 150

December 2 100 units at 30 December 12 200

The company uses the periodic inventory method.

Instructions

(a) Determine ending inventory under (1) specific identification, (2) FIFO, (3) LIFO, and (4) average cost.

(b) Determine ending inventory using dollar-value LIFO. Assume that the December 2, 2017, purchase cost is the current cost of inventory. (Hint:The beginning inventory is the base layer priced at $20 per unit.)

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