File Home Insert Page Layout Formulas Data Review View Help Power Pivot Share Comments Queries & Connections g + Recent Sources [ Existing Connections Le From Text/CSV From Web Get Data From Table/Range 7 3 Properties IN NE Clear Reapply Advanced Flash Fill Consolidate Remove Duplicates E Relationships Text to Columns E Data Validation Manage Data Model Data Analysis ? Solver - Stocks Refresh All Currencies Geography Automatic Sort Filter Group Ungroup Subtotal Edit Links What If Forecast Analysis Sheet Forecast Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Outline Analyze C14 E F G H 1 K S T U V w X Y Z AA AB J L M N O P Q R Que.2. Use the information below to answer questions i, ii, and iii. There are three McDonald's locations in Kearney: North, South, and East. McDonald's needs to send food to three house parties in the next hour but must minimize its cost due to the current high gas prices. The table on the left shows the distance between each McDonald's location and the party locations. The minimum orders needed at each party location have been given. Also, due to covid and the reluctance of some workers to go back to work, each McDonald's location is facing the given limited order capacity. Party 3 1.7 2.7 3.0 Party 3 Total delivered 14 From A B D 1 McDonald's food delivery model 2 Cost of delivering one McDonald's order $ 0.25 3 4 Shipping distance 5 To 6 Party 1 Party 2 7 From North 3.0 2.0 8 South 3.1 3.0 9 East 2.5 1.9 10 11 Shipping plan, and constraints on supply and demand 12 To 13 Party 1 Party 2 North 15 South 16 East 17 Total received 0 18 19 Minimum orders 20 15 20 21 Objective to minimize 22 Total cost 23 24 25 26 27 28 29 Que. 2.i Use Solver to determine the number of orders that should be delivered to each party from the three locations. Capacity 27 30 0 0 IN NE Clear Reapply Advanced Flash Fill Consolidate Remove Duplicates E Relationships Text to Columns E Data Validation Manage Data Model Data Analysis ? Solver - Stocks Refresh All Currencies Geography Automatic Sort Filter Group Ungroup Subtotal Edit Links What If Forecast Analysis Sheet Forecast Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Outline Analyze C14 E F G H 1 K S T U V w X Y Z AA AB J L M N O P Q R Que.2. Use the information below to answer questions i, ii, and iii. There are three McDonald's locations in Kearney: North, South, and East. McDonald's needs to send food to three house parties in the next hour but must minimize its cost due to the current high gas prices. The table on the left shows the distance between each McDonald's location and the party locations. The minimum orders needed at each party location have been given. Also, due to covid and the reluctance of some workers to go back to work, each McDonald's location is facing the given limited order capacity. Party 3 1.7 2.7 3.0 Party 3 Total delivered 14 From A B D 1 McDonald's food delivery model 2 Cost of delivering one McDonald's order $ 0.25 3 4 Shipping distance 5 To 6 Party 1 Party 2 7 From North 3.0 2.0 8 South 3.1 3.0 9 East 2.5 1.9 10 11 Shipping plan, and constraints on supply and demand 12 To 13 Party 1 Party 2 North 15 South 16 East 17 Total received 0 18 19 Minimum orders 20 15 20 21 Objective to minimize 22 Total cost 23 24 25 26 27 28 29 Que. 2.i Use Solver to determine the number of orders that should be delivered to each party from the three locations. Capacity 27 30 0 0