Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN: 9781337115773
Author: Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 3, Problem 27BEB
Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for Budgeted Output
Refer to the information for Speedy Pete’s above. Assume that this information was used to construct the following formula for monthly delivery cost.
Required:
Assume that 3,000 deliveries are budgeted for the following month of January. Use the total delivery cost formula for the following calculations:
- 1. Calculate total variable delivery cost for January.
- 2. Calculate total delivery cost for January.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The controller of the
Stump
Company is preparing the budget for
2021
and needs to estimate a cost function for delivery costs. Information regarding delivery costs incurred in the prior 2 months are:
LOADING...
(Click
the icon to view the information.)
Requirements
1. Estimate the cost function for delivery.
2. Can the constant in the cost function be used as an estimate of fixed delivery cost per month? Explain.
Requirement 1. Estimate the cost function for delivery.
Delivery costs =
+ (
×
)
Delivery costs =
+ (
×
)
Requirement 2. Can the constant in the cost function be used as an estimate of fixed delivery cost per month? Explain.
The cost function in requirement 1 is an estimate of how costs behave
▼
outside of
within
the relevant range, not at cost levels
▼
outside
within
the relevant range. If there are no months with zero miles driven represented in the delivery cost…
Crystal Mining has completed the following data to analyze utility cost:MonthMachine Hours Utility CostJanuary200P 300February325440March400480April410490May525620June680790July820840August900900Required:1.Use the least squaresmethod to develop a formula for budgeting utility cost. (Round off value of b to two decimal places and the value of a to nearest peso.2.Prepare flexible budget with separate variable and fixed categories for utility costs at 350, 500, and 600 machine hours.
Apparelle Co. developed the following equation to predict certain components of its budget for the coming period: Costs = $50,000 + ($5 x direct labor hours) The $5 would approximate:a. total costb. direct labor rate per hourc. fixed cost per direct labor hourd. variable costs per direct labor hour
Chapter 3 Solutions
Managerial Accounting: The Cornerstone of Business Decision-Making
Ch. 3 - Prob. 1DQCh. 3 - What is a driver? Give an example of a cost and...Ch. 3 - Suppose a company finds that shipping cost is...Ch. 3 - Some firms assign mixed costs to either the fixed...Ch. 3 - Explain the difference between committed and...Ch. 3 - Explain why the concept of relevant range is...Ch. 3 - Why do mixed costs pose a problem when it comes to...Ch. 3 - Describe the cost formula for a strictly fixed...Ch. 3 - Describe the cost formula for a strictly variable...Ch. 3 - What is the scattergraph method, and why is it...
Ch. 3 - Describe how the scattergraph method breaks out...Ch. 3 - What are the advantages of the scattergraph method...Ch. 3 - Prob. 13DQCh. 3 - What is meant by the best-fitting line?Ch. 3 - What is the difference between the unit cost of a...Ch. 3 - Prob. 16DQCh. 3 - (Appendix 3A) Explain the meaning of the...Ch. 3 - A factor that causes or leads to a change in a...Ch. 3 - Which of the following would probably be a...Ch. 3 - Prob. 3MCQCh. 3 - In the cost formula, the term 128,000,000 a. is...Ch. 3 - In the cost formula, the term 12,000 a. is the...Ch. 3 - Prob. 6MCQCh. 3 - Prob. 7MCQCh. 3 - The following cost formula for total purchasing...Ch. 3 - An advantage of the high-low method is that it a....Ch. 3 - Prob. 10MCQCh. 3 - Prob. 11MCQCh. 3 - Prob. 12MCQCh. 3 - The total cost for monthly supervisory cost in a...Ch. 3 - Yates Company shows the following unit costs for...Ch. 3 - (Appendix 3A) In the method of least squares, the...Ch. 3 - Creating and Using a Cost Formula Big Thumbs...Ch. 3 - Using High-Low to Calculate Fixed Cost, Calculate...Ch. 3 - Using High-Low to Calculate Predicted Total...Ch. 3 - Using High-Low to Calculate Predicted Total...Ch. 3 - Using Regression to Calculate Fixed Cost,...Ch. 3 - Inventory Valuation under Absorption Costing Refer...Ch. 3 - Inventory Valuation under Variable Costing Refer...Ch. 3 - Absorption-Costing Income Statement Refer to the...Ch. 3 - Variable-Costing Income Statement Refer to the...Ch. 3 - Creating and Using a Cost Formula Kleenaire Motors...Ch. 3 - Using High-Low to Calculate Fixed Cost, Calculate...Ch. 3 - Using High-Low to Calculate Predicted Total...Ch. 3 - Brief Exercise 3-28 Using High-Low to Calculate...Ch. 3 - Using Regression to Calculate Fixed Cost,...Ch. 3 - Inventory Valuation under Absorption Costing Refer...Ch. 3 - Inventory Valuation under Variable Costing Refer...Ch. 3 - Brief Exercise 3-32 Absorption-Costing Income...Ch. 3 - Brief Exercise 3-33 Variable-Costing Income...Ch. 3 - Variable and Fixed Costs What follows are a number...Ch. 3 - Cost Behavior, Classification Smith Concrete...Ch. 3 - Prob. 36ECh. 3 - Prob. 37ECh. 3 - Prob. 38ECh. 3 - Step Costs, Relevant Range Bellati Inc. produces...Ch. 3 - Matching Cost Behavior Descriptions to Cost...Ch. 3 - Examine the graphs in Exercise 3-40. Required: As...Ch. 3 - Prob. 42ECh. 3 - Prob. 43ECh. 3 - High-Low Method Refer to the information for Luisa...Ch. 3 - Scattergraph Method Refer to the information for...Ch. 3 - Method of Least Squares Refer to the information...Ch. 3 - Use the following information for Exercises 3-47...Ch. 3 - Use the following information for Exercises 3-47...Ch. 3 - Method of Least Squares, Developing and Using the...Ch. 3 - The method of least squares was used to develop a...Ch. 3 - Identifying the Parts of the Cost Formula;...Ch. 3 - Inventory Valuation under Absorption Costing...Ch. 3 - Inventory Valuation under Variable Costing Lane...Ch. 3 - Income Statements under Absorption and Variable...Ch. 3 - (Appendix 3A) Method of Least Squares Using...Ch. 3 - (Appendix 3A) Method of Least Squares Using...Ch. 3 - Identifying Fixed, Variable, Mixed, and Step Costs...Ch. 3 - Identifying Use of the High-Low, Scattergraph, and...Ch. 3 - Identifying Variable Costs, Committed Fixed Costs,...Ch. 3 - Scattergraph, High-Low Method, and Predicting Cost...Ch. 3 - Method of Least Squares, Predicting Cost for...Ch. 3 - Cost Behavior, High-Low Method, Pricing Decision...Ch. 3 - Prob. 63PCh. 3 - Variable and Fixed Costs, Cost Formula, High-Low...Ch. 3 - Cost Separation About 8 years ago, Kicker faced...Ch. 3 - Variable-Costing and Absorption-Costing Income...Ch. 3 - Refer to the information for Farnsworth Company...Ch. 3 - (Appendix 3A) Scattergraph, High-Low Method,...Ch. 3 - (Appendix 3A) Separating Fixed and Variable Costs,...Ch. 3 - (Appendix 3A) Cost Formulas, Single and Multiple...Ch. 3 - Suspicious Acquisition of Data, Ethical Issues...
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
- Using Regression to Calculate Fixed Cost, Calculate the Variable Rate, Construct a Cost Formula, and Determine Budgeted Cost Refer to the information for Pizza Vesuvio on the previous page. Coefficients shown by a regression program for Pizza Vesuvios data are: Required: Use the results of regression to make the following calculations: 1. Calculate the fixed cost of labor and the variable rate per employee hour. 2. Construct the cost formula for total labor cost. 3. Calculate the budgeted cost for next month, assuming that 675 employee hours are budgeted. (Note: Round answers to the nearest dollar.) Use the following information for Brief Exercises 3-17 through 3-20: Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected:arrow_forwardUsing High-Low to Calculate Predicted Total Variable Cost and Total Cost for a Time Period That Differs from the Data Period Refer to the information for Pizza Vesuvio on the previous page. Assume that this information was used to construct the following formula for monthly labor cost. TotalLaborCost=5,237+(7.40EmployeeHours) Required: Assume that 4,000 employee hours are budgeted for the coming year. Use the total labor cost formula to make the following calculations: 1. Calculate total variable labor cost for the year. 2. Calculate total fixed labor cost for the year. 3. Calculate total labor cost for the coming year. Use the following information for Brief Exercises 3-17 through 3-20: Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected:arrow_forwardUsing High-Low to Calculate Predicted Total Variable Cost and Total Cost for Budgeted Output Refer to the information for Pizza Vesuvio on the previous page. Assume that this information was used to construct the following formula for monthly labor cost. TotalLaborCost=5,237+(7.40EmployeeHours) Required: Assume that 675 employee hours are budgeted for the month of September. Use the total labor cost formula for the following calculations: 1. Calculate total variable labor cost for September. 2. Calculate total labor cost for September.arrow_forward
- Using Regression to Calculate Fixed Cost, Calculate the Variable Rate, Construct a Cost Formula, and Determine Budgeted Cost Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected: Employee Hours Month January February March April May June July August Labor Cost $7,000 8,140 9,899 9,787 8,490 7,450 9,490 7,531 Coefficients shown by a regression program for Pizza Vesuvio's data are: 360 550 630 600 480 350 570 310. Intercept 4,497 X Variable 8.26 In your calculations, round the variable rate per employee hour to the nearest cent. Required: Use the results of regression to make the following calculations: 1. Calculate the fixed cost of labor. 17,430 X Calculate the variable rate per employee hour. 7.40 X per employee hourarrow_forwardZinc Company constructed the following formula for its monthly utility cost: Total utility cost = $1,000 + ($5 × Number of labor hours) Assume that 500 labor hours are budgeted for the month of April. Calculate the total utility cost for the month of April.arrow_forwardChris Corporation has developed the following flexible budget formula for the linear annual indirect labor cost: Total cost = P 12,000 + .75 per machine hour Operating budgets for the current month are based upon 10,000 machine hours of planned machine time. Indirect labor cost in this monthly planning budget are: a. P 7,500 b. P 8,500 c. P 17,500 d. P 19,500arrow_forward
- Use the given data shown in the graph. A. What is the budgeted fixed cost per period? B. What is the budgeted variance cost per unit? C. What is the value of F (that is, the flexible budget for an activity of 8,000 units)? D. What is the flexible budget cost amount if the actual activity had been 16,000 units?arrow_forward[The following information applles to the questions displayed below.] ABC Corporation Is a service company that measures Its output based on the number of customers served. The company provided the following fixed and varlable cost estimates that It uses for budgeting purposes and the actual results for May as shown below: Actual Total for May $ 223,500 $ 126,000 20,400 S.44,300 Fixed Element Variable Element per Month per Customer Served $6,100 $ 1,500 Revenue Employee salaries and wages Travel expenses other expenses $ 68,000 $ 47,000 When preparing Its plannlng budget the company estimated that It would serve 35 customers per month; however, during May the company actually served 40 customers. 14. What activity varlance would Adger report In May with respect to Its revenue? (Indicate the effect of each varlance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (I.e., zero varlance). Input all amounts as positive values.) Activity variancearrow_forwardThe following budgeted profit statement has been prepared using absorption costing principles.A company manufactures and sells a single product which has the following cost and sellingprice structure: P/unit P/unit Selling price 120 Direct material 22 Direct labour 36 Variable overhead 14 Fixed overhead 12 84 Profit per unit 36 The fixed overhead absorption rate is based on the normal capacity of 2,000 units per month.Assume that the same amount is spent each month on fixed overheads.Budgeted sales for next month are 2,200 units.You are required to calculate:a. The breakeven point, in sales units per month. b. The margin of safety for the next month.arrow_forward
- A company has the following information for the month of October. The company applies overhead (OH) costs using standard machine hours as the allocation base. Actual Results Actual variable OH costs Actual fixed OH costs Actual machine hours Actual output Budget (for 1,000 units) Variable OH Fixed OH Budgeted machine hours Q. What $360 Favorable $2,500 $4,700 $1,280 MHS 1,100 units Q. What was the company's VOH efficiency variance for October? Answer. (Click to select) (Click to select) None of the answers are correct $180 Unfavorable Answer. $360 Unfavorable $180 Favorable $2,000 $4,400 1,000 MHS ume variance for October? 4arrow_forwardCampbell Industries has gathered the following information about the actual sales revenues and expenses for its pharmaceuticals segment for the most recent year. E (Click the icon to view the actual data.) Prepare a segment margin performance report for the pharmaceutical segment. Calculate a variance and a variance percentage for each line in the report. Round to the nearest hundredth for the variance percentages (for example, if your answer is 16.2384%, round it to 16.24%). Budgeted data for the same time period for the pharmaceutical segment are as follows (all data are in millions): E (Click the icon to view the budgeted data.) Begin by preparing the performance report through the contribution margin line. Next, complete the report through the segment margin line, and then, finally, complete the report through the operating income line. (Enter the variances as positive numbers. Round the variance percentages to the nearest hundredth percent, X.XX%.) Performance Report Data table…arrow_forwardThe cost formula for the maintenance department of Rambo Limited is $19,200 per month plus $7.50 per machine hour used by the production department. Required: a. Calculate the maintenance cost that would be budgeted for a month in which 6,600 machine hours are planned to be used. b. Prepare an appropriate performance report for the maintenance department assuming that 7,100 machine hours would be used in the month of May and that the total actual maintenance cost incurred in May was $68,950. Complete this question by entering your answers in the tabs below. Required A Required B Calculate the maintenance cost that would be budgeted for a month in which 6,600 machine hours are planned to be used. Maintenance costarrow_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 LearningExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
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
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
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