you will take on the role of a business leader who wishes to analyze if a new product their company has introduced is meeting the expectations. Imagine that you would like to create a post in the company intranet that summarizes your findings in an easy-to-read format for your team. Pay special attention to creating meaningful data visualizations. You should use techniques that make content easy to follow but that also display charts accurately without distorting or skewing data. Your company's profit goal is 25% of the cost of goods sold (COGS). Remember, COGS is the cost of manufacturing the product, including labor, materials, and overhead. You will need to build trust and an open channel of communication with other leaders on your team. Pay close attention to the story that data visualizations tell you and others reviewing your post.

The purpose of this analysis is to better understand the cost, revenue, and profit associated with the new product launch. Review the Cost, Revenue, and Profit Spreadsheetretrieved from the company's data center and consider the following while developing your ideas in this assignment.

• What is the importance of data analysis?
• What are the results of your analysis?
• Think about your analysis and its findings, including visuals. Use visuals and text to re-state the purpose of your analysis and summarize your most important findings.
  • What are you trying to represent with this data?
  • What kind of graphic have you selected and why?
• How did adding visual representations of the data change your analysis?
  • Does the target audience influence the way you display information?

B F G H J K L M N O P A C D E Feb Apr May Jun Jul Aug Sep Oct Nov Dec Annual Numbers Jan Mar 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 2 Labor 8,400.00 8,400.00 3 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 $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 Overhead (30%) $5,520.00 5 Profit (Goal 25%) $5,980.00 $5,980.0 $5,980.00 $5,980.00 $4,615.00 $4,615.091 $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 $0.25 $0.25 $0.25 $0.25 :0.2 $0.25 $0.25 10.2 $0.25 $0.25 8 Unit Price $0.25 0.25 $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 9 Total Revenue $5,000.00 $7,500.00 12 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 13 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 $5,520.00 $5,520.00 $5,520.00 $4,260.00 $4,260.00 $3,945.00 $3,945.00 $3,945.00 ,945.00 $3,945.00 $3,945.00 14 Overhead $5,520.00 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 15 Target Revenue -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 16 18 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 Cost of Goods 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 Total Revenue -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 Profit 4.18% Percent Profit