Simulation Model (Learn under DR. TAN CHIN LUNG).xlsx

	B	C	D	E	F	G	H	J	K	L	N	O
1
2	Simulation of Walton's Bookstore - Simulation Model
3
4	Cost data			Demand distribution
5	Unit cost	$7.5		Cummulative probability	Demand	Probability
6	Unit price	$10.0		0	100	0.3
7	Unit refund	$2.5		0.3	150	0.2
8				0.5	200	0.3
9	Decision variable			0.8	250	0.15
10	Order quantity	200		0.95	300	0.05
11
12	Summary measures for simulation
13	Average profit	$177.5
14	Stdev of profit	$332.3
15	Minimum profit	-$250.0
16	Maximum profit	$500.0
17
18	Simulation							Distribution of profit			Data table for average profit versus order quantity
19	Replication	Random#	Demand	Revenue	Cost	Refund	Profit	Profit	Frequency	Relative frequency	Order quantity	Average profit
20	1	0.87756714	250	$2,000.00	$1,500.0	$0.0	$500.0	#NAME?	0	0		$177.5
21	2	0.7303485463	200	$2,000.00	$1,500.0	$0.0	$500.0		0	0	100	$250.00
22	3	0.4859465055	150	$1,500.00	$1,500.0	$125.0	$125.0		0	0	125	$258.88
23	4	0.6771718106	200	$2,000.00	$1,500.0	$0.0	$500.0				150	$255.75
24	5	0.7577172828	200	$2,000.00	$1,500.0	$0.0	$500.0				175	$214.75
25	6	0.7085995302	200	$2,000.00	$1,500.0	$0.0	$500.0				200	$212.00
26	7	0.7376528405	200	$2,000.00	$1,500.0	$0.0	$500.0				225	$114.94
27	8	0.3029691289	150	$1,500.00	$1,500.0	$125.0	$125.0				250	$3.25
28	9	0.8340578158	250	$2,000.00	$1,500.0	$0.0	$500.0				275	-$97.94
29	10	0.7710913542	200	$2,000.00	$1,500.0	$0.0	$500.0				300	-$223.50
30	11	0.9271264735	250	$2,000.00	$1,500.0	$0.0	$500.0
31	12	0.9038843774	250	$2,000.00	$1,500.0	$0.0	$500.0
32	13	0.984021924	300	$2,000.00	$1,500.0	$0.0	$500.0
33	14	0.5004743388	200	$2,000.00	$1,500.0	$0.0	$500.0
34	15	0.3350699484	150	$1,500.00	$1,500.0	$125.0	$125.0
35	16	0.7352648111	200	$2,000.00	$1,500.0	$0.0	$500.0
36	17	0.5215833757	200	$2,000.00	$1,500.0	$0.0	$500.0
37	18	0.3891785668	150	$1,500.00	$1,500.0	$125.0	$125.0
38	19	0.3812842136	150	$1,500.00	$1,500.0	$125.0	$125.0
39	20	0.2477288881	100	$1,000.00	$1,500.0	$250.0	-$250.0
40	21	0.4532034663	150	$1,500.00	$1,500.0	$125.0	$125.0
41	22	0.3757317929	150	$1,500.00	$1,500.0	$125.0	$125.0
42	23	0.8495702118	250	$2,000.00	$1,500.0	$0.0	$500.0
43	24	0.8873949159	250	$2,000.00	$1,500.0	$0.0	$500.0
44	25	0.02493577297	100	$1,000.00	$1,500.0	$250.0	-$250.0
45	26	0.3164077884	150	$1,500.00	$1,500.0	$125.0	$125.0
46	27	0.7681222472	200	$2,000.00	$1,500.0	$0.0	$500.0
47	28	0.7818338798	200	$2,000.00	$1,500.0	$0.0	$500.0
48	29	0.7241713043	200	$2,000.00	$1,500.0	$0.0	$500.0
49	30	0.07351010484	100	$1,000.00	$1,500.0	$250.0	-$250.0
50	31	0.6230561395	200	$2,000.00	$1,500.0	$0.0	$500.0
51	32	0.2298676894	100	$1,000.00	$1,500.0	$250.0	-$250.0
52	33	0.5293895089	200	$2,000.00	$1,500.0	$0.0	$500.0
53	34	0.5392912539	200	$2,000.00	$1,500.0	$0.0	$500.0
54	35	0.04072248247	100	$1,000.00	$1,500.0	$250.0	-$250.0
55	36	0.5041544469	200	$2,000.00	$1,500.0	$0.0	$500.0
56	37	0.7374133836	200	$2,000.00	$1,500.0	$0.0	$500.0
57	38	0.7084531236	200	$2,000.00	$1,500.0	$0.0	$500.0
58	39	0.9387137937	250	$2,000.00	$1,500.0	$0.0	$500.0
59	40	0.7225726917	200	$2,000.00	$1,500.0	$0.0	$500.0
60	41	0.1400499573	100	$1,000.00	$1,500.0	$250.0	-$250.0
61	42	0.8623693728	250	$2,000.00	$1,500.0	$0.0	$500.0
62	43	0.4159815842	150	$1,500.00	$1,500.0	$125.0	$125.0
63	44	0.4477370512	150	$1,500.00	$1,500.0	$125.0	$125.0
64	45	0.6706298579	200	$2,000.00	$1,500.0	$0.0	$500.0
65	46	0.03461587898	100	$1,000.00	$1,500.0	$250.0	-$250.0
66	47	0.3292374622	150	$1,500.00	$1,500.0	$125.0	$125.0
67	48	0.2335476737	100	$1,000.00	$1,500.0	$250.0	-$250.0
68	49	0.8958427978	250	$2,000.00	$1,500.0	$0.0	$500.0
69	50	0.1900910874	100	$1,000.00	$1,500.0	$250.0	-$250.0
70	51	0.5858202977	200	$2,000.00	$1,500.0	$0.0	$500.0
71	52	0.5534964922	200	$2,000.00	$1,500.0	$0.0	$500.0
72	53	0.8893986011	250	$2,000.00	$1,500.0	$0.0	$500.0
73	54	0.9689525932	300	$2,000.00	$1,500.0	$0.0	$500.0
74	55	0.6724688784	200	$2,000.00	$1,500.0	$0.0	$500.0
75	56	0.4175234628	150	$1,500.00	$1,500.0	$125.0	$125.0
76	57	0.09142587256	100	$1,000.00	$1,500.0	$250.0	-$250.0
77	58	0.421792435	150	$1,500.00	$1,500.0	$125.0	$125.0
78	59	0.8349478705	250	$2,000.00	$1,500.0	$0.0	$500.0
79	60	0.5125363554	200	$2,000.00	$1,500.0	$0.0	$500.0
80	61	0.7311537272	200	$2,000.00	$1,500.0	$0.0	$500.0
81	62	0.8939184943	250	$2,000.00	$1,500.0	$0.0	$500.0
82	63	0.625232195	200	$2,000.00	$1,500.0	$0.0	$500.0
83	64	0.8862778335	250	$2,000.00	$1,500.0	$0.0	$500.0
84	65	0.2703045461	100	$1,000.00	$1,500.0	$250.0	-$250.0
85	66	0.1043044426	100	$1,000.00	$1,500.0	$250.0	-$250.0
86	67	0.2409630029	100	$1,000.00	$1,500.0	$250.0	-$250.0
87	68	0.03504415489	100	$1,000.00	$1,500.0	$250.0	-$250.0
88	69	0.1107582436	100	$1,000.00	$1,500.0	$250.0	-$250.0
89	70	0.5087167237	200	$2,000.00	$1,500.0	$0.0	$500.0
90	71	0.196146219	100	$1,000.00	$1,500.0	$250.0	-$250.0
91	72	0.7528297028	200	$2,000.00	$1,500.0	$0.0	$500.0
92	73	0.5024320703	200	$2,000.00	$1,500.0	$0.0	$500.0
93	74	0.2367216483	100	$1,000.00	$1,500.0	$250.0	-$250.0
94	75	0.3825724059	150	$1,500.00	$1,500.0	$125.0	$125.0
95	76	0.252792424	100	$1,000.00	$1,500.0	$250.0	-$250.0
96	77	0.1859521493	100	$1,000.00	$1,500.0	$250.0	-$250.0
97	78	0.2487213364	100	$1,000.00	$1,500.0	$250.0	-$250.0
98	79	0.508194584	200	$2,000.00	$1,500.0	$0.0	$500.0
99	80	0.8815049763	250	$2,000.00	$1,500.0	$0.0	$500.0
100	81	0.8095759064	250	$2,000.00	$1,500.0	$0.0	$500.0