Remove 1 item Removes multiple lines (stock control) (BoM)

Hi,

If I had a sheet that had components of a car with stock for example:
Tyres 500
Engine 300
Chassis 250

1 car equals 4 tyres, 1 engine, 1 chassis

Is there a way I can:
A) calculate how many cars I can make
B) take 1 car out of stock (and it automatically remove the components from a separate sheet)?

Apologies if this is tricky but im certain there must be a way.

Thanks in advance