Merchandise Inventory

Horngren'S Financial And Managerial Accounting ยท 135 exercises

31PGA_3

Empire State Carpets’s books show the following data. In early 2020, auditors found that the ending merchandise inventory for 2017 was understated by \(8,000 and that the ending merchandise inventory for 2019 was overstated by \)9,000. The ending merchandise inventory at December 31, 2018, was correct.

 

2019

2018

2017

Net Sales Revenue

\(     220,000

\)    162,000

\(   176,000

Cost of Goods Sold:

 

 

 

         Beginning Merchandise Inventory

\)22,000

\(29,000

\)46,000

         Net cost of purchase

132,000

  90,000

  76,000

         Cost of goods available for sale

154,000

119,000

122,000

         Less: Ending Merchandise Inventory

  32,000 

  22,000

  29,000

         Cost of goods sold

       122,000

         97,000 

       93,000

Gross Profit

         98,000

         65,000

       83,000

Operating Expenses

         72,000

         38,000

       48,000

Net Income

      \( 26,000

      \) 27,000

    $ 35,000

 

Requirements

3. Compute the inventory turnover and days’ sales in inventory using the corrected income statements for the three years. (Round all numbers to two decimals.)

3 step solution

Q32PGA_1

Futuristic Electronic Center began October with 65 units of merchandise inventory that cost \(82 each. During October, the store made the following purchases:

Oct. 3                 25 units @ \) 90 each

12                       30 units @ \( 90 each

18                       35 units @ \) 96 each

 

Futuristic uses the periodic inventory system, and the physical count at October 31 indicates that 80 units of merchandise inventory are on hand.

 

Requirements

1. Determine the ending merchandise inventory and cost of goods sold amounts for the October financial statements using the FIFO, LIFO, and weighted-average inventory costing methods.

3 step solution

Q32PGA_2

Futuristic Electronic Center began October with 65 units of merchandise inventory that cost \(82 each. During October, the store made the following purchases:

Oct. 3                 25 units @ \) 90 each

12                       30 units @ \( 90 each

18                       35 units @ \) 96 each

 

Futuristic uses the periodic inventory system, and the physical count at October 31 indicates that 80 units of merchandise inventory are on hand.

 

Requirements

2. Net sales revenue for October totaled $28,000. Compute Futuristic’s gross profit for October using each method.

3 step solution

Q32PGA_3

Futuristic Electronic Center began October with 65 units of merchandise inventory that cost \(82 each. During October, the store made the following purchases:

Oct. 3                 25 units @ \) 90 each

12                       30 units @ \( 90 each

18                       35 units @ \) 96 each

 

Futuristic uses the periodic inventory system, and the physical count at October 31 indicates that 80 units of merchandise inventory are on hand.

 

Requirements

3. Which method will result in the lowest income taxes for Futuristic? Why? Which method will result in the highest net income for Futuristic? Why?

2 step solution

33PGB_1

Exercise World began January with merchandise inventory of 90 crates of vitamins that cost a total of \(5,850. During the month, Exercise World purchased and soldmerchandise on account as follows:

 

Jan. 2 Purchase 130 crates @ \) 76 each

5 Sale 140 crates @ \( 100 each

16 Purchase 170 crates @ \) 86 each

27 Sale 180 crates @ $ 104 each

 

Requirements

1. Prepare a perpetual inventory record, using the FIFO inventory costing method,and determine the company’s cost of goods sold, ending merchandise inventory,and gross profit.

2 step solution

33PGB_2

Exercise World began January with merchandise inventory of 90 crates of vitamins that cost a total of \(5,850. During the month, Exercise World purchased and soldmerchandise on account as follows:

 

Jan. 2 Purchase 130 crates @ \) 76 each

5 Sale 140 crates @ \( 100 each

16 Purchase 170 crates @ \) 86 each

27 Sale 180 crates @ $ 104 each

 

Requirements

2. Prepare a perpetual inventory record, using the LIFO inventory costing method,and determine the company’s cost of goods sold, ending merchandise inventory,and gross profit.

2 step solution

33PGB_3

