Calculate the CLOSING INVENTORY and the COST OF GOODS SOLD using the FIFO, LIFO and AVCO...
- Calculate the CLOSING INVENTORY and the COST OF GOODS SOLD using the FIFO, LIFO and AVCO methods based on the following information about purchases and sales throughout the year (assuming that the opening inventory has been zero):
January 500 items at £65 each as opening inventory.
March Bought 1,200 items at £70 each.
May Sold 1,000 items at £100 each.
September Bought 450 items at £80 each.
November Sold 750 items at £110 each.
- Total rent payable for the year was £15,000, but the business paid $18,000 for the rent by the end of the year. Has there been accruals or prepayments? How much? Is this an Asset or a Liability?
- Total salaries payable for the year was £28,000, but the business paid $25,000 by the end of the year. Has there been accruals or prepayments? How much? Is this an Asset or a Liability?
- A van was purchased at £14,000 at the beginning of 2017. It is estimated to have a useful life of 6 years, after which it will be sold for an estimated value of £2,000. How much is the 1st year depreciation based on (1) straight line method, and (2) reducing balance method with 25% as the annual depreciation percentage? How much is the profit/loss from sales of the van if it is sold in the middle of 2019, i.e. after being depreciated for 2 periods, at the price of £11,000, and under each method separately?
Homework Answers
Please refer the solution provided. For any Queries please comment. All the part have been solved. If any calculation are not clear please comment we will surely help you with the same. Thank you!!!
Add Answer to:
Calculate the CLOSING INVENTORY and the COST OF GOODS SOLD
using the FIFO, LIFO and AVCO...
Lea E6-19 Comparing amounts for cost of goods sold, ending inventory, and gross profit-FIFO and LIFO...
Lea E6-19 Comparing amounts for cost of goods sold, ending inventory, and gross profit-FIFO and LIFO Assume that Toys Galore store bought and sold a line of dolls during December as follows: Dec. 1 Beginning merchandise inventory 8 Sale 14 Purchase 21 Sale 13 units @ $ 9 each 8 units @ $ 22 each 16 units @ $ 14 each 14 units @ $ 22 each Requirements 1. Compute the cost of goods sold, cost of ending merchandise inventory,...
Calculate ending inventory and cost of goods sold using Specific Identification, FIFO, LIFO, and Weighted Average....
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...
1. Calculate the ending inventory and cost of goods sold for January using the FIFO and...
1. Calculate the ending inventory and cost of goods sold for January using the FIFO and perpetual method: #units Costunit TotalCOGS #units Costunit Total inventory Date 01/01/20 Beginning inventory 01/20/20 Sold 20 units 15 40 100.00 105.00 1,500.00 4,200.00 5,700.00 55 - 01/25/20 Purchased 30 units @ $107.50 01/31/20 Sold 32 units Inventory COGS 2. Calculate the ending inventory and cost of goods sold for January using the LIFO and perpetual method: #units Costunit Total COGS #units Costunit Total inventory...
1. Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO, and...
1. Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO, and Weighted Average Cost methods X FILE 5.a. HOME % Calibri INSERT PAGE LAYOUT Inventory costing methods - Excel FORMULAS DATA REVIEW ? x VIEW - 6 Sign In Paste B IU - -A- Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard D66 1 Better Bottles, Inc., uses a periodic inventory system and has the following information available: of Units...
Determine cost of goods sold and ending inventory using FIFO, LIFO, and average-cost with analysis. ...
Determine cost of goods sold and ending inventory using FIFO,
LIFO, and average-cost with analysis.
Financial Accounting, 8th Edition by Weygandt, Kieso, and
Kimmel
Primer on Using Microsoft Excel in Accounting by Rex A
Schildhouse
Problem: Doom's Day Distribution markets CDs of the performing
artist Marilynn. At...
Problem 6-5A Calculate ending inventory and cost of goods sold using FIFO and LIFO and adjust...
Problem 6-5A Calculate ending inventory and cost of goods sold using FIFO and LIFO and adjust inventory using lower of cost and net realizable value (LO6-3, 6-6) [The following information applies to the questions displayed below.] For the current year, Parker Games has the following inventory transactions related to its traditional board games. Parker Games uses a periodic inventory system. Date Transaction Units Unit Cost Total Cost Jan. 1 Beginning inventory 114 $ 19 $ 2,166 Mar. 12 Purchase 73...
Calculate the cost of goods sold and ending inventory using the FIFO cost method. Calculate the...
Calculate the cost of goods sold and ending inventory using the
FIFO cost method.
Calculate the cost of goods sold and ending inventory using the
average cost method.
Blue Limited uses a perpetual inventory system. The inventory records show the following data for its first month of operations: Date Explanation Units Unit Cost Total Cost Balance in Units Aug. 2 Purchases 249 $69 $17,181 249 3 Purchases 506 96 48,576 755 Sales (275) 480 15 Purchases 926 121 112,046 1,406...
E6.6 Compute inventory and cost of goods sold using FIFO and LIFO. (LO 2) Ballas Co....
E6.6 Compute inventory and cost of goods sold using FIFO and LIFO. (LO 2) Ballas Co. uses a periodic inventory system. Its records show the following for the month of May, in which 68 units were sold Units Unit Cost May 1 15 Inventory Purchases Total Cost $240 275 420 24 Purchases Totals 90 $935 Instructions Compute the ending inventory at May 31 and cost of goods sold using the FIFO and LIFO methods. Prove the amount allocated to cost...
2. Using LIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit. LIFO...
During the year, TRC Corporation has the following inventory transactions. For the entire year, the company sells 400 units of inventory for $50 each. Required: 1. Using FIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit. 2. Using LIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit. 3. Using weighted-average cost, calculate ending inventory, cost of goods sold, sales revenue, and gross profit. (Round "Average Cost per unit" to 4 decimal places and all other answers to...
A company has sales of $722,200 and cost of goods sold of $289,200. Its gross profit...
A company has sales of $722,200 and cost of goods sold of $289,200. Its gross profit (loss) equals:Multiple Choice $1,011,400. $289,200. $722,200. $433,000. $(433,000). A company purchased a new delivery van at a cost of $62,000 on July 1. The delivery van is estimated to have a useful life of 5 years and a salvage value of $5,000. The company uses the straight-line method of depreciation. How much depreciation expense will be recorded for the van during the first year...
Lea E6-19 Comparing amounts for cost of goods sold, ending inventory, and gross profit-FIFO and LIFO Assume that Toys Galore store bought and sold a line of dolls during December as follows: Dec. 1 Beginning merchandise inventory 8 Sale 14 Purchase 21 Sale 13 units @ $ 9 each 8 units @ $ 22 each 16 units @ $ 14 each 14 units @ $ 22 each Requirements 1. Compute the cost of goods sold, cost of ending merchandise inventory,...
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...
1. Calculate the ending inventory and cost of goods sold for January using the FIFO and perpetual method: #units Costunit TotalCOGS #units Costunit Total inventory Date 01/01/20 Beginning inventory 01/20/20 Sold 20 units 15 40 100.00 105.00 1,500.00 4,200.00 5,700.00 55 - 01/25/20 Purchased 30 units @ $107.50 01/31/20 Sold 32 units Inventory COGS 2. Calculate the ending inventory and cost of goods sold for January using the LIFO and perpetual method: #units Costunit Total COGS #units Costunit Total inventory...
1. Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO, and Weighted Average Cost methods X FILE 5.a. HOME % Calibri INSERT PAGE LAYOUT Inventory costing methods - Excel FORMULAS DATA REVIEW ? x VIEW - 6 Sign In Paste B IU - -A- Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard D66 1 Better Bottles, Inc., uses a periodic inventory system and has the following information available: of Units...
Determine cost of goods sold and ending inventory using FIFO,
LIFO, and average-cost with analysis.
Financial Accounting, 8th Edition by Weygandt, Kieso, and
Kimmel
Primer on Using Microsoft Excel in Accounting by Rex A
Schildhouse
Problem: Doom's Day Distribution markets CDs of the performing
artist Marilynn. At...
Calculate the cost of goods sold and ending inventory using the
FIFO cost method.
Calculate the cost of goods sold and ending inventory using the
average cost method.
Blue Limited uses a perpetual inventory system. The inventory records show the following data for its first month of operations: Date Explanation Units Unit Cost Total Cost Balance in Units Aug. 2 Purchases 249 $69 $17,181 249 3 Purchases 506 96 48,576 755 Sales (275) 480 15 Purchases 926 121 112,046 1,406...
E6.6 Compute inventory and cost of goods sold using FIFO and LIFO. (LO 2) Ballas Co. uses a periodic inventory system. Its records show the following for the month of May, in which 68 units were sold Units Unit Cost May 1 15 Inventory Purchases Total Cost $240 275 420 24 Purchases Totals 90 $935 Instructions Compute the ending inventory at May 31 and cost of goods sold using the FIFO and LIFO methods. Prove the amount allocated to cost...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago