Calculate ending inventory and cost of goods sold at March 31, using the specific identification method. !Required information[The following information applies to the questions displayed below.]Greg's Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the month ofMarch. Greg's Bicycle Shop uses a periodic inventory system.DateTransactionsUnitsUnit CostTotal CostMarchBeginning inventorySale ($320 each)$ 210$ 4,200120March515MarchMarch9Purchase102302,300Sale ($370 each)PurchaseSale ($395 each)Purchase178March22102402,400March2712March3072601,820$10,720For the specific identification method, the March 5 sale consists of bikes from beginning inventory, the March 17 saleconsists of bikes from the March 9 purchase, and the March 27 sale consists of four bikes from beginning inventory andeight bikes from the March 22 purchase.rev: 02_28_2017_QC_CS-80932, 04_13_2020_QC_CS-208026Required:1. Calculate ending inventory and cost of goods sold at March 31, using the specific identification method.Ending inventoryCost of goods sold

Name: Calculate ending inventory and cost of goods sold at March 31, using t
Uploaded: 2024-03-20T06:32:37.000Z
Channel: Bartleby
Description: Calculate ending inventory and cost of goods sold at March 31, using the specific identification method. !Required information[The following information applies to the questions displayed below.]Greg's Bicycle Shop has the following transactions rela

Ending Inventory = Total cost of goods available for sale - Cost of goods available for sale

Business

Accounting

Greg's Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the month of March. Greg's Bicycle Shop uses a periodic inventory system. Unit Cost $ 210 Date Transactions Units Total Cost March $ 4,200 Beginning inventory Sale ($320 each) Purchase Sale ($370 each) 1 20 March 5 15 March 9 10 230 2,300 March 17 8 March 22 Purchase 10 240 2,400 March 27 Sale ($395 each) 12 March 30 Purchase 7 260 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. rev: 02_28_2017_QC_CS-80932, 04_13_2020_QC_CS-208026 Required: 1. Calculate ending inventory and cost of goods sold at March 31, using the specific identification method. Ending inventory Cost of goods sold

Greg's Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the month of March. Greg's Bicycle Shop uses a periodic inventory system. Unit Cost $ 210 Date Transactions Units Total Cost March $ 4,200 Beginning inventory Sale ($320 each) Purchase Sale ($370 each) 1 20 March 5 15 March 9 10 230 2,300 March 17 8 March 22 Purchase 10 240 2,400 March 27 Sale ($395 each) 12 March 30 Purchase 7 260 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. rev: 02_28_2017_QC_CS-80932, 04_13_2020_QC_CS-208026 Required: 1. Calculate ending inventory and cost of goods sold at March 31, using the specific identification method. Ending inventory Cost of goods sold

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter16: Manufacturing Accounting (mfg)

Section: Chapter Questions

Problem 3R: The following data pertain to 2012 activities of Twisp Industries: Use your completed worksheet to...

See similar textbooks

Similar questions

