Periodic inventory by three methods The units of an item available for sale during the year...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Periodic inventory by three methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 2,500 units at $6 Feb. 17 Purchase 2,800 units at $8 Jul. 21 Purchase 3,200 units at $10 Nov. 23 Purchase 1,500 units at $12 There are 1,800 units of the item in the physical inventory at December 31. The periodic inventory system is used. 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. X Open spreadsheet a. Determine the inventory cost by the first-in, first-out method. $ 21,000 ✓ b. Determine the inventory cost by the last-in, first-out method. $ 9,400 X c. Determine the inventory cost by the weighted average cost method. Round your answer to the nearest dollar. $ 15,732 ✔ Periodic inventory by three methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 2,500 units at $6 Feb. 17 Purchase 2,800 units at $8 Jul. 21 Purchase 3,200 units at $10 Nov. 23 Purchase 1,500 units at $12 There are 1,800 units of the item in the physical inventory at December 31. The periodic inventory system is used. 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. X Open spreadsheet a. Determine the inventory cost by the first-in, first-out method. $ 21,000 ✓ b. Determine the inventory cost by the last-in, first-out method. $ 9,400 X c. Determine the inventory cost by the weighted average cost method. Round your answer to the nearest dollar. $ 15,732 ✔
Expert Answer:
Answer rating: 100% (QA)
Lets calculate the inventory cost by the firstin firstout FIFO lastin firstout LIFO and weighted ave... View the full answer
Related Book For
Forensic And Investigative Accounting
ISBN: 9780808056300
10th Edition
Authors: G. Stevenson Smith D. Larry Crumbley, Edmund D. Fenton
Posted Date:
Students also viewed these accounting questions
-
(3pts) Each station on an Ethernet network has its own unique physical address, called a MAC address. The address is of the form xx-xx-xx-xx-xx-xx or XX-XXXXXXXXXXXXX, where each x is a hexadecimal...
-
A risk-free 1-year 6% coupon bond has YTM=9% while a risk-free 1-year 16% coupon bond has YTM=9.1%. It is important to keep at least 7 decimal digits for all calculations: a) Find the bonds' prices...
-
The fraud examiner has to differentiate between? a. Truth and fact b. Fact and opinion c. Opinion and truth d. Fact and truth.
-
Find the steady state response Io (t) for the network shown the fig.
-
At the end of May, the sales journal of Mountain View appears as follows. Assume beginning inventory balance for May to be $11,692. Sales Journal Invoice Number PR Page 2 Cost of Goods Sold Debit...
-
A centrifugal pump with a 7-in.-diameter impeller has the performance characteristics shown in Fig. 12.12. The pump is used to pump water at \(100{ }^{\circ} \mathrm{F}\), and the pump inlet is...
-
Applin Corporation has a desired rate of return of 8 percent. Troy Anderson is in charge of one of Applins three investment centers. His center controlled operating assets of $5,000,000 that were...
-
We met with Christine Smith, a human resources representative, on September 9 th to discuss the city-run residential addiction clinic. She voiced some concerns regarding the nature of staff,...
-
You will file 2022 Federal income tax return (treat all info as for year 2022not year 2021). Ignore the last paragraph of the tax return problem info (it does not apply to 2022, the book was still on...
-
Depreciation Expense has a debit balance in the Trial Balance section of the worksheet of $2,200 and a debit of $200 in the adjustments section of the worksheet, the balance of Depreciation Expense...
-
Solve for side x (round your answer to the nearest tenth): 30 4 X
-
Angelina Dunkin, owner of Angelina?s Scents, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2019 and 2020: Mo/yr...
-
If 2x - 3y = 2a and 3x - 5y = -36 express y in terms of a and b.
-
You are expected to do critique and conduct a literature review to discuss a contemporary issue which an IS professional may experience and identify appropriate approaches to address this issue. The...
-
What role do stakeholders play in a strategic approach to environmental problems? How can companies satisfy the interests of various stakeholders?
-
62.A water bed is 2m on a side and 30cm deep. (a) Find weight (b) Find the pressure that the water bed exerts on the floor. Assume that the entire lower surface of the bed makes contact with the...
-
Calculate the Lagrange polynomial P 2 (x) for the values (1.00) = 1.0000, (1.02) = 0.9888, (1.04) = 0.9784 of the gamma function [(24) in App. A3.1] and from it approximations of (1.01) and (1.03).
-
Allstar Company invests in a project with expected cash inflows of $9,000 per year for four years. All cash flows occur at year-end. The required return on investment is 9%. If the project generates...
-
Identify the errors in the following schedule of the cost of goods sold for the year ended May 31, 20Y5: Cost of goods sold: Inventory, May 31, 20Y5 .. Cost of merchandise purchased: Purchases .......
-
Gallatin County Motors Inc. assembles and sells snowmobile engines. The company began operations on July 1 and operated at 100% of capacity during the first month. The following data summarize the...
-
The hangers support the joist in such a way that the four nails on each hanger can be assumed to support an equal portion of the load. If the joist is subjected to the loading shown, determine the...
-
The 60 mm x 60 mm oak post is supported on the pine block. If the allowable bearing stresses for these materials are oak = 43 MPa and pine 25 MPa, determine the greatest load P that can be...
-
The hangers support the joist in such a way that the four nails on each hanger can be assumed to support an equal portion of the load. Determine the smallest diameter of the nails at A and B to the...
Study smarter with the SolutionInn App