Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ATV Company began operations on March 1 and uses a periodic 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
image text in transcribed
image text in transcribed
ATV Company began operations on March 1 and uses a periodic inventory system It entered into purchases and sales for March as shown in the Tableau Dashboard. March Sunday Monday Tuesday Wednesday Thursday Friday Saturday Legend No Purchases or Sales Purchases Sales 2 Purchase 100 units $50 each 3 4 5 6 7 00 9 3 4 5 6 7 8 Purchase 400 units $55 each 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 3 4 6 7 8 Sales 420 units $85 each 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 3 5 6 7 8 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Purchase 120 units S60 each 24 25 26 27 28 29 30 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 27 28 29 Purchase 200 units 562 each 30 3 4 5 6 7 8 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Sales 160 units S95 each Date Cost per March 1 March 5 March 18 March 25 Total Periodic LIFO Check my work Cost of Goods of units of units Cost per unit Available for of units Cost per unit Cost of Goods sold Ending In ending Sale Sold unit inventory Inventory 1001 s 50.00 $ 5000 1001 s 50.00 5,000 0 400 s 55.00 22.000 400 $ 55.00 22 000 120 5 60.00 7,200 80 $ 60.00 4.800 40 $ 60.00 2.400 2005 62.00 12.400 0 200$ 62.00 12 400 820 5 46.600 580 $ 31 800 240 5 14,800 Cost of Goods Available for Sale Cost of Goods Sold Ending Inventory Cost of Goods #of units Cost per unit Available for # of units Cost Cost per Cost of Goods of units sold per unit Sale Ending in ending Sold Inventory unit Inventory 100 S 50.00 5 5.000 0 100 s 50.00 5 5,000 400 $ 5500 22.000 260 5 5500 14300 14015 55.00 7.700 120 5 60.00 7 200 1201 s 50.00 7200 0 2005 62.00 12.400 2005 5200 12400 820 5 46.600 580 5 33.900 240 s 12,700 Date March 1 March 5 March 18 March 25 Total Gross Profit FIFO LIFO

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

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

Financial Statements Analysis Cases From Corporate India

Authors: Sandeep Goel

1st Edition

1138663921, 9781138663923

More Books

Students also viewed these Accounting questions