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 Jan 12 2025

Main Examination Period 2024 – January– Semester A – Take Home Assignment Module Code & Title: BUS326 Global Supply Chains Date and time of submission: 18 January 2025, 16:00 Important: You must read carefully the instructions on “Guidance on Take Home Assignments” before attempting this paper This paper contains 1

Week 1 2025

See attached, article in attachment  The purpose of Discussion 1 is to understand those factors that impact productivity, performance, and employee satisfaction and engagement. Your readings included management theory, organizational behavior, and effective management. All of these can impact employee performance. Job performance is defined as the degree to which

creative 1 (report + 10 slides ppt)

Assessment type:  Written assignment + Presentation  Description: Students will submit a detailed report that outlines their analysis of the business case, the solutions proposed, and the rationale behind their recommendations. Students will also present their case solution to the class, demonstrating their problem-solving process and defending their recommendations.

Why Digital Marketing is Important?

 Digital marketing is crucial in today’s business world because it allows companies to reach their audience where they spend most of their time—online. Here are the key reasons why digital marketing is essential:   1. Wider Reach With digital marketing, businesses can connect with a global audience beyond geographic boundaries,

586W1

This week has two assignment deliverables, the project charter and a one- to two-page paper written in APA format, including references. These deliverables are worth 100 points total. First, you need to decide on your project. You have two ways to proceed. 1. Use a sample project charter provided. 2.

MGMTW1CAA

Current Article Analysis Instructions Choose a current article related to this week’s material. Review and summarize the article, and then provide an analysis of the article applying the concepts related to this week’s material. This assignment should be written in APA style and should include the following. 1. Two pages

MGMTW1CP

Instructions Choose a global (or large publicly traded) corporation and research a published article referencing a legal, ethical, or political issue that the corporation has been affected by, alleged of, or found responsible for based on the article. Objective The name of a global (or large publicly traded) corporation and

INTLW1GPP

The State of Globalization Today: Opportunities and Risk Assessment Overview and Insights Globalization, which simply means the growth, speed, and ease of transportation and exchange of goods, services, data, knowledge, people, money, capital, and technology around the world. Globalization is not a static concept; it is evolving. Many countries have benefited

Marketing

Assignment attached, you must have marketing knowledge  Page 1 Announcing the Opening of Your ABA Clinic- Email newsletter: create a detailed announcement about the grand opening with relevant details about our services. Page 2: Put together an email list of pediatricians and daycare directors in Towson Maryland Page 3: Create

essay3

1 Assignment Title: Lights, Camera, Economics: Movie Pricing Trends Scenario: Movie theaters are constantly adjusting ticket prices based on various factors. However, higher prices aren’t always guaranteed to boost revenue. Assignment Task: Write a short research essay (approximately 1,000 words) analyzing the complex factors involved in movie ticket pricing decisions. Consider

nike

marketing plan for company NIKE MAR 3803 MARKETING PLAN TEMPLATE SLIDE 1 INTRODUCTION Select a company: Nike Provide an Overview of the company Name, date founded, Sales, Profit (loss), Executive Team Stage of the company (Start-up, Growing, Maturing, Declining) Product(s) Marketing Goals of the company SLIDE 2:Company Overview Mission and

case study/journal

see attached- units Vii and Viii MGT 3303, Managerial Decision Making 1 Course Learning Outcomes for Unit VIII Upon completion of this unit, students should be able to: 1. Summarize the foundational theories of managerial decision-making. 2. Examine the rational decision-making process. 3. Explore the psychological aspects of decision-making. 4.

businesses taxes

What taxes do businesses need to pay during the year? What is the current corporate income tax rate? How is corporate income tax calculated based on profit? What expenses can businesses deduct when calculating taxes? When is the deadline for paying corporate income tax? What are the regulations on extending

Deliverable 01 – Memo about Using an Entrepreneurial Mindset

Deliverable 01- Business Model Canvas Competency Assess the characteristics of an entrepreneurial mindset. Student Success Criteria View the grading rubric for this deliverable by selecting the “This item is graded with a rubric” link, which is located in the Details & Information pane. Scenario You have made ice cream that

Deliverable 1 – Presentation

Competency Evaluate the importance of innovation and change for an organization. Student Success Criteria View the grading rubric for this deliverable by selecting the “This item is graded with a rubric” link, which is located in the Details & Information pane. Scenario You are a new intern at organization XYZ,

Positive Psy-5

Instructions: Respond to the following posts with 150-200 words. Heather Share what Truth means to you. My initial instinct is to define truth as factual information free from gray areas, exceptions, or uncertainties. In certain cases, this perspective holds true; for instance, someone is either a student or they are

gta

Part I Utilize the text input field located on the ChatGPT3.5 webpage to ask the following five questions: What is Generative AI? In your own words explain what generative AI is. Do not quote. What is ChatGPT4o? In your own words explain what ChatGPT4o is. Do not quote. What is