Managerial Accounting
3rd Edition
ISBN: 9780077826482
Author: Stacey M Whitecotton Associate Professor, Robert Libby, Fred Phillips Associate Professor
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Question
Chapter 5, Problem 1.1GBP
To determine
Introduction:
Scattered graph:
It is a graph that shows the relationship between X-axis and the Y-axis. It helps determine the relation between the data shown on both the axis and their linearity.
To prepare:
Scattered graph and suitable line on the graph.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Odle Company manufactures a popular brand of cat repellant known as Cat-B-Gone, which it sells in gallon-size bottles with a spray
attachment. The majority of Odie's business comes from orders placed by homeowners who are trying to keep neighborhood cats out
of their yards. Odie's operating information for the first six months of the year follows:
Month
January
February
March
April
May
June
Number of
Bottles Sold
1,000
1,100
1,300
2,000
2,400
3,000
Operating
Cost
$ 8,000
7,700
9,900
14,000
17,250
20,000
Required:
3. Using the high-low method, calculate Odie's total fixed operating costs and variable operating cost per bottle.
4. Perform a least-squares regression analysis on Odie's data.
5. Determine how well this regression analysis explains the data.
6. Using the regression output, create a linear equation (y a+ bx) for estimating Odie's operating costs.
Horton 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,695
2,740
2,790
2,890
2,925
3,025
2,935
1
2
3
4
56789012
10
11
2,975
2,850
2,640
2,660
2,960
Maintenance cost
1,620
1,730
1,745
1,795
1,790
1,890
1,810
1,845
1,835
1,480
1,690
1,495
Required:
1. Use the high-low method to estimate the fixed and variable portions for maintenance costs. (In your calculations, round "slope (uni
variable cost)" to 4 decimal places. Enter the "slope…
Albedo Incorporated manufactures high-end replacement telescope lenses for amateur and professional
astronomers who are seeking to upgrade the performance of their telescopes. You have just become employed as
a staff accountant at Albedo, and Jordan Coleman, the controller, has asked you to help with maintenance cost
estimation for the lens manufacturing process. You review the manufacturing process and decide that the best
cost driver for maintenance costs is machine hours. The data below are from the previous fiscal year for
maintenance costs and machine hours:
Month Maintenance Costs Machine Hours
$ 3,210
4,650
5,175
3,350
3,100
1
2
3
4
5
6
7
8
9
10
11
12
2,950
2,900
2,900
4,120
4,350
3,500
3,775
2,750
3,900
4,050
2,690
2,500
2,580
2,300
2,500
3,160
3,325
2,780
3,000
Required:
1. What is the cost equation for maintenance costs using the high-low method? (Round "slope (unit variable cost)"
to 2 decimal places. Negative amounts should be indicated by a minus sign.)
Chapter 5 Solutions
Managerial Accounting
Ch. 5 - Define each of the following terms variable cost,...Ch. 5 - Prob. 2QCh. 5 - Prob. 3QCh. 5 - Prob. 4QCh. 5 - Prob. 5QCh. 5 - Describe the three methods used to estimate cost...Ch. 5 - Prob. 7QCh. 5 - Prob. 8QCh. 5 - Prob. 9QCh. 5 - Prob. 10Q
Ch. 5 - Prob. 11QCh. 5 - Prob. 12QCh. 5 - Prob. 13QCh. 5 - Prob. 14QCh. 5 - Which of the following increases when activity...Ch. 5 - Prob. 2MCCh. 5 - Prob. 3MCCh. 5 - Consider the following information for a local...Ch. 5 - Prob. 5MCCh. 5 - Prob. 6MCCh. 5 - Prob. 7MCCh. 5 - Prob. 8MCCh. 5 - Prob. 9MCCh. 5 - Hathaway Corp, manufactures garden hoses. Last...Ch. 5 - Identifying Cost Behavior Heather Oak is trying to...Ch. 5 - Prob. 2MECh. 5 - Defining Cost Behavior Match each of the following...Ch. 5 - Prob. 4MECh. 5 - Defining Terms for the High-Low Method Indicate...Ch. 5 - Prob. 6MECh. 5 - Prob. 7MECh. 5 - Prob. 8MECh. 5 - Prob. 9MECh. 5 - Prob. 10MECh. 5 - Prob. 11MECh. 5 - Prob. 12MECh. 5 - Prob. 13MECh. 5 - Prob. 14MECh. 5 - Prob. 15MECh. 5 - Prob. 16MECh. 5 - Compare full absorption costing to variable...Ch. 5 - Identifying Cost Behavior Patterns Steve...Ch. 5 - Prob. 2ECh. 5 - Prob. 3ECh. 5 - Prob. 4ECh. 5 - Estimating Cost Behavior Using High-Low Method...Ch. 5 - Prob. 6ECh. 5 - Prob. 7ECh. 5 - Prob. 8ECh. 5 - Prob. 9ECh. 5 - Estimating Cost Behavior Using Scattergraph and...Ch. 5 - Estimating Cost Behavior Using Least-Squares...Ch. 5 - Comparing High-Low Method and Least-Squares...Ch. 5 - Preparing Contribution Margin Income Statement...Ch. 5 - Determining Cost Behavior, Preparing Contribution...Ch. 5 - Prob. 15ECh. 5 - Prob. 16ECh. 5 - Prob. 17ECh. 5 - Prob. 18ECh. 5 - Comparing Full Absorption Costing and Variable...Ch. 5 - Estimating Cost Behavior Using Least-Squares...Ch. 5 - Prob. 1.1GAPCh. 5 - Prob. 1.2GAPCh. 5 - Prob. 1.3GAPCh. 5 - Prob. 1.4GAPCh. 5 - Prob. 1.5GAPCh. 5 - Prob. 1.6GAPCh. 5 - Prob. 2.1GAPCh. 5 - Prob. 2.2GAPCh. 5 - Prob. 2.3GAPCh. 5 - Prob. 2.4GAPCh. 5 - Prob. 2.5GAPCh. 5 - Prob. 2.6GAPCh. 5 - Prob. 2.7GAPCh. 5 - Prob. 3.1GAPCh. 5 - Prob. 3.2GAPCh. 5 - Prob. 3.3GAPCh. 5 - Prob. 3.4GAPCh. 5 - Prob. 3.5GAPCh. 5 - Prob. 4.1GAPCh. 5 - Prob. 4.2GAPCh. 5 - Prob. 4.3GAPCh. 5 - Comparing Full Absorption and Variable Costing...Ch. 5 - Comparing Full Absorption and Variable Costing...Ch. 5 - Prob. 5.3GAPCh. 5 - Prob. 6.1GAPCh. 5 - Prob. 6.2GAPCh. 5 - Prob. 6.3GAPCh. 5 - Prob. 6.4GAPCh. 5 - Prob. 6.5GAPCh. 5 - Prob. 6.6GAPCh. 5 - Prob. 1.1GBPCh. 5 - Prob. 1.2GBPCh. 5 - Prob. 1.3GBPCh. 5 - Prob. 1.4GBPCh. 5 - Estimating Cost Behavior Using Scattergraph,...Ch. 5 - Prob. 1.6GBPCh. 5 - Prob. 2.1GBPCh. 5 - Estimating Cost Behavior Using Scattergraph,...Ch. 5 - Prob. 2.3GBPCh. 5 - Prob. 2.4GBPCh. 5 - Prob. 2.5GBPCh. 5 - Prob. 2.6GBPCh. 5 - Prob. 2.7GBPCh. 5 - Prob. 3.1GBPCh. 5 - Prob. 3.2GBPCh. 5 - Prob. 3.3GBPCh. 5 - Prob. 3.4GBPCh. 5 - Prob. 3.5GBPCh. 5 - Prob. 4.1GBPCh. 5 - Prob. 4.2GBPCh. 5 - Prob. 4.3GBPCh. 5 - Prob. 5.1GBPCh. 5 - Prob. 5.2GBPCh. 5 - Prob. 5.3GBPCh. 5 - Prob. 6.1GBPCh. 5 - Prob. 6.2GBPCh. 5 - Prob. 6.3GBPCh. 5 - Prob. 6.4GBPCh. 5 - Prob. 6.5GBPCh. 5 - Prob. 6.6GBP
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
- DeMarco Company is developing a cost formula for its packing activity. Discussion with the workers in the Packing Department has revealed that packing costs are associated with the number of customer orders, the size of the orders, and the relative fragility of the items (more fragile items must be specially wrapped in bubble wrap and Styrofoam). Data for the past 20 months have been gathered: Required: 1. Using the method of least squares, run a regression using the number of orders as the independent variable. 2. Run a multiple regression using three independent variables: the number of orders, the weight of orders, and the number of fragile items. Which regression equation is better? Why? 3. Predict the total packing cost for 25,000 orders, weighing 40,000 pounds, with 4,000 fragile items.arrow_forwardHeavenly Chocolates manufactures and sells quality chocolate products at its plant and retail store located in Saratoga Springs, New York. Two years ago, the company developed a web site and began selling its products over the Internet. Web-site sales have exceeded the company’s expectations, and management is now considering strategies to increase sales even further. To learn more about the web-site customers, a sample of 50 Heavenly Chocolate transactions was selected from the previous month’s sales. Data showing the day of the week each transaction was made, the type of browser the customer used, the time spent on the web site, the number of web pages viewed, and the amount spent by each of the 50 customers are contained in the file named Heavenly Chocolates. A portion of the data is shown in the table that follows: Heavenly Chocolates would like to use the sample data to determine whether online shoppers who spend more time and view more pages also spend more money during their visit to the web site. The company would also like to investigate the effect that the day of the week and the type of browser have on sales. Managerial Report Use the methods of descriptive statistics to learn about the customers who visit the Heavenly Chocolates web site. Include the following in your report. Graphical and numerical summaries for the length of time the shopper spends on the web site, the number of pages viewed, and the mean amount spent per transaction. Discuss what you learn about Heavenly Chocolates’ online shoppers from these numerical summaries. Summarize the frequency, the total dollars spent, and the mean amount spent per transaction for each day of week. Discuss the observations you can make about Heavenly Chocolates’ business based on the day of the week? Summarize the frequency, the total dollars spent, and the mean amount spent per transaction for each type of browser. Discuss the observations you can make about Heavenly Chocolates’ business based on the type of browser? Develop a scatter diagram, and compute the sample correlation coefficient to explore the relationship between the time spent on the web site and the dollar amount spent. Use the horizontal axis for the time spent on the web site. Discuss your findings. Develop a scatter diagram, and compute the sample correlation coefficient to explore the relationship between the number of web pages viewed and the amount spent. Use the horizontal axis for the number of web pages viewed. Discuss your findings. Develop a scatter diagram, and compute the sample correlation coefficient to explore the relationship between the time spent on the web site and the number of pages viewed. Use the horizontal axis to represent the number of pages viewed. Discuss your findings.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
- Queen's Move plc specializes in household removals and storage services. The business runs its own fleet of removal vehicles and also has freehold premises used for storage in many major towns and citios. The directors are undertaking an exercise to identify the principal cost pools and drivers in both aspects of the business with a view to implementing ABC on a two-year trial basis Which option below is the correct one for an activity pool? O booking of a removal by a customer O Premises costs (for housing the fleet of vehicles) O occupation of space by goods stored O number of milos drivenarrow_forwardManagement would like an analysis of the profitability of a particular customer, Cell City, which has ordered the following products over the last 12 months: Number of cases Number of orders. Direct labour-hours per case Selling price per case. Direct materials cost per case Sales Costs: Direct materials Direct labour Supporting manufacturing Order processing Customer service The company's direct labour rate is $30 per hour. Required: Using the company's ABC system, compute the customer margin of Cell City. Customer margin Standard Model 290 5 0.25 $49 $ 26 70 Deluxe Model 105 2 $ 0.40 $ 69 $29 70 (70)arrow_forwardColby Company makes cases for cell phones of all sizes and types for sale through specialty retailers. The company makes a standard model for the most recent iPhone as well as a deluxe model. Management has designed an ABC system with the following activity cost pools and activity rates for these models: Activity Cost Pool Supporting manufacturing Order processing Customer service Management would like an analysis of the profitability of a particular customer, Cell City, which has ordered the following products over the last 12 months: Number of cases Number of orders Direct labour-hours per case Selling price per case Direct materials cost per case. Sales Costs: Activity Rates $2 per direct labour-hour $19 per order $60 per customer Direct materials Direct labour Supporting manufacturing Order processing Customer service The company's direct labour rate is $20 per hour. Required: Using the company's ABC system, compute the customer margin of Cell City. Customer margin Standard Model…arrow_forward
- Colby Company makes cases for cell phones of all sizes and types for sale through specialty retailers. The company makes a standard model for the most recent iPhone as well as a deluxe model. Management has designed an ABC system with the following activity cost pools and activity rates for these models: Activity Cost Pool Supporting manufacturing Order processing Customer service Management would like an analysis of the profitability of a particular customer, Cell City, which has ordered the following products over the last 12 months: Number of cases Number of orders Direct labour-hours per case Selling price per case Direct materials cost per case The company's direct labour rate is $19 per hour. Sales Costs: Activity Rates $3 per direct labour-hour $15 per order $50 per customer Direct materials Direct labour Supporting manufacturing Order processing Customer service Customer margin Standard Deluxe Model Model 120 35 23 ta ta OSOF 0.20 $ $ 5 35 10 64 $9 $ Required: Using the…arrow_forwardThe Iowa City Veterinary Laboratory performs a variety of diagnostic tests on commercial and domestic animals. The lab has incurred the following costs over the past year. Required:1. Plot the data above in a scatter diagram. Assign cost to the vertical axis and the number of diagnostic tests to the horizontal axis. Visually fit a line to the plotted data.2. Using the visually fit line, estimate the monthly fixed cost and the variable cost per diagnostic test.arrow_forwardRefer to Exercise 8.29. Suppose Gene determines that next year's Sales Division activities include the following: Research researching current and future conditions in the industry Shipping arranging for shipping of mattresses and handling calls from purchasing agents at retail stores to trace shipments and correct errors Jobbers coordinating the efforts of the independent jobbers who sell the mattresses Basic ads-placing print and television ads for the Sleepeze and Plushette lines Ultima ads choosing and working with the advertising agency on the Ultima account Office management-operating the Sales Division office The percentage of time spent by each employee of the Sales Division on each of the above activities is given in the following table: Research Administrative Gene Assistant Assistant Research 75% Shipping Jobbers 30% 20% 15 10 20 Basic ads 15 40 Ultima ads 30 5 Office management 25 15arrow_forward
- Ventana Window and Wall Treatments Company provides draperies, shades, and various window treatments. Ventana works with the customer to design the appropriate window treatment, places the order, and installs the finished product. Direct materials and direct labor costs are easy to trace to the jobs. Ventanas income statement for last year is as follows: Ventana wants to find a markup on cost of goods sold that will allow them to earn about the same amount of profit on each job as was earned last year. Required: 1. What is the markup on cost of goods sold (COGS) that will maintain the same profit as last year? (Round the percentage to two significant digits.) 2. A customer orders draperies and shades for a remodeling job. The job will have the following costs: What is the price that Ventana will quote given the markup percentage calculated in Requirement 1? (Round the price to the nearest dollar.) 3. What if Ventana wants to calculate a markup on direct materials cost, since it is the largest cost of doing business? What is the markup on direct materials cost that will maintain the same profit as last year? (Round the percentage to two significant digits.) What is the bid price Ventana will use for the job given in Requirement 2 if the markup percentage is calculated on the basis of direct materials cost? (Round to the nearest dollar.)arrow_forwardCost Analysis, Income Statement Five to six times a year, Kicker puts on tent sales in various cities throughout Oklahoma and the surrounding states. The tent sales are designed to show Kicker customers new products, engender enthusiasm about those products, and sell soon to be out-of-date products at greatly reduced prices. Each tent sale lasts 1 day and requires parking lot space to set up the Kicker semitrailer, a couple of show cars, a disc jockey playing music, and a tent to sell Kicker merchandise, distribute brochures, and so on. Last year, the Austin tent sale was held in a far corner of the parking lot outside the city exhibition hall where the automotive show was in progress. Because most customers were interested more in the new model cars than in the refurbishment of their current cars, foot traffic was low. In addition, customers did not want to carry speakers and amplifiers all the way back to where they had originally parked. Total direct costs for this tent sale were 14,300. Direct costs included gasoline and fuel for three pickup trucks and the semitrailer; wages and per diem for the five Kicker personnel who traveled to the show, rent on the parking lot space, and depreciation on the semitrailer, pickups, tent, tables (in tent), sound equipment, and the like. Revenue was 20,000. Cost of goods sold for the speakers was 7,000. Required: 1. CONCEPTUAL CONNECTION How do you suppose Kicker accounts for the costs of the tent sales? What income statement items are affected by the tent sales? 2. CONCEPTUAL CONNECTION What was the profit (loss) from the Austin tent sale? What do you think Kicker might do to make it more profitable in the future?arrow_forwardBumblebee Mobiles manufactures a line of cell phones. The management has identified the following overhead costs and related cost drivers for the coming year. The following were incurred in manufacturing two of their cell phones, Bubble and Burst, during the first quarter. REQUIREMENT Review the worksheet called ABC that follows these requirements. You have been asked to determine the cost of each product using an activity-based cost system. Note that the problem information is already entered into the Data Section of the ABC worksheet.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 LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher: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
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
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
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
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