“do they sell that size box wine at Costco?”
97000 gallons is about 490,000 750 ml bottles.
At $10 per bottle that’s about 4.9 million dollars.
Your math is good. I only note that their cab retails for +/- $20 per bottle of which they likely receive about $10 per bottle. I am guessing that some employee is in a lot of trouble.