Question

In: Accounting

Determine the inventory balance Altira would report in its August 31, 2021, balance sheet and the cost of goods sold it would report in its August 2021 income statement using the Average cost method.

Aug.1Inventory on hand—2,800 units; cost $6.10 each.
8Purchased 14,000 units for $6.30 each.
14Sold 11,200 units for $12.80 each.
18Purchased 8,400 units for $6.40 each.
25Sold 10,200 units for $11.80 each.
28Purchased 4,800 units for $5.80 each.
31Inventory on hand—8,600 units.


Required:
Using calculations based on a periodic inventory system, determine the inventory balance Altira would report in its August 31, 2021, balance sheet and the cost of goods sold it would report in its August 2021 income statement using each of the following cost flow methods.

Determine the inventory balance Altira would report in its August 31, 2021, balance sheet and the cost of goods sold it would report in its August 2021 income statement using the Average cost method. (Round "Average Cost per Unit" to 2 decimal places.)

Average CostCost of Goods Available for SaleCost of Goods Sold - Average CostEnding Inventory - Average Cost
# of unitsUnit CostCost of Goods Available for Sale# of units soldAverage Cost per UnitCost of Goods Sold# of units in ending inventoryAverage Cost per unitEnding Inventory
Beginning Inventory2,800$6.10$17,080

Purchases:


August 814,000$6.3088,200
August 188,400$6.4053,760
August 284,800$5.8027,840





Total30,000
$186,880XX$0XX$0


Solutions

Expert Solution

--Requirement asked:

Average Cost Cost of Goods Available for Sale Cost of Goods Sold - Average Cost Ending Inventory - Average Cost
# of units Unit Cost Cost of Goods Available for Sale # of units sold Average Cost per Unit Cost of Goods Sold # of units in ending inventory Average Cost per unit Ending Inventory
Beginning Inventory 2,800 $                                                 6.10 $17,080
Purchases:
Aug-08 14,000 $                                                 6.30 $88,200
Aug-18 8,400 $                                                 6.40 $53,760
Aug-28 4,800 $                                                 5.80 $27,840
Total 30,000 $                                                 6.23 [186880/ 30000] $186,880 21400 $             6.23 $133,322 8,600 $                               6.23 $    53,578.00

Related Solutions

