Preview

Tsg Hobby Shop Case Study

Satisfactory Essays
Open Document
Open Document
488 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Tsg Hobby Shop Case Study
Sample Inventory Problems
The TSG Hobby Shop carries a line of radio-controlled model racing cars. Demand for the cars is assumed to be constant at a rate of 40 cars per month. The cars cost $60 each, and ordering costs are approximately $15 per order, regardless of the order size. The annual holding cost rate is 20%.

1. What is the Economic Order Quantity and the total annual cost under the assumption that no backorders are permitted?

A monthly demand of 40 cars translates to an annual demand, D, of 480 cars. Given a purchase cost, c, of $60 per car, an ordering cost, co, of $15 per order, and an annual unit holding cost rate, h, of 20%, we can compute the Economic Order Quantity, Q :
*

⎡ 2c D ⎤ Q = ⎢ o ⎥ ⎣ hc ⎦
*

12
…show more content…
≈ 35 cars

This allows us, then, to compute for the Annual Ordering Cost, OC(Q ):

*

⎡ D ⎤ ⎡ 480 ⎤ OC Q = co ⎢ * ⎥ = (15 )⎢ ⎣ 34.64... ⎥ ⎦ ⎣ Q ⎦

( )
*

12

≈ $207.85

and the Annual Holding Cost, HC(Q ):

*

⎡ Q * ⎤ ⎡ 34.64... ⎤ HC Q * = ch ⎢ ⎥ = (0.20 )(60 )⎢ ≈ $207.85 ⎣ 2 ⎥ ⎦ ⎣ 2 ⎦

( )

Consequently, we can compute for the Annual Total Cost at the Economic Order Quantity, TC(Q ):

*

TC Q * = OC Q * + HC Q * = $207.85 + $207.85 ≈ $415.69

( )

( )

( )

Sample Inventory Problems
2. What will happen to the Economic Order Quantity if the ordering cost increases to $20 per order?

If the ordering cost increases from $15 per order to $20 per order, the Economic Order Quantity increases from 35 cars to 40 cars, which is computed as follows:

⎡ 2c D ⎤ Q = ⎢ o ⎥ ⎣ hc ⎦

You May Also Find These Documents Helpful

  • Better Essays

    4541 Answer Key Midterm W13

    • 2194 Words
    • 10 Pages

    Total cost = (F * T/Q) + (H * Q / 2) = (80 * 200,000 / 10,000) + (1.00 * 10,000/2)…

    • 2194 Words
    • 10 Pages
    Better Essays
  • 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
  • Satisfactory Essays

    ECO 550 Midterm Exam

    • 620 Words
    • 3 Pages

    6. If TC = 321 + 55Q - 5Q2, then average total cost at Q = 10 is:…

    • 620 Words
    • 3 Pages
    Satisfactory 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
  • Good Essays

    Demand: Qd = 157 – 35P + 12.5Pw + 0.1Y = 157 – 35P + 12.5(6) + 0.1(1600) = 157 – 35P + 75 + 160 = 392 – 35P.…

    • 767 Words
    • 4 Pages
    Good Essays
  • Good Essays

    C(Q) = wL(Q) + rK = wL(Q) + 4rL(Q) = (w+4r)L(Q) = (90+720)Q2/3 = 270Q2…

    • 3075 Words
    • 11 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
  • Satisfactory Essays

    supply cahin

    • 315 Words
    • 2 Pages

    No, the optimal order quantity is different to each other, in case of #1 the optimal order quantity should be in the range of 1-999 whereas with respect to #3, the optimal order quantity falls in the range of 2000-2999 where is attains the lowest incremental cost.…

    • 315 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Group Collaboration Draft

    • 804 Words
    • 3 Pages

    Q4. What is the economic order quantity (use unit price only, do not include transportation costs) if we purchase everything from CousinsAg? From Dong Hai Supply?…

    • 804 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Moonchem Case

    • 894 Words
    • 4 Pages

    SD hCQ + Q 2 $400(12, 000) (25%)($1)40, 000 TCSmall = + = $5,120 40, 000 2 $400(60, 000) (25%)($1)40, 000 TCMedium = + = $5, 600 40, 000 2 $400(144, 000) (25%)($1)40, 000 TCLarge = + = $6, 440 40, 000 2 TC =…

    • 894 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    So given this minimum order of quantity, we would be able to calculate the total cost under each scenario. If producing in Hong Kong, then we can order 40*600=24000 units optimally. On the other hand, if producing in China, we can order 20*1200=24000 units optimally. Therefore from this point of views, the minimum order of quantity has a lesser impact on total cost. In addition, producing in China has greater…

    • 366 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Midwest Office Products

    • 783 Words
    • 4 Pages

    The cost and profitability of the five orders, using the cost driver information and its existing costing system:…

    • 783 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    4) Refer to the information above. What is the total cost of ordering and carrying sugar?…

    • 1687 Words
    • 12 Pages
    Satisfactory Essays