Given the following information calculate: Value B. gross cost of merch sold: Cost Retail $80,000.00 $65,000.00 opening inventory $38,400.00 gross purchases $31,200.00 $5,760.00 $12,000.00 returns to vendors net transfers in $14,400.00 $30,000.00 freight $2,000.00 CMU = total merch handled $75,000.00 cost % = $12,000.00 net sales net markdowns employee discounts $0.00 total retail deductions clsoing book inventory closing physical inventory $73,000.00 inventory shortage gross cost of merch sold

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

Please do this in excel and not on paper, thanks!

 

146
147 13
148 Given the following information calculate:
Value
149 B. gross cost of merch sold:
Cost
Retail
150
$80,000.00
$38,400.00
$31,200.00
151
opening inventory
$65,000.00
152
gross purchases
$12,000.00
$30,000.00
$5,760.00
153
154
returns to vendors
$14,400.00
$2,000.00
net transfers in
.55
freight
56
total merch handled
CMU =
57
net sales
$75,000.00 cost % =
58
net markdowns
$12,000.00
$0.00
59
50
51
employee discounts
total retail deductions
clsoing book inventory
2
closing physical inventory
$73,000.00
3
inventory shortage
4
gross cost of merch sold
Transcribed Image Text:146 147 13 148 Given the following information calculate: Value 149 B. gross cost of merch sold: Cost Retail 150 $80,000.00 $38,400.00 $31,200.00 151 opening inventory $65,000.00 152 gross purchases $12,000.00 $30,000.00 $5,760.00 153 154 returns to vendors $14,400.00 $2,000.00 net transfers in .55 freight 56 total merch handled CMU = 57 net sales $75,000.00 cost % = 58 net markdowns $12,000.00 $0.00 59 50 51 employee discounts total retail deductions clsoing book inventory 2 closing physical inventory $73,000.00 3 inventory shortage 4 gross cost of merch sold
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Yields on Money Market Securities
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