The cake (is was) made by mom yesterday

The correct sentence is: "The cake was made by mom yesterday."

Using "is" would imply it was made recently or is still relevant now, but since it was made yesterday, "was" is the appropriate choice.