Please this problem using Python (with Gurobi) 1) Suppose that you are hired by realm to manage the financial portfolio for the Seven Kingdoms. One of the most popular ways to make investments is to invest into the dragon glass market by the Iron Bank of Braavos. The purchase of the dragon glass from the Iron Bank, if any, must be made on the first day of each month, and dragon glass can be sold to the Iron Bank only on the last day of each month. The purchasing/selling prices of dragon glass are of course fluctuating, but Bran Stark (a.k.a. The Three-eyed Raven) has made a prediction into the purchasing and selling prices of dragon glass (per ton) for the next four months as shown in the picture below. Please note that the realm must be able to pay cash for the dragon glass at the time of purchase, so the amount of dragon glass that the realm can buy is limited by the cash in hand on the first day of each month. The inventory capacity for dragon glass is 1000 tons. Today is the first day of month 1, and currently, the Seven Kingdoms have 100 tons of dragon glass and $10,000 in cash. Finally, the realm has determined that at least 500 tons of dragon glass need to be in the inventory at the end of month 4 to be used for producing weapons in the upcoming war. A) Formulate a linear program to maximize the amount of cash at the end of month 4. Be sure to clearly define the decision variables, the objective function, and constraints of your model. B) Suppose that the realm will put their cash in a saving account at Iron bank and earn some interest each month. The monthly interest is 10%. For example, if the remaining cash amount after purchasing dragon glass at the start of the month is $1,000, then the amount of cash available at the end of the month before selling dragon glass will become $1,000×(1 + 10%) = $1,100. Taking this into consideration, how would you modify the formulation in part (a)?

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Topic Video

Question

Please this problem using Python (with Gurobi) 1) Suppose that you are hired by realm to manage the financial portfolio for the Seven Kingdoms. One of the most popular ways to make investments is to invest into the dragon glass market by the Iron Bank of Braavos. The purchase of the dragon glass from the Iron Bank, if any, must be made on the first day of each month, and dragon glass can be sold to the Iron Bank only on the last day of each month. The purchasing/selling prices of dragon glass are of course fluctuating, but Bran Stark (a.k.a. The Three-eyed Raven) has made a prediction into the purchasing and selling prices of dragon glass (per ton) for the next four months as shown in the picture below. Please note that the realm must be able to pay cash for the dragon glass at the time of purchase, so the amount of dragon glass that the realm can buy is limited by the cash in hand on the first day of each month. The inventory capacity for dragon glass is 1000 tons. Today is the first day of month 1, and currently, the Seven Kingdoms have 100 tons of dragon glass and $10,000 in cash. Finally, the realm has determined that at least 500 tons of dragon glass need to be in the inventory at the end of month 4 to be used for producing weapons in the upcoming war. A) Formulate a linear program to maximize the amount of cash at the end of month 4. Be sure to clearly define the decision variables, the objective function, and constraints of your model. B) Suppose that the realm will put their cash in a saving account at Iron bank and earn some interest each month. The monthly interest is 10%. For example, if the remaining cash amount after purchasing dragon glass at the start of the month is $1,000, then the amount of cash available at the end of the month before selling dragon glass will become $1,000×(1 + 10%) = $1,100. Taking this into consideration, how would you modify the formulation in part (a)?

Month Purchasing price Selling price
1
2
234
4
12
15
10
15
10
12
15
20

Expert Solution

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions