Continue with the assumptions of Question $2.$ However, you can only order a total of $10,000$ parkas because of logistics capacity from China. You can choose any mix of the $10$ parka styles. Decide how much of each style to include in the $10,000$ total. For each style, calculate the expected profit, service level, and fill rate, using your decision.

Excel Functions:

Calculate z$-$value corresponding to a critical ratio or service level:

z $=$ NORM.INV$($critical ratio or service level, $0,1)$

Calculate service level corresponding to a z$-$value

service level $=$ NORM.DIST$($z$,0,1,$ TRUE$)$

Calculate standard normal loss corresponding to a z$-$value:

L$($z$)=$ NORM.DIST$($z$,0,1,$ FALSE$)-$ z$*$NORM$.$DIST$(-$z$,0,1,$ TRUE$)$