Preview

Hamptonshire Express

Better Essays
Open Document
Open Document
2153 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Hamptonshire Express
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
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Campfire Outfitters Drivers Cost Center Case Study
    • 657 Words
    • 3 Pages

    Campfire Outfitters Drivers Cost Center Case Study

    Paper cost ( 1,300 copies x .007) 9.10 Other supplies & electricity (1,300 copies x 0.004) 5.20 Total variable cost 14.30 2.) Calculate the total labor cost of these jobs Labor cost ( $ 8 x 4 hrs ) 32.00 3.) Suggest a way to assign labor and indirect costs to the cost of a copy made on that Sunday Direct Labor hours used because it is fixed and can be easily measured. 4.) Determine the full cost of one copy on the last Sunday in June, using the cost method in preceeding question. Paper cost 0.007 Other supplies & electricity Other supplies & electricity 0.004 0.004 Labor Cost (8/ hrx 4 hrs)/1300 copies 0.0246 Monthly operating cost (total cost (($5,000/30 days)/8hrs ) hourly rate ( 20.83/ hr x 4hrs )/1,300 copies 0.064 Total Full Cost per copy 0.0996 5. ) Determine the average annual full cost of one copy No. Of copies made / No. Of copies made 1,300 copies / 4hrs = 325 copies per hour Total no. Of copies made = total direct labor-hours x copies made per hour 7,280 hrs x 325 copies per hour = 2,366,000 copies Variable Cost ( 0.011 x 2,366,000 copies ) Labor cost (.0246 x 2,366,000 copies ) Other monthly cost total cost 5,000 x 12 months Total annual cost 26,026.00 58,203.60 144,000.00…

    • 657 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    Cmis 102 Assignment 1 Essay Example
    • 832 Words
    • 4 Pages

    Cmis 102 Assignment 1 Essay Example

    1. Using a similar approach as example 2.3 (textbook page 75): “Finding the Sale Price of Items in a Department Store”, provide your analysis for the following problem statement:…

    • 832 Words
    • 4 Pages
    Powerful Essays
    Read More
  • Good Essays

    Jet Copier
    • 416 Words
    • 2 Pages

    Jet Copier

    In the case study for Jet copies three students are contemplating the benefits of opening a copy business in their town. They are also trying to decide whether or not it would be a good investment to purchase a second copier, in case their main copy machine breaks down. The students have already purchased an $18000 copier to start their copy business. They are trying to determine if they should get a loan to purchase a smaller $8000 copier as back-up. The students estimated that they would sell between 2,000 and 8,000 copies per day at 10 cents per copy. The students determined that the time between main copier breakdowns would be from 0 to 6 weeks. The students determined that if the revenue loss for a 1 year period was greater than or equal to $12000, they would purchase the backup copier. A simulation was created to estimate the amount of revenue that would be lost if they did not have a back-up copy machine.…

    • 416 Words
    • 2 Pages
    Good Essays
    Read More
  • Good Essays

    Sport Obermeyer
    • 1429 Words
    • 6 Pages

    Sport Obermeyer

    In order to minimize the company’s risk of over stock due to relatively inaccurate demand forecast in the first-phase production, it is a wise idea to order at the minimum i.e. 10,000 units. According to Exhibit 10, the total number of all 10 styles added up to 20,000 units. Therefore the goal is to reduce this by half as well as taking mean and standard deviation of each style into account. Obviously, to produce half of the forecast, it has to produce at lower than the “mean” (Average Forecast) of each style. By taking standard deviation into account, this can be calculated using the formula…

    • 1429 Words
    • 6 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Hp Deskjet
    • 300 Words
    • 2 Pages

    Hp Deskjet

    In order to calculate the yearly investment in DeskJet printers, we calculate the yearly investment of the printers separately and then add them together to get the total yearly cost. There are 6 versions of the printers, which are A, AA, AB, AQ, AU, AY. The total factory throughput time through the PCAT and FAT stages is about one week. The transportation time from Vancouver to the European DC is five weeks. The plant sends a weekly shipment of printers to Europe. Therefore, the lead time is L=1+5=6 weeks and review time T=1 week. Based on the data in Exhibit 13.14 in the textbook, we use Excel to calculate the average monthly demand (mean) and the standard deviation for each version of the printers (Exhibit 1).…

    • 300 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    USTruckerjobs.com Partners With Transportation Job Fair in Oklahoma City
    • 321 Words
    • 2 Pages

    USTruckerjobs.com Partners With Transportation Job Fair in Oklahoma City

    those considering the career field are at an all-time high," noted Sela Rodriguez, VP of Recruiting.…

    • 321 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    2010 03 21 210212 ArmyGuySunday
    • 1076 Words
    • 6 Pages

    2010 03 21 210212 ArmyGuySunday

    3) Megley cheese company is a small manu. of several chees products. On of the producst is a cheese spread. That is sold in reail outlets. jason must decide home many cases of cheese spread to manufacture each month. The probabily that the demand will be 6 case is 0.1 for 7 cs is 0.3 for 8 cs is 0.5 and 9 cs is 0.1. the cost of ever case is $45 adn the price that jason gets for each case is $95. Unfortunately any cases not sold by the end of the month are of no vaule cus the spoil. Home cases of cheese should janson manufacture each month?…

    • 1076 Words
    • 6 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    EOQ
    • 378 Words
    • 2 Pages

    EOQ

    The I-75 Carpet Discount Store in North Georgia stocks carpet in its warehouse and sells it through an adjoining showroom. The store keeps several brands and styles of carpet in stock; however, its biggest seller is Super Shag carpet. The store wants to determine the optimal order size and total inventory cost for this brand of carpet given an estimated annual demand of 10,000 yards of carpet, an annual carrying cost of $0.75 per yard, and an ordering cost of $150. The store would also like to know the number of orders that will be made annually and the time between orders (i.e., the order cycle) given that the store is open every day except Sunday, Thanksgiving Day, and Christmas Day (which is not on a Sunday).…

    • 378 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Transshipment Linear Programming
    • 371 Words
    • 2 Pages

    Transshipment Linear Programming

    (b) Solve the problem using Excel Solver and determine an optimal distribution plan for the company.…

    • 371 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Problems
    • 1931 Words
    • 8 Pages

    Problems

    Franklin Mint and Candy Shop can open a new store that will do an annual sales volume of $750,000. It will turn over its assets 2.5 times per year. The profit margin on sales will be…

    • 1931 Words
    • 8 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    Olive Senior Poem
    • 1253 Words
    • 6 Pages

    Olive Senior Poem

    b) Name of Contact (if any) 8. Home/Permanent Phone ( ) 10. Cell Phone ( ) 12. Fax Number ( ) 14. Gender -…

    • 1253 Words
    • 6 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    Nioc Nioc
    • 412 Words
    • 2 Pages

    Nioc Nioc

    Are you renting? Do you have breed/size/number or weight restrictions? Can you provide proof? (Please provide landlord name and phone) | We own our home | Employer/School | Fairfax Radiology |…

    • 412 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    KYC Format HPGAS V3 1
    • 553 Words
    • 6 Pages

    KYC Format HPGAS V3 1

    (To be filled in black ink with BLOCK LETTERS. Fields marked with * are mandatory)…

    • 553 Words
    • 6 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Smoking Ban in Public Places
    • 787 Words
    • 3 Pages

    Smoking Ban in Public Places

    Whether you smoke or not, how bad is it when as you walk into a restaurant to eat a nice meal, you 're greeted with a cloud of smoke in your face. This is the biggest issue with a smoking ban for Northern Kentucky. Supporters say the ban is needed for protection against the hazards of secondhand-smoke. Opponents call it unnecessary and say it infringes on the rights of business and property owners.…

    • 787 Words
    • 3 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    The News Express Questions
    • 426 Words
    • 2 Pages

    The News Express Questions

    Background: If The News-Express does not reduce the price, the market research predicts the Volume sales to go down to 750000, while on the other hand if the price is reduced the volume sales increases to 1000000.…

    • 426 Words
    • 2 Pages
    Satisfactory Essays
    Read More

Related Topics