Emp ID First Name Last Name E Mail Salary Phone No.

1001 Kelly Adams kelly.adams@bp.com $ 51,878.00 405-418-0037

1002 Jack Alexander jack.alexander@gmail.com $ 82,965.00 702-603-3769
1003 Ryan Alexander ryan.alexander@shell.com $ 106,628.00 225-395-3347
1004 Margaret Allen margaret.allen@gmail.com $ 180,107.00 216-697-6987
1005 Jason Anderson jason.anderson@gmail.com $ 76,636.00 217-856-6752
1006 Patrick Bailey patrick.bailey@aol.com $ 72,305.00 319-812-6957
1007 Nancy Baker nancy.baker@bp.com $ 98,189.00 229-336-5117
1008 Margaret Brooks margaret.brooks@gmail.com $ 43,867.00 303-960-0117
1009 Lillian Brown lillian.brown@aol.com $ 67,251.00 239-812-9041
1010 Donna Brown donna.brown@aol.com $ 129,836.00 212-434-7910
1011 Mary Bryant mary.bryant@verizon.net $ 155,442.00 319-827-3516
1012 Brenda Butler brenda.butler@gmail.com $ 60,508.00 480-814-8284
1013 Melissa Butler melissa.butler@hotmail.com $ 167,631.00 308-827-9016
1014 Jack Campbell jack.campbell@gmail.com $ 186,280.00 316-499-5737
1015 Ann Coleman ann.coleman@ibm.com $ 130,014.00 319-994-4179
1016 Carl Collins carl.collins@yahoo.com $ 162,159.00 479-740-7633
1017 Paul Cooper paul.cooper@gmail.com $ 73,526.00 210-984-4722
1018 Daniel Cooper daniel.cooper@yahoo.com $ 153,790.00 701-510-8162
1019 Ann Cooper ann.cooper@exxonmobil.com $ 182,521.00 406-278-6460
1020 Nancy Davis nancy.davis@ibm.com $ 94,986.00 219-610-3067
1021 Paula Diaz paula.diaz@gmail.com $ 152,654.00 252-531-7641
1022 Carol Edwards carol.edwards@msn.com $ 93,967.00 225-283-4295
1023 Gregory Edwards gregory.edwards@outlook.com $ 169,245.00 503-256-9654
1024 Dorothy Edwards dorothy.edwards@hotmail.co.uk $ 179,017.00 215-902-6888
1025 Diane Evans diane.evans@yahoo.com $ 180,294.00 215-793-6791
1026 Ralph Flores ralph.flores@yahoo.com $ 118,457.00 316-280-2864
1027 Douglas Flores douglas.flores@gmail.com $ 181,793.00 303-836-4721
1028 Andrea Garcia andrea.garcia@aol.com $ 54,179.00 219-624-3708
1029 Judy Gonzales judy.gonzales@gmail.com $ 149,575.00 201-640-8645
1030 Roy Griffin roy.griffin@yahoo.com $ 170,895.00 219-506-9378
1031 Todd Hall todd.hall@yahoo.com $ 163,560.00 240-513-8668
1032 Carolyn Hayes carolyn.hayes@hotmail.co.uk $ 42,005.00 239-882-8784
1033 Janet Henderson janet.henderson@ntlworld.com $ 114,481.00 239-769-6347
1034 William Hernandez william.hernandez@rediffmail.com $ 73,734.00 239-276-0532
1035 Judy Hernandez judy.hernandez@gmail.com $ 133,332.00 316-736-6126
1036 Jose Hill jose.hill@hotmail.com $ 129,774.00 228-245-5000
1037 Nancy Howard nancy.howard@gmail.com $ 101,553.00 236-973-8086
1038 Amy Howard amy.howard@aol.com $ 112,715.00 803-613-3168
1039 Jimmy Howard jimmy.howard@yahoo.com $ 120,631.00 212-855-9316
1040 Amanda Hughes amanda.hughes@rediffmail.com $ 114,257.00 225-544-9700
1041 Elizabeth Jackson elizabeth.jackson@aol.com $ 85,420.00 603-568-6118
1042 Henry Jenkins henry.jenkins@hotmail.com $ 102,384.00 314-731-7135
1043 Joyce Jenkins joyce.jenkins@aol.com $ 119,321.00 262-455-4187
1044 Nancy Jones nancy.jones@gmail.com $ 61,924.00 212-825-1930
1045 Melissa King melissa.king@comcast.net $ 166,892.00 216-605-3731
1046 Theresa Lee theresa.lee@gmail.com $ 197,537.00 319-553-8919
 1047 Thomas Lewis thomas.lewis@gmail.com $ 73,862.00 314-679-3697
