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

Discussion Board 3 ( Healthcare Reimbursement)

In your post, compare the characteristics and claims filing processes of private and public payers. What type of ethical issues could arise with personnel during the claims filing processes? Imagine yourself sitting around a conference table with your instructor and classmates. This discussion topic will be similar. It is a

Reading 3

instructions and readings are attached  For section #2 Comparative Insight (7 points) I also attached week 2 reading (Staffing Models)

MATH120

SEE ATTACHMENT  Conditional Probability: What affect does a condition have on the probability?  Let’s compare and find out. Example:   Let’s look at a standard deck of 52 playing cards. No replacement:  What is the probability of getting 2 kings assuming that the first one is not replaced?  (Note:  There are

MGMT496

SEE ATTCHMENT 250-300 WORDS ANSWERING THE FOLLOWING QUESTION This week explain who the potential audience for your e-portfolio will be.  How will you ensure that your e-portfolio is well received by the audience?  What acronyms do you use in your workplace that can cause confusion?  If you are including a

Government and Politics

Details attached.   The role of government in the economy is often debated by economists and businesspeople. 

HRM 6302 Unit V DBR

2 Employment Law HRM 6302 Unit V DB Reply 1 Posts to others should be a minimum of 150 words and use at least one supporting reference. You can use the text for this course as one of the reference sources. Reply to student post below Part I Under the Federal

Fin 6301 Unit VI PPP

2 Corporate Finance ECO 6301 Unit VI PowerPoint Presentation This assignment measures your mastery of ULOs 5.1, 5.2, and 5.3. The purpose of this PowerPoint Presentation is to analyze fundamental aspects of corporate finance management in multinational corporations. You will research a multinational corporation to focus on for the assignment,

gender

 In this summarize, Gallant writes mostly about gender and sex work. How might her ideas be expanded to consider gender in other areas of life?  

Real Estate Evaluation| Neighborhood Analysis

Identify and evaluate the neighborhood within which you live? Create a neighborhood profile using internet links and personal information that will provide some specific data. Draw some inference from this evaluation. Be sure to understand the term neighborhood and what makes this neighborhood different. Is it close to jobs? How

week 3 dicussion Organizational Behavior

 What are the factors that influence our perception? What is the link between perception and decision making? How do individual differences and organizational constraints influence decision making? 

FIN 6301 Unit V DB R1

2 Corporate Finance ECO 6301 Unit V DB Reply 1 • Your response post to class classmate should be at least 150 words in length. • Your response post should include at least one APA-formatted scholarly, professional, or textbook reference with accompanying in-text citation to support any paraphrased, summarized, or

FIN 6301 Unit V DB R2

2 Corporate Finance ECO 6301 Unit V DB Reply 2 • Your response post to class classmate should be at least 150 words in length. • Your response post should include at least one APA-formatted scholarly, professional, or textbook reference with accompanying in-text citation to support any paraphrased, summarized, or

BUSINESS (NO PLAGARISM A+ WORK, ON TIME)

discussion and assignment ASSIGNMENT Brand Extension Assignment For this assignment, you are asked to choose an  existing brand and create a  brand extension for that brand. This is not connected to your final paper topic, so you can use any brand, including your final paper topic for this deliverable. Your goal is

Cash Budget

See attached Please complete Excel template provided The goal of this assignment is to demonstrate the process of construction and utilization of a cash budget for a company. The assignment is closely related to Course Objectives #02. For this assignment we consider the monthly cash budget for six months (January

Final Project: Present a Business Plan

   Final Project: Present a Business Plan WHO: You are the entrepreneur, and your job is to present a business plan for your entrepreneurial venture (I was thinking of a truck parking stop).

Deliverable 7 – Strategic Implementation of Quality Initiatives

  Competencies Analyze the history of healthcare quality improvement and how it shapes current and future quality initiatives. Evaluate patient care clinical outcomes using quality improvement principles. Evaluate healthcare quality measures and their use in diverse populations and settings. Apply models of quality improvement to institutional challenges within the healthcare

Week 4 Discussion Response- Account for Managment Decision Making

Account for Management Decision Making Week 4 Learning Resources Costs There are many different types of costs that impact a manager’s decision making. Therefore, it is imperative that managers understand what each type is as well as the ones relevant to a specific decision. In these resources, you will examine