The manufacture of appliances can produce hazardous waste. New manufacturing facilities and processes can eliminate or greatly
Question:
The manufacture of appliances can produce hazardous waste. New manufacturing facilities and processes can eliminate or greatly decrease the amount of hazardous waste generated. In addition, products themselves can be reengineered to lessen hazardous waste generation. The Samson Appliance Company has a goal to eliminate the generation of hazardous materials in its manufacturing process within the next 10 years. Samson has been tracking the pounds of hazardous waste it has generated for the past few years. The company has two factories: the original factory in Dayton and a new factory in Madison that opened two years ago to meet increasing demand. In the 12 months after the new factory in Madison opened, Samson gradually replaced its aging manufacturing equipment in its Dayton factory with new state-of-the-art equipment.
The worksheet containing the monthly data from the past two years has the following format.
To follow are three 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: Pounds of Hazardous Waste.
2. List the steps that would be taken in Excel to create Chart 2: Units Produced.
3. Describe how the pounds per unit for Dayton in Cell J3 would be calculated, assuming that data populate Columns A through G. Describe how the pounds per unit for Madison in Cell K3 would be calculated. How could you get the formulas you just described for Cells J3 and K3 into the remainder of the cells in those columns?
4. List the steps that would be taken in Excel to create Chart 3: Hazardous Pounds per Unit.
5. What trend(s) can you see in Chart 1? In Chart 2? In Chart 3? What are some potential reasons for these trends?
Step by Step Answer:
