answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
kirill [66]
2 years ago
14

FIFO and LIFO costs under perpetual inventory system The following units of an item were available for sale during the year: Beg

inning inventory Sale First purchase Sale Second purchase Sale 8,400 units at $200 5,500 units at $300 14,500 units at $205 13,400 units at $300 15,500 units at $210 14,400 units at $300 The firm uses the perpetual inventory system, and there are 5,100 units of the item on hand at the end of the year. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet
a. What is the total cost of the ending inventory according to FIFO? Round your answer to the nearest dollar. $ 3,255,000 X
b. What is the total cost of the ending inventory according to LIFO?
Business
1 answer:
klemol [59]2 years ago
4 0

Answer:

a. Ending inventory under FIFO = $1,071,000

b. Ending inventory value under LIFO = $1,036,500

Explanation:

The data are merged together in the question and they are first separated before the questions are answered as follows:

Beginning inventory: 8,400 units at $200

Sale: 5,500 units at $300

First purchase:  14,500 units at $205

Sale: 13,400 units at $300

Second purchase: 15,500 units at $210

Sale: 14,400 units at $300

Number units available for sale = 8,400 + 14,500 + 15,500 = 38,400 units

Number of units sold = 5,500 + 13,400 + 14,400 = 33,300 units

a. What is the total cost of the ending inventory according to FIFO? Round your answer to the nearest dollar. $ 3,255,000 X

Since second purchase is 15,500 units and last sales is 14,400, the 5,100 closing stock must be from the last purchases. Therefore we have:

Ending inventory under FIFO = 5,100 * $210 = $1,071,000

b. What is the total cost of the ending inventory according to LIFO?

Beginning inventory balance after first sale = 8,400 - 5,500 = 2,900

Second sale distribution = 100% from first purchase = 13,400

First Purchase balance = 14,500 - 13,400 = 1,100

Third sale distribution = 100% from second purchase = 14,400

Second Purchase balance = 15,500 - 14,400 = 1,100

Ending inventory value under LIFO = (2,900 * $200) + (1,100 * $205) + (1,100 * $210) = $1,036,500

You might be interested in
Peter's Audio has a yield to maturity on its debt of 7.8 percent, a cost of equity of 12.4 percent, and a cost of preferred stoc
nadezda [96]

Answer:

WACC = 9.22%

Explanation:

after tax cost of debt = 7.8% x (1 - 34%) = 5.148%

Re = 12.4%

cost of preferred stock = 8%

total value:

105,000 common stocks x $22 = $2,310,000

25,000 preferred stocks x $45 = $1,125,00

$1,500,000 bonds x 0.98 = $1,470,000

total value = $4,905,000

capital structure:

common stocks = $2,310 / $4,905 = 47.09%

preferred stocks = $1,125,00 / $4,905 = 22.94%

debt = $1,470,00 / $4,905 = 29.97%

WACC = (47.09% x 0.124) + (22.94% x 0.08) + (29.97% x 0.05148) = 9.22%

8 0
1 year ago
Warson Motors wants to raise $2 million by selling 20-year coupon bonds at par. Comparable bonds in the market have a coupon rat
Kitty [74]

Answer:

He should set coupon rate of 1.98%

Explanation:

Given Data:

Face Value of Bonds = $2,000,000

Coupon rate = 6.3 percent

Issue Value of Bonds = 6.5% * Face Value of Bonds

                                    = 6.5% * $2,000,000

                                    = 0.065 * $2,000,000

                                     = $130,000

Given Annual YTM = 6.30%  

Therefore,

Semiannual YTM = 3.15%

Time to Maturity = 20 years

Semiannual Period = 40

Let Semiannual Coupon be $C

$130,000 = $C * PVIFA(3.15%, 40) + $2,000,000

$130,000 = $C * (1 - (1/1.0315)^40) / 0.0315 + $2,000,000 / 1.0315^40

$130,000= $C * 22.56 + $578,443.2

$448,443.2 = $C * 22.56

$C = $19877.80

Semiannual Coupon = $19877.80

Semiannual Coupon Rate = Semiannual Coupon / Face Value of Bonds

Semiannual Coupon Rate = $19877.80 / $2,000,000

Semiannual Coupon Rate = 0.0099 or 0.99%

Annual Coupon Rate = 2 * Semiannual Coupon Rate

Annual Coupon Rate = 2 * 0.99%%

Annual Coupon Rate = 1.98%

4 0
2 years ago
Which of the following is an example of a soft skill?
netineya [11]

helping a costumer by answering a question

5 0
2 years ago
Margaret would like to work in the Journalism and Broadcasting industry. Which set of qualifications would best assist Margaret
jenyasd209 [6]
Your answer would be C because you gotta be ive if you wanna be in journalism and broadcasting
8 0
1 year ago
Read 2 more answers
Iris Company has provided the following information regarding two of its items of inventory at year-end: There are 160 units of
maw [93]

Answer:

$7,840

Explanation:

The inventory of Items A and B should be valued at the lower of cost and the net realizable value.

The cost is the invoice price at time of purchase ,while the net realizable value is the selling price less to sell

Products              Cost          Selling price cost to sell NRV    unit value

   A                         $18               $22                $6     $16             $16

   B                          $48              $54                $4    $50             $48

Item A is valued at $16 each i.e $16*160=$2,560

Item B is valued at $48 each i.e $48*110=$5,280

total value of inventory                             =$7,840

The ending inventory valued at the lower of cost or net realizable value is worth $7,840

6 0
2 years ago
Other questions:
  • Joe bought a stock at $57 per share. the price promptly fell to $55. joe held on to the stock until it again reached $57, and th
    7·1 answer
  • Yogen Früz is a successful chain of frozen yogurt shops originating in Canada. Archeology Investments has an agreement with the
    15·1 answer
  • Gion Company is considering eliminating its windows division, which reported an operating loss for the recent year of $105,000.
    9·1 answer
  • Assume that houses in an area appreciate at the rate of 4 percent a year. A borrower expects to have a loan-to-value ratio of 90
    15·1 answer
  • "In about 100 words, describe how an n-tier architecture might be used by an online business. Include in your answer an outline
    14·1 answer
  • The manager of your company's pension fund is compensated based entirely on fund performance; he earned over $1.2 million last y
    7·1 answer
  • Your uncle holds just one stock, East Coast Bank (ECB). You agree that this stock is relatively safe, but you want to demonstrat
    6·1 answer
  • Countercyclical monetary policy means that _________________. Select the correct answer below: the Fed lowers interest rates dur
    12·1 answer
  • Sela traveled from her home in Flagstaff to San Francisco to seek specialized medical care. Because she was unable to travel​ al
    7·1 answer
  • Containers, Inc., sends its standard order form to Distribution Corporation to evidence a sale of packing materials. Distributio
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!