Answer:
Step-by-step explanation:
a) The value in C22 is the amount of inventory Store B has of Product Y at the end of July. That value is the starting inventory, 476, less July sales, 87, so will be ...
476 -87 = 389 = C22
__
b) The maximum possible sales of Product Z by Store A in July will be the amount they have in starting inventory, 376. Max(A31) = 376.
___
Additional comment
We have to assume that stores don't share inventory, and that there is no incoming product during the month.
