Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ATV Co. began operations on March 1 and uses a perpetual inventory system. It entered into purchases and sales for March as shown in the

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
ATV Co. began operations on March 1 and uses a perpetual inventory system. It entered into purchases and sales for March as shown in the Tableau Dashboard March Thursday Friday Saturday Sunday Monday Legend No Purchases or Sal.. Purchases Sales 2 3 3 5 6 7 8 10 11 12 13 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 March 1: Purchase 100 units, $50 each March 5: Purchase 400 units, $55 each March 9: Sales 420 units, $85 each March 18: Purchase 120 units, $60 each March 25: Purchase 200 units, $62 each March 29: Sales 160 units, $95 each Cost of Goods Sold Ending Inventory Required Required 2 Required 3 Compute the cost assigned to ending inventory using FIFO. Periodic FIFO Cost of Goods Available for Sale Cost of of Date Cost per Goods units unit Available for Sale March 1 100 $ 50.00 $ 5,000 March 5 400$ 55.00 22.000 March 18 120$ 60.00 7.200 March 25 200$ 62.00 12.400 Total 820 46,600 of units sold Cost per unit Cost of Goods Sold of units In ending Inventory Cost per unit Ending Inventory $ $ 0 0 OR 0 100 $ 50.00 500 $ 55.00 200 $ 60.00 400 3 3 62.00 1.200 5,000 27,500 12,000 24,800 69,300 0 o 0 $ Required 1 Requed 2 Required 3 Ending Inventory Compute the cost assigned to ending inventory using LIFO. Periodic LIFO Cost of Goods Available for Sale Cost of Goods Sold Cost of Date # of units Cost per Goods # of units Cost of Cost per unit Available sold Goods unit Sold for Sale March 1 100 $ 50.00 $ 5,000 0 March 5 s 55.00 22.000 0 % March 18 S 60.00 7,200 0 March 25 200$ 62.00 12,400 Total 820 $ 46,600 0 # of units in ending inventory Cost per unit Ending Inventory 400 120 OOOO 100$ 50.00 500 S 55.00 200 $ 60.00 400 $ 62.00 1,200 $ 5.000 27,500 12,000 24,800 $ 69,300 0 Required 1 Required 2 tequired 3 Compute the cost assigned to ending inventory using Weighted Average. (Round average cost per unit to 2 decimal places.) Average Cost Cost of Goods Available for Sale Cost of Goods Sold Ending Inventory Average Cost of # of # of Date Goods Average Cost of # of units Average units Cost Available units Cost Goods in ending Cost Ending per unit sold for Sale per Unit Sold inventory Inventory March 1 100 $ 5,000.00 March 5 400 $ 22,000.00 March 18 120 $ 7,200.00 March 25 200 $ 12,400.00 Total 820 $ 46,600.00 0 1,200 $ per unit OOO OOOO 580 0

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Game Theory Basics

Authors: Bernhard Von Stengel

1st Edition

1108910114, 9781108910118

Students also viewed these Accounting questions