Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using Data Visualization to Analyze Financial Information DA 6.1 Data visualization can be used to compare changes over time. The millions of pounds of products

Using Data Visualization to Analyze Financial Information DA 6.1 Data visualization can be used to compare changes over time. The millions of pounds of products reacquired at end-of life received from customers, and the percentage of actual end-of-life returns and materials that were usable as recycling materials by Caterpillar during 2016 through 2019 are presented here. Measure 2016 2017 2018 2019 Weight in millions of pounds of end-of-life returned materials received 125 130 155 153 Percentage of actual end-of-life returns usable for recycling 91% 92% 92% 91% Instructions There are three parts to this problem. Use Excel or the visualization software of your or your instructors choice to perform the following: a. Create a combination column and line chart that graphs the pounds of product materials received from 2016 to 2019 as bars on the primary vertical axis, and the percentage of the materials received that are usable as a line on the secondary vertical axis. Include a descriptive chart title, axes labels, properly formatted axes, and a legend. b, What information does the chart provide? Explain. c. What do you think that management can do to increase its gross profit as it relates to the end-of-life materials received from customers?

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

Internal Audit Of The Future The Impact Of Technology Innovation

Authors: An Anthology Compiled And Contributed To By A. Michael Smith

1st Edition

1634540638, 978-1634540636

More Books

Students also viewed these Accounting questions

Question

Explain the nature of human resource management.

Answered: 1 week ago

Question

Write a note on Quality circles.

Answered: 1 week ago

Question

Describe how to measure the quality of work life.

Answered: 1 week ago