Question

In: Accounting

Problem 6-05A a1-a3, b (Part Level Submission) (Video) You are provided with the following information for...

Problem 6-05A a1-a3, b (Part Level Submission) (Video) You are provided with the following information for Splish Brothers Inc. for the month ended June 30, 2020. Splish Brothers uses the periodic method for inventory. Date Description Quantity Unit Cost or Selling Price June 1 Beginning inventory 45 $42 June 4 Purchase 135 46 June 10 Sale 115 73 June 11 Sale return 13 73 June 18 Purchase 54 48 June 18 Purchase return 9 48 June 25 Sale 68 78 June 28 Purchase 25 52

Solutions

Expert Solution

Your data

Date

Description

Quantity

Unit Cost

Selling price

June 1

Beginning inventory

45

$42

June 4

Purchase

135

46

June 10

Sale

115

73

June 11

Sale return

13

73

Net sales of June 10

Net sales

102

73

June 18

Purchase

54

48

June 18

Purchase return

9

48

Net Purchase of June 18

Net purchase

45

48

June 25

Sale

68

78

June 28

Purchase

25

52

Total sales

Units

Selling price

Total sales

Net sales of June 10

102

73

        7,446

June 25

68

78

        5,304

Total sales revenue

170

     12,750

Method

First in First out

Periodic method for inventory

Date

Goods Available for sale

Cost of goods sold

Ending inventory

Unit

Unit cost

Value

Unit

Unit cost

Value

Unit

Unit cost

Value

Beginning

45

42

         1,890

45

42

        1,890

Purchase - June 4

135

46

         6,210

135

46

        6,210

Net Purchase -June 18

45

48

         2,160

45

48

        2,160

Purchase - June 28

25

52

         1,300

25

52

        1,300

Total

250

      11,560

180

        8,100

70

        3,460

Method

Last in First out

Periodic method for inventory

Date

Goods Available for sale

Cost of goods sold

Ending inventory

Unit

Unit cost

Value

Unit

Unit cost

Value

Unit

Unit cost

Value

Beginning

45

42

         1,890

45

42

        1,890

Purchase - June 4

135

46

         6,210

110

46

        5,060

25

46

        1,150

Net Purchase -June 18

45

48

         2,160

45

48

        2,160

Purchase - June 28

25

52

         1,300

25

52

        1,300

Total

250

      11,560

180

        8,520

70

        3,040

Method

Weighted Average (Periodic method for inventory)

Date

Goods Available for sale

Unit

Unit cost

Value

Beginning

45

42

         1,890

Purchase - June 4

135

46

         6,210

Net Purchase -June 18

45

48

         2,160

Purchase - June 28

25

52

         1,300

Total

250

      11,560

Cost of Goods Available for sale

      11,560

Divided by: Units Available for sale

            250

Weighted Average cost per unit

         46.24

Cost of goods sold

180

         46.24

         8,323

Ending inventory

70

         46.24

         3,237

Summary of answer

Inventory Method

First in First out

Last in First out

Weighted Average

Cost of goods sold

         8,100

         8,520

         8,323

Ending inventory

         3,460

         3,040

         3,237

Cost of Goods Available for sale

      11,560

      11,560

      11,560

Income statement

Inventory Method

First in First out

Last in First out

Weighted Average

Sales revenue

      12,750

      12,750

      12,750

Less: Cost of goods sold

         8,100

         8,520

         8,323

Gross Profit

         4,650

         4,230

         4,427


Related Solutions

