|
|
|
1 | Price Index | 1.2156 | |||||||
Category | Quantity | Quantity Purchased |
Quantity Sold |
Ending Inventory | Cost per unit as on Jan 1 | Closing inventory value at base cost | Cost per unit as on Dec 31 | Closing inventory value at recent cost | |
Portable | 7,800 | 19,500 | 18,200 | 9,100 | $100 | $910,000 | $110 | $1,001,000 | |
Midsize | 10,400 | 26,000 | 31,200 | 5,200 | $250 | $1,300,000 | $300 | $1,560,000 | |
Flat-screen | 3,900 | 13,000 | 7,800 | 9,100 | $400 | $3,640,000 | $500 | $4,550,000 | |
$5,850,000 | $7,111,000 | ||||||||
Ending Inventory (Units) = Opening inventory + Purchase - Sold | |||||||||
Price Index = ending inventory at current cost/ending inventory at base cost | |||||||||
Price Index = | 1.2156 | ||||||||
2 | Ending inventory | $6,046,196 | |||||||
base layer ($4,940,000 ) *1 | $4,940,000 | ||||||||
Incremental layer ($5,850,000 - $4,940,000)*1.2156 | $1,106,196 | ||||||||
Ending inventory | $6,046,196 | ||||||||
Cost of goods sold | $15,338,804 | ||||||||
Opening | $4,940,000 | [(7,800*$100) + (10,400*$250) + (3,900*$400)] | |||||||
Purchase | $16,445,000 | [(19,500*$110)+ (26,000*$300) + (13,000*$500)] | |||||||
Less: Ending | $6,046,196 | ||||||||
$15,338,804 | |||||||||
Gross profit | $4,551,196 | ||||||||
Sales | $19,890,000 | [(18,200*$150) + (31,200*$400) + (7,800*$600)] | |||||||
COGS | $15,338,804 | ||||||||
Gross Profit | $4,551,196 | ||||||||
Problem 8-08 (Part Level Submission) Charles’s Televisions produces television sets in three categories: portable, midsize, and...
Problem 8-08 (Part Level Submission) Charles’s Televisions produces television sets in three categories: portable, midsize, and flat-screen. On January 1, 2020, Charles adopted dollar-value LIFO and decided to use a single inventory pool. The company’s January 1 inventory consists of: Category Quantity Cost per Unit Total Cost Portable 7,800 $100 $ 780,000 Midsize 10,400 250 2,600,000 Flat-screen 3,900 400 1,560,000 22,100 $4,940,000 During 2020, the company had the following purchases and sales. Category Quantity Purchased Cost per Unit Quantity Sold...
Charles’s Televisions produces television sets in three categories: portable, midsize, and flat-screen. On January 1, 2020, Charles adopted dollar-value LIFO and decided to use a single inventory pool. The company’s January 1 inventory consists of: Category Quantity Cost per Unit Total Cost Portable 7,800 $100 $ 780,000 Midsize 10,400 250 2,600,000 Flat-screen 3,900 400 1,560,000 22,100 $4,940,000 During 2020, the company had the following purchases and sales. Category Quantity Purchased Cost per Unit Quantity Sold Selling Price per Unit Portable...
Problem 8-08 (Part Level Submission) Brian’s Televisions produces television sets in three categories: portable, midsize, and flat-screen. On January 1, 2020, Brian adopted dollar-value LIFO and decided to use a single inventory pool. The company’s January 1 inventory consists of: Category Quantity Cost per Unit Total Cost Portable 15,000 $100 $ 1,500,000 Midsize 20,000 250 5,000,000 Flat-screen 7,500 400 3,000,000 42,500 $9,500,000 During 2020, the company had the following purchases and sales. Category Quantity Purchased Cost per Unit Quantity Sold...
Problem 8-8 Morgan's Televisions produces television sets in three categories: portable, midsize, and flat-screen. On January 1, 2017, Morgan adopted dollar-value LIFO and decided to une a single inventory pool. The company's January 1 inventory consists of: Category Quantity Cost per Unit Total Cost Portable Midsize Flat-screen 5,700 8,100 3.100 16,900 115 655,500 288 2,332,800 460 1,426,000 $4,414,300 During 2017, the company had the following purchases and sales Quantity Quantity Selling Price Category Purchased Cost per Unit Sold Portable Midsize...
Newman’s Televisions produces television sets in three categories: portable, midsize, and flat-screen. On January 1, 2017, Newman adopted dollar-value LIFO and decided to use a single inventory pool. The company’s January 1 inventory consists of: Category Quantity Cost per Unit Total Cost Portable 6,000 $132 $ 792,000 Midsize 8,400 330 2,772,000 Flat-screen 2,900 528 1,531,200 17,300 $5,095,200 During 2017, the company had the following purchases and sales. Category Quantity Purchased Cost per Unit Quantity Sold Selling Price per Unit Portable...
Company A's Televisions produces television sets in three categories: portable, midsize, and flat-screen. On January 1, 2017, Company A adopted dollar-value LIFO and decided to use a single inventory pool. The company’s January 1 inventory consists of: Category Quantity Cost per Unit Total Cost Portable 5,800 $120 $ 696,000 Midsize 8,100 300 2,430,000 Flat-screen 3,200 480 1,536,000 17,100 $4,662,000 During 2017, the company had the following purchases and sales. Category Quantity Purchased Cost per Unit Quantity Sold Selling Price per...
Problem 6-05A a1-a3, b (Part Level Submission) (Video) You are provided with the following information for Larkspur Inc. for the month ended June 30, 2020. Larkspur uses the periodic method for inventory. Date Description Quantity Unit Cost or Selling Price June 1 Beginning inventory 45 $42 June 4 Purchase 136 46 June 10 Sale 113 69 June 11 Sale return 15 69 June 18 Purchase 54 48 June 18 Purchase return 12 48 June 25 Sale 68 74 June 28...
Problem 8-05 (Part Level Submission) Some of the information found on a detail inventory card for Coronado Inc. for the first month of operations is as follows. Received No. of Units 1,400 Date Issued, No. of Units Unit Cost $4.02 January 2 900 800 4.29 Balance, No. of Units 1,400 500 1,300 600 1,300 200 1,700 700 2,500 1,000 1,200 700 500 1,100 4.42 1,500 4.56 1,000 1,800 4.69 1,500 (b) Your answer is partially correct. Try again. If the...
Problem 6-5A (Part Level Submission) You are provided with the following information for Koetteritz Inc. for the month ended June 30, 2017. Koetteritz uses the periodic method for inventory. Unit Cost or Selling Price Date Quantity $40 June 1 June 4 June 10 June 11 June 18 June 18 June 25 June 28 Description Beginning inventory Purchase Sale Sale return Purchase Purchase return Sale Purchase (a ) Your answer is partially correct. Try again. Calculate ending inventory, cost of goods...
Problem 6-08A a1-a2 (Part Level Submission) Bonita Inc. is a retailer operating in British Columbia. Bonita uses the perpetual inventory method. All sales returns from customers result in the goods being returned to inventory; the inventory is not damaged. Assume that there are no credit transactions; all amounts are settled in cash. You are provided with the following information for Bonita Inc. for the month of January 2020. Date Description Quantity Unit Cost or Selling Price January 1 Beginning inventory...