**Inventory Management Analysis for Aircard Corporation**Aircard Corporation tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each period as if it uses a periodic inventory system. The following are the transactions for the month of July:| Date | Transaction | Units | Unit Cost ||---------|-------------------------|--------|-----------|| July 1 | Beginning Inventory | 2,000 | $25 || July 5 | Sold | 1,000 | || July 13 | Purchased | 6,000 | $29 || July 17 | Sold | 3,000 | || July 25 | Purchased | 8,000 | $31 || July 27 | Sold | 5,000 | |**Objective:**Calculate the cost of goods available for sale, ending inventory, and cost of goods sold if Aircard uses:- (a) FIFO (First-In, First-Out)- (b) LIFO (Last-In, First-Out)- (c) Weighted Average Cost**Instructions:**Round "Cost per Unit" to 2 decimal places.**Table Completion:**| | FIFO | LIFO | Weighted Average Cost ||---------------------------|------|------|-----------------------|| Cost of Goods Available for Sale | | | || Ending Inventory | | | || Cost of Goods Sold | | | |Fill in the table by calculating the respective values using the inventory cost methods specified.

Answered: Alrcard Corporation tracks the number…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each month, as if it uses a periodic inventory system. Assume Oahu Kiki's records show the following for the month of January. Sales totaled 260 units. Beginning Inventory Purchase Purchase Date January 1 January 15 January 24 Units 100 360 240 Unit Cost $ 75 95 115 Total Cost $ 7,500 34,200 27,600 Required: 1. Calculate the number and cost of goods available for sale. 2. Calculate the number of units in ending inventory. 3. Calculate the cost of ending inventory and cost of goods sold using the (a) FIFO, (b) LIFO, and (c) weighted average cost methods.
Aircard Corporation tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each period as if it uses a perpetual inventory system. The following are the transactions for the month of July. July 1 July 5 Units Unit Cost Beginning Inventory 2,700 $ 47 Sold 1,350 July 13 Purchased 6,700 51 July 17 Sold 3,700 July 25 July 27 Purchased Sold 8,700 57 5,700 Calculate the cost of ending inventory and cost of goods sold assuming a perpetual inventory system is used in combination with (a) FIFO and (b) LIFO. Complete this question by entering your answers in the tabs below. Required A Required B Calculate the cost of ending inventory and cost of goods sold assuming a perpetual inventory system is used in combination with FIFO. Beginning Inventory Purchases July 13 FIFO (Perpetual) Units Cost per Unit Total $ 0 July 25 Total Purchases Goods Available for Sale Cost of Goods Sold Units from Beginning Inventory Units…
Akira Company had the following transactions for the month. Numberof Units TotalCost Beginning inventory 140 $1,400 Purchased Mar. 31 190 2,280 Purchased Oct. 15 160 2,400 Total goods available for sale 490 6,080 Ending inventory 70 ? Calculate the gross margin for the period for each of the following cost allocation methods, using periodic inventory updating. Assume that all units were sold for $29 each. Round your intermediate calculations to 2 decimal places and final answers to the nearest dollar amount. Gross Margin A. First-in, First-out (FIFO) $fill in the blank 1 B. Last-in, First-out (LIFO) $fill in the blank 2 C. Weighted Average (AVG) $fill in the blank 3
Shellhammer Company's inventory and purchases accounts show the following data for the month of September: Inventory, Purchases: September 1 September 8 September 18 Ending inventory Cost of goods sold $ tA Units $ 100 450 350 Unit Cost A physical inventory on September 30 shows 200 units on hand. Calculate the cost of ending inventory and cost of goods sold if the company uses the FIFO method and a periodic inventory system. $3.34 3.50 3.70 A
Haynes Company uses the perpetual inventory system. The following information is available for the month of March. March 1 Beginning Inventory 10 units at $2 for $20, March 4 Sold 8 units, March 22 Purchased 50 units at $4 for $200, March 26 Sold 48 units. If Haynes Company uses the LIFO inventory costing method, what is the Cost of Goods Sold for March? A. $212 B. $208 C. $204 D. $560
Bridgeport Inc. uses a perpetual inventory system. Its records show the following for the month of May. Date May May May May 1 Inventory Purchase 15 18 Unit Explanation Units Cost 24 Sale Purchase Total -29 26 (42 ) 40 53 $10 11 12 Total Cost $290 286 480 $1,056
Garrett Company has the following transactions during the months of April and May: Date Transaction Units Cost/Unit April 1 Balance 300 17 Purchase 200 $5.10 25 Sale 150 28 Purchase 100 5.80 May 5 Purchase 250 5.10 18 Sale 300 22 Sale 50 The cost of the inventory on April 1 is $5, $4, and $2 per unit, respectively, under the FIFO, average, and LIFO cost flow assumptions. Required: 1. Compute the inventories at the end of each month and the cost of goods sold for each month for the following alternatives: FIFO periodic Cost of Goods Sold Ending Inventory April $ ____________ $ ____________ May $ ____________ $ ____________ FIFO perpetual Cost of Goods Sold Ending Inventory April $ ____________ $ ____________ May $ ____________ $ ____________ LIFO periodic Cost of Goods Sold Ending Inventory April $ ____________ $ ____________ May $ ____________ $ ____________ LIFO…
The following units of a particular item were available for sale during the calendar year: Jan. 1 3,800 units at $40 Apr. 19 2,600 units June 30 4,400 units at $45 Sept. 2 5,200 units Nov. 15 2,100 units at $48 The firm maintains a perpetual inventory system. Determine the cost of goods sold for each sale and the inventory balance after each sale, assuming the first-in, first-out method. Present the data in the form illustrated in Exhibit 3. Under FIFO, if units are in inventory at two different costs, enter the units with the LOWER unit cost first in the Cost of Goods Sold Unit Cost column and in the Inventory Unit Cost column. Date Jan. 1 Apr. 19 June 30 Sept. 2 Nov. 15 Dec. 31 Inventory Sale Purchase Sale Purchase Quantity Balances Purchases Unit Cost Total Cost Schedule of Cost of Goods Sold FIFO Method Quantity Cost of Goods Sold Unit Cost Total Cost Quantity Inventory Unit Cost $ Total Cost
Cullumber Company uses a perpetual inventory system and reports the following for the month of June. Date June 1 12 23 30 (a1) Explanation Units June 1 Inventory Purchase Purchase June 12 Inventory June 15 June 23 June 27 $ $ $ $ $ 130 Calculate the weighted-average cost per unit, using a perpetual inventory system. Assume a sale of 400 units occurred on June 15 for a selling price of $7 and a sale of 50 units on June 27 for $8. (Round intermediate calculations to O decimal places, e.g. 152 and final answers to 3 decimal places, e.g. 5.125.) eTextbook and Media Save for Later 370- 200 250 Unit Cost $5 6 7 Total Cost $650 2,220 1,400 Attempts: 0 of 10 used Submit Answer
A company reports the following beginning inventory and two purchases for the month of January. On January 26, the company sells 310 units. Ending inventory at January 31 totals 130 units. Units Unit Cost Beginning inventory on January 1 280 $ 2.60 Purchase on January 9 60 2.80 Purchase on January 25 100 2.94 Required:Assume the perpetual inventory system is used. Determine the costs assigned to ending inventory when costs are assigned based on LIFO.
Check my work Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each month, as if it uses a periodic inventory system. Assume Oahu Kiki's records show the following for the month of January. Sales totaled 250 units. Beginning Inventory Date January 1 Units Unit Cost 100 $ 80 Total $ 8, Purchase January 15 450 90 40, Purchase January 24 200 110 22, Required: 1. Calculate the number and cost of goods available for sale. 2. Calculate the number of units in ending inventory. 3. Calculate the cost of ending inventory and cost of goods sold using the (a) FIFO, (b) LIFO, and (c) weighted average cost methods. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Calculate the cost of ending inventory and cost of goods sold using the (a) FIFO, (b) methods. FIFO LIFO Cost of Ending Inventory Cost of Goods Sold Weighted Average Cost
A company has the following purchases and sales during October. Using the FIFO periodic inventory method, what is the value of the inventory on October 15 after the sale? Date Activities Units Acquired at Cost Units Sold at Retail October 1 Beginning inventory 15 units @ $32 = $480 October 5 Purchase 10 units @ $33 = $330 October 12 Purchase 20 units @ $34 = $680 October 15 Sales 30 units sold

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS