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
Videos
Question
Chapter 5, Problem 1.1GAP
To determine
Introduction:
Scattered graph:
It is a graph that depicts the relationship between the 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 solution
Students have asked these similar questions
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:
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)
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…
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.
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…
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
- The 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_forwardOdle 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.arrow_forwardQueen'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_forward
- Log Cabins Unlimited constructs vacation houses in the North Carolina mountains. The company has developed the following value chart: a. How much of the total time is value-added time? ______ hours b. How much total time is spent performing non-value-added activities? ______ hours c. Calculate the manufacturing cycle efficiency of the process. Note: Round the percentage to one decimal point (i.e. show 14.445% as 14.4%). ______%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_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
- 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.)arrow_forwardSuppose Gaurab Chakrabarti and Sean Hunt’s company, Solugen, makes peroxide-based cleaners in different strengths. The founders must decide on the best sales mix. Assume the company has a capacity of 400 hours of processing time available each month and it makes two types of cleaners,Deluxe and Premium. Information on these products follows.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
- Tasty Treats is a snow cone stand near the local park. To plan for the future, it wants to determine its cost behavior patterns. It has the following information available about its operating costs and the number of snow cones served Month January February March. April May June Number of snow cones 6,400 7,000 6,200 6,900 7,600 7,250 Total operating costs $5,830 $6,400 $5,840 $6,330 $6,820 $6,575 Using the high-low method, the monthly operating costs, if Tasty Treats sells 8,000 snow cones in a month, are:arrow_forwardOakwood Company produces maple bookcases. The following information is available for the production of a recent order of 500 bookcases. Process time Inspection time Move time Wait time 1. Compute cycle time. 2. Compute cycle efficiency. 19 days 1 day 4 days 17 days 3. Management believes it can reduce move time by 1 day and wait time by 2 days by adopting lean manufacturing techniques. Compute cycle efficiency assuming the predictions are correct. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Compute cycle time. Inspection time Move time Process time Wait time Cycle time Cycle Time Required 3 Time 0arrow_forwardAfter studying the costs incurred over the past two years for one of its products, skeins of knitting yarn, Jackson has selected four categories of selling costs and chosen cost drivers for each of these costs. The selling costs actually incurred during the past year and the cost drivers are as follows: Cost Category Sales commissions Pay-per-click/Search engine optimization Cost of online sales Credit and collection Total selling costs The knitting yarn is sold to retail outlets in boxes, each containing 12 skeins of yarn. The sale of partial boxes is not permitted. Commissions are paid on sales to retail outlets but not on online sales. The cost of online sales includes technology infrastructure costs and the wages of personnel who process the online orders. Jackson believes that the selling costs vary significantly with the size of the order. Order sizes are divided into three categories as follows: Order Size Small Medium Large Online Sales 1 to 10 skeins 11 to 20 skeins Over 20…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher: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
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
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