**** Need completed by 9pm CST 11/7*** Only need spreadsheet and pivot table created ******
Spreadsheets and databases provide tools for organizing and evaluating data. The York Middle School (YMS) serves the following neighborhoods: Euclid, Parma, Tremont, Cuyahoga, and Lakewood.
The YMS Marching Band needs new uniforms and is selling candy bars to raise funds.
Here are the band members and the neighborhoods they live closest to:
7th Graders:
Sebastian—Tremont
Christin—Cuyahoga
Pablo—Cuyahoga
Matthew—Tremont
Blake—Tremont
Lisa—Cuyahoga
Charles—Cuyahoga
8th Graders:
Dominic—Parma
Lauren—Lakewood
Stella—Parma
Pedro—Euclid
Rochelle—Euclid
Deshaun—Cuyahoga
Max—Lakewood
Mary—Lakewood
Frank—Lakewood
Edward—Cuyahoga
Lillian—Lakewood
Henry—Parma
Carla—Parma
Bekah—Lakewood
Marcella—Lakewood
9th Graders
Gray—Euclid
Daniel—Euclid
Erin—Tremont
Petra—Tremont
Amber—Euclid
Omega—Euclid
Macon—Tremont
Ken—Tremont
Each member is selling three different types of candy bars: the Traditional, the Crunch Magic, and the Caramel Joy. The students have decided to sell within their own neighborhoods to minimize the driving required and to avoid oversaturating any one market. Each student is required to sell 45 candy bars at $2 per candy bar. The student takes the orders and then delivers the candy bars at the end of the sale period.
Rosario, the band leader, hands out order sheets so all the bandmembers can enter the appropriate sales information. Rosario collects the completed order sheets and then brings the appropriate number of candy bars to the respective neighborhoods so students can deliver them to the customers/supporters.
At the end of the fundraiser, every student sold 45 candy bars in the following amounts:
Petra (13 Traditionals, 29 Crunch Magics, 3 Caramel Joys)
Ken (16 Traditionals, 29 Crunch Magics)
Sebastian (7 Traditionals, 22 Crunch Magics, 16 Caramel Joys)
Matthew (17 Traditionals, 17 Crunch Magics, 11 Caramel Joys)
Henry (25 Traditionals, 20 Caramel Joys)
Carla (10 Traditionals, 29 Crunch Magics, 6 Caramel Joys)
Blake (3 Traditionals, 29 Crunch Magics, 13 Caramel Joys)
Christin (21 Traditionals, 18 Crunch Magics, 6 Caramel Joys)
Pablo (28 Crunch Magics, 17 Caramel Joys)
Lisa (13 Traditionals, 19 Crunch Magics, 13 Caramel Joys)
Charles (17 Traditionals, 22 Crunch Magics, 6 Caramel Joys)
Deshaun (15 Traditionals, 18 Crunch Magics, 12 Caramel Joys)
Dominic (11 Crunch Magics, 34 Caramel Joys)
Stella (7 Traditionals, 21 Crunch Magics, 17 Caramel Joys)
Pedro (8 Traditionals, 17 Crunch Magics, 20 Caramel Joys)
Rochelle (16 Traditionals, 13 Crunch Magics, 16 Caramel Joys)
Gray (14 Traditionals, 31 Caramel Joys)
Daniel (7 Traditionals, 30 Crunch Magics, 8 Caramel Joys)
Amber (14 Traditionals, 17 Crunch Magics, 14 Caramel Joys)
Bekah (33 Traditionals, 3 Crunch Magics, 9 Caramel Joys)
Marcella (11 Traditionals, 19 Crunch Magics, 15 Caramel Joys)
Mary (20 Traditionals, 19 Crunch Magics, 6 Caramel Joys)
Lauren (19 Traditionals, 18 Crunch Magics, 8 Caramel Joys)
Omega (9 Traditionals, 25 Crunch Magics, 11 Caramel Joys)
Erin (28 Traditionals, 15 Crunch Magics, 12 Caramel Joys)
Edward (10 Traditionals, 21 Crunch Magics, 14 Caramel Joys)
Lillian (8 Traditionals, 27 Crunch Magics, 10 Caramel Joys)
Max (11 Traditionals, 34 Caramel Joys)
Macon (15 Traditionals, 19 Crunch Magics, 11 Caramel Joys)
Frank (13 Traditionals, 17 Crunch Magics, 15 Caramel Joys)
Rosario needs to organize the data to ensure that she delivers the correct number of candy bars to each neighborhood, where the associated students will pick up their candy bars and deliver them to their customers.
Craft a spreadsheet that organizes the data, and then create a pivot table that shows Rosario which, and how many, candy bars to deliver to each neighborhood.