Youve introduced your post by explaining the importance of data analysis, and youve told the story of your products launch. Now its 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.

For guidance on different types of data visualizations, you can refer back to page 4.2. You can also refer to page 4.3 for guidance on how to create charts using Microsoft Excel.

In the template below, youll be asked to create graphs or charts and upload them as JPEG or PNG files. You may need to take a screenshot of these data visualizations in order to do so.

Use this writing template to upload images of your data visualizations and explain their meaning for your audience.

WRITING TEMPLATE

Upload your first data visualization here as a JPEG or PNG file.

	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Annual Numbers
Labor	8,400.00	8,400.00	8,400.00	8,400.00	4,200.00	4,200.00	3,150.00	3,150.00	3,150.00	3,150.00	3,150.00	3,150.00
Materials	$10,000.00	$10,000.00	$10,000.00	$10,000.00	$10,000.00	$10,000.00	$10,000.00	$10,000.00	$10,000.00	$10,000.00	$10,000.00	$10,000.00
Overhead (30%)	$5,520.00	$5,520.00	$5,520.00	$5,520.00	$4,260.00	$4,260.00	$3,945.00	$3,945.00	$3,945.00	$3,945.00	$3,945.00	$3,945.00
Profit (Goal 25%)	$5,980.00	$5,980.00	$5,980.00	$5,980.00	$4,615.00	$4,615.00	$4,273.75	$4,273.75	$4,273.75	$4,273.75	$4,273.75	$4,273.75
Number of Units Produced	100,000.00	100,000.00	100,000.00	100,000.00	100,000.00	100,000.00	100,000.00	100,000.00	100,000.00	100,000.00	100,000.00	100,000.00
Sold Units	20,000.00	30,000.00	90,000.00	50,000.00	30,000.00	90,000.00	90,000.00	100,000.00	120,000.00	120,000.00	120,000.00	120,000.00
Unit Price	$0.25	$0.25	$0.25	$0.25	$0.25	$0.25	$0.25	$0.25	$0.25	$0.25	$0.25	$0.25
Total Revenue	$5,000.00	$7,500.00	$22,500.00	$12,500.00	$7,500.00	$22,500.00	$22,500.00	$25,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00
Labor and Materials	18,400.00	18,400.00	18,400.00	18,400.00	14,200.00	14,200.00	13,150.00	13,150.00	13,150.00	13,150.00	13,150.00	13,150.00
Profit Goal	$4,600.00	$4,600.00	$4,600.00	$4,600.00	$3,550.00	$3,550.00	$3,287.50	$3,287.50	$3,287.50	$3,287.50	$3,287.50	$3,287.50
Overhead	$5,520.00	$5,520.00	$5,520.00	$5,520.00	$4,260.00	$4,260.00	$3,945.00	$3,945.00	$3,945.00	$3,945.00	$3,945.00	$3,945.00
Target Revenue	28,520.00	28,520.00	28,520.00	28,520.00	22,010.00	22,010.00	20,382.50	20,382.50	20,382.50	20,382.50	20,382.50	20,382.50
	-23,520.00	-21,020.00	-6,020.00	-16,020.00	-14,510.00	$490.00	2,117.50	4,617.50	9,617.50	9,617.50	9,617.50	9,617.50
Cost of Goods	23,920.00	23,920.00	23,920.00	23,920.00	18,460.00	18,460.00	17,095.00	17,095.00	17,095.00	17,095.00	17,095.00	17,095.00	235,170.00
Total Revenue	$5,000.00	$7,500.00	$22,500.00	$12,500.00	$7,500.00	$22,500.00	$22,500.00	$25,000.00	$30,000.00	$30,000.00	$30,000.00	$30,000.00	$245,000.00
Profit	-18,920.00	-16,420.00	-1,420.00	-11,420.00	-10,960.00	4,040.00	5,405.00	7,905.00	12,905.00	12,905.00	12,905.00	12,905.00	9,830.00
Percent Profit													4.18%