Use the LlamaFresh_CaseStudy_Student Scenario Worksheet.xIsx to record the combinations of selected improvement projects and results for each scenario. The worksheet provided has several prebuilt tables that you can use to: 1. Record your scenario name LlamaFresh Case Study Part B | Scenario Worksheet 2. Mark which projects your Student Name scenario is testing 3. Record the total budget used based on your selected Scenario Name: projects. (The total should be Project Investment Cost |Used? less than or equal to 1 - Fleet Size 14 $200,000 $500,000) 2 - Fleet Size 16 $400,000 3 - Reduce Unload Time 10 Mins $100,000 4. Record the weekly 4 - Reduce Unload Time 20 Mins $300,000 transportation costs 5 - Open Saturdays $100,000 6 - Expanded Weekday Hours $300,000 5. Manually calculate the 7 - Expand Weekday Hours + Open Sat $400,000 estimated number of weeks 8 - Allow Overnight Routes $200,000 until the investment costs are 3 Total Project Budget Used: recouped based on the 4 Transportation System Costs: difference in weekly costs # of weeks until investment $ recouped between the given scenario and the "Current State" scenario