a) Draw a bar chart for monthly storage requirement. b) What is the total cost (in $1,000)

Fantastic news! We've Found the answer you've been seeking!

Question:

a) Draw a bar chart for monthly storage requirement.

b) What is the total cost (in $1,000) if the company chooses to pay only for the required storage month by month?

c) What is the total cost (in $1,000) if the company chooses a (single) 6-month contract for 60 PB?

d) Define decision variables for an LP formulation to minimize the cost of cloud service.

e) ) Write the objective function.

f) (2 points) List all constraints.

g) Use Excel, LINDO, MPL or by inspection to find an optimal solution. Explain your solution in words.

h) What is the minimum cost (in $1,000) of cloud service for Galaxy Express 999?

Galaxy Express 999 Animation Studio is currently undertaking a digital remastering project for one of its legendary animations. While its headquarter is located in Japan, most of the detailing jobs are done in the US and South Korea. The company expects to complete the project in 6 months with the help of cloud computing services for up-loading and down-loading huge video files. Just how much storage will be needed in each of the next six months are given below.

	Jan	Feb	Mar	Apr	May	Jun
Storage requirement (10 PB; Petabytes)	6	4	1	2	3	5

The cost of cloud service for various contract periods are as follows.

Contract period (months)	1	2	3	4	5	6
Cost per PB for the leasing period (in $1,000)	$50	$98	$144	$188	$230	$263
Monthly cost per PB (in $1,000)	$50	$49	$48	$47	$46	$43.83