KMCAPSIM.xlsx

Capstone

Traditional			Low End			High End			Performance			Size
Pfmn	Size		Pfmn	Size		Pfmn	Size		Pfmn	Size		Pfmn	Size		Research & Development				MARKETING					PRODUCTION						HR		TQM				FINANCE
5	15	R0	1.7	18.3	R0	7.8	12.2		9.4	16.0	R0	4.0	10.6	R0	ROUND 1
5.1	14.9		1.8	18.2		7.9	12.1		9.5	15.9		4.1	10.5		Name	New Pfmn	New Size	MTBF	Name	Price	Promo Budget	Sales Budget	Your Sales Forecast		Traditional	Low End	High End	Performance	Size	STAFFING	This Year		Budget ($000)		Budget ($000)	Issue Stock ($000)	$13,000
5.2	14.8		1.9	18.1		8	12		9.6	15.9		4.1	10.4		Traditional	5.7	14.3	19,000	Traditional	$29.50	$2,000	$2,000	1,300	Production Schedule	1,430	2,145	550	495	495	Recruiting Spend	$0	Process Management Initiatives		TQM Initiatives		Retire Stock ($000)	$0
5.3	14.7		2	18		8.1	11.9		9.7	15.8		4.2	10.3		Low End	3.0	17.0	17,000	Low End	$21.00	$2,000	$2,000	1,950	Buy/Sell Capacity	-500	0	-300	0	0	Training Hours	0	CPI Systems	$0	Benchmarking	$0	Dividend Per Share	$0.00
5.4	14.6		2.1	17.9		8.2	11.8		9.8	15.7		4.3	10.2		High End	8.6	11.5	25,000	High End	$39.50	$1,500	$1,500	500	New Autom. Rating	7	9	3	5	3			Vendor/JIT	$0	Quality Function Deployment Effort	$0	Borrow ($000)	$20,000
5.5	14.5		2.2	17.8	R1	8.3	11.7		9.9	15.7		4.4	10.1		Performance	10.1	15.2	27,000	Performance	$34.50	$1,500	$1,500	450									Quality Initiative Training	$0	CCE/6 Sigma Training	$0	Retire Long Term Debt ($000)	$0
5.6	14.4		2.3	17.7		8.4	11.6		10.0	15.6		4.4	10.0		Size	4.3	10.3	21,000	Size	$34.50	$1,500	$1,500	450									Channel Support Systems	$0	GEMI TQEM Sustainability Initiatives	$0	Issue Long Term Debt ($000)	$13,000
5.7	14.3	R1	2.4	17.6		8.5	11.5		10.1	15.5		4.5	9.9																			Concurrent Engineering	$0			A/R Lag (days)	30
5.8	14.2		2.5	17.5		8.6	11.4		10.2	15.4		4.6	9.8																			UNEP Green Programs	$0			A/P Lag (days)	30
5.9	14.1		2.6	17.4		8.7	11.3		10.3	15.4		4.6	9.7		ROUND 2
6	14		2.7	17.3	R2	8.8	11.2		10.4	15.3	R1	4.7	9.6	R1	Name	New Pfmn	New Size	MTBF	Name	Price	Promo Budget	Sales Budget	Your Sales Forecast		Traditional	Low End	High End	Performance	Size	STAFFING	This Year		Budget ($000)		Budget ($000)	Issue Stock ($000)	$12,000
6.1	13.9		2.8	17.2		8.9	11.1	R0	10.5	15.2		4.8	9.5		Traditional	5.9	14.1	19,000	Traditional	$29.00	$2,000	$3,000	1,600	Production Schedule	1,760	2,090	715	605	660	Recruiting Spend	$5,000	Process Management Initiatives		TQM Initiatives		Retire Stock ($000)	$0
6.2	13.8		2.9	17.1		9	11		10.6	15.2		4.8	9.4		Low End	3.0	17	17,000	Low End	$20.50	$2,000	$3,000	1,900	Buy/Sell Capacity	0	400	0	100	100	Training Hours	80	CPI Systems	$0	Benchmarking	$0	Dividend Per Share	$0.00
6.3	13.7		3	17		9.1	10.9		10.7	15.1		4.9	9.3		High End	9.2	10.8	25,000	High End	$39.00	$1,500	$1,500	650	New Autom. Rating	7.5	10	4	5.5	4			Vendor/JIT	$0	Quality Function Deployment Effort	$0	Borrow ($000)	$20,000
6.4	13.6	R2	3.1	16.9		9.2	10.8		10.8	15.0		5.0	9.2		Performance	10.7	15.0	27,000	Performance	$34.00	$1,500	$1,500	550									Quality Initiative Training	$0	CCE/6 Sigma Training	$0	Retire Long Term Debt ($000)	$0
6.5	13.5		3.2	16.8	R3	9.3	10.7		10.9	15.0		5.1	9.1		Size	4.8	9.5	21,000	Size	$34.00	$1,500	$1,500	600									Channel Support Systems	$0	GEMI TQEM Sustainability Initiatives	$0	Issue Long Term Debt ($000)	$15,000
6.6	13.4		3.3	16.7		9.4	10.6		11.0	14.9		5.1	9.0																			Concurrent Engineering	$0			A/R Lag (days)	30
6.7	13.3		3.4	16.6		9.5	10.5		11.1	14.8		5.2	8.9																			UNEP Green Programs	$0			A/P Lag (days)	30
6.8	13.2		3.5	16.5		9.6	10.4		11.2	14.7		5.3	8.8		ROUND 3
6.9	13.1		3.6	16.4		9.7	10.3		11.3	14.7		5.3	8.7		Name	New Pfmn	New Size	MTBF	Name	Price	Promo Budget	Sales Budget	Your Sales Forecast		Traditional	Low End	High End	Performance	Size	STAFFING	This Year		Budget ($000)		Budget ($000)	Issue Stock ($000)	$15,000
7	13		3.7	16.3	R4	9.8	10.2	R1	11.4	14.6	R2	5.4	8.6	R2	Traditional	6.6	13.5	19,000	Traditional	$28.50	$1,500	$3,000	1,600	Production Schedule	1,760	2,090	550	660	660	Recruiting Spend	$5,000	Process Management Initiatives		TQM Initiatives		Retire Stock ($000)	$0
7.1	12.9	R3	3.8	16.2		9.9	10.1		11.5	14.5		5.5	8.5		Low End	3.0	17.0	17,000	Low End	$20.00	$1,500	$3,000	1,900	Buy/Sell Capacity	200	400	100	200	200	Training Hours	80	CPI Systems	$0	Benchmarking	$0	Dividend Per Share	$0.00
7.2	12.8		3.9	16.1		10	10		11.6	14.5		5.5	8.4		High End	10.3	9.7	25,000	High End	$38.50	$2,000	$2,000	500	New Autom. Rating	8	10	4	5.5	4.5			Vendor/JIT	$0	Quality Function Deployment Effort	$0	Borrow ($000)	$25,000
7.3	12.7		4	16		10.1	9.9		11.7	14.4		5.6	8.3		Performance	12.0	14.3	27,000	Performance	$33.50	$2,000	$2,000	600									Quality Initiative Training	$0	CCE/6 Sigma Training	$0	Retire Long Term Debt ($000)	$0
7.4	12.6		4.1	15.9		10.2	9.8		11.8	14.3		5.7	8.2		Size	5.7	8.2	21,000	Size	$33.50	$2,000	$2,000	600									Channel Support Systems	$0	GEMI TQEM Sustainability Initiatives	$0	Issue Long Term Debt ($000)	$20,000
7.5	12.5		4.2	15.8	R5	10.3	9.7		11.9	14.3		5.8	8.1																			Concurrent Engineering	$0			A/R Lag (days)	30
7.6	12.4		4.3	15.7		10.4	9.6		12.0	14.2		5.8	8.0																			UNEP Green Programs	$0			A/P Lag (days)	30
7.7	12.3		4.4	15.6		10.5	9.5		12.1	14.1		5.9	7.9		ROUND 4
7.8	12.2	R4	4.5	15.5		10.6	9.4		12.2	14.0		6.0	7.8		Name	New Pfmn	New Size	MTBF	Name	Price	Promo Budget	Sales Budget	Your Sales Forecast		Traditional	Low End	High End	Performance	Size	STAFFING	This Year		Budget ($000)		Budget ($000)	Issue Stock ($000)	$10,000
7.9	12.1		4.6	15.4		10.7	9.3	R2	12.3	14.0		6.0	7.7		Traditional	7.7	12.3	19,000	Traditional	$28.00	$1,400	$3,000	1,800	Production Schedule	1,980	3,630	440	935	1,045	Recruiting Spend	$5,000	Process Management Initiatives		TQM Initiatives		Retire Stock ($000)	$0
8	12		4.7	15.3	R6	10.8	9.2		12.4	13.9	R3	6.1	7.6	R3	Low End	5.2	14.8	17,000	Low End	$19.50	$1,400	$3,000	3,300	Buy/Sell Capacity	100	400	400	200	200	Training Hours	80	CPI Systems	$2,000	Benchmarking	$2,000	Dividend Per Share	$0.00
8.1	11.9		4.8	15.2		10.9	9.1		12.5	13.8		6.2	7.5		High End	13.0	6.9	25,000	High End	$38.00	$1,500	$3,000	400	New Autom. Rating	8.5	10	5	6	5			Vendor/JIT	$2,000	Quality Function Deployment Effort	$2,000	Borrow ($000)	$24,000
8.2	11.8		4.9	15.1		11	9		12.6	13.8		6.2	7.4		Performance	13.4	13.2	27,000	Performance	$33.00	$1,500	$3,000	850									Quality Initiative Training	$2,000	CCE/6 Sigma Training	$2,000	Retire Long Term Debt ($000)	$0
8.3	11.7		5	15		11.1	8.9		12.7	13.7		6.3	7.3		Size	6.8	6.6	21,000	Size	$33.00	$1,500	$3,000	950									Channel Support Systems	$2,000	GEMI TQEM Sustainability Initiatives	$2,000	Issue Long Term Debt ($000)	$30,000
8.4	11.6		5.1	14.9		11.2	8.8		12.8	13.6		6.4	7.2																			Concurrent Engineering	$2,000			A/R Lag (days)	30
8.5	11.5	R5	5.2	14.8	R7	11.3	8.7		12.9	13.6		6.5	7.1																			UNEP Green Programs	$2,000			A/P Lag (days)	30
8.6	11.4		5.3	14.7		11.4	8.6		13.0	13.5		6.5	7.0		ROUND 5
8.7	11.3		5.4	14.6		11.5	8.5		13.1	13.4		6.6	6.9		Name	New Pfmn	New Size	MTBF	Name	Price	Promo Budget	Sales Budget	Your Sales Forecast		Traditional	Low End	High End	Performance	Size	STAFFING	This Year		Budget ($000)		Budget ($000)	Issue Stock ($000)	$5,000
8.8	11.2		5.5	14.5		11.6	8.4	R3	13.2	13.3		6.7	6.8		Traditional	8.5	11.5	19,000	Traditional	$27.50	$1,400	$3,000	1,750	Production Schedule	1,925	3,410	770	935	1,320	Recruiting Spend	$5,000	Process Management Initiatives		TQM Initiatives		Retire Stock ($000)	$0
8.9	11.1		5.6	14.4		11.7	8.3		13.3	13.3		6.7	6.7		Low End	5.2	14.8	17,000	Low End	$19.00	$1,400	$3,000	3,100	Buy/Sell Capacity	100	400	0	0	0	Training Hours	80	CPI Systems	$2,000	Benchmarking	$2,000	Dividend Per Share	$0.00
9	11		5.7	14.3	R8	11.8	8.2		13.4	13.2	R4	6.8	6.6	R4	High End	13.0	6.9	25,000	High End	$37.50	$1,400	$3,000	700	New Autom. Rating	9	10	5	6	5			Vendor/JIT	$2,000	Quality Function Deployment Effort	$2,000	Borrow ($000)	$20,000
9.1	10.9					11.9	8.1		13.5	13.1		6.9	6.5		Performance	14.4	12.5	27,000	Performance	$32.50	$1,400	$3,000	850									Quality Initiative Training	$2,000	CCE/6 Sigma Training	$2,000	Retire Long Term Debt ($000)	$0
9.2	10.8	R6				12	8		13.6	13.1		6.9	6.4		Size	7.5	5.6	21,000	Size	$32.50	$1,400	$3,000	1,200									Channel Support Systems	$2,000	GEMI TQEM Sustainability Initiatives	$2,000	Issue Long Term Debt ($000)	$25,000
9.3	10.7					12.1	7.9		13.7	13.0		7.0	6.3																			Concurrent Engineering	$2,000			A/R Lag (days)	30
9.4	10.6					12.2	7.8		13.8	12.9		7.1	6.2																			UNEP Green Programs	$2,000			A/P Lag (days)	30
9.5	10.5					12.3	7.7		13.9	12.9		7.2	6.1		ROUND 6
9.6	10.4					12.4	7.6		14.0	12.8		7.2	6.0		Name	New Pfmn	New Size	MTBF	Name	Price	Promo Budget	Sales Budget	Your Sales Forecast		Traditional	Low End	High End	Performance	Size	STAFFING	This Year		Budget ($000)		Budget ($000)	Issue Stock ($000)	$0
9.7	10.3					12.5	7.5	R4	14.1	12.7		7.3	5.9		Traditional	9.2	10.8	19,000	Traditional	$27.00	$1,400	$3,000	1,800	Production Schedule	1,980	3,630	990	770	1,100	Recruiting Spend	$5,000	Process Management Initiatives		TQM Initiatives		Retire Stock ($000)	$0
9.8	10.2					12.6	7.4		14.2	12.6		7.4	5.8		Low End	5.2	14.8	17,000	Low End	$18.50	$1,400	$3,000	3,300	Buy/Sell Capacity	0	0	0	0	0	Training Hours	80	CPI Systems	$0	Benchmarking	$0	Dividend Per Share	$0.00
9.9	10.1	R7				12.7	7.3		14.3	12.6		7.4	5.7		High End	14.3	5.7	25,000	High End	$37.00	$1,400	$3,000	900	New Autom. Rating	10	10	5	6	5			Vendor/JIT	$0	Quality Function Deployment Effort	$0	Borrow ($000)	$25,000
10	10					12.8	7.2		14.4	12.5	R5	7.5	5.6	R5	Performance	15.4	11.8	27,000	Performance	$32.00	$1,400	$3,000	700									Quality Initiative Training	$0	CCE/6 Sigma Training	$0	Retire Long Term Debt ($000)	$0
10.1	9.9					12.9	7.1		14.5	12.4		7.6	5.5		Size	8.2	4.6	21,000	Size	$32.00	$1,400	$3,000	1,000									Channel Support Systems	$0	GEMI TQEM Sustainability Initiatives	$0	Issue Long Term Debt ($000)	$20,000
10.2	9.8					13	7		14.6	12.4		7.6	5.4																			Concurrent Engineering	$0			A/R Lag (days)	30
10.3	9.7					13.1	6.9		14.7	12.3		7.7	5.3																			UNEP Green Programs	$0			A/P Lag (days)	30
10.4	9.6					13.2	6.8		14.8	12.2		7.8	5.2		ROUND 7
10.5	9.5					13.3	6.7		14.9	12.2		7.9	5.1		Name	New Pfmn	New Size	MTBF	Name	Price	Promo Budget	Sales Budget	Your Sales Forecast		Traditional	Low End	High End	Performance	Size	STAFFING	This Year		Budget ($000)		Budget ($000)	Issue Stock ($000)
10.6	9.4	R8				13.4	6.6	R5	15.0	12.1		7.9	5.0		Traditional	9.9	10.1	19,000	Traditional	$26.50	$1,400	$3,000	1,950	Production Schedule	2,145	3,520	1,100	825	1,045	Recruiting Spend	$5,000	Process Management Initiatives		TQM Initiatives		Retire Stock ($000)	$0
						13.5	6.5		15.1	12.0		8.0	4.9		Low End	5.2	14.8	17,000	Low End	$18.00	$1,400	$3,000	3,200	Buy/Sell Capacity	0	0	0	0	0	Training Hours	80	CPI Systems	$0	Benchmarking	$0	Dividend Per Share	$0.00
						13.6	6.4		15.2	11.9		8.1	4.8		High End	15.2	4.8	25,000	High End	$36.50	$1,400	$3,000	1,000	New Autom. Rating	10	10	6	6	6			Vendor/JIT	$0	Quality Function Deployment Effort	$0	Borrow ($000)	$20,000
						13.7	6.3		15.3	11.9		8.1	4.7		Performance	16.4	11.1	27,000	Performance	$31.50	$1,400	$3,000	750									Quality Initiative Training	$0	CCE/6 Sigma Training	$0	Retire Long Term Debt ($000)	$0
						13.8	6.2		15.4	11.8	R6	8.2	4.6	R6	Size	8.9	3.6	21,000	Size	$31.50	$1,400	$3,000	950									Channel Support Systems	$0	GEMI TQEM Sustainability Initiatives	$0	Issue Long Term Debt ($000)	$20,000
						13.9	6.1		15.5	11.7		8.3	4.5																			Concurrent Engineering	$0			A/R Lag (days)	30
						14	6		15.6	11.7		8.3	4.4																			UNEP Green Programs	$0			A/P Lag (days)	30
						14.1	5.9		15.7	11.6		8.4	4.3		ROUND 8
						14.2	5.8		15.8	11.5		8.5	4.2		Name	New Pfmn	New Size	MTBF	Name	Price	Promo Budget	Sales Budget	Your Sales Forecast		Traditional	Low End	High End	Performance	Size	STAFFING	This Year		Budget ($000)		Budget ($000)	Issue Stock ($000)	$15,000
						14.3	5.7	R6	15.9	11.5		8.6	4.1		Traditional	10.6	9.4	19,000	Traditional	$26.00	$1,400	$3,000	1,950	Production Schedule	2,145	3,080	1,320	935	1,155	Recruiting Spend	$5,000	Process Management Initiatives		TQM Initiatives		Retire Stock ($000)	$0
						14.4	5.6		16.0	11.4		8.6	4.0		Low End	5.2	14.8	17,000	Low End	$17.50	$1,400	$3,000	2,800	Buy/Sell Capacity	0	0	0	0	0	Training Hours	80	CPI Systems	$0	Benchmarking	$0	Dividend Per Share	$0.00
						14.5	5.5		16.1	11.3		8.7	3.9		High End	16.1	3.9	25,000	High End	$36.00	$1,400	$3,000	1,200	New Autom. Rating	10	10	6	6	6			Vendor/JIT	$0	Quality Function Deployment Effort	$0	Borrow ($000)	$15,000
						14.6	5.4		16.2	11.2		8.8	3.8		Performance	17.4	10.4	27,000	Performance	$31.00	$1,400	$3,000	850									Quality Initiative Training	$0	CCE/6 Sigma Training	$0	Retire Long Term Debt ($000)	$0
						14.7	5.3		16.3	11.2		8.8	3.7		Size	9.6	2.6	21,000	Size	$31.00	$1,400	$3,000	1,050									Channel Support Systems	$0	GEMI TQEM Sustainability Initiatives	$0	Issue Long Term Debt ($000)	$20,000
						14.8	5.2		16.4	11.1	R7	8.9	3.6	R7																		Concurrent Engineering	$0			A/R Lag (days)	30
						14.9	5.1		16.5	11.0		9.0	3.5																			UNEP Green Programs	$0			A/P Lag (days)	30
						15	5		16.6	11.0		9.0	3.4
						15.1	4.9		16.7	10.9		9.1	3.3
						15.2	4.8	R7	16.8	10.8		9.2	3.2
						15.3	4.7		16.9	10.8		9.3	3.1
						15.4	4.6		17.0	10.7		9.3	3.0
						15.5	4.5		17.1	10.6		9.4	2.9
						15.6	4.4		17.2	10.5		9.5	2.8
						15.7	4.3		17.3	10.5		9.5	2.7
						15.8	4.2		17.4	10.4	R8	9.6	2.6	R8
						15.9	4.1
						16	4
						16.1	3.9	R8

