Question

In: Accounting

You have the following information for Novak Corp. for the month ended October 31, 2022. Novak...

You have the following information for Novak Corp. for the month ended October 31, 2022. Novak uses a periodic method for inventory.

Date

Description

Units

Unit Cost or Selling Price

Oct. 1

Beginning inventory

60 $24

Oct. 9

Purchase

140 26

Oct. 11

Sale

95 45

Oct. 17

Purchase

95 270

Oct. 22

Sale

60 50

Oct. 25

Purchase

70 29

Oct. 29

Sale

105 50

Calculate the weighted-average cost. (Round answer to 3 decimal places, e.g. 5.125.)

Calculate ending inventory, cost of goods sold, gross profit under each of the following methods.

(1) LIFO.
(2) FIFO.
(3) Average-cost. (Round answers to 0 decimal place, e.g. 125.)

Calculate gross profit rate under each of the following methods.

(1) LIFO.
(2) FIFO.
(3) Average-cost. (Round answers to 1 decimal place, e.g. 51.2%)

Solutions

Expert Solution

Date Description Units Unit Cost Total Cost
Oct. 1 Beginning inventory 60 $24 $1,440
Oct. 9 Purchase 140 26 $3,640
Oct. 17 Purchase 95 27 $2,565
Oct. 25 Purchase 70 29 $2,030
Goods available for sale 365 $9,675
Weighted average cost per unit (32760/365) $26.507
Date Description Units Selling Price Total Sales
Oct. 11 Sale 95 45 $4,275
Oct. 22 Sale 60 50 $3,000
Oct. 29 Sale 105 50 $5,250
Total 260 $12,525
Ending inventory Units (365-260) 105
Ending inventory Amount
LIFO (60*24+45*26) $ 2,610
FIFO (70*29+35*27) $ 2,975
Average-cost (105*26.507) $ 2,783
Cost of Goods Sold Amount
LIFO (9675-2610) $ 7,065
FIFO (9675-2975) $ 6,700
Average-cost (9675-2783.24) $ 6,892
Gross Profit Amount
LIFO (12525-7065) $ 5,460
FIFO (12525-6700) $ 5,825
Average-cost (12525-6891.76) $ 5,633
Gross Profit Rate
LIFO (5460/12525) 43.59%
FIFO (5825/12525) 46.51%
Average-cost (5633.24/12525) 44.98%

Related Solutions

You have the following information for Novak Corp. for the month ended October 31, 2022. Novak...
You have the following information for Novak Corp. for the month ended October 31, 2022. Novak uses a periodic method for inventory. Date Description Units Unit Cost or Selling Price Oct. 1 Beginning inventory 60 $24 Oct. 9 Purchase 140 26 Oct. 11 Sale 95 45 Oct. 17 Purchase 95 270 Oct. 22 Sale 60 50 Oct. 25 Purchase 70 29 Oct. 29 Sale 105 50 Calculate the weighted-average cost. (Round answer to 3 decimal places, e.g. 5.125.) Calculate ending...
You have the following information for Bramble Corp. for the month ended October 31, 2022. Bramble...
You have the following information for Bramble Corp. for the month ended October 31, 2022. Bramble uses a periodic method for inventory. Date Description Units Unit Cost or Selling Price Oct. 1 Beginning inventory 65 $26 Oct. 9 Purchase 115 28 Oct. 11 Sale 95 40 Oct. 17 Purchase 95 29 Oct. 22 Sale 65 45 Oct. 25 Purchase 75 31 Oct. 29 Sale 105 45 Calculate the weighted-average cost. (Round answer to 3 decimal places, e.g. 5.125.) Weighted-average cost...
You have the following information for Windsor, Inc. for the month ended October 31, 2022. Windsor,...
You have the following information for Windsor, Inc. for the month ended October 31, 2022. Windsor, Inc. uses a periodic method for inventory. Date Description Units Unit Cost or Selling Price Oct. 1 Beginning inventory 56 $23 Oct. 9 Purchase 122 25 Oct. 11 Sale 90 34 Oct. 17 Purchase 108 26 Oct. 22 Sale 55 39 Oct. 25 Purchase 67 28 Oct. 29 Sale 113 39 Calculate ending inventory, cost of goods sold, gross profit under each of the...
You have the following information for Sheridan Company for the month ended October 31, 2022. Sheridan...
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 ending inventory, cost of goods sold, gross profit under each of the following...
You have the following information for Metlock, Inc. for the month ended October 31, 2022. Metlock...
You have the following information for Metlock, Inc. for the month ended October 31, 2022. Metlock uses a periodic method for inventory. Date Description Units Unit Cost or Selling Price Oct. 1 Beginning inventory 65 $22 Oct. 9 Purchase 140 24 Oct. 11 Sale 100 40 Oct. 17 Purchase 100 25 Oct. 22 Sale 65 45 Oct. 25 Purchase 75 27 Oct. 29 Sale 110 45 A) Calculate the weighted-average cost. (Round answer to 3 decimal places, e.g. 5.125.) Weighted-average...
You have the following information for Tamarisk, Inc. for the month ended October 31, 2022. Tamarisk...
You have the following information for Tamarisk, Inc. for the month ended October 31, 2022. Tamarisk uses a periodic method for inventory. Date Description Units Unit Cost or Selling Price Oct. 1 Beginning inventory 60 $24 Oct. 9 Purchase 115 26 Oct. 11 Sale 95 45 Oct. 17 Purchase 95 27 Oct. 22 Sale 60 50 Oct. 25 Purchase 70 29 Oct. 29 Sale 105 50 (a1) Correct answer iconYour answer is correct. Calculate the weighted-average cost. (Round answer to...
You have the following information for Sheridan Company for the month ended October 31, 2022. Sheridan...
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 New attempt is in progress. Some of the new entries may impact the last...
You have the following information for Tamarisk, Inc. for the month ended October 31, 2017. Tamarisk,...
You have the following information for Tamarisk, Inc. for the month ended October 31, 2017. Tamarisk, Inc. uses a periodic method for inventory. Date Description Units Unit Cost or Selling Price Oct. 1 Beginning inventory 63 $25 Oct. 9 Purchase 114 27 Oct. 11 Sale 96 34 Oct. 17 Purchase 102 28 Oct. 22 Sale 54 39 Oct. 25 Purchase 67 30 Oct. 29 Sale 109 39 Calculate the weighted-average cost. (Round answer to 3 decimal places, e.g. 5.125.) Weighted-average...
You have the following information for Sheridan Company for the month ended October 31, 2017. Sheridan...
You have the following information for Sheridan Company for the month ended October 31, 2017. Sheridan Company uses a periodic method for inventory. Date Description Units Unit Cost or Selling Price Oct. 1 Beginning inventory 59 $26 Oct. 9 Purchase 113 28 Oct. 11 Sale 103 35 Oct. 17 Purchase 103 29 Oct. 22 Sale 56 40 Oct. 25 Purchase 75 31 Oct. 29 Sale 102 40 Calculate the weighted-average cost. (Round answer to 3 decimal places, e.g. 5.125.) Weighted-average...
You are provided with the following information for Novak Corp. Novak Corp. uses the periodic system...
You are provided with the following information for Novak Corp. Novak Corp. uses the periodic system of accounting for its inventory transactions. March 1 Beginning inventory 1,930 liters at a cost of 60¢ per liter. March 3 Purchased 2,450 liters at a cost of 65¢ per liter. March 5 Sold 2,395 liters for $1.05 per liter. March 10 Purchased 4,190 liters at a cost of 72¢ per liter. March 20 Purchased 2,510 liters at a cost of 80¢ per liter....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT