Question: Fun n Games is a large discount toy store in Fashion City Mall. The store typically has slow sales in the summer months that increase

Fun €™n Games is a large discount toy store in Fashion City Mall. The store typically has slow sales in the summer months that increase dramatically and rise to a peak at Christmas. However, during the summer and fall, the store must build up its inventory to have enough stock for the Christmas season. In order to purchase and build up its stock during the months when its revenues are low, the store borrows money. Following is the store€™s projected revenue and liabilities schedule for July through December (where revenues are received and bills are paid at the first of each month).

Fun €™n Games is a large discount toy store in

At the beginning of July the store can take out a six month loan that carries an 11% interest rate and must be paid back at the end of December. (The store cannot reduce its interest payment by paying back the loan early.) The store can also borrow money monthly at a rate of 5% interest per month. Money borrowed on a monthly basis must be paid back at the beginning of the next month. The store wants to borrow enough money to meet its cash flow needs while minimizing its cost of borrowing.
a. Formulate and solve a linear programming model for this problem.
b. What would be the effect on the optimal solution if the store could secure a 9% interest rate for a 6-month loan from anotherbank?

Month July August September October November December Revenues $20,000 30,000 Liabilities 30,000 30,000 20,000 100,000

Step by Step Solution

3.46 Rating (169 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a subject to Solution b Changin... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Excel file Icon

184_60713b19a8a02_143247.xlsx

300 KBs Excel File

Students Have Also Explored These Related Management Leadership Questions!