Exercise World began January with merchandise inventory of 90 crates of vitamins that cost a total of \(5,850. During the month, Exercise World purchased and soldmerchandise on account as follows:

 

Jan. 2 Purchase 130 crates @ \) 76 each

5 Sale 140 crates @ \( 100 each

16 Purchase 170 crates @ \) 86 each

27 Sale 180 crates @ $ 104 each

 

Requirements

3. Prepare a perpetual inventory record, using the weighted-average inventory costingmethod, and determine the company’s cost of goods sold, ending merchandiseinventory, and gross profit. (Round weighted-average cost per unit to the nearestcent and all other amounts to the nearest dollar.)

2 step solution

33PGB_4

Exercise World began January with merchandise inventory of 90 crates of vitamins that cost a total of \(5,850. During the month, Exercise World purchased and soldmerchandise on account as follows:

 

Jan. 2 Purchase 130 crates @ \) 76 each

5 Sale 140 crates @ \( 100 each

16 Purchase 170 crates @ \) 86 each

27 Sale 180 crates @ $ 104 each

 

Requirements

4. If the business wanted to pay the least amount of income taxes possible, whichmethod would it choose?

2 step solution

Q33PGB_1

Exercise World began January with merchandise inventory of 90 crates of vitamins that cost a total of \(5,850. During the month, Exercise World purchased and soldmerchandise on account as follows:


Jan. 2 Purchase 130 crates @ \) 76 each

5 Sale 140 crates @ \( 100 each

16 Purchase 170 crates @ \) 86 each

27 Sale 180 crates @ $ 104 each


Requirements

1. Prepare a perpetual inventory record, using the FIFO inventory costing method,and determine the company’s cost of goods sold, ending merchandise inventory,and gross profit.

2 step solution

Q33PGB_ 2

Exercise World began January with merchandise inventory of 90 crates of vitamins that cost a total of \(5,850. During the month, Exercise World purchased and soldmerchandise on account as follows:


Jan. 2 Purchase 130 crates @ \) 76 each

5 Sale 140 crates @ \( 100 each

16 Purchase 170 crates @ \) 86 each

27 Sale 180 crates @ $ 104 each


Requirements

2. Prepare a perpetual inventory record, using the LIFO inventory costing method,and determine the company’s cost of goods sold, ending merchandise inventory,and gross profit.

2 step solution

Q33PGB_3

Exercise World began January with merchandise inventory of 90 crates of vitamins that cost a total of \(5,850. During the month, Exercise World purchased and soldmerchandise on account as follows:


Jan. 2 Purchase 130 crates @ \) 76 each

5 Sale 140 crates @ \( 100 each

16 Purchase 170 crates @ \) 86 each

27 Sale 180 crates @ $ 104 each


Requirements

3. Prepare a perpetual inventory record, using the weighted-average inventory costingmethod, and determine the company’s cost of goods sold, ending merchandiseinventory, and gross profit. (Round weighted-average cost per unit to the nearestcent and all other amounts to the nearest dollar.)

2 step solution

Q33PGB_4

 Exercise World began January with merchandise inventory of 90 crates of vitamins that cost a total of \(5,850. During the month, Exercise World purchased and soldmerchandise on account as follows:


Jan. 2 Purchase 130 crates @ \) 76 each

5 Sale 140 crates @ \( 100 each

16 Purchase 170 crates @ \) 86 each

27 Sale 180 crates @ $ 104 each


Requirements

4. If the business wanted to pay the least amount of income taxes possible, whichmethod would it choose?

2 step solution

Q34PGB_1

Steel It began January with 55 units of iron inventory that cost \(35 each. During January, the company completed the following inventory transactions:

Units Unit Cost Unit Sales Price

Jan. 3 Sale 45 \) 83

8 Purchase 75 $ 52

21 Sale 70 85

30 Purchase 10 55

 

Requirements

1. Prepare a perpetual inventory record for the merchandise inventory using theFIFO inventory costing method.

2 step solution

Q34PGB_2

Steel It began January with 55 units of iron inventory that cost \(35 each. During January, the company completed the following inventory transactions:

Units Unit Cost Unit Sales Price

Jan. 3 Sale 45 \) 83

8 Purchase 75 $ 52

21 Sale 70 85

