Beginning inventory, purchases, and sales data for prepaid cell phones for December are as follows: Inventory Purchases Sales Dec. 1 3,800 units at $23 Dec. 10 1,900 units at $25 Dec. 12 2,660 units Dec. 20 1,710 units at $27 Dec. 14 2,280 units Dec. 31 1,140 units Question Content Area a. Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of goods sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 4. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Goods Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column. Schedule of Cost of Goods SoldLIFO MethodPrepaid Cell Phones Date Quantity Purchased Purchases Unit Cost Purchases Total Cost Quantity Sold Cost of Goods Sold Unit Cost Cost of Goods Sold Total Cost Inventory Quantity Inventory Unit Cost Inventory Total Cost Dec. 1 fill in the blank 96b90efbdff2020_1 fill in the blank 96b90efbdff2020_2 fill in the blank 96b90efbdff2020_3 Dec. 10 fill in the blank 96b90efbdff2020_4 fill in the blank 96b90efbdff2020_5 fill in the blank 96b90efbdff2020_6 fill in the blank 96b90efbdff2020_7 fill in the blank 96b90efbdff2020_8 fill in the blank 96b90efbdff2020_9 fill in the blank 96b90efbdff2020_10 fill in the blank 96b90efbdff2020_11 fill in the blank 96b90efbdff2020_12 Dec. 12 fill in the blank 96b90efbdff2020_13 fill in the blank 96b90efbdff2020_14 fill in the blank 96b90efbdff2020_15 fill in the blank 96b90efbdff2020_16 fill in the blank 96b90efbdff2020_17 fill in the blank 96b90efbdff2020_18 fill in the blank 96b90efbdff2020_19 fill in the blank 96b90efbdff2020_20 fill in the blank 96b90efbdff2020_21 Dec. 14 fill in the blank 96b90efbdff2020_22 fill in the blank 96b90efbdff2020_23 fill in the blank 96b90efbdff2020_24 fill in the blank 96b90efbdff2020_25 fill in the blank 96b90efbdff2020_26 fill in the blank 96b90efbdff2020_27 Dec. 20 fill in the blank 96b90efbdff2020_28 fill in the blank 96b90efbdff2020_29 fill in the blank 96b90efbdff2020_30 fill in the blank 96b90efbdff2020_31 fill in the blank 96b90efbdff2020_32 fill in the blank 96b90efbdff2020_33 fill in the blank 96b90efbdff2020_34 fill in the blank 96b90efbdff2020_35 fill in the blank 96b90efbdff2020_36 Dec. 31 fill in the blank 96b90efbdff2020_37 fill in the blank 96b90efbdff2020_38 fill in the blank 96b90efbdff2020_39 fill in the blank 96b90efbdff2020_40 fill in the blank 96b90efbdff2020_41 fill in the blank 96b90efbdff2020_42 fill in the blank 96b90efbdff2020_43 fill in the blank 96b90efbdff2020_44 fill in the blank 96b90efbdff2020_45 Dec. 31 Balances fill in the blank 96b90efbdff2020_46 fill in the blank 96b90efbdff2020_47 Question Content Area b. Based upon the preceding data, would you expect the inventory to be higher or lower using the first-in, first-out method?

Cornerstones of Financial Accounting
4th Edition
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Jay Rich, Jeff Jones
Chapter6: Cost Of Goods Sold And Inventory
Section: Chapter Questions
Problem 67APSA: Inventory Costing Methods Andersons Department Store has the following data for inventory,...
icon
Related questions
Topic Video
Question

Beginning inventory, purchases, and sales data for prepaid cell phones for December are as follows:

Inventory   Purchases   Sales  
Dec. 1 3,800 units at $23 Dec. 10 1,900 units at $25 Dec. 12 2,660 units
    Dec. 20 1,710 units at $27 Dec. 14 2,280 units
        Dec. 31 1,140 units

Question Content Area

a.  Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of goods sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 4. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Goods Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column.

Schedule of Cost of Goods SoldLIFO MethodPrepaid Cell Phones



Date

Quantity
Purchased

Purchases
Unit Cost

Purchases
Total Cost

Quantity
Sold
Cost of
Goods Sold
Unit Cost
Cost of
Goods Sold
Total Cost

Inventory
Quantity

Inventory
Unit Cost

Inventory
Total Cost
Dec. 1             fill in the blank 96b90efbdff2020_1 fill in the blank 96b90efbdff2020_2 fill in the blank 96b90efbdff2020_3
Dec. 10 fill in the blank 96b90efbdff2020_4 fill in the blank 96b90efbdff2020_5 fill in the blank 96b90efbdff2020_6       fill in the blank 96b90efbdff2020_7 fill in the blank 96b90efbdff2020_8 fill in the blank 96b90efbdff2020_9
              fill in the blank 96b90efbdff2020_10 fill in the blank 96b90efbdff2020_11 fill in the blank 96b90efbdff2020_12
Dec. 12       fill in the blank 96b90efbdff2020_13 fill in the blank 96b90efbdff2020_14 fill in the blank 96b90efbdff2020_15 fill in the blank 96b90efbdff2020_16 fill in the blank 96b90efbdff2020_17 fill in the blank 96b90efbdff2020_18
        fill in the blank 96b90efbdff2020_19 fill in the blank 96b90efbdff2020_20 fill in the blank 96b90efbdff2020_21      
Dec. 14       fill in the blank 96b90efbdff2020_22 fill in the blank 96b90efbdff2020_23 fill in the blank 96b90efbdff2020_24 fill in the blank 96b90efbdff2020_25 fill in the blank 96b90efbdff2020_26 fill in the blank 96b90efbdff2020_27
Dec. 20 fill in the blank 96b90efbdff2020_28 fill in the blank 96b90efbdff2020_29 fill in the blank 96b90efbdff2020_30       fill in the blank 96b90efbdff2020_31 fill in the blank 96b90efbdff2020_32 fill in the blank 96b90efbdff2020_33
              fill in the blank 96b90efbdff2020_34 fill in the blank 96b90efbdff2020_35 fill in the blank 96b90efbdff2020_36
Dec. 31       fill in the blank 96b90efbdff2020_37 fill in the blank 96b90efbdff2020_38 fill in the blank 96b90efbdff2020_39 fill in the blank 96b90efbdff2020_40 fill in the blank 96b90efbdff2020_41 fill in the blank 96b90efbdff2020_42
              fill in the blank 96b90efbdff2020_43 fill in the blank 96b90efbdff2020_44 fill in the blank 96b90efbdff2020_45
Dec. 31 Balances         fill in the blank 96b90efbdff2020_46     fill in the blank 96b90efbdff2020_47
 

Question Content Area

b.  Based upon the preceding data, would you expect the inventory to be higher or lower using the first-in, first-out method?

 
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Accounting for Merchandise Inventory
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781305088436
Author:
Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Financial Accounting
Financial Accounting
Accounting
ISBN:
9781337272124
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning