Complete the table by computing the missing amounts Sales Ne
Solution
Answer
Sales
Sales Discount
Net Sales
Cost of Goods Sold
Gross Profit
[A]
[B]
[C = A - B]
[D]
[E = C - D]
$ 102,900.00
$ 2,500.00
$ 100,400.00
$ 71,400.00
$ 29,000.00
$ 77,800.00
$ 3,100.00
$ 74,700.00
$ 52,600.00
$ 22,100.00
$ 103,000.00
$ 6,200.00
$ 96,800.00
$ 55,400.00
$ 41,400.00
$ 99,700.00
$ 1,400.00
$ 98,300.00
$ 37,800.00
$ 60,500.00
Sales
Sales Discount
Net Sales
Cost of Goods Sold
Gross Profit
[A]
[B]
[C = A - B]
[D]
[E = C - D]
=100400+2500
2500
=71400+29000
71400
29000
77800
3100
=77800-3100
52600
=74700-52600
103000
=103000-96800
96800
=96800-41400
41400
=98300+1400
1400
98300
37800
=98300-37800
Also, following equations are used to calculate above amounts:
Sales – Sales Discount = Net Sales
Net Sales – Cost of Goods Sold = Gross Profit
| Sales | Sales Discount | Net Sales | Cost of Goods Sold | Gross Profit |
| [A] | [B] | [C = A - B] | [D] | [E = C - D] |
| $ 102,900.00 | $ 2,500.00 | $ 100,400.00 | $ 71,400.00 | $ 29,000.00 |
| $ 77,800.00 | $ 3,100.00 | $ 74,700.00 | $ 52,600.00 | $ 22,100.00 |
| $ 103,000.00 | $ 6,200.00 | $ 96,800.00 | $ 55,400.00 | $ 41,400.00 |
| $ 99,700.00 | $ 1,400.00 | $ 98,300.00 | $ 37,800.00 | $ 60,500.00 |


