The word document is a rough outline of what’s needed, please fill up as mentioned into sections because I will paste it into the online book website. The excel sheet is the one attached for this assignment so please do the visualizations and writings based on that
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? Your response should be
between 100–200 words.
◼
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? Your response should be between 200–
300 words.
◼
Consider creating data visualizations that illustrate the following
information:
▪
How have the costs of goods sold (COGS) changed over the
course of the year?
Explain what type of chart this is and the insights it provides about the success of the
product launch. Your response should be between 30–50 words.
▪
How has the profit percentage changed over the course of the
year?
Explain what type of chart this is and the insights it provides about the success of the
product launch. Your response should be between 30–50 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. Your
response should be between 100–150 words.
◼
Jan
Feb
Mar
Apr
Labor
Materials
Overhead (30%)
Profit (Goal 25%)
Number of Units Produced
Sold Units
Unit Price
Total Revenue
8,400.00
$10,000.00
$5,520.00
$5,980.00
100,000.00
20,000.00
$0.25
$5,000.00
8,400.00
$10,000.00
$5,520.00
$5,980.00
100,000.00
30,000.00
$0.25
$7,500.00
8,400.00
$10,000.00
$5,520.00
$5,980.00
100,000.00
90,000.00
$0.25
$22,500.00
8,400.00
$10,000.00
$5,520.00
$5,980.00
100,000.00
50,000.00
$0.25
$12,500.00
Labor and Materials
Profit Goal
Overhead
Target Revenue
18,400.00
$4,600.00
$5,520.00
28,520.00
-23,520.00
18,400.00
$4,600.00
$5,520.00
28,520.00
-21,020.00
18,400.00
$4,600.00
$5,520.00
28,520.00
-6,020.00
18,400.00
$4,600.00
$5,520.00
28,520.00
-16,020.00
Cost of Goods
Total Revenue
Profit
Percent Profit
23,920.00
$5,000.00
-18,920.00
23,920.00
$7,500.00
-16,420.00
23,920.00
$22,500.00
-1,420.00
23,920.00
$12,500.00
-11,420.00
May
Jun
Jul
Aug
Sep
Oct
4,200.00
$10,000.00
$4,260.00
$4,615.00
100,000.00
30,000.00
$0.25
$7,500.00
4,200.00
$10,000.00
$4,260.00
$4,615.00
100,000.00
90,000.00
$0.25
$22,500.00
3,150.00
$10,000.00
$3,945.00
$4,273.75
100,000.00
90,000.00
$0.25
$22,500.00
3,150.00
$10,000.00
$3,945.00
$4,273.75
100,000.00
100,000.00
$0.25
$25,000.00
3,150.00
$10,000.00
$3,945.00
$4,273.75
100,000.00
120,000.00
$0.25
$30,000.00
3,150.00
$10,000.00
$3,945.00
$4,273.75
100,000.00
120,000.00
$0.25
$30,000.00
14,200.00
$3,550.00
$4,260.00
22,010.00
-14,510.00
14,200.00
$3,550.00
$4,260.00
22,010.00
$490.00
13,150.00
$3,287.50
$3,945.00
20,382.50
2,117.50
13,150.00
$3,287.50
$3,945.00
20,382.50
4,617.50
13,150.00
$3,287.50
$3,945.00
20,382.50
9,617.50
13,150.00
$3,287.50
$3,945.00
20,382.50
9,617.50
18,460.00
$7,500.00
-10,960.00
18,460.00
$22,500.00
4,040.00
17,095.00
$22,500.00
5,405.00
17,095.00
$25,000.00
7,905.00
17,095.00
$30,000.00
12,905.00
17,095.00
$30,000.00
12,905.00
Nov
Dec
Annual Numbers
3,150.00
$10,000.00
$3,945.00
$4,273.75
100,000.00
120,000.00
$0.25
$30,000.00
3,150.00
$10,000.00
$3,945.00
$4,273.75
100,000.00
120,000.00
$0.25
$30,000.00
13,150.00
$3,287.50
$3,945.00
20,382.50
9,617.50
13,150.00
$3,287.50
$3,945.00
20,382.50
9,617.50
17,095.00
$30,000.00
12,905.00
17,095.00
$30,000.00
12,905.00
235,170.00
$245,000.00
9,830.00
4.18%

Purchase answer to see full
attachment