DATA ANALYSIS EXPERT ONLY!!! PLANNING A TOUR

PLEASE READ ALL THE INSTUACTIONS BELOW AND FOLLOW THE INSTRUCTIONS CLEARLY. YOUR JOB IS TO PURPOSE A REALISTIC 15 SHOW TOUR FOR MARIAN HILL THIS SUMMER.
EXCEL FILE ATTACHED TO WORK ON THIS PROJECT.
PLEASE READ DELIVERY #1 AND #2 BELOW AND FOLLOW THE INSTUATIONS CLEARLY!
DELIVERY #1 IS ONE PAGE SUMMARY!

Assignment: You are an analyst at New York Artists Agency, NYAA. Given the audio streams data from the last week in March your job is to propose a realistic 15 show tour for Marian Hill this summer. (NOTE: As you can see from the data, this problem is from the days before COVID—there is no need to consider that as a factor in touring, travelling, or scheduling)

The data to use is highlighted in the spreadsheet here: HW _8 Market Data Marian Hill

Instructions for the Proposed Tour:

Your objective is to maximize Marian’s revenues by playing in the cities where she is most popular while minimizing expenses and meeting ALL of the other constraints described below.

You can assume that touring revenue in a city is proportional to the number of streams for that city

The best tour route will maximize revenue (by playing in the most popular cities) while minimizing travel expenses. NY and LA MUST be included among the tour cities.

You can assume that touring revenue is proportional to the number of streams.

The tour can last a maximum of 21 days

You have to give Marian Hill at least one day off a week from playing a show (but you can still travel that off day)

There will be 15 concert dates on the tour all covering different cities with, at least 2 days off from performing. You do not need to name specific venues, just the specific city.

Performing two shows in the same city is not permitted even if the population is large.

You are allowed to take one (1) flight but otherwise you have to drive between the cites for all the other shows

Travel on days with a show MUST NOT be longer than 6 hours of driving or flight time (to provide time for a soundcheck and to avoid tiring out Marian and her team of 3 other people)

Travel on days without a show MUST NOT be longer than 10 hours

Deliverable #1

One page summary of your tour plan. This can take the form of a single page map or a day-by-day schedule outlining the tour route.

As back-up, provide a written explanation of your approach to solving the problem along with any supporting numbers or analyses.

Deliverable #2

Your objective for Deliverable #1 was to maximize Marian’s revenues by playing in the cities where she is most popular while minimizing expenses and meeting all of the other constraints.

There are MANY different solutions that would hit most of the top cities for streaming while meeting all the travel constraints.

I need to determine objectively which student provided the “best” solution. Please describe how you would calculate “TQ”—a single number that represents the “Tour Quality” of what you submitted. You do not need to complete the calculation—that’s up to you. But you do need to explain your logic meaning why your way of calculating tour quality makes sense and the “better” the tour the higher its “TQ”

The post DATA ANALYSIS EXPERT ONLY!!! PLANNING A TOUR appeared first on Learnedprofessors.