Business

Thomas Kratzer is the purchasing manager for the headquarters of a large insurance company chain with a central inventory operation. Thomas’s fastest moving inventory item has a demand of 6000 units per year. The cost of each unit is $100.00, and the inventory carrying cost is $10.00 per unit per year. The average ordering cost is $30.00 per order. It takes about 5 days for an order to arrive, and demand for 1 week is 120 units (this is a corporate operation, there are 250 working days per year).

a. What is the EOQ?
b. What is the average inventory if the EOQ is used?
c. What is the optimal number of orders per year?
d. What is the optimal number of days in between any two orders?
e. What is the annual cost of ordering and holding and holding inventory?
f. What is the total annual inventory cost, including cost of the 6,000 units?

  1. 👍 2
  2. 👎 0
  3. 👁 8,470
  1. a. What is the EOQ? = 189.74 units
    Step (1): Determine the Annual Set-up Cost
    *Annual set-up cost = (# of orders placed per year) x (Setup or order cost per order)
    = Annual Demand
    # of units in each order ¡Á (Setup or order cost per order)
    = (D/Q) ¡Á(S)
    = (6000/Q) x (30)
    Step (2): Annual holding cost = Average inventory level x Holding cost per unit per year
    = (Order Quantity/2) (Holding cost per unit per year)
    = (Q/2) ($10.00)

    Step (3):
    Optimal order quantity is found when annual setup cost equals annual holding cost:
    (D/Q) x (S) = (Q/2) x (H)
    (6,000/Q) x (30) = (Q/2) (10)
    =(2)(6,000)(30) = Q2 (10)
    Q2 = [(2 ¡Á6,000 ¡Á30)/($10)] = 36,000
    Q = ¡Ì([(2 ¡Á6,000 ¡Á30)/(10)]) = ¡Ì36,000
    Q = 189.736 ¡Ö 189.74 units
    EOQ = 189.74 units

    b. What is the average inventory if the EOQ is used?
    Average inventory level = (Order Quantity/2)
    = (189.74) /2 = 94.87
    Average Inventory level =94.87 units

    c. What is the optimal number of orders per year?
    N= ( Demand/ order quantity) = (6000/ 189.736)=31.62
    N = 31.62
    The optimal number of orders per year = 31.62

    d. What is the optimal number of days in between any two orders?
    T = (Number of Working Days per year) / (optimal number of orders)
    T = 250 days per year / 31.62 = 7.906
    T= 7.91
    The optimal number of days in between any two orders = 7.91

    e. What is the annual cost of ordering and holding inventory?
    (Q) x (H)
    (189.736 units) x ($10) =$1,897.36
    ¡Ö $1,897

    The annual cost of ordering and holding the inventory = $1,897

    f. What is the total annual inventory cost, including cost of the 6,000 units?
    TC = setup cost + holding cost
    TC = (Dyear/Q) (S) + (Q/2) (H)
    TC = (6,000/189.74) ($30.00) + (189.74/2) ($10.00)
    TC = $948.67 + $948.7
    TC = 1,897.37 ¡Ö $1,897
    Purchase cost = (6,000 units) x ($100/unit) = $600,000
    Total annual inventory cost = $600,000 + $1,897 = $601,897

    Total annual inventory cost = $601,897

    1. 👍 20
    2. 👎 0
  2. $601,897 is correct!

    1. 👍 6
    2. 👎 0

Respond to this Question

First Name

Your Response

Similar Questions

  1. MGF 1106

    Four accounting majors, two economics majors, and three marketing majors have interviewed for five different managerial positions with a large company. Find the number of different ways that five of these people could be hired if

  2. statistic

    Jim has a 5-year-old car in reasonably good condition. He wants to take out a $30,000 term (that is, accident benefit) car insurance policy until the car is 10 years old. Assume that the probability of a car having an accident in

  3. English

    Juanita sent the two __________ reports to __________ yesterday afternoon. A. technicians'; headquarters B. technicians; headquarter's C. technician's; headquarters' D. technicians'; headquarters' A

  4. math

    A company has two office buildings that hold 30,000 employees. Their headquarters contains 14 times as many employees as their overseas branch. Therefore, their headquarters contains __?__ employees.

  1. statistics help

    The branch manager of an outlet (Store 1) of a nationwide chain of pet supply stores wants to study characteristics of her customers. In particular, she decides to focus on two variables: the amount of money spent by customers and

  2. History

    Based on Common sense and the crisis what conclusion can be made about Thomas Paine? A : Thomas Paine accepted blame for causing the war B: Thomas Paine believed that colonist should remain loyal to the king C : Thomas Paine used

  3. Math

    Tracy Company, a manufacturer of air conditioners, sold 100 units to Thomas Company on November 26. The units have a list price of $500 each, but Thomas was given a 30% trade discount. The terms of the sale were 2/10, n/30. Thomas

  4. Statistics

    A life insurance company sells a term insurance policy to a 21-year-old male that pays $100,000 if the insured dies within the next 5 years. The probability that a randomly chosen male will die each year can be found in mortality

  1. MATH

    Carol Byrd gets a student rate of $30.00 a month for health insurance. There is a $250 deductible. She recently received treatment for a covered condition. The bill was $2,300.00. Carol's insurance company provided payment of 80%

  2. Statistics

    A new manager, hired at a large warehouse, was told to reduce the 26% employee sick leave. The manager introduced a new incentive program for the company's employees with perfect attendance. The manager decides to test the new

  3. Career

    Ben’s job responsibilities include ordering in supplies, tracking inventory, managing waitstaff, and greeting guests. What does Ben do? A) warehouse manager B)restaurant manager C)hotel manager D)shipping company manager Is it

  4. accounting

    Can anyone help me with this? At Idaho Company checks are not prenumbered because both the purchasing agent and the treasurer are authorized to issue checks. Each signer has access to unissued checks kept in an unlocked file

You can view more similar questions or ask a new question.