1048 Sharon Lopez sharon.lopez@gmail.com $ 190,139.00 304-934-5548

First pane untuk mengingatkan header/coloumn or chose pane

City State Zip Region
Meno OK 73760 North
Las Vegas NV 89170 West
Jarreau LA 70749 West
Richmond Dale OH 45673 East
Hudson IL 61748 East
Macksburg IA 50155 South
Atlanta GA 30334 West
Haswell CO 81045 West
Panacea FL 32346 North
Lima NY 14485 East
Conroy IA 52220 South
Mesa AZ 85208 West
Maxwell NE 69151 East
Kalvesta KS 67856 West
Hancock IA 51536 East
Wright AR 72182 North
Glidden TX 78943 East
Manning ND 58642 South
Arlee MT 59821 South
Bowling Green IN 47833 East
Beulaville NC 28518 East
Shreveport LA 71162 North
Bonanza OR 97623 East
Philadelphia PA 19132 South
Hydetown PA 16328 North
Sabetha KS 66534 South
Eckert CO 81418 East
Granger IN 46530 South
Eatontown NJ 7724 South
Liberty IN 47353 South
Randallstown MD 21133 South
Saint Cloud FL 34771 North
Miami FL 33166 West
Mary Esther FL 32569 South
Topeka KS 66606 West
Biloxi MS 39532 North
Saxe VA 23967 South
Kline SC 29814 South
Oriskany NY 13424 North
Lake Charles LA 70605 East
Rochester NH 3867 East
Riverside MO 64150 North
Ellsworth WI 54011 North
New York City NY 10087 East
New Matamoras OH 45767 North
Toeterville IA 50481 South
Dutchtown MO 63745 East
Bartley WV 24813 East
Date Last Name Sales Region Percent of total
Apr Adams $4,595.00 West 6%
Apr Adams $4,223.00 East 6%
Apr Adams $2,652.00 South 4%
Aug Davis $2,565.00 South 3%
Dec Adams $4,819.00 East 7%
Dec Adams $787.00 South 1%
Dec Davis $4,289.00 West 6%
Feb Adams $1,544.00 South 2%
Feb Evans $723.00 East 1%
Jan Adams $1,665.00 South 2%
Jan Brown $4,802.00 East 7%
Jan Davis $4,359.00 East 6%
Jan Davis $642.00 South 1%
Jan Evans $4,890.00 North 7%
Jul Brown $2,033.00 East 3%
Jul Brown $681.00 North 1%
Jun Davis $3,715.00 West 5%
Jun Davis $2,561.00 West 3%
Mar Brown $2,969.00 East 4%
Mar Brown $2,218.00 North 3%
Mar Davis $930.00 East 1%
Mar Evans $2,489.00 East 3%
May Adams $1,537.00 West 2%
May Evans $536.00 West 1%
Nov Brown $4,867.00 North 7%
Nov Evans $2,069.00 East 3%
Sep Davis $4,470.00 North 6%
Total $73,630.00
 SUB SUM
