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

Quickbooks Online Accounting
3rd Edition
ISBN:9780357391693
Author:Owen
Publisher:Owen
Chapter5: Operating Activities: Purchases And Cash Payments
Section: Chapter Questions
Problem 2.1C
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
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage