Preview

Textbook Answer

Good Essays
Open Document
Open Document
1350 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Textbook Answer
Supply Chain Management

Inventory Review

Question
[1] Toys R'Fun is planning a new line of cuddly toys called “furby.” The plush furby toy will be priced at $27. Toys R'Fun purchases the fur by for $18. The annual demand is estimated to be 36,400 furbys (or 700 per week). The opportunity cost of capital for Toy R'Fun is 25% per annum. Other relevant holding costs (taxes, insurance, theft, obsolescence, etc.) are estimated to be 8% per annum. The cost of capital is 10% per annum. The ordering cost is $40 per order. It is also estimated that the weekly demand will have a normal distribution with a mean of 700 and standard deviation of 100. The lead-time to procure the toys from Hyderabad, India is guaranteed to be exactly 9 weeks if the shipment is by sea with a unit transportation cost of 5 cents. a) Find the economic order quantity (EOQ) and compute the total cost per year including the purchase cost @$18/furby but not inclusive of the transportation cost. b) Determine the safety stock for obtaining 99% service level (i.e., an in-stock probability of 99%). When should Toys R'Fun reorder? c) It has been suggested that Toys R'Fun use air shipment to ship the toys. Shipping by air reduces the transportation lead -time to 1 week but increases the unit transportation cost by 5 cents. Is it worthwhile to use air-shipments? [2] A mail order firm has four regional warehouses. Demand at each warehouse is normally distributed with a mean of 10,000 per week and a standard deviation of 2,000. Annual holding cost for the company is 25% and each unit costs $10. Each order incurs a fixed order cost of $1,000 (primarily from fixed transportation costs) and the lead time of supply is one week. The company wants the probability of stocking out to be no more than 5%. Each warehouse has an information system that allows it monitor inventory continuously. Assume that 50 weeks in a year. (a) Assuming that each warehouse operates independently what should be the order policy at

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
  • Better Essays

    Waltham Motors Case

    • 863 Words
    • 4 Pages

    2. Using budget data, what was the total expected cost per unit if all manufacturing and…

    • 863 Words
    • 4 Pages
    Better Essays
  • Satisfactory Essays

    review 2320

    • 1612 Words
    • 7 Pages

    A. Office Supplies—Large inventories B. Flu shots—Large inventories ABC Analysis Less inventory for A (most expensive items), Large inventories for C (lowest cost items) EOQ Holding cost: (Q/2)*h Ordering cost: (D/Q)*S EOQ=intersection point of Holding and Ordering cost Total Cost=(D/Q)*S+(Q/2)*H+ Safety Stock*H+D*S Q=square root of (2DS)/H 2/11/2014-3230 Independent demand Dependent demand Finished Goods inventories—retailers 2/11/2014-3230…

    • 1612 Words
    • 7 Pages
    Satisfactory Essays
  • Good Essays

    Hamptonshire Express Case

    • 632 Words
    • 3 Pages

    b. The optimal stocking quantity differs from problem #2 because Ralph is incurring the cost of overstocking, which changes the critical ratio from .8 in problem #2 to .2. Because of the critical ratio change, Anna’s profit decreases as Ralph’s increases. This is consistent with the Newsvendor Model, which gives Cu=.2, Co=.8, for a critical ratio of .2. Using the formula in the spreadsheet, Q*=NORM.INV(.2,600,100)=515.837, gives the optimal stocking quantity of 516.…

    • 632 Words
    • 3 Pages
    Good Essays
  • Good Essays

    The following information is from the manufacturing budget and the budgeted financial statements of Fabor Fabrication:…

    • 1277 Words
    • 10 Pages
    Good Essays
  • Satisfactory Essays

    Each of the following statements may (or may not) describe one of these technical terms. For each statement, indicate the accounting term described, or answer “None” if the statement does not correctly describe any of the terms.…

    • 1713 Words
    • 9 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
  • Powerful Essays

    Don’t judge on what is not understood; yet take the time to understand. The article titled “Why Does My Child Keep Correcting Me” is about parents who have to deal with the fact that their children may have Aspergers Syndrome. Aspergers is a disorder in which a person regardless of age has the compulsion to always correct someone and they must be right all the time. An idea is presented, if it didn’t not come from them then it is not right. When our little ones do something…

    • 1298 Words
    • 6 Pages
    Powerful Essays
  • Good Essays

    JGT Task 2

    • 1850 Words
    • 6 Pages

    Alistair Wu has requested that I look at what the lowest shipping schedule and cost can be based on data that he has provided. He wants to know what the lowest possible cost of shipping will can be. Mr. Wu is also considering increasing production at the Shanghai factory from 1,300 to 2,800 units, and wants to ensure that this growth will be an affordable choice. The first chart that was given lists the factory capacity and what each warehouse demand is. The second chart lists the price of shipping from each factory to each warehouse. The chart looks at the demand in the warehouses as well as the cost to ship there from each factory. It then generates a cost effective shipping plan to ship products to the warehouse with least shipping expense and fills those warehouses first. It then allocates additional products to other warehouses that have higher shipping prices. This is evident with Shuzworld H and Shuzworld F, the program ships the most products to the lower priced warehouses 1 and 3. Warehouse 1 need 2,500 units but Shuzworld F only produces 2,200 units. That means Warehouse 1 will take all off the units from Shuzworld F and still have a demand of 300 units. Warehouse needs 1,800 units and Shuzworld H produces 2,300 units. This means Warehouse 3 will receive all of its units from Shuzworld H and Shuzworld H will still have an excess of 500 units.…

    • 1850 Words
    • 6 Pages
    Good Essays
  • Satisfactory Essays

    Henry Clements Car rental

    • 453 Words
    • 4 Pages

    From this data, as well as the data given on manufacturing methods and hours per method, a solution could be found utilizing the linear programming method of analysis. To analyze the data, the actual profit on each material was first calculated. This was done by taking the selling price and subtracting each cost associated with the given material. The results are $34.00 for the 75C, $30.00 for the 33C, $60.00 for the 5X, and $25.00 for the 7X. The next step was to determine how many constraints would be part of the analysis. There was determined to be 10 constraints in the analysis, 4 for the April orders, 4 for the manufacturing methods and 2 for the minimum orders promised by Vivian. With this data, the amount of each product to be produced to maximize profit for April could be determined. The results can be seen in Table 3.…

    • 453 Words
    • 4 Pages
    Satisfactory Essays
  • Powerful Essays

    In order to decide how many units of each style Wally should make, we should think about their order’s range, we ignore price differences among styles so we need to think about the maximum order and minimum order for each style. First of all, we need to calculate the stock out probability based on benefit percentage and risk percentage. According to the case, Obermeyer earned 24 percent of wholesale price on each parka it sold, and that units left unsold at the end of the season were sold at a loss that average 8 percent of wholesale price. Therefore, the stock out probability equal to 8%/(24%+8%)=25% so there are 75% probability of being less than mean+0.67*SD (standard deviation). According to z table, z equal to 0.67 when probability is 0.75. Therefore, we can calculate quantity for each style include the risk of stock out by using formulate Q*=mean+z*SD. Therefore, we can get the maximum order units for each style in order to avoid stock out.…

    • 1732 Words
    • 7 Pages
    Powerful Essays
  • Satisfactory Essays

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

    • 1687 Words
    • 12 Pages
    Satisfactory Essays
  • Good Essays

    Ludo Case

    • 567 Words
    • 3 Pages

    2. Michelle finds out that Bobby Peru, a local recycler, is willing to pay a salvage value of €0.05 for each left-over unit of Dado and €0.07 for each left-over unit of Wedo. How would this change the optimal order quantity and the corresponding expected profit?…

    • 567 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Saferty Stock Problems

    • 309 Words
    • 3 Pages

    Litely Corp sells 1,350 of its special decorator light switch per year, and places orders for 300 of these switches at a time. Assuming no safety stocks, Litely estimates a 50% chance of no shortages in each cycle, and the probability of shortages of 5, 10, and 15 units as 0.2, 0.15, and 0.15 respectively. The carrying cost per unit per year is calculated as $5 and the stockout cost is estimated at $6 ($3 lost profit per switch and another $3 lost in goodwill, or future sales loss). What level of safety stock should Litely use for this product? (Consider safety stock of 0, 5, 10, and 15 units)…

    • 309 Words
    • 3 Pages
    Satisfactory Essays