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 - related overhead rate for next month. Note: Round your answer to 2 decimal places. Compute the total call center costs allocated to the Tourist package. Compute the total call center costs allocated to the Premier package.

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 - related overhead rate for next month. Note: Round your answer to 2 decimal places. Compute the total call center costs allocated to the Tourist package. Compute the total call center costs allocated to the Premier package.

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

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…
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?
The Pacific Corporation operates car rental agencies at more than 20 airporta. Customers can choose from one of three contracts for car rentals of 1 day or less: A (Click the icon to view the contract information. Read the requirements. - X More info • Contract 1: $55 for the day • Contract 2: $35 for the day plus $0.20 per mile traveled • Contract 3: $1.20 per mile traveled Requirement 1. Plot separate graphs for each of the three contracts, with costs on the vertical axis and miles traveled on the horizontal axis. First let's draw the graph for contract 1. (Use the line tool button displayed below to draw the graph.) Contract 1 Print Done - X Requirements 1. Plot separate graphs for each of the three contracts, with costs on the vertical axis and miles traveled on the horizontal axis. 150 Click to Milas Iravaled per ny enlarge graph 2. Express each contract as a linear cost function of the form y=a+bX. 3. Identify each contract as a variable-, fixed-, or mixed-cost function. Print…
On-time arrivals, lost baggage, and customer complaints are three measures that are typically used to measure the quality of service being offered by airlines. Suppose that the following values represent the on-time arrival percentage, amount of lost baggage, and customer complaints for 10 U.S. airlines. a. Based on the data above, if you randomly choose a Delta Air Lines flight, what is the probability that this individual flight will have an on-time arrival? b. If you randomly choose 1 of the 10 airlines for a follow-up study on airline quality ratings, what is the probability that you will choose an airline with less than two mishandled baggage reports per 1,000 passengers? c. If you randomly choose 1 of the 10 airlines for a follow-up study on airline quality ratings, what is the probability that you will choose an airline with more than one customer complaint per 1,000 passengers? d. What is the probability that a randomly selected AirTran Airways flight will not arrive on time?
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…
Stay-4-Ever is a small motel chain with locations in the northeastern United States. The chain has a total of 200 rooms. The following operating data are available for July: Number of Guests. Nights per Visit Guest Nights 1,600 1 1,600 750 2 1,500 275 3 825 80 4 320 19 5 95 Determine the guest nights for July. Determine the available room nights for July. Determine the occupancy rate for July. Assume that the occupancy rate for July of the prior year was 75%. Has the utilization rate for Stay-4-Ever improved or declined?
Town Center Tours provides historicalguided tours of several U.S. cities. The company charges $175 per person for the eight-hour tour.For groups of four or more, a group discount of $25 per person is offered. Here is a selection oftransactions during June: Requirement1. Journalize all transactions for Town Center Tours.
The problem says: jakes cabins is a small hotel chain with locations near the national parks of Utah Wyoming Montana. The chain has a total of 500 guestrooms. The following operating data are available for June. See the attached photo. I need to figure out how I determine the available room nights for June and how I determine the occupancy rate for June.
GenX is a career training company that offers both online and on-campus weekend training courses on web development, data science, coding, and digital marketing. The accompanying data file shows the courses that will be offered next month by GenX. The data set contains course name (Course), whether the course is offered online or on-campus (Mode), current enrollment (Enrollment), tuition per student (Tuition), cost of instructors (Instructor costs), facility costs (Facility costs), technical service costs (Technical services), and historical cancellation rate for the course (Cancellation rate). Only on-campus courses incur facility costs. Online courses carry much higher costs for technical services than on-campus courses. The historical cancellation rate is used to project the actual enrollments of the courses. GenX would like to develop a spreadsheet model that calculates the projected revenue and profit for the month. Course Mode Enrollment Tuition Instructor costs Facility…
t is the last day of the month and fiscal year, your manager asks you to create an invoice for $10,000 (debiting Accounts Receivable and Crediting Sales) and send it to a specified customer. Normally invoices are sent to customers when products have been shipped or the service has been finished. You manager tells you that we will be shipping equipment and performing the setup services for this customer next month (as early as next week). You know that by preparing the closing entries tomorrow, the revenue will be included in this year’s fiscal year and then the revenue account will be set to zero for the beginning of the year. How would you respond to your manager? Do you have any suggestions or alternative ways you would recommend to your manager on how to record this?
Before you begin this assignment review the Tying It All Together feature in the chapter. Best Buy Co., Inc. is a leading provider of technology products. Customers can shop at more than 1,700 stores or online. The company is also known for its Geek Squad for technology services. Suppose Best Buy is considering a particular HDTV for a major sales item for Black Friday, the day after Thanksgiving, known as one of the busiest shopping days of the year. Assume the HDTV has a regular sales price of $900, a cost of $500, and a Black Friday proposed discounted sales price of $650. Best Buy’s 2015 Annual Report states that failure to manage costs could have a material adverse effect on its profitability and that certain elements in its cost structure are largely fixed in nature. Best Buy, like most companies, wishes to maintain price competitiveness while achieving acceptable levels of profitability. (Item 1A. Risk Factors.) Requirements Calculate the gross profit of the HDTV at the regular…
Cornwall Mobile Detailing (CMD) is a service that washes and details a customer's vehicle at their home or office. It operates on a membership basis. Members pay $900 dues per month, which entitle them to a complete wash and detail service monthly. Members may also order additional car washes during the month at a fee of $110. Additional washes are common in both summer and winter months. The number of members also varies with the season. The number of members and the average number of additional washes by members for the months of interest follow: Additional Washes (Average January February March April May June Members 430 per Member) 1.5 490 1.8 1,050 1.4 1,190 1.3 1,220 1,370 1.6 2.1 Cornwall allows members to pay for dues on credit. Cornwall's experience is that 40 percent of its members pay cash for the dues, 50 percent of the members pay the dues for a month in the next month, 5 percent in the second month after. The remainder is uncollectible. Additional washes are payable in…