Price Analysis.xlsx

	C	D	G	I	L	O	P	S	T	V	X	AD	AX	AY	AZ	BA	BB	BC	BD
1
2
3	PRICING ANALYSIS											FALSE
4
5	Unit Production/Service Cost:			10.00
6													Hcontrol	Equal	Right	Equal	Logcontrol	QFixedCost	MaxGR
7	High Price Test				<<BETTER		Low Price Test						TRUE	FALSE	BETTER>>	INDIFFERENT	TRUE	TRUE	435,125
8	High Unit Price			39.00			Low Unit Price			19.00			Lcontrol	Left	LEFT	Ccontrol	Fcontrol	QVarCost	MaxMD
9	Quantity Sold at High Price			10,000			Quantity Sold at Low Price			20,000			TRUE	TRUE	<<BETTER	TRUE	TRUE	FALSE	299,720
10	Gross Revenues			390,000			Gross Revenues			380,000
11	Margin Dollars			290,000			Margin Dollars			180,000
12
13
14
15	ROUGH ESTIMATES
16		Price	Quantity Estimates		Unit Cost	Gross Revenues			Margin Dollars				0	0		0.00	-295,000	39.00	290,000
17		0.00	29,500		10.00	0			-295,000				1	0.05		2.95	-197,576	19.00	180,000
18		2.95	28,025		10.00	82,674			-197,576				2	0.1		5.90	-108,855
19		5.90	26,550		10.00	156,645			-108,855				3	0.15		8.85	-28,836
20		8.85	25,075		10.00	221,914			-28,836				4	0.2		11.80	42,480
21		11.80	23,600		10.00	278,480			42,480				5	0.25		14.75	105,094
22		14.75	22,125		10.00	326,344			105,094				6	0.3		17.70	159,005
23		17.70	20,650		10.00	365,505			159,005				7	0.35		20.65	204,214
24		20.65	19,175		10.00	395,964			204,214				8	0.4		23.60	240,720
25		23.60	17,700		10.00	417,720			240,720				9	0.45		26.55	268,524
26		26.55	16,225		10.00	430,774			268,524				10	0.5		29.50	287,625
27		29.50	14,750		10.00	435,125		◄	287,625				11	0.55		32.45	298,024
28		32.45	13,275		10.00	430,774			298,024				12	0.6		35.40	299,720
29	►	35.40	11,800		10.00	417,720			299,720		◄		13	0.65		38.35	292,714
30		38.35	10,325		10.00	395,964			292,714				14	0.7		41.30	277,005
31		41.30	8,850		10.00	365,505			277,005				15	0.75		44.25	252,594
32		44.25	7,375		10.00	326,344			252,594				16	0.8		47.20	219,480
33		47.20	5,900		10.00	278,480			219,480				17	0.85		50.15	177,664
34		50.15	4,425		10.00	221,914			177,664				18	0.9		53.10	127,145
35		53.10	2,950		10.00	156,645			127,145				19	0.95		56.05	67,924
36		56.05	1,475		10.00	82,674			67,924				20	1		59.00	0
37		59.00	0		10.00	0			0
38
39	►	Maximum Values for Gross Revenues and Margin Dollars
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100