Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you. | ||||||||||
Part 1 | ||||||||||
Date | Account | Debit | Credit | |||||||
Jul 13 | Inventory | $ 5,396 | ||||||||
Accounts Payable | $ 5,396 | |||||||||
Jul 29 | Accounts Receivable | $ 11,979 | ||||||||
Sales | $ 11,979 | |||||||||
Part 2 | ||||||||||
Purchases | Cost of Goods Sold | Ending Inventory | ||||||||
Date | Unit | Unit Cost | Total Cost | Unit | Unit Cost | Total Cost | Unit | Unit Cost | Total Cost | |
Jul 1 | 224 | $ 36.00 | $ 8,064 | |||||||
Jul 13 | 152 | $ 35.50 | $ 152 | 224 | $ 36.00 | $ 8,064 | ||||
152 | $ 35.50 | $ 5,396 | ||||||||
Jul 29 | 224 | $ 36.00 | $ 8,064 | - | $ 36.00 | $ - | ||||
18 | $ 35.50 | $ 639 | 134 | $ 35.50 | $ 4,757 | |||||
Aug 3 | 112 | $ 34.50 | $ 3,864 | 134 | $ 35.50 | $ 4,757 | ||||
112 | $ 34.50 | $ 3,864 | ||||||||
Aug 16 | 204 | $ 32.50 | $ 6,630 | 134 | $ 35.50 | $ 4,757 | ||||
112 | $ 34.50 | $ 3,864 | ||||||||
204 | $ 32.50 | $ 6,630 | ||||||||
Sep 21 | 134 | $ 35.50 | $ 4,757 | 112 | $ 34.50 | $ 3,864 | ||||
204 | $ 32.50 | $ 6,630 | ||||||||
Cost of Godos Sold | 376 | $ 13,460 | ||||||||
Ending Inventory | 316 | $ 10,494 | ||||||||
Sales | $ 18,545 | |||||||||
(242*$49.5)+(134*$49) | ||||||||||
Less: COGS | $ (13,460) | |||||||||
Gross Profit | $ 5,085 | |||||||||
Part 3 | Gross profit will increase as COGS will be lower. | |||||||||
Since purchase cost is reducing with every purchase, and hence average cost per unit will be lower than previous purchase | ||||||||||
Part 4 | ||||||||||
Units | Cost | NRV | Lower | Diff | Total | |||||
112 | $ 34.50 | $ 33.00 | $ 33.00 | $ (1.50) | $ (168) | |||||
204 | $ 32.50 | $ 33.00 | $ 32.50 | $ 0.50 | $ 102 | |||||
$ (66) | ||||||||||
Dec 31 | Cost of Goods Sold | $ 66 | ||||||||
Allowance for write down of inventory to NRV | $ 66 | |||||||||
Part 5 | ||||||||||
Cost of Goods Sold | a | $ 13,460 | ||||||||
Beginning Inventory (224*$36) | $ 8,064 | |||||||||
Ending Inventory ($10,494-$66) | $ 10,428 | |||||||||
Average Inventory | b | $ 9,246 | ||||||||
Inventory Turnover Ratio | a/b | 1.46 |
LO7-17-2,74,7-5 Recording Inventory Transactions, Computing Ending Inventory and Cost of Sales, and Determining the...
2.75 LO71.7-2.74,75 74 Recording Inventory Transactions. Connutina Ending Inventor and Cost or Determining the Errects or LC&NRV Rule on the Inventory Turnover Chaiz Inc. specializes in importing furniture for commercial use es importing furniture for commercial use. Chaiz reported the following information all transactions are on account) for the quarter ending September Date Transaction Units Amount per Unit July 1 Inventory 224 $36.0 July 13 Purchase 152 35.5 July 29 Sale 242 49.5 August 3 Purchase 112 34.5 August 16...
LO7-3 AP7-2 11 16 Reporting the Effects of Inventory Costing Methods on Financial Statement Elements and Evaluating Inventory Management (P7-5) The following details were extracted on November 30, 2017, from the records of Seema Company for a specific product: Date Quantity Unit Cost Unit Sale Price Beginning inventory, January 1 300 $ 9 Purchase, February 10 400 10 Sale, April 7 300 $15 Purchase, August 20 300 Sale, November 29 350 On December 21, 2017, Seema sold 200 units to...
Begin by computing the cost of goods sold and cost of ending merchandise inventory using the FIFO inventory costing method. Enter the transactions in chronological order, calculating new inventory on hand balances after each transaction. Once all of the transactions have been entered into the perpetual record, calculate the quantity and total cost of merchandise inventory purchased, sold, and on hand at the end of the period. (Enter the oldest inventory layers first.) A Requirements X 1. 2. Compute cost...
Calculating Cost of Goods Available for Sale, Ending Inventory, Sales, Cost of Goods Sold, and Gross Profit under Periodic FIFO, LIFO, and Weighted Average Cost FIFO (PERIODIC) Unit Selling Price July 1 July 13 July 25 July 31 Beginning Inventory Purchase Sold Ending Inventory Units Unit Cost 40 $10 200 (100) 140 $14 Units Cost per Unit Total Beginning Inventory Purchases July 13 Goods Available for Sale Cost of Goods Sold Units from Beginning Inventory Units from July 13 Purchase...
Computing Cost of Sales and Ending Inventory Stocken Company has the following financial records for the current period: Units Unit cost Beginning inventory 100 $48 Purchases #1 650 44 #2 550 40 #3 200 38 Ending inventory at the end of this period is 350 units. Compute the ending inventory and the cost of goods sold for the current period using (a) first-in, first-out, (b) average cost, and (c) last-in, first-out. FIFO Average cost LIFO Cost of goods sold Answer...
Schedules of Expected Cash Collections and Disbursements; Income Statement; Balance Sheet [LO7-2, LO7-4, LO7-9, LO7-10] The following information applies to the questions displayed below Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company's balance sheet as of June 30th is shown below Beech Corporation Balance Sheet June 30 Assets $95,000 142,000 54,000 225,000 Cash Accounts receivable Inventory Plant and equipment, net of depreciation Total assets 516,000 Liabilities...
statement Elements un AP7-2 ecords of Seema Companyia Reporting the Effects of Inventory Costing Methods on Financial Stateme Evaluating Inventory Management (P7-5) The following details were extracted on November 30, 2017, from the records of a specific product: Date Quantity Unit Cost Unit Sale Price Beginning inventory, January 1 300 $ 9 Purchase, February 10 400 10 Sale, April 7 300 $15 Purchase, August 20 300 Sale, November 29 350 16 ca On December 21, 2017, Seema sold 200 units...
AP7-6B (Calculation of ending inventory and cost of goods sold—perpetual system) The following information relates to Good Kitchen Ltd.'s inventory transactions during the month of March. Cost/Unit $18.00 Amount $108,000 Mar. 1 Units 6,000 4,000 2,500 Beginning inventory Sale Purchase Purchase Sale Purchase Sale $20.00 $20.00 $ 50,000 $ 16,000 16 18 800 27 2,500 4,000 3,500 $25.00 $100,000 29 All of the units sold were priced at $65 per unit. HAPTER 7 Inventory Required a. Good Kitchen Ltd. uses...
Calculate ending inventory and cost of goods sold using Specific Identification, FIFO, LIFO, and Weighted Average. Required information Problem 6-2B Calculate ending inventory, cost of goods sold, sales revenue, and gross profit for four inventory methods (LO6-3, 6-4, 6-5) (The following information applies to the questions displayed below.] Pete's Tennis Shop has the following transactions related to its top-selling Wilson tennis racket for the month of August. Pete's Tennis Shop uses a periodic inventory system. Date Units Unit Cost Total...
Nadal Athletic has the following transactions related to its inventory for the month of August 2021: Date Transactions Units Cost per Unit Total Cost August 1 Beginning inventory 7 $ 130 $ 910 August 4 Sale ($150 each) 5 August 11 Purchase 9 120 1,080 August 13 Sale ($160 each) 7 August 20 Purchase 12 110 1,320 August 26 Sale ($170 each) 10 August 29 Purchase 12 100 1,200 $ 4,510 Required: Calculate ending inventory and cost of goods sold...