Total Sales Rp 73,630 $ 73,630.00
Month Last Name Sales Region SUMIF()
Feb Davis $ 2,069.00 North Month Region Total Sales
Apr Brown $ 4,359.00 South Apr South $ 6,577.00
May Adams $ 930.00 South Oct North
May Davis $ 4,223.00 South
Jun Brown $ 723.00 West
Jun Evans $ 4,802.00 South
Aug Adams $ 4,819.00 South
Aug Adams $ 2,969.00 West
Sep Brown $ 2,033.00 South
Nov Evans $ 2,489.00 East
Feb Brown $ 4,867.00 North
Apr Brown $ 2,218.00 South
Jul Evans $ 681.00 South
Oct Adams $ 4,470.00 North
Oct Adams $ 4,890.00 South
Jan Adams $ 1,544.00 West
Jan Brown $ 1,665.00 West
Mar Davis $ 2,652.00 South
Oct Adams $ 2,565.00 South
Oct Davis $ 642.00 East
Dec Evans $ 787.00 West
Mar Evans $ 1,537.00 North
Apr Davis $ 3,715.00 North
Sep Adams $ 2,561.00 North
Oct Adams $ 4,289.00 West
Nov Adams $ 4,595.00 South
Nov Evans $ 536.00 West
 DSUM()
Month Region Total Sales
Apr South Rp 11,047
Oct North
Date First Name Last Name Region Zip Code Age
4/19/2021 West 12345 18
Item # Fruit
1 Apple Select Fruit:
2 Banana
3 Mango
4 Pear
5 Pineapple
6 Grape
Category Food Fruits Vegetables
Fruits Apple Avocado
Banana Bell Pepper
Mango Carrot
Pear Corn
Pineapple Potato
Grape Tomato
Date Product ID Region Units Sales
### B102 North 8 907
### B102 South 10 235
Date Product ID Region Units Sales
1/13/2020 D104 West 5 $ 705.00
1/24/2020 A101 West 14 $ 405.00
5/20/2020 D104 North 14 $ 156.00
11/6/2020 D104 North 6 $ 142.00
3/25/2020 C103 West 17 $ 232.00
3/4/2020 D104 South 8 $ 211.00
1/14/2020 B102 South 10 $ 235.00
2/29/2020 B102 North 3 $ 885.00
5/29/2020 B102 South 7 $ 340.00
4/10/2020 B102 South 14 $ 865.00
6/10/2020 C103 East 1 $ 692.00
4/27/2020 A101 North 11 $ 994.00
3/6/2020 C103 North 2 $ 540.00
3/12/2020 B102 East 12 $ 194.00
3/7/2020 B102 South 14 $ 303.00
10/16/2020 C103 North 13 $ 594.00
7/23/2020 D104 South 16 $ 364.00
8/8/2020 C103 South 18 $ 904.00
7/26/2020 C103 South 4 $ 436.00
12/24/2020 D104 East 4 $ 192.00
9/10/2020 D104 West 11 $ 481.00
2/8/2020 C103 South 20 $ 282.00
4/4/2020 D104 North 10 $ 538.00
10/21/2020 C103 North 6 $ 715.00
1/28/2020 C103 North 18 $ 141.00
6/20/2020 A101 North 15 $ 524.00
11/1/2020 B102 West 3 $ 639.00
12/31/2020 D104 South 2 $ 622.00
10/26/2020 C103 West 20 $ 308.00
2/27/2020 B102 East 13 $ 466.00
5/11/2020 A101 West 4 $ 199.00
12/25/2020 D104 West 15 $ 573.00
9/15/2020 D104 East 8 $ 134.00
1/15/2020 A101 West 5 $ 544.00
12/5/2020 D104 South 10 $ 621.00
7/4/2020 A101 East 20 $ 436.00
2/28/2020 C103 West 1 $ 701.00
10/26/2020 B102 East 9 $ 831.00
6/20/2020 B102 West 2 $ 554.00
12/1/2020 A101 East 13 $ 759.00
8/27/2020 A101 West 8 $ 889.00
5/17/2020 B102 East 10 $ 744.00
12/18/2020 B102 West 8 $ 303.00
8/2/2020 D104 East 6 $ 548.00
5/11/2020 B102 East 11 $ 839.00
6/13/2020 A101 West 3 $ 202.00
 1/10/2020 C103 East 8 $ 723.00
