appliancewarehouse case study 9

profilekamishliang
build-costs-and-durations.xlsx

Sheet1

Costs for in-house development Standard Development Times
As standard practice, use these costs for all in-house development. As standard practice, use these guidelines (assume 8 hours of work per day).
Cost per hour (for first year) Duration
Database Development $ 60 Database design 5 days
Web developers $ 75 Database build 10 days
App developers $ 75 Design of a report (web or app) 2 days
UX designers $ 60 Design of data entry page (web or app) 2 days
Business Analyst $ 50 Design of static text page (web or app) 1 day
Trainers $ 50 Build of a report (web or app) 1 day
Cybersecurity specialists $ 90 Build of data entry page (web or app) 1 day
System Admin $ 70 Build of static text page (web or app) 1 day
Connection to separate system or database (sys admin) 8 days
Analysis work (both web and app combined) 20 days
Training 5 days
Equipment: Cybersecurity work 10 days
Servers $ 2,500
Routers $ 200
Expected Monthly Maintenance:
Development (web or app) 2 days
System Admin 3 days
Training 1 day
Key:
Web or app = activity must be done for both web and app. Same amount of time required for each deliverable.
Both web and app = time given includes development for both of the web and app deliverables.