30 Purchase 10 55

Requirements

2. Prepare a perpetual inventory record for the merchandise inventory using theLIFO inventory costing method.

2 step solution

Q34PGB_3

Steel It began January with 55 units of iron inventory that cost \(35 each. During January, the company completed the following inventory transactions:

Units Unit Cost Unit Sales Price

Jan. 3 Sale 45 \) 83

8 Purchase 75 $ 52

21 Sale 70 85

30 Purchase 10 55

Requirements

3. Prepare a perpetual inventory record for the merchandise inventory using theweighted-average inventory costing method.

2 step solution

Q34PGB_4

Steel It began January with 55 units of iron inventory that cost \(35 each. During January, the company completed the following inventory transactions:

 

Units Unit Cost Unit Sales Price

Jan. 3 Sale 45 \) 83

8 Purchase 75 $ 52

21 Sale 70 85

30 Purchase 10 55

 

Requirements

4. Determine the company’s cost of goods sold for January using FIFO, LIFO, andweighted-average inventory costing methods.

2 step solution

Q34PGB_5

Steel It began January with 55 units of iron inventory that cost \(35 each. During January, the company completed the following inventory transactions:

Units Unit Cost Unit Sales Price

Jan. 3 Sale 45 \) 83

8 Purchase 75 $ 52

21 Sale 70 85

30 Purchase 10 55

 

Requirements

5. Compute gross profit for January using FIFO, LIFO, and weighted-average inventorycosting methods.

4 step solution

Q34PGB_6

Steel It began January with 55 units of iron inventory that cost \(35 each. During January, the company completed the following inventory transactions:

 

Units Unit Cost Unit Sales Price

Jan. 3 Sale 45 \) 83

8 Purchase 75 $ 52

21 Sale 70 85

30 Purchase 10 55

 

Requirements

6. If the business wanted to maximize gross profit, which method would it select?

2 step solution

Q35PGB_1

Some of L and K Electronics’s merchandise is gathering dust. It is now December 31, 2018, and the current replacement cost of the ending merchandise inventory is\(32,000 below the business’s cost of the goods, which was \)98,000. Before any adjustmentsat the end of the period, the company’s Cost of Goods Sold account has a balanceof $410,000.

 

Requirements

1. Journalize any required entries.

2 step solution

Q35PGB_2

Some of L and K Electronics’s merchandise is gathering dust. It is now December 31, 2018, and the current replacement cost of the ending merchandise inventory is\(32,000 below the business’s cost of the goods, which was \)98,000. Before any adjustmentsat the end of the period, the company’s Cost of Goods Sold account has a balanceof $410,000.

 

Requirements

2. At what amount should the company report merchandise inventory on the balancesheet?

2 step solution

Q35PGB_3

Some of L and K Electronics’s merchandise is gathering dust. It is now December 31, 2018, and the current replacement cost of the ending merchandise inventory is\(32,000 below the business’s cost of the goods, which was \)98,000. Before any adjustmentsat the end of the period, the company’s Cost of Goods Sold account has a balanceof $410,000.

 

Requirements

3. At what amount should the company report cost of goods sold on the incomestatement?

2 step solution

Q35PGB_4

Some of L and K Electronics’s merchandise is gathering dust. It is now December 31, 2018, and the current replacement cost of the ending merchandise inventory is\(32,000 below the business’s cost of the goods, which was \)98,000. Before any adjustmentsat the end of the period, the company’s Cost of Goods Sold account has a balanceof $410,000.

 

Requirements

4. Which accounting principle or concept is most relevant to this situation?

2 step solution

36PGB_3

Question: Antique Carpets’s books show the following data. In early 2020, auditors found that the ending merchandise inventory for 2017 was understated by \(8,000 and that theending merchandise inventory for 2019 was overstated by \)9,000. The ending merchandiseinventory at December 31, 2018, was correct.

 

2019

2018

2017

Net Sales Revenue

\(     212,000

\)    161,000

\(   170,000

Cost of Goods Sold:

 

 

 

         Beginning Merchandise Inventory

\)22,000

\(28,000

\)41,000

         Net cost of purchase

131,000

