Question

In: Accounting

Exercise 5-3A Allocating product cost between cost of goods sold and ending inventory: multiple purchases LO...

Exercise 5-3A Allocating product cost between cost of goods sold and ending inventory: multiple purchases LO 5-1

Cortez Company sells chairs that are used at computer stations. Its beginning inventory of chairs was 120 units at $55 per unit. During the year, Cortez made two batch purchases of this chair. The first was a 142-unit purchase at $62 per unit; the second was a 220-unit purchase at $66 per unit. During the period, it sold 286 chairs.

Required
Determine the amount of product costs that would be allocated to cost of goods sold and ending inventory, assuming that Cortez uses

a.
FIFO:



b. LIFO:
  

c. Weighted average: (Round your intermediate calculations and final answers to the nearest whole dollar amount.)

a. FIFO:
  

Solutions

Expert Solution

Requirement a
Using FIFO
Units Unit price $ Calculation
Beginning Inventory 120 $55     6,600
First Purchases 142 62     8,804
Second Purchases 220 66 14,520
Total cost of goods available for sale 482 29,924
Cost of goods sold 286 16,988 (120*55)+(142*62)+(24*66)
Ending Inventory 196 12,936 (196*66)
Requirement b
Using LIFO
Units Unit price $ Calculation
Beginning Inventory 120 $55     6,600
First Purchases 142 62     8,804
Second Purchases 220 66 14,520
Total cost of goods available for sale 482 29,924
Cost of goods sold 286 18,612 (220*66)+(66*62)
Ending Inventory 196 11,312 (76*62)+(120*55)
Requirement c
Using Weighted average
Units Unit price $ Calculation
Beginning Inventory 120 $55     6,600
First Purchases 142 62     8,804
Second Purchases 220 66 14,520
Total cost of goods available for sale 482      62 29,924 (29,924/482)
Cost of goods sold 286 17,732 (286*62)
Ending Inventory 196 12,192 (29,924-17,732

Related Solutions

Brief Exercise 6-5 Calculate ending inventory and cost of goods sold using FIFO (LO6-3) During the...
Brief Exercise 6-5 Calculate ending inventory and cost of goods sold using FIFO (LO6-3) During the year, Wright Company sells 440 remote-control airplanes for $110 each. The company has the following inventory purchase transactions for the year.   Date   Transaction Number of Units Unit Cost Total Cost   Jan. 1   Beginning inventory 60        $76    $ 4,560   May 5   Purchase 220        79    17,380   Nov. 3   Purchase 170        84    14,280 450        $ 36,220    Calculate ending inventory and cost of...
Exercise 20-28A Merchandising: Computing budgeted purchases and cost of goods sold LO P4 Ahmed Company purchases...
Exercise 20-28A Merchandising: Computing budgeted purchases and cost of goods sold LO P4 Ahmed Company purchases all merchandise on credit. It recently budgeted the month-end accounts payable balances and merchandise inventory balances below. Cash payments on accounts payable during each month are expected to be May, $1,100,000; June, $1,450,000; July, $1,350,000; and August, $1,200,000 Accounts Payable Merchandise Inventory May 31 $ 190,000 $ 270,000 June 30 170,000 200,000 July 31 400,000 400,000 August 31 110,000 320,000
5.Beakman, Inc. has ending inventory of $400,000, and a cost of goods sold for the year...
5.Beakman, Inc. has ending inventory of $400,000, and a cost of goods sold for the year ended $3,800,000. What is the inventory turnover? The days’ sales in inventory? (10 Points) (Use Excel and Excel Formulas)
From the following, calculate the cost of ending inventory and cost of goods sold for the...
From the following, calculate the cost of ending inventory and cost of goods sold for the weighted-average method, ending inventory is 56 units. (Round your intermediate calculations and final answers to the nearest cent.) Beginning inventory and purchases Units Unit cost January 1 6 $ 2.70 April 10 9 3.20 May 15 13 3.70 July 22 14 3.95 August 19 19 4.70 September 30 19 4.90 November 10 33 5.10 December 15 15 5.50 cost of ending inventory? Cost of...
From the following, calculate the cost of ending inventory and cost of goods sold for the...
From the following, calculate the cost of ending inventory and cost of goods sold for the LIFO method, ending inventory is 54 units. (Round your answers to the nearest cent.) Beginning inventory and purchases Units Unit cost January 1 6 $ 1.00 April 10 9 1.50 May 15 13 2.00 July 22 14 2.25 August 19 19 3.00 September 30 19 3.20 November 10 33 3.40 December 15 15 3.80 Cost of ending inventory $ Cost of goods sold $
Calculate the cost of goods sold and the cost of the ending inventory using the LIFO...
Calculate the cost of goods sold and the cost of the ending inventory using the LIFO periodic cost flow assumption. Sales 97 units at $ 18 per unit Beginning inventory 88 units at $ 6 per unit Purchases 58 units at $ 10 per unit Calculate the cost of goods sold using the LIFO periodic cost flow assumption. Units x Cost per Unit = Total Cost Units from beginning inventory x = Units from purchase x = Cost of Goods...
Compute ending inventory, cost of goods sold, and gross profit.
My question: Assume the company uses three inventory pools instead of one. Compute ending inventory, cost of goods sold, and gross profit. (Round price index to 2 decimal places, e.g. 1.45 and final answers to 0 decimal places, e.g. 6,548.)   William’s Televisions produces television sets in three categories: portable, midsize, and flat-screen. On January 1, 2020, William adopted dollar-value LIFO and decided to use a single inventory pool. The company’s January 1 inventory consists of: Category   Quantity  ...
Cost of Goods Sold and Ending Inventory for each of the following methods:
Calculate the following:Cost of Goods Sold and Ending Inventory for each of the following methods:a.    FIFOb.    LIFOc.     Weighted Average  Units                    Unit Cost7/1      Beginning Inventory 100 107/5      Purchases                                                     500 157/15    Sales                                                              400                             7/20    Purchases                                                     200 20
Identify four methods of assigning a cost to ending inventory and cost of goods sold and...
Identify four methods of assigning a cost to ending inventory and cost of goods sold and briefly explain the difference in the methods. It’s common in the electronics industry for unit costs of raw materials inventories to decline over time. In this environment, explain the difference between LIFO and FIFO, in terms of the effect on income and financial position. Assume that inventory quantities remain the same for the period. Explain why proponents of LIFO argue that it provides a...
Exercise 14-15 Schedule of cost of goods manufactured and cost of goods sold LO P1, P2...
Exercise 14-15 Schedule of cost of goods manufactured and cost of goods sold LO P1, P2 Beck Manufacturing reports the information below for 2017. Raw Materials Inventory Begin. Inv. 12,500 Purchases 55,000 Avail. for use 67,500 DM used 49,000 End. Inv. 18,500 Work in Process Inventory Begin. Inv. 17,400 DM used 49,000 Direct labor 31,700 Overhead 61,000 Avail. for mfg. 159,100 Cost of goods mfg 146,300 End. Inv. 12,800 Finished Goods Inventory Begin. Inv. 21,400 Cost of goods mfg 146,300...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT