Preview

EM4031 Week 6 Homework Panita A

Satisfactory Essays
Open Document
Open Document
177 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
EM4031 Week 6 Homework Panita A
QUESTION:
A retail chain has eight stores in a region supplied from four supply sources. Trucks have a capacity of 40,000 units and cost £1,000 per load plus, £100 per delivery. Thus. A truck making two deliveries charges £1200. The cost of holding one unit in inventory at retail for a year is £0.20. The vice president of supply chain is considering whether to use direct shipping from suppliers to retail stores or setting up milk runs from suppliers to retail stores. What network do you recommend if annual sales for each product at each retail store are 960.000 units? What network do you recommend if sales for each product at each retail store are 120.000 units? In your analysis assume that all trucks travel full.

ANSWER:
I recommend direct shipping for both cases. The calculation details are shown below;

1. Annual sale = 960.000 units/store

Direct Shipping 960,000 units*8 stores = 7,680,000 units 7,680,000 units/40,000 loaded units = 192 deliveries 192 deliveries*£1,100 = £211,200 = delivery cost

Milk Run 192 deliveries*£1,200 = 230,400/year = delivery cost

2. Annual sale = 120.000 unit/store

Direct Shipping 120,000 units*8 stores = 960,000 units 960,000 units/40,000 loaded units = 24 deliveries 24 deliveries*£1,100 = £26,400 = delivery cost

Milk Run 24 deliveries*£1,200 = £28,800/year = delivery cost

You May Also Find These Documents Helpful

  • 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

    Question 4 Carlson Manufacturing is a producer of plastic bottles for bottled water companies. In July of this year, the plant manager switched to a new supplier of raw materials. The materials have a lower cost, and because of their…

    • 3022 Words
    • 13 Pages
    Good Essays
  • Good Essays

    Case 36

    • 637 Words
    • 3 Pages

    There is a total capacity (rail carloads) of 14 that is available to serve a total demand (rail carloads sold) of 15. With this mentioned, there is an unbalanced capacity and demand. To solve for the proper shipping route, we will have to include a dummy variable equal to 1, which is the difference between capacity and demand. This means one customer will receive a shortage of 1 rail car of grain. In addition, we need to meet certain requirements (constrains) that limit the capacity from origin (outbound) as well as (inbound) constraints at destinations. Not to mention, we also have two processing centers (hubs) constraints.…

    • 637 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    ramneek

    • 387 Words
    • 3 Pages

    there are 80 units in a box and there are 24 boxes on one pallet…

    • 387 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Dakota Office Products Background • Regional distributor of office supplies to institutions sand commercial businesses • Comprehensive product line • Excellent reputation • Several distribution centers Process • Old: • After customer orders received, orders were accumulated within the warehouses and prepared for shipment • Used commercial truckers to deliver • New Option: • “Desk Top Deliveries” • Delivered products directly to locations • Small fleet of trucks • 2% upcharge on products…

    • 596 Words
    • 6 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Littlefield Labs Report

    • 548 Words
    • 3 Pages

    2. In order to provide a throughput of 12 orders per day, 3 machines are needed because 3 machines/5.3 hours = .57 orders per…

    • 548 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Dakota Office Products

    • 532 Words
    • 3 Pages

    Profit margins varied based upon the size of the order, larger orders were more profitable than small orders. Based upon customer order size, prices should have been varied and the cost determination of the DOP should have been evaluated as it generated a loss.…

    • 532 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Case Study

    • 308 Words
    • 2 Pages

    1. One of Specialty’s managers felt that the profit potential was so great that the order quantity should have a 70% chance of meeting demand and only a 30% chance of any stock-outs. What quantity would be ordered under this policy, and what is the projected profit under the three sales scenarios?…

    • 308 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Chapter 6 Continuous Probability Distributions Case Problem: Specialty Toys 1. Information provided by the forecaster At x = 30,000, [pic] [pic] Normal distribution [pic] [pic] 2. @ 15,000 [pic] P(stockout) = 1 - .1635…

    • 590 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    2. What are the pros and cons of a wholesaler versus a company wide distribution system?…

    • 87 Words
    • 1 Page
    Satisfactory Essays
  • Good Essays

    Hamptonshire Express

    • 1081 Words
    • 5 Pages

    3) a. Armentrout’s optimal stocking quantity is equal to 516 newspapers. This creates of channel profit of $322 and makes Anna’s profit equal to $260.20. This stocking quantity maximizes Armentrout’s profit in this situation at $62.14. b. The optimal stocking quantity differs from that of Problem 2 because with the addition of Ralph to the channel, there is now an extra step in the supply chain and Ralph’s revenue to cost ratio differs from Anna’s in Problem 2. Because of this, it is to Ralph’s benefit to stock less newspapers in order to maximize his own profits. Anna has no control over the stocking quantity and will likely never maximize her profits. c. The new optimal…

    • 1081 Words
    • 5 Pages
    Good Essays
  • Good Essays

    ids cheat sheet

    • 988 Words
    • 3 Pages

    This is an example of: Economies of scale. Organizations have: internal and external supply chains. The center of gravity method for location choice is often used to minimize: shipping costs. Which of the following are common reasons a firm might expand into new countries?: To operate under less restrictive regulations and to improve access to foreign markets. . Compared to service operations, manufacturing operations tend to have more and to be less: standardized output; labor-Intensive. Regarding the transportation model, which of the following statements is true? Each unit shipped on the same route has the same shipping cost. Strategy formulation typically includes: Assessing core competencies and Environmental scanning Factory managers have built a small version of a building as a training aid for fire drill procedures this is an example of a model: Physical. Given the following information, what would utilization be? Design capacity = 1000 units per day Effective capacity = 800 units per day Actual output = 600 units per day: (UTILIZATION = ACTUAL OUTPUT/DESIGN CAPACITY): 600/1000 =60%. Compared to manufacturing operations, an important difference in capacity planning for service operations is that: service operations must often be located near customers and Services cannot be stored. Given the following information, what would efficiency be? Design capacity = 800 units per day Effective capacity = 600 units per day Actual output = 400 units per day: (EFFICIENCY = ACTUAL OUPUT/EFFECTIVE CAPACITY): 400/600=67%. In regard to hierarchical planning, tactics are best described as: the methods and actions taken to accomplish strategies. Productivity is expressed as: output divided by input. Gourmet Pretzels bakes soft pretzels on an assembly line. It currently bakes 4000 pretzels in each 12-hour shift. If the production is increased to 5000 pretzels each…

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

    Supply Chain Management

    • 7320 Words
    • 30 Pages

    A. Analyze whether a Keiretsu network, a virtual company, a vertical integration, or a different supply chain strategy should be adopted.…

    • 7320 Words
    • 30 Pages
    Good Essays
  • Satisfactory Essays

    A bakery buys sugar in 15-pound bags. The bakery uses 5000 bags of sugar each year. Carrying costs are $20 per bag per year. Ordering costs are estimated at $5 per order. Assume that the bakery is open 250 days a year and its daily demand is estimated at 20 bags. It takes 5 days for each order of sugar to be filled.…

    • 1687 Words
    • 12 Pages
    Satisfactory Essays