AdvMkt

ROUND 1-8										IF YOU INTRODUCE A NEW PRODUCT, MAKE SURE TO USE THE NUMBERS OF THEIR RESPECTIVE SEGMENT.
Promo Budget	TRADITIONAL	LOW END	HIGH END	PERFORMANCE	SIZE	NA	NA	NA	Budget
Target Segment
Print Media	$700	$700	$0	$0	$700	$0	$0	$0	$2,100
Direct Mail	$800	$800	$800	$0	$0	$0	$0	$0	$2,400
Web Media	$0	$0	$500	$500	$500	$0	$0	$0	$1,500
Email	$0	$0	$600	$600	$600	$0	$0	$0	$1,800
Trade Shows	$300	$300	$300	$300	$0	$0	$0	$0	$1,200
Budget ($000)	$1,800	$1,800	$2,200	$1,400	$1,800	$0	$0	$0	$9,000
Sales Budget	Trad	Low	High	Pfmn	Size	Budget		Time Allocations
Outside Sales	6	9	6	9	12	$5,250	Able	24%	$3,600
Inside Sales	9	6	12	12	9	$2,400	Acre	22%	$3,300
Distributors	12	12	9	6	6	$4,500	Adam	20%	$3,000
							Aft	17%	$2,550
Budget ($000)	$2,400	$2,625	$2,250	$2,325	$2,550	$12,150	Agape	17%	$2,550
							NA	0%	$0
							NA	0%	$0
							NA	0%	$0
							Total	100%	$15,000

Forecast

Potential Market Share in Units
	Trad	Low	High	Pfmn	Size
Units Demanded	7,387	8,960	2,554	1,915	1,984
Growth Rate	1.092	1.117	1.162	1.198	1.183
Next Y Demand	8066.604	10008.32	2967.748	2294.17	2347.072
							0% Growth / forecast	5% Growth	10% Growth	20% Growth
Trad	17%	0%	0%	0%	0%		1371	1440	1508	1646
Low End	0%	17%	0%	0%	0%		1701	1786	1872	2042
High End	0%	0%	17%	0%	0%		505	530	555	605
Performance	0%	0%	0%	17%	0%		390	410	429	468
Size	0%	0%	0%	0%	17%		399	419	439	479
NewP1	0%	0%	0%	0%	0%		0	0	0	0
NewP2	0%	0%	0%	0%	0%		0	0	0	0
NewP3							0	0	0	0
					Total	0	4366	4585	4803	5240
Step 1
Insert each segments units demanded, found in the market share report in your Capstone Courier
Step 2
Insert the market share of each one of your products in the black square, found in the market share report in your Capstone Courier
Step 3
0% Growth will be your Forecast for the marketing tab while 5-10-20% its for you to use in production schedule depending on how much your product will grow in sales next year