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

Journal Article 1

See attachments  BUSI 613 Journal Article Review Assignment Instructions Overview MBA programs around the country are starting to require their students to become more effective writers. This is in response to industry’s urging for grad schools to improve the writing skills of graduate students. Writing at the MBA level should

Prof Double R

 Electronic Health Record  Answer the following questions: What is an EHR? What types of information are found in an EHR? Who manages an EHR? How is it used? Does an EHR follow the patient to other health facilities? Explain.

Microeconomics 6

Assignment in attachment  1. The following graph shows a firm operating in a monopolistically competitive market. How many haircuts will the firm perform in the short term, and at what price? At this point, what will its total revenue, total cost, and total profit be? Given your answers, what would

Microeconomics 7

Assignment in attachment  1. What are the four most important ways a firm becomes a monopoly? Will a monopoly that maximizes profit also be maximizing revenue? Will it be maximizing output? Explain. 2. Assume the graph below represents the market for a monopolist. What quantity will the monopolist produce, and

Microeconomics 2

Assignment in attachment  1. The graph below represents the market for flank steak in a specific town. Calculate the value of consumer surplus: A. When the market price is allowed to prevail, and B. When the town passes a law setting a price ceiling for flank steak of $13 per

MBA 699 4-2 Milestone 2

   1. Current employee demographics: Summarize the current employee demographics for the organization from the course scenario. a. Use Tableau to visualize the demographic data such as age, sex, marital status, education, and experience, and include the corresponding screenshots in your summary. Choose the graphs or charts that are best

HRM 6301 III

1 Three Keys to Success Joshua A. Learner Columbia Southern University LSS 1300: Learning Strategies for Success Dr. John Doe July 10, 2020 SAMPLE FORMAL ESSAY The title page includes the title of the assignment in bold font, the student’s name, the name of the university, the course name, the

ECO 6301 III

2 Economics for Managers ECO 6301 Unit III Essay Unit III Essay This 3-to-5-page essay measures your mastery of ULOs 1.1, 1.2, 2.1, 6.1, 6.2 and 7.1. Elasticity Assignment objective: Unit I introduced the benefits of markets to improving outcomes for producers and consumers. Unit II examined the role of

RCH 5301

2 Research Design and Methods RCH 5301 Unit II DB Describe a quantitative research project you would be interested in starting now or in the near future. Explain the problem and why this would be important for you to study. Why is a quantitative methodology an appropriate research strategy for

Business Finance – Accounting excel assignment

need this excel assignment done by tomorrow at 11:59. need formulas to be put in excel not just the answers Sheet1 Porsche and Mercedes-Benz, both based in Germany, are two of the largest automobile manufacturers in the world. The following information was provided in each company’s 2019 annual report. Porsche

Business Finance – Economics Global economics assignments

see attached READ ENTIRELY!  Assignments Week 2-6 NO AI!!! Week 2: DUE JULY 19 The role of government in the economy is often debated by economists and businesspeople. The debate ranges from having little to no government intervention to having a strong government presence in both business and social settings.

HRM 6301

2 Human Resources Management Methods HRM 6301 Equal employment opportunity and subsequent discrimination are major factors in today’s workplace. For a quick review, you can access the U.S. Equal Employment Opportunity Commission’s  Employees & Job Applicants webpage to review discrimination by type.  Considering the many types of employment discrimination, share which

dbs global economics

See attached DB1 Week 1 DUE JULY 09 Define capitalism and socialism and provide examples of countries that govern using each structure. Discuss why capitalism and socialism are currently spotlighted in U.S. politics giving the pros and cons of each organizational structure. Be specific and give supporting facts, not just

ECO 6301 II

2 Economics for Managers ECO 6301 Unit II This unit’s readings include information on pricing. You are introduced to the shutdown price, using elasticity to determine the effects of price changes, and cost-based pricing. Discuss the importance of considering elasticity in pricing decisions and the danger of relying solely on

Marketing Plan

iMBA Operations Strategy Module Summer 2024 Group Project One submission per group Only include your group name on the submission (points are deducted if individual group member names are included) . Please submit a Microsoft Word document. Limit of 20 pages, excluding title sheet, references, and appendices. 1. Overview of

WK1PR599

SEE ATTACHED 1 6 Peer Response: Cite 2 Scholary authors for each. •    Find at least TWO students whose conclusions bring new levels of understanding to your view on McDonald’s internal performance or conclusions. •    Discuss any major differences where you might disagree. 1Acj. A purpose/mission statement is

23

check f  This file is too large to display.View in new window