100,000

 86,000

         Cost of goods available for sale

153,000

128,000

127,000

         Less: Ending Merchandise Inventory

 34,000 

  22,000

 28,000

         Cost of goods sold

119,000

106,000 

99,000

Gross Profit

         93,000

         55,000

       71,000

Operating Expenses

   63,000

   28,000

   39,000

Net Income

\( 30,000

\) 27,000

$ 32,000

Requirements

1. Prepare corrected income statements for the three years. 
2. State whether each year’s net income—before your corrections—is understated oroverstated, and indicate the amount of the understatement or overstatement. 

3. Compute the inventory turnover and days’ sales in inventory using the correctedincome statements for the three years. (Round all numbers to two decimals.)

3 step solution

36PGB_2

Question: Antique Carpets’s books show the following data. In early 2020, auditors found that the ending merchandise inventory for 2017 was understated by \(8,000 and that theending merchandise inventory for 2019 was overstated by \)9,000. The ending merchandiseinventory at December 31, 2018, was correct.

 

2019

2018

2017

Net Sales Revenue

\(     212,000

\)    161,000

\(   170,000

Cost of Goods Sold:

 

 

 

         Beginning Merchandise Inventory

\)22,000

\(28,000

\)41,000

         Net cost of purchase

131,000

100,000

 86,000

         Cost of goods available for sale

153,000

128,000

127,000

         Less: Ending Merchandise Inventory

 34,000 

  22,000

 28,000

         Cost of goods sold

119,000

106,000 

99,000

Gross Profit

         93,000

         55,000

       71,000

Operating Expenses

   63,000

   28,000

   39,000

Net Income

\( 30,000

\) 27,000

$ 32,000

Requirements

2. State whether each year’s net income—before your corrections—is understated oroverstated, and indicate the amount of the understatement or overstatement.

2 step solution

36PGB_1

Question: Antique Carpets’s books show the following data. In early 2020, auditors found that the ending merchandise inventory for 2017 was understated by \(8,000 and that theending merchandise inventory for 2019 was overstated by \)9,000. The ending merchandiseinventory at December 31, 2018, was correct.

 

2019

2018

2017

Net Sales Revenue

\(     212,000

\)    161,000

\(   170,000

Cost of Goods Sold:

 

 

 

         Beginning Merchandise Inventory

\)22,000

\(28,000

\)41,000

         Net cost of purchase

131,000

100,000

 86,000

         Cost of goods available for sale

153,000

128,000

127,000

         Less: Ending Merchandise Inventory

 34,000 

  22,000

 28,000

         Cost of goods sold

119,000

106,000 

99,000

Gross Profit

         93,000

         55,000

       71,000

Operating Expenses

   63,000

   28,000

   39,000

Net Income

\( 30,000

\) 27,000

$ 32,000

Requirements

1. Prepare corrected income statements for the three years.

3 step solution

36PGB_3

Question: Empire State Carpets’s books show the following data. In early 2020, auditors foundthat the ending merchandise inventory for 2017 was understated by \(8,000 and thatthe ending merchandise inventory for 2019 was overstated by \)9,000. The ending merchandiseinventory at December 31, 2018, was correct.

 

2019

2018

2017

Net Sales Revenue

\(     220,000

\)    162,000

\(   176,000

Cost of Goods Sold:

 

 

 

         Beginning Merchandise Inventory

\)22,000

\(29,000

\)46,000

         Net cost of purchase

132,000

  90,000

 76,000

         Cost of goods available for sale

154,000

119,000

122,000

         Less: Ending Merchandise Inventory

 32,000 

  22,000

 29,000

         Cost of goods sold

122,000

97,000 

93,000

Gross Profit

         98,000

         65,000

       83,000

Operating Expenses

   72,000

   38,000

   48,000

Net Income

\( 26,000

\) 27,000

$ 35,000

Requirements

3. Compute the inventory turnover and days’ sales in inventory using the correctedincome statements for the three years. (Round all numbers to two decimals.)

3 step solution

Q37PGB_1

Right Now Electronic Center began October with 100 units of merchandise inventory that cost \(70 each. During October, the store made the following purchases:

 

Oct. 3 35 units @ \) 82 each

12 45 units @ \( 84 each

18 75 units @ \) 90 each

 

Right Now uses the periodic inventory system, and the physical count at October 31indicates that 130 units of merchandise inventory are on hand.

 

Requirements

1. Determine the ending merchandise inventory and cost of goods sold amountsfor the October financial statements using the FIFO, LIFO, and weighted-averageinventory costing methods.

3 step solution

Q37PGB_2

Right Now Electronic Center began October with 100 units of merchandise inventory that cost \(70 each. During October, the store made the following purchases:

 

Oct. 3 35 units @ \) 82 each

12 45 units @ \( 84 each

18 75 units @ \) 90 each

 

Right Now uses the periodic inventory system, and the physical count at October 31indicates that 130 units of merchandise inventory are on hand.

 

Requirements

2. Net sales revenue for October totaled $26,000. Compute Right Now’s gross profitfor October using each method.

3 step solution

Q37PGB_3

Right Now Electronic Center began October with 100 units of merchandise inventory that cost \(70 each. During October, the store made the following purchases:

 

Oct. 3 35 units @ \) 82 each

12 45 units @ \( 84 each

18 75 units @ \) 90 each

 

Right Now uses the periodic inventory system, and the physical count at October 31indicates that 130 units of merchandise inventory are on hand.

 

Requirements

3. Which method will result in the lowest income taxes for Right Now? Why? Whichmethod will result in the highest net income for Right Now? Why?

2 step solution

39CP_1

Question: This problem continues the Canyon Canoe Company situation from Chapter 5. At the beginning of the January 2019, Canyon Canoe Company decided to carry and sellT-shirts with its logo printed on them. Canyon Canoe Company uses the perpetualinventory system to account for the inventory. During February 2019, Canyon CanoeCompany completed the following merchandising transactions:

 

Feb. 2 Sold 60 T-shirts at \(10 each.

5 Purchased 50 T-shirts at \)6 each.

7 Sold 45 T-shirts for \(10 each.

8 Sold 20 T-shirts for \)10 each.

10 Canyon Canoe Company realized the inventory was running

low, so it placed a rush order and purchased 20 T-shirts. The

premium cost for these shirts was \(7 each.

12 Placed a second rush order and purchased 40 T-shirts at \)7

each.

13 Sold 20 T-shirts for \(10 each.

15 Purchased 50 T-shirts for \)6 each.

20 In order to avoid future rush orders, purchased 150 T-shirts.

Due to the volume of the order, Canyon Canoe Company

was able to negotiate a cost of \(5 each.

21 Sold 40 T-shirts for \)10 each.

22 Sold 35 T-shirts for \(10 each.

24 Sold 20 T-shirts for \)10 each.

25 Sold 45 T-shirts for \(10 each.

27 Sold 40 T-shirts for \)10 each.

 

Requirements

1. Assume Canton Canoe Company began February with 94 T-shirts in inventorythat cost $5 each. Prepare the perpetual inventory records for February using theFIFO inventory costing method.

2 step solution

39CP_2

Question: This problem continues the Canyon Canoe Company situation from Chapter 5. At the beginning of the January 2019, Canyon Canoe Company decided to carry and sellT-shirts with its logo printed on them. Canyon Canoe Company uses the perpetualinventory system to account for the inventory. During February 2019, Canyon CanoeCompany completed the following merchandising transactions:

 

Feb. 2 Sold 60 T-shirts at \(10 each.

5 Purchased 50 T-shirts at \)6 each.

7 Sold 45 T-shirts for \(10 each.

8 Sold 20 T-shirts for \)10 each.

10 Canyon Canoe Company realized the inventory was running

low, so it placed a rush order and purchased 20 T-shirts. The

premium cost for these shirts was \(7 each.

12 Placed a second rush order and purchased 40 T-shirts at \)7

each.

13 Sold 20 T-shirts for \(10 each.

15 Purchased 50 T-shirts for \)6 each.

20 In order to avoid future rush orders, purchased 150 T-shirts.

Due to the volume of the order, Canyon Canoe Company

was able to negotiate a cost of \(5 each.

21 Sold 40 T-shirts for \)10 each.

22 Sold 35 T-shirts for \(10 each.

24 Sold 20 T-shirts for \)10 each.

25 Sold 45 T-shirts for \(10 each.

27 Sold 40 T-shirts for \)10 each.

Requirements

2. Provide a summary for the month, in both units and dollars, of the change in inventory in the following format:

 

Number of T-shirts

Dollar Amount

Beginning Balance

 

 

Add: Purchases

 

 

Less: Cost of goods sold

 

 

Ending Balance

 

 

2 step solution

40PS_2

Question: This problem continues the Crystal Clear Cleaning problem begun in Chapter 2 and continued through Chapter 5.

Consider the December transactions for Crystal Clear Cleaning that were presentedin Chapter 5. (Cost data have been removed from the sale transactions.) Crystal Clearuses the perpetual inventory system.

 

Dec. 2 Purchased 1,000 units of inventory for \(4,000 on account from Sparkle

Company on terms, 5/10, n/20.

5 Purchased 1,200 units of inventory from Borax on account with terms

4/10, n/30. The total invoice was for \)6,000, which included a \(300

freight charge.

7 Returned 300 units of inventory to Sparkle from the December 2

purchase.

9 Paid Borax.

11 Sold 500 units of goods to Happy Maids for \)5,500 on account with         

termsn/30.

12 Paid Sparkle.

15 Received 100 units with a sales price of \(1,100 of goods back from

customer Happy Maids.

21 Received payment from Happy Maids, settling the amount due in full.

28 Sold 500 units of goods to Bridget, Inc. on account for \)6,500. Terms 

1/15,n/30.

29 Paid cash for utilities of \(550.

30 Paid cash for Sales Commission Expense of \)214.

31 Received payment from Bridget, Inc., less discount.

31 Recorded the following adjusting entries:

a. Physical count of inventory on December 31 showed 800 units of

goods on hand.

b. Depreciation, \(150.

c. Accrued salaries expense of \)2,100.

d. Estimated sales returns of \(1,500, with cost of \)540.

e. Prepared all other adjustments necessary for December (Hint: You willneed to review the adjustment information in Chapter 3 to determinethe remaining adjustments). Assume the cleaning supplies left atDecember 31 are $50.

Requirements

2. Journalize the transactions for December 11th, 28th, and 31st (adjusting entry aonly) using the perpetual inventory record created in Requirement 1.

2 step solution

40PS_1

Question: This problem continues the Crystal Clear Cleaning problem begun in Chapter 2 and continued through Chapter 5.

Consider the December transactions for Crystal Clear Cleaning that were presentedin Chapter 5. (Cost data have been removed from the sale transactions.) Crystal Clearuses the perpetual inventory system.

 

Dec. 2 Purchased 1,000 units of inventory for \(4,000 on account from Sparkle

Company on terms, 5/10, n/20.

5 Purchased 1,200 units of inventory from Borax on account with terms

4/10, n/30. The total invoice was for \)6,000, which included a \(300

freight charge.

7 Returned 300 units of inventory to Sparkle from the December 2

purchase.

9 Paid Borax.

11 Sold 500 units of goods to Happy Maids for \)5,500 on account with         

termsn/30.

12 Paid Sparkle.

15 Received 100 units with a sales price of \(1,100 of goods back from

customer Happy Maids.

21 Received payment from Happy Maids, settling the amount due in full.

28 Sold 500 units of goods to Bridget, Inc. on account for \)6,500. Terms 

1/15,n/30.

29 Paid cash for utilities of \(550.

30 Paid cash for Sales Commission Expense of \)214.

31 Received payment from Bridget, Inc., less discount.

31 Recorded the following adjusting entries:

a. Physical count of inventory on December 31 showed 800 units of

goods on hand.

b. Depreciation, \(150.

c. Accrued salaries expense of \)2,100.

d. Estimated sales returns of \(1,500, with cost of \)540.

e. Prepared all other adjustments necessary for December (Hint: You willneed to review the adjustment information in Chapter 3 to determinethe remaining adjustments). Assume the cleaning supplies left atDecember 31 are $50.

Requirements

