George Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the month of March. George Bicycle Shop uses a periodic inventory system. Date March 1 March 5 March 9 March 17 March 22 March 27 March 30 Transactions Beginning inventory Sale ($320 each) Purchase Sale ($370 each) Purchase Sale ($395 each) Purchase Units 20 15 10 8 10 12 7 Unit Cost $210 230 240 260 Total Cost $4,200 2,300 2,400 1,820 $10,720 For the specific identification method, the March 5 sale consists of bikes from beginning inventory, the March 17 sale consists of bikes from the March 9 purchase, and the March 27 sale consists of four bikes from beginning inventory and eight bikes from the March 22 purchase. Required: 1. Calculate ending inventory and cost of goods sold at March 31, using the specific identification method. 2. Using FIFO, calculate ending inventory and cost of goods sold at March 31. 3. Using LIFO, calculate ending inventory and cost of goods sold at March 31. 4. Using weighted-average cost, calculate ending inventory and cost of goods sold at March 31. 5. Calculate sales revenue and gross profit under each of the four methods.

George Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the month of March. George Bicycle Shop uses a periodic inventory system. Date March 1 March 5 March 9 March 17 March 22 March 27 March 30 Transactions Beginning inventory Sale ($320 each) Purchase Sale ($370 each) Purchase Sale ($395 each) Purchase Units 20 15 10 8 10 12 7 Unit Cost $210 230 240 260 Total Cost $4,200 2,300 2,400 1,820 $10,720 For the specific identification method, the March 5 sale consists of bikes from beginning inventory, the March 17 sale consists of bikes from the March 9 purchase, and the March 27 sale consists of four bikes from beginning inventory and eight bikes from the March 22 purchase. Required: 1. Calculate ending inventory and cost of goods sold at March 31, using the specific identification method. 2. Using FIFO, calculate ending inventory and cost of goods sold at March 31. 3. Using LIFO, calculate ending inventory and cost of goods sold at March 31. 4. Using weighted-average cost, calculate ending inventory and cost of goods sold at March 31. 5. Calculate sales revenue and gross profit under each of the four methods.

Name: 6-5e use same chart George Bicycle Shop has the following transactions
Uploaded: 2024-03-20T06:32:37.000Z
Channel: Bartleby
Description: 6-5e use same chart George Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the month of March. GeorgeBicycle Shop uses a periodic inventory system.DateMarch 1March 5March 9March 17March 22March 27Marc

Financial Accounting

15th Edition

ISBN:9781337272124

Author:Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:Carl Warren, James M. Reeve, Jonathan Duchac

Chapter7: Inventories

Section: Chapter Questions

Problem 4CP: Golden Eagle Company began operations on April 1 by selling a single product. Data on purchases and...

See similar textbooks

Similar questions

Jessie Stores uses the periodic system of calculating inventory. The following information is available for December of the current year when Jessie sold 500 units of inventory. Using the FIFO method, calculate Jessies inventory on December 31 and its cost of goods sold for December.
Golden Eagle Company began operations on April 1 by selling a single product. Data on purchases and sales for the year are as follows: Purchases: Sales: The president of the company, Connie Kilmer, has asked for your advice on which inventory cost flow method should be used for the 32,000-unit physical inventory that was taken on December 31. The company plans to expand its product line in the future and uses the periodic inventory system. Write a brief memo to Ms. Kilmer comparing and contrasting the LIFO and FIFO inventory cost flow methods and their potential impacts on the companys financial statements.
Carla Company uses the perpetual inventory system. The following information is available for January of the current year when Carla sold 1,600 units of inventory on January 14. Using the FIFO method, calculate Carlas cost of goods sold for January and its January 31 inventory.
On April 5, a customer returns 20 bicycles with a sales price of $250 per bike to Barrio Bikes. Each bike cost Barrio Bikes $100. The customer had yet to pay on their account. The bikes are in sellable condition. Prepare the journal entry or entries to recognize this return if the company uses A. the perpetual inventory system B. the periodic inventory system
Palisade Creek Co. is a merchandising business that uses the perpetual inventory system. The account balances for Palisade Creek Co. as of May 1, 2016 (unless otherwise indicated), are as follows: During May, the last month of the fiscal year, the following transactions were completed: Instructions 1. Enter the balances of each of the accounts in the appropriate balance column of a four-column account. Write Balance in the item section, and place a check mark () in the Posting Reference column. Journalize the transactions for July, starting on Page 20 of the journal. 2. Post the journal to the general ledger, extending the month-end balances to the appropriate balance columns after all posting is completed. In this problem, you are not required to update or post to the accounts receivable and accounts payable subsidiary ledgers. 3. Prepare an unadjusted trial balance. 4. At the end of May, the following adjustment data were assembled. Analyze and use these data to complete (5) and (6). 5. (Optional) Enter the unadjusted trial balance on a 10-column end-of-period spreadsheet (work sheet), and complete the spreadsheet. 6. Journalize and post the adjusting entries. Record the adjusting entries on Page 22 of the journal. 7. Prepare an adjusted trial balance. 8. Prepare an income statement, a statement of owners equity, and a balance sheet. 9. Prepare and post the closing entries. Record the closing entries on Page 23 of the journal. Indicate closed accounts by inserting a line in both the Balance columns opposite the closing entry. Insert the new balance in the owners capital account. 10. Prepare a post-closing trial balance.
Dymac Appliances uses the periodic inventory system. Details regarding the inventory of appliances at January 1, purchases invoices during the next 12 months, and the inventory count at December 31 are summarized as follows: Instructions 1. Determine the cost of the inventory on December 31 by the first-in, first-out method. Present data in columnar form, using the following headings: If the inventory of a particular model comprises one entire purchase plus a portion of another purchase acquired at a different unit cost, use a separate line for each purchase. 2. Determine the cost of the inventory on December 31 by the last-in, first-out method, following the procedures indicated in (1). 3. Determine the cost of the inventory on December 31 by the weighted average cost method, using the columnar headings indicated in (1). 4. Discuss which method (FIFO or LIFO) would be preferred for income tax purposes in periods of (a) rising prices and (b) declining prices.
FIFO perpetual inventory The beginning inventory at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows: Instructions 1. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrated in Exhibit 3, using the first-in, first-out method. 2. Determine the total sales and the total cost of goods sold for the period. Journalize the entries in the sales and cost of goods sold accounts. Assume that all sales were on account. 3. Determine the gross profit from sales for the period. 4. Determine the ending inventory cost on June 30. 5. Based upon the preceding data, would you expect the ending inventory using the last-in, first-out method to be higher or lower?
Pappas Appliances uses the periodic inventory system. Details regarding the inventory of appliances at January 1, purchases invoices during the year, and the inventory count at December 31 are summarized as follows: Instructions 1. Determine the cost of the inventory on December 31 by the first-in, first-out method. Present data in columnar form, using the following headings: If the inventory of a particular model comprises one entire purchase plus a portion of another purchase acquired at a different unit cost, use a separate line for each purchase. 2. Determine the cost of the inventory on December 31 by the last-in, first-out method, following the procedures indicated in (1). 3. Determine the cost of the inventory on December 31 by the weighted average cost method, using the columnar headings indicated in (1). 4. Discuss which method (FIFO or LIFO) would be preferred for income tax purposes in periods of (a) rising prices and (b) declining prices.
Communication Golden Eagle Company began operations on April 1 by selling a single product. Data on purchases and sales for the year are as follows: Purchases: Sales: The president of the company, Connie Kilmer, has asked for your advice on which inventory cost flow method should be used for the 32,000-unit physical inventory that was taken on December 31. The company plans to expand its product line in the future and uses the periodic inventory system. Write a brief memo to Ms. Kilmer comparing and contrasting the LIFO and FIFO inventory cost flow methods and their potential impacts on the companys financial statements.
West Bicycle Shop uses a three-column purchases journal. The company is located in Topeka, Kansas. In addition to a general ledger, the company also uses an accounts payable ledger. Transactions for January related to the purchase of merchandise are as follows: Jan. 4 Bought fifty 10-speed bicycles from Nielsen Company, 4,775, invoice no. 26145, dated January 3; terms net 60 days; FOB Topeka. 7 Bought tires from Barton Tire Company, 792, invoice no. 9763, dated January 5; terms 2/10, n/30; FOB Topeka. 8 Bought bicycle lights and reflectors from Gross Products Company, 384, invoice no. 17317, dated January 6; terms net 30 days; FOB Topeka. 11 Bought hand brakes from Bray, Inc., 470, invoice no. 291GE, dated January 9; terms 1/10, n/30; FOB Kansas City, freight prepaid and added to the invoice, 36 (total 506). 19 Bought handle grips from Gross Products Company, 96.50, invoice no. 17520, dated January 17; terms net 30 days; FOB Topeka. 24 Bought thirty 5-speed bicycles from Nielsen Company, 1,487, invoice no. 26942, dated January 23; terms net 60 days; FOB Topeka. 29 Bought knapsacks from Davila Manufacturing Company, 304.80, invoice no. 762AC, dated January 26; terms 2/10, n/30; FOB Topeka. 31 Bought locks from Lamb Safety Net, 415.47, invoice no. 27712, dated January 26; terms 2/10, n/30; FOB Dodge City, freight prepaid and added to the invoice, 22 (total 437.47). Required 1. If using Working Papers, open the following accounts in the accounts payable ledger and record the January 1 balances, if any, as given: Barton Tire Company, 156; Bray, Inc.; Davila Manufacturing Company, 82.88; Gross Products Company; Lamb Safety Net, 184.20; Nielsen Company. For the accounts having balances, write Balance in the Item column and place a check mark in the Post. Ref. column. Skip this step if using CengageNow or CLGL. 2. If using Working Papers, record the balance of 423.08 in the Accounts Payable 212 controlling account as of January 1. Write Balance in the Item column and place a check mark in the Post. Ref. column. Skip this step if using CengageNow or CLGL. 3. Record the transactions in the purchases journal. If using Working Papers, begin on page 81. 4. Post to the accounts payable ledger daily. Skip this step if using CLGL. 5. Post to the general ledger at the end of the month. Skip this step if using CLGL. 6. Prepare a schedule of accounts payable, and compare the balance of the Accounts Payable controlling account with the total of the schedule of accounts payable.
Calculate the cost of goods sold dollar value for A66 Company for the month, considering the following transactions under three different cost allocation methods and using perpetual inventory updating. Provide calculations for last-in, first-out (LIFO).
Longmire Sons nude sales un credit to Alderman Sports totaling 500,000 on April 18. The cost of the goods sold is 400,000. Longmire estimates 3% of its sales to Alderman may be returned. On May 22, 9,000 worth of goods (with a cost of 7,200) are returned by Alderman. Longmire uses a periodic inventory system. Prepare the related journal entries for Longmire Sons.