Ans. | *Calculations for Average cost per unit: | ||||||
Available for sale | |||||||
Date | Units | Rate | Total | ||||
01-Oct | 55 | $26.00 | $1,430 | ||||
09-Oct | 140 | $28.00 | $3,920 | ||||
17-Oct | 100 | $29.00 | $2,900 | ||||
25-Oct | 65 | $31.00 | $2,015 | ||||
Cost of goods available for sale | 360 | $10,265 | |||||
Average cost per unit = Total cost of goods available for sale / Total units available | |||||||
$10,265 / 360 | |||||||
$28.514 | per unit | ||||||
Ans. | Calculations for Ending inventory, cost of goods sold, gross profit and gross profit rate: | ||||||
Units sold (100 + 55 + 110) = 265 units | |||||||
Ending inventory units = Units available for sale - Total units sold | |||||||
360 - 265 | |||||||
95 units | |||||||
a | Periodic LIFO: | ||||||
Date | Units | Rate | Total | ||||
01-Oct | 55 | $26.00 | $1,430 | ||||
09-Oct | 40 | $28.00 | $1,120 | ||||
Ending inventory | 95 | $2,550 | |||||
Cost of goods sold = Total cost of goods available for sale - Ending inventory | |||||||
$10,265 - $2,550 | |||||||
$7,715 | |||||||
*In LIFO method the units that have purchased last, are released the first one and the ending inventory | |||||||
units remain from the first purchases. | |||||||
b | Periodic FIFO: | ||||||
Date | Units | Rate | Total | ||||
25-Oct | 65 | $31.00 | $2,015 | ||||
17-Oct | 30 | $29.00 | $870 | ||||
Ending inventory | 95 | $2,885 | |||||
Cost of goods sold = Total cost of goods available for sale - Ending inventory | |||||||
$10,265 - $2,885 | |||||||
$7,380 | |||||||
*In FIFO method the units that have purchased first (earliest), are released the first one and the ending inventory | |||||||
units remain from the last (recent) purchases. | |||||||
c | Weighted average cost: | ||||||
Ending inventory = Average cost per unit * Ending inventory units | |||||||
$28.514 *95 | |||||||
$2,709 | |||||||
Cost of goods sold = Total cost of goods available for sale - Ending inventory | |||||||
$10,265 - $2,709 | |||||||
$7,556 | |||||||
LIFO | FIFO | Weighted average | |||||
Sales | $12,750 | $12,750 | $12,750 | ||||
(-) Cost of goods sold | -7715 | -7380 | -$7,556 | ||||
Gross profit | $5,035 | $5,370 | $5,194 | ||||
Gross profit rate | 39.5% | 42.1% | 40.7% | ||||
Gross profit rate = Gross profit / Sales * 100 | |||||||
*Calculation of sales: | |||||||
Date | Units | Rate | Cost | ||||
11-Oct | 100 | $45.00 | $4,500 | ||||
22-Oct | 55 | $50.00 | $2,750 | ||||
29-Oct | 110 | $50.00 | $5,500 | ||||
Total sales | $12,750 | ||||||
Question 2 View Policies Current Attempt in Progress You have the following information for Marigold Corp....
View Policies Current Attempt in Progress You have the following information for Waterway Industries for the month ended October 31, 2022. Waterway uses a periodic method for inventory Date Description Units Unit Cost or Selling Price Oct. 1 Beginning inventory $26 70 125 Oct. 9 Purchase Oct. 11 Sale Oct. 17 Purchase Oct. 22 Sale Oct. 25 Purchase Oct. 29 Sale Calculate the weighted average cost. (Round answer to 3 decimal places, e.g. 5.125.) Weighted average cost per unit $...
Question 2 View Policies Current Attempt in Progress You have the following information for Kingbird, Inc. for the month ended October 31, 2022. Kingbird uses a periodic method for inventory. Date Description Units Unit Cost or Selling Price Oct. 1 Beginning inventory Oct. 9 Purchase Oct. 11 Sale Oct. 17 Purchase Oct. 22 Sale Oct. 25 Purchase Oct. 29 Sale Calculate the weighted average cost. (Round answer to 3 decimal places, e.g. 5.125.) Calculate ending inventory, cost of goods sold,...
You have the following information for Waterway Industries for the month ended October 31, 2022. Waterway uses a periodic method for inventory. Date Description Units Unit Cost or Selling Price Oct. 1 Beginning inventory 70 $26 Oct. 9 Purchase Oct. 11 Sale Oct. 17 Purchase Oct. 22 Sale Oct. 25 Purchase Oct 29 Sale X Your answer is incorrect. Calculate the weighted average cost. (Round answer to 3 decimal places, eg. 5.125.) Weighted average cost per units 28.572 Your answer...
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 50 Oct. 1 Oct. 9 Beginning inventory Purchase Sale Oct. 11 Oct 17 Purchase Oct. 22 Oct. 25 Oct. 29 Sale Purchase Sale Calculate the weighted average cost. (Round answer to 3 decimal places, eg. 5.125.) Weighted-average cost per unit $ Calculate ending inventory, cost of goods sold,...
You have the following information for Blue Spruce Corp. for the month ended October 31, 2022. Blue Spruce uses a periodic method for inventory Units Date Description Unit Cost or Selling Price Oct. 1 Beginning inventory 50 $22 Oct. 9 Purchase 125 24 Oct. 11 Sale 90 45 Oct. 17 Purchase 90 25 Oct. 22 Sale 50 50 Oct. 25 Purchase 60 27 Oct. 29 100 Sale 50 Calculate the weighted-average cost. (Round answer to 3 decimal places, e.g. 5.125.)...
Units Unit Cost or Selling Price Date Description Oct. 1 Beginning inventory Oct. 9 Purchase Oct 11 Sale Oct. 17 Purchase Oct. 22 Sale Oct. 25 Purchase Oct. 29 Sale Calculate the weighted-average cost. (Round answer to 3 decimal places, e.g. 5.125.) Weighted average cost per unit $ 89.753 e Textbook and Media List of Accounts 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...
You have the following information for Windsor, Inc. for the month ended October 31, 2022. Windsor uses a periodic method for inventory Date Description Units Unit Cost or Selling Price Oct.1 Beginning inventory 60 Oct. 9 Purchase Sale Oct. 11 Oct. 17 Oct. 22 Oct. 25 Purchase Sale Purchase Oct. 29 Sale Calculate the weighted average cost. (Round answer to 3 decimal places, eg. 5.125.) Weighted average cost per units Calculate ending inventory, cost of goods sold, gross profit under...
You have the following information for Vaughn Manufacturing for the month ended October 31, 2022. Vaughn uses a periodic method for inventory. Date Description Units Unit Cost or Selling Price Oct. 1 Beginning inventory 70 Oct. 9 Purchase Oct. 11 Sale Oct. 17 Purchase Oct. 22 Sale Oct. 25 Purchase Oct. 29 Sale - Your answer is incorrect. Calculate the weighted average cost. (Round answer to 3 decimal places, e.g. 5.125.) Weighted average cost per unit $ 31.468 eTextbook and...
You have the following information for Whispering Winds Corp. for the month ended October 31, 2022. Whispering Winds uses a periodic method for inventory. Date Description Units Unit Cost or Selling Price Oct. 1 Beginning inventory 55 $24 Oct. 9 Purchase 125 26 Oct. 11 Sale 90 35 Oct. 17 Purchase 90 27 Oct. 22 Sale 55 40 Oct. 25 Purchase 65 29 Oct. 29 Sale 100 40 Incorrect answer iconYour answer is incorrect. Calculate the weighted-average cost. (Round answer...
You have the following information for Skysong, Inc. for the month ended October 31, 2022. Skysong uses a periodic method for inventory. Date Description Units Unit Cost or Selling Price Oct. 1 Oct. 9 Oct. 11 Oct. 17 Oct. 22 Beginning inventory Purchase Sale Purchase Sale Oct. 25 Purchase Oct. 29 Sale Calculate the weighted-average cost. (Round answer to 3 decimal places, eg. 5.125.) Weighted average cost per unit $ 35.833 eTextbook and Media List of Accounts Calculate ending inventory,...