There are $4$ sorting centers in the organization and they sort$/$ship orders to branches

Each sorting center has different hinterland and branches

You can see sales forecast and operational metrics for $6$ weeks, $($ please ignore the time and distance between sorting centers and branches $)$

According to information given above;

a$)$ Please show Sorting centers, branches and average daily order qty by week in one table

b$)$ In which branches there is an overcapacity problem?

c$)$ A new branch can be opened with min $500$ orders. Considering overcapacity in branches, how many new branches you should plan and which sorting center's hinterland should they belong to$?$

d$)$ What would be your strategy for managing this kind of flactuation on last mile operations. $($ This question is not related with the example, you can answer freely $)$

SC: Sorting Center

Hinterland: Sorting Center's distribution area$/$branches

Workdays$/$Week: $6$ days

Metric Week $1$ Week $2$ Week $3$ Week $4$ Week $5$ Week $6$

Forecasted Order Qty $352,200352,380439,380522,791419,403360,930$

Metric SC $1$ SC $2$ SC $3$ SC $4$

Order Rate $35\mathrm{.}11\%18\mathrm{.}89\%38\mathrm{.}45\%7\mathrm{.}56\%$

SC $1\text{'}$s HINTERLAND SC $2\text{'}$s HINTERLAND SC $3\text{'}$s HINTERLAND SC $4\text{'}$s HINTERLAND

Branch Name Order Rate Daily Capacity Branch Name Order Rate Daily Capacity Order Rate Daily Capacity Branch Name Order Rate Daily Capacity

Branch $18\mathrm{.}85\%3,000$ Branch $108\mathrm{.}88\%2,50021\mathrm{.}11\%7,000$ Branch $2222\mathrm{.}26\%2,500$

Branch $211\mathrm{.}23\%3,500$ Branch $1126\mathrm{.}83\%5,0009\mathrm{.}81\%4,000$ Branch $2334\mathrm{.}14\%1,750$

Branch $310\mathrm{.}70\%3,500$ Branch $1220\mathrm{.}23\%4,0005\mathrm{.}89\%2,250$ Branch $2443\mathrm{.}60\%2,250$

Branch $411\mathrm{.}61\%3,000$ Branch $1330\mathrm{.}24\%5,00012\mathrm{.}28\%3,500$

Branch $58\mathrm{.}17\%2,000$ Branch $1413\mathrm{.}82\%2,50020\mathrm{.}55\%7,000$

Branch $611\mathrm{.}64\%4,0006\mathrm{.}26\%3,000$

Branch $713\mathrm{.}82\%4,00024\mathrm{.}10\%7,750$

Branch $817\mathrm{.}39\%4,500$

Branch $96\mathrm{.}60\%2,250$