Assume that ABC Company sells one product. The January activity for that product follows: Jan 1...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Assume that ABC Company sells one product. The January activity for that product follows: Jan 1 Jan 4 Jan 11 Jan 13 Jan 20 Jan 24 Jan 27 Inventory Sale Purchase Sale Purchase Purchase Sale 90 units @ $11 each 75 units@ $20 each 120 units @ $15 each 75 units @ $23 each 160 units $18 each 60 units@ $20 each 200 units @ $22 each A) Using an EXCEL spreadsheet and formulas within the Spreadsheet, prepare all journal entries for the month including any month-end closing entries assuming that the company uses the PERIODIC and LIFO methods. Compute the COGS and Ending Inventory values as of 1/31. A physical count of the warehouse finds total units remaining is 80. B) Ignore your answer to A). Using an EXCEL spreadsheet and formulas within the Spreadsheet, prepare all journal entries for the month including any month-end closing entries assuming that the company uses the PERPETUAL and FIFO methods. Compute the COGS and Ending Inventory values as of 1/31. A physical count of the warehouse finds total units remaining is 80. C) Ignore your answers to A) & B). Using an EXCEL spreadsheet and formulas within the Spreadsheet, prepare all journal entries for the month including any month-end closing entries assuming that the company uses the PERPETUAL and Average Cost methods. Compute the COGS and Ending Inventory values as of 1/31. A physical count of the warehouse finds total units remaining is 80. Assume that ABC Company sells one product. The January activity for that product follows: Jan 1 Jan 4 Jan 11 Jan 13 Jan 20 Jan 24 Jan 27 Inventory Sale Purchase Sale Purchase Purchase Sale 90 units @ $11 each 75 units@ $20 each 120 units @ $15 each 75 units @ $23 each 160 units $18 each 60 units@ $20 each 200 units @ $22 each A) Using an EXCEL spreadsheet and formulas within the Spreadsheet, prepare all journal entries for the month including any month-end closing entries assuming that the company uses the PERIODIC and LIFO methods. Compute the COGS and Ending Inventory values as of 1/31. A physical count of the warehouse finds total units remaining is 80. B) Ignore your answer to A). Using an EXCEL spreadsheet and formulas within the Spreadsheet, prepare all journal entries for the month including any month-end closing entries assuming that the company uses the PERPETUAL and FIFO methods. Compute the COGS and Ending Inventory values as of 1/31. A physical count of the warehouse finds total units remaining is 80. C) Ignore your answers to A) & B). Using an EXCEL spreadsheet and formulas within the Spreadsheet, prepare all journal entries for the month including any month-end closing entries assuming that the company uses the PERPETUAL and Average Cost methods. Compute the COGS and Ending Inventory values as of 1/31. A physical count of the warehouse finds total units remaining is 80.
Expert Answer:
Answer rating: 100% (QA)
A Periodic Inventory Method with LIFO Costing Debit Credit Inventory 11 x 90 990 Sales 20 x 75 1500 ... View the full answer
Related Book For
Advanced Accounting
ISBN: 978-1934319307
2nd edition
Authors: Susan S. Hamlen, Ronald J. Huefner, James A. Largay III
Posted Date:
Students also viewed these accounting questions
-
assume that abc company uses a perpetual inventory system the company has the same inventors purchase and sales date for the month of march as shown earlierinventorymarch 1200 units400800purchase...
-
Prepare all journal entries (budgetary and actual) required in all funds and the GCA and GLTL accounts to record the following transactions and events: 1. A state issued $50,000,000 of 4%, 20-year...
-
Prepare all journal entries (budgetary and actual) required in all funds and the GCA-GLTL accounts to record the following transactions and events: 1. The county sold old equipmentoriginal cost...
-
How would you compare the value of direct definition from friends in face-to-face conversation and strangers comments on a YouTube posting?
-
Sisel Company has two divisions, the Optic Lens Division and the Camera Division. The Camera Division may purchase lenses from the Optic Lens Division or from outside suppliers. The Optic Lens...
-
Go to the Shell website and examine the sustainability report. Examine the report and other information on the website and comment on the following: a. What approach did Shell take in undertaking its...
-
For binary distillation with \(\mathrm{CMO}, \mathrm{v}_{\text {ref,mol }}=0\). If \(\mathrm{CMO}\) is valid, show that \(\mathrm{v}_{\text {ref,mass }} eq 0\) if \(\mathrm{MW}_{\mathrm{A}} eq...
-
The portfolio manager of a hedge fund believes that stock A is undervalued and stock B is overvalued. Currently their prices are $30 and $30, respectively. The portfolio manager of the fund buys 100...
-
Unadjusted Trial Balance Rose Temple, Piano teacher December 3 1 , 2 0 2 3 Debit Credit Cash $ 1 0 , 7 7 6 . 6 2 Accounts Recievable 6 9 0 . 0 0 Inventory 1 8 2 . 0 0 Office supplies 9 4 9 . 9 5...
-
1. Create and upload a histogram of the salary data for the city of Bell, where each bar width is about 50,000 US dollars. (Data for the histogram is at the bottom). a.) Is the distribution of the...
-
colin and holy are married, Colin makes the following contributions to holly's spouse rrsp Year 1-2018-$6000 Year 2-2019-$8000 Year 3- 2020-$7000 Year 4 2021-$8000 Year 5- 2022-$0 Holy withdraws...
-
Following the incident at the holiday party, Sally decided that she didn't want to "rock the boat" and she liked her job as an HR coordinator too much to jeopardize it by complaining to the EEOC. She...
-
The choroid plexus located in each ventricle of the brain makesCSF. The ependymal cells filter plasma and help circulate the CSF.The CSF has various important functions. This fluid is...
-
A few years ago, Maria Ramundo purchased a home for $122,000. Today, the home is worth $160,000. Her remaining mortgage balance is $68,000. What is the maximum HELOC (home equity line of credit) she...
-
Equity Information == 7 billion shares, Beta = 1.37, Market risk premium = 10.5%, Risk-free rate = 6.5% Debt Information $3 billion in outstanding debt (face value), Face value = 1300, Current Price...
-
8. Consider the following solution to producer/consumer problem. void producer(void) { int item; while(TRUE) void consumer(void) { int item; while(TRUE) { item=produce item(); P(&empty); P(&mutex);...
-
have had positive outcomes. For example, the center is now highly valued by the community, as evidenced by a marked and rapid decline in incidents of vandalism, and the staff are proud of the...
-
Define the essential properties of the following types of operating systems: a. Batch b. Interactive c. Time sharing d. Real time e. Network f. Parallel g. Distributed h. Clustered i. Handheld
-
Assume the subsidiary's functional currency is the U.S. dollar. What is the remeasurement gain or loss for 2014? a. $162,000 loss b. $ 30,000 loss c. $162,000 gain d. $ 30,000 gain Use the following...
-
Cove Corporation owns all of Bay Corporation's common stock, acquired for $ 1,600,000 cash. Immediately prior to the acquisition, Cove reported current assets of $5,200,000, noncurrent assets of...
-
Goodwill International Technology Inc. (ITI) acquires all of the voting stock of Global Outsourcing Corporation (GOC) on June 30, 2010. Amounts paid are as follows (in millions): Cash consideration...
-
What are workers' compensation premiums? Who pays them? Who pays Social Security and Medicare taxes?
-
Jonas Company issues a 90 -day, 12 percent note payable to replace an account payable to Smith Supply Company in the amount of \(\$ 8,000\). Draft the journal entries (in general journal form) to...
-
The 6 percent bonds of Central Gas \& Electric are selling at a market price of 72, whereas the 6 percent bonds of Interstate Power are selling at a price of 97 . Does this mean that Interstate Power...
Study smarter with the SolutionInn App