Lex Rex is an aspiring rock band composed of college friends based in Raleigh, NC. They are

Question:

Lex Rex is an aspiring rock band composed of college friends based in Raleigh, NC. They are planning a short tour that will take them to five other college towns throughout the Mid-Atlantic region over a 10 day period. The distances between each of the cities planned for their tour are given below:

The venues where the band will perform have other acts booked on some the dates the band will be on tour. The following table indicates (with entries of 1) the dates that venues are available in each of the cities.

a. Create a spreadsheet model that can be optimized to determine the tour that minimizes the number of miles traveled. What is that tour?
b. Now use your model to determine the tour that minimizes the number of days on the road. What is that tour?
c. Now use your model to determine the tour that minimizes the amount of driving on a tour lasting 8 days. (Assume it takes 1 day to travel from any of the cities back to the band home town.)

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Answer rating: 77% (9 reviews)

From City To City Distance To City Date 0 HB 4 D 65 1 4 D 1 A 176 3 1 A ...View the full answer

Answered By

Asim farooq

I have done MS finance and expertise in the field of Accounting, finance, cost accounting, security analysis and portfolio management and management, MS office is at my fingertips, I want my client to take advantage of my practical knowledge. I have been mentoring my client on a freelancer website from last two years, Currently I am working in Telecom company as a financial analyst and before that working as an accountant with Pepsi for one year. I also join a nonprofit organization as a finance assistant to my job duties are making payment to client after tax calculation, I have started my professional career from teaching I was teaching to a master's level student for two years in the evening. My Expert Service Financial accounting, Financial management, Cost accounting, Human resource management, Business communication and report writing. Financial accounting : • Journal entries • Financial statements including balance sheet, Profit & Loss account, Cash flow statement • Adjustment entries • Ratio analysis • Accounting concepts • Single entry accounting • Double entry accounting • Bills of exchange • Bank reconciliation statements Cost accounting : • Budgeting • Job order costing • Process costing • Cost of goods sold Financial management : • Capital budgeting • Net Present Value (NPV) • Internal Rate of Return (IRR) • Payback period • Discounted cash flows • Financial analysis • Capital assets pricing model • Simple interest, Compound interest & annuities

4.40+ 65+ Reviews 86+ Question Solved

Related Book For book-img-for-question

Spreadsheet Modeling And Decision Analysis A Practical Introduction To Business Analytics

ISBN: 9781305947412

8th Edition

Authors: Cliff T. Ragsdale

See More Books

Question Posted: May 04, 2017 05:50 AM

See More Questions

Lex Rex is an aspiring rock band composed of college friends based in Raleigh, NC. They are

Question:

Distances Between Cities in Miles Home 65 176 755 叨 125 173 Home 210 353 210 353 530 797 176 173 571 571 755 395 65 125 395 792 Dates Available for Concerts(1Available, 0 Not Available) City 3 45 6 789 10 A 1 01 0 0 1 0 1 C 00 0 010 00 D 1 0 0 001 0 00

Step by Step Answer:

From City To City Distance To City Date 0 HB 4 D 65 1 4 D 1 A 176 3 1 A ...View the full answer

Spreadsheet Modeling And Decision Analysis A Practical Introduction To Business Analytics

Students also viewed these Statistics questions