Question: Background & Context You are currently working at an event management fifirm. You have been assigned to a new client who is having a destination

Background & Context

You are currently working at an event management fifirm. You have been assigned to a new client who is having a

destination event with an international guest list. You have been tasked with managing their guest list throughout

the planning process of their event. Additionally, an intern will start working with you approximately 1 month before

the event begins and must be onboarded to your project quickly as well as the client will be asking you questions

about the summary of their event throughout the planning process. The start date of your event is May 21st, 2020

with the main event being May 23rd, 2020 and guest departure being on May 24th, 2020.

Data

Follow the link below to the guest list data. I have enabled commenting, feel free to ask questions and assign it to

me. When working on this project, copy the fifile to your own drive and work on the fifile from there.

Guest List Data

https://docs.google.com/spreadsheets/d/1Tm9kknrEFBaQpiMqo27eBU-FMHJdvSlKT45ToI2a_Y8/edit?usp=sharing

Spreadsheet

Your guest list manager must have the following capabilities:

1. Data dictionary.

2. Merge all datasets into a master guest list.

3. Create a dashboard, write formulas that enable you to:

a. Track RSVPs of your guests.

b. Track arrival and departure information of your guests.

c. Track gifts from your guests.

4. Add a new feature that you believe is crucial to the successful completion of your event. Impute the data

and be sure to include as part of your dashboard and analysis.

5. Create at least four visualizations of your data.

Document

Provide answers to the following questions.

1. Readme documentation.

2. Total guests on the guest list

3. How many have missing addresses for invitations.

4. How many have missing emails AND phone, email OR phone for contact information

5. How many are attending, not attending, have not RSVP'ed.

a. Am I able to contact the ones who have not RSVP'ed? Can I use their email, phone or both?

6. How many guests are staying for 1, 2, 3 or all days?

a. What is the average stay of the guests?

7. How many guests provided a gift?

a. Answer the following for all guests, attending guests and not attending guests.

i. What is the average gift?ii. What is the range of gifts?

iii. What is the variance of gifts?

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 Accounting Questions!

Requirements for PART I Do you see any potential areas of risk that the partners in the Briarwood City office should consider regarding RCC? In your response, consider business risk to JKN, en-...

Up, Up, and Away! Event Planning and Production in Las Vegas Cheri A. Young, University of Denver Daniel E. Nelson, The International School of Hospitality Kathleen S. Nelson, University of Nevada...

Personnel Decision at Riverview Based on the narrative by Mary Foster Mary Foster, Director of Event Planning at the Riverview Hotel in New York, had been through the hiring process many times....

Need help with these multiple choice questions for internal audit final exam. Due in 2 hours. QUESTION 1 RsQ_004Without management direction and assumption of responsibility, it would be...

Student Name Enrolled ID. No MS 7004 Independent Study MS 7002 Thesis 1. Title: 2. Type of Research: 3. Background of the Research: 4. Research Objectives: 5. Research Questions: 6. Variables:...

I need someone that is very good at Principles of accounting and finance to answer the attached questions. It is not a one-day job therefore if you do not have the time, please don't attempt it. The...

What strategic issues confront Vail Resort in 2017? What market or internal circumstances should most concern CEO Rob Katz and his companys senior leadership team? WHISTLER BLACKCOMB AFTON ALPS...

IDEO Case Study Assignment What are features of IDEO's "Exploratory Phase"? (select all that apply) Team members share different insights they have gained in downloading sessions Extended interviews...

Resolving agency issues in client-contractor relationships Resolving agency issues in client-contractor relationships Resolving agency issues in client-contractor relationships A FACELIFT FOR A...

PROJECT SCOPE [Instructions for what to include in this section: Define the scope of work that will be undertaken to provide the deliverable(s) mentioned in the Project Charter (PC). Craft this...

Assume that a client with excellent internal controls uses an imprest payroll bank account. Explain why the verification of the payroll bank reconciliation ordinarily takes less time than the tests...

ABC Corp. and XYZ Corp., sister companies, would both like to acquire borrowings of the same amount and term. ABC was offered a fixed rate of 10% or a variable rate of 10-year Treasury bond rate plus...

( 1 8 points ) Assume it is currently the beginning of the year 2 0 2 5 . A . ) Given an investment horizon of 2 0 3 0 , and the data provided below, use a multistage dividend discount model to...

Internal benefits of ISO 9001:2015 certification include A. increased profitability. B. reduction in the cost of producing a product. C. improvement in marketing. D. All of the above.

6. Think of something that you believe in, without the slightest doubt attached to it. How do you imagine this? Is it verbal, in rumours, in metaphors or the like? The answer says something about how...

Do not move closer than an arms distance. (This distance literally applies to Northern Europe. In Southern Europe this distance is slightly smaller.) If you get closer than this distance, you seem...

2. Now list, after going through a-c, three things that you want to be the impres-sion you want others to be left with after meeting you, and that you want to be lasting over time. List four points...