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

  During your year-end review of the accounts related to

in 2011 space technology company modified its model z2 satellite to incorporate a new communication device. the company

  The manufacturing overhead

The manufacturing overhead

  How would your answers to requirements

How would your answers to requirements 1-5 differ if management had the intent and ability to hold the investments until maturity?

  You purchase a commercial building and lot for 450000 on

you purchase a commercial building and lot for 450000 on september 2nd 2012. the lot is estimated to be worth 80000

  Dampf inc has provided the following data concerning its

dampf inc. has provided the following data concerning its only product. selling price 200 per unit current sales 18800

  Dubois inc wishes to accumulate 1300000 by december 31 2022

dubois inc. wishes to accumulate 1300000 by december 31 2022 to retire bonds outstanding. the company deposits 200000

  Interest is payable annually on each decembe

1.On December 31, 2013, Interlink Communications issued 6% stated rate bonds with a face amount of $100 million.

  Prepare journal entries for setterstrom company

On July 10, Setterstrom increased the fund from $100.00 to $130.00. Prepare journal entries for Setterstrom Company.

  House of organs inc purchases organs from a well-known

house of organs inc. purchases organs from a well-known manufacturer and sells them at the retail level. the organs

  Prepare schedules to compute the ending inventory at march

Shania Twain Company was formed on December 1, 2013. The following information is available from Twain's inventory records for Product BAP. A physical inventory on March 31, 2014, shows 2,266 units on hand. Prepare schedules to compute the ending inv..

  Variable overhead rate and efficiency variances input all

budgetedactualnbspsales 8000 ingots240000 nbspnbsp240000 nbspnbspnbspnbspnbspnbspnbspvariable

  Complete all the applicable parts of the tax forms

Complete the attached template that has the respective tax forms (page 1 of form 1040 and schedules) to complete the tax return. Complete all the applicable parts of the tax forms

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