The Jamtime Toy Manufacturing Company has an environmental goal to eliminate the use of non-recyclable packaging materials within the next five years. The company adopted this goal two years ago, so it has been tracking the pounds of non-recyclable packaging material it has used since that time. The company has two factories: the original factory in Tampa and a new factory in Scranton that opened three years ago.

The worksheet containing the monthly data from the past two years has the following format.

To follow are two charts that the production manager made using monthly data from the past two years.

Requirements:
1. List the steps that would be taken in Excel to create Chart 1: Non-Recyclable Pounds.
2. List the steps that would be taken in Excel to create Chart 2: Units Produced.
3. What trend(s) can you see in Chart 1? What trend(s) can you see in Chart 2? What other information might be useful for further analysis?

Transcribed Image Text:

1 2 Month 3 Year 1-Jan 4 Year 1-Feb 5 Year 1-Mar 6 Year 1-Apr B C Non-Recyclable Pounds Tampa Scranton D E F Units Produced Month Tampa Scranton