$1.$Flowchart the current process in VISIO. Include quantities and timing $($Level $3$ process map$).$

$$Recommendation: draw it out first;

$$Include measures in the flowchart when applicable $($distance$,$ time, etc$)$

$2.$Replicate the industry customer service indicators shown in the case using Pfizer$$s logistics operations data $($e$.$g$.,$ on$-$time, damage$).$ Show your work, i$.$e$.,$ I must be able to see your work $($use of functions, formulas, pivot tables, etc.$).$ Typed figures will earn a $0.$ Demonstrate use of at least one Pivot Table

$3.$Analyze the data to determine the specific $($root cause or causes$)$ for non$-$perfect performance for each of the following service item performance areas:

$$Product availability $($in full$)[$Incorrect quantity $($not in full$)]$

$$On$-$time delivery

$$Process completed same day

$$Label errors

$$Product damage

$$Products lost

a$.$ Look for specific reasons $($root causes$)$ for subpar performance

$$When calculating, make sure to show the numbers, i$.$e$.,$ your calculations!

$$Make sure to show decimal places $($out two$)$

$$Do at least one pivot table and turn in$!$

b$.$ Based on this analysis, recommend specific changes to fix problems

i$.$ Any problem $($gap$)?$ Is there a problem?

ii$.$ The Cause $-$ State the specific and most likely causes of the problems in these areas.

iii. Recommend specific changes, aimed at addressing what you believe is the root cause$($s$),$ to fix each service item that Pfizer$$s CLSC should be concerned about.

$4.$Describe other recommendations to improve Pfizer$$s process in addition to the recommendations of part $3.$