Assume the US Govt wants to provide free internet storage to all its citizens. Create a program to manage it and estimate the 3 year cost for the program.
Interviewer clarified that they wanted storage costs for the program.
Follow-up Q: What are the risks associated with such a program?
Follow-up Q: What are the risks associated with such a program?
Asked at
Google
How to answer Estimation questions
Interview Guide
Answers (1)
You'll get access to over 3,000 product manager interview questions and answers
Recommended by over 100k members
Clarification:
- Can you pls let me know what manage means? Does it mean hosting the storage, enrolling new citizens, providing adminstration and technology support? Yes
- Is it intended to offer only for 3 years starting from this year or 3 years for every citizen in their life or want to estimate cost only for 3 years but given free life time? Later
The source of cost are below.
- Storage cost
- Networking Cost
- Manpower cost (administration & Technology support
User and Needs
- 0-6Yrs no need for storage and they dont operate electronic devices
- 7-18 Years for storing education and cartoon material
- 18-60 Years to store personal videos
- 60+ years for storing personal videos
Solution
As the storage is for all and lets assume population growth of 5% and inflation of 2%
Age | Need | Mobile Size (GB) | Laptop (GB) | Age group | Total Size (MillionGB) |
0-6 Yrs | 0 | 0 | 0 | 10% | - |
7-18Yrs | Education | 20 | 60 | 20% | 4,800 |
18-60Yrs | Hobby | 60 | 200 | 40% | 31,200 |
60+ | Hobby | 40 | 100 | 30% | 12,600 |
48,600 |
Based on this total storage required in Yr 1 is 48.6MillionTB. Government may choose to go for a distaster recorvery that will provision 50% of additional data.
Hence total storage in a day = 72.9Million TB
Per TB storage cost per year = 50$
Inflation= 2%
Growth in population 5% and equal in all segments and constant for 3 years.
Storage Million TB | Cost ($) | |
Yr 1 | 48.6 | 50 |
Yr 2 | 51.03 | 51 |
Yr 3 | 53.58 | 52 |
Total cost in Mn$ | 7820 |
Total 3 Yrs storage cost=$7.82 B
Total cost including networking and applications (Assuming netwrking and updation of applications in servers is 10% of storage cost)= 7.82X1.1=$8.6B
Manpower cost:
Assuming 3 scrum teams (25 people) required to maintain and update servers and resolve any problems, Total Years cost = $0.2MX 25= $5M=$0.005B (Does not impact the total cost)
So total cost of 3 years operation is $8.6B
Program composition:
- 1 Scrum team to manage the storage
- 1 scrum team to resolve customer problems at back end
- 1 scrum team taking customer grievances and managers to manage the team
0 likes | 1 feedback
Top Google interview questions
- What is your favorite product? Why?89 answers | 263k views
- How would you design a bicycle renting app for tourists?62 answers | 82.5k views
- Build a product to buy and sell antiques.54 answers | 66.8k views
- See Google PM Interview Questions
Top Estimation interview questions
- Calculate the number of queries answered by Google per second.45 answers | 78.5k views
- How do you decide how many cash registers you need for a new Walmart store?33 answers | 39.4k views
- How many dentists are there in New York?33 answers | 36.7k views
- See Estimation PM Interview Questions
Top Google interview questions
- How would you improve Google Maps?53 answers | 228k views
- A metric for a video streaming service dropped by 80%. What do you do?50 answers | 135k views
- How would you design a web search engine for children below 14 years old?36 answers | 42.9k views
- See Google PM Interview Questions
Top Estimation interview questions
- Estimate the number of Uber rides.30 answers | 51.3k views
- Estimate the number of bicycles required to start a bike sharing operation in a big city.18 answers | 15.8k views
- Estimate the number of WhatsApp chats occuring in India.14 answers | 13.3k views
- See Estimation PM Interview Questions