The executive game

mba_game_sheet.xls

Home >Business & Finance homework help >Marketing homework help >The executive game

Decision Sheet

Period of Year	Period No.	Price $	Marketing Budget $	R & D Budget $	Maintenance Budget $	Prod Vol. Sch. Maximums: Model 1 1.4*CY1 units	Investment in Robotics $	Investment in Plant & Equipment $	Purchase of Materials $	Dividend Declared (Max; owner's equity minus $9,000,000 $
AMJ	0	25.60	200,000	100,000	75,000	100,000	-	500,000	1,000,000	53,000
JAS	T1	25.30	250,000	200,000	77,035	102,713	-	500,000	1,000,000	50,000
OND	T2	24.50	350,000	175,000	121,324	161,765	-	450,000	900,000	50,000
AMJ	0	25.60	200,000	100,000	75,000	100,000	-	500,000	1,000,000	53,000
JAS	1	24.75	270,000	250,000	81,503	108,671	-	500,000	1,000,000	50,000
OND	2						-
JFM	3						-
AMJ	4						-
JAS	5						-
OND	6
JFM	7
AMJ	8
AVERAGE		25.18	235,000	175,000	78,252	104,336		500,000	1,000,000	51,500
Period of Year	AMJ	JAS	OND	AMJ	JAS	OND	JFM	AMJ	JAS	OND	JFM	AMJ
Period No.	0	T1	T2	0	1	2	3	4	5	6	7	8
Forecast, Econ. Index	100	100	95	100	100	95	93	90	95	97	100	100
Changes (If any)	0	0			0
Forecast, Seasonal Index	100	95	115	100	95	115	90	100	95	115	90	100
Changes (If any)	0	-5			-5
	0	T1	T2	0	1	2	3	4	5	6	7	8
Price index
Fcst, annual Change
Econ index
Fcst, nxt qtr
Seasonal index
Next quarter

Averages pd 1-3

Trial 1	Firm No.	Price	Dividends	Sales Volume	Net Profit	ROI	Period 1	Firm No.	Price	Dividends	Sales Volume	Net Profit	ROI
	1	24.60	55,000	12,750	-470,119	-15.48		1
	2	24.60	53,000	108,517	260,368	14.36		2
	3	25.30	50,000	115,463	236,192	13.27		3
	4	26.50	53,000	78,418	-82,992	-0.51		4
	5	24.90	40,000	125,165	347,604	18.39		5
	Average	25.18	50,200	88,063	58,211	6.01		Average	0.00	0	0	0	0.00
Trial 2	Firm No.	Price	Dividends	Sales Volume	Net Profit	ROI	Period 2	Firm No.	Price	Dividends	Sales Volume	Net Profit	ROI
	1	22.95	55,000	125,000	25,090	-5.46		1
	2	25.10	20,000	103,506	103,506	13.60		2
	3	24.50	50,000	153,474	153,474	14.91		3
	4	26.00	53,000	109,332	109,332	4.10		4
	5	24.75	36,000	119,162	119,162	14.34		5
	Average	24.66	42,800	122,095	102,113	8.30		Average
Trial 3	Firm No.	Price	Dividends	Sales Volume	Net Profit	ROI	Period 3	Firm No.	Price	Dividends	Sales Volume	Net Profit	ROI
	1							1
	2							2
	3							3
	4							4
	5							5
	Average	0.00	0	0	0	0.00		Average

Averages pds 4-8

Period 4	Firm No.	Price	Dividends	Sales Volume	Net Profit	ROI	Period 7	Firm No.	Price	Dividends	Sales Volume	Net Profit	ROI
	1							1
	2							2
	3							3
	4							4
	5							5
	Average	0.00	0	0	0	0.00		Average
Period 5	Firm No.	Price	Dividends	Sales Volume	Net Profit	ROI	Period 8	Firm No.	Price	Dividends	Sales Volume	Net Profit	ROI
	1							1
	2							2
	3							3
	4							4
	5							5
	Average							Average
Period 6	Firm No.	Price	Dividends	Sales Volume	Net Profit	ROI
	1
	2
	3
	4
	5
	Average

Original Sheet

step 1	P0	P1	#change	%change	given	totalchange
econ	100	100	0	0	1.4	0
seas	100	95	-5	-0.05	1	-0.05
ourprice	25.6	25	-0.6	-0.0234375	-5	0.1171875
comprice	25.6	26	0.4	0.015625	2	0.03125
ourmart	200000	195000	-5000	-0.025	0.25	-0.00625
compmark	200000	300000	100000	0.5	-0.1	-0.05
total change						0.0421875
MPP0	109720
changP0P1	4628.8125
MPP1	114348.8125
step 2	stockout
MPP0	109720
salesp0	109720
	0
sales loss	0
adjMPP1	114348.8125
step 3	did you like the results?
step 4
adjMPP1	114348.8125	$2,858,720.31
FGI	12750
need to produce	101598.8125
step 5
rmi	$1,200,000
cpu	$6.31
pfg	190174.326465927
step 6
plcP1	104643
OT	146500.2
effic	0.9709088281
step 7
produce	101,599
leftover pfg	88,576	for period 2
step 8	P1	P2	#change	%change	given	totalchange
econ	100	95	-5	-0.05	1.4	-0.07
seas	95	115	20	0.2105263158	1	0.2105263158
total change						0.1405263158
adjMPP1	114348.8125
estMP2	130417.829835526
leftover pfg	88,576	for period 2
min order P2	41842.32
cpu	$6.31
ordermin	$264,025.01
step 9
plcP1	104643		depreciation
do nothing	101268.26325		2%
	3374.73675		inflation
status quo	$ 236,231.57		1.25%
add units	1000
cost	$ 70,000.00
total inv	$ 306,231.57
step 10
produce	101,599
cost main	$ 76,199.11	$ 0.75	maintenance

Trial 1

step 1	P0	P1	#change	%change	given	totalchange
econ	100	100	0	0	1.4	0
seas	100	95	-5	-0.05	1	-0.05
ourprice	25.6	25.3	-0.3	-0.01171875	-5	0.05859375
comprice	25.6	26	0.4	0.015625	2	0.03125
ourmark	200000	250000	50000	0.25	0.25	0.0625
compmark	200000	300000	100000	0.5	-0.1	-0.05
total change						0.05234375
MPP0	109720
changP0P1	5743.15625
MPP1	115463
step 2	stockout
MPP0	109720
salesp0	109720
	0
sales loss	0
adjMPP1	115463
step 3	did you like the results?
step 4
adjMPP1	115463.2	$2,921,217.85
FGI	12750
need to produce	102713.2
step 5
rmi	$1,200,000.00
cpu	$6.31
pfg	190174.326465927
step 6
plcP1	104643
OT	146500.2
effic	0.9815578323
step 7
produce	102,713
leftover pfg	87,461	for period 2
step 8	Period 1	P2	#change	%change	given	totalchange
econ	100	95	-5	-0.05	1.4	-0.07
seas	95	115	20	0.2105263158	1	0.2105263158
total change						0.1405263158
adjMPP1	115463.2
estMP2	131688.8
leftover pfg	87,461	for period 2
min order P2	44227.60
cpu	$6.31
ordermin	279076.1
step 9
plcP1	104643		depreciation
do nothing	101268.26325		2%
	3374.73675		inflation
status quo	236231.57		1.25%
add units	1000
cost	70000.00
total inv	306231.57
step 10
produce	102,713
cost main	77034.87	$ 0.75	maintenance

Trial 2

step 1	P1	P2	#change	%change	given	totalchange
econ	101	95	-6	-0.0594059406	1.4	-0.0831683168
seas	95	115	20	0.2105263158	1	0.2105263158
ourprice	25.3	24.6	-0.7	-0.0276679842	-5	0.1383399209
comprice	25.6	26	0.4	0.015625	2	0.03125
ourmart	250000	350000	100000	0.4	0.25	0.1
compmark	200000	300000	100000	0.5	-0.1	-0.05
total change						0.3469479199
MPP1	118361
changP1P2	41065.1027480422
MPP2	159426
step 2	stockout
MPP1	118361
salesp1	115463
	2898
sales loss	0
adjMPP2	159426
step 3	did you like the results?
step 4
adjMPP2	159426	$3,921,882.13
FGI	0
need to produce	159426
step 5
rmi	$1,552,346.00
cpu	$6.31
pfg	246013.629
step 6
plcP1	109623
OT	153472.2
effic	1.4543125325	1.4 or below
step 7
produce	159,426
leftover pfg	86,588	for period 3
step 8	Trial 1	Trial 2	#change	%change	given	totalchange
econ	100	95	-5	-0.05	1.4	-0.07
seas	95	115	20	0.2105263158	1	0.2105263158
total change						0.1405263158
adjMPP2	159426.103
estMP3	181829.665607899
leftover pfg	86,588	for period 3
min order P3	95242.14
cpu	$6.31
ordermin	600977.90
step 9
plcP2	109623		depreciation
do nothing	106087.65825		2%
	3535.34175		inflation
status quo	247473.92		1.25%
add units	1000
cost	70000.00
total inv	317473.92
step 10
produce	159,426
cost main	119570	$ 0.75	maintenance

Trial 3

step 1	P2	P3	#change	%change	given	totalchange
econ	100	100	0	0	1.4	0
seas	100	95	-5	-0.05	1	-0.05
ourprice	25.6	25	-0.6	-0.0234375	-5	0.1171875
comprice	25.6	26	0.4	0.015625	2	0.03125
ourmart	200000	195000	-5000	-0.025	0.25	-0.00625
compmark	200000	300000	100000	0.5	-0.1	-0.05
total change						0.0421875
MPP2	109720
changP2P3	4628.8125
MPP3	114348.8125
step 2	stockout
MPP2	109720
salesp2	109720
	0
sales loss	0
adjMPP3	114348.8125
step 3	did you like the results?
step 4
adjMPP2	114348.8125	2858720.31
FGI	12750
need to produce	101598.8125
step 5
rmi	$1,200,000
cpu	$6.31
pfg	190174.326465927
step 6
plcP1	104643
OT	146500.2
effic	0.9709088281
step 7
produce	101,599
leftover pfg	88,576	for period 2
step 8	P3	P4	#change	%change	given	totalchange
econ	100	95	-5	-0.05	1.4	-0.07
seas	95	115	20	0.2105263158	1	0.2105263158
total change						0.1405263158
adjMPP3	114348.8125
estMP4	130417.829835526
leftover pfg	88,576	for period 2
min order P4	41842.32
cpu	$6.31
ordermin	$264,025.01
step 9
plcP3	104643		depreciation
do nothing	101268.26325		2%
	3374.73675		inflation
status quo	236231.57		1.25%
add units	1000
cost	$ 70,000.00
total inv	306231.57
step 10
produce	101,599
cost main	$ 76,199.11	$ 0.75	maintenance

Period 1

step 1	P0	P1	#change	%change	given	totalchange
econ	100	100	0	0	1.4	0
seas	100	95	-5	-0.05	1	-0.05
ourprice	25.6	24.75	-0.85	-0.033203125	-5	0.166015625
comprice	25.6	25	-0.6	-0.0234375	2	-0.046875
ourmart	200000	270000	70000	0.35	0.25	0.0875
compmark	200000	300000	100000	0.5	-0.1	-0.05
total change						0.106640625
MPP0	109720
changP0P1	11700.609375
MPP1	121421
step 2	stockout
MPP0	109720
salesp0	109720
	0
sales loss	0
adjMPP1	121421
step 3	did you like the results?
step 4
adjMPP1	121421	$3,005,160.08
FGI	12750
need to produce	108671
step 5
rmi	$1,200,000
cpu	$6.31
pfg	190174
step 6
plcP1	104643
OT	146500.2
effic	1.0384890473
step 7
produce	108,671
leftover pfg	81,504	for period 2
step 8	P1	P2	#change	%change	given	totalchange
econ	100	95	-5	-0.05	1.4	-0.07
seas	95	115	20	0.2105263158	1	0.2105263158
total change						0.1405263158
adjMPP1	121420.6
estMP2	138483.400271382
leftover pfg	81,504	for period 2
min order P2	56979.68
cpu	$6.31
ordermin	$359,541.80
step 9
plcP1	104643		depreciation
do nothing	101268.26325		2%
	3374.73675		inflation
status quo	236231.57		1.25%
add units	1000
cost	$ 70,000.00
total inv	306231.57
step 10
produce	108,671
cost main	$ 81,502.96	$ 0.75	maintenance

Period 2

step 1	P1	P2	#change	%change	given	totalchange
econ	101	100	-1	-0.0099009901	1.4	-0.0138613861
seas	100	115	15	0.15	1	0.15
ourprice	24.75	24.4	-0.35	-0.0141414141	-5	0.0707070707
comprice	25.6	26	0.4	0.015625	2	0.03125
ourmart	270000	385000	115000	0.4259259259	0.25	0.1064814815
compmark	200000	300000	100000	0.5	-0.1	-0.05
total change						0.294577166
MPP1	123945
changP1P2	36511.3668460596
MPP2	160456
step 2	stockout
MPP1	123945
salesp1	121421
	2524
sales loss	0
adjMPP2	160456
step 3	did you like the results?
step 4
adjMPP2	160456	$3,915,135.35
FGI	0
need to produce	160456
step 5
rmi	$1,514,916
cpu	$6.31
pfg	240082
step 6
plcP2	109623
OT	153472.2
effic	1.4637107801
step 7
produce	160,456
leftover pfg	79,625	for period 3
step 8	P1	P2	#change	%change	given	totalchange
econ	101	95	-6	-0.0594059406	1.4	-0.0831683168
seas	95	115	20	0.2105263158	1	0.2105263158
total change						0.127357999
adjMPP2	160456.37
estMP3	180891.77
leftover pfg	79,625	for period 3
min order P3	101266.36
cpu	$6.31
ordermin	$638,990.73
step 9
plcP2	109623		depreciation
do nothing	106087.65825		2%
	3535.34175		inflation
status quo	247473.92		1.25%
add units	1000
cost	$ 70,000.00
total inv	317473.92
step 10
produce	160,456
cost main	120342.28	$ 0.75	maintenance

Period 3

step 1	P0	P1	#change	%change	given	totalchange
econ	100	100	0	0	1.4	0
seas	100	95	-5	-0.05	1	-0.05
ourprice	25.6	25	-0.6	-0.0234375	-5	0.1171875
comprice	25.6	26	0.4	0.015625	2	0.03125
ourmart	200000	195000	-5000	-0.025	0.25	-0.00625
compmark	200000	300000	100000	0.5	-0.1	-0.05
total change						0.0421875
MPP0	109720
changP0P1	4628.8125
MPP1	114348.8125
step 2	stockout
MPP0	109720
salesp0	109720
	0
sales loss	0
adjMPP1	114348.8125
step 3	did you like the results?
step 4
adjMPP1	114348.8125	$2,858,720.31
FGI	12750
need to produce	101598.8125
step 5
rmi	$1,200,000
cpu	$6.31
pfg	190174.326465927
step 6
plcP1	104643
OT	146500.2
effic	0.9709088281
step 7
produce	101,599
leftover pfg	88,576	for period 2
step 8	P1	P2	#change	%change	given	totalchange
econ	100	95	-5	-0.05	1.4	-0.07
seas	95	115	20	0.2105263158	1	0.2105263158
total change						0.1405263158
adjMPP1	114348.8125
estMP2	130417.829835526
leftover pfg	88,576	for period 2
min order P2	41842.32
cpu	$6.31
ordermin	$264,025.01
step 9
plcP1	104643		depreciation
do nothing	101268.26325		2%
	3374.73675		inflation
status quo	$ 236,231.57		1.25%
add units	1000
cost	$ 70,000.00
total inv	$ 306,231.57
step 10
produce	101,599
cost main	$ 76,199.11	$ 0.75	maintenance

Period 4

step 1	P0	P1	#change	%change	given	totalchange
econ	100	100	0	0	1.4	0
seas	100	95	-5	-0.05	1	-0.05
ourprice	25.6	25	-0.6	-0.0234375	-5	0.1171875
comprice	25.6	26	0.4	0.015625	2	0.03125
ourmart	200000	195000	-5000	-0.025	0.25	-0.00625
compmark	200000	300000	100000	0.5	-0.1	-0.05
total change						0.0421875
MPP0	109720
changP0P1	4628.8125
MPP1	114348.8125
step 2	stockout
MPP0	109720
salesp0	109720
	0
sales loss	0
adjMPP1	114348.8125
step 3	did you like the results?
step 4
adjMPP1	114348.8125	$2,858,720.31
FGI	12750
need to produce	101598.8125
step 5
rmi	$1,200,000
cpu	$6.31
pfg	190174.326465927
step 6
plcP1	104643
OT	146500.2
effic	0.9709088281
step 7
produce	101,599
leftover pfg	88,576	for period 2
step 8	P1	P2	#change	%change	given	totalchange
econ	100	95	-5	-0.05	1.4	-0.07
seas	95	115	20	0.2105263158	1	0.2105263158
total change						0.1405263158
adjMPP1	114348.8125
estMP2	130417.829835526
leftover pfg	88,576	for period 2
min order P2	41842.32
cpu	$6.31
ordermin	$264,025.01
step 9
plcP1	104643		depreciation
do nothing	101268.26325		2%
	3374.73675		inflation
status quo	$ 236,231.57		1.25%
add units	1000
cost	$ 70,000.00
total inv	$ 306,231.57
step 10
produce	101,599
cost main	$ 76,199.11	$ 0.75	maintenance

Period 5

step 1	P0	P1	#change	%change	given	totalchange
econ	100	100	0	0	1.4	0
seas	100	95	-5	-0.05	1	-0.05
ourprice	25.6	25	-0.6	-0.0234375	-5	0.1171875
comprice	25.6	26	0.4	0.015625	2	0.03125
ourmart	200000	195000	-5000	-0.025	0.25	-0.00625
compmark	200000	300000	100000	0.5	-0.1	-0.05
total change						0.0421875
MPP0	109720
changP0P1	4628.8125
MPP1	114348.8125
step 2	stockout
MPP0	109720
salesp0	109720
	0
sales loss	0
adjMPP1	114348.8125
step 3	did you like the results?
step 4
adjMPP1	114348.8125	$2,858,720.31
FGI	12750
need to produce	101598.8125
step 5
rmi	$1,200,000
cpu	$6.31
pfg	190174.326465927
step 6
plcP1	104643
OT	146500.2
effic	0.9709088281
step 7
produce	101,599
leftover pfg	88,576	for period 2
step 8	P1	P2	#change	%change	given	totalchange
econ	100	95	-5	-0.05	1.4	-0.07
seas	95	115	20	0.2105263158	1	0.2105263158
total change						0.1405263158
adjMPP1	114348.8125
estMP2	130417.829835526
leftover pfg	88,576	for period 2
min order P2	41842.32
cpu	$6.31
ordermin	$264,025.01
step 9
plcP1	104643		depreciation
do nothing	101268.26325		2%
	3374.73675		inflation
status quo	$ 236,231.57		1.25%
add units	1000
cost	$ 70,000.00
total inv	$ 306,231.57
step 10
produce	101,599
cost main	$ 76,199.11	$ 0.75	maintenance

Period 6

step 1	P0	P1	#change	%change	given	totalchange
econ	100	100	0	0	1.4	0
seas	100	95	-5	-0.05	1	-0.05
ourprice	25.6	25	-0.6	-0.0234375	-5	0.1171875
comprice	25.6	26	0.4	0.015625	2	0.03125
ourmart	200000	195000	-5000	-0.025	0.25	-0.00625
compmark	200000	300000	100000	0.5	-0.1	-0.05
total change						0.0421875
MPP0	109720
changP0P1	4628.8125
MPP1	114348.8125
step 2	stockout
MPP0	109720
salesp0	109720
	0
sales loss	0
adjMPP1	114348.8125
step 3	did you like the results?
step 4
adjMPP1	114348.8125	$2,858,720.31
FGI	12750
need to produce	101598.8125
step 5
rmi	$1,200,000
cpu	$6.31
pfg	190174.326465927
step 6
plcP1	104643
OT	146500.2
effic	0.9709088281
step 7
produce	101,599
leftover pfg	88,576	for period 2
step 8	P1	P2	#change	%change	given	totalchange
econ	100	95	-5	-0.05	1.4	-0.07
seas	95	115	20	0.2105263158	1	0.2105263158
total change						0.1405263158
adjMPP1	114348.8125
estMP2	130417.829835526
leftover pfg	88,576	for period 2
min order P2	41842.32
cpu	$6.31
ordermin	$264,025.01
step 9
plcP1	104643		depreciation
do nothing	101268.26325		2%
	3374.73675		inflation
status quo	$ 236,231.57		1.25%
add units	1000
cost	$ 70,000.00
total inv	$ 306,231.57
step 10
produce	101,599
cost main	$ 76,199.11	$ 0.75	maintenance

Period 7

step 1	P0	P1	#change	%change	given	totalchange
econ	100	100	0	0	1.4	0
seas	100	95	-5	-0.05	1	-0.05
ourprice	25.6	25	-0.6	-0.0234375	-5	0.1171875
comprice	25.6	26	0.4	0.015625	2	0.03125
ourmart	200000	195000	-5000	-0.025	0.25	-0.00625
compmark	200000	300000	100000	0.5	-0.1	-0.05
total change						0.0421875
MPP0	109720
changP0P1	4628.8125
MPP1	114348.8125
step 2	stockout
MPP0	109720
salesp0	109720
	0
sales loss	0
adjMPP1	114348.8125
step 3	did you like the results?
step 4
adjMPP1	114348.8125	$2,858,720.31
FGI	12750
need to produce	101598.8125
step 5
rmi	$1,200,000
cpu	$6.31
pfg	190174.326465927
step 6
plcP1	104643
OT	146500.2
effic	0.9709088281
step 7
produce	101,599
leftover pfg	88,576	for period 2
step 8	P1	P2	#change	%change	given	totalchange
econ	100	95	-5	-0.05	1.4	-0.07
seas	95	115	20	0.2105263158	1	0.2105263158
total change						0.1405263158
adjMPP1	114348.8125
estMP2	130417.829835526
leftover pfg	88,576	for period 2
min order P2	41842.32
cpu	$6.31
ordermin	$264,025.01
step 9
plcP1	104643		depreciation
do nothing	101268.26325		2%
	3374.73675		inflation
status quo	$ 236,231.57		1.25%
add units	1000
cost	$ 70,000.00
total inv	$ 306,231.57
step 10
produce	101,599
cost main	$ 76,199.11	$ 0.75	maintenance

Period 8

step 1	P0	P1	#change	%change	given	totalchange
econ	100	100	0	0	1.4	0
seas	100	95	-5	-0.05	1	-0.05
ourprice	25.6	25	-0.6	-0.0234375	-5	0.1171875
comprice	25.6	26	0.4	0.015625	2	0.03125
ourmart	200000	195000	-5000	-0.025	0.25	-0.00625
compmark	200000	300000	100000	0.5	-0.1	-0.05
total change						0.0421875
MPP0	109720
changP0P1	4628.8125
MPP1	114348.8125
step 2	stockout
MPP0	109720
salesp0	109720
	0
sales loss	0
adjMPP1	114348.8125
step 3	did you like the results?
step 4
adjMPP1	114348.8125	$2,858,720.31
FGI	12750
need to produce	101598.8125
step 5
rmi	$1,200,000
cpu	$6.31
pfg	190174.326465927
step 6
plcP1	104643
OT	146500.2
effic	0.9709088281
step 7
produce	101,599
leftover pfg	88,576	for period 2
step 8	P1	P2	#change	%change	given	totalchange
econ	100	95	-5	-0.05	1.4	-0.07
seas	95	115	20	0.2105263158	1	0.2105263158
total change						0.1405263158
adjMPP1	114348.8125
estMP2	130417.829835526
leftover pfg	88,576	for period 2
min order P2	41842.32
cpu	$6.31
ordermin	$264,025.01
step 9
plcP1	104643		depreciation
do nothing	101268.26325		2%
	3374.73675		inflation
status quo	$ 236,231.57		1.25%
add units	1000
cost	$ 70,000.00
total inv	$ 306,231.57
step 10
produce	101,599
cost main	$ 76,199.11	$ 0.75	maintenance

Statements

Xgame practice. Period 1. Model No. 1
	Price index	102.5
	Fcst, annual Change	5
	Econ index	94
	Fcst, nxt qtr	93
	Seasonal index	115
	Next quarter	90
Operating Statement For Firm 2
Market potential			101,311
Sales volume			101,311
Percent Share of industry sales			13
Production volume (this year)			107,257
Closing inventory of finished goods (units)			16,111
Plant capacity, Quarter 2 (next quarter)			109,279
Income Statement
Total revenue (sales revenue)			2,556,082
Expense
	Marketing	150,000
	R&D	120,000
	Administration	288,223
	Maintenace	80,443
	Labor (regular time cost/unit 5.73)	623,922
	Raw materials consumed (cost/unit 6.31)	674,565
	Reduction, finished goods inventory	73,722
	Plant+eq depreciation (%change rate/qrt 2.00)	151,120
	Robotics depreciation (%change rate/qrt 0.00)	0
	Finished goods carrying cost	32,618
	Raw material carrying cost	42,763
	Ordering costs	50,614
	Plant investment expenses	6,470
	Financing charges and penaltes	0
	Sundry expense	87,802
Total expenses			2,234,816
Profit before income tax			321,266
Incme tax or refund (Inv.credit 0.0%; surtax 0.0%)			109,230
Net profit after income tax			212,036
Dividents paid			51,500
Addition to owners' equity			160,536
Cash Flow
Total receipts (sales revunue)			2,556,082
Disbursements
	Cash expense	1,482,853
	Net income tax payment	109,230
	Dividends paid	51,500
	Robotics investment	0
	Plant investment	254,354
	Materials purchased	310,000
Total disbursements			2,207,938
Net addition to cash			348,144
Financial Statement
cash assets			1,692,313
Inventiry value, finished goods			195,705
Inventory value, raw materials			490,690
Robotics book value			0
Plant + equipment book value			7,659,244
Owners equity			10,037,950
Robotics replacement value			0
Plant + equipment replacement value			7,838,420
Owners economic equity			10,217,130