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.

 

A B C D E IF G IK Store # M N lolaloalue>>>>~$888833 AA Region Full 3 4 2 7 5 2 1 7 10 11 12 9 10 11 2 1 3 4 5 9 10 12 3 4 5 6 9 1 62 12 11 OF 10 2 8 9 006 8 6 1 Region 50% 1,2,5 2,3 1,7 6,8 4,10,12 5,12 2,3 6,9 11,12,1 12,1 10,3,4 7,8 9,11 6,7,9 4,5 3 2,5,7 3,6 4,6 7,8,10 11,1 2,9 4,5,6 7,9 6,8 7,10 11,12 2,4 7,9,10 9,11 8,9 12,2 3,4 9,1 10,11 7,9 3,4,5 12 218 Sales metric A 82 71 66 59 63 70 80 90 47 77 83 68 65 75 85 95 98 62 73 80 81 52 61 64 72 78 79 85 92 88 89 77 66 55 44 85 83 86 www~~66688686320GB00 44 35 33 44 22 48 47 49 40 21 19 18 37 34 35 41 29 31 24 25 35 45 46 39 29 22 42 33 43 36 Staff 12 10 555555EEEEEEEEEEEEEEEEEE 11 20 15 12 10 16