Were you able to nail down where the discrepancies were? I'm intrigued. My money is on minor pricing changes since the catalog was published.
I believe I figured it out, and pricing differences are one component.
As far as I can tell, and this is just with a lot of excel math comparing the price I had from the catalog vs the price that was listed in the spreadsheet, I found several issues with how everything was tallied-up.
(1) The fuel surcharge. We thought it applied to only one pallet's rate (20% of $65), but it actually applies to all pallets (20% of $130 in our case). BUT... this is an error in the other direction. If I correct this issue, then the spreadsheet comes up with an additional $13 added to the total.
(2) Sales Tax. This really where the error comes from. There was NO tax. No 7.75% added on to the price of the bags. No 7.75% added onto the shipping. We were not charged any tax at all by NCM, but tax was added in the spreadsheet.
(3) And finally, pricing differences. The price per pound is off by a few pennies on nearly everything. It could be differences since the catalog was printed, or it could be related to which facility we used. The catalog we used is from their NY warehouse, because that was the facility we used on the first bulk buy. But, there is a link on their website for catalog for each different facility. Reelale's "greatmalt" password does not work for the NC catalog, so I've never actually seen the NC catalog, and we just used the NY catalog.
If I correct the fuel surcharge on the spreadsheet and zero out the sales tax, then I see that:
- All Great Western malts are $0.04/lb less expensive than what was in the catalog.
- Canadian Malting 2-row was $0.04/lb more expensive than the catalog shows (all other Canadian malts are accurately priced).
- Best , Baird's, and Fawcett malts are $0.01/lb more expensive than the catalog.
- Franco Belgian stuff wasn't consistent. The aromatic was cheaper, but the other stuff was more expensive.
- all other malts not specified above were accurately priced.
In general, most of the grains appear to me more expensive than the catalog showed.
So... at the end of the day, we UNDERCHARGED for grain and fuel by about $50, but we OVERCHARGED via the tax by about $200, which gives us the $150 error.
For most folks, the over-charge was only a couple of bucks, and we even did had a few people that were undercharged by a few cents.
Since it was the tax that was the main source of error, the more grain you bought, the more your overpayment was. So, folks like BrewBear00 and Skip got hit with large over-charges.
I PMed those that got hit with the larger over charges today to let them know the amounts, but here's a full list of over payments for full disclosure:
Code:
foltster $7.86
HoppyGus $0.18
Barc $5.21
Stimulus $17.00
fatguy-littlecoat $5.20
mtbrider ($0.33) underpay
skeeordye11 $3.04
Reelale $0.61
Walker $1.77
Chad $2.90
Moterbiker $1.74
fbgillam $3.57
NCBeernut $4.23
Hannable1975 $3.25
longdvsn ($0.33) underpay
joeybeer $3.49
TheSeether $2.08
BrewBear00 $51.53
marc06 $5.37
ezzieyguywuf ($0.17) underpay
Moby $0.38
Skip $40.87