Prepare an worksheet that shows ending inventory balance

Assignment Help Accounting Basics
Reference no: EM131711891

Question - On January 1, 2010, ABC Co. had inventory of 200 units @ 18.00 a unit. It purchased 400 more units @ $20.00 a piece on Feb. 19th. On May 12th, it bought 300 more units @ $22.00 each. On Oct. 3rd, it bought an additional 100 units for $24.00 a unit. On Dec. 31st, an inventory count showed only 206 units that had not been sold.

Prepare an Excel worksheet that shows the Ending Inventory Balance and the Cost of Goods Sold for the year using each of the three inventory valuation methods, LIFO, FIFO, and Average Cost. You will be graded on how well your worksheet data flows. For example, if I open your worksheet and change the ending inventory number, then I expect your worksheet to also change based on the new information. Be sure to link as many cells as possible and use formulas for every calculation.

Reference no: EM131711891

Questions Cloud

Is a pie chart an appropriate display for the data : Oil spills 2006. Data from the International Tanker Owners Pollution Federation Limited (www.itopf.com) give the cause of spillage for 312 large oil tanker.
How can you decide what type of decision is strategic : How can you decide what type of decision is strategic? In your discussion, bring in articles or research from various sources to justify your position.
Evaluate and calculate a companys weighted average cost : Evaluate and calculate a companys weighted average cost of capital and use the analysis to make company investment decisions.
Compute the percentages of respondents : Global Warming. The Pew Research Center for the People and the Press (http://people-press.org) has asked a representative sample of U.S. adults.
Prepare an worksheet that shows ending inventory balance : Prepare an Excel worksheet that shows the Ending Inventory Balance and the Cost of Goods Sold for the year
New blender will mean an increase in his investment : Charles Lackey can also improve the yield by purchasing a new blender. The new blender will mean an increase in his investment.
Explain development of a healthcare business units strategy : Explain Development of a Healthcare Business Unit's Strategy. What do you believe can be done to reduce costs, thereby giving this organization a competitiv
Review acse study about the modalities : Modalities. A survey of athletic trainers (Scott F. Nadler, Michael Prybicien, Gerard A. Malanga, and Dan Sicher).
Amino acids in the liver : What do we call the process by which amino acids are converted to other amino acids in the liver?

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd