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

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

TRUE
 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
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.2
1152 Mark Henders AD 12.25
1196 Katie Atherton HR 9.95
1284 Frank Bellwood MK 12.3
999 #N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A
#N/A #N/A #N/A #N/A
1302 Randy Sindole MK 14.25
1310 Ellen Smith MF 11.5
1329 Tuome Vuanuo AC 10.35
1333 Tadeuz Szcznyck HR 10.15
1368 Tammy Wu AD 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 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
 Inventory Status Check
Enter Product Code Here: XP200
Warehouse 1 Inventory: 150 150
Warehouse 2 Inventory: 110 110
Warehouse 3 Inventory: 115 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 proper option
1054 AD 2 2 AT AT
1078 AD 6 AT AC
1284 9 MK
1299 12 MF
1329 15 AC
1509 18 AT
proper option
Last Name First Name Dept E-mail Emp ID Phone Ext
Smith Howard AT howards 1054 148
Gonzales Joe AT joeg 1056 121
Scote Gail AT gails 1067 123
Kane Sheryl AD sherylk 1075 126
Hapsbuch Kendrick AC kendrickh 1078 101
Henders Mark AD markh 1152 118
Atherton Katie HR katiea 1196 289
Bellwood Frank MK frankb 1284 124
Cooper Linda AD lindac 1290 113
Cronwith Brent HR brentc 1293 205
Simpson Sandrae MF sandraes 1299 127
Sindole Randy MK randys 1302 139
Smith Ellen MF ellens 1310 137
Vuanuo Tuome AC tuomev 1329 151
Szcznyck Tadeuz HR tadeuzs 1333 122
Wu Tammy AD tammyw 1368 132
Kegler Pam AT pamk 1509 135
Bell Tom AC tomb 1516 105
Kellerman Tommie MK tomk 1529 129
Kourios Theo MF theok 1656 149
Dixon-Waite Sherrie MF sherried 1672 114
Boughton Frank AD fboughton 1673 112
Miller Janet MK janetm 1676 115
Alstain Isolde HR isoldea 1721 102
Sammler Mark MK marks 1723 145
Brwyne Melia AC meliab 1758 107
Barton Eileen AT eileenb 1792 111
Al-Sabah Daoud HR daouda 1814 103
Zostoc Melissa AT melissaz 1908 152
Mueller Ursula AC ursulam 1931 110
Fontaine Jean MF jeanf 1960 150
Corwick Rob AC robertc 1964 108
Franklin Larry AC larryf 1975 125
Corwick Judy AT judyc 1983 154
Chang Jessica MF jessc 1990 198
Mivelli Maria AT mariam 1995 198
Atherly Katherine HR kathya 1999 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 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
 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
ACM321DP Drain Plug #321 $9.75
ACM322DP Drain Plug #322 $9.59
ACM325DP Drain Plug #325 $10.40
ACM330DP Drain Plug #330 $10.56
ACM450DP Drain Plug #450 $9.75
ACM460DP Drain Plug #460 $9.75
AST530OL 5W30 $4.06
AST100TF Automatic Transmission Fluid $5.04
AST130OL 10W30 $3.90
AST140OL 10W40 $4.55
AST300GO Gear Oil $5.20
AST121BF Brake Fluid $7.31
AST132PS Power Steering Fluid $6.50
AST2050995 20W50 $4.55
BVR590WF Windshield Washer Fluid $14.30
BVR690AF Anti-Freeze $13.81
TRA203OF Oil Filter #203 $7.31
TRA205OF Oil Filter #205 $7.31
TRA207OF Oil Filter #207 $7.31
TRA310OF Oil Filter #310 $7.64
TRA610OF Oil Filter #610 $6.14
Product Code Num Chars
WW 8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
10
8
8
8
8
8
8
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 Gail Scote
Kane Sheryl Sheryl Kane
Hapsbuch Kendrick Kendrick Hapsbuch
Henders Mark Mark Henders
Atherton Katie Katie Atherton
Bellwood Frank Frank Bellwood
Cooper Linda Linda Cooper
Cronwith Brent Brent Cronwith
Simpson Sandrae Sandrae Simpson
Sindole Randy Randy Sindole
Smith Ellen Ellen Smith
Vuanuo Tuome Tuome Vuanuo
Szcznyck Tadeuz Tadeuz Szcznyck
Wu Tammy Tammy Wu
 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: $ 200,000 Current PMT
Interest Rate: 8% $1,543.63
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 30
 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 31
 Data Table

Mortgage Amount: $ 220,000

Interest Rate: 8%
Term in Months: 300

% Rate $1,698.00
7.25%
7.50%
7.75%
8.25%
8.50%
8.75%
9.00%

Page 32
 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 33
 Scenarios

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

Page 34
1054 Smith Howard AT howards 148 Building 1 4/16/1991 11.25
1056 Gonzales Joe AT joeg 121 Building 1 10/25/1979 12.25
1067 Scote Gail AT gails 123 Building 1 9/20/1987 14.55
1075 Kane Sheryl AD sherylk 126 Building 2 8/7/1992 11.25
1078 Hapsbuch Kendrick AC kendrickh 101 Building 2 4/1/1986 10.20
1152 Henders Mark AD markh 118 Building 2 1/21/1990 12.25
1196 Atherton Katie HR katiea 289 Building 3 4/1/1998 9.95
1284 Bellwood Frank MK frankb 124 Building 1 1/4/1985 12.30
1290 Cooper Linda AD lindac 113 Building 2 1/3/1985 13.25
1293 Cronwith Brent HR brentc 205 Building 3 9/14/1984 10.20
1299 Simpson Sandrae MF sandraes 127 Building 1 12/21/1989 12.20
1302 Sindole Randy MK randys 139 Building 1 8/6/1984 14.25
1310 Smith Ellen MF ellens 137 Building 1 10/4/1986 11.50
1329 Vuanuo Tuome AC tuomev 151 Building 2 2/22/1989 10.35
1333 Szcznyck Tadeuz HR tadeuzs 122 Building 3 4/16/1990 10.15
1368 Wu Tammy AD tammyw 132 Building 2 3/11/1983 12.25
1509 Kegler Pam AT pamk 135 Building 1 6/19/1985 13.25
1516 Bell Tom AC tomb 105 Building 2 3/6/1985 9.50
1529 Kellerman Tommie MK tomk 129 Building 1 1/28/1987 11.30
1656 Kourios Theo MF theok 149 Building 1 12/14/1987 12.35
1672 Dixon-Waite Sherrie MF sherried 114 Building 1 4/16/1990 11.90
1673 Boughton Frank AD fboughton 112 Building 2 3/25/1992 11.85
1676 Miller Janet MK janetm 115 Building 1 10/26/1981 10.75
1721 Alstain Isolde HR isoldea 102 Building 3 8/6/1990 9.75
1723 Sammler Mark MK marks 145 Building 1 2/10/1978 13.95
1758 Brwyne Melia AC meliab 107 Building 2 3/18/1982 11.20
1792 Barton Eileen AT eileenb 111 Building 1 12/24/1990 10.30
1814 Al-Sabah Daoud HR daouda 103 Building 3 3/4/1989 12.25
1908 Zostoc Melissa AT melissaz 152 Building 1 5/15/1984 10.25
1931 Mueller Ursula AC ursulam 110 Building 2 6/20/1989 9.85
1960 Fontaine Jean MF jeanf 150 Building 1 11/13/1986 11.65
1964 Corwick Rob AC robertc 108 Building 2 11/17/1991 9.25
1975 Franklin Larry AC larryf 125 Building 2 3/1/1996 9.25
1983 Corwick Judy AT judyc 154 Building 1 6/28/1997 11.00
1990 Chang Jessica MF jessc 198 Building 1 2/14/1998 10.95
1995 Mivelli Maria AT mariam 198 Building 1 3/1/1998 11.75
1999 Atherly Katherine HR kathya 428 Building 3 7/5/1998 10.15
1054 Smith Howard AT howards 148 Building 1 4/16/1991 11.25
1056 Gonzales Joe AT joeg 121 Building 1 10/25/1979 12.25
1067 Scote Gail AT gails 123 Building 1 9/20/1987 14.55
1075 Kane Sheryl AD sherylk 126 Building 2 8/7/1992 11.25
1078 Hapsbuch Kendrick AC kendrickh 101 Building 2 4/1/1986 10.20
1152 Henders Mark AD markh 118 Building 2 1/21/1990 12.25
1196 Atherton Katie HR katiea 289 Building 3 4/1/1998 9.95
1284 Bellwood Frank MK frankb 124 Building 1 1/4/1985 12.30
1290 Cooper Linda AD lindac 113 Building 2 1/3/1985 13.25
1293 Cronwith Brent HR brentc 205 Building 3 9/14/1984 10.20
1299 Simpson Sandrae MF sandraes 127 Building 1 12/21/1989 12.20
1302 Sindole Randy MK randys 139 Building 1 8/6/1984 14.25
1310 Smith Ellen MF ellens 137 Building 1 10/4/1986 11.50
1329 Vuanuo Tuome AC tuomev 151 Building 2 2/22/1989 10.35
1333 Szcznyck Tadeuz HR tadeuzs 122 Building 3 4/16/1990 10.15
1368 Wu Tammy AD tammyw 132 Building 2 3/11/1983 12.25
1509 Kegler Pam AT pamk 135 Building 1 6/19/1985 13.25
1516 Bell Tom AC tomb 105 Building 2 3/6/1985 9.50
1529 Kellerman Tommie MK tomk 129 Building 1 1/28/1987 11.30
1656 Kourios Theo MF theok 149 Building 1 12/14/1987 12.35
1672 Dixon-Waite Sherrie MF sherried 114 Building 1 4/16/1990 11.90
1673 Boughton Frank AD fboughton 112 Building 2 3/25/1992 11.85
1676 Miller Janet MK janetm 115 Building 1 10/26/1981 10.75
1721 Alstain Isolde HR isoldea 102 Building 3 8/6/1990 9.75
1723 Sammler Mark MK marks 145 Building 1 2/10/1978 13.95
1758 Brwyne Melia AC meliab 107 Building 2 3/18/1982 11.20
1792 Barton Eileen AT eileenb 111 Building 1 12/24/1990 10.30
1814 Al-Sabah Daoud HR daouda 103 Building 3 3/4/1989 12.25
1908 Zostoc Melissa AT melissaz 152 Building 1 5/15/1984 10.25
1931 Mueller Ursula AC ursulam 110 Building 2 6/20/1989 9.85
1960 Fontaine Jean MF jeanf 150 Building 1 11/13/1986 11.65
1964 Corwick Rob AC robertc 108 Building 2 11/17/1991 9.25
1975 Franklin Larry AC larryf 125 Building 2 3/1/1996 9.25
1983 Corwick Judy AT judyc 154 Building 1 6/28/1997 11.00
1990 Chang Jessica MF jessc 198 Building 1 2/14/1998 10.95
1995 Mivelli Maria AT mariam 198 Building 1 3/1/1998 11.75
1999 Atherly Katherine HR kathya 428 Building 3 7/5/1998 10.15