A matrix product state is an ansatz for a wavefunction, and it can be used for modeling the qubits associated wtih any circuit, depending on your desired accuracy. If you want all amplitudes in the wavefunction to have an error below $10^{-100}$, then you will need huge matrices in your matrix product state, even if the entanglement associated with the circuit is "small". If you just want a wavefunction for the qubits and don't care if its amplitudes have errors as big as $10^{-2}$ (for example), then you can use relatively small matrices in your matrix product state, even if the amount of entanglement is "large".
Therefore, the size of the matrices required in your matrix product state, do not depend just on the amount of entanglement between the qubits, but also on your desired error.
In extremely rare cases, like in the case of a GHZ state, the MPS ansatz will give you the wavefunction with zero error, without requiring huge matrices, so circuits like the following one are in the category that you seek:
However, this is not possible for the vast majority of circuits. The required size of the matrices in the MPS ansatz depends on the amount of entanglement between the particles (or qubits), and you asked:
"How can I calculate this quantity for a given quantum circuit?"
For any arbitrarily given circuit, it's not possible to represent the wavefunction of the qubits by an MPS ansatz with no error, without using resources that scale exponentially with the number of resources, so the size of the matrices that you need will depend not only on the nature of the circuit but also your desired accuracy. Finally, even if you asked "given a circuit and a desired maximum error of $\epsilon$ in the wavefunction amplitudes, how big do the matrices in the MPS ansatz have to be?", there is no known answer that applies to "any given circuit".