from the data provided, create a pivot table. once created what stands out? what does not appear to be right? for example if sales are better in a certain region.

From the Data create a pivot table in excel.

Identify any problems found:

Suggested Intervention:

Costs of Intervention:

Benefits of Intervention:

OrderDate Region Rep Item 1/6/18 East Jones Pencil 1/23/18 Central Kivell Binder 2/9/18 Central Jardine Pencil 2/26/18 Central Gill Pen 3/15/18 West Sorvino Pencil 4/1/18 East Jones Binder 4/18/18 Central Andrews Pencil 5/5/18 Central Jardine Pencil 5/22/18 West Thompson Pencil 6/8/18 East Jones Binder 6/25/18 Central Morgan Pencil 7/12/18 East Howard Binder 7/29/18 East Parent Binder 8/15/18 East Jones Pencil 9/1/18 Central Smith Desk 9/18/18 East Jones Pen Set 10/5/18 Central Morgan Binder 10/22/18 East Jones Pen 11/8/18 East Parent Pen 11/25/18 Central Kivell Pen Set 12/12/18 Central Smith Pencil 12/29/18 East Parent Pen Set 1/15/19 Central Gill Binder 2/1/19 Central Smith Binder 2/18/19 East Jones Binder 2/21/19 Central Andrews Binder 3/4/19 Central Jardine Binder 3/7/19 West Sorvino Binder 3/24/19 Central Jardine Pen Set 4/10/19 Central Andrews Pencil 4/17/19 Central Jardine Binder 4/27/19 East Howard Pen 5/14/19 Central Gill Pencil 5/31/19 Central Gill Binder 6/4/19 East Jones Pen Set 6/17/19 Central Kivell Desk 6/21/19 Central Morgan Pen Set 8/7/19 Central Kivell Pen Set 8/10/19 Central Gill Pencil 8/24/19 West Sorvino Desk 8/27/19 West Sorvino Pen 9/14/19 West Thompson Binder 9/16/19 Central Andrews Pencil Units Unit Cost 95 $1.99 50 $19.99 36 $4.99 27 $19.99 56 $2.99 60 $4.99 75 $1.99 90 $4.99 32 $1.99 60 $8.99 90 $4.99 29 $1.99 81 $19.99 35 $4.99 2 $125.00 16 $15.99 28 $8.99 64 $8.99 15 $19.99 96 $4.99 67 $1.29 74 $15.99 46 $8.99 87 $15.00 4 $4.99 28 $4.99 94 $19.99 7 $19.99 50 $4.99 66 $1.99 11 $4.99 96 $4.99 53 $1.29 80 $8.99 62 $4.99 5 $125.00 55 $12.49 42 $23.95 7 $1.29 3 $275.00 76 $1.99 57 $19.99 14 $1.29 Total $189.05 $999.50 $179.64 $539.73 $167.44 $299.40 $149.25 $449.10 $63.68 $539.40 $449.10 $57.71 $1,619.19 $174.65 $250.00 $255.84 $251.72 $575.36 $299.85 $479.04 $86.43 $1,183.26 $413.54 $1,305.00 $19.96 $139.72 $1,879.06 $139.93 $249.50 $131.34 $54.89 $479,04 $68.37 $719.20 $309.38 $625.00 $686.95 $1,005.90 $9.03 $825.00 $151.24 $1,139.43 $18.06 Gross Margin 2.50% 12% 2.50% 5% 2.50% 12% 2.50% 2.50% 2.50% 12% 2.50% 12% 12% 2.50% 23% 33% 12% 5% 5% 33% 2.50% 33% 12% 12% 12% 12% 12% 12% 33% 2.50% 12% 5% 2.50% 12% 33% 23% 33% 33% 2.50% 23% 5% 12% 2.50% East Order Date Region Rep Item 1/6/18 East Jones Pencil 1/23/18 Central Kivell Binder 2/9/18 Central Jardine Pencil 2/26/18 Central Gill Pen 3/15/18 West Sorvino Pencil 4/1/18 East Jones Binder 4/18/18 Central Andrews Pencil 5/5/18 Central Jardine Pencil 5/22/18 West Thompson Pencil 6/8/18 Jones Binder 6/25/18 Central Morgan Pencil 7/12/18 East Howard Binder 7/29/18 East Parent Binder 8/15/18 East Jones Pencil 9/1/18 Central Smith Desk 9/18/18 East Jones Pen Set 10/5/18 Central Morgan Binder 10/22/18 East Jones Pen 11/8/18 East Parent Pen 11/25/18 Central Kivell Pen Set 12/12/18 Central Smith Pencil 12/29/18 East Parent Pen Set 1/15/19 Central Gill Binder 2/1/19 Central Smith Binder 2/18/19 East Jones Binder 2/21/19 Central Andrews Binder 3/4/19 Central Jardine Binder 3/7/19 West Sorvino Binder 3/24/19 Central Jardine Pen Set 4/10/19 Central Andrews Pencil 4/17/19 Central Jardine Binder 4/27/19 East Howard Pen 5/14/19 Central Gill Pencil 5/31/19 Central Gill Binder 6/4/19 East Jones Pen Set 6/17/19 Central Kivell Desk 6/21/19 Central Morgan Pen Set 8/7/19 Central Kivell Pen Set 8/10/19 Central Gill Pencil 8/24/19 West Sorvino Desk 8/27/19 West Sorvino Pen 9/14/19 West Thompson Binder 9/16/19 Central Andrews Pencil Units Unit Cost Total 95 $1.99 $189.05 50 $19.99 $999.50 36 $4.99 $179.64 27 $19.99 $539.73 56 $2.99 $167.44 60 $4.99 $299.40 75 $1.99 $149.25 90 $4.99 $449.10 32 $1.99 $63.68 60 $8.99 $539.40 90 $4.99 $449.10 29 $1.99 $57.71 81 $19.99 $1,619.19 35 $4.99 $174.65 2 $125.00 $250.00 16 $15.99 $255.84 28 $8.99 $251.72 64 $8.99 $575.36 15 $19.99 $299.85 96 $4.99 $479.04 67 $1.29 $86.43 74 $15.99 $1,183.26 46 $8.99 $413.54 87 $15.00 $1,305.00 4 $4.99 $19.96 28 $4.99 $139.72 94 $19.99 $1,879.06 7 $19.99 $139.93 50 $4.99 $249.50 66 $1.99 $131.34 11 $4.99 $5489 96 $4.99 $479.04 53 $1.29 $68.37 80 $8.99 $719.20 62 $4.99 $309.38 5 $125.00 $625.00 55 $12.49 $686.95 42 $23.95 $1.005.90 7 $1.29 $9.03 3 $275.00 $825.00 76 $1.99 $151.24 57 $19.99 $1,139.43 14 $1.29 $18.06 Gross Margin 2.50% 12% 2.50% 5% 2.50% 12% 2.50% 2.50% 2.50% 12% 2.50% 12% 12% 2.50% 23% 33% 12% 5% 5% 33% 2.50% 33% 12% 12% 12% 12% 12% 12% 33% 2.50% 12% 5% 2.50% 12% 33% 23% 33% 33% 2.50% 23% 5% 12% 2.50%