1. Prepare perpetual inventory records for December for Crystal Clear Cleaning usingthe FIFO inventory costing method. (Note: You must calculate the cost of goodssold on the 11th, 28th, and 31st (adjusting entry a).) Round per unit costs to twodecimal places.

2 step solution

Q1CP

The Davis Lamp Company (DLC) is a wholesale company that purchases lamps from the manufacturer and resells them to retail stores. The company has three inventory items: desk lamps, table lamps, and floor lamps. DLC uses a perpetual inventory system, FIFO method. DCL owns land with a building, which is separated into two parts: office space and warehouse space. All expenses associated with the office are categorized as Administrative Expenses. All expenses associated with the warehouse, which is used for the shipping and receiving functions of the company, are categorized as Selling Expenses. In addition to the land and building, DLC also owns office furniture and equipment and warehouse fixtures. The company uses one accumulated depreciation account for all the depreciable assets.

The trial balance for DLC as of September 30, 2018 follows:

DAVIS LAMP COMPANY

Trial Balance

September 30, 2018

 

Balance

Account

Debit

Credit

Cash

   \( 457,000

 

Account Receivables

                 0

 

Merchandise Inventory

      126,000

 

Office Supplies

             275

 

Warehouse Supplies

             350

 

Land 

        20,000

 

Building

      780,000

 

Office Furniture and Equipment

      125,000

 

Warehouse Fixtures

      260,000

 

Accumulated Depreciation

 

     \) 194,00

Accounts Payable

 

                 0

Common Stock

 

      100,000

Retained Earnings

 

      298,925

Dividends 

                 0

 

Sales Revenue

 

   2,654,150

Cost of Goods Sold

   1,061,450

 

Salaries Expense – Selling

      270,000

 

Utilities Expense – Selling

        32,000

 

Supplies Expense – Selling

                 0

 

Depreciation Expense – Selling

                 0

 

Salaries Expense – Administrative

        90,000

 

Utilities Expense – Administrative

        25,000

 

Supplies Expense – Administrative

                 0

 

Depreciation Expense – Administrative

                 0

 

Total

\( 3,247,075

 \) 3,247,075


 

 

 

Merchandise Inventory as of September 30 consists of the following lamps:

Item                 Quantity           Unit Cost          Total Cost

Desk Lamp       2,500                   \( 8                   \) 20,000

Table Lamp      3,000                    18                      54,000

Floor Lamp      2,000                    26                      52,000

Total                                                                   \( 126,000

 

During the fourth quarter of 2018, DLC completed the following transactions: 

Oct. 1 Purchased lamps on account from Blue Ridge Lights, terms n/30, FOB destination:

5,000 desk lamps at \)9 each

7,500 table lamps at \(19 each

2,500 floor lamps at \)25 each

 

12 Sold lamps on account to Atlas Home Furnishings, terms 2/10, n/30:

4,000 table lamps at \(45 each

 

15 Sold lamps on account to Hiawassee Office Supply, terms 2/10, n/30:

1,000 desk lamps at \)20 each

 

20 Received a check from Atlas Home Furnishings for full amount owed on Oct. 12 sale.

 

23 Received a check from Hiawassee Office Supply for full amount owed on Oct. 15 sale.

 

28 Sold lamps on account to Parkway Home Stores, terms 2/10, n/30:

3,500 table lamps at \(45 each

1,500 floor lamps at \)65 each

 

30 Paid amount due to Blue Ridge Lights from Oct. 1 purchase.

31 Paid salaries, \(40,000 (75% selling, 25% administrative).

 

31 Paid utilities, \)2,500 (60% selling, 40% administrative).

 

Nov. 1 Sold lamps on account to Hiawassee Office Supply, terms 2/10, n/30:

3,000 desk lamps at \(20 each

 

5 Purchased lamps on account from Blue Ridge Lights, terms n/30, FOB destination:

5,000 desk lamps at \)10 each

10,000 table lamps at \(21 each

5,000 floor lamps at \)27 each

 

5 Received a check from Parkway Home Stores for full amount owed on Oct. 28 sale.

 

8 Received a check from Hiawassee Office Supply for full amount owed on Nov. 1 sale.

 

