Explore BrainMass
Share

EOQ Analysis in Excel

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Christine Yamaguchi is the manager of the A-to-Z Office Supply Company in Charlotte. 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, A-to-Z 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. Christine maintains these inventory levels by borrowing cash on a daily basis from the First Piedmont 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 Christine takes out a loan to purchase inventory, the bank charges the company a loan origination fee of $1,200 plus 2.25 points (2.25% of the amount borrowed).

Christine 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. Determine the amount of the loan Christine should secure from the bank, the total annual cost of the company's borrowing policy, and the number of loans the company should obtain during the year. Also determine the level of cash on hand at which the company should apply for a new loan, given that it takes 15 days for a loan to be processed by the bank.

Suppose the bank offers Christine 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 the company's optimal loan amount be?

© BrainMass Inc. brainmass.com October 25, 2018, 3:57 am ad1c9bdddf
https://brainmass.com/business/business-math/eoq-analysis-in-excel-361384

Solution Summary

EOQ Analysis in Excel is assessed.

$2.19
See Also This Related BrainMass Solution

EOQ Analysis - ABC Corporation

Having problems solving this because I can not determine "S" Here is the problem.

ABC Corporation purchases 1,200,000 units per year of a component. The fixed cost per order is $25. The annual carrying cost of the item is 27% of its $2 cost.

A) Determine the EOQ cost under the following conditions: (1) No changes,
(2) order cost of zero, and (3) carrying cost of zero

B). what do your answers illustrate about the EOQ Model.

I have attached a file of the work I have done. Any help would be greatly appreciated.

View Full Posting Details