The Skylark 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 Boston and a new factory in Charlotte that opened three years ago. To follow is a partial listing of the pounds of non-recyclable packaging used each month as well as the number of units produced at both factories. Access the Excel file online in the MyLab Accounting exercise to complete the requirements for this exercise.

Requirements
1. Create a clustered column chart for the months and non-recyclable packaging pounds by factory.
2. Create a clustered column chart for the months and units produced by factory.
3. What trends can you see in the clustered column charts you created in Requirements 1 and 2? What other information might be useful for further analysis?

Transcribed Image Text:

A 1 2 Month 3 Year 1-Jan 4 Year 1-Feb 5 Year 1-Mar 6 Year 1-Apr 7 Year 1-May 8 Year 1-June 9 Year 1-July B C Non-Recyclable Pounds Boston Charlotte 28,751 26,716 23,973 22,904 22,595 22,548 21,577 40,879 40,681 44,116 46,645 46,422 43,772 43,983 D E Month Year 1-Jan Year 1-Feb Year 1-Mar Year 1-Apr Year 1-May Year 1-June Year 1-July F G Units Produced Boston Charlotte 40,181 37,349 33,432 31,927 31,378 31,295 29,864 21,553 21,412 23,201 24,489 24,323 22,534 22,583