| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | |||||||
2 | <<< COPY THIS TEMPLATE TO YOUR GOOGLE DRIVE TO MODIFY IT >>> | ||||||
3 | <<< VISIT ATSTRATUS.COM TO KICK OFF YOUR NETSUITE IMPLEMENTATION >>> | ATSTRATUS.COM | |||||
4 | |||||||
5 | |||||||
6 | An advisory tool to enumerate cost assossiated with NetSuite implementation and usage for 5 years. | ||||||
7 | |||||||
8 | Software Costs | Notes | |||||
9 | Number of cloud ERP users | 50 | |||||
10 | Cloud ERP subscription fee per user per month | $ 99.00 | |||||
11 | Number of months of cloud ERP usage | 60 | |||||
12 | Total cost of cloud ERP subscription fees | $ 297,000.00 | |||||
13 | |||||||
14 | Number of third-party software users (e.g., integration and migration platforms) | 10 | |||||
15 | Third-party software license subscription fees per user per month | $ 30.00 | |||||
16 | Number of months of third-party software usage | 60 | |||||
17 | Total third-party software usage fees | $ 18,000.00 | |||||
18 | |||||||
19 | Total software costs for the period | $ 315,000.00 | Monthly fee | $ 5,250.00 | |||
20 | |||||||
21 | Implementation Resources Costs | ||||||
22 | Project management internal resources required | 5 | |||||
23 | Average weekly wage for internal project management resources | $ 800.00 | |||||
24 | Number of weeks required for internal project management resources | 3 | |||||
25 | Project management (external) fees | $ - | |||||
26 | Total internal and external project management costs | $ 12,000.00 | |||||
27 | |||||||
28 | Number of internal business analysis and requirements gathering resources required | 5 | |||||
29 | Average weekly wage for internal business analysis and requirements gathering resources | $ 750.00 | |||||
30 | Number of weeks required for internal business analysis and requirements gathering | 2 | |||||
31 | External business analysis and requirements gathering resources fees | $ - | |||||
32 | Total internal and external business analysis and requirements gathering costs | $ 7,500.00 | |||||
33 | |||||||
34 | Number of internal data conversion and migration resources required | 3 | |||||
35 | Average weekly wage for internal data conversion and migration resources | $ 750.00 | |||||
36 | Number of weeks required for internal data conversion and migration resources | 4 | |||||
37 | External data conversion and migration resources fees | $ 10,000.00 | |||||
38 | Total internal and external data conversion and migration resources costs | $ 19,000.00 | |||||
39 | |||||||
40 | Number of internal software configuration and customization resources required | 4 | |||||
41 | Average weekly wage for internal software configuration and customization resources | $ 750.00 | |||||
42 | Number of weeks required for internal software configuration and customization resources | 4 | |||||
43 | External software configuration and customization resources fees | $ 10,000.00 | |||||
44 | Total internal and external software configuration and customization resources costs | $ 22,000.00 | |||||
45 | |||||||
46 | Number of internal resources required for integration with other systems | 3 | |||||
47 | Average weekly wage for internal resources for integration with other systems | $ 800.00 | |||||
48 | Number of weeks required for internal resources for integration with other systems | 4 | |||||
49 | External fees for resources required for integration with other systems | $ - | |||||
50 | Total internal and external costs for resources required for integration with other systems | $ 9,600.00 | |||||
51 | |||||||
52 | Monthly training costs (multiplied by number of months of ERP usage) | $ 500.00 | |||||
53 | Number of months of cloud ERP usage | 60 | |||||
54 | Total training costs | $ 30,000.00 | |||||
55 | |||||||
56 | Number of internal testing resources required | 3 | |||||
57 | Average weekly wage for internal testing resources | $ 800.00 | |||||
58 | Number of weeks required for internal testing resources | 2 | |||||
59 | External testing resources fees | $ - | |||||
60 | Total internal and external testing resources costs | $ 4,800.00 | |||||
61 | |||||||
62 | Total implementation resources costs | $ 104,900.00 | |||||
63 | |||||||
64 | IT Costs | ||||||
65 | Internet connectivity | $ 1,000.00 | |||||
66 | Network infrastructure | $ 10,000.00 | |||||
67 | Security infrastructure | $ 20,000.00 | |||||
68 | Backup and disaster recovery | $ 20,000.00 | |||||
69 | Total IT costs | $ 51,000.00 | |||||
70 | |||||||
71 | Indirect Costs | ||||||
72 | Number of hours of downtime during implementation | 2 | |||||
73 | Number of employees impacted by downtime | 20 | |||||
74 | Average hourly wage of employees impacted by downtime | $ 25.00 | |||||
75 | Total loss of productivity due to downtime | $ 1,000.00 | |||||
76 | |||||||
77 | Number of hours of training required per employee during implementation | 3 | |||||
78 | Number of employees requiring training | 50 | |||||
79 | Average hourly wage of employees requiring training | $ 40.00 | |||||
80 | Total cost of lost productivity during training | $ 6,000.00 | |||||
81 | |||||||
82 | Additional staffing or consulting fees | $ - | |||||
83 | Travel expenses | $ 5,000.00 | |||||
84 | Total indirect costs | $ 12,000.00 | |||||
85 | |||||||
86 | Total estimated cost of cloud ERP implementation | $ 482,900.00 | |||||
87 | |||||||
88 | |||||||
89 | |||||||
90 | |||||||