food co-op at city of the sun
email announcement - invoice example - accounts summary
food co-op at cos order ship paid 2006 july 15 - 22 august 12 - 19 september 9 - 16 october 7 - 14 november 4 - 11 december 2 - 9 2007 january 1 - 6
vansprouts 7 orders 1118.76 284.29 180.22 184.34 145.85 105.94 138.59 79.52
49% ship 1059.65 275.74 166.32 177.27 126.14 115.10 119.55 79.52
0.00 paid 1059.65 275.74 166.32 179.85 145.00 93.66 119.55 79.52
paceneal 4 orders 71.56 17.89 17.89 17.89 17.89
2% ship 53.67 17.89 0.00 17.89 17.89
0.00 paid 53.67 18.00 -0.11 17.89 17.89
seansands 3 orders 454.94 175.31 84.88 194.75
20% ship 432.23 167.49 78.18 186.56
13.45 paid 445.68 175.00 70.68 200.00
electricpine 3 orders 170.48 42.20 61.30 66.98
8% ship 170.48 42.20 61.30 66.98
0.77 paid 171.25 42.25 65.00 64.00
gdtaylor41 4 orders 438.83 99.57 263.64 52.96 22.66
15% ship 327.96 72.77 196.75 35.78 22.66
72.04 paid 400.00 100.00 250.00 0.00 50.00
andreainus 1 orders 66.79 66.79
3% ship 68.33 68.33
0.00 paid 68.33 66.07 2.26
eyeofthemountain 1 orders 60.99 60.99
3% ship 60.99 60.99
0.01 paid 61.00 61.00
iamdwarren 1 orders 0.00 .00
1% ship 9.38 9.38
0.00 paid 9.38 9.38
totals order ship paid order ship paid order ship paid order ship paid order ship paid order ship paid order ship paid order ship paid
86.27 accts 2382.34 2182.69 2268.96 284.29 275.74 275.74 279.79 248.47 275.70 556.97 484.55 538.17 338.99 302.10 289.00 321.80 305.25 320.81 308.34 282.60 272.12 292.16 283.97 297.41
-0.73 -199.66 86.27 -0.39 -8.55 0.00 .02 -31.32 27.23 -0.14 -72.42 53.62 -0.19 -36.89 -13.10 -0.01 -16.55 15.56 .01 -25.74 -10.48 -0.03 -8.19 13.44
7 months 24 orders 8% non-food 1 3 4 5 4 4 3
340.33 $/mo 99.26 $/order 2.20 $/# net avg 2.66 2.30 2.20 2.42 1.64 2.10 2.48
132.7 #/mo 38.7 #/order 0.15 $/# shipping 0.21 0.20 .09 0.17 0.12 0.16 0.19
tcw order subtotal 2158.79 256.88 253.94 504.41 305.98 292.20 280.30 265.08
fuel surcharge 70.00 10.00 10.00 10.00 10.00 10.00 10.00 10.00
shipping wt 928.7 96.1 99.3 211.3 116.8 173.5 125.1 106.7
subtotal ship 2049.19 259.11 235.46 450.48 282.43 287.17 266.90 267.64
membership 2.25% 46.12 5.83 5.30 10.14 6.36 6.46 6.01 6.02
nm non-food tax 5% 7.71 1.96 0.39 2.07 2.38 0.36 0.00 0.55
total tcw 2103.02 266.90 241.15 462.69 291.17 293.99 272.91 274.21
vfbc overhead 198.43 10%
tcw ovh 116.12 5.9% 15.83 15.30 20.14 16.36 16.46 16.01 16.02
pricing 2.64 0.1% 0.39 -0.03 2.05 0.17 .03 -0.01 .04
bank 3.92 0.2% 0.49 0.49 0.98 0.49 0.49 0.49 0.49
driver 70.00 3.5% 10.00 10.00 10.00 10.00 10.00 10.00 10.00
manager 5.75 0.3% -1.65 -3.17 10.88 0.44 0.77 -0.80 -0.73
elephant economics (c)1993-2007 vansprouts / consensus shareware <vansprouts at mac dot com> http://homepage.mac.com/vansprouts/
| 