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

Part 1:

=MIN(B2/4,B3,B4)

Part 2 depends on whether or not folow is one way only (± restocking of components).

Something like this:

=500-SUM(I:I)*C3

or

=500-SUM(I:I)*C12+SUMIF(L:L,A12,M:M)

see sheet, as you need to see the context!!

You're welcome and thanks for the rep.