Hamptonshire Express

Better Essays
Arjun R. Sabhaya
Production 529
Hamptonshire Express
October 16, 2012

PROBLEM #1 A. The simulated function given in the Excel spreadsheet “Hamptonshire Express: Problem_#1” allows the user to find the optimal quantity of newspapers to be stocked at the newly formed Hamptonshire Express Daily Newspaper. Anna Sheen estimated the daily demand of newspapers to be on a normal standard distribution; stating that daily demand will have a mean of 500 newspapers per day with a standard deviation of 100 newspapers per day. Using the function provided, the optimal stocking quantity, which maximizes expected profit, is determined to be approximately 584 newspapers. If 584 newspapers were to be ordered, Hamptonshire Express will net an expected profit of $331.436 per day with an expected fill rate of 98%. Any inventory ordered above 584 will produce a loss of profit due to stocking inventory over expected demand causing an imbalance between the gains and losses due to the respective overage and underage costs. The table below outlines the optimal amount of daily expected profit. Profits rise until the 584 newspaper mark; any potential increase in quantity stocked will decrease daily expected profit for every newspaper ordered above 584.

Stocking Quantity | Daily Expected Profit | 575 newspapers | 331.323 | 576 newspapers | 331.347 | 577 newspapers | 331.369 | 578 newspapers | 331.387 | 579 newspapers | 331.403 | 580 newspapers | 331.415 | 581 newspapers | 331.425 | 582 newspapers | 331.431 | 583 newspapers | 331.435 | 584 newspapers | 331.436 | 585 newspapers | 331.435 | 586 newspapers | 331.430 | 587 newspapers | 331.423 | 588 newspapers | 331.413 | 589 newspapers | 331.400 | 590 newspapers | 331.385 |
Calculations: Cr=cu/cu+co where Cr= critical ratio. Cu=1-0.2=.8 Co=0.2
Therefore, Cr= .8/.8+.2=.8 which is equal to .84 (z value) on the standard normal distribution function table.
To find the optimal stocking

You May Also Find These Documents Helpful

  • Good Essays

    Hamptonshire Express

    • 1081 Words
    • 5 Pages

    1) a. Sheen should stock the optimal stocking quantity in this situation, which is 584 newspapers. The expected profit at this stocking quantity is $331.44. b. Q= µ+Φ-1(Cu/(Cu+C0))δ Q=500+ Φ-1(.8/(.2+.8))100 Q=500+(..7881)(100) Q=579 This is off by 5 newspapers from the model given in the spreadsheet, which results in a $.03 difference in profits. 2) a. With the opportunity cost of her time per hour being equal to $10, Sheen should invest 4 hours daily into the creation of the profile section. This…

    • 1081 Words
    • 5 Pages
    Good Essays
  • Good Essays

    Hamptonshire Express Case

    • 632 Words
    • 3 Pages

    1. a. The simulation indicates that 584 is the optimum stocking quantity. Daily profit at this stocking quantity is $331.4346. b. Using the newsvendor model, Cu = 1 - 0.2 = 0.8 and Co = .2. Cu /(Cu + Co) = .8. Using the spreadsheet, we found Q* = NORM.INV(.8,500,100) = 584.16. The simulation and newsvendor model give the same optimal stocking quantity. 2. a. According to the simulation spreadsheet, 4 hours of investment in creation maximizes daily profit at $371.33. b. Sheen would choose an…

    • 632 Words
    • 3 Pages
    Good Essays
  • Good Essays

    The Express

    • 1064 Words
    • 5 Pages

    “The Express” is the story of Ernie Davis who was the first African-American to win the coveted Heisman Trophy, the highest accolade in American Football. Davis was a naturally talented football player, who developed from a quiet young man to become an icon for the civil rights movement that divided America in the early 1960s. Raised in poverty in Pennsylvania coal-mining country, his talent was recognized by Coach Ben Schwartzwalder who would help him turn from a high school athlete to a sporting…

    • 1064 Words
    • 5 Pages
    Good Essays
  • Powerful Essays

    American Express

    • 2524 Words
    • 11 Pages

    strategy of American Express MARKETING MANAGEMENT Assignment report writing analysis: Marketing strategy of American express Executive Summary: The report is above American Express’ marketing strategy for increasing market share and penetration in key emerging markets of Brazil, Russia, India and China. American Express pursues geographical segmentation (national market based segmentation) and customer based segmentation (business customers, individual customers etc.). American Express is striving to…

    • 2524 Words
    • 11 Pages
    Powerful Essays
  • Powerful Essays

    American Express

    • 1548 Words
    • 7 Pages

    Bottom of Form Business / American Express American ExpressThis essay American Express is available for you on Essays24.com! Search Term Papers, College Essay Examples and Free Essays on Essays24.com - full papers database.Autor: anton 17 March 2011Tags: American, Express Words: 675 | Pages: 3Views: 130Printable Version Essay: American ExpressRead Full Essay Join Now! As one of the leading credit card companies in today’s economic world, American Express has rightfully earned its place as…

    • 1548 Words
    • 7 Pages
    Powerful Essays
  • Good Essays

    Airborne Express

    • 720 Words
    • 3 Pages

    Case 8 Airborne Express: The Underdog 1. What generic strategy is Airborne Express pursuing? Justify. Is this a sound strategy in the context of the air express industry? Why or why not? Entrance barriers (high): it is hard to entry this industry, the top three carriers already dominate 86% of the industry. And it need a large scale of capital to entry this industry. For instance, with the development of business, global express demand increases. Airborne Express international strategy can…

    • 720 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Fedral Express

    • 7383 Words
    • 30 Pages

    Executive Summary This report is an overview of FedEx Corporation which we came across through the source of internet. We focused on different aspects of what FedEx is, how it works and how much is its global recognition. FedEx is the world's largest express delivery, ground small-parcel delivery, less-than-truckload freight delivery, supply chain management, customs brokerage, trade facilitation and e-commerce solutions company with more than 145,000 employees, worldwide and delivering more than 3.2…

    • 7383 Words
    • 30 Pages
    Powerful Essays
  • Good Essays

    Express Opinions

    • 513 Words
    • 3 Pages

    People Should Be Allowed to Express Their Opinions There are three assiduous things that make people pursue with consecutive efforts during life times: freedom, justice and love. The pursuit of Freedom, however, is something invariably vital to seek. Expression freedom or freedom of speech; therefore, deserves more passionate pursuit. As a democratic country, freedom of speech is that all citizens are allowed to express their thoughts, opinions, and attitudes to the everything of their country…

    • 513 Words
    • 3 Pages
    Good Essays
  • Good Essays

    selkirk express

    • 983 Words
    • 8 Pages

    [Document title] The Selkirk Express EXECUTIVE SUMMARY Selkirk Express growth boosted in relation to increase of capacity and tours from 60% to 85% since the year 1996. Over the last two years, however, growth has slowed to about 2%. In addition, TSE is also offering standard and premium service today. Sales and profits have shown a steady 8-12% increase per year at TSE. The corporate objective for TSE annual growth by 4-5%. TSE won’t consider an expansion in the number of trains that…

    • 983 Words
    • 8 Pages
    Good Essays
  • Satisfactory Essays

    The Future Express

    • 1200 Words
    • 5 Pages

    Page1 Future Express, The Future Express, The Court of Appeal (Civil Division) 29 July 1993 Case Analysis Where Reported Case Digest [1993] 2 Lloyd's Rep. 542 Subject: Shipping Keywords: Bills of lading; Cargo; Delivery; Insolvency Summary: Bill of lading; c & f contract; bank named as consignee; property passing separately from bill; buyer insolvent; delivery of cargo without production of bill; whether bank becoming pledgee of goods; whether bank having title to sue; whether shipowner…

    • 1200 Words
    • 5 Pages
    Satisfactory Essays