3/1/2020 D104 West 8 $ 541.00
12/14/2020 D104 North 9 $ 915.00
10/7/2020 B102 South 7 $ 163.00
5/25/2020 B102 East 18 $ 328.00
10/12/2020 A101 West 16 $ 640.00
1/27/2020 C103 East 15 $ 734.00
7/24/2020 B102 South 8 $ 668.00
1/27/2020 D104 South 12 $ 116.00
2/8/2020 A101 South 7 $ 484.00
7/28/2020 C103 South 4 $ 236.00
7/26/2020 C103 East 17 $ 256.00
8/5/2020 D104 East 14 $ 202.00
1/23/2020 B102 North 8 $ 907.00
2/17/2020 B102 North 3 $ 926.00
2/11/2020 A101 South 3 $ 993.00
6/26/2020 C103 South 3 $ 222.00
6/30/2020 D104 North 9 $ 740.00
7/29/2020 A101 East 15 $ 622.00
6/2/2020 B102 East 8 $ 992.00
6/10/2020 D104 West 18 $ 549.00
4/23/2020 C103 West 10 $ 371.00
4/1/2020 B102 North 4 $ 923.00
6/14/2020 B102 North 5 $ 948.00
6/7/2020 B102 East 4 $ 474.00
5/6/2020 B102 East 3 $ 124.00
7/23/2020 B102 North 2 $ 758.00
11/10/2020 C103 West 11 $ 126.00
9/29/2020 B102 East 9 $ 735.00
8/18/2020 A101 East 16 $ 243.00
9/16/2020 A101 South 3 $ 356.00
11/8/2020 B102 South 19 $ 217.00
3/27/2020 B102 East 19 $ 992.00
10/4/2020 D104 West 12 $ 362.00
9/1/2020 B102 South 15 $ 747.00
1/25/2020 A101 North 1 $ 960.00
5/3/2020 B102 West 11 $ 913.00
11/25/2020 A101 East 5 $ 168.00
6/9/2020 A101 West 11 $ 128.00
4/7/2020 A101 East 16 $ 166.00
5/24/2020 C103 South 11 $ 294.00
6/12/2020 C103 South 9 $ 895.00
4/5/2020 D104 South 10 $ 441.00
11/18/2020 A101 West 14 $ 175.00
4/22/2020 B102 West 11 $ 888.00
10/4/2020 A101 East 11 $ 583.00
11/21/2020 C103 North 14 $ 265.00
7/12/2020 D104 West 5 $ 226.00
5/29/2020 C103 North 11 $ 424.00
7/3/2020 C103 South 4 $ 697.00
1/9/2020 C103 North 10 $ 670.00
2/20/2020 D104 West 18 $ 402.00
2/4/2020 D104 North 16 $ 916.00
Sum of Sales Product ID
This shape represents a
Date B102 C103 D104 A101 Total Result slicer. Slicers are supported
Jan $ 1,142.00 ### $ 821.00 ### $ 6,140.00 in Excel 2010 or later.
Feb $ 2,277.00 $ 983.00 ### ### $ 6,055.00
Mar $ 1,489.00 $ 772.00 $ 752.00 $ 3,013.00 If the shape was modified in
Apr $ 2,676.00 $ 371.00 $ 979.00 ### $ 5,186.00 an earlier version of Excel,
or if the workbook was saved
May $ 3,288.00 $ 718.00 $ 156.00 $ 199.00 $ 4,361.00 in Excel 2003 or earlier, the
Jun $ 2,968.00 ### ### $ 854.00 $ 6,920.00 slicer cannot be used.
Jul $ 1,426.00 ### $ 590.00 ### $ 4,699.00
Aug $ 904.00 $ 750.00 ### $ 2,786.00
Sep $ 1,482.00 $ 615.00 $ 356.00 $ 2,453.00
Oct $ 994.00 ### $ 362.00 ### $ 4,196.00
Nov $ 856.00 $ 391.00 $ 142.00 $ 343.00 $ 1,732.00
Dec $ 303.00 ### $ 759.00 $ 3,985.00
Total Result $ 18,901.00 ### ### ### $ 51,526.00

