Zoho Sheet

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58

Server : Buy vs. Lease


Enter product information in the white fields.

			Purchase and Product Information
			Purchase Price:	$550.00	per unit
			Monthly Lease Cost:	$7.00	per unit/month
			Number of Units:	1,000
			MTBF:	40,000	hours
			Warranty Period for purchased units:	24	months
			Management costs for returning leased or under-warranty units:	$150.00

			Duty Cycle
			Hours per day:	10
			Days per week:	5
			Weeks per year:	50


Refesh Cycle	Reliability	Number of Failed Units	Purchase Cost	Lease Costs	Replacement Costs				TCO
(Months)					Buy			Lease
					Unit Replacement Cost	Warranty Savings	Total Replacement Cost	Unit Replacement Cost	Buy	Lease
0	1.00	0	$550,000.00	$0.00	$0.00	$0.00	$0.00	$0.00	$550,000.00	$0.00
3	0.98	16	$550,000.00	$108,524.94	$8,526.96	-$6,201.43	$2,325.53	$2,325.53	$552,325.53	$110,850.48
6	0.97	31	$550,000.00	$215,367.36	$16,921.72	-$12,306.71	$4,615.01	$4,615.01	$554,615.01	$219,982.37
9	0.95	46	$550,000.00	$320,553.34	$25,186.33	-$18,317.33	$6,869.00	$6,869.00	$556,869.00	$327,422.34
12	0.94	61	$550,000.00	$424,108.56	$33,322.82	-$24,234.77	$9,088.04	$9,088.04	$559,088.04	$433,196.60
15	0.92	75	$550,000.00	$526,058.31	$41,333.15	-$30,060.47	$11,272.68	$11,272.68	$561,272.68	$537,330.99
18	0.91	89	$550,000.00	$626,427.47	$49,219.30	-$35,795.86	$13,423.45	$13,423.45	$563,423.45	$639,850.92
21	0.90	104	$550,000.00	$725,240.55	$56,983.19	-$41,442.32	$15,540.87	$15,540.87	$565,540.87	$740,781.42
24	0.88	118	$550,000.00	$822,521.68	$64,626.70	$0.00	$64,626.70	$17,625.46	$614,626.70	$840,147.15
27	0.87	131	$550,000.00	$918,294.61	$72,151.72	$0.00	$72,151.72	$19,677.74	$622,151.72	$937,972.35
30	0.86	145	$550,000.00	$1,012,582.71	$79,560.07	$0.00	$79,560.07	$21,698.20	$629,560.07	$1,034,280.91
33	0.84	158	$550,000.00	$1,105,409.01	$86,853.57	$0.00	$86,853.57	$23,687.34	$636,853.57	$1,129,096.35
36	0.83	171	$550,000.00	$1,196,796.17	$94,033.99	$0.00	$94,033.99	$25,645.63	$644,033.99	$1,222,441.81
39	0.82	184	$550,000.00	$1,286,766.51	$101,103.08	$0.00	$101,103.08	$27,573.57	$651,103.08	$1,314,340.08
42	0.80	196	$550,000.00	$1,375,341.98	$108,062.58	$0.00	$108,062.58	$29,471.61	$658,062.58	$1,404,813.60
45	0.79	209	$550,000.00	$1,462,544.22	$114,914.19	$0.00	$114,914.19	$31,340.23	$664,914.19	$1,493,884.46
48	0.78	221	$550,000.00	$1,548,394.52	$121,659.57	$0.00	$121,659.57	$33,179.88	$671,659.57	$1,581,574.40
51	0.77	233	$550,000.00	$1,632,913.83	$128,300.37	$0.00	$128,300.37	$34,991.01	$678,300.37	$1,667,904.84
54	0.75	245	$550,000.00	$1,716,122.79	$134,838.22	$0.00	$134,838.22	$36,774.06	$684,838.22	$1,752,896.85
57	0.74	257	$550,000.00	$1,798,041.71	$141,274.71	$0.00	$141,274.71	$38,529.47	$691,274.71	$1,836,571.17
60	0.73	268	$550,000.00	$1,878,690.60	$147,611.40	$0.00	$147,611.40	$40,257.66	$697,611.40	$1,918,948.25

1_ Instructions

2_ Server Worksheet