Managerial Accounting: Creating Value in a Dynamic Business Environment
11th Edition
ISBN: 9781259569562
Author: Ronald W Hilton Proffesor Prof, David Platt
Publisher: McGraw-Hill 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 159,000 kilometres during a year, the average operating cost is 12.0 cents ($0.120) per kilometre. If a truck is driven only 85,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.)
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.)
3. If a truck were driven 139,400 kilometres during a year, what total cost would you expect to be incurred? (Do not round intermediate calculations. Round the "Variable cost per kilometer" to 3 decimal places.)
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…
The 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?
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 - Madison County Airport handles several daily...Ch. 6 - Earth and Artistry, Inc. provides commercial...Ch. 6 - Prob. 48CCh. 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
- I need help with this accounting problemarrow_forwardABC Ltd., operates a fleet of delivery trucks in Singapore. The company has determined that if a truck is driven 126,000 kilometers during a year, the average operating cost is 13.3 cents per kilometer. If a truck is driven only 84,000 kilometers during a year, the average operating cost increases to 15.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 105,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 Variable cost per…arrow_forwardHoi 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_forward
- a) Provincial Packages, Inc. operates a local parcel delivery service. The company keeps detailed records relating to operating costs of trucks, and has found that if a truck is driven 122,000 kilometres per year, the operating cost is 8.5 cents per kilometre. This cost increases to 9.25 cents per kilometre if a truck is driven 72,000 kilometres per year. Required: Estimate the cost formula for truck operating costs using the high-low method. Accessibility: Investigate Focusarrow_forwardA piece of laborsaving equipment has just come onto the market that Mitsui Electronics, Ltd., could useto reduce costs in one of its plants in Japan. Relevant data relating to the equipment follow (currency is inthousands of yen, denoted by ¥):Purchase cost of the equipment ............. ¥432,000Annual cost savings that will beprovided by the equipment .................. ¥90,000Life of the equipment .............................. 12 yearsRequired:(Ignore income taxes.)1. Compute the payback period for the equipment. If the company requires a payback period of fouryears or less, would the equipment be purchased?2. Compute the simple rate of return on the equipment. Use straight-line depreciation based on theequipment’s useful life. Would the equipment be purchased if the company’s required rate of returnis 14%?arrow_forwardThank you.arrow_forward
- Speedy Parcel Service operates a fleet of delivery trucks in a large metropolitan area. A careful study by the company's cost analyst has determined that if a truck is driven 120,000 miles during a year, the average operating cost is 11.6 cents per mile. If a truck is driven only 80,000 miles during a year, the average operating cost increases to 13.6 cents per mile. Required: 1. Using the high-low method, estimate the variable and fixed cost elements of the annual cost of truck operation. 2. Express the variable and fixed costs in the form Y = a + bX. 3. If a truck were driven 100,000 miles during a year, what total cost would you expect to be incurred?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_forwardParker Pottery produces a line of vases and a line of ceramic figurines. Each line uses the sameequipment and labor; hence, there are no traceable fixed costs. Common fixed cost equals$30,000. Parker’s accountant has begun to assess the profitability of the two lines and has gathered the following data for last year: Required:1. Compute the number of vases and the number of figurines that must be sold for thecompany to break even.2. Parker Pottery is considering upgrading its factory to improve the quality of its products.The upgrade will add $5,260 per year to total fixed cost. If the upgrade is successful, theprojected sales of vases will be 1,500, and figurine sales will increase to 1,000 units. Whatis the new break-even point in units for each of the products?arrow_forward
- Howard Cooper, the president of Thornton Computer Services, needs your help. He wonders about the potential effects on the firm's net income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal Year 3. Standard rate and variable costs Service rate per hour Labor cost Overhead cost Selling, general, and administrative cost Expected fixed costs Facility maintenance Selling, general, and administrative Required: a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 42,000 hours of services in Year 3. b. A marketing consultant suggests to Mr. Cooper that the service rate may affect the number of service hours that the firm can achieve. According to the consultant's analysis, if Thornton charges customers $79 per hour, the firm can achieve 48,000 hours of services. Prepare a flexible budget using the consultant's assumption. c. The same consultant also suggests that if the…arrow_forwardExercise 10-32 (Algo) Activity-Based Costing of Customers (LO 10-3, 4) Northwestern Bank (NB) offers only checking accounts. Customers can write checks and use a network of automated teller machines. NB earns revenue by investing the money deposited; currently, it averages 4.1 percent annually on its investments of those deposits. To compete with larger banks, NB pays depositors 0.3 percent on all deposits. A recent study classified the bank's annual operating costs into four activities. Activity Using ATM Visiting branch Processing transactions Managing functions Total overhead Cost Driver Number of uses Number of visits Number of transactions Total deposits Cost $ 1,936,800 1,900,800 8,521,920 7,321,600 $ 19,681,120 Driver Volume 3,228,000 uses 396,000 visits 129,120,000 transactions $ 615,035,000 in deposits Data on two representative customers follow: Emily Jacob ATM uses 40 130 Branch visits 5 Number of transactions Average deposit 200 45 520 $ 10,000 $ 10,000arrow_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
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
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
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