BIP On Your Own $-$ Problem #$2$

Locate two fire stations to minimize the response time across all calls.

Zone Response Time $($in minutes$)[["$ Cost $"],[51","000)]123415123020152002204151025250315206151240042515254103005102515125500$ Frequency $(/$day$)$: $21313$

Now consider the additional constraints that a fire station must be located such that all calls can be responded to in less than $15$ minutes. We can have as many fire stations as we like but the objective is now to minimize cost.

Solve using Excel and Solver