Amounts of inventory to order for different office supplies

Assignment Help Operation Management

Reference no: EM132186424

Christie Levine is the manager of the Instant Paper Clip Office Supply Company in Louisville. The company attempts to gain an advantage over its competitors by providing quality customer service, which includes prompt delivery of orders by truck or van and always being able to meet customer demand from its stock. In order to achieve this degree of customer service, it must stock a large volume of items on a daily basis at a central warehouse and at three retail stores in the city and suburbs. Christie maintains these inventory levels by borrowing cash on a daily basis from the First American Bank. She estimates that for the coming fiscal year the company's demand for cash to pay for inventory will be $17,000 per day for 305 working days. Any money she borrows during the year must be repaid with interest by the end of the year. The annual interest rate currently charged by the bank is 9%. Any time Christie takes out a loan to purchase inventory, the bank charges the company a loan origination fee of $1200 plus 2 ¼ points (2.25% of the amount borrowed).

Christie often uses EOQ analysis to determine optimal amounts of inventory to order for different office supplies. Now she is wondering if she can use the same type of analysis to determine an optimal borrowing policy.

1. Determine the amount of the loan Christie should borrow, the total annual cost of the company’s policy, and the number of loans that the company should obtain during the year.

2. Determine the level of cash on hand at which the company should apply for the new loan given that it takes the bank 15 days for the loan to be processed by the bank.

3. Suppose the bank offers Christie a discount as follows. On any loan amount equal to or greater than $500,000, the bank will lower the number of points charged on the loan origination fee from 2.25% to 2.00%. What would be the company's optimal amount borrowed?

Please explain your solution AND if possible show work in excel.

Reference no: EM132186424

Questions Cloud

What conclusions can you draw from distribution of products : Tabulate the results at the bottom of each column. What conclusions can you draw from the distribution of your products?

Salesperson visits from one of pharmaceutical companies : University Drug Pharmaceuticals orders its antibiotics every two weeks (14 days) when a salesperson visits from one of the pharmaceutical companies.

Result in company lack of competitiveness : How would you respond to the simple statement, "A lack of critical thinking can result in a company's "lack of competitiveness."

Sometimes problematic situations at work compound : Sometimes problematic situations at work compound to an elevated level you are able to cope with, but this week, you noticed that you are easily agitated,

Amounts of inventory to order for different office supplies : Christie often uses EOQ analysis to determine optimal amounts of inventory to order for different office supplies.

Find the necessary planned-order releases for all components : Use the low-level-coded bill-of-materials to find the necessary planned-order releases for all components.

Calculate the inventory carrying cost associated : Calculate the inventory carrying cost associated with your plan using planned end of month levels.

Transmissions are delivered to the fabrication line : Transmissions are delivered to the fabrication line four at a time. It takes one hour for transmissions to be delivered.

What are value assumptions : Academic argument implies which of the following? What are value assumptions? Describe them.

User Account

All Pages