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 34E
Gator Beach Marts, a chain of convenience grocery stores in the Fort Lauderdale area, has store hours that fluctuate from month to month as the tourist trade in the community varies. The utility costs for one of the company’s stores are listed below for the past six months.
- 1. Use the high-low method to estimate the cost behavior for the store’s utility costs. Express the cost behavior in formula form (Y = a + bX). What is the variable utility cost per hour of operation?
- 2. Draw a scatter diagram of the store’s utility costs. Visually fit a cost line to the plotted data. Estimate the variable utility cost per hour of operation.
- 3. Build a spreadsheet: Construct an Excel spreadsheet and use the Excel commands to perform a least-squares regression. Estimate the cost behavior for the store’s utility cost. Express the cost behavior in formula form. What is the variable utility cost per hour of operation?
- 4. During July, the store will be open 300 hours. Predict the store’s total utility cost for July using each of the cost-estimation methods employed in requirements (1). (2), and (3).
- 5. Use your Excel sheet from requirement (3) to calculate and interpret the R2 value for the regression.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Tucker Pup’s Pet Resort offers dog boarding services in Chicago. Assume that in March, when dog- days occupancy was at an annual low of 150 days, the average cost per dog-day was $65. In July, when dog-days were at a capacity level of 600, the average cost per dog-day was $20.
a.Develop an equation for monthly operating costs.
b.Determine the average boarding cost per dog-day at an annual volume of 4,500 dog-days.
Tucker Pup's Pet Resort offers dog boarding services in Chicago. Assume that in March, when dog- days occupancy was at
an annual low of 150 days, the average cost per dog-day was $65. In July, when dog-days were at a capacity level of 600,
the average cost per dog-day was $20.
a. Develop an equation for monthly operating costs.
b.Determine the average boarding cost per dog-day at an annual volume of 4,500 dog-days.
Using the high-low method
Mark, owns a machine shop. In reviewing the shop’s utility bills for the past 12 months, he found that the highest bill of $2,600 occurred in August when the machines worked 1,200 machine hours. The lowest utility bill of $2,300 occurred in December when the machines worked 600 machine hours.
Requirements
Use the high—low method to calculate the variable cost per machine hour and the total fixed utility cost.
Show the equation for determining the total utility cost for the machine shop.
If Mark anticipates using 800 machine hours in January, predict the shop’s total utility bill using the equation from Requirement 2.
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
- 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_forwardHoward Cooper, the president of Stuart 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 30,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 Stuart charges customers $80 per hour, the firm can achieve 36,000 hours of services. Prepare a flexible budget using the consultant's assumption. c. The same consultant also suggests that if the firm…arrow_forward1) Your delivery business uses a rental truck, In an attempt to estimate future truck rental costs you have collected the following information: Month Miles driven Rental cost of truck January February 600 $585 620 588 March 580 574 April 640 591 May 700 610 June 680 598 If you drive the truck 640 miles in July, what should the total rental cost be? Use the high/low method. Do you think this is a decent estimate of what the cost will be? Why?arrow_forward
- Bargain Rental Car wants to better understand the variable and fixed portions of its car washing costs. The company operates its own car wash facility that cleans each rental car before releasing it to another customer. Management believes the variable portion of its car washing costs relates to the number of rental returns. Accordingly, the following data have been compiled: Month January February March April May June July August September October November December Rental Returns 2,500 2,500 2,800 3,100 3,700 5,200 5,600 5,700 4,800 4,900 Fixed cost per month Variable cost per rental return 2,300 3,100 Exercise 5A-2 Part 2 (Algo) Car Wash Costs $ 11,800 $ 13,500 $ 12,600 $ 15,500 $ 17,000 $ 24,900 $ 23,000 $ 24,200 $ 23,600 $ 23,500 $ 11,500 $ 17,000 2. Using least-squares regression; estimate the variable cost per rental return and the monthly fixed cost incurred to wash cars. Note: Round Fixed cost to the nearest whole dollar amount and the Variable cost per unit to 2 decimal…arrow_forwardHorton Manufacturing Incorporated produces blinds and other window treatments for residential homes and offices. The owner is concerned about the maintenance costs for the production machinery because maintenance costs for the previous fiscal year were higher than he expected. The owner has asked you to assist in estimating future maintenance costs to better predict the firm's profitability. Together, you have determined that the best cost driver for maintenance costs is machine hours. The data from the previous fiscal year for maintenance costs and machine hours follow: Month 1 3 4 6 7 8 9 10 11 12 Maintenance Costs Machine Hours $ 2,665 2,710 2,760 2,860 2,895 3,045 2,905 2,945 2,820 2,610 2,630 2,930 Maintenance cost 1,566 1,670 1,685 1,735 1,855 1,890 1,865 1,885 1,775 1,450 1,630 1,465 Required: 1. Use the high-low method to estimate the fixed and variable portions for maintenance costs. (In your calculations, round "slope (unit variable cost)" to 4 decimal places. Enter the…arrow_forwardRe Espresso Express operates a number of espresso coffee stands in busy suburban malls. The fixed weekly expense of a coffee stand is $2,300 and the variable cost per cup of coffee served is $0.33. Required: 1. Fill in the following table with your estimates of the company's total cost and average cost per cup of coffee at the indicated levels of activity. 2. Does the average cost per cup of coffee served increase, decrease, or remain the same as the number of cups of coffee served in a week increases? X Answer is not complete. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Fill in the following table with your estimates of the company's total cost and average cost per cup of coffee at the indicated levels of activity. (Round the "Average cost per cup of coffee served" to 3 decimal places.) Cups of Coffee Served in a Week 2,000 2,100 2,200 Fixed cost Variable cost Total cost Average cost per cup of coffee served 124 A 22 $ 0 $ Barrow_forward
- Espresso Express operates a number of espresso coffee stands in busy suburban malls. The fixed weekly expense of a coffee stand is $700 and the variable cost per cup of coffee served is $0.50. Required: 1. Fill in the following table with your estimates of the company's total cost and average cost per cup of coffee at the indicated levels of activity. 2. Does the average cost per cup of coffee served increase, decrease, or remain the same as the number of cups of coffee served in a week increases? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Does the average cost per cup of coffee served increase, decrease, or remain the same as the number of cups of coffee served in a week increases? Average cost per cup of coffeearrow_forwardEspresso Express operates a number of espresso coffee stands in busy suburban malls. The fixed weekly expense of a coffee stand is $700 and the variable cost per cup of coffee served is $0.50. Required: 1. Fill in the following table with your estimates of the company's total cost and average cost per cup of coffee at the indicated levels of activity. 2. Does the average cost per cup of coffee served increase, decrease, or remain the same as the number of cups of coffee served in a week increases? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Fill in the following table with your estimates of the company's total cost and average cost per cup of coffee at the indicated levels of activity. Note: Round the "Average cost per cup of coffee served" to 3 decimal places. Fixed cost Variable cost Total cost Average cost per cup of coffee served $ 500 Cups of Coffee Served in a Week 600 0 $ 0arrow_forwardHorton Manufacturing Incorporated produces blinds and other window treatments for residential homes and offices. The owner is concerned about the maintenance costs for the production machinery because maintenance costs for the previous fiscal year were higher than he expected. The owner has asked you to assist in estimating future maintenance costs to better predict the firm's profitability. Together, you have determined that the best cost driver for maintenance costs is machine hours. The data from the previous fiscal year for maintenance costs and machine hours follow: Month Maintenance Costs Machine Hours $ 2,665 2,710 2,760 1 2 3 4 6 7 8 9 10 11 12 2,860 2,895 Maintenance cost 3,045 2,905 2,945 2,820 2,610 2,630 2,930 1,566 1,670 1,685 1,735 1,855 1,890 1,865 1,885 1,775 1,450 1,630 1,465 Required: 1. Use the high-low method to estimate the fixed and variable portions for maintenance costs. (In your calculations, round "slope (unit variable cost)" to 4 decimal places. Enter the…arrow_forward
- Espresso Express operates a number of espresso coffee stands in busy suburban malls. The fixed weekly expense of a coffee stand is $2,100 and the variable cost per cup of coffee served is $0.16. Required: 1. Fill in the following table with your estimates of the company's total cost and average cost per cup of coffee at the indicated levels of activity. 2. Does the average cost per cup of coffee served increase, decrease, or remain the same as the number of cups of coffee served in a week increases? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Does the average cost per cup of coffee served increase, decrease, or remain the same as the number of cups of coffee served in a week increases? Increase Decrease Remain the samearrow_forwardEspresso Express operates a number of espresso coffee stands in busy suburban malls. The fixed weekly expense of a coffee stand is $2,100 and the variable cost per cup of coffee served is $0.18. Required: 1. Fill in the following table with your estimates of the company's total cost and average cost per cup of coffee at the indicated levels of activity. 2. Does the average cost per cup of coffee served increase, decrease, or remain the same as the number of cups of coffee served in a week increases? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Fill in the following table with your estimates of the company's total cost and average cost per cup of coffee at the indicated levels of activity. (Round the "Average cost per cup of coffee served" to 3 decimal places.) Fixed cost Variable cost Total cost Average cost per cup of coffee served $ Cups of Coffee Served in a Week 2,300 2,200 0 $ 0arrow_forwardEspresso Express operates a number of espresso coffee stands in busy suburban malls. The fixed weekly expense of a coffee stand is $500 and the variable cost per cup of coffee served is $0.49. Required: Fill in the following table with your estimates of the company's total cost and average cost per cup of coffee at the indicated levels of activity. Does the average cost per cup of coffee served increase, decrease, or remain the same as the number of cups of coffee served in a week increases?arrow_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
What is Risk Management? | Risk Management process; Author: Educationleaves;https://www.youtube.com/watch?v=IP-E75FGFkU;License: Standard youtube license