please explain formulas used.

3. Recycling Can For the past 10 years, five Colorado cities have heid a recycling contest to see which city does the best job of recycling plastic, glass, and aluminum. The citles participating in this year's contest are Arvada, Centennial, Lakewood, Highlands Ranch, and Parker. To make the contest fair for both large and small cities, the winning city will be the one that recycles the largest number of cans per capita-the number of cans recycled divided by the number of city residents. You have been asked to help the coordinator, Jill Slater, to compile the numbers in an Excel worksheet and create the formulas to compute the total recycling by city each month, total recycling for all cities each month, and the per-capita recycling value that determines the contest winner. In addition, Jill wants to know a few statistics about the monthly recycling efforts, induding the minimum, average, and maximum number of cans recycled. Jill has provided you with sample data, T2 RecyclingCans Data File.xIsx. Figure T2.22 shows a sample of what Jill would like to see as a completed worksheet. 4. MusicPlayerz Sales Projections MusicPlayerz is a wholesale MP3 distributor headquartered in Morison, Colorado. Corporate buyers for the retall stores contract with MusicPlayerz to supply and ship MP3s to warehouses scattered throughout the western United States. MusicPlayer chief procurement officer Juliamne Beekman oversees the purchase and distribution operations for all divisions from the Morison office. 3. Recycling Can For the past 10 years, five Colorado cities have heid a recycling contest to see which city does the best job of recycling plastic, glass, and aluminum. The citles participating in this year's contest are Arvada, Centennial, Lakewood, Highlands Ranch, and Parker. To make the contest fair for both large and small cities, the winning city will be the one that recycles the largest number of cans per capita-the number of cans recycled divided by the number of city residents. You have been asked to help the coordinator, Jill Slater, to compile the numbers in an Excel worksheet and create the formulas to compute the total recycling by city each month, total recycling for all cities each month, and the per-capita recycling value that determines the contest winner. In addition, Jill wants to know a few statistics about the monthly recycling efforts, induding the minimum, average, and maximum number of cans recycled. Jill has provided you with sample data, T2 RecyclingCans Data File.xIsx. Figure T2.22 shows a sample of what Jill would like to see as a completed worksheet. 4. MusicPlayerz Sales Projections MusicPlayerz is a wholesale MP3 distributor headquartered in Morison, Colorado. Corporate buyers for the retall stores contract with MusicPlayerz to supply and ship MP3s to warehouses scattered throughout the western United States. MusicPlayer chief procurement officer Juliamne Beekman oversees the purchase and distribution operations for all divisions from the Morison office