Unformatted Attachment Preview
A
B
C
D
E
F
2
3
4
6
9
10
11
12
13
14
I
INVOICE
J. B. Sherr Co.
5
8
H
Project Sheet 4
Chapter 9 - Mathematics of Buying
1
7
G
Showroom and Warehouse
S
o
l
d
1704 Rollins Road
Oaks Hardware
Burlingame, CA 94010
10136 Fair Oaks Blvd
T
o
S
h
i
p
Telephone: (850) 697-3430
Fair Oaks, CA 95628
Page No. 1 of 1
To Order: 1-800-660-1422
Oaks Hardware
INVOICE DATE
INVOICE NO.
3/17/2005
0000238-IN
10136 Fair Oaks Blvd
T
o
Fair Oaks, CA 95628
15
16 SALESMAN
17
T
a Qty Ord.
18 g
TERMS:
ENTRY NUMBER
Shipped
Unit
ENTRY DATE
SHIPPING DATE
SHIPPING VIA
Stock Number
Description
Sugg. Retail
CUSTOMER ORDER NO/DEPT
Unit Price
Amount
19
1
12
12
Ea
736-080
Impt Natural Sea Sponge
0.00
$
2.400
$
28.80
20
2
1
0
Ea
267-6682
Acrylic Butter Dish
6.39
$
3.768
$
-
21
3
1
1
Ea
267-6683
Acrylic Cream & Sugar Se
6.39
$
3.768
$
3.77
22
4
1
1
Ea
267-6684
Acrylic Napkin Holder
5.29
$
3.140
$
3.14
23
5
6
6
Ea
694-322
Impt Wenol Metal Polish
7.79
$
4.650
$
27.90
24
6
6
6
Ea
694-353
Imptred Bear Polish
7.39
$
4.370
$
26.22
25
7
2
2
Ea
274-10012
Friendship Mixing Bowl
31.50
$
18.750
$
37.50
26
8
1
1
Ea
274-11014
Friendship Mixing Bowl
44.90
$
26.500
$
26.50
27
9
2
2
Ea
274-31008
Flexible Chopping Mats
3.93
$
2.360
$
4.72
28 10
1
1
Ea
589-22153
Corner Sink Shelf w/Suc
2.79
$
1.600
$
1.60
29 11
6
2
Ea
281-7950
Gemco Juicer w/Glass Jar
4.59
$
2.730
$
5.46
30 12
2
2
Ea
54-611
Arden Waffle Towel - Blue
3.19
$
1.900
$
3.80
31 13
2
2
Ea
54-612
Arden Waffle Towel - Gree
3.19
$
1.900
$
3.80
32 14
2
2
Ea
60-6
Ashland Tire Mat 18.5 X
18.75
$
11.250
$
22.50
33 15
2
2
Ea
998-713
3 Half/ Rd Dragon 18 X 30
0.00
$
5.200
$
10.40
34 16
2
2
Ea
998-143
3 Welcome Mat 18 X 30
0.00
$
6.910
$
13.82
35 17
3
3
Ea
998-303
3 MB Plain Mat 18 X 30
0.00
$
8.640
$
25.92
36 18
2
2
Ea
998-504
4 Half-Rd MB Plain 20 X 3
0.00
$
10.550
$
21.10
Sales Tax
Freight
37 19
38 20
39
Non Tax Total
Taxable Total
Misc.
INVOICE TOTAL
40
0
$
266.95 $
16.02
19.45
0
$
302.41
41
ALL ITEMS NOT SHIPPED ARE CANCELLED PLEASE REORDER
Please pay from this
42
invoice.
43
All orders subject to credit acceptance. Prices subject to change without notice. Shortages must be reported with 10
44 days. No returns accepted without authorization. Past due accounts subject to interest (1 1/2% per mo.) plus collection
45
Customer's Copy
charges.
46
Be sure to save your work
20150705215322saccoman_kortnee_copy_of_project_4_11.xlsInvoice
A
1
B
C
E
F
Project Sheet 4
Chapter 9 - Mathematics of Buying
2
3
4 Trade Discount Net Cost Equivalent Single Discount Equivalent
5
15/35
0.5525
44.75%
6
20/20/10
7
40/20/10
8
25/10/20/10
9
33 1/3/20
10
D
List Price
Trade Discount Net Cost
$
148.00
$ 81.77
$ 1,250.00
$ 2,300.00
$ 10,940.00
$ 30,000.00
Be sure to save your work
20150705215322saccoman_kortnee_copy_of_project_4_11.xlsSDE-TradeDiscount-NetCost
A
B
C
2
3
Invoice
Amount
10
E
F
G
H
I
J
Project Sheet 4
Chapter 9 - Mathematics of Buying
1
4
5
6
7
8
9
D
$
$
$
$
$
166.10
96.06
248.00
780.70
262.00
Invoice Date
8-Mar
30-Nov
19-Jul
5-May
15-Jan
Receive
Cash
Cash
Shipping & Goods Date Invoice
Net Cost
Terms
Discount Discount
Final Cost
Insurance Returned
Paid
Decimal
(Yes or Decimal
No)
6/10, n/30
$
5.39 $
14-Mar
Net 30
$
5.22 $
20-Dec
3/15, 1/25, n/60 $
9.45 $
16-Aug
net 30
$
3.80 $ 125.00
1-Jun
2/15, net 30
$
18.18 $ 15.00
23-Jan
Be sure to save your work
20150705215322saccoman_kortnee_copy_of_project_4_11.xlsCash Discounts-1
A
B
C
2
3
Invoice
Amount
11
E
F
G
H
I
Net Cost
Decimal
Net Cost
Project Sheet 4
Chapter 9 - Mathematics of Buying
1
4
5
6
7
8
9
10
D
$
$
$
$
$
$
682.28
194.04
2,960.00
11,450.00
3,250.60
8,518.00
Invoice
Date
Terms
4-Jun
22-Aug
31-Oct
6-Apr
17-Oct
9-Jun
3/20 ROG
5/10-60 ex
2/10 EOM
2/15 prox
3/15-20x
3/20 EOM
Date Good
Received
Date
Invoice Paid
25-Jul
15-Sep
10-Aug
5-Nov
5-Dec
30-Apr
20-Oct
18-Jul
10-Apr
Receive
Cash
Cash Discount
Discount
Decimal
(Yes or No)
Be sure to save your work
20150705215322saccoman_kortnee_copy_of_project_4_11.xlsCash Discounts-2
A
B
C
4
5
6
7
8
9
E
F
G
H
I
J
Project Sheet 4
Chapter 9 - Mathematics of Buying
1
2
3
D
Points (1 pt per cell for input in Column F & G, 1 pt per cell in Columns H-J, 1pt per cell for formulas in Columns H-J)
Receive
Date
Cash
Invoice
Invoice
Partial
Cash
Net Cost
Credit
Balance
Terms
Invoice
Discount
Amount
Date
Payment
Discount
Decimal
Given
Due
Paid
Decimal
(Yes or No)
$ 3,150.00
9-Jan
2/10 EOM
8-Feb
$ 1,862.00
$ 884.00
6-Jun
5/10-30x
10-Jul
$ 209.00
$ 1,920.00
11-Jan
3/10, 2/15. n/30
23-Jan
$ 450.80
$ 6,120.00
4-Sep
4/20 prox
15-Nov
$ 2,016.00
Be sure to save your work
20150705215322saccoman_kortnee_copy_of_project_4_11.xlsPartial Payments
A
B
C
D
E
F
2
3
4
6
9
10
11
12
13
14
I
INVOICE
J. B. Sherr Co.
5
8
H
Project Sheet 4
Chapter 9 - Mathematics of Buying
1
7
G
Showroom and Warehouse
S
o
l
d
1704 Rollins Road
Oaks Hardware
Burlingame, CA 94010
10136 Fair Oaks Blvd
T
o
S
h
i
p
Telephone: (850) 697-3430
Fair Oaks, CA 95628
Page No. 1 of 1
To Order: 1-800-660-1422
Oaks Hardware
INVOICE DATE
INVOICE NO.
3/17/2005
0000238-IN
10136 Fair Oaks Blvd
T
o
Fair Oaks, CA 95628
15
16 SALESMAN
17
T
a Qty Ord.
18 g
TERMS:
ENTRY NUMBER
Shipped
Unit
ENTRY DATE
SHIPPING DATE
SHIPPING VIA
Stock Number
Description
Sugg. Retail
CUSTOMER ORDER NO/DEPT
Unit Price
Amount
19
1
12
12
Ea
736-080
Impt Natural Sea Sponge
0,00
$
2,400
$
28,80
20
2
1
0
Ea
267-6682
Acrylic Butter Dish
6,39
$
3,768
$
-
21
3
1
1
Ea
267-6683
Acrylic Cream & Sugar Se
6,39
$
3,768
$
3,77
22
4
1
1
Ea
267-6684
Acrylic Napkin Holder
5,29
$
3,140
$
3,14
23
5
6
6
Ea
694-322
Impt Wenol Metal Polish
7,79
$
4,650
$
27,90
24
6
6
6
Ea
694-353
Imptred Bear Polish
7,39
$
4,370
$
26,22
25
7
2
2
Ea
274-10012
Friendship Mixing Bowl
31,50
$
18,750
$
37,50
26
8
1
1
Ea
274-11014
Friendship Mixing Bowl
44,90
$
26,500
$
26,50
27
9
2
2
Ea
274-31008
Flexible Chopping Mats
3,93
$
2,360
$
4,72
28 10
1
1
Ea
589-22153
Corner Sink Shelf w/Suc
2,79
$
1,600
$
1,60
29 11
6
2
Ea
281-7950
Gemco Juicer w/Glass Jar
4,59
$
2,730
$
5,46
30 12
2
2
Ea
54-611
Arden Waffle Towel - Blue
3,19
$
1,900
$
3,80
31 13
2
2
Ea
54-612
Arden Waffle Towel - Gree
3,19
$
1,900
$
3,80
32 14
2
2
Ea
60-6
Ashland Tire Mat 18.5 X
18,75
$
11,250
$
22,50
33 15
2
2
Ea
998-713
3 Half/ Rd Dragon 18 X 30
0,00
$
5,200
$
10,40
34 16
2
2
Ea
998-143
3 Welcome Mat 18 X 30
0,00
$
6,910
$
13,82
35 17
3
3
Ea
998-303
3 MB Plain Mat 18 X 30
0,00
$
8,640
$
25,92
36 18
2
2
Ea
998-504
4 Half-Rd MB Plain 20 X 3
0,00
$
10,550
$
21,10
Sales Tax
Freight
37 19
38 20
39
Non Tax Total
Taxable Total
Misc.
INVOICE TOTAL
40
0
$
266,95 $
16,02
19,45
0
$
302,41
41
ALL ITEMS NOT SHIPPED ARE CANCELLED PLEASE REORDER
Please pay from this
42
invoice.
43
All orders subject to credit acceptance. Prices subject to change without notice. Shortages must be reported with 10
44 days. No returns accepted without authorization. Past due accounts subject to interest (1 1/2% per mo.) plus collection
45
Customer's Copy
charges.
46
Be sure to save your work
20150705215346saccoman_kortnee_copy_of_project_4_11.xlsInvoice
A
1
B
C
E
F
Project Sheet 4
Chapter 9 - Mathematics of Buying
2
3
4 Trade Discount Net Cost Equivalent Single Discount Equivalent
5
15/35
0,5525
44,75%
6
20/20/10
7
40/20/10
8
25/10/20/10
9
33 1/3/20
10
D
List Price
Trade Discount Net Cost
$
148,00
$ 81,77
$ 1.250,00
$ 2.300,00
$ 10.940,00
$ 30.000,00
Be sure to save your work
20150705215346saccoman_kortnee_copy_of_project_4_11.xlsSDE-TradeDiscount-NetCost
A
B
C
2
3
Invoice
Amount
10
E
F
G
H
I
J
Project Sheet 4
Chapter 9 - Mathematics of Buying
1
4
5
6
7
8
9
D
$
$
$
$
$
166,10
96,06
248,00
780,70
262,00
Invoice Date
8-Mar
30-Nov
19-Jul
5-May
15-Jan
Receive
Cash
Cash
Shipping & Goods Date Invoice
Net Cost
Terms
Discount Discount
Final Cost
Insurance Returned
Paid
Decimal
(Yes or Decimal
No)
6/10, n/30
$
5,39 $
14-Mar
Net 30
$
5,22 $
20-Dec
3/15, 1/25, n/60 $
9,45 $
16-Aug
net 30
$
3,80 $ 125,00
1-Jun
2/15, net 30
$
18,18 $ 15,00
23-Jan
Be sure to save your work
20150705215346saccoman_kortnee_copy_of_project_4_11.xlsCash Discounts-1
A
B
C
2
3
Invoice
Amount
11
E
F
G
H
I
Net Cost
Decimal
Net Cost
Project Sheet 4
Chapter 9 - Mathematics of Buying
1
4
5
6
7
8
9
10
D
$
$
$
$
$
$
682,28
194,04
2.960,00
11.450,00
3.250,60
8.518,00
Invoice
Date
Terms
4-Jun
22-Aug
31-Oct
6-Apr
17-Oct
9-Jun
3/20 ROG
5/10-60 ex
2/10 EOM
2/15 prox
3/15-20x
3/20 EOM
Date Good
Received
Date
Invoice Paid
25-Jul
15-Sep
10-Aug
5-Nov
5-Dec
30-Apr
20-Oct
18-Jul
10-Apr
Receive
Cash
Cash Discount
Discount
Decimal
(Yes or No)
Be sure to save your work
20150705215346saccoman_kortnee_copy_of_project_4_11.xlsCash Discounts-2
A
B
C
4
5
6
7
8
9
E
F
G
H
I
J
Project Sheet 4
Chapter 9 - Mathematics of Buying
1
2
3
D
Points (1 pt per cell for input in Column F & G, 1 pt per cell in Columns H-J, 1pt per cell for formulas in Columns H-J)
Receive
Date
Cash
Invoice
Invoice
Partial
Cash
Net Cost
Credit
Balance
Terms
Invoice
Discount
Amount
Date
Payment
Discount
Decimal
Given
Due
Paid
Decimal
(Yes or No)
$ 3.150,00
9-Jan
2/10 EOM
8-Feb
$ 1.862,00
$ 884,00
6-Jun
5/10-30x
10-Jul
$ 209,00
$ 1.920,00
11-Jan
3/10, 2/15. n/30
23-Jan
$ 450,80
$ 6.120,00
4-Sep
4/20 prox
15-Nov
$ 2.016,00
Be sure to save your work
20150705215346saccoman_kortnee_copy_of_project_4_11.xlsPartial Payments