Shortly after being hired as an analyst with Global American Airlines, Kim Williams was asked to prepare a report that focused on passenger ticketing cost. The airline writes most of its own tickets (largely through reservations personnel), makes little use of travel agents, and has seen an ever-increasing passenger interest in e-ticketing (i.e., electronic reservations and tickets handled over the Internet).
After some discussion, Williams thought it would be beneficial to begin her report with an overview of three different cost estimation tools: scatter diagrams, least-squares regression, and the high-low method. She would then present the results of her analysis of the past year’s monthly ticketing cost, which was driven largely by the number of tickets written. These results would be presented in the form of algebraic equations that were derived by the three tools just cited. The equations follow. (C denotes ticketing cost, and PT denotes number of passenger tickets written.)
Williams had analyzed data over the past 12 months and built equations on these data, purposely including the slowest month of the year (February) and the busiest month (November) so that things would “… tend to average out.” She observed that November was especially busy because of Thanksgiving, passengers purchasing tickets for upcoming holiday travel in December, and the effects of a strike by Delta Western Airlines, Global American’s chief competitor. The lengthy strike resulted in many of Delta Western’s passengers being rerouted on Global American flights.
Required:
- 1. Prepare a bullet-point list suitable for use in Williams’s report that describes the features of scatter diagrams, least-squares regression, and the high-low method. Determine which of the three tools will typically produce the most accurate results.
- 2. Will the three cost estimation tools normally result in different equations? Why?
- 3. Assuming the use of least-squares regression, explain what the $312,000 and $2.30 figures represent.
- 4. Assuming the use of a scatter diagram, predict the cost of an upcoming month when Global American expects to write 580,000 tickets.
- 5. Did Williams err in constructing the equations on data of the past 12 months? Briefly explain.
- 6. Assume that over the next few years, more of Global American’s passengers will take advantage of e-ticketing over the Internet. What will likely happen to the airline’s cost structure in terms of variable and fixed cost incurred?
Want to see the full answer?
Check out a sample textbook solutionChapter 6 Solutions
Managerial Accounting: Creating Value in a Dynamic Business Environment
- An accounting intern for a local CPA firm was reviewing the financial statements of a client in the electronics industry. The intern noticed that the client used the FIFO method of determining ending inventory and cost of goods sold. When she asked a colleague why the firm used FIFO instead of LIFO, she was told that the client used FIFO to minimize its income tax liability. This response puzzled the intern because she thought that LIFO would minimize income tax liability. Required: What would you tell the intern to resolve the confusion?arrow_forwardBig Apple Design Company specializes in designing commercial office space in Chicago. The firm’s president recently reviewed the following income statement and noticed that operating profits were below her expectations. She had a hunch that certain customers were not profitable for the company and asked the controller to perform a customer-profitability analysis showing profitability by customer for the month of March. Required: Put yourself in the position of Big Apple’s controller and write a memo to the president to accompany the customer-profitability graph. Comment on the implications of the customer-profitability analysis and raise four or more questions that should be addressed by the firm’smanagement team.arrow_forwardThis question builds on your work from B-1. Competition is fierce for the Chicago to Atlanta route, and the airline realizes that it may need to reduce the current ticket price. They ask you to provide projections for number of reservations, number of denied passenger check ins (due to overbooking), penalties, sales, net income, and profit margin for this route at different ticket prices. The average number of reservations for this route is 184 when the ticket price is $420, use those figures as a base for your calculations. The airline conducted a price sensitivity analysis and determined that for every $20 increase in ticket price, demand will decrease by 1 ticket reservation. Similarly, ticket sales will increase by 1 reservation for every $20 decrease in ticket price. Using an appropriate data table, calculate the number of reservations, number of passengers denied check ins (due to overbooking), total penalties, total sales, net income, and profit margin (as a percentage) for…arrow_forward
- Aaron McKinney is a cost accountant for Majik Systems Inc. Martin Dodd, Vice President of Marketing, has asked Aaron to meet with representatives of Majik Systems’ major competitor to discuss product cost data. Martin indicates that the sharing of these data will enable Majik Sys-tems to determine a fair and equitable price for its products. Would it be ethical for Aaron to attend the meeting and share the relevant cost data? Explain your answer.arrow_forwardYou are an accounting student at Berkeley College and will not graduate for another year. But because of your excellent grades so far, you have been able to land a job in the purchasing department of a retailer. One of the purchasing agents in your company is negotiating for the receipt of a very large order of uninsured goods from a supplier. The purchasing agent is able to get a better deal on the goods if they are shipped FOB shipping point rather than FOB destination. The agent doesn’t know the difference between these two concepts. He also doesn’t understand why choosing one over the other should make any difference to the company. As a student of accounting at Berkeley College, you know well the difference between these 2 concepts and you know why one would be a better choice over the other in the case of uninsured goods. Please explain these two concepts in this discussion and tell the purchasing agent which shipping method is preferable and why.arrow_forwardThe controller of a retail company has just had a $50,000 request to implement an ABC system quickly turned down. A senior vice president, in rejecting the request, noted, "Given a choice, I will always prefer a $50,000 investment in improving things a customer sees or experiences, such as our shelves or our store layout. How does a customer benefit by our spending $50,000 on a supposedly better accounting system?" Question: How should the controller respond?arrow_forward
- Penny is compiling a list of costs incurred so far on a project. She must categorize these costs so that she can present the amount of direct cost incurred. Which of the following should Penny include in this list?This type of question contains radio buttons and checkboxes for selection of options. Use Tab for navigation and Enter or space to select the option. option A Expense incurred in meeting the regulatory standards for the company option B Benefits for employees in the organization option C Travel expenses to the customer’s office option D Costs incurred for maintaining coffee stations around the office.arrow_forwardThe controller of a retail company has just had a $50,000 request to implement an ABC system quickly turned down. A senior vice president, in rejecting the request, noted, “Given a choice, I will always prefer a $50,000 investment in improving things a customer sees or experiences, such as our shelves or our store layout. How does a customer benefit by our spending $50,000 on a supposedly better accounting system?” How should the controller respond?arrow_forwardYou are a newly hired accountant for Sushi Beeber, Inc., a retail company specializing in apparel for small pets. The company would like to expand its apparel line to include sweaters for cats. Sushi Beeber has found several manufacturers that offer competitive prices to ensure cost of goods sold is low. Because the company receives merchandise from different manufacturers and the cat sweaters will be commoditized, the company needs to develop an internal accounting system to keep track of inventory cost. You think that the weighted average cost method may help the company stay up-to-date with the inventory cost as purchase cost changes over time. Your task is to create a spreadsheet that can calculate the inventory cost based on purchases and sales for the month. See attached spreadsheet.-this has the information you need! The chart below is what I need to fill in. Inventory Weighted Date Purchase/Sale Total Cost Average Cost 1-Oct Purchase 1-Oct Sale 3-Oct…arrow_forward
- You are a newly hired accountant for Sushi Beeber, Inc., a retail company specializing in apparel for small pets. The company would like to expand its apparel line to include sweaters for cats. Sushi Beeber has found several manufacturers that offer competitive prices to ensure cost of goods sold is low. Because the company receives merchandise from different manufacturers and the cat sweaters will be commoditized, the company needs to develop an internal accounting system to keep track of inventory cost. You think that the weighted average cost method may help the company stay up-to-date with the inventory cost as purchase cost changes over time. Your task is to create a spreadsheet that can calculate the inventory cost based on purchases and sales for the month. To help you get started, the file already has a list of columns for you to fill out. Row 2 has the beginning inventory. Starting with row 3, you need to fill in each field so that you can find the updated inventory total…arrow_forwardYou are a newly hired accountant for Sushi Beeber, Inc., a retail company specializing in apparel for small pets. The company would like to expand its apparel line to include sweaters for cats. Sushi Beeber has found several manufacturers that offer competitive prices to ensure cost of goods sold is low. Because the company receives merchandise from different manufacturers and the cat sweaters will be commoditized, the company needs to develop an internal accounting system to keep track of inventory cost. You think that the weighted average cost method may help the company stay up-to-date with the inventory cost as purchase cost changes over time. Your task is to create a spreadsheet that can calculate the inventory cost based on purchases and sales for the month. See attached spreadsheet. nventory Weighted Date Purchase/Sale Total Cost Average Cost 1-Oct Purchase 1-Oct Sale 3-Oct Purchase 4-Oct Sale 4-Oct Sale 4-Oct Purchase 7-Oct Sale…arrow_forwardUrLink Company is a newly formed company specializing in high-speed Internet service for home and business. The owner, Lenny Kirkland, had divided the company into two segments: Home Internet Service and Business Internet Service. Each segment is run by its own supervisor, while basic selling and administrative services are shared by both segments.Lenny has asked you to help him create a performance reporting system that will allow him to measure each segment’s performance in terms of its profitability. To that end, the following information has been collected on the Home Internet Service segment for the first quarter of 2017. Budgeted Actual Service revenue $24,800 $25,000 Allocated portion of: Building depreciation 10,300 10,300 Advertising 4,700 4,200 Billing 3,200 3,200 Property taxes 1,100 1,200 Material and supplies 1,400 1,300 Supervisory salaries 9,400 9,400 Insurance 4,300 3,200 Wages…arrow_forward
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning