CMPS 209 Homework Assignment 5 Solution, Spring 2015

Donations L Full Name City / State Item Donated Category Vickie Anderson Greeley, CO MP3 Player Equipment Michael Anderson Topeka, KS Gift Basket Product Natalie Barguno Phoenix, AZ Toy Store Gift Certificate Gift Certificate Dennis Boothe Alva, OK YMCA Swimming Lessons Service Benjamin Brown Tucson, AZ Digital Camera Equipment Emiko Francani Emporia, KS Floral Arrangement Gift Certificate Robert Hall Denver, CO Grocery Gift Certificate Gift Certificate Tara Huber Omaha, NE Laptop Computer Equipment Kevin Jackson Amarillo, TX Movie Tickets + Popcorn Gift Certificate Peggy Jackson Grand Junction, CO Restaurant Gift Certificate Gift Certificate Kim Jansen Oklahoma City, OK MP3 Player Equipment Kim Jones Oklahoma City, OK Fondue Set Product Kelly Kripton Dodge City, KS Football Tickets Product Kristen Kripton Fort Collins, CO Free Photography Sitting Service Larry Lopez Topeka, KS Restaurant Gift Certificate Gift Certificate George Martin Denver, CO Car Wash Card Other Shelly Martin San Fransisco, CA Massage Other Catherine McCue Tulsa, OK Restaurant Gift Certificate Gift Certificate Marion McMahon Tulsa, OK Automotive Gift CertificateGift Certificate Robert McMahon Lincoln, NE Web Site Services Service Catherine McQuaideDallas, TX 10 pounds of Fresh Fish Product Anita Miller Grand Junction, CO MP3 Player Equipment Huong Ngyun Dallas, TX Gym Membership Other Ian Parker Lubbock, TX Gym Membership Gift Certificate Huong Pham Colorado City, CO Restaurant Gift Certificate Gift Certificate Donna Reed Dumas, TX Hotel Accommodations Gift Certificate Dan Reed Austin, TX Yoga Class Service Jennifer Ward Houston, TX 1-Year Free Coffee Product Bobby Wilcox Lincoln, NE Automotive Gift CertificateGift Certificate Idelle Wilcox Oklahoma City, OK Restaurant Gift Certificate Gift Certificate Donations List Quantity Total Value Message Group 2 $145 $290 Group A 3 $75 $225 Group C 3 $50 $150 Group C 2 $65 $130 Group C 1 $400 $400 Group A 2 $75 $150 Group C 3 $50 $150 Group C 1 $1,000 $1,000 Thanks for your generous donation! Group A 4 $30 $120 Group C 2 $75 $150 Group C 3 $200 $600 Thanks for your generous donation! Group A 4 $20 $80 Group C 2 $75 $150 Group C 2 $45 $90 Group C 4 $40 $160 Group C 2 $50 $100 Group C 2 $50 $100 Group C 2 $40 $80 Group C 2 $50 $100 Group C 2 $100 $200 Group B 3 $100 $300 Group B 4 $145 $580 Thanks for your generous donation! Group A 2 $250 $500 Thanks for your generous donation! Group B 3 $200 $600 Thanks for your generous donation! Group B 3 $60 $180 Group C 2 $100 $200 Group B 2 $100 $200 Group B 1 $100 $100 Group B 1 $100 $100 Group B 4 $45 $180 Group C Individual Value Prizes 2nd prize 1st prize 3rd prize Donations List Full Name City / State Item Donated Category Vickie Anderson Greeley, CO MP3 Player Equipment Michael Anderson Topeka, KS Gift Basket Product Natalie Barguno Phoenix, AZ Toy Store Gift Certificate Gift Certificate Dennis Boothe Alva, OK YMCA Swimming Lessons Service Benjamin Brown Tucson, AZ Digital Camera Equipment Emiko Francani Emporia, KS Floral Arrangement Gift Certificate Robert Hall Denver, CO Grocery Gift Certificate Gift Certificate Tara Huber Omaha, NE Laptop Computer Equipment Kevin Jackson Amarillo, TX Movie Tickets + Popcorn Gift Certificate Peggy Jackson Grand Junction, CO Restaurant Gift Certificate Gift Certificate Kim Jansen Oklahoma City, OK MP3 Player Equipment Kim Jones Oklahoma City, OK Fondue Set Product Kelly Kripton Dodge City, KS Football Tickets Product Kristen Kripton Fort Collins, CO Free Photography Sitting Service Larry Lopez Topeka, KS Restaurant Gift Certificate Gift Certificate George Martin Denver, CO Car Wash Card Other Shelly Martin San Fransisco, CA Massage Other Catherine McCue Tulsa, OK Restaurant Gift Certificate Gift Certificate Marion McMahon Tulsa, OK Automotive Gift CertificateGift Certificate Robert McMahon Lincoln, NE Web Site Services Service Catherine McQuaideDallas, TX 10 pounds of Fresh Fish Product Anita Miller Grand Junction, CO MP3 Player Equipment Huong Ngyun Dallas, TX Gym Membership Other Ian Parker Lubbock, TX Gym Membership Gift Certificate Huong Pham Colorado City, CO Restaurant Gift Certificate Gift Certificate Donna Reed Dumas, TX Hotel Accommodations Gift Certificate Dan Reed Austin, TX Yoga Class Service Jennifer Ward Houston, TX 1-Year Free Coffee Product Bobby Wilcox Lincoln, NE Automotive Gift CertificateGift Certificate Idelle Wilcox Oklahoma City, OK Restaurant Gift Certificate Gift Certificate nations List Quantity Total Value 2 $290 3 $225 3 $150 2 $130 1 $400 2 $150 3 $150 1 $1,000 4 $120 2 $150 3 $600 4 $80 2 $150 2 $90 4 $160 2 $100 2 $100 2 $80 2 $100 2 $200 3 $300 4 $580 2 $500 3 $600 3 $180 2 $200 2 $200 1 $100 1 $100 4 $180 Analysis Did the total number of gifts reach 75 items? No If not, how many items are still needed? 2 items are still needed Is the total value of all donated "Product" items above 800$? Yes No, they are the same! Is the number of donors who donated "Equipment" items different than the number of donors donating "Product" items? & Vickie Anderson, from Greeley, CO, donated 2 Equipments Michael Anderson, from Topeka, KS, donated 3 Products Natalie Barguno, from Phoenix, AZ, donated 3 Gift Certificates Dennis Boothe, from Alva, OK, donated 2 Services Benjamin Brown, from Tucson, AZ, donated 1 Equipment Emiko Francani, from Emporia, KS, donated 2 Gift Certificates Robert Hall, from Denver, CO, donated 3 Gift Certificates Tara Huber, from Omaha, NE, donated 1 Equipment Kevin Jackson, from Amarillo, TX, donated 4 Gift Certificates Peggy Jackson, from Grand Junction, CO, donated 2 Gift Certificates Kim Jansen, from Oklahoma City, OK, donated 3 Equipments Kim Jones, from Oklahoma City, OK, donated 4 Products Kelly Kripton, from Dodge City, KS, donated 2 Products Kristen Kripton, from Fort Collins, CO, donated 2 Services Larry Lopez, from Topeka, KS, donated 4 Gift Certificates George Martin, from Denver, CO, donated 2 Others Shelly Martin, from San Fransisco, CA, donated 2 Others Catherine McCue, from Tulsa, OK, donated 2 Gift Certificates Marion McMahon, from Tulsa, OK, donated 2 Gift Certificates Robert McMahon, from Lincoln, NE, donated 2 Services Catherine McQuaide, from Dallas, TX, donated 3 Products Anita Miller, from Grand Junction, CO, donated 4 Equipments Huong Ngyun, from Dallas, TX, donated 2 Others Ian Parker, from Lubbock, TX, donated 3 Gift Certificates Huong Pham, from Colorado City, CO, donated 3 Gift Certificates Donna Reed, from Dumas, TX, donated 2 Gift Certificates Dan Reed, from Austin, TX, donated 2 Services Jennifer Ward, from Houston, TX, donated 1 Product Bobby Wilcox, from Lincoln, NE, donated 1 Gift Certificate Idelle Wilcox, from Oklahoma City, OK, donated 4 Gift Certificates Donations List Full Name Category Quantity Vickie Anderson Equipment 2 $145 $58.00 Michael Anderson Product 3 $75 $45.00 Natalie Barguno Gift Certificate 3 $50 $30.00 Dennis Boothe Service 2 $65 $26.00 Benjamin Brown Equipment 1 $400 $80.00 Emiko Francani Gift Certificate 2 $75 $30.00 Robert Hall Gift Certificate 3 $50 $30.00 Tara Huber Equipment 1 $1,000 $200.00 Kevin Jackson Gift Certificate 4 $30 $24.00 Peggy Jackson Gift Certificate 2 $75 $30.00 Kim Jansen Equipment 3 $200 $120.00 Kim Jones Product 4 $20 $16.00 Kelly Kripton Product 2 $75 $30.00 Kristen Kripton Service 2 $45 $18.00 Larry Lopez Gift Certificate 4 $40 $32.00 George Martin Other 2 $50 $20.00 Shelly Martin Other 2 $50 $20.00 Catherine McCue Gift Certificate 2 $40 $16.00 Marion McMahon Gift Certificate 2 $50 $20.00 Robert McMahon Service 2 $100 $40.00 Catherine McQuaide Product 3 $100 $60.00 Anita Miller Equipment 4 $145 $116.00 Huong Ngyun Other 2 $250 $100.00 Ian Parker Gift Certificate 3 $200 $120.00 Huong Pham Gift Certificate 3 $60 $36.00 Donna Reed Gift Certificate 2 $100 $40.00 Dan Reed Service 2 $100 $40.00 Jennifer Ward Product 1 $100 $20.00 Bobby Wilcox Gift Certificate 1 $100 $20.00 Idelle Wilcox Gift Certificate 4 $45 $36.00 Total Amount $1,473.00 Which Scenario needs a higher budget? scenario 1 Which Scenario needs a lower budget? Individual Value Thank you Gift Scenario One scenario 2 Which scenario should be followed, knowing that the budget specified for the thank you gift is: 1500$? Scenario 1 Donations List $400 $240 $232 $200 $240 $1,312.00 Which Scenario needs a higher budget? scenario 1 Which Scenario needs a lower budget? Thank you gift Scenario Two scenario 2 owed, knowing that the budget specified for the thank you gift is: 1500$? Scenario 1