Preview

Inventory and Annual Holding Cost

Satisfactory Essays
Open Document
Open Document
275 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Inventory and Annual Holding Cost
Your firm uses a continuous review system and operates 52 weeks per year. One of the SKUs has the following characteristics.
Demand (D) = 20,000 units/year
Ordering cost (S) = $40/order
Holding cost (H) = $2/unit/year
Lead time (L) = 2weeks
Cycle-service level = 95%
Demand is normally distributed with a standard deviation of weekly demand of 100 units. Current on-hand inventory is 1.040 units with no scheduled receipts and no backorders.
1. Calculate the item’s EOQ. What is the average time, in weeks between orders?
EOQ = (2DS)/H
EOQ = (2*20000*40)/2
EOQ = 800000
EOQ = 894.43894
TBO = (EOQ/D)*52weeks
TBO = (894/20000)*52weeks
TBO = (0.0447)*52weeks
TBO = 2.32442.32weeks
2. Find the safety stock and reorder point that provide a 95% cycle-service level.
Safety stock = Z*(standard deviation of demand during lead time)
Z for 95% service level is 1.64
Safety stock = 1.64*(2*100)
Safety stock = 328 units
Reorder point = (Average demand during lead time) + (Safety Stock)
Reorder point = ((20000/52weeks)*2) + 328 = 1097.23 1097
3. For these policies, what are the annual costs of holding the cycle inventory and placing orders?
Annual holding cost = (Average cycle inventory)*(Unit holding cost)
Annual holding cost = (Average Lot size/2)*(Unit holding cost)
Annual holding cost = ((20000/52weeks)*2.32weeks)/2 * 2
Annual holding cost = (892.30 892/2)*2
Annual holding cost = 446*2 = $892
Annual ordering cost = (Number of orders/year)*(Ordering cost)
Annual ordering cost = (Demand/Average lot size)*(Ordering cost)
Annual ordering costs = (20000/892)*(40)
Annual ordering costs = 22.42*40 = $896.8
4. A withdrawal of 15 units just occurred. Is it time to reorder? If so, how much should be ordered?
Inventory position = on hand inventory + schedule receipts – backorders
Inventory position = 1040+15+0=1055
IP (1055) < R (1097) so new order must be placed
Order quantity: Target inventory level – Inventory position
Target inventory level =

You May Also Find These Documents Helpful

  • Good Essays

    RSM222 Midterm

    • 1583 Words
    • 9 Pages

    3. Using the variable costing method, which of the following costs are assigned to inventory?…

    • 1583 Words
    • 9 Pages
    Good Essays
  • Satisfactory Essays

    Acct 505 Project A

    • 281 Words
    • 2 Pages

    Total cash collections ... $436,000 $695,000 $865,000 $1,996,000 c. Merchandise purchases budget: Budgeted unit sales ..... 65,000 Add desired ending inventory (40% of the next month’s unit sales)................. 40,000 Total needs.................. 105,000 Less beginning inventory .................. 26,000 Required purchases...... 79,000 Cost of purchases at $4 per unit ................ $316,000 100,000 50,000 215,000 20,000 120,000 12,000 62,000 12,000 227,000 40,000 80,000 20,000 42,000 26,000 201,000 $320,000 $168,000 $ 804,000 d. Budgeted cash disbursements for merchandise purchases: Accounts payable .......... $100,000 April purchases ............. 158,000 May purchases .............. June purchases .............…

    • 281 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    review 2320

    • 1612 Words
    • 7 Pages

    Cycle inventory—Q/2 Safety Stock inventory—SS*D Pipeline Inventory—L*D Cost of…

    • 1612 Words
    • 7 Pages
    Satisfactory Essays
  • Satisfactory Essays

    SCM 366 HW1

    • 517 Words
    • 1 Page

    e. What would the cost per order (the ordering cost) need to be in order for a 500 gallon order to have annual holding and ordering costs of $900.00?…

    • 517 Words
    • 1 Page
    Satisfactory Essays
  • Good Essays

    The difference is due to the effect of Sheen’s effort on the demand. This relation is not surprising. Players in the different stages of a supply chain can increase demand for their product through efforts in advertisement, product development etc.…

    • 956 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    A physical count of merchandise inventory on July 30 reveals that there are 32 units on hand. Using the FIFO inventory method, the amount allocated to…

    • 1273 Words
    • 9 Pages
    Powerful Essays
  • Better Essays

    Little field

    • 1749 Words
    • 7 Pages

    As this is a short life-cycle product, managers expect that demand during the 268 day period will grow as customers discover the product, eventually level out, and then decline. In the initial months, demand is expected to grow at a roughly linear rate. Demand is then expected to stabilize. Eventually, demand should begin to decline at a roughly linear rate. Although orders arrive randomly to LT, management expects that, on average, demand will follow the trends outlined above.…

    • 1749 Words
    • 7 Pages
    Better Essays
  • Satisfactory Essays

    BBUS 3121 ASSINGMENT 5

    • 554 Words
    • 4 Pages

    Both policies are viable. Policy one is the best choice if a choice must be made.…

    • 554 Words
    • 4 Pages
    Satisfactory Essays
  • Better Essays

    Ba 555 Practice Midterm

    • 1465 Words
    • 6 Pages

    4. The weekly demand for General Motors car sales follows a normal distribution with a mean of 40,000 cars and a standard deviation of 12,000 cars.…

    • 1465 Words
    • 6 Pages
    Better Essays
  • Better Essays

    Supply Chain Task 1

    • 2621 Words
    • 8 Pages

    In Quarter 3 I increased my projected demand to a total of 2,000 units. I projected 1,250 units for the Mercedes group and 750…

    • 2621 Words
    • 8 Pages
    Better Essays
  • Satisfactory Essays

    5) Refer to the information above. What is the optimal number of orders per year?…

    • 1687 Words
    • 12 Pages
    Satisfactory Essays
  • Satisfactory Essays

    1. What are good estimates of order cost and inventory holding cost? ( State all…

    • 436 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Group Collaboration Draft

    • 804 Words
    • 3 Pages

    Dong Hai Supply safety stock = 59 units/day x 43 days lead time = 2,537 units…

    • 804 Words
    • 3 Pages
    Good Essays
  • Good Essays

    The number of units to stock was generally not equal to the forecast demand, but it was determined using historical forecast errors. To determine the stock of each item, first, they calculated the historical forecast errors for each item in the previous year and the frequency distribution of those errors. Then, this frequency was used as probability distribution for the future forecast errors. The next step was to balance the individual items' contribution margin if this item was demanded against the…

    • 422 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Parts Emporium

    • 333 Words
    • 2 Pages

    2. Using the current inventory management system, Parts Emporium is using a lot of 150 gaskets, being ordered 35.36 times per year to meet their demand of 5304 gaskets. This equates to an annual ordering cost of $707.20. The average cycle inventory would increase from 37.5 to 169 gaskets. Currently, there are 11 backordered gaskets after 21 weeks, which equates to an average of 27.24 gaskets backordered per year. The lost margin on 27.24 gaskets is (27.24)(12.99)(32%)= $113.23. The annual holding cost is currently $66.04. The total inventory cost with the current system is $886.47, which is $260.22 more that the system outlined above.…

    • 333 Words
    • 2 Pages
    Satisfactory Essays

Related Topics