Refer to the data in Exercise 3.26. Data in Exercise 3.26 Required: 1. Construct an Excel spreadsheet

Question:

Refer to the data in Exercise 3.26.

Data in Exercise 3.26

Utilities cost Month Machine hours $35 100 52 500 January 33 150 February 31 500 33 000 March 33 000 33 675 April 36 000

Required:
1. Construct an Excel spreadsheet to estimate the company's utilities cost behaviour.
2. Provide an assessment of the explanatory power of this equation (using the equation and other statistics).

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For book-img-for-question

Management Accounting

ISBN: 9781760421144

7th Edition

Authors: Kim Langfield Smith, Helen Thorne, David Alan Smith, Ronald W. Hilton

See More Books

Question Posted: Nov 01, 2017 05:31 AM

See More Questions

Refer to the data in Exercise 32 for the Halifax General Hospital. In exercise Required: 1. Using the highlow method, estimate the fixed cost of admitting patients per month and the variable cost of...
Refer to the data in Exercise 113. Assume that Vancouvers sales by major market are as follows: In Exercise The company would like to initiate an intensive advertising campaign in one of the two...
Refer to the data in Exercise 6-16. Assume that Minneapolis' sales by major market Data in Exercise 6-16 The company would like to initiate an intensive advertising campaign in one of the two market...
Carter Co. has a value of $80 million. Buleigh is otherwise identical to Carter Co., but has $32 million in debt. Suppose that both firms are growing at a rate of 5%, the corporate tax rate is 38%,...
Explain why this compound gives about 50%syn elimination whenheated: N(CH3)3
Why is it that a lawyer cannot bill the client for everything the lawyer does? What kinds of acts would qualify as being nonbillable?
Based on Jamie Lees current financial situation, could she possibly make the balance transfer option work?
Discuss each of the four fundamental issues for potential conflict during the project formation stage.
The shareholders' equity section of the balance sheet of TNL Systems Incorporated included the following accounts at December 3 1 , 2 0 2 3 : Shareholders' Equity Common stock, 2 7 0 million shares...
Efficiently implement a stack class using a singly linked list, with no header or tail nodes.
Daisy Wong is the accountant for the Heavy Manufacturing Company. She has been asked by one of Heavy's senior managers to provide an estimate of the firm's utilities costs using the high-low method....
Plasma Pathology has incurred the following costs in its diagnostic blood laboratory during the past 12 months: Required: 1. Use regression analysis to estimate the variable cost per blood test and...
What are the basic tenets of positive psychology? How can this area of research enhance our knowledge of adult development? Based on the principles of this research what are some strategies that you...
Some people jump at the chance to be a change agent while others run from the role. Why is this the case? What are some characteristics of successful change agentry? These factors should refer to the...
An S corporation with $50,000 of earnings and profits owns rental real estate and has interest income producing investments. For the last two years, 50% of its gross receipts came from passive...
How has Biden Lowered premiums and out of pocket costs for millions of Americans?
Product costs using activity rates Body-Solid Inc. manufactures elliptical exercise machines and treadmills. The products are prouced in its Fabrication and Assembly production departments. In...
How to start an essay on the multigenerational workforce and your experiences working with each of the generations. Begin your essay with an introduction that outlines the current generations in the...
It is sometimes suggested that the most equitable way to resolve issues in international trade agreements would be for all countries to adopt the same emission standards. What are the pros and cons...
Tanaka Company's cost and production data for two recent months included the following: March April Production (units).........300................600 Rent.....................$1,800............$1,800...
Tenneco, Inc., produces three models of tennis rackets: standard, deluxe, and pro. Following are the sales and cost information for 2011: Fixed manufacturing support costs are $800,000, and fixed...
The following information pertains to Torasic Companys budgeted income statement for the month of June 2011: Sales (1,200 units at $250) $300,000 Variable cost 150,000 Contribution margin $150,000...
Breakeven point, what-if analysis Air Peanut Company manufactures and sells roasted peanut packets to commercial airlines. Following are the price and cost data per 100 packets of peanuts:...
thumbs up if correct A stock paying no dividends is priced at $154. Over the next 3-months you expect the stock torpeither be up 10% or down 10%. The risk-free rate is 1% per annum compounded...
Question 17 2 pts Activities between affiliated entities, such as a company and its management, must be disclosed in the financial statements of a corporation as O significant relationships O segment...
Marchetti Company, a U.S.-based importer of wines and spirits, placed an order with a French supplier for 1,000 cases of wine at a price of 200 euros per case. The total purchase price is 200,000...

Refer to the data in Exercise 3.26. Data in Exercise 3.26 Required: 1. Construct an Excel spreadsheet

Question:

Utilities cost Month Machine hours $35 100 52 500 January 33 150 February 31 500 33 000 March 33 000 33 675 April 36 000 34 350 May 45 000 35 025 June 48 000 42 000 July 60 000 34 200 August 45 000 34 500 September 45 000 34 050 October 42 000 36 150 November 61 500 37 425 December 58 500

Step by Step Answer:

1 The calculations to estimate the companys utilities cost behaviour are shown below using Excel Som...View the full answer

Management Accounting

Students also viewed these Advanced Accounting questions