Question

Weygandt, Accounting Principles, 13e Help System Announcements CALCULATOR PRINTER VERSION 4 BACK NEXT Exercise 6-17 al-a3 (Video) Vaughn Company reports the following for the month of June. Unit Cost Date Explanation Units Total Cost 200 $5 June 1 12 $1,000 3,200 400 8 Inventory Purchase Purchase Inventory 400 9 3,600 23 30 50 Assume a sale of 500 units occurred on June 15 for a selling price of $10 and a sale of 450 units on June 27 for $11. Your answer is correct. Calculate cost of goods available for sale. The cost of goods available for sale 7800 LINK TO TEXT VIDEO: SIMILAR EXERCISE Your answer is partially correct. Try again. Calculate Moving Averan2 unit cast for us 1 12.15. 222.27 (Daund ansitors to 2 decimal placer A2525 ch zi е 3:09 PM 9/20/2020 142

Answer 1

A B с D E F G H 1 N 3 Moving Average Cost st 5 Unit 6 June.1 7 Inventory 12 Purchases 23 Purchases 30 Inventory Unit Cost Total cost 200 $ 5$ 1,000 400 $ 8 $ 3,200 400 $ 9 $ 3,600 50 00 9 10 11 Unit Balance Average Cost of Inventory Unit Cost goods sold (unit) 500 $ 7.0 $ 3,500.0 100 450 $ 8.60 $ 3,870.00 50 12 15 Sales 27 Sales 13 14 June.1 5.0 15 16 17 $ 12 $ 15 $ 23 $ 27 $ 7.0 7.0 8.60 8.60 18 19 20 21 22 Cost of goods sold $ 7,370 Cost of ending inventory $ 430 23 24 25

Formula:

A B с D E F G Н. 1 2. 3 Moving Average C 4 5 Unit Cost 6 June.1 12 Unit 200 400 400 5 8 Inventory Purchases Purchases Inventory Total cost =D6*E6 =D7*E7 =D8E8 7 8 9 23 19 30 50 10 11 12 Unit 500 15 Sales Sales Average Unit Cost Cost of goods sold Balance Inventory (unit) =C16 =D12*E12 =D6+D7-D12 =C18 =D13*E13 =G12+D8-D13 27 450 13 14 15 16 June. 1 12 17 15 =F6/D6 =(F7+F6)/(D6+D7) =C16 =(F6+F7+F8-F12)/(G12+D8) =C18 18 23 27 19 20 21 22 Cost of goods sold Cost of ending inventory =F12+F13 =G13*C19 23 24 25

----

Hope you Understood.
If you have any doubt please leave a comment.
Thank you.