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 MANAGEMENT GREAT WORK, ON TIME, NO PLAGARISM,

Tutor Business Response 2 Respond JD ( MO MORE THAN 160-200 WORDS I’ve chosen to discuss insider trading for this week’s post. Insider trading occurs when an individual buys or sells securities based on tangible, non-public information obtained from a position of trust or access. It is illegal because it

Unit 5

See Attached Purpose · Apply knowledge of funding sources and financial data from the organization’s Form 990 to create a budget. · Develop a narrative explanation of the budget. · Address reporting and board oversight responsibilities, KPIs, and sustainability. Task You will research your nonprofit’s financial data the Wounded Warrior

Accounting Project

Based on the information provided below, complete a 2025y Form 1040 and any supporting schedules/forms for Bob and Melissa Grant. You should complete this tax return manually using the forms available from the IRS website, www.irs.gov. You may not use software to assist in preparing the forms. You may find

Interdisciplinary Research Question

The instructions are all attached. Interdisciplinary Research Question Assignment Instructions Overview You will write your Interdisciplinary Research Question for approval and provide an explanation of why you selected this question. Your Interdisciplinary Research Question should be complex in that it requires insights from two disciplines (these should be your two

Logistics 3

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 for

Total Quality Management 3

see attached  BUSI 616 Customer Satisfaction Assignment Instructions Review the assigned readings and reflect on who the customer is within your selected organization. Is importance placed on satisfaction on both the internal and external customer? How are the needs of both internal and external customers identified? Who is empowered in

1-1 Discussion: Introduction and Selection of Organizations

 lect two to three organizations for consideration for your capstone project’s feasibility study. Provide a brief descriptive background and a general financial overview of each organization. For the financial overview, locate up-to-date financial information and copy and paste the information into your post. Then discuss why you feel each organization

Business & Finance Business 508 Managerial Analytics ( Excel Spread Sheet Homework)

Excel Spreadsheet Assignment Simple. Excel Homework Assignment 1 – Business Analytics Basics (50 Points) Course: Business Analytics / Project Management Analytics Submission Format: Excel File Upload Assignment Overview This assignment is designed to help you practice basic Excel skills and introductory business analytics modeling. You will build a simple spreadsheet,

Case Study: How Sysco Is Shaping the American Food System

Strength: Sysco wins because it can deliver almost everything a restaurant needs through one large, coordinated distribution network, saving customers time and reducing ordering headaches. Weakness: Because Sysco is built for efficiency and volume, its product mix can feel “same everywhere,” which can make it harder for independent restaurants to

ITC 5301 VI PPP

2 Management Information Systems ITC 5301 Unit VI PowerPoint Presentation This measures your mastery of ULOs 3.4, 3.5, 4.2, and 5.4. Harnessing the Power of AI for Strategic Decision- Making: Opportunities and Challenges The objective of this assignment is to understand and analyze the role of artificial intelligence (AI), business

HRM 6304 VDBR1

2 Labor Relations and Collective Bargaining HRM 6304 Unit V Discussion Board Reply 1 Initial post to be a minimum of 250 words and at least one supporting reference. You should also include at least two references. Reply to post below The most immediate danger of a narrow wage spread

BUSINESS MANAGEMENT GREAT WORK, ON TIME, NO PLAGARISM,

tutor discussion response Respond dm (No more than 150 words) So, for this week’s discussion board, we look at wearable AI devices. This for sure has always been where technology was headed. Like in the TED talk in our lesson plan, technology has been on a constant path to scaling

Assignment 2

Due 2/6/2026 Assignment 2 Conceptualizing Successful leadership For Current Times This assignment is aimed at providing opportunities to reflect on current challenges and experiences influencing the role of leaders in your field. Considering your professional field, create a sketch describing your views for successful leadership in your professional field (HVAC

Virtual Meetings: Communicating Your Plan

Overview In today’s modern workplace, employees have a wide range of digital tools at their fingertips to meet virtually with colleagues and/or customers. This assignment allows you to practice your communication, digital proficiency, and productivity skills. Imagine that you are preparing for a Zoom meeting with a colleague to discuss

BUSINESS MANAGEMENT GREAT WORK, ON TIME, NO PLAGARISM,

tutor discussion Week 5 Discussion: Agency Regulation (No more than 300 words) Discussion Prompt Background and Resources In 1934 Congress created the Securities & Exchange Commission (SEC) to regulate publicly traded stocks and securities. The SEC’s responsibilities cover a range of activities. Two types of violations found in SEC cases are:

biblical

good to go  BUSI 502 Biblical Integration Project Assignment Instructions Overview The purpose of the individual biblical integration paper is to explore the topic of servant leadership in a non-exhaustive scholarly manner that will be useful in your chosen field. In this individual project, learners will be able to demonstrate