10 Purchased and paid for supplies: \(325 for the office; \)675 for the warehouse.

 

15 Sold lamps on account to Anderson Office Supply, n/30:

2,000 desk lamps at \(20 each

 

18 Sold lamps on account to Go-Mart Discount Stores, terms 1/10, n/30:

2,000 table lamps at \)45 each

2,000 floor lamps at \(65 each

 

28 Received a check from Go-Mart Discount Stores for full amount owed on Nov. 18 sale.

 

30 Paid salaries, \)40,000 (75% selling, 25% administrative).

 

30 Paid utilities, \(2,670 (60% selling, 40% administrative).

 

Dec. 5 Paid amount due to Blue Ridge Lights from Nov. 5 purchase.

 

15 Received a check from Anderson Office Supply for full amount owed on Nov. 15 sale.

 

15 Paid dividends, \)50,000.

 

27 Sold lamps on account to Atlas Home Furnishings, terms 2/10, n/30:

4,500 desk lamps at \(20 each

5,000 table lamps at \)45 each

 

31 Paid salaries, \(40,000 (75% selling, 25% administrative).

 

31 Paid utilities, \)3,200 (60% selling, 40% administrative).

 Requirements

1. Open general ledger T-accounts and enter opening balances as of September 30, 2018.

2. Open inventory records for the three inventory items and enter opening balances as of September 30, 2018. Complete the inventory records using the following transactions: Oct. 1, 12, 15, 28; Nov. 1, 5, 15, 18, and Dec. 27.

3. Record the transactions in the general journal.

4. Post transactions to the general ledger.

5. Prepare adjusting entries for the year ended December 31, 2018, and post to the ledger:

a. Depreciation, \(48,500 (75% selling, 25% administrative).

b. Supplies on hand: office, \)200; and warehouse, $650.

c. A physical inventory account resulted in the following counts: desk lamps, 1,990; table lamps, 5,995; and floor lamps, 6,000. Update the inventory records.

6. Prepare an adjusted trial balance.

7. Provide a summary for the month, in both units and dollars, of the change in inventory for each item in the following format:

 

DESK Lamps

FLOOR Lamps

FLOOR Lamps

 

Number of lamps

Dollar Amount

Number of lamps

Dollar Amount

Number of lamps

Dollar Amount

Beginning Balance

 

 

 

 

 

 

Add: Purchases

 

 

 

 

 

 

Less: COGS

 

 

 

 

 

 

Ending Balance

 

 

 

 

 

 

         

Does the sum of the ending balances in the inventory records match the balance in Merchandise Inventory in the general ledger? If not, review the transactions to find your error.

8. Prepare Davis Lamp Company’s multi-step income statement and statement of retained earnings for the year ended December 31, 2018, and a classified balance sheet as of December 31, 2018. 

9. Calculate the following ratios for DLC as of December 31, 2018: gross profit percentage, inventory turnover, and days’ sales in inventory.

10. Record and post the closing entries.

11. Prepare a post-closing trial balance.

10 step solution

Q6-1DC

Question: Suppose you manage Campbell Appliance. The store’s summarized financial statements for 2019, the most recent year, follow:

 

CAMPBELL APPLIANCE

Income Statement

Year Ended December 31, 2019

Net Sales Revenue

 

\( 800,000

Cost of Goods Sold

 

      660,000

Gross Profit 

 

      140,000

Operating Expenses

 

      100,000

Net Income

 

\)      40,000

 

 

CAMPBELL APPLIANCE

Balance Sheet

December 31, 2019

Assets

Liabilities and Stockholders’ Equity

Cash

\( 30,000

Accounts Payable

\) 35,000

Inventories

75,000

Note Payable

280,000

Land and Building, Net

360,000

Total Liabilities

315,000

 

 

Stockholders’ Equity

150,000

Total Assets

\( 465,000

Total Liabilities and Stockholders’ Equity

\) 465,000

 

Assume that you need to double net income. To accomplish your goal, it will be very difficult to raise the sales prices you charge because there is a discount appliance store nearby. Also, you have little control over your cost of goods sold because the appliance manufacturers set the amount you must pay.

Identify several strategies for doubling net income.

2 step solution

Show/ page