Lauer Corporation uses the periodic inventory system and thefollowing information about their laptop computer is available: Date Transaction Number of Units Cost per Unit 1/1 BeginningInventory 100 $800 5/5 Purchase 200 $900 8/10 Purchase 300 $1,000 10/15 Purchase 200 $1,050 During the year, 750 laptop computers were sold.What was ending inventory and cost of goods sold on 12/31 under the FIFO costflow assumption? A. $60,000 and $710,000 B. $52,500 and $717,500 C. $52,000 and $718,000 D. None of the answers is correct
The following information applies to the questions displayed below.]Greg’s Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the month of March. Greg's Bicycle Shop uses a periodic inventory system. Date Transactions Units Unit Cost Total Cost March 1 Beginning inventory 20 $ 150 $ 3,000 March 5 Sale ($200 each) 15 March 9 Purchase 10 170 1,700 March 17 Sale ($250 each) 8 March 22 Purchase 10 180 1,800 March 27 Sale ($275 each) 12 March 30 Purchase 7 200 1,400…
Waqar Sound uses a periodic inventory system. One of the store’s products is a wireless headphone.The inventory quantities, purchases, and sales of this product for the most recent year are as follows: Number of units Cost per Unit Total Cost Inventory, Jan 1 10 150 Rs 1500 First Purchase 30 101 3030 Second Purchase 40 140 5600 Third Purchase 5 110 550 Fourth Purchase 15 130 1,950 Good available for sale 100 Units sold during the year 80 Inventory, Dec 31 20 Instructions Using periodic costing procedures, compute the cost of the December 31 inventory and thecost of goods sold for the year under each of the following cost assumptions: First-in, first-out. Last-in, first-out. Average cost (round to the nearest dollar, except unit cost).
[The following information applies to the questions displayed below.]Greg’s Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the month of March. Greg's Bicycle Shop uses a periodic inventory system. Date Transactions Units Unit Cost Total Cost March 1 Beginning inventory 20 $ 215 $ 4,300 March 5 Sale ($330 each) 15 March 9 Purchase 10 235 2,350 March 17 Sale ($380 each) 8 March 22 Purchase 10 245 2,450 March 27 Sale ($405 each) 12 March 30 Purchase 8 265 2,120 $ 11,220 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…
Millicent, a merchandiser of fancy tea party hats, has the following activity for the month: $850 of inventory purchases from supplier, terms are 4/15, n/30, FOB Shipping Point and freight costs are $40. A return of $125 of merchandise is made to supplier. Payment to supplier is made within the discount period. Given this information, what is the ending inventory balance for the Millicent? Group of answer choices $736 $691 $696 $725
Calculate ending inventory, cost of goods sold, sales revenue, and gross profit for four inventory methods (LO6-3, 6-4, 6-5) Ariana Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the month of March. Ariana Bicycle Shop uses a periodic inventory system. Date Transactions Units Unit Cost Total Cost March 1 Beginning inventory 20 $235 $4,700 March 5 Sale ($370 each) 15 March 9 Purchase 10 255 2,550 March 17 Sale ($420 each) 8 March 22 Purchase 10 265 2,650 March 27 Sale ($445 each) 12 March 30 Purchase 9 285 2,565 $12,465 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.
Please show the complete solution. Thank you so much. 1. On January 5, CRYSTAL LANCER Company purchased 5,000 units of Class A inventory at P100 each and 10,000 units of Class B inventory at P80 each under credit terms of 3/10, EOM. The Class A type was paid on January 15 and the Class B type on January 25. Q1. Under the gross method, what amount of net purchases should be included in computing total goods available for sale?a. P1,300,000b. P1,261,000c. P1,285,000d. P1,276,000 Q2. Under the net method, what amount of net purchases should be included in computing total goods available for sale?a. P1,300,000b. P1,261,000c. P1,285,000d. P1,276,000
Steven Company uses a perpetual inventory system. It sells its product to customers for $60 per unit. Below is information regarding inventory transactions for April. The company uses the FIFO method. Apr.1 Beginning Inventory 60 units @ $22 = $1,320 Apr. 12 Purchase 1 30 units @ $23 = $690 Apr. 18 Sale 1 15 units Apr. 20 Purchase 2 15 units @ $25 = $375 Apr. 29 Sale 2 50 units Using the FIFO inventory method, what is the cost of Ending Inventory? Show your calculations Blank 1. Fill in the blank, read surrounding text. Cost of Ending Inventory Blank 2. Fill in the blank, read surrounding text.
Maria B, Inc. uses a perpetual inventory system. This system includes a perpetual inventory record card for each of the 50 types of the products the company keep in stock. The following transactions show the purchase and sale of particular round table (product code AB-RB7) during November. Nov.1 Balance on hand, 50 units, cost $60 each…………………………………….$3,000 Nov.4Purchase, 20 Units, cost $65 each……………………………………………..$1300 Nov.8Sale, 35 units, Sale price $100 each…………………………………………...$3500 Nov.9 Purchase, 40 units, cost $65 each……………………………………………..$2600 Nov.20Sale, 60 units, sale price $100 each…………………………………………..$6000 Nov.25Purchase 40 units, cost $70 each…………………………………….……….$2800 Nov.30Sale 5 units sale price $110 each………………………………………...…….$550 Required: Record the beginning inventory, the purchases, the cost of goods sold, and the running balance on an inventory record card by Using W.Average Cost Method & LIFO method. Prepare journal entries to record these purchases and sales in…
Maria B, Inc. uses a perpetual inventory system. This system includes a perpetual inventory record card for each of the 50 types of the products the company keep in stock. The following transactions show the purchase and sale of particular round table (product code AB-RB7) during November. Nov.1 Balance on hand, 50 units, cost $60 each…………………………………….$3,000 Nov.4Purchase, 20 Units, cost $65 each……………………………………………..$1300 Nov.8Sale, 35 units, Sale price $100 each…………………………………………...$3500 Nov.9 Purchase, 40 units, cost $65 each……………………………………………..$2600 Nov.20Sale, 60 units, sale price $100 each…………………………………………..$6000 Nov.25Purchase 40 units, cost $70 each…………………………………….……….$2800 Nov.30Sale 5 units sale price $110 each………………………………………...…….$550 Required: Record the beginning inventory, the purchases, the cost of goods sold, and the running balance on an inventory record card by Using Average Cost Method & LIFO method. Prepare journal entries to record these purchases and sales in…
Maria B, Inc. uses a perpetual inventory system. This system includes a perpetual inventory record card for each of the 50 types of the products the company keep in stock. The following transactions show the purchase and sale of particular round table (product code AB-RB7) during November. Nov.1 Balance on hand, 50 units, cost $60 each…………………………………….$3,000 Nov.4Purchase, 20 Units, cost $65 each……………………………………………..$1300 Nov.8Sale, 35 units, Sale price $100 each…………………………………………...$3500 Nov.9 Purchase, 40 units, cost $65 each……………………………………………..$2600 Nov.20Sale, 60 units, sale price $100 each…………………………………………..$6000 Nov.25Purchase 40 units, cost $70 each…………………………………….……….$2800 Nov.30Sale 5 units sale price $110 ea Maria B, Inc. uses a perpetual inventory system. This system includes a perpetual inventory record card for each of the 50 types of the products the company keep in stock. The following transactions show the purchase and sale of particular round table (product code AB-RB7)…
Blue Spruce Corp. markets CDs of numerous performing artists. At the beginning of March, Blue Spruce had in beginning inventory 2,600 CDs with a unit cost of $8. During March, Blue Spruce made the following purchases of CDs. March 5 2,100 @ $9 March 21 5,500 @ $11 March 13 3,700 @ $10 March 26 2,100 @ $12 During March 12,200 units were sold. Blue Spruce uses a periodic inventory system. (a) Correct answer iconYour answer is correct. Determine the cost of goods available for sale. The cost of goods available for sale $enter the cost of goods available for sale in dollars Calculate Average Cost. (Round answer to 3 decimal places, e.g. 5.125.) (b) Determine (1) the ending inventory and (2) the cost of goods sold under each of the assumed cost flow methods (FIFO, LIFO, and average-cost). (Round answers to 0 decimal places, e.g. 125.) FIFO LIFO AVERAGE-COST The…