1) Prepare a Cost of Goods Manufactured Statement and determine Cost of Goods Sold using the...
1) Prepare a Cost of Goods Manufactured Statement and determine Cost of Goods Sold using the following information: IF YOU DO NOT LABEL YOUR ANSWERS, YOU WILL NOT RECEIVE CREDIT Beginning Raw Materials Inventory $1,000 Beginning Work-In-Process Inventory $2,000 Beginning Finished Goods Inventory $3,000 Ending Raw Materials Inventory $1,500 Ending Work-In-Process Inventory $2,500 Ending Finished Goods Inventory $3,500 Raw Materials Purchases $1,250 Direct Labor $750 Factory Overhead $750 2) Prepare journal entries, if necessary, for the following as of the...
Altira Corporation provides the following information related to its merchandise inventory during the month of August 2021:
Altira Corporation provides the following information related to its merchandise inventory during the month of August 2021:   Aug.1 Inventory on hand—2,700 units; cost $6.80 each. 8 Purchased 13,500 units for $6.20 each. 14 Sold 10,800 units for $12.70 each. 18 Purchased 8,100 units for $5.60 each. 25 Sold 9,800 units for $11.70 each. 28 Purchased 4,700 units for $5.80 each. 31 Inventory on hand—8,400 units.   Required:1. Using calculations based on a perpetual inventory system, determine the inventory balance...
The adjusted cost of goods sold that would appear on the income statement for July is?
Nizar Inc. has provided the following data for the month of July. The balance in the Finished Goods inventory account at the beginning of the month was Rs. 50,000 and at the end of the month was Rs. 40,000. The cost of goods manufactured for the month was Rs. 220,000. The actual manufacturing overhead cost incurred was 75,000 and the manufacturing overhead cost applied to Work in Process was Rs. 70,000. The adjusted cost of goods sold that would appear...
Calculate the cost of goods sold and ending inventory using weighted average. (Round the weighted average...
Calculate the cost of goods sold and ending inventory using weighted average. (Round the weighted average cost per unit to 2 decimal places, e.g. 5.25 and final answers to 0 decimal places, e.g. 5,250.) Purchases Cost of Goods Sold Balance Date Units Cost Total Units Cost Total Units Cost Total Units Total Cost WA Cost Per unit Apr-01 Beginning Inventory 26 $11 $286 26 $11 $286 Apr-15 52 $13 $676 $ $ 26 $286 52 $676 $ $ Apr-20 29...
what would be the effect on the Cost of goods sold, Ending inventory, net income and...
what would be the effect on the Cost of goods sold, Ending inventory, net income and income tax if the prices of inventory are decreasing (deflation). Using LIFO and FIFO
Income Statement Balance Sheet Sales $20,000,000 Assets: Cost of Goods Sold 8,000,000 Cash $5,000,000 12,000,000 Marketable...
Income Statement Balance Sheet Sales $20,000,000 Assets: Cost of Goods Sold 8,000,000 Cash $5,000,000 12,000,000 Marketable Securities 12,500,000 Selling and Administrative 1,600,000 Accounts Receivable, net 2,500,000 Depreciation 3,000,000 Inventory 30,000,000 EBIT 7,400,000 Prepaid Expenses 5,000,000 Interest 2,000,000 Plant & Equipment 30,000,000 5,400,000 Taxes (40%) 2,160,000 Total Assets 85,000,000 3,240,000 Common Stock Div. 600,000 Liabilities and Equity: $2,640,000 Accounts Payable $20,000,000 Notes Payable 5,000,000 Shares outstanding of common stock = 1,000,000 Accrued Expenses 5,000,000 Market price of common stock = $18...
Q4. The 2021 income statement of Adrian Express reports sales of $20,710,000, cost of goods sold...
Q4. The 2021 income statement of Adrian Express reports sales of $20,710,000, cost of goods sold of $12,600,000, and net income of $1,980,000. Balance sheet information is provided in the following table. ADRIAN EXPRESS Balance Sheets December 31, 2021 and 2020 2021 2020 Assets Current assets: Cash $ 840,000 $ 930,000 Accounts receivable 1,775,000 1,205,000 Inventory 2,245,000 1,675,000 Long-term assets 5,040,000 4,410,000 Total assets $ 9,900,000 $ 8,220,000 Liabilities and Stockholders' Equity Current liabilities $ 2,074,000 $ 1,844,000 Long-term liabilities...
Calculate the cost of goods sold and the cost of ending inventory using the FIFO, LIFO, and average cost methods.
Inventory Costing Methods: Periodic Inventory Systems. (Appendix 6B)Tyler Company has the following information related to purchases and sales of one of its inventory items.DateDescriptionUnits Purchased at CostUnits Sold at RetailSept. 1Beginning inventory20 units @ $510Purchase30 units @ $820Sales40 units @ $1525Purchase25 units at $10Assume that the company uses the periodic inventory system.Required:Calculate the cost of goods sold and the cost of ending inventory using the FIFO, LIFO, and average cost methods. (Note: Use four decimal places for per-unit calculations and...
Determine the costs assigned to ending inventory and to cost of goods sold using FIFO. Perpetual...
Determine the costs assigned to ending inventory and to cost of goods sold using FIFO. Perpetual FIFO: Goods Purchased Cost of Goods Sold Inventory Balance Date # of units Cost per unit # of units sold Cost per unit Cost of Goods Sold # of units Cost per unit Inventory Balance January 1 290 @ $13.60 = $3,944.00 January 10 260 @ $13.60 = $3,536.00 30 @ $13.60 = $408.00 March 14 500 @ $18.60 30 @ $13.60 = $408.00...
How would this transaction be reflected on the income statement and balance sheet on December 31?
Chris Gayle, a lawyer, received $72,000 on October 1 to represent a client in real estate negotiations over the next 12 months.Journal Entries: October 1st $72,000 & December 31st $18,000 (Already solved)How would this transaction be reflected on the income statement and balance sheet on December 31?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT