Calculate total costs of ordering and carrying inventories

Assignment Help Financial Management

Reference no: EM13890136

Start with the partial model in the file Ch28 P03 Build a Model.xls on the textbook’s Web site. The following inventory data have been established for the Adler Corporation. (1) Orders must be placed in multiples of 100 units. (2) Annual sales are 338,000 units. (3) The purchase price per unit is $3. (4) Carrying cost is 20% of the purchase price of goods. (5) Cost per order placed is $24. (6) Desired safety stock is 14,000 units; this amount is on hand initially. (7) Two weeks are required for delivery. a. What is the EOQ? b. How many orders should the firm place each year? c. At what inventory level should a reorder be made? Hint: Reorder point = (Safety stock + Weeks to deliver × Weekly usage) − Goods in transit. d. Calculate the total costs of ordering and carrying inventories if the order quantity is (1) 4,000 units, (2) 4,800 units, or (3) 6,000 units. What are the total costs if the order quantity is the EOQ? e. What are the EOQ and total inventory costs if the following were to occur? (1) Sales increase to 500,000 units. (2) Fixed order costs increase to $30; sales remain at 338,000 units. (3) Purchase price increases to $4; sales and fixed costs remain at original values.

Reference no: EM13890136

Questions Cloud

Loan off by making your planned monthly payments : Your Christmas ski vacation was great, but it unfortunately ran a bit over budget. All is not lost: You just received an offer in the mail to transfer your $13,000 balance from your current credit card, which charges an annual rate of 20.8 percent, t..

How big will the balloon payment be : You have just arranged for a $1,740,000 mortgage to finance the purchase of a large tract of land. The mortgage has an APR of 7.4 percent, and it calls for monthly payments over the next 20 years. However, the loan has an eight-year balloon payment, ..

At what rate does the firm just break even : Consider a firm with a contract to sell an asset for $150,000 five years from now. The asset costs $86,000 to produce today. Given a relevant discount rate on this asset of 12 percent per year, calculate the profit the firm will make on this asset. A..

Describes the characteristics of off-balance sheet financing : Leasing is often referred to as off-balance sheet financing of the way that the transaction is treated and reported in financial statements. Which of the following statements best describes the characteristics of off-balance sheet financing?

Calculate total costs of ordering and carrying inventories : Start with the partial model in the file Ch28 P03 Build a Model.xls on the textbook’s Web site. The following inventory data have been established for the Adler Corporation. (1) Orders must be placed in multiples of 100 units. Calculate the total cos..

Fixed rate mortgage with monthly payments : You are buying a house and will borrow $215,000 on a 30-year fixed rate mortgage with monthly payments to finance the purchase. Your loan officer has offered you a mortgage with an APR of 4.45 percent. What are the most points you would be willing to..

The bond is callable after nine years with the call price : You own a bond with the following features: face value of $1000, coupon rate of 6% (semiannual compounding), and 15 years to maturity. The bond has a current price of $1,200. The bond is callable after nine years with the call price of $1100. What is..

Common equity capital-Holding everything else constant : S. Girard Inc. has $375,000 of assets, and it uses only common equity capital (zero debt). Its sales for the last year were $595,000, and its net income was $25,000. Stockholders recently voted in a new management team that has promised to lower cost..

Operations and generate future sales and cash flows : Rivashes Fashion recently reported $10,750 of sales, $5,500 of operating costs other than depreciation, and $1,250 of depreciation. The company had $3,500 of bonds that carry a 6.25% interest rate, and its federal-plus-state income tax rate was 35%. ..

User Account

All Pages