Rp20,000
Rp18,000
Rp16,000
Rp14,000
Rp12,000
Rp10,000 Product ID B102
C103
Rp8,000
D104
Rp6,000 A101
Rp4,000
Rp2,000
Rp0
ar Apr ay l t t
Ja
n
Fe
b
M M Ju
n Ju Aug Sep Oc Nov Dec sul
R e
l
ta
To
his shape represents a This shape represents a
icer. Slicers are supported slicer. Slicers are supported
Excel 2010 or later. in Excel 2010 or later.

the shape was modified in If the shape was modified in

earlier version of Excel, an earlier version of Excel,
if the workbook was saved or if the workbook was saved
Excel 2003 or earlier, the in Excel 2003 or earlier, the
icer cannot be used. slicer cannot be used.
 IF() Function IF(AND()) Function IF(OR()) Functi
Name Score 1 Result Name Score 1 Score 2 Result Name
Cory 89 Pass Cory 89 77 Pass Cory
Megan 76 Pass Megan 76 63 Fail Megan
Ryan 93 Pass Ryan 93 84 Pass Ryan
Brittany 62 Fail Brittany 62 81 Fail Brittany
Trevor 90 Pass Trevor 90 85 Pass Trevor
Kate 81 Pass Kate 81 63 Fail Kate

IF ()dibuat untuk perolehan nilai yang lulus dan gagal

IF and apabila score ada 2 (;) tanda yang harus diberikan

IF/fungsi logika untuk membandingkan dua kondisi lebih

Fungsi or akan menghasilkan niai pass apabila salah satu score atau pernyataan teruji terpenuhi dan menghasilkan fail apabila
Fungsi and menghasilkan nilai pass jika semua pernyataan diuji terpenuhi dan menghasilkan fail jika salah satu pernyataan saja
 IF(OR()) Function
Score 1 Score 2 Result
89 77 PASS
76 63 PASS
93 84 PASS
62 81 PASS
90 85 PASS
81 64 PASS

dan menghasilkan fail apabilah semua pernytaaan tidak terpenuhi

jika salah satu pernyataan saja tidak terpenuhi
 Nesting IF() COUNTIF() Function
Name Score Grade Grade Count
Cory 89 B A 4
Megan 76 C B 3
Ryan 93 A C 3
Brittany 62 F D 1
Trevor 90 A F 2
Kate 81 B
Grace 58 F
Jake 74 C
Colby 67 D
Jack 95 A
Melissa 70 C
Frank 86 B
Erin 90 A
ID Name Score Grade
110 Cory 89 B ID 115
111 Megan 76 C Name Kate
112 Ryan 93 A Score 81
113 Brittany 62 F
114 Trevor 90 A
115 Kate 81 B
116 Grace 58 F
117 Jake 74 C
118 Colby 67 D
119 Jack 95 A
120 Melissa 70 C
121 Frank 86 B
122 Erin 90 A

rumus digunakan menemukan data dalam tabel atau menurut baris

if the range have duplicate the vlook always the first
if the number doesn’t exist just click iferor and put the ; "id not found"
 Course #: CALC101 ECON101 STAT101
Monday 50 100 35
Wednesday 45 125 34
Friday 25 75 30

How many students are in each class:

Course #: ECON101
Monday 100
Wednesday 125
Friday 75

Hlookup digunakan untuk mencari nilai pada kolom atau sumber data lain yang berbentuk horizontal.
ID Name Score Grade INDEX MATCH
110 Cory 89 B Name 90 ID 114
111 Megan 76 C Position 6
112 Ryan 93 A
113 Brittany 62 F
114 Trevor 90 A
115 Kate 81 B
116 Grace 58 F
117 Jake 74 C
118 Colby 67 D
119 Jack 95 A
120 Melissa 70 C
121 Frank 86 B
122 Erin 90 A

