1 you are a CFA (chartered financial analyst). Madonna has come to you because she needs help paying off her credit card bills. She owes the amounts on her credit cards shown in the Table below. Madonna is willing to allocate a fixed amount of dollars per month (P) to pay off these credit cards, i.e., the total payments on the three cards each month cannot be more than P. All cards must be paid off within a deadline which can be negotiated with the card companies. Madonna want s the monthly payment (P) to be as small as possible. She would like to know how the minimum monthly payment (P) can change with the deadline which can be in the range of 12 months to 36 months. Her intuition is that the shorter the deadline the larger the minimum monthly payment. To solve this problem, you must understand how interest on a loan works. To illustrate, suppose Madonna pays $5,000 on Saks during month 1. Then her Saks balance at the beginning of month 2 is 20, 000 + 15, 000 0.005 + (20, 000 15, 000) 0.02 5, 000 This follows because during month 1 Madonna i n c u r s 15, 000 0.005 + (20, 000 15, 000) 0.02 in interest charges on her Saks card. You need to present the results of your r esea rc h i n both t h e t a b u l a r and g r a p h i c a l f o r m s . In the t a b u l a r form the first column is the deadline in months and the second column is the minimum monthly p a y m e n t (P). In the graphical form the horizontal axis is the deadline in months and the vertical axis is the minimum monthly payment (P ). Formulate an LP and use LINGO to solve this problem. (hint: the deadline is a parameter in your LP model and the LINGO code which can be changed) Card Saks Bloom Macys Balance($) 20,000 50,000 40,000 Monthly Rate 0.5 cent for each dollar below 15,000, but 2 cents for each dollar above 15,000. 1% 1.5%