Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help me with these questions based on below table. I need this ASAP. Thanks Q1 Q2. Q3 Q4. What KPIs would you consider using

Please help me with these questions based on below table. I need this ASAP. Thanks

image text in transcribed

image text in transcribed

image text in transcribed

Q1 Q2. Q3 Q4. What KPIs would you consider using to evaluate sales financial performance? What KPIs would you consider using to evaluate customer relationships? What KPIs would you consider using to evaluate process efficiency? What KPIs would you consider using to evaluate employee growth? Q8. 09. Which product categories have fallen below the profit goal of 13 percent? Which states are taking significantly more than four days to ship to? J 7 4 DXL Angle B D E F H K L M 1 Order ID Order Date Ship Date Ship Mode Customer Customer Segment Country City State Postal Cor Region 2 CA-2017-1 2017/11/8 ######## Second CI CG-12520 Claire Gute Consumer United Sta Henderso Kentucky 42420 South 3 CA-2017-1 2017/11/8 ######## Second CI CG-12520 Claire Gute Consumer United Sta Henderso Kentucky 42420 South 4 CA-2017-1 2017/6/12 2017/6/16 Second CIDV-13045 Darrin Var Corporate United Sta Los Angel California 90036 West 5 US-2016-1 ######## ######## Standard (SO-20335 Sean O'DConsumer United Sta Fort Laude Florida 33311 South 6 US-2016-1 ######## ######## Standard (SO-20335 Sean O'DConsumer United Sta Fort Laude Florida 33311 South 7 CA-2015-1 2015/6/9 2015/6/14 Standard (BH-11710 Brosina Hi Consumer United Sta Los Angel California 90032 West 8 CA-2015-1 2015/6/9 2015/6/14 Standard (BH-11710 Brosina Hi Consumer United Sta Los Angel California 90032 West 9 CA-2015-1 2015/6/9 2015/6/14 Standard (BH-11710 Brosina H. Consumer United Sta Los Angel California 90032 West 10 CA-2015-1 2015/6/9 2015/6/14 Standard (BH-11710 Brosina Hi Consumer United Sta Los Angel California 90032 West 11 CA-2015-1 2015/6/9 2015/6/14 Standard (BH-11710 Brosina Hi Consumer United Sta Los Angel California 90032 West 12 CA-2015-1 2015/6/9 2015/6/14 Standard (BH-11710 Brosina Hi Consumer United Sta Los Angel California 90032 West 13 CA-2015-1 2015/6/9 2015/6/14 Standard (BH-11710 Brosina Hi Consumer United Sta Los Angel California 90032 West 14 CA-2018-1 2018/4/15 2018/4/20 Standard (AA-10480 Andrew Al Consumer United Sta Concord North Caro 28027 South 15 CA-2017-1 2017/12/5 ######## Standard (IM-15070 Irene Mad Consumer United Sta Seattle Washingto 98103 West 16 US-2016-1 ######## ######## Standard (HP-14815 Harold Pa Home Offi, United Sta Fort Worth Texas 76106 Central 17 US-2016-1 ######## ######## Standard (HP-14815 Harold Pa Home Offi. United Sta Fort Worth Texas 76106 Central 18 CA-2015-1 ######## ######## Standard (PK-19075 Pete Kriz Consumer United Sta Madison Wisconsin 53711 Central 19 CA-2015-1 2015/5/13 2015/5/15 Second CI AG-10270 Alejandro Consumer United Sta West Jord Utah 84084 West 20 CA-2015-1 2015/8/27 2015/9/1 Second CI ZD-21925 Zuschuss Consumer United Sta San Franc California 94109 West 21 CA-2015-1 2015/8/27 2015/9/1 Second CIZD-21925 Zuschuss Consumer United Sta San Franc California 94109 West 22 CA-2015-1 2015/8/27 2015/9/1 Second CIZD-21925 Zuschuss Consumer United Sta San Franc California 94109 West 23 CA-2017-1 2017/12/9 ######## Standard (KB-16585 Ken Black Corporate United Sta Fremont Nebraska 68025 Central 24 CA-2017-1 2017/12/9 ######## Standard (KB-16585 Ken Black Corporate United Sta Fremont Nebraska 68025 Central 25 US-2018-1 2018/7/16 2018/7/18 Second CISF-20065 Sandra Fl: Consumer United Sta Philadelpt Pennsylva 19140 East 26 CA-2016-1 2016/9/25 2016/9/30 Standard (EB-13870 Emily Burr Consumer United Sta Orem Utah 84057 West 27 CA-2017-1 2017/1/16 2017/1/20 Second CI EH-13945 Eric Hoffm Consumer United Sta Los Angel California 90049 West 28 CA-2017-1 2017/1/16 2017/1/20 Second CIEH-13945 Eric Hoffm Consumer United Sta Los Angel California 90049 West 29 US-2016-1 2016/9/17 2016/9/21 Standard (TB-21520 Tracy Blur Consumer United Sta Philadelph Pennsylve 19140 East 30 US-2016-1 2016/9/17 2016/9/21 Standard (TB-21520 Tracy Blur Consumer United Sta Philadelpt Pennsylve 19140 East N 0 P Q R S Product ID Category Sub-Catec Product N Sales Quantity Discount Profit FUR-BO-1 Furniture Bookcase Bush Som 261.96 2 0 41.9136 FUR-CH-1 Furniture Chairs Hon Delux 731.94 3 0 219.582 OFF-LA-10 Office Sup Labels Self-Adhe: 14.62 2 0 6.8714 FUR-TA-1 Furniture Tables Bretford CI 957.5775 5 0.45 -383.031 OFF-ST-11 Office Sup Storage Eldon Folc 22.368 2 0.2 2.5164 FUR-FU-1 Furniture Furnishing Eldon Exp 48.86 0 14.1694 OFF-AR-1 Office Sup Art Newell 324 7.28 0 1.9656 TEC-PH-1 Technoloc Phones Mitel 5320 907.152 6 0.2 90.7152 OFF-BI-10 Office Sup Binders 18.504 0.2 5.7825 OFF-AP-11 Office Sup Appliance Belkin F50 114.9 5 0 34.47 FUR-TA-1 Furniture Tables Chromcraf 1706.184 9 0.2 85.3092 TEC-PH-1 Technolog Phones Konftel 251 911.424 4 0.2 68.3568 OFF-PA-11 Office Sup Paper Xerox 196: 15.552 3 0.2 5.4432 OFF-BI-10 Office Sup Binders Fellowes F 407.976 3 0.2 132.5922 OFF-AP-11 Office Sup Appliance Holmes R 68.81 5 0.8 -123.858 OFF-Bl-10 Office Sup Binders Storex Dur 2.544 0.8 -3.816 OFF-ST-11 Office Sup Storage Stur-D-Sto 665.88 6 0 13.3176 OFF-ST-11 Office Sup Storage Fellowes 55.5 2 9.99 OFF-AR-1 Office Sup Art Newell 34 8.56 2 0 2.4824 TEC-PH-1 Technoloc Phones Cisco SPA 213.48 3 0.2 16.011 OFF-BI-10 Office Sup Binders Wilson Joi 22.72 4 0.2 7.384 OFF-AR-1 Office Sup Art Newell 318 19.46 7 0 5.0596 OFF-AP-11 Office Sup Appliance Acco Six-C 60.34 0 15.6884 FUR-CH-1 Furniture Chairs Global De 71.372 0.3 -1.0196 FUR-TA-1 Furniture Tables Bretford CI 1044,63 0 240.2649 OFF-Bl-10 Office Sup Binders Wilson Joi 11.648 2 0.2 4.2224 TEC-AC-1 Technoloc Accessori Imation 8G 90.57 3 0 11.7741 FUR-BO-1 Furniture Bookcase Riverside 3083.43 0.5 -1665.05 OFF-BI-10 Office Sup Binders Avery Rec 9.618 2 0.7 -7.0532 7 Q1 Q2. Q3 Q4. What KPIs would you consider using to evaluate sales financial performance? What KPIs would you consider using to evaluate customer relationships? What KPIs would you consider using to evaluate process efficiency? What KPIs would you consider using to evaluate employee growth? Q8. 09. Which product categories have fallen below the profit goal of 13 percent? Which states are taking significantly more than four days to ship to? J 7 4 DXL Angle B D E F H K L M 1 Order ID Order Date Ship Date Ship Mode Customer Customer Segment Country City State Postal Cor Region 2 CA-2017-1 2017/11/8 ######## Second CI CG-12520 Claire Gute Consumer United Sta Henderso Kentucky 42420 South 3 CA-2017-1 2017/11/8 ######## Second CI CG-12520 Claire Gute Consumer United Sta Henderso Kentucky 42420 South 4 CA-2017-1 2017/6/12 2017/6/16 Second CIDV-13045 Darrin Var Corporate United Sta Los Angel California 90036 West 5 US-2016-1 ######## ######## Standard (SO-20335 Sean O'DConsumer United Sta Fort Laude Florida 33311 South 6 US-2016-1 ######## ######## Standard (SO-20335 Sean O'DConsumer United Sta Fort Laude Florida 33311 South 7 CA-2015-1 2015/6/9 2015/6/14 Standard (BH-11710 Brosina Hi Consumer United Sta Los Angel California 90032 West 8 CA-2015-1 2015/6/9 2015/6/14 Standard (BH-11710 Brosina Hi Consumer United Sta Los Angel California 90032 West 9 CA-2015-1 2015/6/9 2015/6/14 Standard (BH-11710 Brosina H. Consumer United Sta Los Angel California 90032 West 10 CA-2015-1 2015/6/9 2015/6/14 Standard (BH-11710 Brosina Hi Consumer United Sta Los Angel California 90032 West 11 CA-2015-1 2015/6/9 2015/6/14 Standard (BH-11710 Brosina Hi Consumer United Sta Los Angel California 90032 West 12 CA-2015-1 2015/6/9 2015/6/14 Standard (BH-11710 Brosina Hi Consumer United Sta Los Angel California 90032 West 13 CA-2015-1 2015/6/9 2015/6/14 Standard (BH-11710 Brosina Hi Consumer United Sta Los Angel California 90032 West 14 CA-2018-1 2018/4/15 2018/4/20 Standard (AA-10480 Andrew Al Consumer United Sta Concord North Caro 28027 South 15 CA-2017-1 2017/12/5 ######## Standard (IM-15070 Irene Mad Consumer United Sta Seattle Washingto 98103 West 16 US-2016-1 ######## ######## Standard (HP-14815 Harold Pa Home Offi, United Sta Fort Worth Texas 76106 Central 17 US-2016-1 ######## ######## Standard (HP-14815 Harold Pa Home Offi. United Sta Fort Worth Texas 76106 Central 18 CA-2015-1 ######## ######## Standard (PK-19075 Pete Kriz Consumer United Sta Madison Wisconsin 53711 Central 19 CA-2015-1 2015/5/13 2015/5/15 Second CI AG-10270 Alejandro Consumer United Sta West Jord Utah 84084 West 20 CA-2015-1 2015/8/27 2015/9/1 Second CI ZD-21925 Zuschuss Consumer United Sta San Franc California 94109 West 21 CA-2015-1 2015/8/27 2015/9/1 Second CIZD-21925 Zuschuss Consumer United Sta San Franc California 94109 West 22 CA-2015-1 2015/8/27 2015/9/1 Second CIZD-21925 Zuschuss Consumer United Sta San Franc California 94109 West 23 CA-2017-1 2017/12/9 ######## Standard (KB-16585 Ken Black Corporate United Sta Fremont Nebraska 68025 Central 24 CA-2017-1 2017/12/9 ######## Standard (KB-16585 Ken Black Corporate United Sta Fremont Nebraska 68025 Central 25 US-2018-1 2018/7/16 2018/7/18 Second CISF-20065 Sandra Fl: Consumer United Sta Philadelpt Pennsylva 19140 East 26 CA-2016-1 2016/9/25 2016/9/30 Standard (EB-13870 Emily Burr Consumer United Sta Orem Utah 84057 West 27 CA-2017-1 2017/1/16 2017/1/20 Second CI EH-13945 Eric Hoffm Consumer United Sta Los Angel California 90049 West 28 CA-2017-1 2017/1/16 2017/1/20 Second CIEH-13945 Eric Hoffm Consumer United Sta Los Angel California 90049 West 29 US-2016-1 2016/9/17 2016/9/21 Standard (TB-21520 Tracy Blur Consumer United Sta Philadelph Pennsylve 19140 East 30 US-2016-1 2016/9/17 2016/9/21 Standard (TB-21520 Tracy Blur Consumer United Sta Philadelpt Pennsylve 19140 East N 0 P Q R S Product ID Category Sub-Catec Product N Sales Quantity Discount Profit FUR-BO-1 Furniture Bookcase Bush Som 261.96 2 0 41.9136 FUR-CH-1 Furniture Chairs Hon Delux 731.94 3 0 219.582 OFF-LA-10 Office Sup Labels Self-Adhe: 14.62 2 0 6.8714 FUR-TA-1 Furniture Tables Bretford CI 957.5775 5 0.45 -383.031 OFF-ST-11 Office Sup Storage Eldon Folc 22.368 2 0.2 2.5164 FUR-FU-1 Furniture Furnishing Eldon Exp 48.86 0 14.1694 OFF-AR-1 Office Sup Art Newell 324 7.28 0 1.9656 TEC-PH-1 Technoloc Phones Mitel 5320 907.152 6 0.2 90.7152 OFF-BI-10 Office Sup Binders 18.504 0.2 5.7825 OFF-AP-11 Office Sup Appliance Belkin F50 114.9 5 0 34.47 FUR-TA-1 Furniture Tables Chromcraf 1706.184 9 0.2 85.3092 TEC-PH-1 Technolog Phones Konftel 251 911.424 4 0.2 68.3568 OFF-PA-11 Office Sup Paper Xerox 196: 15.552 3 0.2 5.4432 OFF-BI-10 Office Sup Binders Fellowes F 407.976 3 0.2 132.5922 OFF-AP-11 Office Sup Appliance Holmes R 68.81 5 0.8 -123.858 OFF-Bl-10 Office Sup Binders Storex Dur 2.544 0.8 -3.816 OFF-ST-11 Office Sup Storage Stur-D-Sto 665.88 6 0 13.3176 OFF-ST-11 Office Sup Storage Fellowes 55.5 2 9.99 OFF-AR-1 Office Sup Art Newell 34 8.56 2 0 2.4824 TEC-PH-1 Technoloc Phones Cisco SPA 213.48 3 0.2 16.011 OFF-BI-10 Office Sup Binders Wilson Joi 22.72 4 0.2 7.384 OFF-AR-1 Office Sup Art Newell 318 19.46 7 0 5.0596 OFF-AP-11 Office Sup Appliance Acco Six-C 60.34 0 15.6884 FUR-CH-1 Furniture Chairs Global De 71.372 0.3 -1.0196 FUR-TA-1 Furniture Tables Bretford CI 1044,63 0 240.2649 OFF-Bl-10 Office Sup Binders Wilson Joi 11.648 2 0.2 4.2224 TEC-AC-1 Technoloc Accessori Imation 8G 90.57 3 0 11.7741 FUR-BO-1 Furniture Bookcase Riverside 3083.43 0.5 -1665.05 OFF-BI-10 Office Sup Binders Avery Rec 9.618 2 0.7 -7.0532 7

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

Homework: Chapter 9 Homework (required) Save Score: 0.23 of 1 pt

Answered: 1 week ago