Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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?

image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Risk Management

Authors: Paul Hopkin

5th Edition

0749483075, 978-0749483074

More Books

Students also viewed these General Management questions

Question

What shorter and longer-term career goals spark your interest?

Answered: 1 week ago