What is the highest number of trucks

Assignment Help Supply Chain Management
Reference no: EM13915918

OK, here's what I want to know: how often do we have more than 5 trucks, more than 6 trucks, and more than 7 trucks. What is the highest number of trucks we may have in the system with a 95% probability? And then, assuming the arrival rate of the deliveries does not change, what does the unload rate need to be so that we can service up to five trucks 95% of the time? In other words if we want a 95% probability of 5 or fewer trucks in the system at any one time, what does the unloading (service) rate need to be? Then, consider that we have two unloading teams, each able to unload trucks at the same rate. What does the unloading rate need to be for each team in order to ensure (100%) 5 or fewer trucks in the system at any time? I know we don't have room for two unloading teams at this time, but there is a possibility we might make room in the future. Analyze this situation and determine what we need to know and give me report. At this point in time, I am looking only for the problem to be quantified and the unload rate determined for the current situation (single server) and possible two servers. The current situation is a Single Server situation. Enter the arrival rate and service rate to calculate the pertinent queuing system state data. Find out the probabilities of 5 or more trucks in the system, then 6, then 7.

Then use trial and error to find the greatest number of trucks or less that can be in the system with 95% (or as close to 95%). For the Multi-server problem you will need to use a similar process. Record the results of your calculations and save the Excel file. The report should thoroughly address these aspects in depth and breadth:

Problem situation: clearly elucidate the problem situation at EBBD Assumptions: what are the assumptions that need to be made and your critical evaluation Solution: discuss how you developed the Solver solution. Keep in mind that your audience is not too technical and do not need a lot of detail on this. Make sure you attach the Excel file. You should refer to the Excel file when necessary. Explanation: clear articulation of the results that you obtain, based on what Mr. Wilco is asking for. Conclusion: Even though Mr. Wilco is not asking for a conclusion, you should determine if there is a conclusion to this situation and elucidate what it is.

Attachment:- Mod 3 Excel.xls

Reference no: EM13915918

Questions Cloud

Developing good note-taking and paraphrasing strategies : ‘Developing good note-taking and paraphrasing strategies, to effectively summarise academic resources, is a difficult process for students to learn.’
Ethical analysis of the issues raised in the case study : Prepare a business report of about 1500 words that gives an ethical analysis of the issues raised in the case study. In particular include in the report responses to the following sub-tasks:
Will the offering need to be registered with the securities : Will the offering need to be registered with the Securities and Exchange Commission (SEC) under the Securities Act of 1933? Explain. Does your answer differ if "Shares in Learning" are issued by Private College, a proprietary for-profit institution t..
To manage the economies of their countries : Critically evaluate measures used by governments and central banks to manage the economies of their countries. By critical evaluation use convincing arguments for or against measures used to re-duce, minimise or alleviate economic difficulties many c..
What is the highest number of trucks : OK, here's what I want to know: how often do we have more than 5 trucks, more than 6 trucks, and more than 7 trucks. What is the highest number of trucks we may have in the system with a 95% probability?
Uses the effective-interest method of amortization : The company uses the effective-interest method of amortization. Interest is paid on June 30 and December 31. On June 30, 2015, several years before their maturity, the company retired the bonds at 104 plus accrued interest. The loss on retirement, ig..
Write a memo report of three or fewer pages addressed to you : Write a memo report of three or fewer pages addressed to your boss. Include conclusions, recommendations, and a pie chart illustrating public opinion of outsourcing.
Contribution margin per unit cmu : Assume the contribution margin per unit (CMU) of a certain product is greater than zero. Which of the following would produce the largest increase and why?
Retirement of the bonds : Blue Note Corporation issued a $100,000, 10-year, 10 percent bond on January 1, 2013, for $112,000. Blue Note uses the straight-line method of amortization. On April 1, 2015, Blue Note reacquired the bonds for retirement when they were selling at 104..

Reviews

Write a Review

Supply Chain Management Questions & Answers

  Average number of customers in the system

Moore, Aiken, and Payne is a critical care dental clinic serving the emergency needs of the general public on a first come, first served basis.

  Analyze the emerging leadership theories

Identify the current global trends that you see driving a global leadership agenda -  Analyze the emerging leadership theories that are appropriate for a global agenda.

  What other factors should be considered

Three potential suppliers have been identified and the data were gathered. Develop a weighted-point model. Based on this model, which supplier should be selected? What other factors should be considered?

  The shipping pattern that will minimize transportation costs

1.Prescott Industries transports sand and stone extracted from its open pit mines located in Odessa and Bryan to its concrete block manufacturing facilities in Abilene, Tyler, and San Angelo.

  Evaluate the authors argument - management principles

Evaluate the authors argument that 'the management principles of TPS can be applied beyond manufacturing to any technical or service process'.

  Strategic international business mgmt dear tutorglobeplease

dear tutorglobe ltbrgt ltbrgtplease send your quotation and leadtime prior starting the attached assigment as quickly

  How company position in supply chain affect business role

How might a company's position in the supply chain affect its business role? Is there such a thing as a company that strictly operates in only one business role? Why or Why not

  How would the order quantity change

How would the order quantity change if the loss for each unsold parka would not be 8%, but 46% in the above scenario and which assumptions of the newsboy model correspond to the real situation described in the case; which do deviate strongly?

  How the profile of the function can be improved

The procurement and supply function to create savings or efficiencies or other sources of added value - How the profile of the function can be improved and how collaboration can be created with stakeholders to increase early engagement in the procure..

  Differences between transactional and relationship marketing

Explain the differences between transactional and relationship marketing. How do these differences lead to increasing emphasis on logistical performance in supply chain management?

  Describe the company''s supply chain

Identify a company with which you are familiar. This could be your place of employment, a car wash, a yard service company, and so forth.

  What was the innovative supply chain strategy

Review Essilor: Building an Efficient Supply Chain to Serve the Company's Mission - What was Essilors mission and what was the innovative supply chain strategy used to support the mission

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd