Weber Electric Cars have captured the imagination of car owners everywhere - but sales have not kept up with the hype due to the high price of the vehicles. You play the role as a District Sales Manager for 38 Weber Retail stores in the Texas region. These stores are typically located at shopping malls and are fairly ubiquitous. Due to organizational revenue pressures, you have been asked to submit a plan that reduces the number of operational stores in your region while maintaining enough of a presence that the Weber logo and hype remains seared into the memory of all humanity who long for a 'green world'. Each retail store has certain attributes relevant to your reduction plan. Each store is located in one of 12 REGIONS. Thus, a store is said to 'cover' the region in which it is located. Each retail store also is considered to "overlap" other regions due to its specific physical location. This overlap is equivalent to 50% of a store. A retail store can therefore simultaneously 'cover' the region in which it is located (100%), as well as multiple other regions at a 50% value. This 'coverage' data is pertinent to determining which stores will remain open. Each retail store employs a certain number of sales staff (between 6 and 21). Each retail stores' productivity is measured by two different sales metrics (call them A, and B). Higher values are better than lower values. "A" can range from 1-100, "B" can range from 1-50. The data for the 38 existing stores are provided on a separate spreadsheet. Your task: Determine which of the 38 stores should remain open such that you maximize the total sum of Sales Metric A for the open stores. Your plan though must meet the following requirements: a) Each region must contain one open store, but no more than 2 open stores. b) In terms of coverage, each region must be covered by at least 2 equivalent stores, but no more than 3 equivalent stores. (recall, stores count as either 100% or 50% for a region based upon their location attributes). c) Your plan must retain at least 220 sales staff members (assume if a store is open, their entire staff is retained - otherwise, the staff is 'not retained'). d) The stores that are kept open must average at least 37 on Sales Metric B. Summarize your plan for upper management by showing which stores remain open and how they meet these specifications.

.... Staff Store # Region Region Sales metric ....ja Full ..... 50% A B 32 12 A 3 1,2,5 82 6 B 4 2,3 71 44 .... ...... C 2 66 20 9 1.7 . ... 10 D 6,8 59 35 7 63 33 9 5 4,10,12 ..... -... 8 2 5,12 70 44 ..... 80 22 11 G 1 2,3 .... 90 48 20 7 6,9 15 10 11,12,1 47 47 12.1 77 49 13 11 ... 12 10,3,4 83 40 9 7 9 7,8 68 32 ..... 9 ..... .. M 10 9,11 65 21 75 19 18 11 6,7,9 ..... 85 18 15 O 2 4,5 ...... 37 14 3 95 P ..... 3 2,5,7 98 36 12 Q ..j.. 62 34 10 R A 3,6 35 11 S 5 4,6 73 ..... ..... 80 41 13 9 7,8,10 8 10 11,1 81 29 21 12 2,9 52 19 3 4,5,6 61 31 W ..... ..... 7,9 64 26 18 4 72 24 19 5 6,8 78 25 18 17 6 7,10 ..... 35 17 AA 9 11,12 79 .... ....... .... 2,4 85 45 13 BB 1 46 15 CO 6 7,9,10 92 DD 12 9,11 88 39 16 8,9 89 29 8 EE 11 ... .... 77 22 6 ..... FF 10 12.2 9 GG 2 3,4 66 32 9,1 55 42 10 HH 8 44 23 11 10,11 ...... 7,9 85 33 13 8 ...... 6 3,4,5 83 43 12 KK 12 86 36 14 LL 1Histogram of Skewed Continuous 60- 50 40 Frequency 30 20 10 32000 64000 96000 128000 160000 192000 Skewed Continuous