Part III ( Difficulty: Intermediate) In order to create the

 Part III ( Difficulty: Intermediate) In order to create the Treemap for the Cost of Goods Sold (COGS), you will have to link two data files. Tableau will do this automatically. Start by uploading the sales file (you can use the same workbook as the previous investigations; however, we always recommend you save your work as you go). Once the sales file is uploaded, upload the purchase price file. The files should be a center join based on Brand. Once the files are linked, verify your files uploaded and joined properly. The total Sales Dollars should be $483,891,954. Verifying your COGS of $347,412,594 will trickier as we need to create the variable (to be discussed below). To determine the COGS, you’ll have to create the COGS variable by going to the Analysis Tab and clicking on a Create a Calculated Field . Drag Purchase Price and then multiply by Sales Quantity. You should see your new variable under the Measures . • Once the files are merged, you’ll have to calculate the following variables – COGS – $347,412,594 – Gross Profit: Gross Profit = Sales – COGS – Gross Profit %: Gross Profit / Sales • Create a Scatter Graph comparing each store’s Sales and Gross Profit. – Does the relationship appear to be linear? – What is the equation of the trend line? Hint: Use the Analysis Tab and drag it onto your Worksheet . – Why wouldn’t all of the stores be exactly on the trend line since each store has access to the same inventory? • Create a Worksheet to determine the percentage that each Store contributes to the overall Gross Profit. Use the Classification variable to filter based on spirits and wine. Convert your Worksheet into a Stacked Bar Chart . What percent does store 76 contribute to the overall gross profit? What percent does Store 76 contribute to Gross Profit based on wine only? Spirits only? • Individually, which two stores have the highest Gross Profit %? Individually, which two stores have the lowest Gross Profit %? • What kind of decisions could be made when examining a store’s contribution to overall gross profit for the company? What kind of decision could be made when comparing individual store gross profit percentages 

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Future direction

 Future Directions No unread replies.11 reply. This week’s graded topics relate to the following Course Outcome (CO). • CO9: Examine future trends in community health nursing, including the impact of information systems and evidence-based practice. (PO8) Review this week’s lesson and assigned reading on the nurses’ role in population health,

During the last few weeks, this course has explored issues

During the last few weeks, this course has explored issues in culture, creativity, innovation, and conflict. Please consider at least one theory and one related tool and consider the application of these into your professional environment or into a professional environment in which you aspire to join. Finally, conclude your

This week, we learned about organizational design. This allowed you

This week, we learned about organizational design. This allowed you to identify different characteristics of your organization. To apply this knowledge, identify an organization you are familiar with and which you answer the following questions: Identify an organization. Describe the organization and the industry. Explain all the elements of the

Select one of the case studies at the end of

  Select one of the case studies at the end of either chapter 7 or chapter 8. After reading the case study, respond to the questions in a 3-4 page paper. The requirements below must be met for your paper to be accepted and graded: ·  Write between 750-1,000 words

Progress: When is it appropriate to use in-depth interviews? Problems:

Progress: When is it appropriate to use in-depth interviews? Problems: What are the features, problems, and pitfalls of interviewing? Plans: How will you organize your interview? How will you incorporate the concepts from your theory/model into your interview guide? What other resources or support will you need to develop a

At some point, most people will be interviewed for a

 At some point, most people will be interviewed for a job position. Many people will also be the interviewer, helping their company find the right applicant for a position. Create a visual presentation that explores interview communication skills: Summarize interview preparation skills and strategies.Explain various interview structures and processes.Differentiate the

Demonstrate leadership and teamwork skills to effectively manage health care

  Demonstrate leadership and teamwork skills to effectively manage health care projects and teams. Analyze trending management issues to maintain lifelong learning in the rapidly evolving health care field. Develop a Briefing report (continue working on the case from week 3) covering all the following: Provide an overview of Estelle

A descriptive essay about a place you know well, either from memory or

Purpose: To write a descriptive essay about a place you know well, either from memory or observation. To practice writing creative nonfiction. “The aim is to write descriptively, and to help readers see this place in their mind’s eye and understand some of the significance of the place” (Course Syllabus).

Queer Theory: Objectives of this Course

Queer Theory Diary: Get yourself a diary after the first class (or start one on your computer, if that’s more practical for you) and keep up with it weekly (at least). The diary is a personal space for you to reflect on the myriad ways in which you come into

1. Project Overview In this project you will analyse and

     1. Project Overview  In this project you will analyse and explore a large data set based on the daily closing stock-prices of 28 large companies. In particular, you will build and assess linear regression models that explain variability in the daily stock price of Vodafone using stock price data

Total pages: two or more There are three readings that

Total pages: two or more There are three readings that need to be read, please read through them and write summary and analysis according to the questions below for each reading. Please write each question separately by using 1) 2) 3), and also separately each reading with its title. Thank

Neurodevelopmental disorders begin in the developmental period of childhood and

  Neurodevelopmental disorders begin in the developmental period of childhood and may continue through adulthood. They may range from very specific to a general or global impairment, and often co-occur (APA, 2022). They include specific learning and language disorders, attention deficit hyperactivity disorder (ADHD), autism spectrum disorders, and intellectual disabilities. Neurocognitive

review the various healthcare (such as hospital, community health center,

  review the various healthcare (such as hospital, community health center, etc.) and select one. Once selected, research the internet to identify a facility that represents your selected healthcare delivery setting. Review their website and determine: Location and size Mission and values Accreditation and awards How long they have been

Lesson 14 – Discussion A medical group recently conducted an

 Lesson 14 – Discussion A medical group recently conducted an advertising campaign for its new pediatric orthopedics department.  After 4 weeks, a telephone survey found that 42% of the families with children under the age of 18 years were aware of the service.  Six months later, it found that 12%

Health & Medical Question Nursing Assignment Help

Introduction How do you find the best evidence to answer PICO(T) questions? In EBP, it is essential to use your PICO(T) question and its components as the foundation of your search for the most relevant, best evidence to answer the question and address a health care challenge. Peer reviewed journals

Atoms and Quantum Physics – Premium Paper Help

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along with research materials for assistance purposes only. All the materials from our website should be used with proper references.

Assignment: Financial Reporting Review of the Federal Government Overview The

Assignment: Financial Reporting Review of the Federal Government Overview The U.S. Constitution Article I, Section IX mandates “a regular statement and account of the receipts and expenditures of all public money shall be published from time to time” by the federal government.Two centuries after the publication of the U.S. Constitution,

This is an individual task in which the student will

This is an individual task in which the student will answer the following questions: 1)      Define and describe the differences between Common Law, Civil Law and Sharia Law. 2)      Define the concept of Limited Liability and describe its importance for the business environment. 3)      Define Intellectual Property and its application