No image of the design yet Steve, hopefully we will see something the middle of next month. Daniel Carr said he had a few things that had to be done by then, Merlin is after that. All of that said, below are the calculations that I have been working on the last 2 nights.
The first attachment is the order list with the costs owed to Daniel Carr. The costs of the Morgans and Ikes are not included in this list. I have sent this list to Daniel Carr for approval, and will start on the payment instructions when he approves the cost list.
The second attachment is the cost list for the Morgans, and the Ikes for overstrikes. I bought some at coin shows, and some at the local coin store. This is where part of the price for these came from.
The third attachment is the updated main calculation spreadsheet. As mentioned at the beginning of this Medallion quest thread, the prices for each medal will be rounded up to the nearest dollar. The extra change from each medal will stay with Barry in the castle treasury for web fees. Shipping to each member is not included in the prices of the medals. This will be collected separately when the actual shipping cost is known. The spot price for these calculations is $20 right now. It has been hanging between $19.50 and $20.50 the past couple weeks. If spot is above $20 when we lock in the price, the difference will be collected with shipping. Any drop in spot will go to the treasury.
I have also posted the final order lists.
My head is spinning from all the math and calculations.... I went through the main sheet for more than a few hours and found a few small errors form when orders changed, but there is still an unexplained $27 difference from the money owed to Daniel Carr, and the main calculation list total. About $12 can be explained since the paypal calculation is incorrect for the Morgans and Ikes, but this money will be used to ship them to Daniel Carr for overstriking. About $420 difference is for the cost of the Morgans and Ikes. The total of $6641 probably makes this amount insignificant. At this point I don't think it will make a difference since we are rounding them all up. Thoughts?