Managerial Accounting: Creating Value in a Dynamic Business Environment
12th Edition
ISBN: 9781260417074
Author: HILTON, Ronald
Publisher: MCGRAW-HILL HIGHER EDUCATION
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 6, Problem 30E
Rio Bus Tours has incurred the following bus maintenance costs during the recent tourist season. (The real is Brazil’s national monetary unit. On the day this exercise was written, the real was equivalent in value to .269 U.S. dollar.)
Required:
- 1. Use the high-low method to estimate the variable cost per tour mile traveled and the fixed cost per month.
- 2. Develop a formula to express the cost behavior exhibited by the company’s maintenance cost.
- 3. Predict the level of maintenance cost that would be incurred during a month when 22.000 tour miles are driven. (Remember to express your answer in terms of the real.)
- 4. Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements. Show how the solution will change it the following information changes: in March there were 21,000 miles traveled and the cost was 12,430 real.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
We Deliver operates a fleet of delivery trucks in Halifax. Analysis shows that if a truck is driven 150,000 kilometres during a year, the
average operating cost is 11.9 cents ($0.119) per kilometre. If a truck is driven only 94,000 kilometres during a year, the average
operating cost increases to 13.9 cents ($0.139) per kilometre.
Required:
1. Using the high-low method, estimate the variable and fixed cost elements of the annual cost of truck operation. (Do not round your
intermediate calculations. Round the "Variable cost per kilometer" to 3 decimal places.)
High level of activity
Low level of activity
Change
Variable cost per kilometer
Fixed cost per year
=
Kilometers
Driven
2. Express the variable and fixed costs in the form Y= a + bX. (Do not round your intermediate calculations. Round the "Variable cost
per kilometer" to 3 decimal places.)
Total Annual
Cost
Total annual cost
3. If a truck were driven 127,000 kilometres during a year, what total cost would you expect to be…
Hoi Chong Transport, Limited, operates a fleet of delivery trucks in Singapore. The company has determined that if a truck is driven
93,000 kilometers during a year, the average operating cost is 9.2 cents per kilometer. If a truck is driven only 62,000 kilometers
during a year, the average operating cost increases to 9.9 cents per kilometer.
Required:
1. Using the high-low method, estimate the variable operating cost per kilometer and the annual fixed operating cost associated with
the fleet of trucks.
2. Express the variable and fixed costs in the form Y = a + bX.
3. If a truck were driven 77,500 kilometers during a year, what total operating cost would you expect to be incurred?
Habib transport company Itd, operates a fleet of delivery trucks in Singapore. The Company has determined that if a truck is driven 135,000 kilometers during a year, The average operating cost is 11.8 cent per kilometers. If a truck driven 95,000 kilometers during a year, the average operating cost increases to 13.6 cents per kilometers.
Requirement
a) Using high-low method estimate the variable and fixed costs elements of the annual cost of truck operators.
b) Express the variable and fixed costs in the form y= a +bx
e) if a truck were driven to 100,000 kilometers during a year, what total cost would you expect to be incurred?
Chapter 6 Solutions
Managerial Accounting: Creating Value in a Dynamic Business Environment
Ch. 6 - Describe the importance of cost behavior patterns...Ch. 6 - Define the following terms, and explain the...Ch. 6 - Suggest an appropriate activity base (or cost...Ch. 6 - Draw a simple graph of each of the following types...Ch. 6 - Explain the impact of an increase in the level of...Ch. 6 - Explain why a manufacturers cost of supervising...Ch. 6 - Explain the impact of an increase in the level of...Ch. 6 - Prob. 8RQCh. 6 - Indicate which of the following descriptions is...Ch. 6 - Prob. 10RQ
Ch. 6 - What is meant by a learning curve? Explain its...Ch. 6 - Suggest an appropriate independent variable to use...Ch. 6 - What is an outlier? List some possible causes of...Ch. 6 - Explain the cost estimation problem caused by...Ch. 6 - Describe the visual-fit method of cost estimation....Ch. 6 - What is the chief drawback of the high-low method...Ch. 6 - Explain the meaning of the term least squares in...Ch. 6 - Prob. 18RQCh. 6 - Prob. 19RQCh. 6 - List several possible cost drivers that could be...Ch. 6 - Prob. 21RQCh. 6 - Prob. 22ECh. 6 - The behavior of the annual maintenance and repair...Ch. 6 - WMEJ is an independent television station run by a...Ch. 6 - Jonathan Macintosh is a highly successful...Ch. 6 - Jonathan Macintosh is a highly successful...Ch. 6 - The Iowa City Veterinary Laboratory performs a...Ch. 6 - Chillicothe Meat Company produces one of the best...Ch. 6 - Rio Bus Tours has incurred the following bus...Ch. 6 - Prob. 31ECh. 6 - Prob. 32ECh. 6 - Prob. 33ECh. 6 - Gator Beach Marts, a chain of convenience grocery...Ch. 6 - For each of the cost items described below, choose...Ch. 6 - The following selected data were taken from the...Ch. 6 - Antioch Extraction, which mines ore in Montana,...Ch. 6 - Nations Capital Fitness, Inc. operates a chain of...Ch. 6 - The Allegheny School of Music has hired you as a...Ch. 6 - Prob. 40PCh. 6 - (Note: Instructors who wish to cover all three...Ch. 6 - Refer to the original data in the preceding...Ch. 6 - Shortly after being hired as an analyst with...Ch. 6 - The controller of Chittenango Chain Company...Ch. 6 - Dana Rand owns a catering company that prepares...Ch. 6 - Prob. 48PCh. 6 - Earth and Artistry, Inc. provides commercial...Ch. 6 - Prob. 51CCh. 6 - Refer to the data and accompanying information in...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Hoi Chong Transport, Limited, operates a fleet of delivery trucks in Singapore. The company has determined that if a truck is driven 162,000 kilometers during a year, the average operating cost is 13.2 cents per kilometer. If a truck is driven only 108,000 kilometers during a year, the average operating cost increases to 16.6 cents per kilometer. Required: 1. Using the high-low method, estimate the variable operating cost per kilometer and the annual fixed operating cost associated with the fleet of trucks. 2. Express the variable and fixed costs in the form Y = a + bX. 3. If a truck were driven 135,000 kilometers during a year, what total operating cost would you expect to be incurred? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Variable cost Fixed cost Required 3 Using the high-low method, estimate the variable operating cost per kilometer and the annual fixed operating cost associated with the fleet of trucks. (Do not round your…arrow_forwardLucky Transport, Ltd., operates a fleet of delivery trucks in the United States. The company has determined that if a truck is driven 105,000 kilometers during a year, the average operating cost is 11.4 cents per kilometer. If a truck is driven only 70,000 kilometers during a year, the average operating cost increases to 13.4 cents per kilometer. 1. Using the high-low method, determine the following: a. Variable Cost per kilometer b. Fixed Cost per year 2. If a truck was driven 80,000 kilometers during a year, what total cost would you expect to be incurred?arrow_forwardThe Mayflower Transport Company operates a fleet of delivery trucks in the Ottawa area. It has been determined that if a truck is driven 105,000 kilometers over a one year period the average operating cost is $0.114 per kilometer. If a truck is driven only 70,000 kilometers annually, the operating costs increases to $0.134 per kilometer. a) Using the high-low method, estimate the variable and fixed cost elements of the annual cost of truck operation. b) Using the formula Y=a + bX, present the fixed and variable costs. c) If a truck were driven 80,000 kilometers over a one year period, what total cost would your expect to be incurred?arrow_forward
- Hoi Chong Transport, Limited, operates a fleet of delivery trucks in Singapore. The company has determined that if a truck is driven 96,000 kilometers during a year, the average operating cost is 10.3 cents per kilometer. If a truck is driven only 64,000 kilometers during a year, the average operating cost increases to 11.5 cents per kilometer. Required: 1. Using the high-low method, estimate the variable operating cost per kilometer and the annual fixed operating cost associated with the fleet of trucks. 2. Express the variable and fixed costs in the form Y = a + bX. 3. If a truck were driven 80,000 kilometers during a year, what total operating cost would you expect to be incurred? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Using the high-low method, estimate the variable operating cost per kilometer and the annual fixed operating cost associated with the fleet of trucks. Note: Do not round your intermediate calculations. Round…arrow_forwardHoi Chong Transport, Limited, operates a fleet of delivery trucks in Singapore. The company has determined that if a truck is driven 105,000 kilometers during a year, the average operating cost is 11.4 cents per kilometer. If a truck is driven only 70,000 kilometers during a year, the average operating cost increases to 13.4 cents per kilometer. Required: 1. Using the high-low method, estimate the variable operating cost per kilometer and the annual fixed operating cost associated with the fleet of trucks. 2. Express the variable and fixed costs in the form Y = a + bx. 3. If a truck were driven 80,000 kilometers during a year, what total operating cost would you expect to be incurred? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Using the high-low method, estimate the variable operating cost per kilometer and the annual fixed operating cost associated with the fleet of trucks. (Do not round your intermediate calculations. Round the…arrow_forwardABC Ltd., operates a fleet of delivery trucks in Singapore. The company has determined that if a truck is driven 138,000 kilometers during a year, the average operating cost is 14.8 cents per kilometer. If a truck is driven only 92,000 kilometers during a year, the average operating cost increases to 18.6 cents per kilometer. Required: 1. Using the high-low method, estimate the variable operating cost per kilometer and the annual fixed operating cost associated with the fleet of trucks. 2. Express the variable and fixed costs in the form Y = a + bx. 3. If a truck were driven 115,000 kilometers during a year, what total operating cost would you expect to be incurred?arrow_forward
- Hoi Chong Transport, Ltd., operates a fleet of delivery trucks in Singapore. The company has determined that if a truck is driven 93,000 kilometers during a year, the average operating cost is 9.2 cents per kilometer. If a truck is driven only 62,000 kilometers during a year, the average operating cost increases to 9.9 cents per kilometer. Using the high-low method, estimate the variable operating cost per kilometer and the annual fixed operating cost associated with the fleet of trucks. (Do not round your intermediate calculations. Round the Variable cost per kilometer to 3 decimal places.) Express the variable and fixed costs in the form Y = a + bX. (Do not round your intermediate calculations. Round the Variable cost per kilometer to 3 decimal places.) If a truck were driven 77,500 kilometers during a year, what total operating cost would you expect to be incurred? (Do not round intermediate calculations.)arrow_forwardAmarjit Truckers, Ltd. operates a fleet of delivery trucks in North America. The company has determined that, if a truck is driven 120,000 kilometres during a year, the average operating cost is 18.000 cents per kilometre. If a truck is driven only 50,000 kilometres during a year, the average operating cost increases to 21.0 cents per kilometre. Required: 1. Using the high - low method, estimate the variable and fixed cost elements of the annual cost of truck operation. (Do not round intermediate calculations. Round the "Variable cost" to 5 decimal places. Round "Fixed cost" to 2 decimal places.) 2. Express the variable and fixed costs in the form Y = a + bX. (Do not round intermediate calculations. Round the "Variable cost" to 5 decimal places. Round "Fixed cost" to 2 decimal places.) 3. If a truck were driven 80,000 kilometres during a year, what total cost would you expect to be incurred? (Do not round intermediate calculations. Round "Total annual cost" to 2 decimal places.)arrow_forwardSuppose that a manufacturer can produce a part for $11.00 with a fixed cost of $7,000. Alternately, the manufacturer could contract with a supplier in Asia to purchase the part at a cost of $13.00, which includes transportation. a. If the anticipated production volume is 1,300 units, compute the total cost of manufacturing and the total cost of outsourcing. b. What is the best decision? a. The total cost of manufacturing is $.arrow_forward
- Check my work mode: This shows what is correct or incorrect for the work you have completed so far. It does not indicate completic Hoi Chong Transport, Limited, operates a fleet of delivery trucks in Singapore. The company has determined that if a truck is driven 105,000 kilometers during a year, the average operating cost is 11.4 cents per kilometer. If a truck is driven only 70,000 kilometers during a year, the average operating cost increases to 13.4 cents per kilometer. Required: 1. Using the high-low method, estimate the variable operating cost per kilometer and the annual fixed operating cost associated with the fleet of trucks. 2. Express the variable and fixed costs in the form Y = a +bX. 3. If a truck were driven 80,000 kilometers during a year, what total operating cost would you expect to be incurred? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Answer is complete but not entirely correct. If a truck were driven 80,000…arrow_forwardİzmir Forwarding’s transport price for one pallet of paint is TL80/km. in a certain route. Variable costs per unit equal TL32. The company expects total fixed costs to be TL72,000 for the next month at the projected transport level of 2,000 pallets. In an attempt to improve performance, management is considering a number of alternative actions. Each situation is to be evaluated separately. a) Suppose management believes that a TL16,000 increase in the monthly advertising expense will result in a considerable increase in sales. Sales must increase by how much to cover additional expenditure? b) Suppose that management believes that a 10% decrease in the selling price will result in a 10% increase in sales. If this proposed decrease in selling price is implemented, compute the change in the operating income. c) Write an alternative action for the company your own, to improve the performance, compute the change in the operating income. d) Which alternative (A, B, C) should be chosen?…arrow_forwardPlease help me find fixed costs. Oak Island Amusements Center provides the following data on the costs of maintenance and the number of visitors for the last three years. Number of Visitors per Year (thousands) Maintenance Costs($000) 1,825 $ 2,925 2,007 3,225 2,375 3,750 Required: a. Use the high-low method to estimate the fixed cost of maintenance annually and the variable cost of maintenance per visitorarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSON
Intermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill Education
Financial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education
How to Estimate Project Costs: A Method for Cost Estimation; Author: Online PM Courses - Mike Clayton;https://www.youtube.com/watch?v=YQ2Wi3Jh3X0;License: Standard Youtube License