Sales Figures - December 2020

Sales Person Week 1 Week 2 Week 3 Week 4 Totals

H. James $ 9,550 $ 9,230 $ 8,500 $ 8,965 $ 36,245
K. Dunn $ 5,975 $ 6,900 $ 8,500 $ 10,100 $ 31,475
L. Carrie $ 7,425 $ 8,580 $ 9,910 $ 7,512 $ 33,427
R. Smith $ 9,560 $ 10,150 $ 10,200 $ 9,795 $ 39,705
D. O'Brian $ 7,892 $ 7,695 $ 9,520 $ 10,252 $ 35,359
Weekly Total $ 40,402 $ 42,555

Current number of sales people who haved reached their goal: 3

TRUE
FALSE
 Monthly Goal: $ 34,000.00

Was Goal Met? Bonus Status

YES BONUS
NO NO BONUS
NO NO BONUS
YES BONUS
YES NO BONUS
Month Store # SKU Sales Units Store # Total Units Total Sales
JAN 1000 E0028M $ 9,660 345 3000 17,538 $491,064
JAN 1050 E0028M $ 5,936 212 SKU # Total Units Total Sales
JAN 2000 E0028M $ 10,136 362 E0032M 7,357 $7,357
JAN 2050 E0028M $ 3,388 121
JAN 3000 E0028M $ 14,056 502
JAN 3050 E0028M $ 10,136 362
JAN 1000 E0030M $ 14,588 521
JAN 1050 E0030M $ 6,552 234
JAN 2000 E0030M $ 11,788 421
JAN 2050 E0030M $ 9,072 324
JAN 3000 E0030M $ 3,388 121
JAN 3050 E0030M $ 15,176 542
JAN 1000 E0032M $ 5,964 213
JAN 1050 E0032M $ 6,748 241
JAN 2000 E0032M $ 11,508 411
JAN 2050 E0032M $ 3,416 122
JAN 3000 E0032M $ 14,588 521
JAN 3050 E0032M $ 17,640 630
JAN 1000 E0034M $ 9,856 352
JAN 1050 E0034M $ 9,016 322
JAN 2000 E0034M $ 17,976 642
JAN 2050 E0034M $ 14,616 522
JAN 3000 E0034M $ 3,724 133
JAN 3050 E0034M $ 12,712 454
JAN 1000 E0036M $ 16,828 601
JAN 1050 E0036M $ 14,056 502
JAN 2000 E0036M $ 8,456 302
JAN 2050 E0036M $ 17,808 636
JAN 3000 E0036M $ 3,416 122
JAN 3050 E0036M $ 13,020 465
FEB 1000 E0028M $ 17,780 635
FEB 1050 E0028M $ 7,140 255
FEB 2000 E0028M $ 7,448 266
FEB 2050 E0028M $ 6,608 236
FEB 3000 E0028M $ 9,856 352
FEB 3050 E0028M $ 10,248 366
FEB 1000 E0030M $ 14,616 522
FEB 1050 E0030M $ 11,816 422
FEB 2000 E0030M $ 14,896 532
FEB 2050 E0030M $ 3,724 133
FEB 3000 E0030M $ 14,616 522
FEB 3050 E0030M $ 9,016 322
FEB 1000 E0032M $ 11,928 426
FEB 1050 E0032M $ 11,480 410
FEB 2000 E0032M $ 8,960 320
FEB 2050 E0032M $ 18,284 653
FEB 3000 E0032M $ 14,028 501
FEB 3050 E0032M $ 11,256 402
FEB 1000 E0034M $ 11,760 420
FEB 1050 E0034M $ 10,080 360
FEB 2000 E0034M $ 11,760 420
FEB 2050 E0034M $ 8,484 303
FEB 3000 E0034M $ 16,856 602
FEB 3050 E0034M $ 14,560 520
FEB 1000 E0036M $ 8,456 302
FEB 1050 E0036M $ 5,684 203
FEB 2000 E0036M $ 5,740 205
FEB 2050 E0036M $ 11,228 401
FEB 3000 E0036M $ 17,360 620
FEB 3050 E0036M $ 6,524 233
MAR 1000 E0028M $ 7,084 253
MAR 1050 E0028M $ 16,828 601
MAR 2000 E0028M $ 12,096 432
MAR 2050 E0028M $ 14,616 522
MAR 3000 E0028M $ 3,724 133
MAR 3050 E0028M $ 14,616 522
MAR 1000 E0030M $ 9,016 322
MAR 1050 E0030M $ 11,928 426
MAR 2000 E0030M $ 11,480 410
MAR 2050 E0030M $ 8,960 320
MAR 3000 E0030M $ 18,284 653
MAR 3050 E0030M $ 14,028 501
MAR 1000 E0032M $ 11,256 402
MAR 1050 E0032M $ 11,760 420
MAR 2000 E0032M $ 10,080 360
MAR 2050 E0032M $ 11,760 420
MAR 3000 E0032M $ 8,484 303
MAR 3050 E0032M $ 16,856 602
MAR 1000 E0034M $ 14,560 520
MAR 1050 E0034M $ 8,456 302
MAR 2000 E0034M $ 5,684 203
MAR 2050 E0034M $ 5,740 205
MAR 3000 E0034M $ 5,936 212
MAR 3050 E0034M $ 10,136 362
MAR 1000 E0036M $ 3,388 121
MAR 1050 E0036M $ 14,056 502
MAR 2000 E0036M $ 10,136 362
MAR 2050 E0036M $ 14,588 521
MAR 3000 E0036M $ 6,552 234
MAR 3050 E0036M $ 11,788 421
JAN 1000 B0028M $ 9,072 324
JAN 1050 B0028M $ 3,388 121
JAN 2000 B0028M $ 15,176 542
JAN 2050 B0028M $ 5,964 213
JAN 3000 B0028M $ 3,724 133
JAN 3050 B0028M $ 14,616 522
JAN 1000 B0030M $ 9,016 322
JAN 1050 B0030M $ 11,928 426
JAN 2000 B0030M $ 11,480 410
JAN 2050 B0030M $ 8,960 320
JAN 3000 B0030M $ 18,284 653
JAN 3050 B0030M $ 14,028 501
JAN 1000 B0032M $ 11,256 402
JAN 1050 B0032M $ 11,760 420
JAN 2000 B0032M $ 10,080 360
JAN 2050 B0032M $ 11,760 420
JAN 3000 B0032M $ 8,484 303
JAN 3050 B0032M $ 16,856 602
JAN 1000 B0034M $ 14,560 520
JAN 1050 B0034M $ 8,456 302
JAN 2000 B0034M $ 5,684 203
JAN 2050 B0034M $ 5,740 205
JAN 3000 B0034M $ 5,936 212
JAN 3050 B0034M $ 10,136 362
JAN 1000 B0036M $ 3,388 121
JAN 1050 B0036M $ 14,056 502
JAN 2000 B0036M $ 10,136 362
JAN 2050 B0036M $ 14,588 521
JAN 3000 B0036M $ 6,552 234
JAN 3050 B0036M $ 11,788 421
FEB 1000 B0028M $ 9,072 324
FEB 1050 B0028M $ 3,388 121
FEB 2000 B0028M $ 15,176 542
FEB 2050 B0028M $ 5,964 213
FEB 3000 B0028M $ 14,588 521
FEB 3050 B0028M $ 17,640 630
FEB 1000 B0030M $ 9,856 352
FEB 1050 B0030M $ 9,016 322
FEB 2000 B0030M $ 17,976 642
FEB 2050 B0030M $ 14,616 522
FEB 3000 B0030M $ 3,724 133
FEB 3050 B0030M $ 12,712 454
FEB 1000 B0032M $ 16,828 601
FEB 1050 B0032M $ 14,056 502
FEB 2000 B0032M $ 8,456 302
FEB 2050 B0032M $ 17,808 636
FEB 3000 B0032M $ 3,416 122
FEB 3050 B0032M $ 13,020 465
FEB 1000 B0034M $ 17,780 635
FEB 1050 B0034M $ 7,140 255
FEB 2000 B0034M $ 7,448 266
FEB 2050 B0034M $ 6,608 236
FEB 3000 B0034M $ 9,856 352
FEB 3050 B0034M $ 10,248 366
FEB 1000 B0036M $ 14,616 522
FEB 1050 B0036M $ 11,816 422
FEB 2000 B0036M $ 14,896 532
FEB 2050 B0036M $ 3,724 133
FEB 3000 B0036M $ 14,616 522
FEB 3050 B0036M $ 9,016 322
MAR 1000 B0028M $ 5,936 212
MAR 1050 B0028M $ 10,136 362
MAR 2000 B0028M $ 3,388 121
MAR 2050 B0028M $ 14,056 502
MAR 3000 B0028M $ 10,136 362
MAR 3050 B0028M $ 14,588 521
MAR 1000 B0030M $ 6,552 234
MAR 1050 B0030M $ 11,788 421
MAR 2000 B0030M $ 9,072 324
MAR 2050 B0030M $ 3,388 121
MAR 3000 B0030M $ 15,176 542
MAR 3050 B0030M $ 5,964 213
MAR 1000 B0032M $ 14,588 521
MAR 1050 B0032M $ 17,640 630
MAR 2000 B0032M $ 9,856 352
MAR 2050 B0032M $ 9,016 322
MAR 3000 B0032M $ 17,976 642
MAR 3050 B0032M $ 14,616 522
MAR 1000 B0034M $ 3,724 133
MAR 1050 B0034M $ 12,712 454
MAR 2000 B0034M $ 16,828 601
MAR 2050 B0034M $ 14,056 502
MAR 3000 B0034M $ 8,456 302
MAR 3050 B0034M $ 17,808 636
MAR 1000 B0036M $ 3,416 122
MAR 1050 B0036M $ 13,020 465
MAR 2000 B0036M $ 17,780 635
MAR 2050 B0036M $ 7,140 255
MAR 3000 B0036M $ 7,448 266
MAR 3050 B0036M $ 6,608 236
JAN 1000 C0028M $ 9,856 352
JAN 1050 C0028M $ 10,248 366
JAN 2000 C0028M $ 14,616 522
JAN 2050 C0028M $ 11,816 422
JAN 3000 C0028M $ 14,896 532
JAN 3050 C0028M $ 3,724 133
JAN 1000 C0030M $ 14,616 522
JAN 1050 C0030M $ 9,016 322
JAN 2000 C0030M $ 3,724 133
JAN 2050 C0030M $ 14,616 522
JAN 3000 C0030M $ 9,016 322
JAN 3050 C0030M $ 11,928 426
JAN 1000 C0032M $ 11,480 410
JAN 1050 C0032M $ 8,960 320
JAN 2000 C0032M $ 18,284 653
JAN 2050 C0032M $ 14,028 501
JAN 3000 C0032M $ 11,256 402
JAN 3050 C0032M $ 11,760 420
JAN 1000 C0034M $ 10,080 360
JAN 1050 C0034M $ 11,760 420
JAN 2000 C0034M $ 8,484 303
JAN 2050 C0034M $ 16,856 602
JAN 3000 C0034M $ 14,560 520
JAN 3050 C0034M $ 8,456 302
JAN 1000 C0036M $ 5,684 203
JAN 1050 C0036M $ 14,588 521
JAN 2000 C0036M $ 17,640 630
JAN 2050 C0036M $ 9,856 352
JAN 3000 C0036M $ 9,016 322
JAN 3050 C0036M $ 17,976 642
FEB 1000 C0028M $ 14,616 522
FEB 1050 C0028M $ 3,724 133
FEB 2000 C0028M $ 12,712 454
FEB 2050 C0028M $ 16,828 601
FEB 3000 C0028M $ 14,056 502
FEB 3050 C0028M $ 8,456 302
FEB 1000 C0030M $ 17,808 636
FEB 1050 C0030M $ 3,416 122
FEB 2000 C0030M $ 13,020 465
FEB 2050 C0030M $ 17,780 635
FEB 3000 C0030M $ 7,140 255
FEB 3050 C0030M $ 7,448 266
FEB 1000 C0032M $ 6,608 236
FEB 1050 C0032M $ 9,856 352
FEB 2000 C0032M $ 10,248 366
FEB 2050 C0032M $ 14,616 522
FEB 3000 C0032M $ 11,816 422
FEB 3050 C0032M $ 14,896 532
FEB 1000 C0034M $ 3,724 133
FEB 1050 C0034M $ 14,616 522
FEB 2000 C0034M $ 9,016 322
FEB 2050 C0034M $ 5,936 212
FEB 3000 C0034M $ 10,136 362
FEB 3050 C0034M $ 3,388 121
FEB 1000 C0036M $ 14,056 502
FEB 1050 C0036M $ 10,136 362
FEB 2000 C0036M $ 14,588 521
FEB 2050 C0036M $ 6,552 234
FEB 3000 C0036M $ 11,788 421
FEB 3050 C0036M $ 9,072 324
MAR 1000 C0028M $ 3,388 121
MAR 1050 C0028M $ 15,176 542
MAR 2000 C0028M $ 5,964 213
MAR 2050 C0028M $ 3,724 133
MAR 3000 C0028M $ 14,616 522
MAR 3050 C0028M $ 9,016 322
MAR 1000 C0030M $ 11,928 426
MAR 1050 C0030M $ 11,480 410
MAR 2000 C0030M $ 8,960 320
MAR 2050 C0030M $ 18,284 653
MAR 3000 C0030M $ 14,028 501
MAR 3050 C0030M $ 11,256 402
MAR 1000 C0032M $ 11,760 420
MAR 1050 C0032M $ 10,080 360
MAR 2000 C0032M $ 11,760 420
MAR 2050 C0032M $ 8,484 303
MAR 3000 C0032M $ 16,856 602
MAR 3050 C0032M $ 14,560 520
MAR 1000 C0034M $ 8,456 302
MAR 1050 C0034M $ 5,684 203
MAR 2000 C0034M $ 5,740 205
MAR 2050 C0034M $ 3,724 133
MAR 3000 C0034M $ 14,616 522
MAR 3050 C0034M $ 9,016 322
MAR 1000 C0036M $ 11,928 426
MAR 1050 C0036M $ 11,480 410
MAR 2000 C0036M $ 8,960 320
MAR 2050 C0036M $ 18,284 653
MAR 3000 C0036M $ 14,028 501
MAR 3050 C0036M $ 11,256 402
Emp ID First Name Last Name Dept Pay Rate
1054 Howard Smith AT $ 11.25
1056 Joe Gonzales AT $ 12.25
1067 Gail Scote AT $ 14.55
1075 Sheryl Kane AD $ 11.25
1078 Kendrick Hapsbuch AC $ 10.20
1152 Mark Henders AD $ 12.25
1196 Katie Atherton HR $ 9.95
1284 Frank Bellwood MK $ 12.30
EMP ID NOT FOUND #N/A #N/A #N/A
EMP ID NOT FOUND #N/A #N/A #N/A
EMP ID NOT FOUND #N/A #N/A #N/A
1302 Randy Sindole MK $ 14.25
1310 Ellen Smith MF $ 11.50
1329 Tuome Vuanuo AC $ 10.35
1333 Tadeuz Szcznyck HR $ 10.15
1368 Tammy Wu AD $ 12.25
Emp ID First Name Last Name Dept
1054 Howard Smith AT
1056 Joe Gonzales AT
1067 Gail Scote AT
1075 Sheryl Kane AD
1078 Kendrick Hapsbuch AC
1152 Mark Henders AD
1196 Katie Atherton HR
1284 Frank Bellwood MK

#N/A #N/A #N/A

#N/A #N/A #N/A
#N/A #N/A #N/A
1302 Randy Sindole MK
1310 Ellen Smith MF
1329 Tuome Vuanuo AC
1333 Tadeuz Szcznyck HR
1368 Tammy Wu AD
 Pay Rate
$ 11.25
$ 12.25
$ 14.55
$ 11.25
$ 10.20
$ 12.25
$ 9.95
$ 12.30

#N/A
#N/A
#N/A
$ 14.25
$ 11.50
$ 10.35
$ 10.15
$ 12.25
Emp ID Last Name First Name Dept E-mail Phone Ext
1054 Smith Howard AT howards 148
1056 Gonzales Joe AT joeg 121
1067 Scote Gail AT gails 123
1075 Kane Sheryl AD sherylk 126
1078 Hapsbuch Kendrick AC kendrickh 101
1152 Henders Mark AD markh 118
1196 Atherton Katie HR katiea 289
1284 Bellwood Frank MK frankb 124
1290 Cooper Linda AD lindac 113
1293 Cronwith Brent HR brentc 205
1299 Simpson Sandrae MF sandraes 127
1302 Sindole Randy MK randys 139
1310 Smith Ellen MF ellens 137
1329 Vuanuo Tuome AC tuomev 151
1333 Szcznyck Tadeuz HR tadeuzs 122
1368 Wu Tammy AD tammyw 132
1509 Kegler Pam AT pamk 135
1516 Bell Tom AC tomb 105
1529 Kellerman Tommie MK tomk 129
1656 Kourios Theo MF theok 149
1672 Dixon-Waite Sherrie MF sherried 114
1673 Boughton Frank AD fboughton 112
1676 Miller Janet MK janetm 115
1721 Alstain Isolde HR isoldea 102
1723 Sammler Mark MK marks 145
1758 Brwyne Melia AC meliab 107
1792 Barton Eileen AT eileenb 111
1814 Al-Sabah Daoud HR daouda 103
1908 Zostoc Melissa AT melissaz 152
1931 Mueller Ursula AC ursulam 110
1960 Fontaine Jean MF jeanf 150
1964 Corwick Rob AC robertc 108
1975 Franklin Larry AC larryf 125
1983 Corwick Judy AT judyc 154
1990 Chang Jessica MF jessc 198
1995 Mivelli Maria AT mariam 198
1999 Atherly Katherine HR kathya 428
Location Hire Date Pay Rate
Building 1 16-Apr-91 $ 11.25
Building 1 25-Oct-79 $ 12.25
Building 1 20-Sep-87 $ 14.55
Building 2 07-Aug-92 $ 11.25
Building 2 01-Apr-86 $ 10.20
Building 2 21-Jan-90 $ 12.25
Building 3 01-Apr-98 $ 9.95
Building 1 04-Jan-85 $ 12.30
Building 2 03-Jan-85 $ 13.25
Building 3 14-Sep-84 $ 10.20
Building 1 21-Dec-89 $ 12.20
Building 1 06-Aug-84 $ 14.25
Building 1 04-Oct-86 $ 11.50
Building 2 22-Feb-89 $ 10.35
Building 3 16-Apr-90 $ 10.15
Building 2 11-Mar-83 $ 12.25
Building 1 19-Jun-85 $ 13.25
Building 2 06-Mar-85 $ 9.50
Building 1 28-Jan-87 $ 11.30
Building 1 14-Dec-87 $ 12.35
Building 1 16-Apr-90 $ 11.90
Building 2 25-Mar-92 $ 11.85
Building 1 26-Oct-81 $ 10.75
Building 3 06-Aug-90 $ 9.75
Building 1 10-Feb-78 $ 13.95
Building 2 18-Mar-82 $ 11.20
Building 1 24-Dec-90 $ 10.30
Building 3 04-Mar-89 $ 12.25
Building 1 15-May-84 $ 10.25
Building 2 20-Jun-89 $ 9.85
Building 1 13-Nov-86 $ 11.65
Building 2 17-Nov-91 $ 9.25
Building 2 01-Mar-96 $ 9.25
Building 1 28-Jun-97 $ 11.00
Building 1 14-Feb-98 $ 10.95
Building 1 01-Mar-98 $ 11.75
Building 3 05-Jul-98 $ 10.15
 Inventory Status Check
Enter Product Code Here: XP200
Warehouse 1 Inventory: 150
Warehouse 2 Inventory: 110
Warehouse 3 Inventory: 115

Enter Product Code Here: XP200

Warehouse 1 Inventory: 150

Warehouse 2 Inventory: 110
Warehouse 3 Inventory: 115
Product Code: XP100 XP200 XP300 AX10 AX25 AX50
Warehouse 1 120 150 135 90 95 140
Warehouse 2 55 110 75 95 75 55
Warehouse 3 70 115 65 55 85 65
 RETURNS VALUE RETURNS NUMERIC
AT A SPECIFIC POSITION OF A
POSITION VALUE
EMP ID INDEX MATCH INDEX & MATCH
1054 AD 1 AT
1078 113 5 AC
1284 8 MK
1299 11 MF
1329 14 AC
1509 17 AT
Last Name First Name Dept Emp ID E-mail Phone Ext
Smith Howard AT 1054 howards 148
Gonzales Joe AT 1056 joeg 121
Scote Gail AT 1067 gails 123
Kane Sheryl AD 1075 sherylk 126
Hapsbuch Kendrick AC 1078 kendrickh 101
Henders Mark AD 1152 markh 118
Atherton Katie HR 1196 katiea 289
Bellwood Frank MK 1284 frankb 124
Cooper Linda AD 1290 lindac 113
Cronwith Brent HR 1293 brentc 205
Simpson Sandrae MF 1299 sandraes 127
Sindole Randy MK 1302 randys 139
Smith Ellen MF 1310 ellens 137
Vuanuo Tuome AC 1329 tuomev 151
Szcznyck Tadeuz HR 1333 tadeuzs 122
Wu Tammy AD 1368 tammyw 132
Kegler Pam AT 1509 pamk 135
Bell Tom AC 1516 tomb 105
Kellerman Tommie MK 1529 tomk 129
Kourios Theo MF 1656 theok 149
Dixon-Waite Sherrie MF 1672 sherried 114
Boughton Frank AD 1673 fboughton 112
Miller Janet MK 1676 janetm 115
Alstain Isolde HR 1721 isoldea 102
Sammler Mark MK 1723 marks 145
Brwyne Melia AC 1758 meliab 107
Barton Eileen AT 1792 eileenb 111
Al-Sabah Daoud HR 1814 daouda 103
Zostoc Melissa AT 1908 melissaz 152
Mueller Ursula AC 1931 ursulam 110
Fontaine Jean MF 1960 jeanf 150
Corwick Rob AC 1964 robertc 108
Franklin Larry AC 1975 larryf 125
Corwick Judy AT 1983 judyc 154
Chang Jessica MF 1990 jessc 198
Mivelli Maria AT 1995 mariam 198
Atherly Katherine HR 1999 kathya 428
Location Hire Date Pay Rate
Building 1 16-Apr-91 $ 11.25
Building 1 25-Oct-79 $ 12.25
Building 1 20-Sep-87 $ 14.55
Building 2 07-Aug-92 $ 11.25
Building 2 01-Apr-86 $ 10.20
Building 2 21-Jan-90 $ 12.25
Building 3 01-Apr-98 $ 9.95
Building 1 04-Jan-85 $ 12.30
Building 2 03-Jan-85 $ 13.25
Building 3 14-Sep-84 $ 10.20
Building 1 21-Dec-89 $ 12.20
Building 1 06-Aug-84 $ 14.25
Building 1 04-Oct-86 $ 11.50
Building 2 22-Feb-89 $ 10.35
Building 3 16-Apr-90 $ 10.15
Building 2 11-Mar-83 $ 12.25
Building 1 19-Jun-85 $ 13.25
Building 2 06-Mar-85 $ 9.50
Building 1 28-Jan-87 $ 11.30
Building 1 14-Dec-87 $ 12.35
Building 1 16-Apr-90 $ 11.90
Building 2 25-Mar-92 $ 11.85
Building 1 26-Oct-81 $ 10.75
Building 3 06-Aug-90 $ 9.75
Building 1 10-Feb-78 $ 13.95
Building 2 18-Mar-82 $ 11.20
Building 1 24-Dec-90 $ 10.30
Building 3 04-Mar-89 $ 12.25
Building 1 15-May-84 $ 10.25
Building 2 20-Jun-89 $ 9.85
Building 1 13-Nov-86 $ 11.65
Building 2 17-Nov-91 $ 9.25
Building 2 01-Mar-96 $ 9.25
Building 1 28-Jun-97 $ 11.00
Building 1 14-Feb-98 $ 10.95
Building 1 01-Mar-98 $ 11.75
Building 3 05-Jul-98 $ 10.15
 SKU Number Product Name Retail Price Supplier ID Part #
ACM110WW Windshield Wipers #110 $13.65 ACM 110
ACM111WW Windshield Wipers #111 $12.19 ACM 111
ACM150WW Windshield Wipers #150 $10.89 ACM 150
ACM321DP Drain Plug #321 $9.75 ACM 321
ACM322DP Drain Plug #322 $9.59 ACM 322
ACM325DP Drain Plug #325 $10.40 ACM 325
ACM330DP Drain Plug #330 $10.56 ACM 330
ACM450DP Drain Plug #450 $9.75 ACM 450
ACM460DP Drain Plug #460 $9.75 ACM 460
AST530OL 5W30 $4.06 AST 530
AST100TF Automatic Transmission Fluid $5.04 AST 100
AST130OL 10W30 $3.90 AST 130
AST140OL 10W40 $4.55 AST 140
AST300GO Gear Oil $5.20 AST 300
AST121BF Brake Fluid $7.31 AST 121
AST132PS Power Steering Fluid $6.50 AST 132
AST2050995 20W50 $4.55 AST 205
BVR590WF Windshield Washer Fluid $14.30 BVR 590
BVR690AF Anti-Freeze $13.81 BVR 690
TRA203OF Oil Filter #203 $7.31 TRA 203
TRA205OF Oil Filter #205 $7.31 TRA 205
TRA207OF Oil Filter #207 $7.31 TRA 207
TRA310OF Oil Filter #310 $7.64 TRA 310
TRA610OF Oil Filter #610 $6.14 TRA 610
Product Code Num Chars
WW 8
WW 8
WW 8
DP 8
DP 8
DP 8
DP 8
DP 8
DP 8
OL 8
TF 8
OL 8
OL 8
GO 8
BF 8
PS 8
0995 10
WF 8
AF 8
OF 8
OF 8
OF 8
OF 8
OF 8
Name First Name Last Name
Patrick Marleau Patrick Marleau
Joe Thornton Joe Thornton
Brent Burns Brent Burns
Joe Pavelski Joe Pavelski
Martin Jones Martin Jones
Last Name First Name Full Name:
Smith Howard Howard Smith
Gonzales Joe Joe Gonzales
Scote Gail
Kane Sheryl
Hapsbuch Kendrick
Henders Mark
Atherton Katie
Bellwood Frank
Cooper Linda
Cronwith Brent
Simpson Sandrae
Sindole Randy
Smith Ellen
Vuanuo Tuome
Szcznyck Tadeuz
Wu Tammy
 Sales Figures - December 2015

Sales Person Week 1 Week 2 Week 3 Week 4 Totals

H. James $ 9,550 $ 9,230 $ 8,500 $ 8,965 $ 36,245
K. Dunn $ 5,975 $ 6,900 $ 8,500 $ 10,100 $ 31,475
L. Carrie $ 7,425 $ 8,580 $ 9,910 $ 7,512 $ 33,427
R. Smith $ 9,560 $ 10,150 $ 10,200 $ 9,795 $ 39,705
D. O'Brian $ 7,892 $ 7,695 $ 9,520 $ 10,252 $ 35,359
Weekly Total $ 40,402 $ 42,555 $ 46,630 $ 46,624 $ 176,211

Total Sales: $ 352,422

Current number of sales people who haved reached their goal: 3
 Monthly Goal: $ 34,000.00

Was Goal Met? Bonus Status

YES BONUS
NO NO BONUS
NO NO BONUS
YES BONUS
YES NO BONUS
December 2015 Total $ 176,211.00
 Sales Figures - December 2015

Sales Person Week 1 Week 2 Week 3 Week 4 Totals

H. James $ 9,550 $ 9,230 $ 8,500 $ 8,965 $ 36,245
K. Dunn $ 5,975 $ 6,900 $ 8,500 $ 10,100 $ 31,475
L. Carrie $ 7,425 $ 8,580 $ 9,910 $ 7,512 $ 33,427
R. Smith $ 9,560 $ 10,150 $ 10,200 $ 9,795 $ 39,705
D. O'Brian $ 7,892 $ 7,695 $ 9,520 $ 10,252 $ 35,359
Weekly Total $ 40,402 $ 42,555 $ 46,630 $ 46,624 $ 176,211

Total Sales: $ 352,422

Current number of sales people who haved reached their goal: 3
 Monthly Goal: $ 34,000.00

Was Goal Met? Bonus Status

YES BONUS
NO NO BONUS
NO NO BONUS
YES BONUS
YES NO BONUS
Mortgage Amount: $ 142,521 Current PMT
Interest Rate: 8% $1,100.00
Term in Months: 300
 Solver

Shipping
1QTR 2QTR 3QTR 4QTR Per Unit
Plant 1: 92 40 92 92 $ 1.25
Plant 2: 33 20 43 20 $ 1.84
Plant 3: 55 20 55 48 $ 1.45
Total Units Produced: 180 80 190 160
Warehouse Demands: 180 80 190 160

To optimize the total shipping costs, the following constraints must be set:
1) Each plant must produce at least 20 units a quarter to justify remaining open.
2) Plant 1 has a maximum capacity of 92 units per quarter; Plant 2 = 45 units max; Plant 3 = 55 units max.
3) The plant production must equal the requirements of the warehouse, since there is short shelf-life.
4) Note that the shipping costs vary because of plant locations and that this is factored in the total cost of shipping.

Page 31
 Solver

Total Cost of
Shipping
$ 395.00
$ 213.44
$ 258.10
$ 866.54

ant 3 = 55 units max.

ort shelf-life.
the total cost of shipping.

Page 32
 Data Table

Mortgage Amount: $ 220,000

Interest Rate: 8%
Term in Months: 300

% Rate $1,698.00
7.25% $ 1,590.18
7.50% $ 1,625.78
7.75% $ 1,661.72
8.25% $ 1,734.59
8.50% $ 1,771.50
8.75% $ 1,808.72
9.00% $ 1,846.23

Page 33
 Scenarios

Region Q1 Q2 Q3 Q4
North $85,292.25 $88,106.89 $91,014.42 $94,017.90
East $75,891.25 $77,636.75 $79,422.39 $81,249.11
West $90,568.34 $94,462.78 $98,524.68 $102,761.24
South $65,897.25 $66,622.12 $67,354.96 $68,095.87
Totals: $317,649.09 $326,828.54 $336,316.46 $346,124.11

Predicted Sales Growth

North 3.30%
East 2.30%
West 4.30%
South 1.10%

Page 34
 Scenarios

Yearly Total
$358,431.46
$314,199.50
$386,317.04
$267,970.20
$1,326,918.20

Page 35
Emp ID Last Name First Name Dept Email Ext
1054 Smith Howard AT howards 148
1056 Gonzales Joe AT joeg 121
1067 Scote Gail AT gails 123
1075 Kane Sheryl AD sherylk 126
1078 Hapsbuch Kendrick AC kendrickh 101
1152 Henders Mark AD markh 118
1196 Atherton Katie HR katiea 289
1284 Bellwood Frank MK frankb 124
1290 Cooper Linda AD lindac 113
1293 Cronwith Brent HR brentc 205
1299 Simpson Sandrae MF sandraes 127
1302 Sindole Randy MK randys 139
1310 Smith Ellen MF ellens 137
1329 Vuanuo Tuome AC tuomev 151
1333 Szcznyck Tadeuz HR tadeuzs 122
1368 Wu Tammy AD tammyw 132
1509 Kegler Pam AT pamk 135
1516 Bell Tom AC tomb 105
1529 Kellerman Tommie MK tomk 129
1656 Kourios Theo MF theok 149
1672 Dixon-Waite Sherrie MF sherried 114
1673 Boughton Frank AD fboughton 112
1676 Miller Janet MK janetm 115
1721 Alstain Isolde HR isoldea 102
1723 Sammler Mark MK marks 145
1758 Brwyne Melia AC meliab 107
1792 Barton Eileen AT eileenb 111
1814 Al-Sabah Daoud HR daouda 103
1908 Zostoc Melissa AT melissaz 152
1931 Mueller Ursula AC ursulam 110
1960 Fontaine Jean MF jeanf 150
1964 Corwick Rob AC robertc 108
1975 Franklin Larry AC larryf 125
1983 Corwick Judy AT judyc 154
1990 Chang Jessica MF jessc 198
1995 Mivelli Maria AT mariam 198
1999 Atherly Katherine HR kathya 428
Location Hire Date Pay
Building 1 16-Apr-91 $ 11.25
Building 1 25-Oct-79 $ 12.25
Building 1 20-Sep-87 $ 14.55
Building 2 7-Aug-92 $ 11.25
Building 2 1-Apr-86 $ 10.20
Building 2 21-Jan-90 $ 12.25
Building 3 1-Apr-98 $ 9.95
Building 1 4-Jan-85 $ 12.30
Building 2 3-Jan-85 $ 13.25
Building 3 14-Sep-84 $ 10.20
Building 1 21-Dec-89 $ 12.20
Building 1 6-Aug-84 $ 14.25
Building 1 4-Oct-86 $ 11.50
Building 2 22-Feb-89 $ 10.35
Building 3 16-Apr-90 $ 10.15
Building 2 11-Mar-83 $ 12.25
Building 1 19-Jun-85 $ 13.25
Building 2 6-Mar-85 $ 9.50
Building 1 28-Jan-87 $ 11.30
Building 1 14-Dec-87 $ 12.35
Building 1 16-Apr-90 $ 11.90
Building 2 25-Mar-92 $ 11.85
Building 1 26-Oct-81 $ 10.75
Building 3 6-Aug-90 $ 9.75
Building 1 10-Feb-78 $ 13.95
Building 2 18-Mar-82 $ 11.20
Building 1 24-Dec-90 $ 10.30
Building 3 4-Mar-89 $ 12.25
Building 1 15-May-84 $ 10.25
Building 2 20-Jun-89 $ 9.85
Building 1 13-Nov-86 $ 11.65
Building 2 17-Nov-91 $ 9.25
Building 2 1-Mar-96 $ 9.25
Building 1 28-Jun-97 $ 11.00
Building 1 14-Feb-98 $ 10.95
Building 1 1-Mar-98 $ 11.75
Building 3 5-Jul-98 $ 10.15
Emp ID Last Name First Name Dept Email Ext Location
1054 Smith Howard AT howards 148 Building 1
1067 Gonzales Joe AT joeg 121 Building 1
1075 Scote Gail AT gails 123 Building 1
1078 Kane Sheryl AD sherylk 126 Building 2
1152 Hapsbuch Kendrick AC kendrickh 101 Building 2
1196 Henders Mark AD markh 118 Building 2
1284 Atherton Katie HR katiea 289 Building 3
1290 Bellwood Frank MK frankb 124 Building 1
1293 Cooper Linda AD lindac 113 Building 2
1299 Cronwith Brent HR brentc 205 Building 3
1302 Simpson Sandrae MF sandraes 127 Building 1
1310 Sindole Randy MK randys 139 Building 1
1329 Smith Ellen MF ellens 137 Building 1
1333 Vuanuo Tuome AC tuomev 151 Building 2
1368 Szcznyck Tadeuz HR tadeuzs 122 Building 3
1509 Wu Tammy AD tammyw 132 Building 2
1516 Kegler Pam AT pamk 135 Building 1
1529 Bell Tom AC tomb 105 Building 2
1656 Kellerman Tommie MK tomk 129 Building 1
1672 Kourios Theo MF theok 149 Building 1
1673 Dixon-Waite Sherrie MF sherried 114 Building 1
1676 Boughton Frank AD fboughton 112 Building 2
1721 Miller Janet MK janetm 115 Building 1
1723 Alstain Isolde HR isoldea 102 Building 3
1758 Sammler Mark MK marks 145 Building 1
1792 Brwyne Melia AC meliab 107 Building 2
1814 Barton Eileen AT eileenb 111 Building 1
1908 Al-Sabah Daoud HR daouda 103 Building 3
1931 Zostoc Melissa AT melissaz 152 Building 1
1960 Mueller Ursula AC ursulam 110 Building 2
1964 Fontaine Jean MF jeanf 150 Building 1
1975 Corwick Rob AC robertc 108 Building 2
1983 Franklin Larry AC larryf 125 Building 2
1990 Corwick Judy AT judyc 154 Building 1
1995 Chang Jessica MF jessc 198 Building 1
1999 Mivelli Maria AT mariam 198 Building 1
Atherly Katherine HR kathya 428 Building 3
Hire Date Pay
16-Apr-91 $ 11.25
25-Oct-79 $ 12.25
20-Sep-87 $ 14.55
7-Aug-92 $ 11.25
1-Apr-86 $ 10.20
21-Jan-90 $ 12.25
1-Apr-98 $ 9.95
4-Jan-85 $ 12.30
3-Jan-85 $ 13.25
14-Sep-84 $ 10.20
21-Dec-89 $ 12.20
6-Aug-84 $ 14.25
4-Oct-86 $ 11.50
22-Feb-89 $ 10.35
16-Apr-90 $ 10.15
11-Mar-83 $ 12.25
19-Jun-85 $ 13.25
6-Mar-85 $ 9.50
28-Jan-87 $ 11.30
14-Dec-87 $ 12.35
16-Apr-90 $ 11.90
25-Mar-92 $ 11.85
26-Oct-81 $ 10.75
6-Aug-90 $ 9.75
10-Feb-78 $ 13.95
18-Mar-82 $ 11.20
24-Dec-90 $ 10.30
4-Mar-89 $ 12.25
15-May-84 $ 10.25
20-Jun-89 $ 9.85
13-Nov-86 $ 11.65
17-Nov-91 $ 9.25
1-Mar-96 $ 9.25
28-Jun-97 $ 11.00
14-Feb-98 $ 10.95
1-Mar-98 $ 11.75
5-Jul-98 $ 10.15