Wayne Mueller, financial analyst at CELL Corporation, is examining the behav-ior of quarterly utility costs for budgeting purposes. Mueller collects the following data on machine-hoursworked and utility costs for the past 8 quarters:Utility Costs$215,000QuarterMachine-Hours120,000150,000200,000270,000170,000250,000225,000195,000275,000110,000150,00090,000140,000130,000345100,0001. Estimate the cost function for the quarterly data using the high-low method.2. Plot and comment on the estimated cost function.3. Mueller anticipates that CELL will operate machines for 125,000 hours in quarter 9. Calculate the pre-dicted utility costs in quarter 9 using the cost function estimated in requirement 1.

Answered: Wayne Mueller, financial analyst at…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

[The following information applies to the questions displayed below.] Adger Corporation is a service company that measures its output based on the number of customers served. The company provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results for May as shown below: Revenue Employee salaries and wages Travel expenses Other expenses Fixed Element per Month $ 59,000 Revenue variance $ 38,000 Variable Element per Customer Served $ 5,500 $2,000 $ 510 Actual Total for May $ 204,000 $ 137,900 $ 17,500 $36,200 When preparing its planning budget the company estimated that it would serve 35 customers per month; however, during May the company actually served 40 customers. 6. What is Adger's revenue variance for May? Note: Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.
Click Draperies makes and sells curtains. Information related to its performance in 2020 is given below: (Click the icon to view the data.) Calculate Click Draperies' flexible budget for (a) revenues, (b) variable costs, (c) fixed costs, and (d) operating income. Calculate Click's flexible budget for (a) revenues. Begin by determining the formula and then solve for the amount. Actual units sold 1,560 X Budgeted selling price per unit = Flexible budget for revenues × $ 361,920 232 Calculate Click's flexible budget for (b) variable costs. Begin by determining the formula and then solve for the amount. Actual units sold 1,560 X Budgeted variable cost per unit × $ 108 = Calculate Click's flexible budget for (c) fixed costs. Click's flexible budget for fixed costs is $ 73,000. = = Flexible budget for variable costs 168,480 Calculate Click's flexible budget for (d) operating income. Begin by determining the formula and then solve for the amount. (Abbreviations used: rev = revenue, vc =…
Nathan Davidson, financial analyst at LMN Corporation, is examining the behavior of quarterly utility costs for budgeting purposes. Davidson collects the following data on machine-hours worked and utility costs for the past 8 quarters: (Click the icon to view the data.) Read the requirements. Requirement 1. Estimate the cost function for the quarterly data using the high-low method. (Complete all answer boxes.) Data table + Quarter Machine-Hours Utility Costs Quarter 1 100,000 $ 265,000 Quarter 2 55,000 200,000 Quarter 3 90,000 250,000 Quarter 4 105,000 280,000 Quarter 5 70,000 220,000 Quarter 6 95,000 260,000 Quarter 7 85,000 275,000 Quarter 8 80,000 245,000 Print Done - ☑ Requirements 1. Estimate the cost function for the quarterly data using the high-low method. 2. Plot and comment on the estimated cost function. 3. Davidson anticipates that LMN will operate machines for 105,000 hours in quarter 9. Calculate the predicted utility costs in quarter 9 using the cost function estimated…
Smile Company makes baked goods. The budgeted sales are $620,000, budgeted variable costs are $260,400, and budgeted fixed costs are $237,800. What is the budgeted operating income?
During the current year, Cullumber Corporation expects to produce 10,000 units and has budgeted the following: net income $350,000; variable costs $1,290,000; and fixed costs $110,000. It has invested assets of $1,650,000. What was the company's budgeted ROI? What was its budgeted markup percentage using a total cost approach? Budgeted ROI per unit Budgeted markup percentage $ %
As a newly hired management accountant, you have been asked to prepare a profit plan for the company for which you work. As part of this task, you've been asked to do some what-if analyses. Following is the budgeted Information regarding the coming year: Selling price per unit Variable cost per unit Fixed costs (per year) Required: $ 100.00 60.00 1,113,040 1. What is the breakeven volume, in units and dollars, for the coming year? 2. Assume that the goal of the company is to earn a pretax (operating) profit of $316,000 for the coming year. How many units would the company have to sell to achieve this goal? 3. Assume that of the $60 variable cost per unit the labor-cost component is $27. Current negotiations with the employees of the company indicate some uncertainty regarding the labor cost component of the variable cost figure presented above. What is the effect on the breakeven point in units if selling price and fixed costs are as planned, but the labor cost for the coming year is…
Summer Corporation is an oil well service company that measures its output by the number of wells serviced. The company has provided the following fixed and variable cost estimates that it uses for budgeting purposes. Revenue Employee salaries and wages Servicing materials Other expenses O $87,000 $88,750 Fixed Element per Month O $90,650 O $89,888 S 57,400 S 35,400 When the company prepared its planning budget at the beginning of December, it assumed that 35 wells would have been serviced. However, 33 wells were actually serviced during December. The "Employee salaries and wages" in the flexible budget for December would have been closest to: Variable Element per Well Serviced. S S 4,500 950 700
Using the table , determine whether there is a cumulative cost overrun or underrun by the following months: Month 2 Month 6
Gayner Corporation is an oil well service company that measures its output by the number of wells serviced. The company has provided the following fixed and variable cost estimates that it uses for budgeting purposes and the actual results of operations for November. Variable Actual Fixed Element Element per Total for per Month November Well Serviced 4,300 $ 148,400 Revenue Employee salaries and 1,000 $ 006 wages 009 2$ 20,200 Servicing materials $29,600 30,300 Other expenses When the company prepared its planning budget at the beginning of November, it assumed that 30 wells would have been serviced. However, 34 wells were actually serviced during November. The spending variance for "Servicing materials" for November would have been closest to: MacBook Air い DD 888 delete 8. 6 9 %24 %24 %24 %24 %24
The following data get out from Samsung industrial company: Direct materials costs JD 75 Direct manufacturing labor costs 20 Variable manufacturing overhead costs 15 Fixed overhead costs 28 Each TV need to 0.75 hour, and each hour by JD 31.5. The number of units manufactured is the cost driver for direct materials, direct manufacturing labor, and variable manufacturing overhead. The relevant range for the cost driver is from 0 to 6,000 TV. Budgeted and actual data for November 2019 are: Budgeted fixed costs for production JD 141, 750 Budgeted selling price JD 138 per unit Actual selling price 152.75 per unit Revenue at budgeted…

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS