Question: Use Solver under the Data tab in Excel to find to most Scenic Route LEGEND Possible Route Network +1 L'burg 9 3.3 hrs 5 pts

Use Solver under the Data tab in Excel to find to most Scenic Route

Use Solver under the Data tab in Excel to find to

LEGEND Possible Route Network +1 L'burg 9 3.3 hrs 5 pts Va Bch 11 Nodes 1 2 3 4 5 6 7 8 9 10 11 5.0 hrs 9 pts Birmingham Atlanta Chattanooga Greenville Knoxville Asheville Charlotte Greensboro Lynchburg Raleigh Virginia Beach 2.0 hrs 4 pts +0 4.7 hrs 9 pts 2.7 hrs 4 pts Kville 5 +0 G'boro 8 1.1 hrs 3 pts 2.0 hrs 9 pts Raleigh 10 +0 1.7 hrs 5 pts A ville 6 3.0 hrs +0 4 pts 1.5 hrs 3 pts 2.3 hrs 3 pts +0 Chatt 3 2.8 hrs 7 pts Travel Time Matrix 2.0 hrs 8 pts Charl 7 3.0 hrs 1.7 hrs 4 pts +0 4 pts 5 10000.00 10000.00 1.5 hrs 2 pts G'ville 4 Atlanta 1.70 B'ham 1 2.5 hrs 3 pts +0 2.5 hrs 3 pts +0 -1 1 2 3 4 5 6 7 8 9 101 11 1 0.001 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 2.50 0.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00) 10000.00 3 3.00 1.70 0.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.000 4 10000.00 2.50 10000.00 0.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 0.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 6 10000.00 10000.00 2.80 2.00 2.00 0.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 1.50 10000.00 10000.00 0.001 10000.00 10000.00 10000.00 10000.000 8 10000.00 10000.00 10000.00) 10000.00 10000.00 3.00 1.50 0.00 10000.00 10000.00 10000.00 9 10000.00 10000.00 10000.00 10000.00 5.00 4.70 10000.00 2.00 0.00 10000.00 10000.00 10 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 2.301 1.10 10000.00 0.001 10000.00 11 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 3.30 2.70 0.00 Variables 1 4 6 7 10 0.00 0.00 2 3 0.00 1.00 0.00 0.00 4 0.00 5 6 7 8 9 101 11 0.00 0.001 0.00 0.00 0.00 0.001 0.00 0.00 0.00 0.001 0.001 0.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.00 3 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.001 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.00 5 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.001 0.00 0.00 0.00 0.00 0.001 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.001 1.00 8 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 9 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.001 0.00 0.00 0.00 0.00 1.00 0.00 0.00 0.00 0.00 11 TOTAL OUT NET FLOW = IN-OUT 0.00 1.00 -1.00 = 0.00 0.001 0.00] = 0.00 0.001 0.00 = 0.00 1.00) 0.00 = 0.00 0.00 0.00 = 0.00 0.001 0.00] = 0.00 1.00 0.00] = 0.00 0.00 0.00 = 0.00 0.001 0.00 = 1.00 1.00 0.00 = 0.00 0.00 1.00] = 1.00 TOTAL IN 1.00 TOTAL TRAVEL TIME NOTE: THIS IS A MAXIMIZATION PROBLEM USE 'POINTS' AS THE WEIGHTAGE INSTEAD OF TRAVEL TIME REPLACE BIG POSITIVE NUMBERS WITH A BIG NEGATIVE NUMBER (EX: YOU CAN USE -100 IN THIS PROBLEM) LEGEND Possible Route Network +1 L'burg 9 3.3 hrs 5 pts Va Bch 11 Nodes 1 2 3 4 5 6 7 8 9 10 11 5.0 hrs 9 pts Birmingham Atlanta Chattanooga Greenville Knoxville Asheville Charlotte Greensboro Lynchburg Raleigh Virginia Beach 2.0 hrs 4 pts +0 4.7 hrs 9 pts 2.7 hrs 4 pts Kville 5 +0 G'boro 8 1.1 hrs 3 pts 2.0 hrs 9 pts Raleigh 10 +0 1.7 hrs 5 pts A ville 6 3.0 hrs +0 4 pts 1.5 hrs 3 pts 2.3 hrs 3 pts +0 Chatt 3 2.8 hrs 7 pts Travel Time Matrix 2.0 hrs 8 pts Charl 7 3.0 hrs 1.7 hrs 4 pts +0 4 pts 5 10000.00 10000.00 1.5 hrs 2 pts G'ville 4 Atlanta 1.70 B'ham 1 2.5 hrs 3 pts +0 2.5 hrs 3 pts +0 -1 1 2 3 4 5 6 7 8 9 101 11 1 0.001 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 2.50 0.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00) 10000.00 3 3.00 1.70 0.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.000 4 10000.00 2.50 10000.00 0.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 0.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 6 10000.00 10000.00 2.80 2.00 2.00 0.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 1.50 10000.00 10000.00 0.001 10000.00 10000.00 10000.00 10000.000 8 10000.00 10000.00 10000.00) 10000.00 10000.00 3.00 1.50 0.00 10000.00 10000.00 10000.00 9 10000.00 10000.00 10000.00 10000.00 5.00 4.70 10000.00 2.00 0.00 10000.00 10000.00 10 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 2.301 1.10 10000.00 0.001 10000.00 11 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 3.30 2.70 0.00 Variables 1 4 6 7 10 0.00 0.00 2 3 0.00 1.00 0.00 0.00 4 0.00 5 6 7 8 9 101 11 0.00 0.001 0.00 0.00 0.00 0.001 0.00 0.00 0.00 0.001 0.001 0.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.00 3 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.001 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.00 5 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.001 0.00 0.00 0.00 0.00 0.001 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.001 1.00 8 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 9 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.001 0.00 0.00 0.00 0.00 1.00 0.00 0.00 0.00 0.00 11 TOTAL OUT NET FLOW = IN-OUT 0.00 1.00 -1.00 = 0.00 0.001 0.00] = 0.00 0.001 0.00 = 0.00 1.00) 0.00 = 0.00 0.00 0.00 = 0.00 0.001 0.00] = 0.00 1.00 0.00] = 0.00 0.00 0.00 = 0.00 0.001 0.00 = 1.00 1.00 0.00 = 0.00 0.00 1.00] = 1.00 TOTAL IN 1.00 TOTAL TRAVEL TIME NOTE: THIS IS A MAXIMIZATION PROBLEM USE 'POINTS' AS THE WEIGHTAGE INSTEAD OF TRAVEL TIME REPLACE BIG POSITIVE NUMBERS WITH A BIG NEGATIVE NUMBER (EX: YOU CAN USE -100 IN THIS PROBLEM)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

show spreadsheet and formula 4. Members of AAA often have different objectives in planning driving trips. Some are interested in identifying routes that minimize travel times. AAA wants to develop an...

American Car Association: The American Car Association (ACA) provides a variety of travel-related services to its members, including information on vacation destinations, discount hotel reser-...

CASE its lose in ROSE TREE REGIONAL AIRLINE or ad- ying Decision Support Using Microsoft Excel Solver PREVIEW onse Tree Regional Airline provides passenger transportation services and small-parcel...

PROJ592 COURSE PROJECT GUIDELINES Course Project Part 1Due Week 1 (graded, 40 points) MS Project Tutorials 5 points 1. Before starting your Course Project assignments, watch the MS Project videos and...

Jones & Bartlett Learning, LLC. NOT FOR RESALE OR DISTRIBUTION CHAPTER Hot Spot Analysis 10 LEARNING OBJECTIVES C A R R Provide a working definition of a \"hot spot.\" , Be able to explain different...

Please show on microsoft excel using solver. 4. Members of AAA often have different objectives in planning driving trips. Some are interested in identifying routes that minimize travel times. AAA...

Problem 1: Suzuki Auto Batteries Suzuki Auto Batteries, a manufacturer of batteries for automobiles, sells its products in the auto aftermarket and distributes them nationwide. The company divides...

SHOW WORK AND USE SOLVER IN EXCEL ! please show work in excel , explain steps used if any formulas ate used show also. Use SOLVER in excel DATA to solve . Nola Company produces two types of cookies:...

2.12 The Primo Insurance Company is introducing two new product lines: special risk insurance and mortgages. The expected profit is $5 per unit on special risk insurance and $2 for mortgages....

Courtyard Medical Plaza has new worksheets for weight loss workshops. You use Solver with sample data and add scenarios and data tables to complete a sample set. [ Student Learning Outcomes 9 . 1 , 9...

In small groups, consider how David should have handled his oral briefing differently. Compose a short skit that redesigns the oral briefing using an inductive outline and focuses on the most...

Q2. C. Develop a requirements traceability matrix (RTM) for your own class group project showing three items with different categories (write your project name and group in the above of the table)?...

Technical advice requests arise from the audit or appeals process. True False

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...