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
Millner Corporation has provided the following data from its activity-based costing accounting system: Activity Cost Pool Total
ryzh [129]

Answer:

Activity rate = $176  per hour

Explanation:

<em>Activity-based costing is a form of absorption costing where overheads are charged to product using cost drivers.  </em>

<em>Under this method, overheads are first analyzed and categorized by the activities responsible for them and then charged to product based on the amount of benefits enjoyed using cost drivers.  </em>

<em>Activity rate per driver is calculated as:  </em>

Activity overhead for the period / Total cost drivers for the period   Designing products activity cost pool= designing cost /product design hours

        = $1372,448/7,798 hours

       = $176  per hour

4 0
2 years ago
On January 1, 2020, the balance sheet of Naperville Company (a sole proprietorship) was as follows.
guapka [62]

Answer:

Explanation:

From the information povided:

(a) To compute the amount of goodwill paid by Chicago Corporation

Particulars                                            Amount ($)

Accounts Receivable                           100000

Inventory                                               170000

Plant & Equipment                               400000

Land                                                        90000

Customer List                                            4000

Trade Names                                          <u> 16000</u>

     NET ASSETS  (A)                             <u>780000</u>

<u />

Current liabilities                                     76000

Non-current liabilities                            <u>160000 </u>

      NET LIABILITIES (B)                        <u> 236000</u>

∴

PURCHASE  CONSIDERATION (A -B)   544000

<u>Less:</u>  Cash Paid                                    <u>  580000</u>

          GODWILL                                    <u>    36000 </u>

<u />

b)

In the books of Chicago Corporation, the Journal Entry to record the purchase of Naperville Company.

Account Name                                       Dr.                      Cr.

Accounts Receivable A/C                  100000

Inventory A/C                                       170000

Plant Equipment  A/C                          400000

Land A/C                                                 90000

Customer List A/C                                    4000

Trade Names A/C                                   16000

Goodwill A/C                                           36000

Current liabilities A/C                                                       76000

Non-Current Liabilities A/C                                             160000

Cash A/C                                                                          580000

c)

The minimum required amount of goodwill that Chicago can amortize by the end of 2020 is $3600.This is because the amortization can take place for a period of 10 years.

<u />

8 0
1 year ago
The Carbondale Hospital is considering the purchase of ambulance. The TheXarbondale Hospital is considering the purchase of ambu
babunello [35]

Answer:

Explanation:

A) using 2-year moving average :

Year 6 : (3800 + 3700) = 7500 / 2 = 3750

2) Mean absolute deviation based on the forecast above :

(3000 + 4000) = 7000/2 = 3500

(4000 + 3400) = 7400/2 = 3700

(3400 + 3800) = 7200/2 = 3600

3000

4000

3400 __3500__100

3800__3700__100

3700__3600__100

Mean absolute deviation = (100 + 100 + 100) /3 = 300/3 = 100

C) weight of 0.4 and 0.6

(0.4*3000 + 0.6*4000) = 3600

(0.4*4000 + 0.6*3400) = 3640

(0.4*3400 + 0.6*3800) = 3640

3000

4000

3400 __3600__200

3800__3640__160

3700__3640__60

(200 + 160 + 60) = 420 / 3 = 140

5 0
2 years ago
Joe takes a dollar from the cash register every day and does not tell anyone about it. Sara’s cash register is $2 short because
KonstantinChe [14]
Well, obviously Sara is the better employee because she's being honest and tells the boss about her mistake. Joe is not a good employee, becuse he is stealing and doesn't tell anyone about it so, your answer is Sara is the better employee. Hope it helps!
6 0
2 years ago
Read 2 more answers
Mr. and Mrs. Haley are purchasing beachfront property in an upscale development. The home comes equipped with all furnishings. T
sweet-ann [11.9K]

Answer: package mortgage

Explanation:

From the question, we are informed that Mr and Mrs. Haley are purchasing beachfront property in an upscale development and that the home comes equipped with all furnishings.

We are further told that the Haleys want to get a mortgage that will cover the purchase price plus all the furnishings. This shows that they are looking for package mortgage.

A package mortgage is a form of mortgage whereby the personal property and the furniture will have to be included when buying the house.

8 0
1 year ago
Other questions:
  • Can cathy withdraw money from her ira savings account
    9·2 answers
  • Brenda wants to buy a new car and has a budget of $25,000. she has just found a magazine that assigns each car an index for styl
    10·1 answer
  • Answer the following question in your own words:
    8·1 answer
  • Label demand as elastic, unit elastic, or inelastic for each scenario. Use the midpoint method when applicable to calculate the
    8·1 answer
  • You have rented your first apartment, signing a lease that commits you to pay $500 each month for 12 months. You have an opportu
    14·1 answer
  • A company purchased $3,300 worth of merchandise. Transportation costs were an additional $290. The company returned $230 worth o
    14·1 answer
  • Which answer best fills in the blank in this sentence?
    12·1 answer
  • The equipment account had a $36,000 balance at the beginning of the year, and a $30,000 balance at the end of the year. The accu
    15·1 answer
  • Carter Motor Company, claims that its new sedan, the Libra, will average better than 23 miles per gallon in the city. Assuming t
    15·1 answer
  • Calculate the transaction value (in $ thousands) of a theoretical company based on the information provided below. Current Share
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!