sales territory planning at caro-life

Project Description:

task is from book spreadsheet modeling and decision analysis edition 6th chapter 7 case 7.3 by cliff ragsdale

(1.1) assuming caro-life is aiming to maximise the average sales potential of its ten offices, formulate this maximisation problem.
(1.2) design a spreadsheet model for (1.1) and solve it to identify the office locations, the population and the geographic area associated with each office.
(1.3) assuming caro-life is aiming to minimise the average geographic area covered by each of its ten offices, formulate this minimisation problem.
(1.4) design a spreadsheet model for (1.3) and solve it to identify the office locations, the population and the geographic area associated with each office.
(1.5) determine the solution that minimises the maximum percentage deviation from the optimal objective function values identified in (1.2) and (1.4). based on this solution, identify the office locations, the population and the geographic area associated with each office.
(1.6) suppose caro-life considers maximising average sales potential of its territories to be twice as important as minimising the average geographic size of its territories. propose a solution that minimises the maximum weighted percentage deviations. based on this solution, identify the office locations, the population and the geographic area associated with each office.
Skills Required:
Project Stats:

Price Type: Fixed

Project Budget: $10 to $20
Expired
Total Proposals: 4
1 Current viewersl
46 Total views
Project posted by:

Proposals

Proposals Reputation Price offered
  • 4.8
    2 Jobs 1 Reviews
    $70 in 15 Hours
  • 4.9
    522 Jobs 333 Reviews
    $50 in 3 Days
  • 0.0
    1 Jobs 0 Reviews
    $40 in 3 Days
  • 4.9
    26 Jobs 9 Reviews
    $39 in 14 Hours