18 19 SKU# Description 20 1234567 Sony 5 CD Exchng 21 2345678 Panasonic 3 CD 22 5566778 Samsung Blu Ray 23 9988776 RCA 3 CD Changer Total of All 4 Items 24 25 Gross Margins in Absolute $ US $ Cdn $ Met Cdn $ Targets? # of products on target: Exchange Rate SKU# Overall 1234567 2345678 5566778 998877E

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

how to calculate the  Gross Margin of the table 

2
56049GAWN
4 SKU# Description
1234567 Sony 5 CD Exchng
2345678 Panasonic 3 CD
5566778 Samsung BluRay
9988776 RCA 3 CD Changer
10
11 SKU#
Description
12 1234567 Sony 5 CD Exchng
13 2345678 Panasonic 3 CD
14 5566778 Samsung Blu Ray
15 9988776 RCA 3 CD Changer
16
17
18
19 SKU#
Description
20 1234567 Sony 5 CD Exchng
21 2345678 Panasonic 3 CD
22 5566778 Samsung Blu Ray
9988776 RCA 3 CD Changer
Total of All 4 Items
23
24
25
Sales in Cdn $
Day 1
Day 2
29610.39
98054.1
63867.15
60368.12
84600
30747.49 92272.04
81210.01
Day 3
24787.28
Day 5 Day 6
84209.54 43019.81
96408.06 44655.44 82164.95 63137.21
57047.46
Day 7
18651.55
91636.3
77717.63 85982.78 58038.06 12952.97 32288.93
24832.7 3055.31 27325.85 88318.63 98361.52
Cost of Goods Sold in Cdn $
Day 1 Day 2 Day 3
73540.58 22208.13 18590.46
51093.72 48294.5 76123.56
71464.81 75012.35 68391.51
24566.98 70090.56 19121.18
Gross Margins in Absolute $
Cdn $ US $
Day 4
Day 4
Day 5 Day 6 Day 7
42785.6 62126.3 33658.89 13988.66
35724.35 64663.52 51264.34 73309.04
75664.85 52556.32 11398.61 28414.26
2406.53 21040.9 68005.35 72399.65
Met Cdn $ Targets?
# of products on target:
Week Total in Cdn $
355380.13
502237.23
857617.3E
364913.54
Week Total in Cdn $
Overall
649801.33
400473.03
382902.71
277631.15
Exchange Rate
SKU#
1234567
2345678
5566778
998877E
Transcribed Image Text:2 56049GAWN 4 SKU# Description 1234567 Sony 5 CD Exchng 2345678 Panasonic 3 CD 5566778 Samsung BluRay 9988776 RCA 3 CD Changer 10 11 SKU# Description 12 1234567 Sony 5 CD Exchng 13 2345678 Panasonic 3 CD 14 5566778 Samsung Blu Ray 15 9988776 RCA 3 CD Changer 16 17 18 19 SKU# Description 20 1234567 Sony 5 CD Exchng 21 2345678 Panasonic 3 CD 22 5566778 Samsung Blu Ray 9988776 RCA 3 CD Changer Total of All 4 Items 23 24 25 Sales in Cdn $ Day 1 Day 2 29610.39 98054.1 63867.15 60368.12 84600 30747.49 92272.04 81210.01 Day 3 24787.28 Day 5 Day 6 84209.54 43019.81 96408.06 44655.44 82164.95 63137.21 57047.46 Day 7 18651.55 91636.3 77717.63 85982.78 58038.06 12952.97 32288.93 24832.7 3055.31 27325.85 88318.63 98361.52 Cost of Goods Sold in Cdn $ Day 1 Day 2 Day 3 73540.58 22208.13 18590.46 51093.72 48294.5 76123.56 71464.81 75012.35 68391.51 24566.98 70090.56 19121.18 Gross Margins in Absolute $ Cdn $ US $ Day 4 Day 4 Day 5 Day 6 Day 7 42785.6 62126.3 33658.89 13988.66 35724.35 64663.52 51264.34 73309.04 75664.85 52556.32 11398.61 28414.26 2406.53 21040.9 68005.35 72399.65 Met Cdn $ Targets? # of products on target: Week Total in Cdn $ 355380.13 502237.23 857617.3E 364913.54 Week Total in Cdn $ Overall 649801.33 400473.03 382902.71 277631.15 Exchange Rate SKU# 1234567 2345678 5566778 998877E
Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
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