Problem 6-06A a1-a2 (Part Level Submission) You are provided with the following information for Sheffield Inc....
Problem 6-06A a1-a2 (Part Level Submission) You are provided with the following information for Sheffield Inc. Sheffield Inc. uses the periodic method of accounting for its inventory transactions. March 1 Beginning inventory 2,000 liters at a cost of 60¢ per liter. March 3 Purchased 2,500 liters at a cost of 62¢ per liter. March 5 Sold 2,300 liters for $1.05 per liter. March 10 Purchased 4,000 liters at a cost of 69¢ per liter. March 20 Purchased 2,300 liters at...
Problem 6-06A a1-a2 (Part Level Submission) You are provided with the following information for Sheffield Inc....
Problem 6-06A a1-a2 (Part Level Submission) You are provided with the following information for Sheffield Inc. Sheffield Inc. uses the periodic method of accounting for its inventory transactions. March 1 Beginning inventory 2,000 liters at a cost of 60¢ per liter. March 3 Purchased 2,500 liters at a cost of 62¢ per liter. March 5 Sold 2,300 liters for $1.05 per liter. March 10 Purchased 4,000 liters at a cost of 69¢ per liter. March 20 Purchased 2,300 liters at...
Problem 6-05A a1-a3 You have the following information for Sheridan Company for the month ended October...
Problem 6-05A a1-a3 You have the following information for Sheridan Company for the month ended October 31, 2022. Sheridan uses a periodic method for inventory. Date Description Units Unit Cost or Selling Price Oct. 1 Beginning inventory 55 $24 Oct. 9 Purchase 140 26 Oct. 11 Sale 90 45 Oct. 17 Purchase 90 27 Oct. 22 Sale 55 50 Oct. 25 Purchase 65 29 Oct. 29 Sale 100 50 Calculate the weighted-average cost. (Round answer to 3 decimal places, e.g....
Problem 6-05A a1-a3 You have the following information for Nash's Trading Post, LLC for the month...
Problem 6-05A a1-a3 You have the following information for Nash's Trading Post, LLC for the month ended October 31, 2022. Nash uses a periodic method for inventory. Date Description Units Unit Cost or Selling Price Oct. 1 Beginning inventory 50 $24 Oct. 9 Purchase 130 26 Oct. 11 Sale 100 40 Oct. 17 Purchase 100 27 Oct. 22 Sale 50 45 Oct. 25 Purchase 60 29 Oct. 29 Sale 110 45 Your answer is incorrect. Try again. Calculate the weighted-average...
Problem 8-05A a-b (Part Level Submission) (Video) The bank portion of the bank reconciliation for Vaughn...
Problem 8-05A a-b (Part Level Submission) (Video) The bank portion of the bank reconciliation for Vaughn Company at November 30, 2020, was as follows. Vaughn COMPANY Bank Reconciliation November 30, 2020 Cash balance per bank $14,767.90 Add: Deposits in transit 2,530.20 17,298.10 Less: Outstanding checks Check Number Check Amount 3451 $ 2,260.40 3470 720.10 3471 844.50 3472 1,426.80 3474 1,054.50 6,306.30 Adjusted cash balance per bank $10,991.80 The adjusted cash balance per bank agreed with the cash balance per books...
Problem 6-5A (Part Level Submission) You are provided with the following information for Najera Inc. for...
Problem 6-5A (Part Level Submission) You are provided with the following information for Najera Inc. for the month ended June 30, 2017. Najera uses the periodic method for inventory. Date Description Quantity Unit Cost or Selling Price June 1 Beginning inventory 40 $40 June 4 Purchase 135 44 June 10 Sale 110 70 June 11 Sale return 15 70 June 18 Purchase 55 46 June 18 Purchase return 10 46 June 25 Sale 65 75 June 28 Purchase 30 50...
Problem 4-05A a-g (Part Level Submission) (Video) Crane Clark opened Crane’s Cleaning Service on July 1,...
Problem 4-05A a-g (Part Level Submission) (Video) Crane Clark opened Crane’s Cleaning Service on July 1, 2020. During July, the following transactions were completed. July 1 Crane invested $19,900 cash in the business. 1 Purchased used truck for $8,800, paying $3,900 cash and the balance on account. 3 Purchased cleaning supplies for $2,000 on account. 5 Paid $1,800 cash on 1-year insurance policy effective July 1. 12 Billed customers $4,500 for cleaning services. 18 Paid $1,600 cash on amount owed...
Problem 16-05A a-d (Part Level Submission) The following securities are in Wildhorse Company’s portfolio of long-term...
Problem 16-05A a-d (Part Level Submission) The following securities are in Wildhorse Company’s portfolio of long-term securities at December 31, 2020. Cost 1,200 shares of Willhite Corporation common stock $60,000 1,200 shares of Hutcherson Corporation common stock 69,600 1,000 shares of Downing Corporation preferred stock 26,000 On December 31, 2020, the total cost of the portfolio equaled total fair value. Wildhorse had the following transactions related to the securities during 2021. Jan. 20 Sold all 1,200 shares of Willhite Corporation...
Problem 6-08A a1-a2 (Part Level Submission) Metlock, Inc. is a retailer operating in Calgary, Alberta. Metlock...
Problem 6-08A a1-a2 (Part Level Submission) Metlock, Inc. is a retailer operating in Calgary, Alberta. Metlock uses the perpetual inventory method. Assume that there are no credit transactions; all amounts are settled in cash. You are provided with the following information for Metlock for the month of January 2022. Date Description Quantity Unit Cost or Selling Price Dec. 31 Ending inventory 160 $20 Jan. 2 Purchase 96 22 Jan. 6 Sale 180 39 Jan. 9 Purchase 76 24 Jan. 10...
Problem 6-08A a1-a2 (Part Level Submission) Bramble Inc. is a retailer operating in British Columbia. Bramble...
Problem 6-08A a1-a2 (Part Level Submission) Bramble Inc. is a retailer operating in British Columbia. Bramble 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 Bramble Inc. for the month of January 2020. Date Description Quantity Unit Cost or Selling Price January 1 Beginning inventory...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT