Make assumptions about amounts for beginning inventory, net purchases, and ending inventory. Then use the pick lists (accessed by clicking in the boxed areas within the Calculation of Cost of Goods Sold section) to select the correct amounts for goods available for sale and cost of goods sold. Correct selections turn applicable boxes green. Enter an amount for beginning inventory >>>> Enter an amount for net purchases >>>> Enter an amount for ending inventory >>>> 0 0 0

Principles of Accounting Volume 1
19th Edition
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax
Chapter10: Inventory
Section: Chapter Questions
Problem 5PA: Use the first-in, first-out (FIFO) cost allocation method, with perpetual inventory updating, to...
icon
Related questions
Topic Video
Question
100%
Make assumptions about amounts for beginning inventory, net purchases, and ending inventory. Then use
the pick lists (accessed by clicking in the boxed areas within the Calculation of Cost of Goods Sold section) to
select the correct amounts for goods available for sale and cost of goods sold. Correct selections turn
applicable boxes green.
Enter an amount for beginning inventory >>>>
Enter an amount for net purchases >>>>
Enter an amount for ending inventory >>>>
Beginning inventory
Plus: Net purchases
Goods available for sale
Less: Ending inventory
Cost of goods sold
Calculation of Cost of Goods Sold
0
0
0
0
0
0
0
0
Transcribed Image Text:Make assumptions about amounts for beginning inventory, net purchases, and ending inventory. Then use the pick lists (accessed by clicking in the boxed areas within the Calculation of Cost of Goods Sold section) to select the correct amounts for goods available for sale and cost of goods sold. Correct selections turn applicable boxes green. Enter an amount for beginning inventory >>>> Enter an amount for net purchases >>>> Enter an amount for ending inventory >>>> Beginning inventory Plus: Net purchases Goods available for sale Less: Ending inventory Cost of goods sold Calculation of Cost of Goods Sold 0 0 0 0 0 0 0 0
Go to eBook and download the Excel document from the
Cost of Goods paragraph section of "MyExceLab" then
solve the Excel problem using the following data:
Beginning Inventory: $10,000
• Purchase for the year: $113,000
●
Freight-in for the shipping under F.O.B Shipping
Point term: $5,000
• Purchase Discount for the year: $12,000
• Purchase Return for the year: $6,000
•
End of the year physical inventory balance:
$35,000
Transcribed Image Text:Go to eBook and download the Excel document from the Cost of Goods paragraph section of "MyExceLab" then solve the Excel problem using the following data: Beginning Inventory: $10,000 • Purchase for the year: $113,000 ● Freight-in for the shipping under F.O.B Shipping Point term: $5,000 • Purchase Discount for the year: $12,000 • Purchase Return for the year: $6,000 • End of the year physical inventory balance: $35,000
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

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
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
College Accounting, Chapters 1-27
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning