BCOR 3750 Course Project #2 Fresh Choice Snack Foods is a trail-mix supplier who sources products from all over the world. Their primary snack mix uses ingredients nuts from California, dried fruit from Hawaii, and chocolate pieces both Ohio and Pennsylvania. Recently, supplier restrictions and plant closures in the United States began limiting the company's ability to supply its product into the market. Furthermore, since the start of the pandemic, the company is now experiencing price increases as its suppliers have concurrently observed a dramatic increase in demand for Fresh Choice's inputs (thus causing significant increases in price). That said, the company has long standing contracts that still need to be honored and fulfilled. The volumes are set; however, the mix of inputs has some flexibility (which could allow some flex based on variations in prices). Fresh Choice Snack Foods hired you as a consultant to help identify the potential "optimal solutions" to fulfill their current orders while also helping with global sourcing decisions for the inputs that can be purchased from suppliers in other countries. The company has an outstanding contract for 10,000,000 Lbs of its trail mix but the changing pricing landscape is destroying the company's margins. There are four scenarios Fresh Choice Snack Foods is requesting you to analyze. 1. Pre-Pandemic Contract Scenario (US ONLY) 2. Post-Pandemic Contract Scenario (US ONLY) 3. US & International Suppliers (Initial) 4. US & International Suppliers (Final) The Pre-Pandemic Sources and Prices are as follows: Location California Product Price ($/Lb) Freight Mix % Mix % ($/Lb) (Low) (High) Almonds $ 2.50 $ 0.10 10% 25% California Raisins $ 0.99 $ 0.12 10% 25% Hawaii Coconut Shavings $ 2.00 $ 0.50 10% 25% Michigan Dried Tart Sweet Cherries $ 4.00 $ 0.35 10% 25% Ohio Chocolate Bits $ 0.75 $ 0.12 10% 25% Pennsylvania Chocolate Bits $ 0.85 $ 0.10 10% 25%