What would the effect be on the optimal solution

Assignment Help Operation Management

Reference no: EM131645951

Toyz is a large discount toy store in Valley Wood Mall. The store typically has slow sales in the summer months that increase dramatically and rise to a peak at Christmas. During the summer and fall, the store must build up its inventory to have enough stock for the Christmas season. 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):

Month Revenues

July $20,000 August 30,000 September 40,000 October 50,000 November 80,000 December 100,000

Liabilities

$60,000 60,000 80,000 30,000 30,000

20,000

At the beginning of July, the store can take out a 6-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.

Formulate a linear programming model for this problem.

Solve this model by using the computer.

What would the effect be on the optimal solution if Toyz could secure a 9% interest rate for a 6-month loan from another bank?

Please provide with excel format

Reference no: EM131645951

Questions Cloud

How did the nazis at wannsee rationalize their actions : How did the Nazis at Wannsee rationalize their actions?

Australian rupert murdoch was able to form fox : Australian Rupert Murdoch was able to form FOX in 1986, the first new U.S. broadcast in over 40 years, for all of the following reasons EXCEPT:

Difference between the british and american versions : According to Beeden and DeBruin, which of the following is a key difference between the British and American Versions of The Office?

Experienced or observed based on cultural differences : Cultural Assignment. Describe an instance of stereotyping or prejudice you have experienced or observed based on cultural differences

What would the effect be on the optimal solution : What would the effect be on the optimal solution if Toyz could secure a 9% interest rate for a 6-month loan from another bank?

Learning can impact social determinant of health : transformative learning can impact the social determinant of health.

What leadership styles are used within that organization : What characteristics make an organization a team-based organization? What leadership styles are used within that organization?

What is the optimal size of the production run for bumpers : Based on the above information, what is the optimal size of the production run for bumpers?

Contemporary ideas about human resource management : Interestingly, contemporary ideas about human resource management and developing human capital have their roots in early 20th century research findings-theories

User Account

All Pages