Utility computing (cloud computer)

Question 2 [30 marks] MyBank Inc. would like to avail of low spot instance costs for big data analysis during off peak hours (processing of large datasets to gain deeper user insights). They are working on 3 projects, which must be completed in a single 24-hour cycle. The table below details instance/hour requirements for each of the three projects. m5.large 2.med Hours required for each project and type of instance Inst.type> 12.small m5.med m5.small t2.large Project 1 3 1 2 Project 21 2 2 Project 3 2 6 M 2 Pricing for each type of instance is as follows: Start t2.small m5. med m5.small 00:00 0.864 0.299 1.489 01:00 1.430 0.634 1.055 02:00 1.241 1.166 1.189 03:00 1.222 1.322 0.041 04:00 0.136 1.466 1,319 05:00 1.326 0.228 0.892 06:00 1.432 0.110 1.349 07:00 0.581 0.739 0.019 08:00 0.244 0.459 0.588 09:00 0.468 0.507 1.434 10:00 0.129 1.420 0.295 11:00 0.713 0.729 0.591 12:00 0.371 1.285 0.273 13:00 0.403 0.890 1.423 14:00 0.457 0.339 0.103 15:00 0.082 0.917 1.115 16:00 0.502 0.623 17:00 1.038 0.045 0.364 18:00 0.401 1.001 0.162 19:00 0.100 0.995 0.320 20:00 0.933 1.025 0.185 21:00 1.063 0.309 0.218 22:00 0.502 0.730 1.009 23:00 1.420 0.215 0.075 t2.large 1.154 0.798 1.369 1.440 1.452 0.731 1.166 0.868 1.178 0.509 0.732 0.397 0.391 1.467 1.351 1.432 0.945 0.012 1.008 0.168 1.277 0.392 0.194 0.785 m5.large 0.728 0.853 0.596 1.448 1.488 1.007 0.969 0.027 1.342 0.178 0.859 0.113 1.453 0.895 1.206 0.688 0.793 0.743 1.486 0.800 0.934 0.401 0.529 1.035 t2.med 1.415 1.161 1.359 0.206 1.465 0.502 0.146 0.823 0.229 0.677 0.136 0.261 0.359 0.836 1.246 1.007 0.802 0.549 0.208 0.921 1.288 1.319 1.324 1.114 1.057 Please answer the following questions regarding each of the 3 projects. Note: for all answers, you must show your calculations or briefly explain your logic. For Project 1, what is the lowest cost at which the project can be completed? [4 Marks] For Project 2 a. For the quickest project completion time, what is the total project cost? [4 Marks] b. What are the minimum bid prices for each type of instance that will achieve the above? [5 Marks] For Project 3, assume that your budget is $11.80: a. Can the project be completed within budget by 6:00am? Please remember to support your answer with a logical explanation and calculations. [12 Marks] b. If the project can be completed, what are the corresponding minimum bid prices for each type of instance? [5 Marks] Page 3 of 4 Question 2 [30 marks] MyBank Inc. would like to avail of low spot instance costs for big data analysis during off peak hours (processing of large datasets to gain deeper user insights). They are working on 3 projects, which must be completed in a single 24-hour cycle. The table below details instance/hour requirements for each of the three projects. m5.large 2.med Hours required for each project and type of instance Inst.type> 12.small m5.med m5.small t2.large Project 1 3 1 2 Project 21 2 2 Project 3 2 6 M 2 Pricing for each type of instance is as follows: Start t2.small m5. med m5.small 00:00 0.864 0.299 1.489 01:00 1.430 0.634 1.055 02:00 1.241 1.166 1.189 03:00 1.222 1.322 0.041 04:00 0.136 1.466 1,319 05:00 1.326 0.228 0.892 06:00 1.432 0.110 1.349 07:00 0.581 0.739 0.019 08:00 0.244 0.459 0.588 09:00 0.468 0.507 1.434 10:00 0.129 1.420 0.295 11:00 0.713 0.729 0.591 12:00 0.371 1.285 0.273 13:00 0.403 0.890 1.423 14:00 0.457 0.339 0.103 15:00 0.082 0.917 1.115 16:00 0.502 0.623 17:00 1.038 0.045 0.364 18:00 0.401 1.001 0.162 19:00 0.100 0.995 0.320 20:00 0.933 1.025 0.185 21:00 1.063 0.309 0.218 22:00 0.502 0.730 1.009 23:00 1.420 0.215 0.075 t2.large 1.154 0.798 1.369 1.440 1.452 0.731 1.166 0.868 1.178 0.509 0.732 0.397 0.391 1.467 1.351 1.432 0.945 0.012 1.008 0.168 1.277 0.392 0.194 0.785 m5.large 0.728 0.853 0.596 1.448 1.488 1.007 0.969 0.027 1.342 0.178 0.859 0.113 1.453 0.895 1.206 0.688 0.793 0.743 1.486 0.800 0.934 0.401 0.529 1.035 t2.med 1.415 1.161 1.359 0.206 1.465 0.502 0.146 0.823 0.229 0.677 0.136 0.261 0.359 0.836 1.246 1.007 0.802 0.549 0.208 0.921 1.288 1.319 1.324 1.114 1.057 Please answer the following questions regarding each of the 3 projects. Note: for all answers, you must show your calculations or briefly explain your logic. For Project 1, what is the lowest cost at which the project can be completed? [4 Marks] For Project 2 a. For the quickest project completion time, what is the total project cost? [4 Marks] b. What are the minimum bid prices for each type of instance that will achieve the above? [5 Marks] For Project 3, assume that your budget is $11.80: a. Can the project be completed within budget by 6:00am? Please remember to support your answer with a logical explanation and calculations. [12 Marks] b. If the project can be completed, what are the corresponding minimum bid prices for each type of instance? [5 Marks] Page 3 of 4