Trusted by Students Everywhere
Why Choose Us?
0% AI Guarantee

Human-written only.

24/7 Support

Anytime, anywhere.

Plagiarism Free

100% Original.

Expert Tutors

Masters & PhDs.

100% Confidential

Your privacy matters.

On-Time Delivery

Never miss a deadline.

Problem 1 grade Problem 2 Perpetual Inventory System Determine case poads sold and ending inventarusino FFQUFT and average cost wis anasis FIFO Glee Distribution markets CDs of the performing artist Unique

Accounting Nov 02, 2020

Problem 1 grade Problem 2 Perpetual Inventory System Determine case poads sold and ending inventarusino FFQUFT and average cost wis anasis FIFO Glee Distribution markets CDs of the performing artist Unique. At the beginning of October, Glee had in beginning inventory 2,000 of Unique's CDs with a unit cost of $7. During October, Glee made the following purchases of Unique's CDs. Purchases COST OF GOODS SOLD Cost Cost Total Per unit Total Cos Units Per unit Per unit Cost Balance Cost Per unit Total Cost Date Units Units Oct. 3 Oct. 9 Oct. 19 Oct. 25 2,500 @ $8 3,500 @$9 3,000 @ $10 4,000 $11 6 18 75 105 204 value During October, 10,900 units were sold. Instructions (a) Determine the cost of goods available for sale using the periodic inventory system. Value 18 pts. (b) Determine using the periodic inventory system (1) the ending inventory and (2) the cost of goods sold under each of the assumed cost flow methods (FIFO, LIFO and average cost). Prove the accuracy of the cost of goods sold under the FIFO and LIFO methods. Value 75 pts. Problem 2 (a) Determine using the perpetual inventory system (1) the ending inventory and (2) the cost of goods sold under each of the assumed cost flow methods (FIFO, LIFO and average cost). Use the information given, fill the yellow area. Value 105 pts. Date Explanation Units Unit Cost Total Cost Beginning 1-Jan inventory 150 $ 1100 llene los espacios en amarillo 15-Feb Purchases 100 $ 12.00 12-Apr Purchases 200 $ 13.00 5-May Sale 400 6 pts. 3-Jun Purchases 100 $ 14.00 Total Units Purchases sold NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". Problem 1 (a) Determine the cost of goods available for sale. Cost of Goods Sold Ending inventory Date 'Oct. 1 3 COST OF GOODS AVAILABLE FOR SALE Explanation Units Unit Cost Beginning inventory Value Value Purchase Value Value Total Cost ? ? 9 Purchase Value Value ? Perpetual Inventory System LIFO Value ? 19 25 Purchase Purchase Value Value Value ? Purchases Cost Total Per unit Cost COST OF GOODS SOLD Total Units Per unit Cost Cost Balance Cost Total Per unit Cost Total ? ? Date Units Units (b) Determine (1) the ending inventory and (2) the cost of goods sold under each of the assumed cost flow methods (FIFO, LIFO and average cost). Prove the accuracy of the cost of goods sold under the FIFO and LIFO methods. Date Date (1) Ending Inventor - FIFO Units Unit Cost Value | Value Value Value ? ? Total Cost ? ? Date ? Date Date Date Date Date 2 Cost of Goods Sold - FIFO Units Unit Cost Value Value Value Value Value Value Value Value ? Total Cost ? ? ? ? ? Date Date Date (1 Ending Inventor - LIFO Units Unit Cost Value Value Value | Value Total Cost ? ? ? ? ? Perpetual Inventory System WEIGHTED AVERAGE Purchases Cost Total Per unit Cost Sales Cost Units Per unit Total Cost Balance Cost Total Units Per unit Cost Date Units Date Date Date Date Date (2- Cost of Goods Sold -LIFO Units Unit Cost Value Value Value Value Value Value Value Value ? Total Cost ? ? ? ? ? AVERAGE COST Total goods available for sale Total units available Average cost" "Round to two decimal points Value Value ? 1 Ending Inventor - Average Cost Units Unit Cost Total Cost Value Value Value 12 Cost of Goods Sold - Average Cost Units Unit Cost Total Cost Value Value Value
Problem grade Determine cost of goods sold and ending inventory using FIFO, LIFO and average cost with analysis Glee Distribution markets CDs of the performing artist Unique. At the beginning of October, Glee had in beginning inventory 2,000 of Unique's CDs with a unit cost of $7. During October, Glee made the following purchases of Unique's CDs Oct 3 2,500 @ $8 Oct. 93,500 @59 Oct. 193,000 @ $10 Oct. 25 4,000 @ S11 value During October 10,900 units were sold Instructions (a) Determine the cost of goods available for sale using the periodic inventory system. Value 18 pts. (b) Determine using the periodic inventory system (1) the ending inventory and (2) the cost of goods sold under each of the assumed cost flow methods (FIFO, LIFO and average cost). Prove the accuracy of the cost of goods sold under the FIFO and LIFO methods. Value 75 pts 6 18 75 105 204 Problema (a) Determine using the perpetual inventory system (1) the ending inventory and (2) the cost of goods sold under each of the assumed cost flow methods (FIFO, LIFO and average cost). Use the information given till the yellow area Value 105 pts. Date Explanation Units Unit Cost Total Cost Beginning 1-Jan inventory 150 $ 11.00 llene los espacios en amarillo 15-Feb Purchases 100 $ 12.00 12-Apr Purchases 200 $ 13.00 5-May Sale 400 6 pts 3-Jun Purchases 100 $ 14.00 Total Units Purchases sold NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?"

Expert Solution

           

A

         
 

 

Number Of Units & Cost Of Goods Available For Sale

 

 

 

 

Date

Explanation

No. of Units

Cost Per Unit

Cost Of Goods Available For Sales

 

OCT. 1

Beginning Inventory

2000

$7.00

$14,000

 

3

Purchases

2500

$8.00

$20,000

 

9

Purchases

3500

$9.00

$31,500

 

19

Purchases

3000

$10.00

$30,000

 

25

Purchases

4000

$11.00

$44,000

 

 

Total Units Available for Sale

15000

 

$1,39,500

 

 

 

 

 

 
           

B

 

WORKING NOTES :

     
   

Ending Inventory Units

   

Units

   

Total Units Available For Sale

   

15000

   

Less: Sales

   

10900

   

Ending Inventory Units

 

 

4100

           

B

1

Ending Inventory - FIFO

 

 

 

 

 

Date

Units

Cost Per Unit

Total Cost

 

 

Oct. 25

4000

$11.00

$44,000

 

 

19

100

$10.00

$1,000

 

 

Total

4100

 

$45,000

 

 

 

 

 

 
           
 

2

COGS - FIFO

 

 

 

 

 

Date

Units

Cost Per Unit

Total Cost

 

 

Oct. 1

2000

$7.00

$14,000

 

 

3

2500

$8.00

$20,000

 

 

9

3500

$9.00

$31,500

 

 

19

2900

$10.00

$29,000

 

 

Total

10900

 

$94,500

 

 

 

 

 

 
           

B

1

Ending Inventory - LIFO

 

 

 

 

 

Date

Units

Cost Per Unit

Total Cost

 

 

Oct. 1

2000

$7.00

$14,000

 

 

3

2100

$8.00

$16,800

 

 

Total

4100

 

$30,800

           
           
 

2

COGS - LIFO

 

 

 

 

 

Date

Units

Cost Per Unit

Total Cost

 

 

Oct. 25

4000

$11.00

$44,000

 

 

19

3000

$10.00

$30,000

 

 

9

3500

$9.00

$31,500

 

 

3

400

$8.00

$3,200

 

 

Total

10900

 

$1,08,700

 

 

 

 

 

 
           

B

 

Average Cost Per Unit

 

 

 

 

 

Cost Of Goods Available For Sale

A

 

$1,39,500

 

 

Units Available For Sale

B

 

$15,000

 

 

Average Unit Cost

A / B

 

$9.30

 

 

 

 

 

 

           
 

1

Ending Inventory - Weighted Avg.

 

 

 

 

 

 

Units

Avg. Cost Per Unit

Total Cost

 

 

Ending Inventory Units

4100

$9.30

$38,130

 

 

Total

4100

 

$38,130

 

 

 

 

 

 
           
 

2

COGS - Average Cost

 

Download Solution Attachment (PDF/Doc)
Archived Solution
Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In
Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution
Get Custom Quote
Secure Payment