This is the case study, which should be calculated in excel. The answer should be in Excel table format, thanks!

Sunkiss, founded in 1947 in Florida, US, is a leading producer of bottled orange juice. Sunkiss developed a patent process in 1954 that could rapidly raise the temperature of juice for a short time to preserve its fresh taste. For the first time, consumers could have the fresh taste of pure not-from-concentrate juice in a ready to serve chilled package. Its major customers are supermarket chains and grocery stores.

Question: Sunkiss logistics manager has analyzed the orders placed by a distributor. The manager has found that the size of the monthly orders placed by the distributor varies from 2,000 to 10,000 units. Explain why the fluctuation of the order size is so big compared with the relatively stable consumer demand for bottled orange juice. Propose effective ways to reduce fluctuation.

Plus, What are the three common types of retailer supplier partnerships that Sunkiss can consider for forming a strategic alliance with its customers? Discuss their typical characteristics.