Fungsi INDEX menghasilkan nilai atau referensi ke nilai dari dalam tabel atau rentang. Ada dua cara untuk menggunakan fungsi INDEX: Jika Anda ingin m
 INDEX & MATCH
ID 121
Name Frank
Score 86
Grade B

fungsi INDEX: Jika Anda ingin mendapatkan nilai sel atau array sel yang ditentukan, lihat Bentuk Array. Jika Anda ingin mendapatkan referensi untuk sel tertentu, lihat Be
erensi untuk sel tertentu, lihat Bentuk referensi.
 LEFT(), MID() & RIGHT()
SKU # Brand Part # Type
BA154KTL BA 154 KTL
TT874ALM TT 874 ALM
RS149OPP RS 149 OPP
YT257TRW YT 257 TRW
AA944CTX AA 944 CTX

LEN() & SEARCH()

SKU# Before "-" After "-" LEN SEARCH
BA-154KTL BA 154KTL 9 3
TTR-87ALM TTR 87ALM 9 4
RSR-1494OP RSR 1494OP 10 4
YT-257TRWP YT 257TRWP 10 3
A-944CTX A 944CTX 8 2

PADA "BRAND" 2HURUF PERTAMA PADA SKU YANG INGIN DIEKSTRAK

PADA "TYPE" 3HURUF TERAKHIR YANG INGIN DI EKSTRAK
First Name Last Name Register Date Concatenate Heading
Kelly Adams 11/5/2020 Kelly Adams Kelly Adams please register by Nov
Jack Alexander 4/6/2020 Jack Alexander Jack Alexander please register by Apr
Margaret Allen 5/13/2020 Margaret Allen Margaret Allen please register by May
Jason Anderson 8/21/2020 Jason Anderson Jason Anderson please register by Aug
Patrick Bailey 6/29/2020 Patrick Bailey Patrick Bailey please register by Jun
Nancy Baker 11/25/2020 Nancy Baker Nancy Baker please register by Nov
Margaret Brooks 6/14/2020 Margaret Brooks Margaret Brooks please register by Jun
Lillian Brown 4/21/2020 Lillian Brown Lillian Brown please register by Apr
Mary Bryant 7/8/2020 Mary Bryant Mary Bryant please register by Jul
Brenda Butler 8/18/2020 Brenda Butler Brenda Butler please register by Aug
Jack Campbell 1/14/2020 Jack Campbell Jack Campbell please register by Jan
Ann Coleman 10/4/2020 Ann Coleman Ann Coleman please register by Oct
Carl Collins 10/15/2020 Carl Collins Carl Collins please register by Oct
Paul Cooper 5/31/2020 Paul Cooper Paul Cooper please register by May
Nancy Davis 2/15/2020 Nancy Davis Nancy Davis please register by Feb
Paula Diaz 6/24/2020 Paula Diaz Paula Diaz please register by Jun
Carol Edwards 8/30/2020 Carol Edwards Carol Edwards please register by Aug
Diane Evans 9/9/2020 Diane Evans Diane Evans please register by Sep
Ralph Flores 6/19/2020 Ralph Flores Ralph Flores please register by Jun

pada formula concreate diberikan quote tanda petik untuk separated nama awal dan akhir
Invoice # Formatted Name Trim Score Grade
000001 000001 Cory Cory 89 B Name
000002 000002 Megan 76 C Score
000003 000003 Ryan 93 A
000004 000004 Brittany 62 F
000005 000005 Trevor 90 A
000006 000006 Kate 81 B
000007 000007 Grace 58 F
000008 000008 Jake 74 C
000009 000009 Colby 67 D
000010 000010 Jack 95 A
Melissa 70 C
Frank 86 B
Erin 90 A
Trevor
 Quarterly Sales Summary 2018
