Preview

QAT1 Task 3 309

Good Essays
Open Document
Open Document
611 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
QAT1 Task 3 309
Competency 309.3.1: Decision Making Models
A – A1. Economic Order Quantity Model (EOQ)

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). Equation:

Variables:
Q* = optimal number to order
D = annual demand in units
Co = ordering cost
Ch = holding cost

Process Description:
Q or Q* meaning the optimal order of pieces per order, is equal to the square root of the equation of annual demand (D), multiplied by 2, then multiplied by the ordering cost (Co), which is then divided by the holding cost (Ch). The end result of the equation provides the optimal order of pieces per order or Q*. Company A:

Demand (D) = 670,000 units per year
Ordering Costs (Co) = $320 per order
Per Unit Cost of inventory = $375
Holding cost rate = 5.5%
Holding cost (Ch) = $375 (5.5) = $20.62
*Holding cost is the per unit cost of inventory multiplied by the holding cost rate

Step 1: Input variables into the equation

Step 2: Follow mathematical order of operations: simplify and solve for numerator 2(670000)(320) = 428800000=20795344.3258972
Step 3: Follow mathematical order of operations: Divide numerator by denominator 428800000/20.62
Step 4: Square roots your quotient and get your final result of the equation = 4560
Step 5: Round up to the nearest Unit to get you final answer. In order to minimize total cost, the order size should be 4560 when company A orders new inventory.

B – B1. Economic Production Lot Model

The Economic Production Lot Model is a variation of the EOQ model that allows businesses to determine optimal replenishment lot size. This model provides the most optimized approach this form of ordering as it considers, demand, available production, ordering cost, set

You May Also Find These Documents Helpful

  • Satisfactory Essays

    SCM 366 001 HW 1 and HW 2

    • 346 Words
    • 9 Pages

    Ordering Cost Sensitivity $ 500 $ 1000 $ 1500 $ 2000 $ 2500 $ 3000 $ $ 182.00 910.00 455.00 303.33 227.50 182.00 151.67 Holding Cost Sensitivity $ 525.00 500 $ 105.00 1000 $ 210.00 1500 $ 315.00 2000 $ 420.00 2500 $ 525.00 3000 $ 630.00 1,472 Annual Cost of Holding and Ordering = (13,000*x/500) + (500*$0.42/2) $900 = (13,000*x/500) + (500*$0.42/2) $900 = (26 *x) + $105 $900 - $105 = (26 *x) $795 = 26 * x x = $795 / 26 = 30.58 f. Scenario Demand Ratio Scenario 1 Scenario 2 Scenario 3 Scenario 4 Scenario 5 g. 0.25 0.5 1 2 4 Order Quantity 1000 2000 3000 4000 5000 Annual Ordering Costs $ 455 $ 228 $ 152 $ 114 $ 91 Annual Deamd EOQ 3,250 6,500 13,000 26,000 52,000 Annual Holding Costs $ 210.00 $ 420.00 $ 630.00 $ 840.00 $ 1,050.00 735.98 1040.83 1471.96 2081.67 2943.92 Total $ $ $ $ $ 665 648 782 954 1,141…

    • 346 Words
    • 9 Pages
    Satisfactory 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
  • Good Essays

    The EOQ model assumes goods are not subject to discounts for bulk ordering and where the specific demand and lead time are known for a particular product. Timing of orders is critical to ensuring no stock outs happen, even during unplanned events and seasonal changes (Heizer & Render, 2014). If a customer finds that a store such as Safeway never runs out of what he or she is looking for, a lifelong relationship could generate.…

    • 727 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    3. The Economic Order Quantity model is extremely useful while making decisions on order quantities in MRP systems.…

    • 4131 Words
    • 19 Pages
    Powerful Essays
  • Satisfactory Essays

    Ise 513 Homework2

    • 549 Words
    • 3 Pages

    d. Assuming that we get replenishment of 8000 pounds of flour on Monday and Tuesday respectively, the bakery will consume the first 8000 pounds from Monday till Thursday, and next 8000 pounds from Friday. However, the flour would be expired after 7 days, in this case on next Tuesday; while we only consume 4000 pounds before next Tuesday. Therefore, the maximum economic lot size under this scenario would be 8000+4000=12000 pounds.…

    • 549 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Sap Lot Sizing

    • 318 Words
    • 2 Pages

    Optimizing method • A or B item • Demand-driven OR MTO • Consumption-based OR demand planning with forecast for BOM top-level and X,Y item • Inventory holding cost and order cost known • No planning in fixed order-/delivery-intervals OR this is not focus of the lot-size planning • If limited stockroom: no Y/L parts Else: Periodic method • Demand-driven OR MTO • Consumption-based or demand planning with forecast for BOM top-level and X, Y item • AND/OR A-item (including A/Z-items) • AND/OR: Planning in fixed order-/delivery-intervals (including Z-items) Else: Static method • 'Replenishment to maximum level' (high order costs, negligible holding cost, limited stockroom and/or technical requirement, e.g. silo, tank) • Remaining materials: 'EX'(exact lot size); in particular for B/Z and C/Z items, when consumption-based or BOM top-level and forecast is conducted…

    • 318 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    In this case study, I use POQ to calculate Optimal Quantities to Order because some the parts are made by company's plastic-molding machines in an assembly operations and units can be assumed that are received incrementally during production. We also have the following assumptions:…

    • 1681 Words
    • 7 Pages
    Powerful Essays
  • Better Essays

    The Eoq Inventory Formula

    • 2324 Words
    • 10 Pages

    The order quantity. This is the variable we want to optimize. All the other variables…

    • 2324 Words
    • 10 Pages
    Better Essays
  • Satisfactory Essays

    Inventory Management

    • 270 Words
    • 2 Pages

    This problem entails knowing Inventory Control Subject to known demand. Based out of the book Production and Operations Analysis-5th edition ISBN 0072865385 which is almost Identical to 4th ed.…

    • 270 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Test Inventory Management

    • 489 Words
    • 2 Pages

    6. What is the relationship of the economic order quantity to demand? To the holding cost? To the set-up costs?…

    • 489 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Economic Order Quantity

    • 2031 Words
    • 9 Pages

    Inventory management is big issue today, it gives one company competitive edge over other companies. The word inventory refers to any kind of resource having economic value and is maintained to fulfill the present and future needs of an organization. Fred hansman defined inventory as an idle resource of any kind provided such a resource has economic value. Inventory of resources is held to provide desirable service to customers and to achieve sales turnover target. Investment in large inventories adversely affects firm’s cash flow and working capital as investment in inventory represents substantial portion of total capital investment in any business. It is in therefore essential to balance the advantage of having inventory of resources and the cost of maintain it so as to determine an optimal level of inventory of each resource so that total inventory cost is minimum. Holding of stock is expensive so controls are needed to ensure that stock level remains as low as possible. Stocks should be controlled using rational policies to balance between holding cost and demand. One such policy is ordering ECONOMIC ORDER QUQNTITY for stock replenishment at this point holding cost reduces significantly and total annual inventory cost is lowest. Though maintaining exact EOQ is sometime not possible working in the vicinity of it results in lower total annual inventory cost. Holding cost is straight line that is it directly varies with ordering quantity…

    • 2031 Words
    • 9 Pages
    Good Essays
  • Powerful Essays

    1. Introduction With the fast expansion of activities in Business and Industrial sectors, many inventory systems are increasingly found to operate with more than single commodity. These systems unlike those dealing with single commodity, involve more complexities in the reordering procedures. In the modelling of such systems, initially models were proposed with independently established reorder points. But in situations where several products compete for common storage space or share the same transport facility or are procured from the same source, the above method overlooks potential savings associated with joint ordering and hence may not be optimal.…

    • 3488 Words
    • 14 Pages
    Powerful Essays
  • Good Essays

    * Inventory management. Identify the level of inventory which allows for uninterrupted production but reduces the investment in raw materials - and minimizes reordering costs - and hence increases cash flow; see Supply chain management; Just In Time (JIT); Economic order quantity (EOQ); Economic production quantity (EPQ).…

    • 6498 Words
    • 26 Pages
    Good Essays
  • Better Essays

    Working Capital

    • 809 Words
    • 4 Pages

    Q.1. Spring Enterprises require 30,000 units of input annually to sustain its production at the current level. The carrying cost is Rs 32 per unit while the ordering cost is Rs 5000 per order. The cost per unit of input is also Rs 32. Determine the EOQ for Spring Enterprises. What would be the firm’s policy of inventory acquisition if the firm’s suppliers offer quantity discount as follows:…

    • 809 Words
    • 4 Pages
    Better Essays
  • Satisfactory Essays

    Management

    • 418 Words
    • 2 Pages

    Inventory modelling helps control inventories by mathematically establishing how and when to order a product.…

    • 418 Words
    • 2 Pages
    Satisfactory Essays