Data analysis case study

Assignment Help Business Management
Reference no: EM132487731

Benchmark - Data Analysis Case Study

Develop a managerial report (800 words) summarizing your analysis of the OEI service capabilities. Make recommendations regarding the number of technicians to be used when OEI reaches 20 and then 30 customers, and justify your response. Include a discussion of the following issues in your report:

Question 1. What is the arrival rate for each customer?

Question 2. What is the service rate in terms of the number of customers per hour? (Remember that the average travel time of 1 hour is counted as service time because the time that the service technician is busy handling a service call includes the travel time in addition to the time required to complete the repair.)

Question 3. Waiting line models generally assume that the arriving customers are in the same location as the service facility. Consider how OEI is different in this regard, given that a service technician travels an average of 1 hour to reach each customer. How should the travel time and the waiting time predicted by the waiting line model be combined to determine the total customer waiting time? Explain.

Question 4. OEI is satisfied that one service technician can handle the 10 existing customers. Use a waiting line model to determine the following information: (a) probability that no customers are in the system, (b) average number of customers in the waiting line, (c) average number of customers in the system, (d) average time a customer waits until the service technician arrives, (e) average time a customer waits until the machine is back in operation, (f) probability that a customer will have to wait more than one hour for the service technician to arrive, and (g) the total cost per hour for the service operation.

Question 5. Do you agree with OEI management that one technician can meet the average 3-hour service call guarantee? Why or why not?

Question 6. What is your recommendation for the number of service technicians to hire when OEI expands to 20 customers? Use the information that you developed in Question 4 (above) to justify your answer.

Question 7. What is your recommendation for the number of service technicians to hire when OEI expands to 30 customers? Use the information that you developed in Question 4 (above) to justify your answer.

Question 8. What are the annual savings of your recommendation in Question 6 (above) compared to the planning committee's proposal that 30 customers will require three service technicians? (Assume 250 days of operation per year.) How was this determination reached?

Attachment:- Data Analysis Case Study.zip

Reference no: EM132487731

Questions Cloud

Cost of equity-capm : Booher Book Stores has a beta of 0.9. The yield on a 3-month T-bill is 4% and the yield on a 10-year T-bond is 8%.
Determine when should bpp record cost of create commercials : Determine When should BPP record the cost of creating the commercials? When should BPP record the cost of showing the commercials?
Cost of equity-dividend growth : Summerdahl Resort's common stock is currently trading at $29 a share. The stock is expected to pay a dividend of $2.25 a share at the end of the year
Cost of preferred stock with flotation costs : Burnwood Tech plans to issue some $80 par preferred stock with a 8% dividend. A similar stock is selling on the market for $95.
Data analysis case study : What is the arrival rate for each customer and What is the service rate in terms of the number of customers per hour - Data Analysis Case Study
Compute what is the amount of each payment : Each of the four payments must be paid at the end of the next three years. What is the amount of each payment? Please round to the nearest whole number
Topic - Leadership and management and its importance : Research Paper Assignment - Topic - Leadership and management and its importance. Report the results of your rigorous analyses in a concise form
Define and describe purpose of pro-forma financial statement : Define and describe the purpose of pro-forma financial statements and the process involved in developing pro-forma financial statements
Expected growth rate of the company dividends : Arts and Crafts, Inc. will pay a dividend of $2 per share in 1 year. It sells at $40 a share, and firms in the same industry provide an expected rate of return

Reviews

Write a Review

Business Management Questions & Answers

  Caselet on michael porter’s value chain management

The assignment in management is a two part assignment dealing 1.Theory of function of management. 2. Operations and Controlling.

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. Due to increase in the preference for light beer drinkers, Chris Prangel wants to introduce light beer version in Mountain Man. An analysis into the la..

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. An analysis into the launch of Mountain Man Light over the present Mountain Man Lager.

  Analysis of the case using the doing ethics technique

Analysis of the case using the Doing Ethics Technique (DET). Analysis of the ethical issue(s) from the perspective of an ICT professional, using the ACS Code of  Conduct and properly relating clauses from the ACS Code of Conduct to the ethical issue.

  Affiliations and partnerships

Affiliations and partnerships are frequently used to reach a larger local audience? Which options stand to avail for the Hotel manager and what problems do these pose.

  Innovation-friendly regulations

What influence (if any) can organizations exercise to encourage ‘innovation-friendly' regulations?

  Effect of regional and corporate cultural issues

Present your findings as a group powerpoint with an audio file. In addition individually write up your own conclusions as to the effects of regional cultural issues on the corporate organisational culture of this multinational company as it conducts ..

  Structure of business plan

This assignment shows a structure of business plan. The task is to write a business plane about a Diet Shop.

  Identify the purposes of different types of organisations

Identify the purposes of different types of organisations.

  Entrepreneur case study for analysis

Entrepreneur Case Study for Analysis. Analyze Robin Wolaner's suitability to be an entrepreneur

  Forecasting and business analysis

This problem requires you to apply your cross-sectional analysis skills to a real cross-sectional data set with the goal of answering a specific research question.

  Educational instructional leadership

Prepare a major handout on the key principles of instructional leadership

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