RST Airlines operates call centers for customer service in four locations: Minneapolis, Phoenix, Boise, a call centers can handle any inquiries, calls from elite customers are generally routed to the Boise cente as domestic calls between midnight and 6 a.m. (Central U.S Time) are routed to Singapore. The following information provides the call center representative-hours worked and the number of calls period: Representative-hours Calls handled Minneapolis 8,430 60,696 Phoenix 10,200 61,710 Boise 7,220 30,324 Singapore 14,300 73,216

RST Airlines operates call centers for customer service in four locations: Minneapolis, Phoenix, Boise, a call centers can handle any inquiries, calls from elite customers are generally routed to the Boise cente as domestic calls between midnight and 6 a.m. (Central U.S Time) are routed to Singapore. The following information provides the call center representative-hours worked and the number of calls period: Representative-hours Calls handled Minneapolis 8,430 60,696 Phoenix 10,200 61,710 Boise 7,220 30,324 Singapore 14,300 73,216

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter2: Descriptive Statistics

Section: Chapter Questions

Problem 3P: Ohio Logistics manages the logistical activities for firms by matching companies that need products...

See similar textbooks

Similar questions

Manning Systems is a commercial software vendor that sells billing and other financial software to companies around the globe. Manning operates a centralized call center for customer support calls. Costs associated with use of the center are charged to the division with primary responsibility for the client. There are four geographical divisions: North America (NA), Central and South America (SA), Europe, and Asia-Pacific (APAC). The allocation is based on the length of time of calls made (Minutes). Idle time of the reservation agents and the fixed cost of the equipment are allocated based on the number of calls received (Calls) from clients in each division. Due to recent increased competition in the commercial software business, Manning has decided that it is necessary to better allocate its costs in order to price its services competitively and profitably. During the most recent period for which data are available, the use of the call center for each division was as follows:…
Westover Travel offers travel packages using both air and ocean travel. Westover offers two packages, Tourist and Premier, that differ in the accommodations, class of travel, and so on. Westover has a call center, which handles customer queries and complaints. The call center tracks the number of calls and the number of call-minutes for customers by the package they have purchased. Expected call center data for next month follow. Call center volume: Number of calls Number of call minutes Call center costs: Call-related Call minute-related Total call center costs Tourist 29,000 126,000 Required: Total $ 222,950 106,920 $ 329,870 The call center at Westover uses a two-stage cost allocation system: It uses the number of calls to allocate call-related costs and the number of call minutes to allocate call minute-related costs. Premier 16,500 198,000 a. Call related-overhead rate b. Call minute-related overhead rate c. Call center costs allocated to Tourist d. Call center costs allocated to…
Locker Rentals Corp. (LRC) operates locker rental services at several locations throughout thecity including the airport, bus depot, shopping malls, and athletics facilities. Unlike some of theold mechanical lockers that charge a fixed amount per use, LRC’s lockers operate electronicallyand are able to charge based on hours of use. The locker system transmits a daily message toLRC’s office indicating the number of hours that lockers have been used, which the office manager uses to determine when cash should be picked up at each location. LRC’s cash receipts system is described below.a. Two employees (“cash collection clerks”) are responsible for collecting cash from the lockers. Based on instructions from the office manager, one clerk collects cash from specificlocations on the west side of the city and the other collects from specific locations on theeast side.b. When each cash collection clerk returns with the cash, a supervisor counts the cash and prepares a cash count sheet.c. The…
Armada Shipping is a global logistics company. The company is organized into two divisions: Contracts and Retail. The Contracts Division, which is by far the larger division, handles customers who have regular shipping requirements and have signed contracts specifying costs and schedule for up to one year. The Retail Division handles shipments for customers who have only occasional shipping requirements and pay on an as-used basis. Billing for all customers is handled by the corporate Accounts Receivable Department. Accounts Receivable performs two major activities: billing and accounts. Billing refers to preparing and sending the bills as well as processing the payments. Accounts refers to establishing accounts, ensuring credit status, following up on collection, and so on. The costs of the Accounts Receivable Department are allocated to the two divisions based on the number of bills prepared. The manager of the Contracts Division has complained that the allocated costs from Accounts…
Armada Shipping is a global logistics company. The company is organized into two divisions: Contracts and Retail. The Contracts Division, which is by far the larger division, handles customers who have regular shipping requirements and have signed contracts specifying costs and schedule for up to one year. The Retail Division handles shipments for customers who have only occasional shipping requirements and pay on an as-used basis. Billing for all customers is handled by the corporate Accounts Receivable Department. Accounts Receivable performs two major activities: billing and accounts. Billing refers to preparing and sending the bills as well as processing the payments. Accounts refers to establishing accounts, ensuring credit status, following up on collection, and so on. The costs of the Accounts Receivable Department are allocated to the two divisions based on the number of bills prepared. The manager of the Contracts Division has complained that the allocated costs from Accounts…
Westover Travel offers travel packages using both air and ocean travel. Westover offers two packages, Tourist and Premier, that differ in the accommodations, class of travel, and so on. Westover has a call center, which handles customer queries and complaints. The call center tracks the number of calls and the number of call - minutes for customers by the package they have purchased. Expected call center data for next month follow. Call center volume: Tourist Premier Number of calls 26,000 15,000 Number of call minutes 120,000 186, 000 Call center costs: Total Call - related $ 219, 350 Call minute - related 119,340 Total call center costs $ 338,690 The call center at Westover uses a two-stage cost allocation system: It uses the number of calls to allocate call - related costs and the number of call minutes to allocate call minute - related costs. Required: Compute the call - related overhead rate for next month. Note: Round your answer to 2 decimal places. Compute the call minute -…
Martin Shoes, Inc. manufactures and distributes orthopedic footwear. To sell its products, the marketing department requires sales personnel to call on the shoe retailers within their assigned geographic territories. Each salesperson has a laptop computer, which he or she uses to record sales orders during the day and to send these sales orders to Martin’s network nightly for updating the company’s sales order file. Each day, warehouse personnel review the current sales orders in its file, and where possible, pick the goods and ready them for shipment. (Martin ships goods via common carrier, and shipping terms are generally FOB from the shipping point.) When the shipping department completes a shipment, it also notifies the billing department, which then prepares an invoice for the customer. Payment terms vary by customer, but most are net 30. When the billing department receives a payment, the billing clerk credits the customer’s account and records the cash received. Requirements 1.…
Ohio Logistics manages the logistical activities for firms by matching companies that need products shipped with carriers that can provide the best rates and best service for the companies. Ohio Logistics is very concerned that its carriers deliver their customers material on time, so it carefully monitors the percentage of on-time deliveries. The following table contains a list of the carriers used by Ohio Logistics and the corresponding on-time percentages for the current and previous years. a. Sort the carriers in descending order by their current years percentage of on-time deliveries. Which carrier is providing the best service in the current year? Which carrier is providing the worst service in the current year? b. Calculate the change in percentage of on-time deliveries from the previous to the current year for each carrier. Use Excels conditional formatting to highlight the carriers whose on-time percentage decreased from the previous year to the current year. c. Use Excels conditional formatting tool to create data bars for the change in percentage of on-time deliveries from the previous year to the current year for each carrier calculated in part b. d. Which carriers should Ohio Logistics try to use in the future? Why?
East Coast Trucking provides service from Boston to Miami using regional offices locatedin Boston, New York, Philadelphia, Baltimore, Washington, Richmond, Raleigh,Florence, Savannah, Jacksonville, and Tampa. The number of miles between the regionaloffices is provided in the following table:
Orion Languages, Incorporated (OLI) offers conversational Instruction in several languages. Customers can choose from three approaches: Group, Individual, or Intense. Group customers meet as a part of a class at scheduled times. Individual customers receive one-on-one Instruction over the same time frame as a group class, but at times most convenient for them, Intense customers receive focused, Individual Instruction over two weeks; this approach is often chosen by executives who are relocating to offices located in countries where a new (to the executive) language is spoken. The courses have the following characteristics: Group $ 334 $ 84 782 Individual $ 2,534 $ 1,534 234 Price charged per customer Variable cost per customer Expected customers per year The total fixed costs per year for the company are $609,000. Intense $ 5,085 $ 3,335 234 Required: a. What is the anticipated level of profits for the expected sales volumes? b. Assuming that the product mix is the same at the…
CARMAX has several branches island wide. The company imports and sells motor vehicle parts and accessories to retail customers. With the increase in staff complement, the company has decided to implement a computerised wages system. All employees are required to work eight hours daily. The employees' hours are recorded using the magnetic card which is attached to their identification card. When each employee arrives for work, they hold their card close to the card reader. This must be done, as encoded in the reader is the employee's TRN and NIS number, which is linked to the payroll system. The reader recognizes the magnetic information on the card, identifying the employee as being 'at work. When the employee leaves work at the end of the day, the employee must log out by ensuring their ID is swiped, as the process is reversed showing that the employee has left work. The information that is used to calculate the employees' weekly salary is obtained directly from the magnetic card…
CARMAX has several branches island wide. The company imports and sells motor vehicle parts and accessories to retail customers. With the increase in staff complement, the company has decided to implement a computerised wages system. All employees are required to work eight hours daily. The employees' hours are recorded using the magnetic card which is attached to their identification card. When each employee arrives for work, they hold their card close to the card reader. This must be done, as encoded in the reader is the employee's TRN and NIS number, which is linked to the payroll system. The reader recognises the magnetic information on the card, identifying the employee as being 'at work'. When the employee leaves work at the end of the day, the emplovee must log out by ensuring their ID is swiped, as the process is reversed showing that the employee has left work. The information that is used to calculate the employees weekly salary is obtained directly from the magnetic card…