EBK CORNERSTONES OF COST MANAGEMENT
4th Edition
ISBN: 8220103648561
Author: MOWEN
Publisher: Cengage Learning US
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 8, Problem 41P
Refer to Problem 8.40 for data.
Required:
- 1. Run a multiple regression equation using machine hours, number of setups, and number of purchase orders as independent variables. Prepare a flexible budget for overhead for the 12 months using the results of this regression equation. (Round the regression coefficients to the nearest cent and predicted overhead to the nearest dollar.) Which flexible budget is better—the one based on simple regression (with machine hours as the only independent variable) or the one based on multiple regression? Why?
- 2. Now, suppose that the controller remembers that the factory throws two big parties each year, one for the 4th of July and the other for Christmas. Rerun the multiple regression with machine hours, number of setups, and number of purchase orders, and add a dummy variable called “Party.” (This variable takes the value one for months with a factory-sponsored party, and zero otherwise.) Prepare a flexible budget for the 12 months using the results of this regression. Discuss the implications of using this new regression for decision making.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
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.
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?
These are True/False questions.
____ 6. If the total unit cost of manufacturing Product Y is currently $36 and the total unit cost after modifying the style is estimated to be $48, the differential cost for this situation is $12.
____ 7. A process whereby the effect of fluctuations in level of activity is built into the budgeting system is referred to as flexible budgeting.
____ 8. In an investment center, the manager has the responsibility and the authority to make decisions that affect not only costs and revenues, but also the plant assets invested in the center.
____ 9. The capital expenditures budget summarizes future plans for acquisition of fixed assets.
____ 10. The process by which management plans, evaluates, and controls long-term investment decisions involving fixed assets is called capital investment analysis.
Chapter 8 Solutions
EBK CORNERSTONES OF COST MANAGEMENT
Ch. 8 - Define budget. How are budgets used in planning?Ch. 8 - Prob. 2DQCh. 8 - Prob. 3DQCh. 8 - What is the master budget? An operating budget? A...Ch. 8 - Explain the role of a sales forecast in budgeting....Ch. 8 - All budgets depend on the sales budget. Is this...Ch. 8 - What is an accounts receivable aging schedule? Why...Ch. 8 - Suppose that the vice president of sales is a...Ch. 8 - Suppose that the controller of your companys...Ch. 8 - Prob. 10DQ
Ch. 8 - Prob. 11DQCh. 8 - Discuss the shortcomings of the traditional master...Ch. 8 - Define static budget. Give an example that shows...Ch. 8 - What are the two meanings of a flexible budget?...Ch. 8 - What are the steps involved in building an...Ch. 8 - FlashKick Company manufactures and sells soccer...Ch. 8 - Refer to Cornerstone Exercise 8.1, through...Ch. 8 - Refer to Cornerstone Exercise 8.2 for the...Ch. 8 - Prob. 4CECh. 8 - Johnston Company cleans and applies powder coat...Ch. 8 - Play-Disc makes Frisbee-type plastic discs. Each...Ch. 8 - Refer to Cornerstone Exercise 8.6. Required: 1....Ch. 8 - Timothy Donaghy has developed a unique formula for...Ch. 8 - Green Earth Landscaping Company provides monthly...Ch. 8 - Coral Seas Jewelry Company makes and sells costume...Ch. 8 - Shalimar Company manufactures and sells industrial...Ch. 8 - Khloe Company imports gift items from overseas and...Ch. 8 - Nashler Company has the following budgeted...Ch. 8 - Refer to Cornerstone Exercise 8.13. In March,...Ch. 8 - Palmgren Company produces consumer products. The...Ch. 8 - Prob. 16ECh. 8 - Crescent Company produces stuffed toy animals; one...Ch. 8 - Audio-2-Go, Inc., manufactures MP3 players. Models...Ch. 8 - Tiger Drug Store carries a variety of health and...Ch. 8 - Rosita Flores owns Rositas Mexican Restaurant in...Ch. 8 - Prob. 21ECh. 8 - Janet Wooster owns a retail store that sells new...Ch. 8 - Historically, Ragman Company has had no...Ch. 8 - Del Spencer is the owner and founder of Del...Ch. 8 - Refer to Exercise 8.24. Del Spencers purchases...Ch. 8 - Ingles Corporation is a manufacturer of tables...Ch. 8 - In an attempt to improve budgeting, the controller...Ch. 8 - Refer to Exercise 8.27. At the end of the year,...Ch. 8 - Olympus, Inc., manufactures three models of...Ch. 8 - Refer to Exercise 8.29. Suppose Gene determines...Ch. 8 - Trumbull Co. plans to produce 100,000 toy cars...Ch. 8 - Which of the following describes the order in...Ch. 8 - A companys controller is adjusting next years...Ch. 8 - A companys sales for the coming months are as...Ch. 8 - The budget that adjusts unit sales for beginning...Ch. 8 - Ponderosa, Inc., produces wiring harness...Ch. 8 - Bernard Creighton is the controller for Creighton...Ch. 8 - Greiner Company makes and sells high-quality glare...Ch. 8 - Prob. 39PCh. 8 - The controller for Muir Companys Salem plant is...Ch. 8 - Refer to Problem 8.40 for data. Required: 1. Run a...Ch. 8 - Norton Company, a manufacturer of infant furniture...
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_forwardConsider the following time series data: Construct a time series plot. What type of pattern exists in the data? Develop a three-week moving average for this time series. Compute MSE and a forecast for week 8. Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 8. Compare the three-week moving average forecast with the exponential smoothing forecast using α = 0.2. Which appears to provide the better forecast based on MSE? Use trial and error to find a value of the exponential smoothing coefficient α that results in a smaller MSE than what you calculated for α = 0.2.arrow_forwardUsing the data in E4-2 and spreadsheet software, determine: The variable cost per unit, the total fixed cost, and R2. The plotted data points using the graphing function. Compare the results to your solutions in E4-2 and E4-3 and explain the reasons for the results.arrow_forward
- Friendly Bank is attempting to determine the cost behavior of its small business lending operations. One of the major activities is the application activity. Two possible activity drivers have been mentioned: application hours (number of hours to complete the application) and number of applications. The bank controller has accumulated the following data for the setup activity: Required: 1. Estimate a regression equation with application hours as the activity driver and the only independent variable. If the bank forecasts 2,600 application hours for the next month, what will be the budgeted application cost? 2. Estimate a regression equation with number of applications as the activity driver and the only independent variable. If the bank forecasts 80 applications for the next month, what will be the budgeted application cost? 3. Which of the two regression equations do you think does a better job of predicting application costs? Explain. 4. Run a multiple regression to determine the cost equation using both activity drivers. What are the budgeted application costs for 2,600 application hours and 80 applications?arrow_forwardConsider the following time series data: Construct a time series plot. What type of pattern exists in the data? Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 7. Compare the three-week moving average forecast with the exponential smoothing forecast using α = 0.2. Which appears to provide the better forecast based on MSE? Explain. Use trial and error to find a value of the exponential smoothing coefficient α that results in a smaller MSE than what you calculated for α = 0.2.arrow_forwardThe Lockit Company manufactures door knobs for residential homes and apartments. Lockit is considering the use of simple (single-driver) and multiple regression analyses to forecast annual sales because previous forecasts have been inaccurate. The new sales forecast will be used to initiate the budgeting process and to identify more completely the underlying process that generates sales. Larry Husky, the controller of Lockit, has considered many possible independent variables and equations to predict sales and has narrowed his choices to four equations. Husky used annual observations from 20 prior years to estimate each of the four equations. Following are definitions of the variables used in the four equations and a statistical summary of these equations: St=ForecastedsalesindollarsforLockitinperiodtSt1=ActualsalesindollarsforLockitinperiodt1Gt=ForecastedU.S.grossdomesticproductinperiodtGt1=ActualU.S.grossdomesticproductinperiodt1Nt1=Lockitsnetincomeinperiodt1 Required: 1. Write Equations 2 and 4 in the form Y = a + bx. 2. If actual sales are 1,500,000 in the current year, what would be the forecasted sales for Lockit in the coming year? 3. Explain why Larry Husky might prefer Equation 3 to Equation 2. 4. Explain the advantages and disadvantages of using Equation 4 to forecast sales.arrow_forward
- The management of Brinkley Corporation is interested in using simulation to estimate the profit per unit for a new product. The selling price for the product will be $45 per unit. Probability distributions for the purchase cost, the labor cost, and the transportation cost are estimated as follows: ProcurementCost ($) Probability LaborCost ($) Probability TransportationCost ($) Probability 10 0.2 18 0.25 2 0.74 12 0.35 20 0.35 5 0.26 13 0.45 22 0.1 25 0.3 Compute profit per unit for the base-case, worst-case, and best-case scenarios.Profit per unit for the base-case: $ fill in the blank 1Profit per unit for the worst-case: $ fill in the blank 2Profit per unit for the best-case: $ fill in the blank 3 Construct a simulation model to estimate the mean profit per unit. If required, round your answer to the nearest cent.Mean profit per unit = $ fill in the blank 4 Why is the simulation approach to risk analysis preferable to generating a variety of…arrow_forwardWhat is the basic difference between a master budget and a flexible budget? Master budget is for five year period and flexible budget is for one year period. Master budget is on financial terms and flexible budget is on quantitative terms. Master budget is for specific capacity and flexible budget is for multiple capacity. Master budget is prepared on actuals and flexible budget is based on standards. Submit You have used 0 of 2 Save attemptsarrow_forwardQ.Calculate all the required variances. (If your work is accurate, you will find that the total static-budget variance is $0.)arrow_forward
- LO.8 (Appendix; Least squares regression) UpTop Mining has compiled the follcowing data to analyze utilitry costs: Month Machine Hours Utility cost January 200 $300 February 325 440 March 400 480 April 410 490 May 525 620 June 680 790 July 820 840 August 900 900 Use the least squares method to develop a formula for budgeting utility cost.arrow_forwardK Juda Recliners manufactures leather recliners and uses flexible budgeting and a standard cost system. Juda allocates overhead based on yards of direct materials. The company's performance report includes the following selected data: Data table X Sales Static Budget Actual Results (1,025 recliners) (1,005 recliners) (1,025 recliners x $515 each) (1,005 recliners x $480 each) $ 527 875 S 482 400 Variable Manufacturing Costs: Direct Materials (6,150 yds @ $8.90/ yd.) (6,300 yds @ $8.707 yd.) 54.735 54.810 Direct Labor (10,250 DLHr @ $11.30/DLHr) (9,850 DLHr @ $11.40/DLHr) 115 825 112 290 Variable Overhead (6,150 yds @ $5.107 yd.) 31,365 (6,300 yds. @$6.50/yd.) 40.950 Fixed Manufacturing Costs: Fixed Overhead Total Cost of Goods Sold 62,730 64,730 264,655 272,780 263,220 $ 209,620 Gross Profitarrow_forwardRefer to Cornerstone Exercise 3.4 for data on Dohini Manufacturing Company’s purchasing cost and number of purchase orders.The controller for Dohini Manufacturing ran regression on the data, and the coefficients shown by the regression program are: Intercept 15,021 (rounded to the nearest dollar)X variable 1 9.74 (rounded to the nearest cent) Required: 1. Construct the cost formula for the purchasing activity showing the fixed cost and the vari-able rate. 2. If Dohini Manufacturing Company estimates that next month will have 430 purchaseorders, what is the total estimated purchasing cost for that month? (Round your answer tothe nearest dollar.)3. What if Dohini Manufacturing wants to estimate purchasing cost for the coming year andexpects 5,340 purchase orders? What will estimated total purchasing cost be? (Round youranswer to the nearest dollar.) What is the total fixed purchasing cost? Why doesn’t it equalthe fixed cost calculated in Requirement 1?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 LearningEssentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningPrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher: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
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
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
What is variance analysis?; Author: Corporate finance institute;https://www.youtube.com/watch?v=SMTa1lZu7Qw;License: Standard YouTube License, CC-BY