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 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
Java Joe coffees wants to find an equation to estimate monthly utility costs. Java Joe's has been in business for one year and has collected the following cost data for utilities
1.which of the preceding costs is variable? Fixed? Mixed? Explain
2. using the high-low method, determine the cost function for each cost
3. combine the preceding information to get a monthly utility cost function for Java
4. next month, Java's expects to use 2200 kilowatt hours of electricity, make 1500 minutes of telephone calls and use 32000 gallons of water. Estimate total cost of utilities for the month
Month
Electricity
bill
Kilowatt hours used
telefone
telefone
min used
Water
bill
Gallonsof water used
January
$360
1200
$92.00
1100
$60
30560
February
$420
1400
$91.80
1060
$60
26800
March
$549
1830
$94.80
1240
$60
31450
April
$405
1350
$89.60
980
$60
29965
May
$588
1960
$98.00
1400
$60
30568
June
$624
2080…
Slarlet Beauty manufactures and sells a face cream lo small specialy stores in the greater Los Angeles area. It presents the monthly operating income stalement shown here to George Diaz, a polenial investor in the business. Help Mr. Diaz
understand Starlet Beauty's cost structure.
E(Click the icon to view the operating income stalement.)
Read the equirements.
Data Table
Requirement 1. Recast the income statement to emphasize contribution margin.
Starlet Cosmetics
Operating Income Statement, June 2017
Starlet Beauty
Operating Income Statement, June 2017
10,000
Units sold
Revenues
200,000
Cost of goods sold
Variable manufacturing costs
80,000
32,900
Fixed manufacturing costs
112,900
Total
Gross margin
87,100
Operating costs
Variable marketing costs
48,000
17.500
Fixed marketing and administrative costs
65,500
Total operating costs
21,600
Operating income
Print
Done
Choose from any list or enter any number in the input fields and then click Check Answer.
Ethan Manufacturing Incorporated produces floor mats for automobiles. The owner, Joseph Ethan, has asked you to assist in estimating maintenance costs. Together, you and Joseph determine that the single best cost driver for maintenance costs is machine hours. These data are from the previous fiscal year for maintenance costs and machine hours:
1. What is the cost equation for maintenance costs using the high-low method?
2. Calculate the mean absolute percentage error (MAPE) for the cost equation you developed in requirement 1.
Month
Maintenance Costs
Machine Hours
1
$ 2,660
1,750
2
2,820
1,830
3
2,970
1,910
4
3,080
1,930
5
3,160
1,960
6
3,130
1,940
7
3,070
1,920
8
2,910
1,900
9
2,680
1,760
10
2,280
1,160
11
2,290
1,360
12
2,510
1,650
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
- Lucerne pizza is a small neighborhood pizzeria that has a small area for in-store dining as well offering takeout and free home delivery services. The pizzeria’s owner has determined that the shop has two major cost drivers—the number of pizzas sold and the number of deliveries made. Data concerning the pizzeria’s costs appear below: Fixed Cost per Month Cost per Pizza Cost per Delivery Pizza ingredients ................ $5.00 Kitchen staff ...................... $5,800 Utilities .............................. 520 $.10 Delivery person .................. $2.90 Delivery vehicle .................. 680 $2.10 Equipment depreciation ...... 387 Rent .................................. 1,730 Miscellaneous ..................... 730 $.01 In October, the pizzeria budgeted for 2,000 pizzas at an average selling price of $13.00 per pizza and for 190 deliveries. Data concerning the pizzeria’s…arrow_forwardMilano Pizza is a small neighborhood pizzeria that has a small area for in-store dining as well as offering take-out and free home delivery services. The pizzeria's owner has determined that the shop has two major cost drivers-the number of pizzas sold and the number of deliveries made. The pizzeria's cost formulas appear below: Fixed Cost per Month Pizza ingredients Kitchen staff Utilities Delivery person Delivery vehicle. Equipment depreciation Rent Miscellaneous Pizzas Deliveries Revenue Pizza ingredients. Excee Kitchen staff n+ili+ Utilities Delis Delivery person Delivery vehicle Equipment depreciation. Rent Miscellaneous $ 6,090 $ 700 Pizzas Deliveries Revenue Expenses: $ 720 $ 472 Pizza ingredients Kitchen staff $ 2,050 $ 820 In November, the pizzeria budgeted for 1,830 pizzas at an average selling price of $16 per pizza and for 230 deliveries. Data concerning the pizzeria's actual results in November were as follows: Actual Results 1,930 210 520 $ 31,520 930 $ 8,830 $ 6,030 $930…arrow_forwardWindows is a small company that installs windows. Its cost structure is as follows: LOADING... (Click the icon to view the cost structure.) Traylor Windows' breakeven revenues is $1,870,000 and breakeven units is 3,400. Calculate the margin of safety in units and dollars and the margin of safety percentage if Traylor Windows expects to sell 3,600 windows in the year. Begin with calculating the margin of safety in dollars. Determine the formula to calculate the margin of safety in dollars. Then, enter the amounts and calculate the margin of safety in dollars. Budgeted revenue - Breakeven revenue = Margin of safety in dollars - = Next, determine the formula, enter the amounts, and calculate the margin of safety in units. Budgeted units - Breakeven units = Margin of safety in units - = Finally, calculate the margin of safety percentage if…arrow_forward
- 1) 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_forwardBargain 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_forward
- 4arrow_forwardMemanarrow_forwardMilano Pizza is a small neighborhood pizzeria that has a small area for in-store dining as well as offering take-out and free home delivery services. The pizzeria's owner has determined that the shop has two major cost drivers-the number of pizzas sold and the number of deliveries made. The pizzeria's cost formulas appear below: Fixed Cost per Month Pizza ingredients Kitchen staff Utilities Delivery person Delivery vehicle Equipment depreciation Rent Miscellaneous Pizzas Deliveries Revenue Pizza ingredients Kitchen staff Utilities Delivery person Delivery vehicle Equipment depreciation Rent $ 5,910 $ 610 Miscellaneous $ 630 $ 400 $ 1,870 $ 730 In November, the pizzeria budgeted for 1,560 pizzas at an average selling price of $15 per pizza and for 220 deliveries. Data concerning the pizzeria's actual results in November appear below: Actual Results. 1,660 200 $ 25,450 $ 7,210 $ 5,850 $ 885 $ 620 $ 986 $ 400 Cost per Pizza $ 4.40 $ 1,870 $ 790 $ 0.30 Cost per Delivery $ 0.15 $ 3.10 $…arrow_forward
- am. 130.arrow_forwardDeveloping an Equation from Average CostsParadise Pub is a high-end dog hotel located in New York. Assume that in March, when dog-days occupancy was at an annual low of 500 days, the average cost per dog-day was $26. In July, when dog-days were at a capacity level of 4,500, the average cost per dog-day was $10.(a) Develop an equation for monthly operating costs. (Let X = dog-days per month)Total cost = $ _________ + $ _________ * _______ (b) Determine the average cost per dog-day at an annual volume of 28,000 dog-days. (Round to the nearest cent.) $ ___________arrow_forwardMilano Pizza is a small neighborhood pizzeria that has a small area for in-store dining as well as offering take-out and free home delivery services. The pizzeria's owner has determined that the shop has two major cost drivers-the number of pizzas sold and the number of deliveries made. The pizzeria's cost formulas appear below: Fixed Cost per Month Pizza ingredients Kitchen staff Utilities Delivery person Delivery vehicle Equipment depreciation Rent Miscellaneous 4 Pizzas Deliveries Revenue Pizza ingredients Kitchen staff Utilities Delivery person Delivery vehicle. Equipment depreciation Rent Miscellaneous Pizzas Deliveries Revenue Expenses: Pizza ingredients Kitchen staff Utilities Delivery person Delivery vehicle Equipment depreciation Rent $ 6,250 $ 780 $ 0.10 In November, the pizzeria budgeted for 2,070 pizzas at an average selling price of $16 per pizza and for 230 deliveries. Data concerning the pizzeria's actual results in November were as follows: Miscellaneous Total expense…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
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
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
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
What is Risk Management? | Risk Management process; Author: Educationleaves;https://www.youtube.com/watch?v=IP-E75FGFkU;License: Standard youtube license