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

Intermediate Accounting: Reporting And Analysis
3rd Edition
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Chapter7: Inventories: Cost Measurement And Flow Assumptions
Section: Chapter Questions
Problem 4C
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
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
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage