Customer Analysis of Universal Studios

July 15, 2022

Customer Analysis of Universal Studios

Order ID	35675990
Type	Essay
Writer Level	Masters
Style	APA/MLA/CHICAGO
Sources/References	4
Perfect Number of Pages to Order	5-10 Pages

Description/Paper Instructions

Customer Analysis of Universal Studios

I need one page about a customer analysis of Universal studios. ASAP

Use secondary data to describe consumers in your industry. Define the consumers: consider demographics, geographic, psychographics, lifestyles, and behavioral characteristics (how they use the product; why they use the product; how much they use the product). You’ll need to decide which of those segmentation variables are relevant in this industry. What market segments exist in this industry?

Identify consumers’ needs/wants regarding your product category.

How do consumers make decisions in your industry? Is it a low involvement or high involvement process for most of them? Is it an individual decision or do others (spouse, children, etc.) play a role? If others play roles in the decision, describe the roles.

Given previous sales, industry trends, competitive forces, and any foreseen future changes in environmental and company factors, what is your forecasted demand for this product?

420 or more words

You are the parent of a young child whom you would like to see become a peaceful, affectionate, and cooperative adult.

To achieve this goal, to what extent would you consider taking the following steps?
a. preventing your child from watching violent television shows;
b. preventing your child from playing with “violent” toys such as guns, swords, etc.;
c. preventing your child from playing with “aggressive” children;
d. preventing your child from fighting back if another child kept bullying him or her.

Rank the above options in the order in which you would take action—“a” being the most to “d” being the least likely to be put into action by you as a parent.

Finally, would you want to eliminate all aggressive behavior in your child? Why or why not? Discuss your decisions and the reasoning behind them with your classmates.

Requirements: you will need Excel 2007, 2010, or 2013 to complete this project. You will also need the following file(s): 1010excel.xlsx.

Project Background: You have been hired by the Bahamas Cruise Line as an analyst. You will assist the cruise line staff in record-keeping, revenue generation, and overall efficiency. Your project will be broken down into the following three sections: Worksheet & Workbook Management, Formulas & Functions, and Charts & Subtotals.

Part 1: Worksheet & Workbook Management—Rename and organize the worksheets within the workbook and re-save the workbook itself by following the instructions below:

Click here to access and open 1010excel.xlsx.

Save the 1010excel.xlsx file as your “student ID number last name.xlsx” (ex: 12345_Jones.xlsx).

Rename Sheet 1 to Formulas & Functions.

Rename Sheet 2 to Chart.

Rename Sheet 3 to Subtotals.

Move the Chart worksheet to the right of the Subtotals worksheet.

Create a fourth worksheet using your student ID number as the name.

Save the file.

Part 2: Formulas & Functions— In this section you will assist the sales manager in categorizing the company’s revenue sources and how each one relates to each other. You will use formulas and functions to create totals and/or averages of the revenue data following the instructions below. Make sure you are in the Formulas & Functions active worksheet before you begin:

In cell B2, create a function that totals Jan through Dec sales for Online Reservations.

In cell B3, create a function that totals Jan through Dec sales for Telephone Reservations.

In cell B4, create a function that totals Jan through Dec sales for Sales Calls.

In cell B5, create a function that totals Jan through Dec sales for Activity Companies.

In cell B7, create a formula that adds the annual totals of all four categories using cells B2, B3, B4, and B5 which will give you the total annual revenue for the Bahamas Cruise Line.

In cell C2, create a function that displays the average for online reservations from Jan through Dec. Repeat this for the other three categories of revenue.

Save the file.

Part 3: Charts & Subtotals—Create a pie chart that compares each revenue source in the month of January and use the subtotals feature in excel to total three separate categories of revenue. Use the following instructions:

Make sure the Chart worksheet is active before you begin.

Create a pie chart using the range A1 to B5.

Slightly detach the sales calls piece of the pie from the rest of the pie chart.

Save the file.

Make sure the Subtotals worksheet is active before you begin.

Sort the list by category.

Use the subtotals function in excel to display totals for the three categories on this worksheet (Activities, Hotels, and Retail) in blocks D26, D27, & D28

Save the file and submit for grading.

Customer Analysis of Universal Studios

	Excellent (4)	Good (3)	Needs Improvement (2)	Poor (1)
Language/Spelling/ Grammar	Presentation has no spelling or punctuation errors and very few grammatical errors. Very well written and excellent use of business language.	Presentation has a few punctuation or spelling errors. Few grammatical errors that don’t affect meaning. Well written and use of business language is acceptable.	Presentation has some punctuation or spelling errors. Some grammatical errors but generally don’t affect meaning. Language is satisfactory overall but use of more appropriate business language is required.	Presentation has numerous punctuation or spelling errors. Numerous grammatical errors that affect meaning. Language used is unprofessional and not appropriate for business use.
Presentation Organization and Formatting	Relevant sections are included, and each is organized effectively. Formatting is professional and consistent and includes all required elements.	Relevant sections are included but could be a little better organized. Formatting is acceptable and/or one or two required elements are missing.	Relevant sections are included but organization could be improved. Formatting is inconsistent and/or many elements are missing or not formatted appropriately.	Sections are missing and/or poorly organized. Formatting is messy and unprofessional.
Presentation Content/Thinking	Presentation Content is comprehensive and detailed. Thinking and ideas are presented clearly, are engaging and thorough.	Presentation Content is sufficient. Thinking and ideas are clear but could be expanded to be more thorough.	Presentation Content is fairly basic and/or thinking and ideas lack some clarity and depth.	Presentation Content is very basic and thinking and ideas are superficial and lack clarity.