Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

BUS-660 Data Analysis Case Study

Please see attached document 

The purpose of this assignment is to apply a waiting line model to a business service operation in order to recommend the most efficient use of time and resources.

Use the information in the scenario provided to prepare a managerial report for Office Equipment, Inc. (OEI). 


Scenario

Office Equipment, Inc. (OEI) leases automatic mailing machines to business customers in Fort Wayne, Indiana. The company built its success on a reputation of providing timely maintenance and repair service. Each OEI service contract states that a service technician will arrive at a customer’s business site within an average of 3 hours from the time that the customer notifies OEI of an equipment problem.

Currently, OEI has 10 customers with service contracts. One service technician is responsible for handling all service calls. A statistical analysis of historical service records indicates that a customer requests a service call at an average rate of one call per 50 hours of operation. If the service technician is available when a customer calls for service, it takes the technician an average of 1 hour of travel time to reach the customer’s office and an average of 1.5 hours to complete the repair service. However, if the service technician is busy with another customer when a new customer calls for service, the technician completes the current service call and any other waiting service calls before responding to the new service call. In such cases, after the technician is free from all existing service commitments, the technician takes an average of 1 hour of travel time to reach the new customer’s office and an average of 1.5 hours to complete the repair service. The cost of the service technician is $80 per hour. The downtime cost (wait time and service time) for customers is $100 per hour.

OEI is planning to expand its business. Within 1 year, OEI projects that it will have 20 customers, and within 2 years, OEI projects that it will have 30 customers. Although OEI is satisfied that one service technician can handle the 10 existing customers, management is concerned about the ability of one technician to meet the average 3-hour service call guarantee when the OEI customer base expands. In a recent planning meeting, the marketing manager made a proposal to add a second service technician when OEI reaches 20 customers and to add a third service technician when OEI reaches 30 customers. Before making a final decision, management would like an analysis of OEI service capabilities. OEI is particularly interested in meeting the average 3-hour waiting time guarantee at the lowest possible total cost.


Managerial Report

Develop a managerial report (1,100-1,250 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:

1. What is the arrival rate for each customer?

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.)

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.

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.

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

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.

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.

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?

Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student Success Center. An abstract is not required.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Business Finance – Management Homework

MBA 599 – Strategic Management Case Project This capstone course requires each student to construct a detailed and well-thought-out analysis of a business employing all the relevant strategic analysis tools studied in the course. This project will take the full term to complete. It is our sincere hope that you

Mapping the Customer Experience Journey to Improve Customer Experience

Mapping the Customer Experience Journey to Improve Customer Experience In today’s competitive market, businesses must focus on delivering meaningful and seamless interactions at every stage of engagement. This is why mapping the customer experience journey has become an essential strategy for growth. By understanding how customers interact with a brand

Generative AI

   Discuss whether and how generative AI will play a role in strategic planning? How might you use it to assist in strategy formulation and implementation?

BCG and IE

   Are there key differences between BCG and IE portfolio matrices in both early-stage and established companies? If so, what are those key differences, and if not, why not? Provide insights in your responses based on the industry in which you have worked, are working in, or would like to

Event Software LLC

Reliable virtual event software is essential for online gatherings, and Eventsoftware.com offers seamless integrations, engagement features, and stable performance for global audiences.

Logistics 6

Please see attached  BUSI 615 Integrated Learning Project Assignment Instructions Overview The integrated learning assignment is a series of 6 assignments and a final course consolidated submission. All assignments and the compilation of the final consolidated submission is managed as an individual assignment. Purpose The purpose of the ILP is

Total Quality Management week 6

See attached the problem for my organization is invoice processing and how long it takes for vendors to get paid for the cook county organization. 

BUSINESS( NO PLAGARISM A+ WORK, ON TIME)

Tutor discussions  DB (NO MORE THAN 150 WORDS) Hello class! Looks like we made it to the end! When a company like X5RL creates a breakthrough treatment, the question of whether people can afford it gets complicated fast. Technically, the public’s financial struggles aren’t X5RL’s “problem,” but it’s hard to

Week 7 discussion

 please be sure to discuss the following 4 prompts regarding ‘The Three R’s’ (reduce, reuse, recycle) to waste reduction. (1) Please describe how ‘The Three R’s’ are ordered by how impactful those actions are. (2) Given the issues with recycling, why do you think it is still included in being

DEFM200

see attached Instructions Assignment Directions Write a three-page essay (excluding title and reference pages) on contract modifications and terminations in government contracting, using paraphrased content from at least three library articles and APA citations as detailed in the current APA manual in the library resources focus on: · The types and

Management

Can you help me with this question? Essay 2 Assignment Preparation Instructions: 1. Compose the assignment using Microsoft Word. 2. The paper should be formatted using double-spaced, Times New Roman, 12-point font, and one-inch margins. Content Instructions: 1. Pick a topic of interest to you from Chapters 7-12 of your

Calculating Quantities and Annual Costs

Assignment with questions are attached. Answers can be used on same document QSO 630 Module Four Problem Set Calculating Quantities and Annual Costs For this assignment, you will calculate quantities and annual costs to answer two supply chain questions. When you are finished, submit your answers for review by your

EXP 4

I have attached the completed versions of A2 and A3. Please use both to complete A4. The assignment needs to be cohesive to my original a2 and a3. This assignment is graded HARSHLY. I need quality work only 

Deliverable 2 – Lease Versus Purchase

  Scenario Health resources are finite. Therefore, it is incumbent on all health organizations to exercise responsible fiscal decision making when allocating their financial resources. As the senior cost analyst for a local, nonprofit hospital, you are charged with determining the most appropriate use of financial resources and making recommendations.

Deliverable 2 – Assessing Data Sets for Population Health Management

  Scenario W. Edwards Deming, who many consider the father of quality management, espoused the importance of using data for decision making. As a healthcare leader responsible for managing your healthcare organization’s population health management program, you will find that relevant, accurate, and current population health data is an essential

BUSINESS( NO PLAGARISM A+ WORK, ON TIME)

discussion tutor 2 reerences With Artificial Intelligence, Philosophy of Mind Has Become an Experimental Science | by Casper Wilstrup | Machine Consciousness | Medium The Future of the World (2030 to 10,000 A.D.+): 130 Future Technologies – YouTube Quantum Computing and Its Impact on AI Discussion (No more than 300