Question $1$: $(21$ points$)$ Analyze the drop$-$shipping option.$$

Fill Cells B$26,$ B$27,$ B$32,$ and B$33$ in $$Drop Ship$$ tab with your procurement costs $(2$ points$).$ You don$$t need to write anything here. $$

$$To drop$-$shop or not?

Complete the remaining empty cells in $$Drop Ship$$ tab $(15$ points$).$

You don$$t need to write anything here.

ii$.$ Recommend whether Amazon should drop$-$shop orders of book A and$/$or B$.(1$ point$)$

Briefly explain your opinion on the following questions. $(3$ points$)$

Drop shipping expensive$-$to$-$stock items?

How does demand volatility affect the drop$-$ship decision?

How does the wholesaler$$s service level affect the drop$-$ship decision?

Question $2$: $(18$ points$)$ Analyze the European distribution network.

Complete the $$EDN$$ tab in Excel $(14$ points$)$

You do not need to write anything here.$$

Recommend where Amazon should hold each product $(4$ points$)$

Explain your decisions intuitively.$$ Intuitive explanation means that you should not refer to any calculated numbers; use only raw data to explain your decisions. For each product, please compare demand levels, demand variability, holding costs, shipping costs to justify your warehousing strategy.$$

Question $3$: $(11$ points$)$ Analyze engagement ring customization.

Complete the $$Ring$$ tab in Excel $(10$ points$)$

You do not need to write anything here.$$

Recommend whether Amazon should build to order or build to stock $(1$ point$)$