Division Qtr 1 Qtr 2 Qtr 3 Qtr 4 Total % of Total
North $12,586.00 $5,169.00 $5,785.00 $10,707.00 $34,247.00 22%
West 5,353.00 10,573.00 14,855.00 8,437.00 39,218.00 25%
South 9,956.00 7,689.00 4,751.00 6,984.00 29,380.00 19%
East 13,021.00 8,745.00 8,429.00 25,000.00 55,195.00 35%
Total $40,916.00 32,176.00 33,820.00 51,128.00 $158,040.00

to show which coloumn have formlas ust click tab home and find and and select and click them ok
 Bonus Bonus Table
$2,500.00 20% 25% 26% 30%
$2,500.00 $2,500.00 $5,000.00
$0.00
$0.00

and click them ok

 Quarterly Sales Summary 2019
Division Qtr 1 Qtr 2 Qtr 3 Qtr 4 Total % of Total
North 5,353.00 10,573.00 14,855.00 7,165.00 $37,946.00 27%
West $9,584.00 $4,836.00 $4,297.00 $8,974.00 27,691.00 20%
South 9,956.00 7,689.00 4,751.00 12,466.00 34,862.00 25%
East 13,021.00 4,796.00 8,429.00 14,785.00 41,031.00 29%
Total $37,914.00 27,894.00 32,332.00 43,390.00 $141,530.00
 Bonus Bonus Table
$5,000.00 20% 25% 26% 30%
$2,500.00 $2,500.00 $5,000.00
$2,500.00
$5,000.00
 Quarterly Sales Summary 2020
Division Qtr 1 Qtr 2 Qtr 3 Qtr 4 Total % of Total
North 11,476.00 6,912.00 8,429.00 4,513.00 $31,330.00 22%
West 9,956.00 7,689.00 8,797.00 12,466.00 38,908.00 27%
South 5,353.00 10,573.00 14,855.00 8,437.00 39,218.00 27%
East $12,586.00 $6,542.00 $4,297.00 $10,707.00 34,132.00 24%
Total $39,371.00 31,716.00 36,378.00 36,123.00 $143,588.00
 Bonus Bonus Table
$2,500.00 20% 25% 26% 30%
$5,000.00 $2,500.00 $5,000.00
$5,000.00
$2,500.00
 Sales Summary
Division Qtr 1 Qtr 2 Qtr 3 Qtr 4 Total
North $29,415.00 $22,654.00 $29,069.00 $22,385.00 $103,523.00
West $24,893.00 $23,098.00 $27,949.00 $29,877.00 $105,817.00
South $25,265.00 $25,951.00 $24,357.00 $27,887.00 $103,460.00
East $38,628.00 $20,083.00 $21,155.00 $50,492.00 $130,358.00
Total $118,201.00 $91,786.00 $102,530.00 $130,641.00 $443,158.00
 Price $200.00
Units Sold 50
Sales $10,000.00
Expenses $7,900.00
Profit $2,100.00

Distributor Price
Part 1 $70.00
Part 2 $50.00
Part 3 $38.00
Annual Rate 6%
Years 30
Loan Amount $300,000.00

Monthly PMT ($1,798.65)

 Price $200.00 Price $2,100.00
Units Sold 50 $205.00 $ 2,350.00
Sales $10,000.00 $210.00 $ 2,600.00
Expenses $7,900.00 $215.00 $ 2,850.00
Profit $2,100.00 $220.00 $ 3,100.00
$225.00 $ 3,350.00

Distributor Price
Part 1 $70.00
Part 2 $50.00
Part 3 $38.00
 CONSTRAINTS
Monitor Laptop Keyboard Warehouse Stock
Unit Profit $35 $175 $20 Monitor Laptop
Cost $50 $450 $15 75 50

Order Size 75 50 125 Budget $30,000

Total Cost $28,125

Profit $13,875

to use solver tool click file tab home and choose options to activated add-in and in ddata click solver
ONSTRAINTS
ehouse Stock
Keyboard
125

ta click solver