2/16/2016 Module 3 Assignment Page 3 Merchandise MerchI MerchName MerchPric MerchType d MC Wilson balls $3 Balls MC2 Wilson racket $200 Racket MC3 Adidas shoes $100 Shoes MC4 Racket stringing $40 Racket Member Mmbri MmbrNam MmbrZi Mem Typel MmbrDate Franchid MmbrEmail d p d 1111 Joe 98011 M1 1-Feb-2009 F1 joe@serv1.com 2222 Mary 80112 M2 1-Jan-2010 F2 mary@serv2.com 3333 Sue 45327 ME 3-Mar-2011 F3 sue@serv3.com 4444 George 45236 F3 george @serv4.com Sale Saleld SaleDate Mmbrid 1111 10-Feb-2013 1111 2222 13-Feb-2013 2222 3333 13-Feb-2013 2222 4444 14-Feb-2013 3333 Contains Merch Saleld Qty d MC1 1111 2 MC2 1111 MC4 2222 MC3 3333 MC4 4444 ServicePurchase ServPurchl ServPurchat Mmbrl PassCatl d 1111 13-Feb-2013 1111 SC1 2222 14-Feb-2013 2222 SC 4444 15-Feb-2013 4444 SC3 Franchises also sell special events to corporate and other organizations. Since special event promotions and sales are not standard among franchises, spreadsheets are typically used to track special events. The franchise sales database was never extended to accommodate special event sales. The Special Events Worksheet shows a typical format for tracking special event sale by a franchise. Most franchises use a similar spreadsheet