Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started