Wholesale Order Cost Estimates

	A	B	C	D	E	F	G	H	T
1		lbs	Price	units	Subtotal
2	BAY AREA Native Wildflower Mix	10	35	160	350
3	Native Bee Mix	10	40	160	400
4	CALIFORNIA Native Wildflower Mix	10	40	160	400				$1.18
5	Central California Native wildflowers Mix	10	60	160	600				0.27
6	Coast california native wildflowers Mix	10	60	160	600				$0.54
7	Central xerces California Native wildflowers Mix	10	60	160	600				$0.55
8	Coast xerces california native wildflowers Mix	10	60	160	600				7.5
9	Eschschozlia californica		35	0	0				16.8
10	Nemophila Menziesii		35	0	0				6
11	Sierra Mix		35	0	0				$32.84
12	Achillea millefolium		35	0	0
13	Lupinus densiflorus		35	0	0
14	Aquilegia coerulea		35	0	0
15	Linum lewisii		35	0	0
16	Eriophyllum lanatum		35	0	0
17	Phacelia tanacetifolia		35		0
18	Collinsia heterophylla		35		0
19	Layia platyglossa		140		0
20	Clarkia Unguicalata		90		0
21	wolly sunflower		150		3550	Subtotal
22					308.85	8.64% tax	1120	Total Units
23					38	Shipping	70	Total Lbs
24	Grand total				3896.85	Total Cost	3.479330357	Price Per Unit
25
26				960			4.05921875
27
28
29
30
31
32
33
34	American Meadows Restock
35	Midwest	10	$53.92	$539.20
36	Northeast	10	$53.92	$539.20
37	Pacific Northwest	10	$53.92	$539.20
38	Southeast	10	$53.92	$539.20
39	Southwest	10	$53.92	$539.20
40	West	10	$53.92	$539.20
41	Total Lbs			$3,235.20
42	Total Oz	0		52.2	8.64% tax
43				30	shipping
44					Overnight shipping
45		#VALUE!		$3,317.40
46				60	Total lbs
47				960	Total oz
48				$3.46	Price Per oz
49				$55.29	Price Per lb
50
51
52
53
54			1
55
56
57
58
59		lbs	Price	units
60	CALIFORNIA	2	35	32	70
61	Bay Area Blend		35	0	0
62	CENTRAL VALLEY		35	0	0
63	Coastal		35	0	0
64	Sierra		35		0
65					70
66					38	Shipping
67	Stovers	0			#REF!
68	California	0	33		6.09	tax
69	California Native Polinator Mix	ca	33
70	High Plains	0
71	Intermountain West	0
72	Nevada	0			Total
73	Midwest	0	76	0	0
74	Northeast	0	84	0	0
75	Southeast	0	92	0	0
76	Southwest	0		0	0
77	Texas	3	79	237	237
78	Florida	5	92	460	460
79				697	0
80	Total				697	Total
81
82
83
84
85
86	American Meadows Restock if it was stovers prices
87	Midwest	2	$76.00	$152.00
88	Northeast	2	$84.00	$168.00
89	Pacific Northwest		$90.00	$0.00
90	Southeast	2	$92.00	$184.00
91	Southwest	2	$92.00	$184.00
92	West	2	$53.92	$107.84
93	Total Lbs	10		$795.84
94	Total Oz	160		6.09	8.64% tax
95				16	shipping
96		#VALUE!		$817.93
97				8	Total lbs
98				128	Total oz
99
100