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
Concept explainers
Question
Chapter 6, Problem 48P
1.
To determine
Introduction: A scatterplot is used to determine the relationship between the two variables or check whether the two variables of the data set are related or not. A scatterplot can provide a general understanding of how the two variables are related.
To construct: The scatterplot for the provided data set.
2.
To determine
Introduction: The regression equation between the dependent variable
can be represented by the following equation:
In the above regression equation, the values
To construct: The excel spreadsheet to find the least square regression equation. Also, estimate the variable and fixed cost components.
3.
To determine
Introduction: The regression equation between the dependent variable
can be represented by the following equation:
In the above regression equation, the values
To find: The least square regression equation.
4.
To determine
Introduction: The regression equation between the dependent variable
can be represented by the following equation:
In the above regression equation, the values
To find: The cost of the airport if it is known that the number of flights that originated at the airport is 1600.
5.
To determine
Introduction: The coefficient of determination is the proportion of the variance of the dependent variable that could be predicted from the independent variable.
To find: The coefficient of determination using the spreadsheet constructed in subpart (2). Also, interpret it.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Integrated Excel: Preparing a Contribution Format Income Statement Using the High-Low Method
Jay Corporation has provided data from a two-year period to aid in planning. The Controller has asked you to prepare a contribution
format income statement.
Budgeted information for Quarter 1 of 2024:
Sales in units
Sales price per unit
After analyzing expenses, the company has determined the following cost patterns.
Cost of Goods Sold (per unit)
Sales Commissions (per dollar of sales).
Administrative Salaries (per quarter)
Rent Expense (per quarter)
Depreciation Expense (per quarter)
Shipping has been determined to be a mixed cost with the following total costs and units:
2022
Quarter 1
Quarter 2
Quarter 3
Quarter 4
2023
Quarter 1
Quarter 2
Quarter 3
Quarter 4
Total Cost
$ 67,000
$ 94,000
$ 89,800
$ 92,600
$ 72,500
$80,000
$ 84,000
$ 100,000
17,000
$ 48.00
Units
12,500
21,000
13,800
20,000
13,700
14,000
14,300
22,500
$29.00
9.50€
$ 45,000
$ 27,000
$ 36,000
Required:
Use the data to answer the…
Assume that a company provided the following cost formulas for three of its expenses (where q
refers to the number of hours worked):
Rent (fixed)
Supplies (variable)
Utilities (mixed)
$ 3,000
$ 4.00g
$ 205 + $ 0.759
The company's planned level of activity was 2,000 hours and its actual level of activity was 1,900
hours. How much utilities expense would be included in the planning budget?
Multiple Choice
$1,500
$1,630
$1,705
$1,730
Part 1
Waterways uses time and material pricing when it bids on drainage projects. Budgeted data for 2022 for installation division 1 are as follows.
Waterways Corporation
Installation Division 1
Budgeted Costs for Drainage Projects for 2022
Labour wages (5.760 hours)
Supervisor's salary
Clerical and accountant wages
Drainage supplies manager
Overhead
Total
Time Charges Material Loading Charges
$241,920
63,360
51,840
$357,120
$ 60,000
4,000
40,000
21,000
$125,000
Waterways desires a $23 profit margin per hour of labour and 25% profit on materials. Materials are transferred in from the manufacturing division. The total estimated invoice cost of materials in 2022 will
be $500,000.
Instructions
a. Suppose Ryan accepts the order. Determine what the impact would be on:
1. the plant,
2. the installation division, and
3. the company as a whole.
b. What do you think would be the best course of action in this situation? Explain.
a. Calculate the rate per hour of labour.
b. Calculate the…
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 Finch 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 1: 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 28,000 hours of services in Year 1. 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 Finch charges customers $57 per hour, the firm can achieve 31,000 hours of services. Prepare a flexible budget using the consultant's assumption. c. The same consultant also suggests that if the firm…arrow_forwardAssume that a company provided the following cost formulas for three of its expenses (where q refers to the number of hours worked): Rent (fixed) Supplies (variable) Utilities (mixed) $ 4.009 $150 + $0.75q The company's planned level of activity was 2,110 hours and its actual level of activity was 1,850 hours. How much supplies expense would be included in the planning budget? Multiple Choice C $7,840 $8,140 $8,340 $ 3,000 $8,440arrow_forwardTASK A. Problem Solving. Analyze the given problem and perform the required tasks in the worksheet provided. 1. A hospital has P250,000 expected utility bill this year. The janitorial, accounting, and orderlies departments are service departments servicing the operating, hospital rooms, and laboratories departments. Floor spaces assigned to each department are as follows Department Square Footage Janitorial Accounting Orderlies 1,000 2,000 7,000 Operating Hospital rooms Laboratories 4,000 30,000 6,000 How much of the P200,000 will eventually become the hospital rooms department's total costs, assuming a direct allocation based in square footage is used? 2. The Laptop complex, which offers two main services: 1) time on a time-shared computer and (2) propriety computer programs. Computer time is provided by the Operating Department (OD), and programs are written by the programming Department(PD). Usually, the Operating Department spends P 9,000 and the Programming Departmemnt spends…arrow_forward
- Question Content Area Given the following information, determine the activity rate (rounded to the nearest cent) for setups. Activity Total Activity-Base Usage Budgeted Activity Cost Setups 10,000            $57,200            Inspections 23,400            $149,700            Assembly (dlh) 73,800            $394,500             a. $5.61 b. $5.35 c. $6.40 d. $5.72arrow_forwardRequired information [The following information applies to the questions displayed below.] Professor John Morton has just been appointed chairperson of the Finance Department at Westland University. In reviewing the department's cost records, Professor Morton has found the following total cost associated with Finance 101 over the last five terms: Term Fall, last year Winter, last year Summer, last year. Fall, this year Winter, this year. Number of Sections Offered Required 38 4 6 2 Fixed cost Variable cost Total expected cost 5 3 Professor Morton knows that there are some variable costs, such as amounts paid to graduate assistants, associated with the course. He would like to have the variable and fixed costs separated for planning purposes. Total Cost $ 10,000 $ 14,000 3-a. Assume that because of the small number of sections offered during the Winter Term this year, Professor Morton will have to offer eight sections of Finance 101 during the Fall Term. Compute the expected total cost…arrow_forwardA company uses charging rates to allocate service department costs to the using departments. The accountant compiled the following information on one of the service departments: If Department K plans to use 1,350 hours of the service departments service in the coming year, how much of the service departments cost is allocated to Department K? a. 3,375 b. 27,300 c. 26,325 d. 23,950arrow_forward
- Assume that a company provided the following cost formulas for three of its expenses (where q refers to the number of hours worked): Rent (fixed) Supplies (variable) Utilities (mixed) $ 3,000 $ 4.009 $150 $0.75q The company's planned level of activity was 2,000 hours and its actual level of activity was 1,850 hours. How much supplies expense would be included in the planning budget? Multiple Choice Đž $7,900 Đž $7,700 $7,400 Đž $8,000 Ă—arrow_forwardTB MC Qu. 9-346 (Static) Standahl Air uses two measures ... Standahl Air uses two measures of activity, flights and passengers, in the cost formulas in its budgets and performance reports. The cost formula for plane operating costs is $39,590 per month plus $2,649 per flight plus $4 per passenger. The company expected its activity in August to be 82 flights and 294 passengers, but the actual activity was 85 flights and 297 passengers. The actual cost for plane operating costs in August was $255,690. The spending variance for plane operating costs in August would be closest to: Multiple Choice $2,294 U Đž $10,253 Uarrow_forwardGiven the following information, determine the activity rate (rounded to the nearest cent) for setups. Activity Total Activity-Base Usage Budgeted Activity Cost Setups 9,000Â Â Â Â Â Â Â Â Â Â Â Â $53,600Â Â Â Â Â Â Â Â Â Â Â Â Inspections 25,400Â Â Â Â Â Â Â Â Â Â Â Â $136,500Â Â Â Â Â Â Â Â Â Â Â Â Assembly (dlh) 75,200Â Â Â Â Â Â Â Â Â Â Â Â $412,200Â Â Â Â Â Â Â Â Â Â Â Â Â a. $5.37 b. $5.96 c. $5.50 d. $5.48arrow_forward
- Premium Candy Inc. is a producer of premium chocolate based in Palo Alto. i (Click the icon to view additional information.) For 2020, the trucking fleet had a practical capacity of 45 round-trips between the Palo Alto plant and the two suppliers. It recorded the following information: (Click the icon to view the budget and actual data.) Variable costs Requirement 1. Using the dual-rate method, what are the costs allocated to the dark chocolate division and the milk chocolate division when (a) variable costs are allocated using the budgeted rate per round-trip and actual round-trips used by each division and when (b) fixed costs are allocated based on the budgeted rate per round-trip and round-trips budgeted for each division? Dark chocolate Milk chocolate Fixed costs Premium Candy Inc. decides to examine the effect of using the dual-rate method for allocating truck costs to each round-trip. (Click the icon to view the cost information for 2020.) Total costs Read the requirements.arrow_forwardSubject - Acounting JAR-499 tour company uses two measures of activity, routes and passengers in its cost formulas used for budgeting and performance evaluation. The cost formula for tour operating costs Is $56,870 per month plus $2,876 per route plus $17 per passenger The company expected in August to perform 86 routes and serve 259 passengers, but the actual activity was 95 routes and 269 passengers. The actual tour operating costs in August was $305.100. The spending variance for tour operating costs in August would be closest to: $3,509 Favorable $26,054 Favorable $29,563 Favorable $3.509 Unfavorablearrow_forwardu                                                        messageQ&A notifications account_circle  Business AccountingQ&A LibraryAn operations manager narrowed the search for a new facility location to four communities. The annual fixed costs (land, property taxes, insurance, equipment, and buildings) and the variable costs (labor, materials, transportation, and variable overhead) are as follows:Community Fixed Costs per Year Variable Costs per UnitA $150,000 $62B $300,000 $38C $500,000 $24D $600,000 $30Notice that no community dominates the set of alternatives; that is, no community has both the lowest fixed costs and the lowest variable costs per unit. If that were so, that community would be the best location.Step 1. Plot the total cost curves for all the communities on a single graph. Identify on the graph the approximate volume range…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
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher: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