Preview

SCM 366 HW1

Satisfactory Essays
Open Document
Open Document
517 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
SCM 366 HW1
SCM 366
Supply Chain Modeling
Spring, 2015

Assignment 1
Inventory Management with Steady Demand

Your friend needs to purchase malt for his micro-brewery. His supplier charges $35 per delivery, for each delivery, regardless of the size of the order. The product cost your friend $1.20 per gallon. The annual holding cost per unit is assumed to be 35% of the item’s cost of $1.20. Assume that your friend’s weekly usage of malt is 250 gallons and the brewery is open 52 weeks per year.

a. Suppose your friend orders 2,500 gallons of malt each time an order is made. What is the total annual holding and ordering costs using this order quantity?
b. Suppose each order is for 500 gallons of malt, what is the total annual holding and ordering costs using this order quantity?
c. Use a data table to show how annual holding costs and annual ordering costs change as the order quantity Q changes. Start with a Q equal to 500 and increase Q in 500 unit increments up to 3000 (e.g., 500, 1000, 1500, 2000, 2500, and 3000). Produce a graph that shows the costs (ordering, holding, and total) by order quantity. Be sure to label your graph.
d. What should the order size be if your friend wants to minimize the annual sum of ordering and holding costs?
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?
f. Consider 5 different demand scenarios where the demand rate is as follows: Scenario 1, demand = 0.25 of the original demand; Scenario2, demand = 0.5 of the original demand, Scenario 3, demand = original demand, Scenario 4, demand = 2 times the original demand; and Scenario 5, demand = 4 times the original demand. For each demand scenario find the EOQ and express the Annual EOQ costs as a % of the Annual Purchase Cost. Use the original ordering and holding costs inputs.
g. Suppose your friend’s supplier only accepts orders that are an integer multiple of 1,000 gallons. In other

You May Also Find These Documents Helpful

  • Satisfactory Essays

    3. What is the opportunity cost of increasing the annual output of corn from 800 to 1000 pounds?…

    • 428 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Operation Managment

    • 293 Words
    • 2 Pages

    the investment in the inventory will be 68% of $12.99 that is $8.83. The cost of carrying this will be 21 percent that is $1,85. If we multiply this by 204 units found above we get a yearly cost of $337.4. Now if the ordering is done once every two weeks then the ordering cost will be 26 X $20 = $520. if this is added to the above cost we get a total of $857.4.…

    • 293 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    solutions to homework-1

    • 1845 Words
    • 16 Pages

    (c) The problem could be where to store all the items. If we were to order 1.24 years worth of…

    • 1845 Words
    • 16 Pages
    Powerful Essays
  • Satisfactory Essays

    Expected annual usage of a particular raw material is 1,200,000 units, and standard order size is 10,000 units. The invoice cost of each unit is $145, and the cost to place one purchase order is $105. The estimated annual order cost is:…

    • 5088 Words
    • 43 Pages
    Satisfactory Essays
  • Better Essays

    b. [4] Estimate how many units “x” of the product must be sold in order…

    • 2663 Words
    • 30 Pages
    Better Essays
  • Satisfactory Essays

    Q6. Using the information in Exhibit 4, calculate the cost of the five orders (A - E) under the “new” costing system.…

    • 1088 Words
    • 7 Pages
    Satisfactory Essays
  • Good Essays

    Textbook Answer

    • 1350 Words
    • 6 Pages

    [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…

    • 1350 Words
    • 6 Pages
    Good Essays
  • Satisfactory Essays

    Toys Plus Inc

    • 1122 Words
    • 5 Pages

    1. Calculate economic order quantities for each of the three types of toys. MASTER SCHEDULE FORECAST INPUT SEP26 OCT3 OCT10 OCT17 OCT24 OCT31 ----- ----- ----- ----- ----- ----- TOY AUTO 1100 1150 1200 1300 1400 1500 TOY TRUCK 500 450 400 350 300 300 TOY ROBOT 700 650 650 625 625 600 ------ ------ ------ ------ ------ ------ TOTAL UNITS 2300 2250 2250 2275 2325 2400 AVERAGE WEEKLY DEMAND (CALCULATED) TOY AUTO 1275 TOY TRUCK 383 TOY ROBOT 642 MASTER SCHEDULE EOQ CALCULATIONS AUTO TRUCK ROBOT WEEKLY DEMAND RATE 1275 383 642 PRODUCTION RATE PER WEEK 3500 1750 2333 UNIT COST 3.2 6.5 4.1 SETUP COST 293 CARRYING COST(% Per Year) 25% ECONOMIC ORDER QUANTITY 8740 3034 5130 BEGINNING INVENTORY LEVEL INPUT 4000 2000 1500…

    • 1122 Words
    • 5 Pages
    Satisfactory Essays
  • Satisfactory Essays

    EOQ

    • 378 Words
    • 2 Pages

    Pam runs a mail-order business for gym equipment. Annual demand for the TricoFlexers is 16,000. The annual holding cost per unit is $2.50 and the cost to place an order is $50. What is the economic order quantity?…

    • 378 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Scientific glass

    • 626 Words
    • 3 Pages

    Transportation Cost for 8 Warehouses Erlenmeyer Total Demand Un fulfilled Fill Rate Bulk Shipment Rate Unit weight 19.56 0.01 0.4 0.25 Griffin Formula Exhibit 3.Average Bi-Weekly Demand for 8 warehouse*1.2 65.04 =54.2*1.2 0.01 0.4 Comments 2009 Demand increases by 20% in 2010 From Exhibit 5 Unit Weight = Pounds per case/ Units per case 0.125 When Stock out occurs, the inter-warehouse transportation costs Total Bi-weekly cost Total Bi-weekly cost for 8 warehouses Total Annual Cost(A) 0.01956 0.15648 4.06848 Un fulfilled Fill Rate * Total Demand * Bulk Shipment Rate * Unit Weight 0.03252 0.26016 8*Total Bi-weekly cost 6.76416 26*Total Bi-weekly cost for 8 warehouses From Waltham to warehouses Total inventory to carry Total Bi-weekly cost Total Annual Cost(B) 136.92 13.692 355.992 455.28 Total Demand*7 22.764 Total Invetory to carry * Bulk shipment rate * weight 591.864 26*Total…

    • 626 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    d) What is the corresponding total cost (holding and ordering cost only – do not include material cost)?…

    • 675 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    Lipman Bottle Company

    • 722 Words
    • 3 Pages

    As shown in the Table 1, it is a part of question1. In the textbook, it has illustrated the 10 month income statement, containing variable cost per machine per hour and cost per thousand passes, which are used for the calculations. For the question 1, it requires to compute two order quantity ranges- 5000- 9999 and 100000- 249999, using the median of the order sizes for simplification. Setup time for a job is a factor of variable cost, so in the table, it has setup time, and uses it to get hours per thousand bottles. The formula is demonstrated below the Table 1. The setup time and run time per thousand adding together can get the total time of working per thousand, which means that when the company operates machines, it will spend cost, and should be included in variable. As a result, total time increases variable cost per machine per hour.…

    • 722 Words
    • 3 Pages
    Good Essays
  • Good Essays

    amity asignment

    • 3970 Words
    • 16 Pages

    A company manufactures a single product in its factory utilizing 600% of its capacity. The selling price and cost details are given below:…

    • 3970 Words
    • 16 Pages
    Good Essays