plate$\_$and$\_$Da$...$

File

$031$

Home

Insert

Page Layout

Formulas

Data

Review

Saved to this PC

View

Automate

Search

Help

B

C

X

$$

fx

D

E

G

H

$86$

$85$ Create a pivot table that shows the average $2-$day and average $3-$to$-5$ day on$-$time delivery by district. Use conditional formatting to highlight the top two districts in green and the bottom two in red, separately for the $2-$day and the $3-$to$-5$ day delivery. Sort the pivot table alphabetically by District. Properly format the amounts. $88$

$87$

$89$

$90$ Use the INDEX, MATCH, and MAX functions to indicate

$92$

$911.$ The name of the region with the highest $2-$day on$-$time delivery and the district in which it lies. Place the MAX value next to the district.

$932.$ The name of the region with the highest $3-5$ day on$-$time delivery and $94$ the district in which it lies. Place the MAX value next to the district.

$95$ Use the INDEX, MATCH, and MIN functions to indicate

$961.$ The name of the region with the lowest $2-$day on$-$time delivery and the $97$ district in which it lies. Place the MIN value next to the district.

$982.$ The name of the Region with the lowest $3-5$ day on$-$time delivery and $99$ the district in which it lies. Place the MIN value next to the district.

$100$ In which location do you think that the resources are most needed to $101$ improve on$-$time delivery performance? Explain your choice.

$102$

$103$

$104$

$105$

$106$

$107$

$108$

F

$+$