MIKESBIKES SIMULATION - FREE EXCEL FILE FOR Calculation OF 8 ROUNDS.xlsx

	A	B	D	E	G	H	J	K	M	N	P
1	Round 1	2019
2	Unit	26.500
3	Price	2.200
4	Revenue	58.300.000									58.300.000
5		5%
6	ADS	2.915.000
7
8	SCU	0,92
9		24.380									24.380
10	Workers	400
11		61									61
12
13	R2-2020	ADV		LEI		COM		KID		RACE
14	Unit	29.000	Unit	40.000	Unit	-	Unit	-	Unit	8.000
15	Price	2.150	Price	480	Price	400	Price	450	Price	4.500
16	Revenue	62.350.000	Revenue	19.200.000	Revenue	-	Revenue	-	Revenue	36.000.000	117.550.000
17		5%		5%		5%		5%		5%
18	ADS	3.117.500	ADS	960.000	ADS	-	ADS	-	ADS	1.800.000
19	Inventory	1.200		-		-		-		-
20	Production	27.800		40.000		-		-		8.000
21	SCU	0,92	SCU	0,23	SCU	0,17	SCU	0,18	SCU	1
22		26.680		9.200		-		-		8.000	43.880
23	Workers	400	Workers	400	Workers	400	Workers	400	Workers	400
24		67		23		-		-		20	110
25
26
27	R3 - 2021	ADV		LEI		COM		KID		RACE
28	Unit	31.000	Unit	60.000	Unit	30.000	Unit	30.000	Unit	5.000
29	Price	2.100	Price	460	Price	340	Price	340	Price	4.300
30	Revenue	65.100.000	Revenue	27.600.000	Revenue	10.200.000	Revenue	10.200.000	Revenue	21.500.000	134.600.000
31		5%		5%		5%		5%		5%
32	ADS	3.255.000	ADS	1.380.000	ADS	510.000	ADS	510.000	ADS	1.075.000
33	Inventory	-		-		-		-		2.600
34	Production	31.000		60.000		30.000		30.000		2.400
35	SCU	0,92	SCU	0,21	SCU	0,17	SCU	0,18	SCU	1,12
36		28.520		12.600		5.100		5.400		5.600	57.220
37	Workers	400	Workers	400	Workers	400	Workers	400	Workers	400
38		71		32		13		14		14	143
39
40
41	R4 - 2022	ADV		LEI		COM		KID		RACE
42	Unit	38.000	Unit	43.000	Unit	36.000	Unit	43.000	Unit	5.500
43	Price	2.050	Price	460	Price	350	Price	350	Price	4.400
44	Revenue	77.900.000	Revenue	19.780.000	Revenue	12.600.000	Revenue	15.050.000	Revenue	24.200.000	149.530.000
45		5%		5%		5%		5%		5%
46	ADS	3.895.000	ADS	989.000	ADS	630.000	ADS	752.500	ADS	1.210.000
47	Inventory	-		13.000		1.200		1.500		-
48	Production	38.000		30.000		34.800		41.500		5.500
49	SCU	0,92	SCU	0,21	SCU	0,13	SCU	0,15	SCU	1,12
50		34.960		9.030		4.680		6.450		6.160	61.280
51	Workers	400	Workers	400	Workers	400	Workers	400	Workers	400
52		87		23		12		16		15	153
53
54
55	R5 - 2023	ADV		LEI		COM		KID		RACE
56	Unit	35.000	Unit	40.000	Unit	43.000	Unit	46.000	Unit	4.500
57	Price	2.000	Price	450	Price	330	Price	330	Price	4.300
58	Revenue	70.000.000	Revenue	18.000.000	Revenue	14.190.000	Revenue	15.180.000	Revenue	19.350.000	136.720.000
59		5%		5%		5%		5%		5%
60	ADS	3.500.000	ADS	900.000	ADS	709.500	ADS	759.000	ADS	967.500
61	Inventory	2.000		1.000		2.000		2.000		700
62	Production	33.000		39.000		41.000		44.000		3.800
63	SCU	0,67	SCU	0,13	SCU	0,13	SCU	0,15	SCU	1,12
64		23.450		5.200		5.590		6.900		5.040	46.180
65	Workers	400	Workers	400	Workers	400	Workers	400	Workers	400
66		59		13		14		17		13	115
67
68
69
70
71	MikesBikes Simulation Game
72	Free Winning Guide and Tips
73	Free Personal Support for Round 1 and Round 2
74	Email	mbasimbikes@gmail.com
75	Quick Guide:	https://bit.ly/3JH7mDW
76	Free Excel file:	https://bit.ly/3p91zh8
77	Blogs:	https://mbasimbikes.blogspot.com
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100