Preview

Economic Order Quantity: Practice Exercise

Good Essays
Open Document
Open Document
310 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Economic Order Quantity: Practice Exercise
Economic Order Quantity - PRACTICE EXERCISE SCM 300

Below are some the key figures important in your analysis:

Annual Per Unit Holding Costs are estimated at 30% of the wholesale cost. D = 13000
H = $60.00
C = $200.00
S = $400.00

Using Present Lot Size (Q = 1100)
Calculate the time between orders? Do Not Round.
4.40 weeks

How many orders per year are being placed annually? Do Not Round.
11.8 Orders per year

According to the information supplied, what is the present annual inventory cost? (In other words, using their present lot size what is the annual inventory cost?) Also, separately identify, the annual cost of purchasing the inventory, the annual holding cost (AHC) and annual ordering cost (AOC).

DC = $ 2,600,000
AOC = $ 4,727.27
AHC = $ 33,000
TC = $ 2,637,727.27

Using the Economic Order Quantity (Q=EOQ)
Calculate EOQ. (USE A WHOLE NUMBER, NO DECIMALS)
EOQ = 416

Using the calculated EOQ, How often will orders be placed? Weeks.
DO NOT ROUND (Show 2 decimal places)

1.67 Weeks

According to the information supplied, what would be the annual inventory cost if they used the calculated EOQ? Also, separately identify the annual holding cost (AHC) and annual ordering cost (AOC).
AHC = $ 12,490
AOC = $ 12,490
TC = $ 2,624,980

If they could order the EOQ instead of 1100, how much would this one store stand to save annually?

$12,747.28

Orders can only be taken in increments of 250 units. What would be the appropriate order size?
A. 250 units
B. 500 units
C. 750 units
D. 1000 units
Answer not provided.
According to the appropriate order size recommendation, what would be the Total Annual Inventory cost? Also, separately identify, the annual cost of purchasing the inventory, the annual holding cost (AHC) and annual ordering cost (AOC).

DC = $ 2,600,000
AHC = $ 15,000
AOC = $

You May Also Find These Documents Helpful

  • Good Essays

    What is the amount of the inventory at the end of the year using the average cost method?…

    • 2103 Words
    • 14 Pages
    Good Essays
  • Satisfactory Essays

    SCM 366 001 HW 1 and HW 2

    • 346 Words
    • 9 Pages

    Delivery Charges Production Cost Annual Holding Cost per Unit S C h $ $ Weekly Usage (gallons) Annual Demand Order Quantity D $ $ Annual Holding Cost per Unit per year Number of Orders Per Year Average Inventory Annual Ordering Cost Annual Holding Cost EOQ Q H = h*C D/Q Q/2…

    • 346 Words
    • 9 Pages
    Satisfactory Essays
  • Good Essays

    QAT 3

    • 553 Words
    • 3 Pages

    The Economic Order Quantity Model will allow an organization to determine the optimal volume of inventory to order at a given time. The EOQ model provides the most optimized approach to inventory ordering as it considers, demand, ordering cost, and holding costs; to develop the volume of inventory to be ordered to maintain to minimum annual cost (Render, 2012).…

    • 553 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Qat 4

    • 373 Words
    • 1 Page

    To find the order size for Company A you need to use the economic order quantity model. This will give the smallest total cost to the company. First you need to find the holding cost. To find the holding cost you multiply the annual holding cost rate by the unit cost of the item (Ch=IC). In this example the annual holding cost rate is 3% and the unit cost is $500 (Ch=3%X$500 or Ch=$15). Now that you have the holding cost you can find the optimal order size. To find the optimal order size you take the square root of 2 times the demand times the ordering cost divided by the holding cost. Q*= the square root of 2(D)(Co)/Ch or Q*= the square root of 2(400,000)(42)/15. When you complete this equation you get 1,496.66. Because you can not create a partial laptop you need to round up. Thus giving you 1,497 laptops as the optimal ordering size.…

    • 373 Words
    • 1 Page
    Satisfactory 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
  • Good Essays

    Loblaw Chapter 8

    • 4097 Words
    • 17 Pages

    8.1 Estimate the amount of inventories that your company purchased and produced during the current year. (Hint: use the cost of sales equation.)…

    • 4097 Words
    • 17 Pages
    Good Essays
  • Good Essays

    Narragansett Yacht Company

    • 1780 Words
    • 8 Pages

    b. What is the reorder point (in units) for each supplier? Assume for now that no safety stocks are held and use a 360-day year.…

    • 1780 Words
    • 8 Pages
    Good Essays
  • Satisfactory Essays

    Hca Ratio Analysis

    • 546 Words
    • 3 Pages

    Cost of goods sold—operating revenue: 180,000 divided by ending inventory of 5000; 180,000/5000 = 36…

    • 546 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    * Products arrived at warehouse 2 months prior to selling period. Inventory cost averaged $21.5 million. Space was optimized since it followed a tightly managed schedule.…

    • 1412 Words
    • 6 Pages
    Powerful Essays
  • Good Essays

    Eddie Bauer

    • 2471 Words
    • 10 Pages

    The total inventory for retails and catalog $656M equaled the costs of goods sold ($697M), meaning the stock rotation around 12 months (table2) which is extremely high when compared to A&F with 1.3 months and Gap with 2.4 months…

    • 2471 Words
    • 10 Pages
    Good 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

    Study Guide

    • 679 Words
    • 3 Pages

    14. know the components of cost of merchandise inventory (e.g., invoice price less discount plus what other items are included?);…

    • 679 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Web Search 2

    • 739 Words
    • 3 Pages

    5. If a company has beginning inventory of $30,000 and ending inventory of $55,000, compute its average inventory. If the cost of goods sold is $140,000, compute its inventory turnover and determine how many days the average item is in stock. The average inventory would be 42,500, and average…

    • 739 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Skill Mgt

    • 265 Words
    • 2 Pages

    c. An inventory withdrawal of 10 pairs was just made. Is it time to reorder?…

    • 265 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    2) Refer to the information above. What is the maximum inventory held in a given EOQ cycle?…

    • 1687 Words
    • 12 Pages
    Satisfactory Essays