Question
A large toy discount store has slow sales in the summer months that increase drastically and rise to a peak in Christmas. During the summer
A large toy discount store has slow sales in the summer months that increase drastically and rise to a peak in 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 inventory during the months when revenue is low, the store borrows money. Following is the stores 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 (in thousands) | Liabilities (in thousands) |
July | $20 | $60 |
August | $30 | $60 |
September | $40 | $80 |
October | $50 | $30 |
November | $80 | $30 |
December | $100 | $20 |
At the beginning of July, the store can take out a 6-month loan that carries an 11% interest rate (for the entire period) and that must be paid on January 1. The loan cannot be paid early and interests are not paid monthly, instead they are all paid on January 2. The store can also borrow money monthly at a rate of 5% per month. Money borrowed on a monthly basis must be paid back at the beginning of the next month, along with the interests. For example, if $100 are borrowed on July 1 then $105 must be paid on August 1. Money borrowed on December 1 must be paid on January 1. The store wants to borrow money to meet its cash flow obligations while minimizing its cost of borrowing. Note that minimizing the cost of borrowing is the same as maximizing the stores cash position on January 1. Also, note that positive cash balances from one month should be carried to the next month. No negative cash balances are allowed.
- What type of optimization problem is this? Options: Inventory, Cash flow, Transshipment, Assignment, Binary
- Consider a borrowing plan of monthly loans (in thousands of dollars) taken on the first day of each of the following months: $40 in July, $72 in August, $116 in September, $102 in October, and $57 in November. Is this plan feasible? Yes or No
- Consider a borrowing plan of monthly loans (in thousands of dollars) taken on the first day of each of the following months: $40 in July, $72 in August, $116 in September, $102 in October, and $57 in November. What is the cash position on January 1 for this plan?
- Create a model to find a plan that maximizes the stores cash position on January 1. What is the optimal borrowing plan?
- Six-month loan:
- July loan:
- August loan:
- September loan:
- October loan:
- November loan:
- December loan:
- What is the cash position on January 1 for the optimal borrowing plan?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started