Weber Electric Cars have captured the imagination of car owners everywhere - but sales have not kept
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Related Book For
Management A Practical Introduction
ISBN: 978-0078112713
5th edition
Authors: Angelo Kinicki, Brian Williams
Posted Date: