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

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education