To make sense of all the data available to them, business leaders work alongside data scientists who generate data visualizations to understand business questions via analytics. This process gives companies insight on what is working and what is not: for example, whether the products or services offered are meeting expectations, or if a shift in strategy is necessary.

Prompt

 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 Spreadsheet retrieved from the company's data center and consider the following while developing your ideas.

• 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?

Transcribed Image Text:

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

Answer rating: 100% (QA)

Answer To the team Ive conducted an analysis of our recent product launch to better understand its f... View the full answer