Step 1: Download and Review the Data
Begin working on your Assignment by examining product launch data from an attached
Excel spreadsheet (Cost_Revenue_and_Profit)
This spreadsheet contains data on the number of goods sold, the cost of goods sold, the overhead,
the revenue, and the profit. As part of this assignment, you will create visualizations to analyze
the data for trends to better understand the information.
As you review the data, look for answers to the following questions:
▪
How does the cost of goods sold (COGS) change from month to month?
▪ How does the profit change over time?
▪ How has the profit as a percentage of the COGS changed over time?
▪ What factors are responsible for changes in revenue and profit?
▪ Has your company been able to meet its goal of a profit equal to 25 percent of the
COGS?
You’ll also want to experiment with the spreadsheet and the data to find the charts or graphs that
best allow you to visualize important trends. Remember, the purpose of this analysis is to better
understand the cost, revenue, and profit associated with the new product launch.
Step 2: Explain the Importance of Data Analysis
Start drafting your report to post on the company’s intranet.
To begin your report, write a brief introduction explaining the importance of data analysis and
how it is essential for understanding how well a product is performing.
As you write, remember that you are creating an internal report for your coworkers.
➢ What is the importance of data analysis? How can it help you understand whether
the new product had a successful launch? What are you reporting on and what are
you analyzing? Why is it important to analyze this information? – 100 words.
Step 3: Describe Your Findings
Draft a description of your findings related to the product launch data.
Now that you’ve introduced your post by explaining the importance of data analysis, you can
move on to reporting on your findings. Based on your analysis of the product launch data, provide
a general overview of the data and describe the story of the product launch that emerges from
your analysis of it.
➢ Describe the results of your analysis. What does the data tell you about the success
of the product throughout the year? Was the company able to meet its profit goal?
What data did you use to determine whether the product is meeting expectations? 200 words.
Step 4: Summarize the Results of Your Analysis
Summarize your findings using data visualizations and text.
You’ve introduced your post by explaining the importance of data analysis, and you’ve told the
story of your product’s launch. Now it’s time to summarize your most important findings with
data visualizations to help employees and fellow company leaders understand your insights about
the product launch data.
Consider creating data visualizations that illustrate the following information:
▪ How have the costs of goods sold (COGS) changed over the course of the year?
▪ How has the profit percentage changed over the course of the year?
Keep your target audience in mind as you choose which data visualizations to use. Look for
visualizations that best highlight the most useful information in a way that will be easiest for
your coworkers to interpret.
➢ Upload images of your data visualizations and explain their meaning for your
audience. as a JPEG or PNG file
➢ Explain what type of chart this is and the insights it provides about the success of
the product launch. 40 words.
➢ Upload your next data visualization as a JPEG or PNG file.
➢ Explain what type of chart this is and the insights it provides about the success of
the product launch 40 words.
➢ Restate the purpose of your analysis and summarize your most important findings.
Be sure to highlight what you learned from the data visualizations you created. 150
words.
If you used any research sources to inform your strategy, you must list them using APA Style.

Purchase answer to see full
attachment